Importing data into RevDB

Björnke von Gierke bvg at mac.com
Fri Dec 4 16:34:58 EST 2009


normally, csv is a pain in the ass, but Rev tokens trump that ;)

you can set the linedelimiter to comma, and the itemdelimter to quote.  
then you could do something similar to this (great for not having to  
make special cases for the particular field being empty, lacking  
quotes, etc.):

set the linedelimiter to comma
set the itemdelimiter to quote
repeat for each line theLine in theCSV
   put item 1 to -1 of line theLine into theData
   --do stuff with data here
end repeat




On 4 Dec 2009, at 21:46, David Coker wrote:

> Hello folks,
> I'm in the planning stages of a possible new app which will include  
> populating a Rev Database (SQLite) primarily from a standard Excel  
> based CSV file. What I've run into while doing some research is that  
> that format seems leaves a lot to be desired. It seems that the CSV  
> data that I'll be working with has all kinds of spurious line breaks  
> and such embedded, so converting to a tab delimited format doesn't  
> work well.
>
> Does anyone have any suggestions as to how to make something like  
> this reliable as far as maintaining record integrity during import?
>
> Best regards,
> David C.
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution




More information about the Use-livecode mailing list