SIGN IN YOUR ACCOUNT TO HAVE ACCESS TO DIFFERENT FEATURES

Login with Google
CREATE AN ACCOUNT FORGOT YOUR PASSWORD?

FORGOT YOUR DETAILS?

AAH, WAIT, I REMEMBER NOW!

CREATE ACCOUNT

ALREADY HAVE AN ACCOUNT?

Login with Google

QUESTIONS? CALL: 865-637-8986
  • SIGN UP
  • LOGIN

SimpleIndex

  • LEARN MORE
    • GENERAL INFO
      • Getting Started
      • How To Scan Documents
      • Barcode Scanning Guide
      • Searching & Viewing
      • News & Updates
      • Schedule a Web Demo
    • FEATURES
      • Streamlined Interface
      • TWAIN and ISIS Scanning
      • Zone OCR and Dynamic OCR
      • Database Integration
      • Required Documents Check
      • Automated Processing & 1-Click Interface
      • SharePoint Document Scanning
    • –
      • Document Classification
      • PDF & MS Office Text Parsing
      • Barcode Recognition
      • Optical Mark Recognition
      • Match Documents to Existing Data
      • Imprinting & Watermarking
      • Screenshot OCR
  • SOLUTIONS
    • General
      • All-In-One Scanning & Sorting Tool
      • Affordable Document Management
      • Instant Integration
      • Network Scanners & Copiers
      • Remote Document Capture
      • Reduce Click Charges for Data Capture
    • Specific
      • Sales Tax Exemption Forms
      • Federal Tax Returns
      • Invoice Processing
      • Material Safety Data Sheets (MSDS)
      • Patent ID and Title Extraction
      • Mortgage & Loan Documents
    • Feature Demos
      • Zone OCR with Template Matching
      • Full-Page OCR & Multi-User Workflow
      • PDF Text Processing
      • Organize Office Documents
      • Integration with RPA Bots
      • Compare with Other Solutions
  • SUITE
    • SimpleCoversheet – Print Bar Codes
    • SimpleExport – Data File Converter
    • SimpleView – Search, View & Edit
    • SimpleQB – QuickBooks Integrator
    • SimpleOCR – Freeware OCR
    • Buy Suite Apps
    • Buy Suite Bundles
  • DOWNLOAD
  • SHOP
    • COMPARE VERSIONS
    • SIMPLEINDEX WORKSTATION
      • Machine License
      • Concurrent User
      • Subscription License
    • SIMPLEINDEX SERVER
    • SUITE APPLICATIONS
    • SUITE BUNDLES
    • MAINTENANCE & RENEWALS
    • FIND A DEALER
      • Dealer Locator
      • Become a Dealer
    • CONTACT SALES
  • SUPPORT
    • WIKI HELP
    • KNOWLEDGE BASE
    • SIMPLEINDEX UNIVERSITY
      • SimpleIndex University – 100 Series
      • SimpleIndex University – 200 Series
      • SimpleIndex University – 300 Series
    • PRIVACY POLICY
    • CONTACT SUPPORT
  • My Account
    • Downloads
  • MY CART
    No products in cart.
  • Home
  • Simple Software Knowledge Base - Article

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

Oracle database is slow to respond

Wednesday, 13 November 2019 by aaron

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:

  • Check User Permissions. Make sure the user has access to the required tables and schemas. Users with access to all schemas may experience significant delays when loading table lists as there can be many thousands of tables they have access to. Try switching to a user account whose schema only includes the tables used by SimpleIndex.
  • Slow connection between the client and the Oracle server. Check if other Oracle applications on this workstation also experience slowness.
  • Issues with client installation. Reinstall or update your Oracle client and ODBC drivers.

Oracle
Read more
No Comments

What is Document Imaging?

Wednesday, 31 July 2019 by aaron

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 as the processing of files saved electronically. These files are then named and saved for later searching.

