Home Back E-mail



Automated mass export of images from FileMaker Pro


FileMaker Pro (FMP) has no built-in feature to allow the export of images. Jeff Davis, a participant in the comp.databases.filemaker newsgroup, asked for a solution and I suggested him to use a combination of IrfanView and AutoIt (both freeware). He succeeded in that direction and presented the following AutoIt macro.

I quote:
The "repeat 1751" was for the number of
records and {TAB 3} was needed to tab 3 times to the picture field.

MsgBox, 4, Test Script, Run?
IfMsgBox, NO, Goto, denied

WinActivate, FileMaker Pro

Repeat, 1751

Send, {TAB 3}
Send, ^c
WinActivate, IrfanView
Send, ^v
WinActivate, FileMaker Pro
Send, {TAB}
Send, ^a
Send, ^c
WinActivate, IrfanView
Send, !f
Send, s
Send, ^v
Send, {ENTER}
Sleep, 3000
WinActivate, FileMaker Pro
LeftClick, 332,195

EndRepeat

denied:
Exit
You will have to adapt your version a bit as to the number of records, the number of tabs and possibly also to the pixel position for LeftClick, depending on your screen resolution.

Good luck!

Back to the list of my FileMaker Pro trouvailles

Home Back to Christoph Bouthillier Top

© 1997...