I am currently trying to download and export spreadsheets from a Google application that is inherited. I use their Python Framework. Here are the relevant lines in the bulkloader.yaml file:
- kind: KindName connector: csv connector_options: encoding: utf-8 print_export_header_row: true property_map: - property: __key__ external_name: key export_transform: transform.key_id_or_name_as_string - property: field1 external_name: field1 - property: keyInAnotherTable external_name: keyInAnotherTable import_transform: transform.none_if_empty(transform.create_foreign_key('AnotherTable')) export_transform: transform.key_id_or_name_as_string
Then, when I run buklloader, I first have to wait more than an hour to download everything, and then finally it ends with this error:
google.appengine.ext.bulkload.bulkloader_errors.ErrorOnTransform: Error on transform. Property: keyInAnotherTable External Name: keyInAnotherTable. Code: transform.key_id_or_name_as_string Details: 'unicode' object has no attribute 'to_path'
I cannot find any relevant information through Googling.
Thanks in advance.
Also Is there a way to export directly from the downloaded sql3 file to CSV so that I don't have to download so many times?
source share