i am using Version 2.3.2 (2012-12-17 15:03:30) stable
sorry for no mentioning that before.
Love and peace,
Joe
On Friday, January 4, 2013 9:14:53 AM UTC-8, JoeCodeswell wrote:
>
> Dear web2py,
>
> I am working my way thru the ajax-live-search-auto-complete web2pyslice.
> Instead of using inserts, i thought i'd use csv to populate the db. When i
> upload, I get an error flash that says:
>
>> "unable to parse csv file
>
> near ")": syntax error"
>
>
> BUT THERE'S NO ")" right parenthesis in the csv. Is this a bug?
>
> Here's the model:
> db.define_table('country',
> Field('iso'),
> Field('name'),
> Field('printable_name'),
> Field('iso3'),
> Field('numcode'))
>
> Here's the csv:
> 'UY','URUGUAY','Uruguay','URY','858'
> 'UZ','UZBEKISTAN','Uzbekistan','UZB','860'
> 'VU','VANUATU','Vanuatu','VUT','548'
> 'VE','VENEZUELA','Venezuela','VEN','862'
> 'VN','VIET NAM','Viet Nam','VNM','704'
> 'VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB','092'
> 'VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.s.','VIR','850'
> 'WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF','876'
> 'EH','WESTERN SAHARA','Western Sahara','ESH','732'
> 'YE','YEMEN','Yemen','YEM','887'
> 'ZM','ZAMBIA','Zambia','ZMB','894'
> 'ZW','ZIMBABWE','Zimbabwe','ZWE','716'
>
>
> This all looks OK to me.
>
> Thanks for the help in advance.
>
> Love and peace,
> Joe
>
>
--
