You need to create a script in filemaker that inserts the file path as a reference into a container field.
Go To Record [ first ]
Set Variable [ $path ; yourTable::yourTextFieldPath ]
Insert File [ yourTable::newContainerField ; $path ; store as reference ]
Go To Record [ next ; exit after last ]
Or alternatively, you can set up a webviewer to load the thumbnail based on the file path field. If you don't want to import it and just display it.
You can also create an "open url" button that will open the thumbnail file using the text path.
Just to add a few alternatives.
gbrown007 - it's not entirely clear to me how you're doing this export (a sample file/some screen shots would be helpful), but based on what you describe, one issue may be that file path in the text file you are importing isn't using the FileMaker file path.
On a Mac, you will e.g. want to use something like:
rather than simply an OS-style path like
This does help. It's working but I think I have the syntax wrong for the path. When I run the script I get a warning saying the file can not be found. Is this right?
My "$path" is: C:/Users/GB/Desktop/TEST/testFile.jpg
I that case, you will want something like:
or perhaps better
See http://www.filemaker.com/help/14/fmp/en/html/create_db.8.41.html for more details.
Do you want to store the files as reference, or actually insert them into the database?
Works like a charm now! Thanks guys!
I would want to keep them as a reference because the images will get updated and changed over time. (Assuming I am understanding that any updates will automatically show.) And the files are so small the load time is nothing.