Re: Why I can't import Google AdSense CSV file???



On Fri, 11 Feb 2005 22:17:45 -0700
"Andreas J. Guelzow" <aguelzow taliesin ca> wrote:

On Sat, 2005-12-02 at 01:03 +0100, Nomine Mutato wrote:
On Fri, 11 Feb 2005 16:10:59 -0700
"Andreas J. Guelzow" <aguelzow taliesin ca> wrote:

On Fri, 2005-11-02 at 23:30 +0100, Nomine Mutato wrote:
Hi to all. I tried to build a simple analysis system for CSV
report by Google AdSense, but Gnumeric said that it can't import
this file because is unknow format.

If I do ~$ file report.csv from command line /bin/file said: 
"report.csv: MPEG ADTS, layer I, v1,  96 kBits, 44.1 kHz,
Stereo"

I tried to ~$ cat report.csv | awk '{print $1,$2,$n...}' >
myreport.csv, but myreport.csv is same file of report.csv. It's
a binary file! 

If I do ~$ strings report.csv result is an empty file! 

Can you help me? I can't share my CVS file report, because
Google policy about it forbids that, but if want I can edit this
by hand with non true data, and attach this onto mail message.


Hi,

CSV files (comma separated values) are text files. If you look
into the file using cat or less or more you should see straight
text. If you don't then your file is _not_ a csv file.

Google said it's a CSV file... OOo Calc open correctly this
file... I suppose it is a "CSV from Microzoz" or similar way.

I like this "CSV from Microzoz". But it is much simpler:

;-)

It is indeed a csv file (at least in the widest of definitions.
To open it in gnumeric:

start gnumeric, select open, select the file, choose file type:
"comma or tab separated" of "textimport (configurable)"
choose character encoding Unicode->UTF16LE

the file should open.

WOW! It works! Thx!
 
Note that the fields a separated by blanks, but gnumeric is likely to
figure that out correctly.

There is one little problem: the file uses comma as a decimal
separator. Currently you can't select this on import, so to import
this file correctly you need to use a locale that uses comma as a
decimal separator.

Sure, I have same problem with data field. For Google CSV report in
italian format it is dd/mm/yy, I use custom column format for it.
Currently I replece comma with dot with sed before import file.

If you don't mind I would like to use this file to enter a bunch of
bug reports against Gnumeric. I can make gnumeric crash with it.

Sure, no problems. I can encoded for you an exensive example if you need
it.

Thx thx thx. Ciao! 


I had encode head of this file with no true data:

-- cut starts below this line --
begin-base64 644 google-report
//4wADEALwAwADEALwAwADUACQAzADkAMAAJADgACQAiADAALAA0ACUAIgAJ
ACIAMAAsADMAMgAiAAkAIgAwACwAMQAyACIACgAwADIALwAwADEALwAwADUA
CQA2ADMANAAJADEAOAAJACIAMQAsADEAJQAiAAkAIgAwACwAOQA4ACIACQAi
ADAALAA1ADgAIgAKADAAMwAvADAAMQAvADAANQAJADkANAA1AAkAMQAJACIA
MAAsADEAJQAiAAkAIgAzACwAOQA4ACIACQAiADEALAA4ADcAIgAKADAAMQAv
ADAAMQAvADAANQAJADMAOQAwAAkAOAAJACIAMAAsADQAJQAiAAkAIgAwACwA
MwAyACIACQAiADAALAAxADIAIgAKADAAMgAvADAAMQAvADAANQAJADYAMwA0
AAkAMQA4AAkAIgAxACwAMQAlACIACQAiADAALAA5ADgAIgAJACIAMAAsADUA
OAAiAAoAMAAzAC8AMAAxAC8AMAA1AAkAOQA0ADUACQAxAAkAIgAwACwAMQAl
ACIACQAiADMALAA5ADgAIgAJACIAMQAsADgANwAiAAoAMAAxAC8AMAAxAC8A
MAA1AAkAMwA5ADAACQA4AAkAIgAwACwANAAlACIACQAiADAALAAzADIAIgAJ
ACIAMAAsADEAMgAiAAoAMAAyAC8AMAAxAC8AMAA1AAkANgAzADQACQAxADgA
CQAiADEALAAxACUAIgAJACIAMAAsADkAOAAiAAkAIgAwACwANQA4ACIACgA=
====
-- cut end above this line --

Cut and paste this code into your file named report.uu, and then try
from command line

~$ uudeconde -o report.csv report.uu
~$ file report.csv 

and look result. You can read this file with cat and less, but it is
a binary file!

See too: uuencode(5) uudecode(5).

Hi!
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]