I forgot to saay that I have an sqlformgrid in whoch i am importing
On Jul 22, 2015 1:43 AM, "Derek" <sp1d...@gmail.com> wrote:

> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/FhgWebuuk4o/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.

Reply via email to