calopter / googlecl

Automatically exported from code.google.com/p/googlecl
0 stars 0 forks source link

google docs get --format=csv <src-file> <dest-file> downloads as xls not csv. it worked fine until Feb 18, 2015 #572

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. I checked my .config/googlecl/config and format = csv, so that setting is 
good
2. I tried a few converters but the time stamp in the spreadsheet became 
corrupt 
3. I shouldn't need to convert xls to csv.  This --format=csv worked good until 
Feb 18

What is the expected output? What do you see instead?
The command I have in my script is: google docs get --format=csv <src-file> 
<dest-file>
But the download is an xls file and should be a csv file as requested

What version of the product are you using? On what operating system? What
version of gdata-python-client (aka python-gdata)?
Red Hat 6.0 64-bit, googlecl-0.9.14, python-ldap-2.3.10-1.el6(x86_64), 
python-libs-2.6.6-51(x86_64), 
python2.6/site-packages/gdata-2.0.18-py2.6.egg/gdata

Please provide any additional information below.
Again, this started happening Feb 18, 2015 and worked great prior.  Manually 
downloading the file as a csv in google docs still works good.  Its the command 
line that now downloads the attached non-csv file.  I need a csv file to parse 
the data correctly. Here's the output (verbose):
[riverice@phi-lw-riverice riverice]$ google docs get --format=csv --verbose 
"Ice Report" googledoc_iceobservations
Gdata will be imported from 
/usr/lib/python2.6/site-packages/gdata-2.0.18-py2.6.egg/gdata/__init__.pyc
Your pythonpath: None
Reading configuration from /home/riverice/.config/googlecl/config
determine_terminal_encoding(): UTF-8
Initialized googlecl.client.BaseClientCL
missing_reqs: ['title', 'dest']
Option convert: True
Option delimiter: ,
Option dest: googledoc_iceobservations
Option format: csv
Option hostid: riverice@phi-lw-riverice
Option prompt: True
Option src: []
Option title: Ice Report
Option user: mthollyiceobservers
Option verbose: True
args: []
Loaded token from file
Successfully set token
Using regex: Ice Report
Retrieved 6 entries, returning 1 of them
Decided file_ext is csv
Downloading Ice Report to googledoc_iceobservations.csv
[riverice@phi-lw-riverice riverice]$ 

Original issue reported on code.google.com by mthollyi...@gmail.com on 11 Mar 2015 at 12:13

Attachments:

GoogleCodeExporter commented 8 years ago
In reviewing the verbose output during the script run I see this and have the 
following questions:
Reading configuration from /home/riverice/.config/googlecl/config
determine_terminal_encoding(): UTF-8
Initialized googlecl.client.BaseClientCL
missing_reqs: ['title', 'dest']       <== missing_reqs? do I need something 
here?
Option convert: True                  <== Is this a conversion from xls to csv? 
make it false instead?
Option delimiter: ,
Option dest: googledoc_iceobservations
Option format: csv
Option hostid: riverice@phi-lw-riverice

Original comment by mthollyi...@gmail.com on 13 Mar 2015 at 1:18

GoogleCodeExporter commented 8 years ago
I have had to manually download the spreadsheet as a csv file every day since 
Feb 18th.  I'd think google developers would have an easy fix for this.  Whats 
going on in google's software house?  Don't you have enough developers to fix 
this issue? I don't get it...

Original comment by mthollyi...@gmail.com on 23 Mar 2015 at 11:45

GoogleCodeExporter commented 8 years ago
[deleted comment]
GoogleCodeExporter commented 8 years ago
wtf?

Original comment by ibasoalt...@groupon.com on 13 May 2015 at 12:54