You need more than just the file name you need the file path--a list starting from the volumne name (mac) or drive letter (windows) that then lists all the enclosing folders followed by the file name.
You might investigate Import Records with the Folder option as another approach for importing a batch of pictures.
even if i specify the full path - it doesn't work. and importing more than 1000 pictures by hand doesn't sound like an attractive idea....
Specifying the full path will work if it is used correctly. I can't tell from your example how you are setting up such a full path.
And Import Records | Folder is an option for importing all the images into your table in one batch.
full path: imagewin:D:/DB/Contact/pic/CONTACT::id_abbrev.jpg
and about import records | folder. how would it assign specific picture to a record?
How are you implementing that path? Are you using a variable?
Set Variable [$Path ; Value: "imagewin:D:/DB/Contact/pic/CONTACT::id_abbrev.jpg" ]
Go to Field [YourTable::YourContainerField]
Insert Picture [$Path]
The cursor has to be in the container feld before you do the insert.
With Import Records | Folder, you can specify a field for the FileName--so if you may be able to use the file name to match records. (Sometimes it's easier to use this tool to import into a separate related table.)
doesn't work with that path.... sad :(
If it doesn't work with that path, then there is an error in that path or in how you have set up insert picture. A quick test suggests that you need this path: "/D:/DB/Contact/pic/CONTACT::id_abbrev.jpg"
script debugger returns error number 100 - file is missing. but it's not. weird.
Which is what I would expect if the path is invalid.
Which version of the path did you use with this last test?
In manage scripts, I'd use Add file to manually insert the file reference for one file and check to see what format that file path takes as a way to double check all the details of your file path's format.
data viewer returns proper values. i don't get what's wrong. as i said, if i substitute variable with any of the .jpg names (that is what variable stands for) - it works like a charm. but it doesn't with variables. it's disappointing.
That didn't answer my question.
Your original example: "imagewin:D:/DB/Contact/pic/CONTACT::id_abbrev.jpg"
Does not appear to be a valid file path to use with Insert Picture.
When I tested setting up this script step, there was no "imagewin" and the first character was a /, followed by the drive letter.
Did you test this with the modified format that I suggested?
This script worked for me in a quick test:
Set Variable [ $Path; Value:"/C:/Documents and Settings/Phil/My Documents/My Pictures/RaceCars/1967-race-0011.jpg" ]
Go to Field [ ContainerTest::containerField ]
Insert Picture [ “imagewin:$path” ]