Jump to content

Tiff image from Access to Filemaker?


This topic is 7863 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

A Win application digitalises X-ray scans and delivers them in .tiff format to an Access database. Is it possible, through Applescript, to automatically export them from the Access database to a Filemaker database?

Thanks in advance for any advice.

dirk confused.gif

Link to comment
Share on other sites

Access is a Windows application and AppleScript will not apply. Try to see if you an get the path (via Visual Basic or an export of the data). You could then import the path and use an applescript to import the image (assuming the image is not stored within the access database.)

Link to comment
Share on other sites

If you can get the images out of Access and into separate tiff image files in a folder on your mac, then yes.


tell app "finder"

-- change the following to suit your own folder name

set myfolder to "Macintosh HD:ScannedXrays:jan2002"

set mypics to ( name of every item in folder myfolder) as list

end tell

-- change the following line to suit your database name

tell database "XrayCatalog.fp5" of app "Filemaker Pro"

repeat with i from 1 to count of mypics

set filename to (myfolder &":"&(item i of mypics))

-- skip files that are the wrong type

-- change the following line to suit your image file type

if filename ends with ".tiff"

set picFile to reference to file filename

create new record

-- picture is the container field where the import goes

set cell "picture" of last record to reference to picFile

-- picref is a text field that holds the path/file name

set cell "picref" of last record to filename

end if

end repeat

end tell


As for getting the images out of Access, you may have to get help from someone else. I've never used it.

Link to comment
Share on other sites

This topic is 7863 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.