Nevermind, I went for the XML approach and I got it working now :) On Thursday, February 13, 2014 11:08:04 PM UTC+1, Ruud Schroen wrote: > > Hi, > > I'm currently working with an affiliate program from Daisycon. > They offer productfeeds in the form of XML, XML attributes and CSV. I went > for the CSV because it's easier to import. > > There's only one problem. > > When I look at an exported csv file in a basic texteditor, it looks like > this: > > supplier.name >>> ,supplier.full_name,supplier.address,supplier.zip,supplier.city,supplier.phone,supplier.email >> >> Naam,Full name,Postbus 9034,3007 AA,Rotterdam,<NULL>,[email protected] >> >> > But the CSV files from Daisycon look like this: > > "supplier.name >> ";"supplier.full_name";"supplier.address";"supplier.zip";"supplier.city";"supplier.phone";"supplier.email" > > "Naam";"Full name";"Postbus 9034";"3007 AA";"Rotterdam";"<NULL>";" >> [email protected]" > > > (These are not the actual CSV files btw, just an example) > > Basically all field names and data in the second CSV file are surrounded > by "" and seperated by ; > *I'm not sure if this actually causes the problem*, but when I import the > csv file, it adds the right amount of entries, but all fields of every > entry contain *None* > My model contains the same fields as the CSV file, in the right order, > with the right name. > > Can anyone help me with this please? It's really urgent! >
-- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
