Exporting a dataset to Google Sheets

Tycho

Hi,

I'm trying to export data towards Google Sheets. I can retrieve data with the Google Sheets plugin, but now I want to send it.

How can I do this using the Google Sheets plugin?

With kind regards,

Tycho

jereze

Hi,

You should first create a dataset with the plugin Google Sheets? Then, edit/create your recipe and select the dataset as the output.

Tycho

Great! Thanks for the explanation. But now I get this error:

Failed to write rows : : 'Worksheet' object has no attribute 'get_addr_int'

What does that mean?

Tycho

What module should I use to export the data to Google sheets?

Tycho

This is the error log:

2018-11-14 09:51:13,290 INFO Connecting to parent at port 53541
2018-11-14 09:51:13,291 INFO Connected to parent at port 53541
2018-11-14 09:51:13,397 INFO Processing task: write_rows
2018-11-14 09:51:14,195 INFO Refreshing access_token
Traceback (most recent call last):
File "/Applications/DataScienceStudio.app/Contents/Resources/kit/python/dataiku/connector/server.py", line 125, in serve
write_rows(connector, schema, partitioning, partition_id, input)
File "/Applications/DataScienceStudio.app/Contents/Resources/kit/python/dataiku/connector/server.py", line 63, in write_rows
writer.close()
File "/var/folders/k8/jbnml6rd43g6_3m16qrz1jxm0000gn/T/tmpgnqPYT/code.py", line 182, in close
self.flush()
File "/var/folders/k8/jbnml6rd43g6_3m16qrz1jxm0000gn/T/tmpgnqPYT/code.py", line 171, in flush
cell_list = ws.range( 'A1:%s' % ws.get_addr_int(num_lines, num_columns) )
AttributeError: 'Worksheet' object has no attribute 'get_addr_int'

jereze

Did you install the python dependencies in the UI of Dataiku DSS?

I suspect that you don't have the versions of the dependencies expected by the plugin.

Tycho

What are the dependencies needed for this plugin?

jereze

https://github.com/dataiku/dataiku-contrib/blob/master/googlesheets/requirements.json

Tycho

This plugin declares external dependencies HIDE
gspread (==0.4.0)
oauth2client (>=2.0.0,<2.3.0)<BR />PyOpenSSL (>=0.15.0)
awesome-slugify (>=1.6.5)
To install them, run on the command line:
/DATA_DIR/dss_home/bin/pip install 'gspread==0.4.0' 'oauth2client>=2.0.0,<2.3.0' 'PyOpenSSL>=0.15.0' 'awesome-slugify>=1.6.5'
SUCCESSFULLY INSTALLED

Tycho

I'll try to reinstall the plugins.

jereze

The plugin should work now.

Tycho

I'm still getting the same error. I already had all the dependencies installed. Is there anything else I can try to fix this?

jereze

There might be a bug with the plugin. I will investigate. You can follow-up here: https://github.com/dataiku/dataiku-contrib/issues/91

Tycho

Are you getting the same error? Thank you! I'll follow the thread!