[web2py] Re: csv import export

2013-04-19 Thread Reza Shah
I just found out there was a mistake in the csv file i used when importing. The problem was i open the csv exported from admin in libreoffice, but i didnot notice that the separator converted to tab. -- --- You received this message because you are subscribed to the Google Groups "web2py-user

Re: [web2py] Re: CSV Import/Export from different tables

2012-02-07 Thread Richard Vézina
Your are welcome! Richard On Tue, Feb 7, 2012 at 5:46 PM, Omi Chiba wrote: > Thank you, Richard ! > I came up the same idea using excutesql and it's done in a seconds !! > > db.executesql('INSERT INTO request (subject, result) SELECT subject, > result FROM result;') > * my database is db2 > > >

[web2py] Re: CSV Import/Export from different tables

2012-02-07 Thread Omi Chiba
Thank you, Richard ! I came up the same idea using excutesql and it's done in a seconds !! db.executesql('INSERT INTO request (subject, result) SELECT subject, result FROM result;') * my database is db2 > In your case you need input of user so you need to import from CSV... But I > don't see why

Re: [web2py] Re: CSV Import/Export from different tables

2012-02-07 Thread Richard Vézina
I was think of something like this... INSERT INTO dict_table (table_name) SELECT relname FROM pg_class WHERE relnamespace='2200' AND relname LIKE 'test_%' AND relname NOT LIKE '%_id_seq' That could be write in raw SQL or with web2py request syntax In your case you need input of user so you need

[web2py] Re: CSV Import/Export from different tables

2012-02-07 Thread Omi Chiba
I think my case is the former. Like Sales support team prepare the reply for the open request at the end of the day and upload. In the evening, I have scheduled job on my AS400 do the upgrade from result to request table with other information. Insert each rows takes long time compared to update o