How to import CSV into SQL (gadfly)?
Hi all, I have three CSV tables (together 120k) and I need import that data into some SQL database for different kind of views to data strored in tables. Because Gadfly is enough for that amount of data and I does not have installed any other SQL at production machine, I want to import CSV into gadfly. I was search over net, but does not find something usefull. Or it is possible to use TinyTables or something similar with power of SQL commands for that table structure? CREATE TABLE katalog ( poradi integer, kod_dest varchar, ... ) CREATE TABLE dest ( kod_dest varchar, ... ) CREATE TABLE pok ( poradi integer, kod_dest varchar, ... ) Do you have somebody experience or tips how to do that? Many thanks, -- Jaroslav Lukesh
Jaroslav Lukesh wrote:
I have three CSV tables (together 120k) and I need import that data into some SQL database for different kind of views to data strored in tables.
I guess you could use the Python csv module to import the data and then pass it to a couple of zsql methods. http://www.python.org/doc/2.3.2/lib/module-csv.html /Anton Stonor
Anton Stonor wrote:
Jaroslav Lukesh wrote:
I have three CSV tables (together 120k) and I need import that data into some SQL database for different kind of views to data strored in tables.
I guess you could use the Python csv module to import the data and then pass it to a couple of zsql methods.
Thank you very much, I will run latest python with latest zope :o) and then export&import+copy DB files to my old zopes. -- Jaroslav Lukeš
participants (2)
-
Anton Stonor -
Jaroslav Lukesh