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

SimpleIndex

T (865) 637-8986
Email: info@simpleindex.com

SimpleIndex by SimpleSoftware
500 W Summit Hill Dr SW # 302, Knoxville, TN 37902

  • 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
      • Dynamic OCR
      • Database Integration
      • Required Documents Check
      • Integrated & Unattended Processing
      • 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

Comma-delimited text files for document metadata.

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

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

Wednesday, 28 February 2018 by dwilder

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.

Automatic Indexing SoftwareCSVDatabaseDatabase AutofillDocument AutomationDocument RetrievalFile IndexingKeyword IndexingMetadataMS AccessMySQLODBCOffice PDF Document IndexingOracleScanned Document IndexingServer OCRSharePoint ScanningSQL ServerWorkflowWorkflow Software
Read more
  • Published in Indexing & UI
No Comments

Indexing Solutions with Barcode Recognition

Friday, 12 January 2018 by Simple Software

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 coversheet that contains these values in barcode format.

Barcode recognition can also be useful when you have documents with a variable number of pages that will all receive the same index values. If it is not possible to generate an indexed coversheet for these at the time they are created, a generic barcode coversheet can be used to separate the scanned images into multi-page files, one for each document. A second process can then be used to index these images one file at a time instead of one page at a time, greatly increasing throughput.

Barcode Recognition Features

With SimpleIndex Barcode you can:

  • Read barcodes printed on scanned paper documents
  • Read barcodes embedded in PDF files
  • Automatically rename files based on barcodes
  • Export barcode data to CSV file or any database
  • Separate multi-page documents with cover pages
  • Recognize 2D formats like PDF417, DataMatrix, Aztec and QR Code
  • Recognize 30 different 1D barcode formatsCode 39, Codabar, UPC, Code 128, EAN 13, 2 of 5, etc.
  • Recognize postal barcodes like Planet, PostNet, Royal Post and Australian Post
  • Lookup barcode values in a database for additional data
  • Complete list of document scanning & indexing features

With SimpleCoversheet you can:

  • Create barcode coversheets for use with SimpleIndex and other scanning applications
  • Print barcodes on Avery label templates that can be applied to documents
  • Affordably enable every employee to print barcodes
  • Create coversheets that allow SimpleIndex to automatically index and file documents
  • Enable scanning and indexing from MFPs, network scanners and digital copiers
  • Perform “mail merge” with barcodes to print many coversheets at once
  • Supports many 1D and 2D barcode formats

KB Articles for Barcode Recognition

  • Turn On Replacement Characters for Barcodes
  • Regular Expression (RegEx) - Syntax or Type
  • Autonumber Increment Value
  • What are some other terms for Bar Code Scanning Software?
  • Can SimpleIndex read bar codes from existing PDF files?
  • I cannot recognize PDF417 or QR Code bar codes. What does "Advanced "Only" mean?
  • Can I split TIFF or PDF files based on barcodes as a separator and also name the file with the barcode value?
  • Will SimpleIndex read multiple barcodes on a page and save the value to the appropriate index field?
  • Is there a way to just use part of a bar code or OCR value? For example, extract "50" from the value "124450"
  • How can I delete the barcode or blank page cover/separator sheet that I don't need to save?

FAQ Related to Barcode Recognition

Coming Soon
1-Click ProcessingBar Code PrintingBar Code ScanningBarcode Recognition SoftwareCommand-LineCSVFile IndexingPatch CodePDFPDF417QR CodeScanning CoversheetSimpleCoversheetUnattendedWatermark PDF FilesWorkflow Software
Read more
No Comments

Database Integration

Tuesday, 03 October 2017 by dwilder

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 offers direct export to pre-formatted XML files, as well as the SimpleExport module that can output any XML schema or text file format.

SimpleExport makes it possible to integrate with any third party database, application, or document management systems (DMS) that accept 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.

 

Find Out More

  • Download or get an Online Demo
  • Database wiki page
  • Autofill wiki page
  • SimpleExport wiki page

Knowledge Base 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?
CSVDatabaseDatabase AutofillDocument AutomationDocument Management SoftwareDocument RetrievalFile IndexingMS AccessMySQLODBCOracleServer OCRSharePoint ScanningSQL ServerWorkflowWorkflow SoftwareXMLXSLT
Read more
No Comments

Contact Us Today!

=

Search Knowledge Base

Recent KB Articles

  • SimpleIndex Standard Workstation
  • Simple Software Server Processing Add-on for SimpleIndex
  • SimpleIndex Standard Server 1M
  • SimpleIndex OCR Add-on Workstation
  • SimpleIndex Pro Server 1M
  • SimpleIndex Professional Concurrent
  • SimpleSearch Concurrent Viewer
  • SimpleIndex OCR Concurrent

Feature Cloud

Barcode Recognition Software XSLT Data Conversion Software Watermark File Indexing Automatic Data Capture TWAIN Scanning Software Workflow Software Text Processing Imprinting Document Imaging TIFF PDF417 Remote Capture PDF Compression Document Retrieval Command Line Interface Screen Scraping OCR Distributed Scanning Scanned Document Indexing PDF Bookmarking OCR Form Processing TIFF PDF Annotations Clipboard OCR SharePoint Migration TWAIN & ISIS Scanning SimpleView Document Capture Solution Mortgage Metadata Database Autofill OCR Paperless Office OCR Scanning Fast Scanning 1-Click Processing Full-Text Search RPA Oracle Document Management Software Image Scanning Unattended Processing Invoice OCR Personal Document Management MS Access Export

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}
});