Check Scanner into Database

[thankgodfortektips]

Hi All,

I have been given the task of getting a Canon CR-180 to scan to a database. I will need to get it to scan each check, save the check number in a DB, save an image of the whole check and store the path of the image in a DB.

My problem is... I dont have a clue how to do this.

Does anyone know what method is used to make the scanner scan? How to save the info from the scanner?

I will be connected via USB.

Thanks in advance

 

[johnwm]

Do a search on this forum for 'TWAIN'. There are several good hits, including:
thread222-869262
thread222-272125

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[Sheco]

That scanner is not just a plain desktop thing, it is a specialized cheque scanner with a feed mechanism that grabs the front and back image of 180 checks per minute and also reads the MICR magnetic ink routing number along the bottom edge.

So you probably want more than just the twain driver .... i would check with Canon because they almost certainly have some sort of extended API for controlling the machine.

 

[thankgodfortektips]

hey guys, sorry I haven't replied had hectic few days...

I looked into the twain drivers and the threads provided (thanks johnwm!) but like Sheco said, this scanner has capabilities that I think might be passed the twain drivers...

Thanks for the suggestion Sheco, but would you know of anywhere to get the API controls as I looked on Canon and google and couldn't find anything. I will keep looking but if anyone knows would greatly appreciate the help

Thanks in advance

 

[thankgodfortektips]

hey all,

I have been working on this and found VintaSoftTwain ActiveX Control... I also got some examples from there website and this control works great.

Unfortunately I cant use any third party controls etc... so does anyone know how to get the functionality of the VintaSoftTwain control without having to use a third party control?

Thanks again!

 

[rds747]

What sort of functionalities are you looking for?
I've been working with the Kodak Image controls.

 

[thankgodfortektips]

I was looking at using the Kodak Image Controls but it would appear that because I want this to run on XP I would have to use Windows Image Acquistion. I have added this to my project and I get the additional controls - VideoPreview, CommonDialog and DeviceManager. Unfortunately I am now stuck because I can not find documentation on these controls. I keep getting a "No WIA device of the selected type is available" error, with what samples/code I have got.

I need to be able to get the scanner to just start scanning a batch of checks and then be able to display them on screen. I will also need to be able to use the MIRC to read the magnetic numbering on the checks. I have only found one app that can be used to do this which is RangerFlex from Silver Bullet Technology, but I dont think that this can be adapted to integrate with a VB App...

Thanks in advance guys!

 

[rds747]

I would think there is a way for you to get the Kodak Image controls on your XP PC as these controls were already on the XP PC I'm using. But I'm not sure if the Kodak Image controls are capable of reading the magnetic numbering on the checks.

You can check with

http://www.global360.com/

to find out if that functionality is included. They're pretty helpful.

 

[thankgodfortektips]

Ok guys, one step futher... I have just installed the ranger drivers that are meant to be shipped with the scanner. I now see that I have an additional Ranger Active X Control Module option under Tools, Components.

I have selected this and now I get an additional active x control which puts me back in the same situation as with the windows image acquisition controls... WHERE NOW????

Thanks again in advance

 

[thankgodfortektips]

Ok, another update... i have gone back to using the Kodak Controls and I can make it scan... but I can not get it to do more than one page at a time and I can not get it to use the MICR...

any ideas?

 

[rds747]

If you're asking how to save more than one image in a tiff file, in the imgscan control there is an option for multipage. If you set that to true, then you will be able to save multiple images in 1 tiff file.

Not sure about the MICR. E-mailing Global360 would be the best bet.

 

[thankgodfortektips]

Does anyone have any sample code? I have tried using the multipage option, but still just one page.

Also it is bringing up the CR-180 options and I need to program all of this into the code... Sample code anyone?

Thanks again guys for all the help!

 

[rds747]

Change your ScanTo option in the ImgScan control to 1-DisplayandFile. If that doesn't work try the other options in ScanTo.

I'm trying to scan legal size documents, but they show up letterhead (image is cut off). Know of any way to change that?