Other document imaging terms include automatic imaging software, best digital imaging software, best imaging software, desktop imaging software, digital document imaging, digital imaging software, document imaging download, document imaging PDF, document imaging processing, document imaging products, document imaging software, document imaging solution, document imaging solutions, document imaging systems, document imaging technologies, document imaging technology, document imaging tools, image to database, imaging resource, imaging scanning software, imaging software companies, imaging software download, imaging software for windows, imaging solution, scanner imaging software, scanning and imaging, scanning imaging, and software for imaging.

Automatic Data CaptureAutomatic Indexing SoftwareDocument AutomationDocument ClassificationDocument ImagingDocument Management SoftwareDocument ScanningImage ScanningKeyword IndexingOffice PDF Document IndexingPersonal Document ManagementQuickBooks Document ManagementRequired Documents AuditingScanned Document IndexingWorkflow
Read more
No Comments

Using alternate database schemas

Monday, 29 July 2019 by Simple Software

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 list, but when you try to get the list of fields you get an “Invalid object reference” error.

To reference these tables, use [Schema].[Table] for the table name to explicitly reference the table.

You can also change the user’s default schema on the server to the one matching the table.

A third option is to create a view under the user’s default schema that selects the necessary records.

At the present time you cannot enter [Schema].[Table] in the wizard, so if you need to use this workaround configure the job in the wizard and modify the table name in the old job options screen.

DatabaseDatabase AutofillDocument RetrievalMS AccessMySQLODBCOracleSQL ServerWorkflow Software
Read more
No Comments

Multiple Sort Fields on Search

Monday, 29 July 2019 by Simple Software

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 you want to search by as the database columns like this:  <SORT_FIELD>[FIELD1],[FIELD2]</SORT_FIELD>

Document Management SoftwareDocument RetrievalSearch
Read more
No Comments

Access Database Connection String

Monday, 29 July 2019 by Simple Software

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;

DatabaseDatabase AutofillDocument RetrievalMS AccessODBC
Read more
No Comments

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

Wednesday, 28 February 2018 by dwilder

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 and you must have sufficient permissions for both the database record and the file.

You cannot delete files with SimpleSearch. To enable retrieval users to change indexes, rename or delete files, use a SimpleIndex Standard license.

DatabaseDocument RetrievalMS AccessMySQLODBCOracleSearchServer OCRSQL ServerWorkflow Software
Read more
  • Published in Database & Retrieval
No Comments

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

Wednesday, 28 February 2018 by dwilder

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 when building its index and will return any matching files when you search.

Using Windows Search on a file server allows for instantaneous searching across terabytes of documents and text for all of the users on your network.

IFilters allow Windows Search to search within file contents.

Here are three popular PDF IFilters that will enable text searching for PDF files:

  • Foxit PDF IFilter (commercial)
  • TET PDF IFilter (free/commercial)
  • Adobe PDF IFilter (32-bit / 64-bit) (free)

If you have issues with PDF text searching in Windows 10, this article has detailed instructions for resolving PDF IFilter issues:

https://fixedit.itxpress.biz/2018/07/05/searching-pdfs-in-windows-10/

ContentverseDocument Management SoftwareDocument RetrievalFile IndexingMicrosoft Word Data ExtractionOffice PDF Document IndexingOffice PDF Text ProcessingPaperless OfficePaperVisionPDF Archive Scanning SoftwareQuickBooks Document ManagementSearchServer OCRText ProcessingUnattended Processing
Read more
  • Published in Database & Retrieval, Export, Office PDF Text Processing
No Comments

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

Wednesday, 28 February 2018 by dwilder

SimpleQB enables you to scan and link documents to QuickBooks transactions through a custom menu. When you have an invoice, purchase order, work order, bank reconciliation or other transaction open, simply click the Scan menu to scan a document and save it with that transaction.

To view the documents for a transaction, just click the View menu.

You can also use SimpleSearch to find and view documents scanned with SimpleQB without the QuickBooks interface.

