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

[Nomine Mutato <mutato nonews org>]

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