Importing data, missing pictures and attachments

Tap Forms – Organizer Database App for Mac, iPhone, and iPad Forums Using Tap Forms Importing data, missing pictures and attachments

Tagged: 

Viewing 2 reply threads
  • Author
    Posts
  • February 1, 2023 at 2:56 PM #48821

    ASW
    Participant

    I try to import from a 3rd party db. In the .csv file are references to pictures and attachments as following:
    “/Users/Andreas/Downloads/Home Inventory Export/Exported Receipts/CFED5A83-6DC9-4733-941F-85411195AE5C.jpg”

    Assigning the folders for pictures and attachments during the import is working. The paths will appear in the Tap Form if I leave the field format as TEXT.
    If I assign the correct field format for the import neither pictures nor attachments will be imported.
    Any idea what’s wrong?

    • This topic was modified 1 year, 1 month ago by ASW. Reason: erasing typos
    February 4, 2023 at 3:15 AM #48828

    Brendan
    Keymaster

    Can you edit the CSV file first and strip out everything before the filename?

    If you do that, and put all of the photos into the same folder, on the Import Records screen you can choose a folder to import.

    Then Tap Forms will look for the images with the names in the CSV file.

    For example:

    Inventory Item,Photo
    MacBook Pro,CFED5A83-6DC9-4733-941F-85411195AE5C.jpg
    February 4, 2023 at 5:42 AM #48833

    ASW
    Participant

    Problem solved!
    Many thanks, Brendan

Viewing 2 reply threads

You must be logged in to reply to this topic.