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 during scanning.
The key field may be typed by the user, or it may be 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. Search on up to 99 index fields without a single keystroke!
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 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.
Command Line to Auto-close SimpleIndex
This is used to closed SimpleIndex after the job has been completed automatically. This can be useful if you only run one batch in SimpleIndex at a time and don’t need it after that batch is complete.
Instructions to Auto-close SimpleIndex when Batch is complete:
- Open the SimpleIndex Job Configuration that you would like to set to auto close when the batch is is complete.
- Open the Job Settings Wizard from the File menu.
- Go to the Advanced Settings step and expand Pre-Process & Post-Process options.
- In the Post-Process field put the following:
taskkill -f -im simpleindex.exe - Save the Job Configuration.
Alternate Intructions:
- Open the Job Options from the File menu
- In the Batch tab put the following in the “Post-Proc” field:
taskkill -f -im simpleindex.exe - Click OK and then Save from the File menu
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 a database field, your configuration must be connected to a database using the settings on the Database tab. Any fields defined as “List” on the Index tab that have a corresponding field mapped on the Database tab will use the unique values from that field to populate the list.
You can check “Only allow values in list” to disallow users from entering a value not in the list.
Once the List index field is configured properly you can select the values from a drop down after scanning that appear in the main SimpleIndex window while indexing. It also makes the field autofill the closest match from the list based on the characters that you type in that field.
- Published in Indexing & UI
What is “Match & Attach” mode?
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.
For details on how to configure Match & Attach mode, please refer to the manual.
- Published in Database & Retrieval, Export
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 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 during scanning.
To configure the Autofill feature first go to the Index tab and define the field that will be used to perform the lookup. Each value in this field should correspond to a single record in the database, usually defined as the “Primary Key”. This field can be any type, including Barcode and OCR for full automation.
Next click “Configure Index Autofill” button. Here is where you will setup the database lookup. The “Match Data Source” is configured the same way as the “Data Source” on the Database tab. It can be the path to an MDB file, an ODBC data source or OleDB connection string. Click “Set” to browse to an Access MDB file or type the connection string.
Once the data source is set, the drop-downs for the Table and Field names will be populated. Select the table or query that contains the data, then select the field in the database that will be used for lookup. Under “SimpleIndex Key Field 1” select the field you defined in the first step.
“Key Field 2” gives you the option to use 2 field values to perform the lookup if a single unique matching value doesn’t exist.
Click OK and go back to the Index tab.
Finally set the field type to “Autofill” on every field you want to populate from the database. In the “Template” for all the Autofill fields put the name of the corresponding database field that will be used to populate it.
Now when a value is entered for the key field, the Autofill fields will be filled in automatically from the database!
Cascading List Mode
Cascading List Mode is a powerful new feature introduced in 8.2 that lets you filter each list field by the values you select. For example, you could have lists for Vendor Name and Invoice Number, and when you select a Vendor from the list, the Invoice Number list will only show invoices from the selected vendor.
- Published in Database & Retrieval, Indexing & UI
Your All-In-One Scanning & Sorting Tool
SimpleIndex® has the ability to perform a wide variety of scanning and document organization tasks quickly and automatically. This makes it a must-have tool for IT departments and consultants who often need to:
- Scan and store various documents on network shares
- Organize existing MS Office, PDF and other files on your network
- Attach files to records in a custom database
- Integrate scanning into custom business applications
- Automate data entry from paper or electronic documents
- Reduce click charges for centralized scanning departments
The wide variety of scanning and indexing tasks you can do with SimpleIndex make it an incredibly useful tool to have in your arsenal. Even if your company already has an enterprise document scanning system, the low cost, fast setup and automated processing features of SimpleIndex can be put to use in many places where your existing system either doesn’t work, is too complex for the task or costs too much in click charges to be feasible.
KB Articles for Document Management
- 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?
- 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?
- Is the document Search/Retrieval and View functions available in SimpleIndex or available only with the SimpleSearch add-on module?
- Is it possible to have the scanned image itself added to a database and not just the image path?
- 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?
- When exporting to a database, I get the error "Multi-step operation generated errors"
- Is it possible to restrict user access to certain documents in Retrieval Mode?
- How do you configure full text searching in Retrieval mode?
- How do you create searchable CDs or DVDs that you can distribute royalty-free?
- What is "Match & Attach" mode?
- How do you configure the Autofill feature?
Instant Integration With Any Application
SimpleIndex® provides a great alternative to “reinventing the wheel” using a document imaging SDK to implement scanning in your custom application. SimpleIndex uses a command line interface to enable developers to execute customized scanning workflows from another application. This lets you take advantage of SimpleIndex‘s TWAIN/ISIS scanning, zone OCR, barcode recognition and database export features without having to re-code them all yourself.
Whether you are an IT consultant creating an application for internal company use or a software developer looking to add scanning features to your application, SimpleIndex provides the easiest solution available.
To use SimpleIndex as a scanning front-end for your application, simply:
- Create a SimpleIndex job file configured to scan, index and save files the way you want
- (Optional) configure the database export to create/update document records in your DB
- Use a “Shell” command to execute the job file from your program
When you execute the job file from your program, SimpleIndex will scan, read barcodes, OCR zones, etc. and organize the documents into the folders and filenames your program requires. The database export can be configured to add or update records in your database with information captured from the documents as well as the image file path or binary data. Index values can be passed from your program to SimpleIndex via the command line. The whole process can be configured to run minimized so the user never even sees the SimpleIndex screen.
KB Articles for Integration
- Exclude Index Field from Index Log
- Turn Off Prompts and Pop Ups on Job Configurations
- Change the Font Size of Index Fields
- Large documents (>500 pg) Slow to Process - Workaround
- Regular Expression (RegEx) - Syntax or Type
- Index With Non-Latin Character Sets
- Skip to Blank Index on Save Index
- Stop Autorun When Double Clicking Configuration
- Autonumber Increment Value
- High DPI Monitor Correction
Indexing from Applications with Screen OCR
Some documents are difficult or impossible to automate with OCR. For example, documents with non-standard layouts, unconstrained handwriting or very poor scan quality. In applications like invoice processing, fully automating the data entry can require expensive software and weeks of consulting. Even after all that expense, many users miss the interface and data validations that their accounting software entry screens provide.
In cases like this, SimpleIndex can help improve data entry efficiency while archiving your scanned originals at the same time. Here’s how it works:
- Scan a batch of documents for data entry
- Place the SimpleIndex window side-by-side with your data entry window
- Enter the data normally, reading from the scanned image in SimpleIndex
- Press the hotkey combo to transfer the data to SimpleIndex
- Save the image and repeat with the next one
In this configuration, SimpleIndex captures an image of the data entry window, then uses OCR to read the data and index the image. Since the data entry screen has a consistent layout and clear, readable fonts, it can be reliably recognized with OCR.
There are several advantages to this approach:
- Configuration and training takes hours not weeks
- Scanned images are indexed with no extra work
- All the advantages of digital docs–security, searching, sharing, etc.
- Use all the data validation features of your software
- No flipping through paper documents
- Operator keeps eyes on the screen and hands on the keyboard
- Data entry can be done remotely
- Data entry performance improves and files are archived at the same time
Automated Processing & 1-Click Interface
SimpleIndex® 1-click scanning and indexing is enabled with its command line interface. SimpleIndex job files can be saved and opened just like a Word document. When you open a job file, SimpleIndex begins processing a new batch automatically. Scanning, processing (OCR, barcodes, database autofill, etc) and export happen in sequence with no further input from the user.
For unattended processing, the command line interface lets you use Windows services and scheduled tasks to automate OCR, barcode recognition and database export tasks.
The Command Line Interface also allows SimpleIndex to be integrated with custom software applications with minimal to no programming required.
- Field values, processing folders and other settings can be passed as command line parameters
- Any SimpleIndex option can be set using XML job files
- Database export links processed files to your app automatically
- Control application behavior (display window, exit after processing, etc.)
- Pre-Process and Post-Process features can execute other command line applications at start and end of batch
Unattended Server-Based Processing
SimpleIndex lets you run any SimpleIndex job as a Windows service for fully unattended processing. This is particularly useful for high-volume, high-demand applications where scanned images are coming from many remote workstations, as well as small and large implementations utilizing network scanners or digital copiers. In server mode, images are saved to a “hot folder” on the server where they are processed automatically. SimpleIndex performs barcode recognition, OCR and other indexing tasks and exports formatted files to storage and database servers.
Server processing licenses may be added to any version of SimpleIndex. Unattended processing is possible without a server license, but a user must be logged on to the workstation for it to execute. Windows services run automatically when the computer is booted up, even if nobody is logged on. You must have a Server license to run SimpleIndex on Windows Server operating systems.
SimpleIndex Servers can run multiple jobs on different schedules on the same server, or run multiple instances of the same job simultaneously to take advantage of multiple CPUs.
Integrate SimpleIndex in your Custom Application
Are you a developer looking for an easy scanning interface to use with your custom database application? Then SimpleIndex is the perfect solution for you!
With SimpleIndex, you can easily package pre-configured scanning and indexing settings for distribution with your application. SimpleIndex‘s command-line interface allows you to pre-set some or all of the index values for each batch, or even to hide the SimpleIndex GUI altogether. SimpleIndex can also interface directly with your database, inserting or updating index values and associating them with the images you scan. With SimpleIndex, you won’t have to write a separate import routine to get the new information into your database.
SimpleIndex is a far better option to developing your own scanning interface from scratch. If your application needs to use advanced features like barcode recognition or dynamic OCR, SimpleIndex saves you hundreds of hours of development time. If you need to let users preview each image, rotate, clean-up, rescan or index as necessary, why reinvent the wheel?
SimpleIndex means it is no longer too costly or complicated to bundle a full scanning application with your custom software. Being a SimpleIndex reseller means big discounts on every copy you sell. Sign up now!
KB Articles for Automation, Command-Line and Server Processing
- Command Line Sample
- Command Line to Auto-close SimpleIndex
- Fixes for Service not Correctly Running
- Stop Autorun When Double Clicking Configuration
- Using alternate database schemas
- Service Configuration Paths
- How do I delete an image and it's database entry?
- How do I export index data to a database?
- Is it possible to have the scanned image itself added to a database and not just the image path?
- How do you configure a field to select from a list of possible values?
Automatic Indexing Using Existing Data
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 during scanning.
The key field may be typed by the user, or it may be 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. Search on up to 99 index fields without a single keystroke!
KB Articles for Automatic Indexing
- Exclude Index Field from Index Log
- Turn Off Prompts and Pop Ups on Job Configurations
- Change the Font Size of Index Fields
- Large documents (>500 pg) Slow to Process - Workaround
- Regular Expression (RegEx) - Syntax or Type
- Index With Non-Latin Character Sets
- Skip to Blank Index on Save Index
- Stop Autorun When Double Clicking Configuration
- Autonumber Increment Value
- High DPI Monitor Correction
Streamlined Interface
The Fastest, Most Accurate Scanning Solution
Simple
KB Articles for Streamlined Interface
- Command Line to Auto-close SimpleIndex
- Command Line Sample
- Network Scanners & Copiers
- Instant Integration With Any Application
- Automatic Indexing Using Existing Data
- Automated Processing & 1-Click Interface
- Invoice Processing with Full Page OCR
- Indexing Solutions with Barcode Recognition
- Reduce Click Charges for Data Capture
- Your All-In-One Scanning & Sorting Tool
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 during scanning.
The key field may be typed by the user, or it may be 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. Search on up to 99 index fields without a single keystroke!
Output to XML or Any Text Format
SimpleIndex 8 offers export to XML files, as well as the SimpleExport module. SimpleExport makes it possible to integrate with any third party database, application, or document management systems (DMS) that accepts an XML or text file import.
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.
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.
With other systems you must create a temporary database and write a custom import to match the scanned images to existing records. When indexing with OCR or barcode recognition, the entire process can be accomplished with our 1-click interface.
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?