I would first suggest you export to csv (even a blank table) and then you will know the headers you need for your file.
On Tuesday, July 21, 2015 at 12:07:34 AM UTC-7, Yebach wrote: > > Hello > > I would like to import csv file into a database table - user imports > > how do you recommend to do it. I guess telling users to set the column > names matching the headers in CSV but how do i match them after for import. > I also have to add two fields with user id and another one that is based > on user id to be inserted > > > My table is > > CREATE TABLE workers > ( > id serial NOT NULL, > w_organisation integer, > w_user integer, > w_status integer, > w_first_name character varying(32), > w_last_name character varying(32), > w_nick_name character varying(32), > w_email character varying(64), > w_note text, > CONSTRAINT workers_pkey PRIMARY KEY (id) > > ) > > > I am strugling with import function > > Please help i need this fast > > Thank you > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
