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

[goog...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 572 by mthollyi...@gmail.com: google docs get --format=csv
<src-file> <dest-file> downloads as xls not csv. it worked fine until Feb
18, 2015
https://code.google.com/p/googlecl/issues/detail?id=572

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]$


Attachments:
googledoc_iceobservations.csv 20.4 KB

--
You received this message because this project is configured to send all
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings

[goog...@googlecode.com]

Comment #1 on issue 572 by mthollyi...@gmail.com: google docs get

--format=csv <src-file> <dest-file> downloads as xls not csv. it worked
fine until Feb 18, 2015
https://code.google.com/p/googlecl/issues/detail?id=572

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

[goog...@googlecode.com]

Comment #2 on issue 572 by mthollyi...@gmail.com: google docs get

--format=csv <src-file> <dest-file> downloads as xls not csv. it worked
fine until Feb 18, 2015
https://code.google.com/p/googlecl/issues/detail?id=572

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...

[goog...@googlecode.com]

Comment #3 on issue 572 by ja...@codility.com: google docs get --format=csv

<src-file> <dest-file> downloads as xls not csv. it worked fine until Feb
18, 2015
https://code.google.com/p/googlecl/issues/detail?id=572

+1 Me too! (THERE IS NO STAR ICON)

[goog...@googlecode.com]

Comment #4 on issue 572 by ibasoalt...@groupon.com: google docs get

--format=csv <src-file> <dest-file> downloads as xls not csv. it worked
fine until Feb 18, 2015
https://code.google.com/p/googlecl/issues/detail?id=572

wtf?