Index a migration - ID and Title on both sides

What is the problem you are having with rclone?

How do I output an index of the mappings between Box and Google Drive?

We have a successful migration running as per the command below. What we need from rclone is a csv of the source files and a csv of the destination files so we can find and map them.

Ideally:
Box ID, Box Title, Google Drive ID, Google Drive Title

The scenario is that the Box files have internal box links within the docs. After migration to Google Shared Drives, and Box being deactivated, these will no longer work. We need to be able to reference the source and destination of each file in Box so that we can look up a file and find the new, equivalent document id in Google Drive.

We cant do this by filename, as there would be duplicates. We also cant do this by folder and filename as in the migration to Shared Drives the paths are being reduced and changed.

Thanks!

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

rclone v1.60.0
- os/version: darwin 13.2.1 (64 bit)
- os/kernel: 22.3.0 (x86_64)
- os/type: darwin
- os/arch: amd64
- go/version: go1.19.2
- go/linking: dynamic
- go/tags: cmount

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 -P -v tspbox:/ sunriseproject:/ --server-side-across-configs  --drive-server-side-across-configs  --log-file sunrisesync.log >/dev/null 2>&1

The rclone config contents with secrets removed.

[sunriseproject.org]
type = drive
client_id = xxxxxx
client_secret = GOCSPX-xxxxx-qzYC
scope = drive
token = {"access_token":"ya29.xxxxxxx-KpaWKCJb687-xxxxxxx-xxxxxxxx","token_type":"Bearer","refresh_token":"1//xxxxxxx-xxxxxx","expiry":"2023-06-12T04:01:50.667866377Z"}
team_drive = xxxxx
root_folder_id = 

[tspbox]
type = box
client_id = xxx
client_secret = xxx
token = {"access_token":"xxx","token_type":"bearer","refresh_token":"xxx","expiry":"2023-06-12T04:08:03.209341974Z"}

A log from the command with the -vv flag

n/a

Only option I can see is to compare files' hashes. Box uses SHA1 and gdrive uses MD5 so unfortunately it means you have to download all files from one remote.

Lets say you decide to use SHA1, then you run rclone sha1sum:

rclone sha1sum tspbox:

rclone sha1sum sunriseproject.org: --download

and compare outputs

Please note --download flag for gdrive as it does not support SHA1

You can do the same using rclone md5sum - but then all files from box will need to be downloaded.

to get the ID of files and the hash, try something like this.

rclone lsf box:zork --format=pih --csv --hash=SHA1 --files-only --absolute --recursive
/file.ext,1237726567036,356a192b7913b04c54574d18c28d46e6395428ab

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