Scanning for data
Are you talking about OCR here as well for the check boxes and the originator’s name/ref?
I think there are plenty of scanners at that speed, Fujitsu is one I have used. You should be able to get a scanning system at a professional level to handle qty you are mentioning. But the OCR may be the stumbling block.
Getting references to stored files is simple enough.
I would also use SQL if you are talking a million records or more, although the DF1 would just about survive 500,000, records, when it goes wrong, then you is in trouble for sure. So start with SQL.
Mike Matthews, Managing Director, Lineal Software Solutions Ltd
Apple Reseller, Microsoft Partner, SQLWorks Business Partner
phone: 01271 375999 | web: lineal.co.uk <www.lineal.co.uk/> | email: email@example.com <mailto:firstname.lastname@example.org>
> On 9 Aug 2017, at 17:17, Martin Luce <email@example.com> wrote:
> I am looking into scanning say 5k per day of 1/3ed A4 (99*297mm) documents with about 2 or 3 check boxes plus some printed text showing 3 fields of originator’s name/ref etc. I would like to import the data directly into Omnis plus be able to save a pdf of each document with a suitable reference to the document in the file name. We could be looking at scanning hundreds of thousands or perhaps millions but would need to start small and be able to quickly scale later if the demand builds up, adding more scanners and work stations.
> This is outside my current knowledge and I am hoping someone has some experience of doing this and can point me in the right direction re scanners and how to do it?
> Do you see any problem using .df1 file which I am familiar with rather than SQL with this sort of volume?
> Manage your list subscriptions at lists.omnis-dev.com
Manage your list subscriptions at lists.omnis-dev.com