looking up and importing a graphic?

[Labelman]

Can anyone help? I use V4 as a label database, I want to incorporate the relevant graphic in our 'specification' layout , each record has a unique number and the graphic can be identified with the same number. I have tried various methods with little success . Please can someone point me in the right direction.

Thank you

[cjaeger]

create a graphics database and relate it via record id . showing it on the label would be as easy as placing a field "graphics::picture" on the label ...

------

From your post I gather you do not yet have stored the graphics in Filemaker but have a bunch of images named 1234.jpg or similar.

there is an applescript example in your filemaker folder that does batch import pictures ...

[Labelman]

Christian, thank you for your response.You are right I currently have numbered .jpeg files.

I get the idea and have created a seperate database but am unable to pull in a different graphic for each record as the links using Import object/picture apply to all records in the layout mode. I also could not find the applescript for importing batch pictures..

Can you help any further.

Thank you

Nigel-Labelman

[cjaeger]

I get the idea and have created a seperate database but am unable to pull in a different graphic for each record as the links using Import object/picture apply to all records in the layout mode.

You will simply have to create a container field and import in "browse" mode.

The applescript is simply used to automate import, but for a start you can do it manually.

this little applescript should enter the pictures for you.

make sure pix database is in front

field names are

"picture" for the picture container

"picture name" text field for the picture name

---------snip- paste in AppleScript Editor ---------

activate

--choose a folder with picture files

set folderPath to (choose folder with prompt "Where are your pictures?")

--create a list of all files in the folder

set fileList to list folder folderPath

--initialize pictureCount variable

set pictureCount to 0

--create a new record for each picture

repeat with pictureFileName in fileList

set pictureFileRef to (folderPath & pictureFileName as string)

tell application "FileMaker Pro"

activate

tell database 1 --- the database in front (or use "database.fp3" for a specific database)

if pictureFileName contains ".jpg" then

set newRecord to create record at end

go to newRecord

set cell "picture name" of newRecord to pictureFileName

set cell "picture" of newRecord to file (pictureFileRef)

set pictureCount to pictureCount + 1

end if

end tell

end tell

end repeat

end

end

--display number of pictures found

tell me to activate

if pictureCount = 0 then

display dialog "No pictures were found in folder " & folderPath

else

display dialog "Number of pictures imported: " & pictureCount

end if

--------------snip -------------------------

not much error checking here.

Imports files that contain ".jpg", but does not check filetype etc ...

But should do since this is a one time job ...