Re: Character sets and CSV report file downloads
Hi Reed, A quick followup - I tried running reports against a test account with Chinese ads yesterday and noticed that CSV report format is actually encoded in UTF-8. So if your program were UTF-8 aware, then the data wouldn't be mangled when you read it. Excel does not recognize the UTF-8 csv file format, it expects csv files to be ascii encoded, and hence displays mangled characters when you open the downloaded csv in excel. That's a different issue, and is not due to report contents encoded incorrectly. Cheers, Anash P. Oommen, AdWords API Advisor. On Jan 18, 12:06 pm, AdWords API Advisor adwordsapiadvi...@google.com wrote: Hi Reed, I've opened issues with the AdWords team for both the cases you reported. I'll update you once I hear from them. Cheers, Anash P. Oommen, AdWords API Advisor. On Jan 14, 6:01 pm, Reed r...@powellgenealogy.com wrote: This problem just gets stranger and stranger. I think I found a solution - if I specify CSVFOREXCEL as the report format instead of CSV, then I get a double-byte file that Excel opens and shows the correct Chinese characters. BUT - the file is tab-delimited, not comma delimited, despite the format being CSVFOREXCEL. ?? -reed -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: Character sets and CSV report file downloads
Hi Reed, I've opened issues with the AdWords team for both the cases you reported. I'll update you once I hear from them. Cheers, Anash P. Oommen, AdWords API Advisor. On Jan 14, 6:01 pm, Reed r...@powellgenealogy.com wrote: This problem just gets stranger and stranger. I think I found a solution - if I specify CSVFOREXCEL as the report format instead of CSV, then I get a double-byte file that Excel opens and shows the correct Chinese characters. BUT - the file is tab-delimited, not comma delimited, despite the format being CSVFOREXCEL. ?? -reed -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: Character sets and CSV report file downloads
This problem just gets stranger and stranger. I think I found a solution - if I specify CSVFOREXCEL as the report format instead of CSV, then I get a double-byte file that Excel opens and shows the correct Chinese characters. BUT - the file is tab-delimited, not comma delimited, despite the format being CSVFOREXCEL. ?? -reed -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: Character sets and CSV report file downloads
The report ID is 60440936 - I have sent a sample file to the private email address. thanks Reed -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: Character sets and CSV report file downloads
More details. Below are the http headers from AdWords and from Baidu for pulling CSV files via http GET that have Chinese characters in them. Note that AdWords forces the character set to UTF-8, where Baidu doesn't specify it. I think this is pertinent, because I can tell Java what character set to interpret the data as for the Baidu download, and that seems to work. But it is also important to remember that the only character set the Baidu API has to deal with is for Chinese characters, whereas AdWords has to deal with all character sets. As we start pulling other non-Latin character set performance data in CSV format files, this is going to become an important need. Adwords: HTTP/1.1 200 OK Content-Disposition: attachment; filename=Keyword Perf Rpt Without Conversions.csv Connection: close Expires: Fri, 01 Jan 1990 00:00:00 GMT Date: Thu, 13 Jan 2011 18:38:06 GMT Server: GSE X-Frame-Options: SAMEORIGIN Pragma: no-cache Cache-Control: no-cache, no-store, max-age=0, must-revalidate X-XSS-Protection: 1; mode=block Content-Type: text/csv; charset=UTF-8 X-Content-Type-Options: nosniff Baidu: HTTP/1.1 200 OK Content-Disposition: attachment; filename=20110113-190532.csv Connection: close Accept-Ranges: bytes Date: Thu, 13 Jan 2011 11:15:21 GMT Server: Apache Content-Length: 27308 ETag: 1ed4076-6aac-499b84bd31700 Last-Modified: Thu, 13 Jan 2011 11:05:32 GMT Content-Type: text/csv Hope this helps narrow things down, -reed -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
