Use existing data from your Oracle database to populate document index field values and metadata. Export documents and data to any Oracle database. Use your Oracle database as a document management system.
Database Integration
Monday, 07 November 2022
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.
No Comments
Oracle database is slow to respond
Wednesday, 13 November 2019
Please refer to the Wiki Documentation for the complete Autofill reference. When connecting to an Oracle database, you may experience very slow responses when loading the list of Tables or Field in the configuration wizard, or when performing Autofill and Export using the Oracle connection. This can be caused by a variety of issues:
Using alternate database schemas
Monday, 29 July 2019
Please refer to the Wiki Documentation for the complete Database reference. In SQL Server, Oracle and MySQL (among others) user logons are associated with a default “schema” that determines which tables and views they can see. Users may have access to other tables and views that aren’t in their schema. When connecting to the database these tables will show up in the
How do I delete an image and it’s database entry?
Wednesday, 28 February 2018
Please refer to the Wiki Documentation for the complete Global Settings Wizard reference. If your Job Settings Wizard configuration’s of Database mode setting is set to “Update Existing Records”, the database record and the image will be deleted when you delete an image from a batch. The Table Name must be an updateable query or table
- Published in Database & Retrieval
How do I export index data to a database?
Wednesday, 28 February 2018
Please refer to the Wiki Documentation for the complete Export reference. There are a variety of ways to connect to your database. Detailed instructions are provided in the Manual (check the Help menu). Here is a brief overview of the steps involved: -Create a job configuration to scan and index files -On the database tab, set the
- Published in Database & Retrieval, Export
Is it possible to have the scanned image itself added to a database and not just the image path?
Wednesday, 28 February 2018
Please refer to the Wiki Documentation for the complete Database reference. Yes. Image files can be inserted into binary fields in Access, SQL Server, Oracle, MySQL and other databases. Check the “Store files as binary objects” option on the Database tab and the “Output File Field” setting can be mapped to a binary field. If using PDF,
- Published in Database & Retrieval, Export
When exporting to a database, I get the error “Multi-step operation generated errors”
Wednesday, 28 February 2018
or a text value that is longer than the maximum length of the f
- Published in Database & Retrieval
Is it possible to restrict user access to certain documents in Retrieval Mode?
Wednesday, 28 February 2018
Please refer to the Wiki Documentation for the complete Database Mode reference. If the database you use to store index information has security access features, you can use these to manage access to documents with SimpleIndex retrieval mode. In your database, create user accounts and groups and assign them the appropriate permissions to records in your document
- Published in Database & Retrieval
How do you configure full text searching in Retrieval mode?
Wednesday, 28 February 2018
Please refer to the Wiki Documentation for the complete Database Settings reference. On the Database tab there dropdown in the lower portion of the panel for Full Text OCR Field. Put the name of the field that will store the full-text data there. This must be configured both for Insert and Retrieval mode configurations. The database field
- Published in Database & Retrieval, OCR
What is “Match & Attach” mode?
Wednesday, 28 February 2018
if you have a large backfile of documents that you want to scan and link to records in an existing database
- Published in Database & Retrieval, Export
How do you configure the Autofill feature?
Wednesday, 28 February 2018
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 application. Autofill uses a database lookup to retrieve records that match a key value or values entered by the user or extracted with SimpleIndex. Blank index fields are then filled
- Published in Database & Retrieval, Indexing & UI
I know nothing about databases. Can I still use the database and Retrieval Mode features?
Wednesday, 28 February 2018
Yes! We’ve made it simple to create a database that you can use to store index information and perform searches with SimpleIndex Retrieval Mode. Once you have configured a SimpleIndex job to scan and store documents on your network, use these steps to create a database to store index information for searching: Go to the
- Published in Database & Retrieval
