1 Reply Latest reply on Jan 12, 2015 10:33 AM by philmodjunk

    Relationship Field in database with a Windows file in a folder on the server.

    dansan500

      Title

      Relationship Field in database with a Windows file in a folder on the server.

      Post

      There is a folder on our server that contains all the photo for our parts.

      We load all our parts to a Cloud in Amazon so we can use the URL for Ebay loads

      Somehow I need to know what parts have photos,

      (Can I somehow relate the Part# in the dbase to match the file name in the folder. That way I can tell what parts don't have photos)

      I can't use the search method when a container field is empty because we use the URL script in the container.

        • 1. Re: Relationship Field in database with a Windows file in a folder on the server.
          philmodjunk

          If you can insert references, not actual copies, of your image files from that server, then you can use Insert Records | Folder to populate a table of images from that file without importing actual copies of the file, just the filepaths to those files. A field in this table can receive the file name as part of the import so you can use that to link these records to your parts table. If there is no related record, there is no part image in your folder on the server. But if you later remove a image file from the folder, you would not get an automatic update to tell you that the image file is no longer there.

          You can also use a web viewer to access and display those files. I think that combining a web viewer with GetLayoutObjectAttribute, would allow you to confirm whether or not an image file exists in that folder.

          There are also plugins that can list the file names of all files present in a folder, so you might be able to use that approach to determine which parts do and do not have associated image files.