R
rligouri
I use a document imaging system that uses OCR to file documents I scan
into it. For every document I scan in, I have to print a "lead sheet"
that contains the document information (file number, document type). I
use the lead sheet as the first page of the document I am scanning and
my system will use OCR to read the info on the lead sheet and it will
file it based on that info. Problem is the OCR runs into too many
problems. If the lead sheet isnt perfectly straight, the ink too light,
there is a mark on the scanner or many others, the document will not
file properly. I contacted my software vendor and they said they will
come up with an alternative and they added the ability for the system
to process metadata files. The metadata file is a file created by some
scanners when you scan a document that contains user inputted
information. I could input the file number and document type right from
the scanner and a .DAT file (metadata file) will accompany the scanned
file telling the system how to file document. Next problem is my
scanners do not have this feature.
I've brainstormed and I came up with an idea to create the metadata
file.Create an email with the document attached and the file
information in the subject line. Send the email to a computer with
outlook always running on it. Using a combination of rules and vba,
outlook will do the following:
1) Save the attachment to a specific directory. I need to target only
TIFF files as my that is the only format my system can handle.
2) Create a text file containing information from the subject line
and/or body and the attachment file name of the email and save it as a
..DAT file in the same directory as where the TIFF file was saved.
The metadata file has to be formated like
xxxxxxxxxYYYYYYYYYYYYzzzzzzzzzzzzz. With x being the file number, Y
being the document type, and z being the path of the TIFF file. The
file name need to be formatted as IT#.dat, with # being a random
generated number to avoid duplicates.
Any help would be greatly appreciated.
into it. For every document I scan in, I have to print a "lead sheet"
that contains the document information (file number, document type). I
use the lead sheet as the first page of the document I am scanning and
my system will use OCR to read the info on the lead sheet and it will
file it based on that info. Problem is the OCR runs into too many
problems. If the lead sheet isnt perfectly straight, the ink too light,
there is a mark on the scanner or many others, the document will not
file properly. I contacted my software vendor and they said they will
come up with an alternative and they added the ability for the system
to process metadata files. The metadata file is a file created by some
scanners when you scan a document that contains user inputted
information. I could input the file number and document type right from
the scanner and a .DAT file (metadata file) will accompany the scanned
file telling the system how to file document. Next problem is my
scanners do not have this feature.
I've brainstormed and I came up with an idea to create the metadata
file.Create an email with the document attached and the file
information in the subject line. Send the email to a computer with
outlook always running on it. Using a combination of rules and vba,
outlook will do the following:
1) Save the attachment to a specific directory. I need to target only
TIFF files as my that is the only format my system can handle.
2) Create a text file containing information from the subject line
and/or body and the attachment file name of the email and save it as a
..DAT file in the same directory as where the TIFF file was saved.
The metadata file has to be formated like
xxxxxxxxxYYYYYYYYYYYYzzzzzzzzzzzzz. With x being the file number, Y
being the document type, and z being the path of the TIFF file. The
file name need to be formatted as IT#.dat, with # being a random
generated number to avoid duplicates.
Any help would be greatly appreciated.