Script to insert picture into container

[Matt Leach]

Im having a bit of difficulty with a project i am working on.

I've taken a spreadsheet with variouls fields in it and have created a new database based on the spreadsheet.

One of the fields is PointerToSource and contains the path to the image that i would like to insert into my container field (field name is image)

I've setup the following script:

Set Variable [$file; Value:test_import::PointertoSource]

Go to Field [test_import::image]

Insert Picture ["imagewin:/$file"]

When i run this script, i am presented with the following error:

The File (path to the file) could not be found and is required to complete this operation.

The path for this particular record is C:\Temp\GalacTek\_obj_8_D27\_obj_8_D27_224.TIF

If i manually browse to the path, the file is there and viewable.

Any ideas as to why i am unable to insert the picture?

[comment]

The path for this particular record is C:\Temp\GalacTek\_obj_8_D27\_obj_8_D27_224.TIF

In Filemaker, it needs to be:

imagewin:/C:/Temp/GalacTek/_obj_8_D27/_obj_8_D27_224.TIF

See:

http://www.filemaker.com/11help/html/create_db.8.32.html#1030283

[Matt Leach]

i knew it had to be something simple, i completely overlooked the slashes. Ill just do a substitution and ill be all set.

Thanks for the quick reply.