Dear Massimo,
You asked:
> What's the difference between the two?
*
*
*Answer:
*
*Double quotes* on the one that *worked*.
*Single quotes* on the one that *didn't work*.
Love and peace,
Joe
On Friday, January 4, 2013 4:54:01 PM UTC-8, Massimo Di Pierro wrote:
>
> What's the difference between the two?
>
> On Friday, 4 January 2013 13:36:25 UTC-6, JoeCodeswell wrote:
>>
>> Hi Derek,
>>
>> Thanks for the reply. I just tried these 2 csv's:
>> 'iso','name','printable_name','iso3','numcode'
>> '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'
>>
>> RESULT:
>> unable to parse csv file
>> near ")": syntax error
>>
>> AND
>>
>> "iso","name","printable_name","iso3","numcode"
>> "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"
>>
>> RESULT:
>> data uploaded
>> Thanks for the help, Derek.
>>
>> Love and peace,
>> Joe
>>
>> On Friday, January 4, 2013 11:17:41 AM UTC-8, Derek wrote:
>>>
>>> You need to have the column names in the first line of the csv.
>>>
>>> On Friday, January 4, 2013 10:30:08 AM UTC-7, JoeCodeswell wrote:
>>>>
>>>> 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
>>>>>
>>>>>
--
