Tuesday 09 September 2003 10:22:50 am
I think you need to think about your end aim here and work out the necessary steps. For example, take a look at creating an ez class and determine whether your data can be modelled in the way you need it to be. If you can create a class with attributes that matches the structure of your data then all you need to do is create the ez objects. This is, as you might guess, a little more difficult to do. You mention csv data so i assume you have a way of exporting your oracle fields into a handle text file. Paul mentioned using webdav, which is new in 3.2. You could use that to 'drop' in files, which will create the correct objects (for the files mime type) in the database. For that you may need to alter the webdav code a little to match the type for your class. However a little script to read your csv file, and create the objects inside ez looks like the best way to go. I've worked on similar things, its just a matter of finding what function calls to use.
Paul
|