Discussions

Expand all | Collapse all

Migrating records with attachments

  • 1.  Migrating records with attachments

    Posted 04-06-2017 19:09
    Is there a way to migrate records with attachments from one App to another App without downloading each attachment and re-attaching (uploading) individually?


  • 2.  RE: Migrating records with attachments

    Posted 04-06-2017 19:50
    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.


  • 3.  RE: Migrating records with attachments

    Posted 04-06-2017 20:55
    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.


  • 4.  RE: Migrating records with attachments

    Posted 04-06-2017 21:10
    Could you provide more details?  Need to know exactly how to do this.  Getting my Kleenex box for those tears.  


  • 5.  RE: Migrating records with attachments

    Posted 04-06-2017 21:32
    I will post further tomorrow - I am getting serious backed up with all my other work.


  • 6.  RE: Migrating records with attachments

    Posted 04-07-2017 16:19
    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)?


  • 7.  RE: Migrating records with attachments

    Posted 04-07-2017 17:49
    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 :)


  • 8.  RE: Migrating records with attachments

    Posted 04-09-2017 14:26
    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...