Open database integration is a powerful feature of SimpleIndex® and one that furthers its interoperability with custom programs. Instead of using a proprietary database, SimpleIndex allows you to map its index fields to cells in any database table. It can be configured to create new records, update existing ones or retrieve them for viewing. Using these three basic database functions, SimpleIndex is able to interface with and operate on any database.
The Autofill feature of SimpleIndex is an easy way to associate many index fields with one document without retyping data that already exists in another database. Autofill uses a database lookup to retrieve records that match a key value entered by the user. Blank index fields are then filled in automatically with the data from this lookup. The result is a document database with many different possible search fields, of which only one needed to be entered during scanning.
The key field may be typed by the user, or it may be read from the document automatically using barcode recognition or OCR. The lookup is performed either when the user changes this field or when the index values are saved. If the lookup finds multiple matching records, the user will be notified and the first set of values will be used by default.
When used with pre-index batches, key information can be read automatically from barcodes or OCR and matched to database records with a single click. Search on up to 99 index fields without a single keystroke!
SimpleIndex 8 offers export to XML files, as well as the SimpleExport module. SimpleExport makes it possible to integrate with any third party database, application, or document management systems (DMS) that accepts an XML or text file import.
SimpleExport converts the index values from a SimpleIndex job to any output format through XSL Transformations (XSLT). You may use one of the built-in scripts to export to a pre-defined system or design your own. SimpleExport runs automatically after each batch is exported, or it can run as an unattended Windows service.
SimpleExport can also be used as a standalone appliction for automating XSLT transformations, converting CSV or TSV (delimited text files) to XML, converting images to base64 or integrating other scanning applications with third party software.
Simplendex features "Match and Attach" mode, which combines the power of the Autofill feature with the ability to update existing records in your database. This lets you "attach" images to existing database records by "matching" them with values from SimpleIndex.
With other systems you must create a temporary database and write a custom import to match the scanned images to existing records. When indexing with OCR or barcode recognition, the entire process can be accomplished with our 1-click interface.
|I know nothing about databases. Can I still use the database and Retrieval Mode features?|
|How do you configure the Autofill feature?|
|What is "Match & Attach" mode?|
|Can SimpleIndex integrate with Microsoft SharePoint?|
|How do you configure full text searching in Retrieval mode?|
|How do I connect to an SQL Server database?|
|Is SimpleIndex for Windows only? I'm a Mac user.|
|Does SimpleQB access or modify my QuickBooks database in any way?|
|How do you configure a field to select from a list of possible values?|
|Are installation and training options available for SimpleIndex?|