All database-related articles including autofill, match and attach, database exports and searching functions.

Oracle database is slow to respond

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:
Read more
No Comments

What is Document Imaging?

Document Imaging was the more commonly used term in the early days of document scanning and OCR and refers to any system used to replicate documents used in business. It evolved from the microfilm days where it was referred to as Document Image Management. Document Imaging allows for the scanning of paper documents, as well
Read more
No Comments

Using alternate database schemas

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
Read more
No Comments

Multiple Sort Fields on Search

Please refer to the Wiki Documentation for the complete Search reference. If you have a Search/Retrieval configuration that you want to have Sort by more than one column do the following. 1. Open the configuration pad in Notepad.2. Search for the option value <SORT_FIELD>3. Normally there is one value in the section that looks like this:  <SORT_FIELD>FIELD1</SORT_FIELD>4. Add the fields that
Read more
No Comments

Access Database Connection String

Please refer to the Wiki Documentation for the complete Access reference. If you would like to create a database string for an Access database that includes a password use this format: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path\database.mdb;Jet OLEDB:Database Password=db_password;
Read more
No Comments

How do I delete an image and it’s database entry?

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
Read more
No Comments

Is it possible to search for and retrieve documents with Windows desktop search?

Please refer to the Wiki Documentation for the complete Searchable PDF reference. Windows Search works great with SimpleIndex because all index data can be saved to the folder and file names as well as the file properties, and OCR text can be saved to hidden layers in PDF files. Windows Search will read all of these elements
Read more
No Comments

Will your SimpleQB allow me to scan in old invoices or bank statements directly into QuickBooks?

purchase order
Read more
No Comments

How do I use the Media Wizard to create searchable DVDs or thumb drives?

Please refer to the Wiki Documentation for the complete Send Menu reference. To enable the Media Wizard, you must first create a job configuration that exports index information to an Access database. Once you have scanned all the documents for the CD or DVD and attached them to the database, create a second job that uses “Retrieve
Read more
No Comments

How do I export index data to a database?

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
Read more
No Comments

When I click Media Wizard, an error comes up saying “Installer Not detected in C:\Program Files\SimpleIndex\CDFiles\setup.exe” How do I fix this?

Please refer to the Wiki Documentation for the complete Wizard Mode reference. You must include the latest SimpleIndex Standalone or Imaging Suite installer with your CDs to enable the search function. Download this file to “C:\ProgramFiles\SimpleIndex\CDFiles\setup.exe” to enable the Media Wizard or update it to the latest version.
Read more
No Comments

Is the document Search/Retrieval and View functions available in SimpleIndex or available only with the SimpleSearch add-on module?

Please refer to the Wiki Documentation for the complete SimpleSearch reference. All of the search functions can be used with any SimpleIndex license. SimpleSearch is only needed to enable searching from other workstations.
Read more
No Comments

Is it possible to have the scanned image itself added to a database and not just the image path?

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,
Read more
No Comments

I have a scanner/copier that creates PDF and TIFF files and saves them to my file server. Can I use SimpleIndex to create a searchable CD/DVD from these files?

Please refer to the Wiki Documentation for the complete Wizard Mode reference. This feature is included in SimpleIndex at no additional cost and is called the Media Wizard. The Media Wizard is located in the “Send” file menu and is called Media Wizard. It allows you to burn your images, indexes, a database and a free SimpleSearch
Read more
No Comments

When exporting to a database, I get the error “Multi-step operation generated errors”

or a text value that is longer than the maximum length of the f
Read more
No Comments

Is it possible to restrict user access to certain documents in Retrieval Mode?

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
Read more
No Comments

How do you configure full text searching in Retrieval mode?

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
Read more
No Comments

How do you create searchable CDs or DVDs that you can distribute royalty-free?

Please refer to the Wiki Documentation for the complete Settings Wizard reference. This feature is included in SimpleIndex at no additional cost and is called the Media Wizard. The Media Wizard is located in the “Send” file menu and is called Media Wizard. It allows you to burn your images, indexes, a database and a free SimpleSearch
Read more
No Comments

What is “Match & Attach” mode?

if you have a large backfile of documents that you want to scan and link to records in an existing database
Read more
No Comments

How do you configure the Autofill feature?

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
Read more
No Comments