To upload documents to a database table using the Black Ice Printer Driver, the table must have at least 3 columns. The table must have an index field column, a document field (any name) column, and a document ID field (any name) column.
Based on the Upload to Database configuration, the Document field column Data Type can be varbinary or varchar. If you select “Document Binary” when uploading documents, the Data Type must be varbinary. If you select “Document Path” the Data Type must be varchar.
For the complete list of the database fields and data types, please see the following table:
|
Column |
Data Type |
Description |
|
ID (index) Column |
The Data Type must be bigint. |
This column will be a unique identifier (index field). |
|
Document Column |
If you upload “Document Binary” (the entire document), then the column Data Type must be varbinary(MAX).
If you upload “Document Path”, then the Data Type must be varchar(256). |
This column will store the document itself, or the document location. |
|
DocumentID Column |
The Data Type must be varchar(N).
N is the maximum length of the Document ID. It’s recommended to enter a number larger than 1000. |
This column will store the document ID generated by the printer driver. This document ID can contain the document name, or other variables to help you identify the document. |
|
OCR Column (Optional Column) |
The Data Type must be varchar(N).
N is the maximum length of the OCR. It’s recommended to enter a number larger than 4000. |
This column will store the OCR data.
This column is optional, and will only be used if Uploading OCR is enabled. |
|
Text Output Column (Optional Column) |
The Data Type must be varchar(N).
N is the maximum length of the Text Output. It’s recommended to enter a number larger than 4000. |
This column will store the Text Output data.
This column is optional, and will only be used if Uploading OCR is enabled. |