Dear Massimo,
Thanks for the reply.
Strange behavior indeed. O well. At least we all as individuals seem
communicate on this group clearly and respectfully.
Thanks for your leadership, Massimo.
Love and peace,
Joe.
On Saturday, January 5, 2013 4:50:04 PM UTC-8, Massimo Di Pierro wrote:
>
> 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
>>>>>>>>
>>>>>>>>
--