Full-Text SearchInvoice OCRQuickBooks Document ManagementSimpleQB
Read more
  • Published in Database & Retrieval, SimpleQB
No Comments

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

Wednesday, 28 February 2018 by dwilder

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 and View Records” to search and view these files.

The media wizard will be enabled in the Send menu whenever you have this configuration file open. The sample configurations included with SimpleIndex demonstrate scanning and searching with an Access database. Microsoft Access is not required to create the database.

The media wizard will copy the Access database and all of the files in your Output folder to a temporary folder, along with the SimpleSearch configuration and Autorun files needed to search the files from a CD or DVD. Simply burn all the files in this folder to create the searchable disc.

DatabaseDocument ManagmentDocument RetrievalExport
Read more
  • Published in Database & Retrieval, Export
No Comments

How do I export index data to a database?

Wednesday, 28 February 2018 by dwilder

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.

CSVDatabaseDocument Capture SolutionDocument RetrievalMS AccessMySQLODBCOracleServer OCRSharePoint ScanningSQL ServerWorkflowWorkflow SoftwareXMLXSLT
Read more
  • Published in Database & Retrieval, Export
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?

Wednesday, 28 February 2018 by dwilder

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
  • Published in Database & Retrieval
No Comments

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

Wednesday, 28 February 2018 by dwilder

All of the search functions can be used with any SimpleIndex license. SimpleSearch is only needed to enable searching from other workstations.

ContentverseDocument Management SoftwareDocument RetrievalFile IndexingPaperless OfficePaperVisionPDF Archive Scanning SoftwareQuickBooks Document ManagementSearchServer OCR
Read more
  • Published in Database & Retrieval, Licensing & Installation
No Comments

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

Wednesday, 28 February 2018 by dwilder

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, MS Office or other non-image files, use the File Type Field to store the file extension of the stored file.

SimpleSearch mode will let you view files stored using this method as well.

DatabaseDocument RetrievalMS AccessMySQLODBCOracleSharePoint ScanningSQL ServerWorkflow Software
Read more
  • Published in Database & Retrieval, Export
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?

Wednesday, 28 February 2018 by dwilder

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 viewer for just the CD or DVD. It also provides an easy way to get the maximum amount of information on the media that you want it on.

You set up the Media Wizard by pointing it to your image folder and database and you select the media that you would like to put it on. It then saves a file folder with all the files that you would need in the size of the media you are using in the location that you designate. You then burn these files using the burning application of your choice.

Document Management SoftwareDocument RetrievalPaperless OfficePDFPDF Archive Scanning SoftwareSearchServer OCRTIFF
Read more
  • Published in Database & Retrieval, Import
No Comments

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

Wednesday, 28 February 2018 by dwilder

This error is usually caused when the data you are trying to insert does not match the data type of the database field. This could be a text value being inserted into a number or date field, or a text value that is longer than the maximum length of the field.

To avoid this error, be sure to use the correct Field Type and/or Template on the Index tab to force the user to enter data in the correct format. You may also need to adjust the data types or lengths for your database fields.

DatabaseDocument RetrievalMS AccessMySQLODBCOracleSQL Server
Read more
  • Published in Database & Retrieval
No Comments

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

Wednesday, 28 February 2018 by dwilder

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 database.

In SimpleIndex, check the “Require Logon” option on the Logging tab to force the user to logon to the database using the accounts you created. When they search and view documents, they will only be able to access records that the corresponding database user has been assigned access to.

DatabaseDocument Management SoftwareDocument RetrievalMS AccessMySQLODBCOraclePaperless OfficeServer OCRSQL ServerWorkflow Software
Read more
  • Published in Database & Retrieval
No Comments

How do you configure full text searching in Retrieval mode?

Wednesday, 28 February 2018 by dwilder

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 needs to be sufficient length to store the entire text of your document.

