Hello Joe,
I do not have an answer. I do not have the ability to edit posts therefore
I assume none of the other managers has that ability either.
I have found some strange behavior with google groups, for example some
posts (including mine) have disappeared.
In particular I responded to your last posts and commented that web2py
expects CSV in the Excel format and escaped strings are supposed to be
double quoted, not single quoted. This post somehow never appeared but
googlegroup told me it was posted.
Massimo
On Saturday, 5 January 2013 10:57:16 UTC-6, JoeCodeswell wrote:
>
> 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
>>>>>>>
>>>>>>>
--
