Migrating records with attachments

  • 1
  • 2
  • Question
  • Updated 2 years ago
  • Answered
Is there a way to migrate records with attachments from one App to another App without downloading each attachment and re-attaching (uploading) individually?
Photo of Crystal-UTSW

Crystal-UTSW

  • 90 Points 75 badge 2x thumb

Posted 2 years ago

  • 1
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
If both app already in production you will want to do a file download script, which takes some custom programming.

If the app you are transfering to is new, an option is to;
Copy the old app WITH file attachements, and then transfer the table into the new app.

Really depends on where you current apps are at in production and what details you need.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
I just transferred a small binary file from one field to another field within the same application without downloading it. I used the fetch API, and the FormData API transferring the file as a blob. No API token needed as I did not use the QuickBase API.

...

I just did it again with a 5meg photo and it worked seamlessly. I even renamed the photo when uploading. You will cry tears of joy when you see how short the code is.
Photo of Crystal-UTSW

Crystal-UTSW

  • 90 Points 75 badge 2x thumb
Could you provide more details?  Need to know exactly how to do this.  Getting my Kleenex box for those tears.  
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
I will post further tomorrow - I am getting serious backed up with all my other work.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
Okay this procedure works. How do you intend to implement this? What is determining the record the file is being sent to (new record or existing record)? How do you intend to invoke this functionality (button click on record)?
Photo of Keith

Keith, Champion

  • 1,204 Points 1k badge 2x thumb
How many file attachment fields are you looking to migrate?  How many records have files in them that you want to copy?  

I just did this for a client of mine, I copied 150K files (113GB) from 8 file attachment fields in 1 app to another....it took about 90 hours of processing time to complete :)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
Please see this post:

How To Copy File Attachments Between Tables Without Download?
https://community.quickbase.com/quickbase/topics/how-to-copy-file-attachments-between-tables-without...