Of course, the Insert Mode configuration must have “Enable Full Page OCR” checked to generate full text data from images. Text from MS Office documents, PDF files and existing OCR text files can be used without setting this option.

When designing your Retrieval Mode configuration, create a Text field to use for full text search queries. On the Database tab, set the corresponding “Database Field Name” to the full text database field.

When searching on your full text field, SimpleIndex finds the text you enter no matter where it appears in the document. It is able to match partial words. It does not perform boolean or natural language searches. The text entered must match the document text exactly.

DatabaseDocument Management SoftwareDocument RetrievalFile IndexingFull Text IndexingMS AccessMySQLOCROCR Form ProcessingOCR ScanningODBCOffice PDF Text ProcessingOraclePaperless OfficePDF Archive Scanning SoftwarePDF Data Extraction SoftwareQuickBooks Document ManagementSearchServer OCRSharePoint ScanningSQL ServerText ProcessingUnattended ProcessingWorkflow SoftwareZone OCR
Read more
  • Published in Database & Retrieval, OCR
No Comments

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

Wednesday, 28 February 2018 by dwilder

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 viewer for just the CD or DVD. It also provides an easy way to get the maximum amount of information on the media that you want it on.

You set up the Media Wizard by pointing it to your image folder and database and you select the media that you would like to put it on. It then saves a file folder with all the files that you would need in the size of the media you are using in the location that you designate. You then burn these files using the burning application of your choice.

Related Links

  • SimpleIndex.com – Document Management
  • SimpleIndex.com – Affordable Document Management
  • SimpleIndex Wiki – Send Menu
  • SimpleIndex Wiki – SimpleSearch
  • SimpleIndex Wiki – Retrieve and View Records
Read more
  • Published in Database & Retrieval
No Comments

What is “Match & Attach” mode?

Wednesday, 28 February 2018 by dwilder

Match & Attach mode lets you batch update multiple records in a database using the index data from your SimpleIndex job. For example, if you have a large backfile of documents that you want to scan and link to records in an existing database, you can use Match & Attach to find the corresponding record and set the Image Path field to the newly scanned file.

This allows documents to be indexed with a variety of information and then have it find a particular record based on up to three different key indexes in a data source.  It can then fill in additional data columns with indexed information along with the full text information, page count, batch ID and image path.

The Match & Attach uses the key field in the  “Autofill Settings…” in the Indexing & File Naming step of the Job Settings Wizard in the File menu.  Then fills the data into any blank columns for the record in the database and also changes any fields that are different.

Related Links

  • SimpleIndex Wiki – Match and Attach Records
DatabaseDatabase AutofillDocument AutomationDocument RetrievalMS AccessMySQLODBCOracleServer OCRSQL ServerWorkflow
Read more
  • Published in Database & Retrieval, Export
No Comments

How do you configure the Autofill feature?

Wednesday, 28 February 2018 by dwilder

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 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.

You can use one, two or three index fields as the key values to extract data from your data source.  These index fields can be any of the various types of manual and automatic fields.  Once the fields are matched the lookup information will get filled in to the Autofill Index fields.

Instructions

  1. Navigate to the Indexing & File Naming step in the Job Options Wizard under the File menu.
  2. Create an Index field(s) in SimpleIndex that will be used for the key matching value(s), which will pull the information from the database.  This Index field can be any Type other than Autofill.
  3. Click the “Autofill Settings…” button on the top right.
  4. Select the “Datasource:” configured in the Database step in the drop down or click the “New Data Source…” button to create a new connection.
  5. Click the Load button, which loads the data from the database.
  6. Select the Table or View that the data is in in the “Table or View:” drop down.
  7. Select the key field from the database that will be used to match against to pull the other data from the other columns in the selected Table or View from the “Database Key Field 1:” drop down.  If other index fields are required for matching the correct records select these in “Database Key Field 2:” and “Database Key Field 3:”
  8. Select the key index field from SimpleIndex that will be entered or extracted and used to match against the database in the “Index Key Field 1:” drop down.  If other index fields are required for matching the correct records select these in the “Index Key Field 2:” and “Index Key Field 2:”, making sure that the correct SimpleIndex fields are linked to the correct database columns.
  9. Click Finish
  10. Create new Autofill index fields for each piece of additional data needed to be filled in based on the key field(s).  The Template for each of the Autofill index fields should be the exact name of the column from the data source that should be filled.

