Is it possible to move all the attachments to Drive or similar?

I tried a search and gpt, but no luck.

If I could create a script or simply do some sort of database magic, we could move all the PDFs and docs and JPGs to a cloud server for organization, search and archiving.

Or perhaps I’m just imagining a magic trick, not something that’s doable…

thanks.

1 Like

Three options spring to mind:

  • use Data Explorer to create a query for all Upload records with desired extensions and print the URL, then download them to a folder
  • download an SQL backup, then do the same as above
  • download a backup including all uploads (requires assistance enabling this temporarily on our hosting), then extract that backup

With the first two options you can also grab the original filename so you can preserve it upon download but there will be collisions.

With the third all the files will be named with their hash (the long hex string) but you can use the data from #1 or #2 to rename them.

4 Likes

thank you! much appreciated.

2 Likes

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