2 Replies Latest reply on Jul 27, 2012 12:00 AM by JodieWeston

    Auto import images

    JodieWeston

      Title

      Auto import images

      Post

      Does anyone know how to auto import images (jpeg files) into a database?  For example the record name is S123 and the file name contains S123 (but it may have additional characters, eg. S123v1), I would like to say if it contains S123 then import into the record S123... hope that makes sense.

      Thanks Jodie :)

        • 1. Re: Auto import images
          philmodjunk

          Import the images into another table, then use a script to find the appropriate record and link the two in a relationship.

          The Import Records | Folder tool can import the image files into a container and the filename into a text field at the same time.

          Then it's a matter of the script finding and linking records.

          Assuming a 1 to 1 relationship, you can define a serial number field in either table (you may have one already defined in your current table) and set up a match field for the relationship in your new imported image table. With either method, your script would link your image record to a record in your existing table by copying the serial number to the match field.

          How you set up the script will depend to some degree on the design of your current table and whether your imported images will replace existing images or not. If there is a consistent format to how the additional characters are added to the record name to make it a filename, this can be set up without needing to use a script as a calculation field can then extract the record name from the file name and then it can match to the recordname in the relationship.

          • 2. Re: Auto import images
            JodieWeston

            Thank you so much!!! Have a great weekend!! :)