Skip to main content
Question

I need to transfer file attachments fields to new app. I downloaded info into a cvs file but I am not sure the file attachements are there

  • August 28, 2017
  • 0 replies
  • 22 views
I need to transfer file attachments fields into a new app. I downloaded the app info into a cvs file but I am not sure the file attachements are there to go into the new appl Is there an easy way to transfer the file attachments? I have around 900 to transfer.
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • August 28, 2017
      You would need to run a script to move the actual file.  If you don't have access to / or budget for that, you can make a link from the old records and bring that over for legacy data.

      As long as you don't delete the old files, you can use this;


      URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e87/v0/"

      (the e87 is the field ID of the file attachment)
      Create this formula URL in your old app, and add it to the CSV that you are exporting.  Then the users in the new app can click the 'link' and download/view the document.

      Also enable the checkbox to allow access without logging in.  That way if new users don't have access to the old app, they can still use it in the new app.
      • anomDiebolt
      • Registered
      • August 28, 2017
      When querying a record containing a file attachment field you get the name of the file attachment not the file's contents.

      You can copy files between applications using the script in this pastie (look also for the forum link for additional info):

      How To Copy File Attachments  Between Tables Without Download?
      https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=574

      Surprisingly this script doe snot even use the API so no application token is needed.
      Terms & ConditionsAccessibility statement