Migrating Google Sheets out of Box > Google Drive

What is the problem you are having with rclone?

We are migrating away from Box > Google Drive.

Via the Box integration to Google Drive there are .gsheet docs in Box

When these are migrated the file is not there. Naturally its a reference to a special Google Sheet file that is over on Box.

How do we migrate these into Google Drive, preferably keeping it as a Google Sheet?

Run the command 'rclone version' and share the full output of the command.

rclone v1.61.1
- os/version: debian 11.7 (64 bit)
- os/kernel: 5.10.0-21-cloud-amd64 (x86_64)
- os/type: linux
- os/arch: amd64
- go/version: go1.19.4
- go/linking: static
- go/tags: none

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

Box > Google Drive

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

rclone copy tsp_shared_sync_dest:/'Staff Management Folders/' TSP_SHARED_DEMO_DEST,team_drive=0AH33hp-Aiqxxxxxxxx:/ -vvP --checkers=10 --transfers=10 --drive-server-side-across-configs --drive-pacer-min-sleep=100ms --check-first --stats-one-line --stats=1s --drive-use-trash=false --fast-list --create-empty-src-dirs --ignore-existing --update --log-file TSP_0AH33hp-Aiqxxxxxxxx_DEST.log --dry-run 

The rclone config contents with secrets removed.

type = drive
client_id = xxxx
client_secret = xxxx
scope = drive
token = {"access_token":"xxxx"}
team_drive = xxxxxx
root_folder_id =

type = drive
scope = drive
token = {"access_token":"xxxxxx"}
team_drive = 0ANokkgddwxxxxxx
root_folder_id =

A log from the command with the -vv flag

2023/07/06 02:55:08 DEBUG : International Team - Management/Dana's Management Folder/Hours Tracker.gsheet: md5 = 74f2789e302a170bb6fcb3927f6000dd OK
2023/07/06 02:55:08 INFO  : International Team - Management/Dana's Management Folder/Hours Tracker.gsheet: Copied (server-side copy)
2023/07/06 02:55:08 DEBUG : International Team - Management/Dana's Management Folder/Australia.gsheet: md5 = 36353825bae5b77e4afb9ff4e5b685ae OK
2023/07/06 02:55:08 INFO  : International Team - Management/Dana's Management Folder/Australia.gsheet: Copied (server-side copy)

I recognise this isn't really an issue in rclone, but I thought someone here may have come across this.

Google Support say there is no way to unwrap their native files from Box so we can have them back in drive.google.com

What I need to know is can rclone convert the file on export from /box to a docx for example?

But it won't be server side operation

Thanks - I appreciate you can do this on a Google Drive remote, however this is a Box remote with Google Drive files inside it.

Here's the info on the Box + Drive integration https://www.box.com/partners/google

@ncw have you come across this? Does the box API even support the change of the file format from gdoc > docx?

I didn't think it was possible to export google docs in "native" format. That certainly isn't in the google drive API I have access to. I wonder if box has a special API from google to do this?

That is a possibility but I couldn't find anything in a brief search.

Thanks - until a few days ago I didnt even know you could use native gdoc/gsheet within Box. Google Support said they cant help(!), and there is nothing on the Box docs or API I can see that even mentions Google Docs.

Our solution to this for now, is to use Make to export it from Box as a xlsx and then import it back into Google Drive.

1 Like

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