Ok you can do:
colnames = ['field1','field2',etc.]
for lines in import_data:
items = lines.split(',')
db[csv_data].insert(**dict((colnames[i],v) for i,v in enumerate(items)))
It may still fail of the data is not in the right format but you can find
out why.
On Wednesday, 3 April 2013 16:40:01 UTC-5, David S wrote:
>
> I'm very new to web2py and python in general but have a bit of knowledge
> when it comes to C/C++.
>
> I've got a db setup which needs to pull data from a row in a .csv file and
> put each column in the .csv into the corresponding column in the db. Rather
> than doing this explicitly (there's ~40 columns), I'd like to have each
> iteration of the for loop correspond to one of the columns. Here's what
> I've got so far:
>
> for lines in import_data:
> info = lines.split(',')
> field_name = 'field1'
> db[csv_data].insert(**{field_name:info})
>
> The above puts all the data in 'field1' and not into separate columns,
> close but not quite. I'm thinking some sort of select from the db might
> work. Any ideas or links which might help?
>
> Thanks,
> David
>
--
---
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
