SIGN IN YOUR ACCOUNT TO HAVE ACCESS TO DIFFERENT FEATURES

CREATE AN ACCOUNT FORGOT YOUR PASSWORD?

FORGOT YOUR DETAILS?

AAH, WAIT, I REMEMBER NOW!

CREATE ACCOUNT

ALREADY HAVE AN ACCOUNT?
QUESTIONS? CALL: 865-637-8986
  • SIGN UP
  • LOGIN

SimpleIndex - Document Scanning and OCR Recognition Software

SimpleIndex - Document Scanning and OCR Recognition Software

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
      • Schedule a Web Demo
      • News & Updates
    • 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
      • Mortgage & Loan Documents
      • Material Safety Data Sheets (MSDS)
      • Patent ID and Title Extraction
      • Federal Tax Returns
      • Invoice Processing
  • 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
  • ORDER NOW
    • COMPARE VERSIONS
      • Versions & Feature
      • Price List (PDF)
    • SIMPLEINDEX WORKSTATION
      • Machine License
      • Concurrent User
      • Subscription License
    • SIMPLEINDEX SERVER
    • SUITE APPLICATIONS
    • SUITE BUNDLES
    • SUPPORT & MAINTENANCE
      • Annual Maintenance Renewals
    • FIND A DEALER
      • Dealer Locator
      • Become a Dealer
  • DEMOS
    • TRIAL DOWNLOADS
    • SCHEDULE A DEMO
    • COMPARE SOLUTIONS
    • VIDEO DEMOS
      • Zone OCR with Template Matching
      • Invoice Processing with Full Page OCR
      • PDF Invoice OCR Demo
      • Sort and Index MS Office Documents
    • SIMPLEINDEX UNIVERSITY
      • SimpleIndex University – 100 Series
      • SimpleIndex University – 200 Series
      • SimpleIndex University – 300 Series
  • CONTACT
    • Contact Us
    • Support
    • FAQ
    • Privacy Policy
  • My Account
    • Downloads
  • MY CART
    No products in cart.
  • Home
  • Knowledge Base - Article

XSLT to transform text file formats like CSV and XML to different schemas.

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.

CSVDatabaseDatabase & RetrievalExportIntegrationMS AccessMySQLODBCOracleRecords ManagementScan to DatabaseServerSharePoint ScanningSQL ServerWorkflowXMLXSLT
Read more
  • Published in Database & Retrieval, Export
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 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?
AutofillAutomationCSVDatabaseDatabase & RetrievalDocument Management SoftwareExportIndexingIntegrationMS AccessMySQLODBCOracleRecords ManagementServerSharePoint ScanningSQL ServerWorkflowXMLXSLT
Read more
No Comments

Contact Us Today!

Search Knowledge Base

Recent KB Articles

  • Stop/Turn Off Image Deletion when Blank is Recognized
  • Error in Scanning Batch 743
  • How do I download and utilize TaxStacker after purchasing?
  • How to emulate Server behavior in the client
  • Oracle database is slow to respond
  • SharePoint Login Issues
  • Reset SharePoint Login Information
  • Large documents (>500 pg) Slow to Process - Workaround

Feature Cloud

Document Imaging Server MS Access E-Mail Annotation File Indexing MySQL PDF Barcode Recognition OCR Scanning Scanned Document Indexing QuickBooks Invoice Scanning Bookmark Automatic Data Capture SharePoint Scanning SharePoint Migration Personal Document Management CSV Microsoft Word Data Extraction Fast Scanning OCR QuickBooks Document Management Invoice OCR InstaDocs Installation & Registration SAGE Document Management Software Full Text Indexing Bar Codes Patch Code OMR Front End Scanning Zone OCR Wilder Archive Document Scanning Import PDF PDF Forms Office PDF Text Processing PDF Archive Scanning Software Keyword Indexing Bar Code Scanning Screen Scraping OCR Oracle TWAIN & ISIS Scanning

Online Support Options

Simple Software provides an interactive Frequently Asked Questions database and Live Support chat system, as well as free Training Videos.

How to Buy

Solutions start at just $500! Buy SimpleIndex online or from an Authorized Dealer in your area. Price List (PDF).

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 TrialFully functional 30-day demos are available for all Simple Software applications.
Download Now!

SimpleIndex Applications

SimpleIndex Applications See how SimpleIndex can be used in your business.
"Out-of-the-Box" Solutions
Case Studies
Common Applications
Industry-Specific Applications

© 2021 Meta Enterprises, LLC | Knoxville, Tennessee | A Family Owned Company

TOP });