scanning documents into fmp

[MacDocMd]

i have developed a modest data base for a medical practice

i need to develop a module to import xrays lab reports etc

is there a scanner

a special plugin

imput needs to stop to enter patient id

any help will be appreciated

[goanna300]

In windows, you can probably execute a script from within Filemaker and import the image into a container field.

Try AutoIt http://www.hiddensoft.com . (Freeware)

Steve

[goanna300]

Yes, II just found out it's been done:

(from http://www.tekstotaal.com/c.fmp.twain.scan.html):

>FileMaker Pro (FMP) v4 and v5 has no built-in feature to allow scanning images directly into a container field. If you do not want to use a plugin and work under Windows, here is a solution that will (hopefully) satisfy your needs for 99%:

Get freeware AutoIt v2.63 or higher from www.hiddensoft.com/autoit.

Get freeware IrfanView v3.61 + all plugins or higher from www.irfanview.com

Write the following textfile; my comments are bulleted and in italics. Be careful: window titles are case sensitive. Double backslashes are needed to represent a single backslash.

Run IrfanView

run, C:Program Filesirfanviewi_view32.exe

Wait until IrfanView window becomes active

WinWaitActive, IrfanView

Enter Alt-f ("File") or Alt-d (!d) ("Datei") for German Windows etc.

Send, !d

Enter c for Scan (in IrfanView, German version; in the English version this might be a different character)

Send, c

Wait until the scanner's window opens; I have a Canon N650U, its software is called ScanGear; adapt the title if necessary.The scanner settings must be set before your start it all (size, dpi etc.)

WinWaitActive, ScanGear

Enter Alt-s (that starts *my* Canon scanning process)

Send, !s

Wait until the scanned image appears in Irfanview

WinWaitActive, ScanImage

Enter control-c to copy it

Send, ^c

Close Irfanview

WinClose, ScanImage

Awaken FMP

WinActivate, FileMaker Pro

Paste image into the selected cotnainer field (see script below)

Send, ^v

Now save this as text file "fmptwain.aut" an compile it with Aut2exe.exe into "fmptwain.exe".

In FMP you need a container field on a layout, and a 2 line script:

Go to Field ["o.image"]

Send Message ["fmptwain.exe", "aevt", "odoc"]

This works fine, with one single exception (that is the remaining 1%): at the end the container field is still selected. You could avoid that with a sufficient pause before giving an additional "naked" Go to Field. FMP does not wait until an external app is finished (very nasty, would be nice for FMP v6). You would have to find out with testing your scanner etc. how long that pause would have to be.

>Good luck!

Hope this helps.

Steve

[Lefo]

And, if you wanted to do this on a Mac?

TIA

Lefo

[goanna300]

On a Mac it's even easier! You have Applescript.

[rjc3000]

InsideScan - http://www.powersolutions.it Works with Windows and Mac

[JP2004]

i have recently been converted from Access to Filemaker and am having trouble with scanning images into my database. I have downloaded and installed the inside scan plug in however i cant find any documentation on how to call and control it. If anybody could help i would be very appreciative indeed.

Regards,

JP2004

[S. D. Bowler]

The 1.7 version of Inside Scan has a very detailed PDF in the unpacked folder.

I have yet to use the product however.

SB

[stefanshotton]

Theres is a free plugin that lets you scan direct to a container field.

Topic Here