Export Workspace sheet to xlsx

Help and Support
1

What is the problem you are having with rclone?

Trying to export a sheet from my employer's workspace to xlsx

What is your rclone version (output from rclone version)

$ rclone version
rclone v1.53.4
- os/arch: linux/amd64
- go version: go1.15.7

Which OS you are using and how many bits (eg Windows 7, 64 bit)

Archlinux

Which cloud storage system are you using? (eg Google Drive)

Google Drive

The command you were trying to run (eg rclone copy /tmp remote:tmp)

rclone copy twgd:$id .
2021/01/29 11:13:51 ERROR : : error reading source directory: directory not found
2021/01/29 11:13:51 ERROR : Attempt 1/3 failed with 1 errors and: directory not found

(It can't find the sheet with the id I know exists)

The rclone config contents with secrets removed.

twgd                 drive

Or what I can do with gdrive export --mime application/vnd.openxmlformats-officedocument.spreadsheetml.sheet $id with the unmaintained github prasmussen/gdrive project

2

Rclone copy normally takes a file name. Do you know the name?

If the sheet is shared with you then you might need the --drive-shared-with-me flag.

Or you could try rclone backend copyid for copying files by I'd but you will need the beta for that I think.

3

--drive-shared-with-me didn't work.

I just installed

rclone v1.54.0-beta.5115.f0bf9cfda
- os/arch: linux/amd64
- go version: go1.15.7

I don't see a copyid... :grimacing:

4

It is a backend specific command - here is the docs

I'm not 100% sure it will work with google docs - give it a go!

copyid

Copy files by ID

rclone backend copyid remote: [options] [<arguments>+]

This command copies files by ID

Usage:

rclone backend copyid drive: ID path
rclone backend copyid drive: ID1 path1 ID2 path2

It copies the drive file with ID given to the path (an rclone path which
will be passed internally to rclone copyto). The ID and path pairs can be
repeated.

The path should end with a / to indicate copy the file as named to
this directory. If it doesn't end with a / then the last path
component will be used as the file name.

If the destination is a drive backend then server-side copying will be
attempted if possible.

Use the -i flag to see what would be copied before copying.

5 
 rclone backend copyid drive: 1_bQAKskMdtaOM8z3tH4BF3w9cMURQG-M_7s1pXtLiGg foo.xslx
2021/01/29 21:28:32 Failed to backend: didn't find section in config file
(ins)[hendry@t14s signupshow]$ rclone twgd copyid drive: 1_bQAKskMdtaOM8z3tH4BF3w9cMURQG-M_7s1pXtLiGg foo.xslx
Error: unknown command "twgd" for "rclone"
Run 'rclone --help' for usage.
2021/01/29 21:28:36 Fatal error: unknown command "twgd" for "rclone"
(ins)[hendry@t14s signupshow]$ rclone config
Current remotes:

Name                 Type
====                 ====
twgd                 drive

I'm confused and drunk obviously.

6

You need to put the name of your remote instead of drive: so

rclone backend copyid twgd: 1_bQAKskMdtaOM8z3tH4BF3w9cMURQG-M_7s1pXtLiGg foo.xslx

You and me both! (It is tax time in the UK.)

7

I don't understand this can't use empty string as a path error message.

$ rclone backend copyid twgd: 1_bQAKskMdtaOM8z3tH4BF3w9cMURQG-M_7s1pXtLiGg foo.xslx
2021/02/01 18:07:27 Failed to backend: command "copyid" failed: failed copying "1_bQAKskMdtaOM8z3tH4BF3w9cMURQG-M_7s1pXtLiGg" to "foo.xslx": can't use empty string as a path
(ins)[hendry@t14s signupshow]$ rclone version
rclone v1.54.0-beta.5115.f0bf9cfda
- os/arch: linux/amd64
- go version: go1.15.7
8

Ah, that looks like a bug!

If you use

rclone backend copyid twgd: 1_bQAKskMdtaOM8z3tH4BF3w9cMURQG-M_7s1pXtLiGg ./foo.xslx

It should work.

I fixed this here if you want to give it a try :slight_smile:

v1.54.0-beta.5134.f66928a84 on branch master (uploaded in 15-30 mins)

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.