[web2py] Re: Possible bug: DAL csv import unable to parse csv file near ): syntax error BUT NO ) in thefile
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'
[web2py] Re: Possible bug: DAL csv import unable to parse csv file near ): syntax error BUT NO ) in thefile
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] Re: Possible bug: DAL csv import unable to parse csv file near ): syntax error BUT NO ) in thefile
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 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 --
[web2py] Re: Possible bug: DAL csv import unable to parse csv file near ): syntax error BUT NO ) in thefile
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
[web2py] Re: Possible bug: DAL csv import unable to parse csv file near ): syntax error BUT NO ) in thefile
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 --
[web2py] Re: Possible bug: DAL csv import unable to parse csv file near ): syntax error BUT NO ) in thefile
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 --
[web2py] Re: Possible bug: DAL csv import unable to parse csv file near ): syntax error BUT NO ) in thefile
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 --
[web2py] Re: Possible bug: DAL csv import unable to parse csv file near ): syntax error BUT NO ) in thefile
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 --
[web2py] Re: Possible bug: DAL csv import unable to parse csv file near ): syntax error BUT NO ) in thefile
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 --