By checking the “Allow manual input in Autofill fields” the users can edit the filled data manually.  By checking “Automatically select first matching record” it will select the first record in the table that matches instead of asking which record should be used, when multiple records in the data source have the same data.  By checking “Match on single Key Field” it will match on just one of the key fields, instead of requiring all key fields be match, when multiple key matching fields are used.  By checking “Cascading List Mode” each autofill field is displayed as a drop down list populated by the records that match the key field(s) and each selection filters the next list for matching values.

Related Links

  • SimpleIndex.com – Automatic Indexing Using Existing Data
  • SimpleIndex.com – Invoice Processing with Full Page OCR
  • SimpleIndex Wiki – Autofill
  • SimpleIndex Wiki – Cascading List Mode
  • SimpleIndex Wiki – Data Source
  • SimpleIndex Wiki – Access
  • SimpleIndex Wiki – SQL
  • SimpleIndex Wiki – ODBC
DatabaseDatabase AutofillDocument AutomationDocument RetrievalMS AccessMySQLODBCOracleServer OCRSQL ServerWorkflow
Read more
  • Published in Database & Retrieval, Indexing & UI
No Comments
  • 1
  • 2

Search

Contact Us Today!

=

Search Knowledge Base

Recent KB Articles

  • Database Export Error
  • SimpleIndex Not Autorunning Jobs
  • Prompt Before Appending with Identical Filename
  • Error in Program Load: 481 - Invalid Picture
  • Order of Import
  • How do I purchase, register and activate Simple Software products?
  • What are SimpleIndex Specifications?
  • License Activation Issues

Feature Cloud

File Indexing Robotic Process Automation Paperless Office Automatic Data Capture TIFF PDF Annotations Invoice OCR SQL Server PDF Data Extraction Software Text Processing TWAIN Full Text Indexing Office to PDF PDF Forms Optical Character Recognition OCR Scanning Barcode Recognition Software Database Autofill PDF417 TIFF Personal Document Management Image Scanning Imprinting & Watermarking PDF Bookmarking Unattended Invoice Scanning Software Workflow Software SharePoint Migration Office PDF Document Indexing Microsoft Word Data Extraction Unattended Processing Scanned Document Indexing Contentverse Barcode Printing Remote Capture Zone OCR MS Access PaperVision Document Imaging RegEx Document Classification ODBC PDF Document Retrieval XML Business Process Automation

Online Support Options

Check our Wiki Help, Knowledge Base and Training Videos, or Contact Support if you still need Help

How to Buy

Solutions start at just $500! Buy SimpleIndex online or from an Authorized Dealer in your area.

Authorized Dealers

Authorized DealersSimpleIndex is a great addition to any system integrator's product line. Become an Authorized Dealer.

Get a Web Demo

Get a free online demo with a scanning specialist who can configure SimpleIndex on your computer remotely.
Sign up for a demo now!

Download a Trial

SimpleIndex Trial30-day trial downloads are available for all Simple Software applications.
Download Now!

SimpleIndex Applications

SimpleIndex Applications Packaged apps built with SimpleIndex.
SimpleInvoice for AP
Sales Tax Manager
Mortgage LoanStacker
MSDS and Patents
SimpleIndex

© 2022 Meta Enterprises, LLC | Knoxville, Tennessee | A Family Owned Company
© 2022 SimpleSoftware | Consulting Services in the Field of Software as a Service

TOP
Manage Cookie Consent
We use cookies to optimize our website and our service.
Functional cookies Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
View preferences
{title} {title} {title}
});