Unprecedented Control of Database Interactions
Open database integration is a powerful feature of SimpleIndex® that furthers interoperability with custom programs. Instead of using a proprietary database, SimpleIndex allows you to map 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.
Automatic Indexing Using Existing Data
SimpleIndex's Autofill feature 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 key values entered by the user. Then blank index fields are automatically filled with the lookup data. After entering only one field, data autopopulates, resulting in a document database.
The key field may be typed by the user or 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.
Custom Code Extensions for Autofill and Export
Customized Autofill and Export functions extend this functionality to use APIs and web services to populate or export index data when a direct database connection is not possible. This allows you to directly interface with any application to populate and export document data.
An example is our ChatGPT document analysis service, which uses the same extension interface to provide AI document analysis results that can be used for classification and natural language data extraction.
Match and Attach Mode
SimpleIndex 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.
xml and JSON Data Sources
SimpleIndex also has the ability to read data directly from XML and JSON files. Many document management and cloud storage platforms provide document metadata in XML and JSON files whenever you attempt to migrate data, along with corresponding files that may or may not have logical filenames. Use SimpleIndex to extract the data from these files, organize the documents, and migrate the metadata to a database or new document management platform.
Output to XML or Any Text Format
SimpleIndex offers direct export to pre-formatted XML files, as well as the SimpleExport module that can output any XML schema or text file format.
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 application 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.
Find Out More
KB Articles for Database Integration
- Oracle database is slow to respond
- What is Document Imaging?
- Using alternate database schemas
- Multiple Sort Fields on Search
- Access Database Connection String
- How do I delete an image and it's database entry?
- Is it possible to search for and retrieve documents with Windows desktop search?
- Will your SimpleQB allow me to scan in old invoices or bank statements directly into QuickBooks?
- How do I use the Media Wizard to create searchable DVDs or thumb drives?
- How do I export index data to a database?