Re: Character sets and CSV report file downloads

2011-01-18 Thread AdWords API Advisor
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 fi

Re: Character sets and CSV report file downloads

2011-01-17 Thread AdWords API Advisor
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 wrote: > This problem just gets stranger and stranger.  I think I found a > "solution" - if I specify

Re: Character sets and CSV report file downloads

2011-01-14 Thread Reed
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 for

Re: Character sets and CSV report file downloads

2011-01-13 Thread Reed
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

Re: Character sets and CSV report file downloads

2011-01-13 Thread Reed
FYI, I have already tried specifying a character set of either "BIG5" or "GB2312" in the HTTP GET to download the file, but that doesn't seem to help. When I pull the csv files with Chinese characters in them from the Baidu API that's what I do to get the correct encoding. I think I need some way

Re: Character sets and CSV report file downloads

2011-01-13 Thread Reed
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 =~=~=~=~=~=~=~=~=~=~=~=~=~

Re: Character sets and CSV report file downloads

2011-01-12 Thread AdWords API Advisor
Hi Reed, Do you have a report definition id I can refer to? Cheers, Anash P. Oommen, AdWords API Advisor. On Jan 13, 6:42 am, Reed wrote: > I disagree.  I pull csv formatted data files from Baidu's API (which > looks a lot like the adWords API interface from a few generations ago) > with no pro

Re: Character sets and CSV report file downloads

2011-01-12 Thread Reed
I disagree. I pull csv formatted data files from Baidu's API (which looks a lot like the adWords API interface from a few generations ago) with no problem. -reed -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http

Re: Character sets and CSV report file downloads

2011-01-12 Thread Jai
Hi Reed, csv files are do not handle multi-byte characters well. You could try having the multi-byte field within double quotes or export it as utf-8 txt file. -- Jai -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.co

Character sets and CSV report file downloads

2011-01-12 Thread Reed
I'm using the reporting service to define and then download keyword performance files in CSV format. I've started loading data for a client in China, and am running into a character-set problem. My calls to the 201008 API to pull XML files for campaign, etc., data using my exsiting application wo