Another Revolution Success Story

[Pierre Sahores]

Oh là là, comme on dit chez nous... What's an usefull stuff, Xavier. 
Can spend time in test and debug, if that can help ;)

Le 29 juin 04, à 06:11, MisterX a écrit :

> I wrote one to import an excel made csv.
> There was no published format that I could find though...
>
> It is a "bit" unfinished (about 5% missing) in the
> translation matrix...
>
> I'll polish it today and try to fix the errors, try to
> find the source of the data to put in the proper credits.
> The database contains a few thousands NT events errors and
> codes reference.
>
> cheers
> Xavier
>
>
>> -----Original Message-----
>> From: use-revolution-bounces at lists.runrev.com
>> [mailto:use-revolution-bounces at lists.runrev.com]On Behalf Of Alex
>> Tweedly
>> Sent: Tuesday, June 29, 2004 03:51
>> To: use-revolution at lists.runrev.com
>> Subject: Re: Another Revolution Success Story
>>
>>
>> At 18:02 28/06/2004 -0400, Troy Rollins wrote:
>>
>>
>>> On Jun 28, 2004, at 5:40 PM, Kurt Kaufman wrote:
>>>
>>>> A physician in our area had a need for an application which
>> could easily
>>>> import patient data from a text file (multiple rows of 
>>>> comma-delineated
>>>> data).  It was a simple task, using Revolution, to open the
>> file and read
>>>> the data to a field.  Subsequently a "model" card was cloned and the
>>>> appropriate data sent to various fields on each card. Over a 
>>>> thousand
>>>> records were created this way in a few minutes.The only stumbling 
>>>> block
>>>> involved my forgetting that a standalone cannot modify itself.
>> No matter
>>>> though; I merely created an invisible "starter app" that immediately
>>>> opened a data stack in the data folder.
>>>> The application works "as advertised".
>>>> The doctor was impressed that it was possible to do this in a few 
>>>> hours!
>>>
>>> String handling apps DO seem to be Rev's forte.
>>
>> yes, string handling is pretty good - but I'm surprised that Rev has 
>> no
>> built-in support for CSV files. They are a pretty common interchange
>> format, but handling the variations commonly found makes it
>> non-trivial to
>> do this properly - quoted fields, delimiter in quoted fields, escaped 
>> or
>> doubled quotes within a field, etc.
>>
>> Has anyone written and contributed a library to avoid others having to
>> "roll-your-own" ?
>>
>> (*) - I should probably say "appears to have no built-in support" - 
>> there
>> may be something that I just can't find in the docs.
>>
>>
>> -- Alex.
>>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
-- 
Bien cordialement, Pierre Sahores

100, rue de Paris
F - 77140 Nemours

psahores+ at +easynet.fr

GSM:   +33 6 03 95 77 70
Pro:      +33 1 41 60 52 68
Dom:    +33 1 64 45 05 33
Fax:      +33 1 64 45 05 33

Inspection académique de Seine-Saint-Denis
Applications et SGBD ACID SQL (WEB et PGI)
Penser et produire "delta de productivité"