Re: Tab separated text input
Re: Tab separated text input
- Subject: Re: Tab separated text input
- From: Catherine Ferris <email@hidden>
- Date: Sat, 16 Apr 2005 10:33:10 +0100
Hi Florijan,
You may want to look at the following :
xlSQL Excel JDBC Driver : http://sourceforge.net/projects/xlsql
StelsCSV : http://www.csv-jdbc.com/
CsvJDBC : http://sourceforge.net/projects/csvjdbc/
In theory you can use these drivers to treat a CSV file as a RDBMS, and then use EOs on access the data.
No practical experience from my side in doing this with WO, just thought it may be possible or at least give you a jump start.
Catherine Ferris
e-mail: email@hidden
On 15 Apr 2005, at 13:20, Florijan Stamenkovic wrote:
Hi guys...
I searched the lists and Apple and WOCode for some examples or knowledge on this, but found nothing.
What I would need to do is enable cross-platform tab (or comma or whatever) separated text input. I need to:
1. Read the file and separate elements
2. Parse the elements into proper formats (number for example)
3. Search my data for EOs according to names given in the text file
4. Create EOs and relate them to a couple other tables according to the searches from step 3
5. Verify and save...
...and it seems a process that is one big pitfall by itself. Anybody has any experience with this or shareable code (parsing) or advice or whatever???
Thanks
Florijan
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden