Comma-delimited text files for document metadata.

How do I export index data to a database?

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 “Database Mode” to “Insert New Records” -To use ODBC, enter the data source name or file in Data Source -To connect directly, select your database type under “Select a Data Source” and click Start. A series of dialogs will prompt you for database connection information. -Select destination Table or View and click Reload -For each index field, select the corresponding database field that will receive that field value -The “Output File Field” will receive the path to the exported file Once you have created records in your database in “Insert” mode, you can change to “Retrieve and View Records” and use SimpleIndex or SimpleSearch to search and view the files.
Read more
No Comments

How do you configure a field to select from a list of possible values?

List fields are populated using a text file or database field containing the values for that list. The text file scenario will be described first. To configure a list field, go to the Index tab in the Job Options. Create a list field by selecting “List” for the field type and give it a name. In the “List File/Field” setting for this field, put the full path or UNC to the text file containing the list or click “Set” to browse to the file. If you have not created a file, you can put the path where you want the file stored here and click the “Edit” button. This will open the file in Notepad; new files will prompt you to create them. On each line of the text file you will put one of the possible values that you want to be able to select from while you are indexing with SimpleIndex. You can copy this information from another source and paste it into the text file. Save the file in Notepad and close it. The List field is now configured! To use
Read more
No Comments

Indexing Solutions with Barcode Recognition

Barcode recognition is the most efficient way to capture index data printed on documents. If you are unfamiliar with the use of barcodes in document scanning, you can learn more about barcodes in our Barcode Scanning Guide, but if you want to know more about barcode use with SimpleSoftware products, read on. Your browser does not support the video tag. Some documents already have key information in barcode format on them. In many cases adding a barcode to a document is as simple as changing or adding a font. Adding barcodes to new documents is preferable as all the index data is on the document at the time it is created and in a format that can be read with near 100% accuracy. As an alternative to placing barcodes on the individual documents, it is possible to print out a barcode cover page and place it on the file before it is scanned. The SimpleCoversheet application was designed to make this easy by providing a simple interface for selecting index values and printing a standard
Read more
No Comments

Database Integration

Unprecedented Control of Database Interactions 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. Automatic Indexing Using Existing Data 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
Read more
No Comments