This is a meta-comment regarding the behavior of this group.
Last night, when i was answering Massimo's question, i noticed that my post
that Massimo was asking about [Jan 4 Hi Derek, ...] showed a* blank
line*between the
*title item* and the beginning of the *data items* *for each *csv.
I don't remember putting those blank lines in. I checked the files from
which i copied and pasted and they don't have blank lines either. I don't
know how those blank lines got in there.
ALSO if you click "show quoted text" on my answer to Massimo, you will see
the way i originally made the post Massimo was asking about. It DOES NOT
SHOW THOSE BLANK LINES.
Here is how it looked originally. I hope this doesn't change.
===== begin =====
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
===== end =====
Was my post edited somehow? I don't know how to edit a post once it has
been posted. Very Strange.
I hope one of the web2py group managers can clear this up for me.
Thanks for the help in advance.
Love and peace,
Joe
On Friday, January 4, 2013 9:01:58 PM UTC-8, JoeCodeswell wrote:
>
> 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
>>>>>>
>>>>>>
--
