After every Extract Table command is executed, you can use System Variable command, $Table Column(index)$ to extract the row data of the Table.Insert Database commands to connect and insert the Tabular data extracted from the web into the database.
--------------------
oliviaharis
http://www.drivenwide.com
XML is generally more robust. For example if any fields contain newlines, that may well cause a problem with csv files because a newline indicates the end of a record. XML handles this with no problem. Also if you have extended characters outside the normal Latin-1 set, XML will handle that. Or binary data, and so on and so on.
But if the data is straightforward go with CSV with a song in your heart.
bms
23 September 2008 05:04am
After every Extract Table command is executed, you can use System Variable command, $Table Column(index)$ to extract the row data of the Table.Insert Database commands to connect and insert the Tabular data extracted from the web into the database.
--------------------
oliviaharis
http://www.drivenwide.com
Retired at Retired
23 September 2008 10:45am
XML is generally more robust. For example if any fields contain newlines, that may well cause a problem with csv files because a newline indicates the end of a record. XML handles this with no problem. Also if you have extended characters outside the normal Latin-1 set, XML will handle that. Or binary data, and so on and so on.
But if the data is straightforward go with CSV with a song in your heart.
Senior marketing officer - online at MyScience.co Ltd
23 September 2008 20:37pm
Thanks Textor,
This all makes me a bit more comfortable with how we proceed and that the plans won't be shot down by the technology
John