Microsoft SharePoint document scanning and metadata indexing. Automatically capture scanned images and electronic files like PDF and MS Office, automatically extract data, organize the files and upload them to the relevant SharePoint document libraries.
How to connect to a SharePoint Online site that uses multi-factor authentication
SimpleIndex does not support multi-factor authentication to connect to a SharePoint Online site that implements it.
If your admin has set up 2-step verification for your organization you’ll need to generate an app password so the app can connect to Office 365.
Once you have an app password, you use this in place of your original password with SimpleIndex to connect to the SharePoint site. Your SharePoint administrators should be able to create one for you.
You can find more information about App Password here:
For instructions on how to set one up, visit this page:
Reset SharePoint Login Information
The first time you run a SimpleIndex Job Configuration that uploads to SharePoint it will ask for your SharePoint User Name and Password. Once you enter this it saves this information and doesn’t ask for it again. If you need to change the User Name or Password for SharePoint please follow the instructions below.
Open the Windows File Explorer and navigate to this location:
C:\Users\WINDOWSUSERNAME\AppData\Local\Simple_Software\DefaultDomain_Path_3aa0dedu1iaszsodvugr0hxbpamae3ew
The WINDOWSUSERNAME section will be the Windows User Name that you login to Windows with when you run the SimpleIndex software.
The “DefaultDomain_Path_3aa0dedu1iaszsodvugr0hxbpamae3ew” section will vary, but will always start with “DefaultDomain”.
Once that folder is found delete all of the files and folders from this location.
How to Fix SharePoint Login Issues
If login issues occur when connecting to SharePoint or it continually prompts for a login please try this solution.
Instructions:
- Search for “regedit” on your computer.
- Navigate to this folder in the Registry Editor window: Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SimpleIndex\Misc
- In the right pane of the Registry Editor window Right Click and select New>String Value
- Set the name of the file to this: DisableSharePointForms
- Double click on the “DisableSharePointForms” registry key, set the Value to “1” (Zero) and click OK.
- Run again and re-enter the login information.
- This will automatically logon to SharePoint without requesting the login information each upload.
Troubleshooting SharePoint Permissions Issues
The problem was being caused by the fact that the root site on the server did not grant the users read access.
For example, imagine they are trying to upload to:
” http://server/sites/mysite/test.pdf ”
The user has full permissions on mysite, but if they try to access http://server/ they get permission denied. Even though the user can upload to mysite, they cannot upload with SimpleIndex because the client objects require permission on the root site.
Granting the users at least read access to the root site at http://server/ resolves the issue.
SharePoint Managed Metadata
If a SharePoint user has a Managed Metadata column that they need to set the value for in SimpleIndex, the value they must use is the unique ID for that metadata value, not the value itself.
SharePoint 2010
To find the unique ID, go to a document library that uses the managed metadata column and view the documents in Datasheet view. The unique ID is the part before the semicolon in that column. In the example below, the ERM Classification of “Electric Deal Tickets” has an actual value of “1”.
You will need to have a document with each possible value in order to get all the values this way. If there are a great number of possible values, it is possible to use a script to download them or to pull them directly from the SharePoint database.
SharePoint 2013 & Office365
For SharePoint 2013 and Office365 you need to use the GUID identifier for the taxonomy term.To get the actual value for a managed metadata term, you can use the Unique Identifier that is displayed when you edit the terms in Term Store Management.
In order to get the full list of unique ID values, follow the steps on this here. Use this list to create an autofill table that will replace the text value with the unique ID and map that field to your column in the database.
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.
Can SimpleIndex integrate with Microsoft SharePoint?
Any document processed with SimpleIndex can be uploaded directly to your SharePoint document library, and any custom columns or metadata tags can be set automatically using the SimpleIndex index field values.
Find out more at our SharePoint Document Scanning page.
Integrated custom metadata is only supported in SharePoint 2010 and above, including SharePoint Online / Office 365. Microsoft .NET 3.5 and the SharePoint 2010 Client Object Model are required and must be installed separately in version 7. Version 8 includes a download option in the Global Settings Wizard. Version 8.4 and above include them automatically. Version 7 users can Download the SharePoint 2010 Client Object Model here.
To configure SharePoint export, go to the Advanced Options screen in your Job Options and enter the URL of your document library in the SharePoint Document Library URL setting.
The easiest way to integrate with SimpleIndex is to simply map a network drive to the SharePoint document library and set your Output folder to use this drive. SimpleIndex will create folders and name files automatically using your job settings.
In this configuration, only the Title tag is set. You can also use SimpleIndex‘s file property feature to set EXIF tags (images) or PDF file properties for the Title, Subject, Author and Keywords tags.
One thing to remember when configuring SimpleIndex jobs for SharePoint is the extra restrictions on filenames in SharePoint. For a detailed list please visit SharePoint File Name Restrictions. When using the integrated SharePoint feature with SharePoint 2010 these invalid characters are automatically replaced when exporting.
There are also several inexpensive or free applications that allow you to upload documents processed with SimpleIndex to SharePoint. These can be useful when you have a slow connection and need the files to upload in the background without slowing down production. Here are two of them:
SharePoint 2010 Bulk Document Importer
If your SharePoint integration has requirements not met by these solutions, our Professional Services department will be able to design a SharePoint interface to meet your specifications.
- Published in SharePoint Integration
How do I export index data to a database?
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.
- Published in Database & Retrieval, Export
I have a duplex scanner how do I set up SimpleIndex to scan 2 sided documents automatically?
Simplex versus Duplex scanning is a function of your scanner driver. SimpleIndex uses both TWAIN and ISIS drivers. ISIS drivers are faster for high-speed scanners and are preferred.
To configure duplex on an ISIS scanner:
1 Select “Use ISIS Driver” from the Scan menu if it is not selected
2 If this is your first time using ISIS, click “Select a Scanner” to select the driver for your scanner
3 Click Display Scanner Settings to display the ISIS driver settings
4 Find the setting for Simplex/Duplex and set appropriately. Each scanner model has a different driver interface. Refer to your scanner’s documentation if you cannot find the duplex setting.
To set the scanner settings using TWAIN:
1 Select “Use TWAIN Driver” from the Scan menu
2 If this is your first time scanning with TWAIN, click “Select a Scanner” and select your scanner
3 If “Display Scanner Settings” is not checked in the Scan menu, click it to select it
4 When you run the job, the scanner settings will be displayed prior to scanning. Find and select the duplex setting there. If you cannot find it, refer to your scanner’s documentation.
When scanning in duplex, you will want to enable automatic blank page deletion. Many scanners have this feature built-in, so check your driver settings to see if there is a blank page deletion option.
If your scanner doesn’t have blank page deletion, use the “Min File Size” setting on the Batch tab of the Options screen to enable it in SimpleIndex. This setting refers to the minimum file size (in bytes) for a page to be considered non-blank. Any file under that size will be deleted. This value varies depending on scan resolution, and does not work with uncompressed files.
- Published in TWAIN & ISIS Scanning
Is it possible to have the scanned image itself added to a database and not just the image path?
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.
- Published in Database & Retrieval, Export
What scanners are compatible with SimpleIndex? How do I find a list?
SimpleIndex is compatible with any device that has a TWAIN or ISIS driver. This includes virtually all makes and models of scanner, as well as many specialty scanners, digital cameras and other devices.
In the few instances when a scanner has a proprietary driver, it can still be used with SimpleIndex by first scanning to a folder and setting SimpleIndex‘s input to “From Folder” on the Input tab.
For many high-speed scanners (over 50 pages/minute), ISIS drivers provide improved throughput versus TWAIN. It is recommended you purchase the ISIS driver option with these scanners.
ISIS drivers also let you save your scanner settings to a file that can be distributed with your SimpleIndex configuration.
You can find more information on selecting the best scanner for your specific requirements on the ScanStore Scanners Guide, as well as a wide assortment of scanners available for purchase.
- Published in TWAIN & ISIS Scanning
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
How do you configure full text searching in Retrieval mode?
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.
- Published in Database & Retrieval, OCR
I know nothing about databases. Can I still use the database and Retrieval Mode features?
Yes! We’ve made it simple to create a database that you can use to store index information and perform searches with SimpleIndex Retrieval Mode.
Once you have configured a SimpleIndex job to scan and store documents on your network, use these steps to create a database to store index information for searching:
- Go to the Database step in the Job Settings Wizard
- Click “New Data Source…”
- Select Default and then click Next
- Click Yes when asked to “Copy default database to config file folder and configure settings?”
- The database will be copied to the folder that the Job Configuration is saved in and the name of the database will be the same name as the Job Configuration with all of the fields in SimpleIndex
This creates a database and automatically links it to your SimpleIndex Job Configuration for uploading to or searching from.
Related Links
- Published in Database & Retrieval
How do I configure SimpleIndex to scan documents?
First make sure that you scanner’s TWAIN and/or ISIS driver (found on the included CD or manufacturer website) is installed and that the scanner shows up in the ‘Printers and Scanners’ section of the ‘Control Panel’ in Windows.
On the SimpleIndex Settings Wizard step of the Job Settings Wizard set the Input Type to Scanner or Both. Scanner will just use the scanner and both will scan first and then pull image from the Input folder.
Settings for the scanner can be found in the Scanner Settings step of the Job Settings Wizard. These allow you to select TWAIN or ISIS scanning, whether images are displayed during scanning and more.
From the Scan menu you have the option to select your scanner, display or hide the scanner’s TWAIN/ISIS settings interface or have SimpleIndex prompt the user when the feeder is empty.
The Scan to File option in the Scan menu lets you separate the scanning from processing. Use this to scan a sample image and save directly to a file folder.
Related Pages
- Published in
Organize Office Documents with Text Parsing
This video shows the Sort My Documents sample job included with the SimpleIndex trial download. It shows how you can organize office documents automatically by parsing the file’s text for relevant metadata and keywords. You can then use those keywords to tag documents with metadata and create standardized folders and filenames.
First we sort Word documents, Excel spreadsheets and PowerPoint presentations automatically using the SimpleIndex template and dictionary matching algorithms that match patterns and keywords in the parsed text.
Then the files are organized into folders and filenames using the Sales Rep, Customer, Document Type and Date values extracted from the text.
Organize Office Documents for Cloud Storage
You can also upload organized files to SharePoint or Cloud Storage platforms without the chaos and disorganization you inevitably get when users create their own folders and filenames.
Organize Office Documents for Document Management
In the video, we use SimpleSearch to search and view the sorted files. But you can just as easily use any third party document management system or custom database to perform keyword or full-text searching.
You can use the SimpleView embedded viewer to view Office documents, PDF files and images in a common interface. In the video we use the full version of Word, Excel, and PowerPoint to edit Office documents right from the search screen.
Find Out More
- Download or get an Online Demo
- MS Office Text Processing Features in SimpleIndex
- MS Office Features and Settings Wiki Pages
- OCR Features and Settings Wiki Pages
- OCR Software Guide on SimpleOCR
FAQ Related to Organizing Office Documents
- Take control of Sales Tax exemption forms
- Exclude Index Field from Index Log
- Change the Font Size of Index Fields
- Large documents (>500 pg) Slow to Process - Workaround
- How to activate SimpleView?
- How to activate any Add-on or Upgrade to SimpleIndex?
- What is Document Imaging?
- Index With Non-Latin Character Sets
TWAIN and ISIS Scanning
SimpleIndex works with all TWAIN and ISIS document scanners.
Virtually all document scanners support both the TWAIN and ISIS driver standards. TWAIN is more common and is usually the only driver provided with consumer scanner models.
ISIS is the unfortunately named driver standard developed by Pixel Translations years before the acronym (which stands for “Image and Scanner Interface Specification”) had any jihadist connotations. ISIS provides a more standardized interface for high-speed scanners, and is often required to scan at the scanners rated speed.
TWAIN scanning is supported in all versions of SimpleIndex.
Support for ISIS is included with SimpleIndex Professional and available as an Add-on for other versions. ISIS is recommended for high-speed document scanners, or applications that require central management of scanner settings. ISIS driver settings are saved in your SimpleIndex job file so every user gets the exact scanner settings they need for each type of document.
What is a WIA Driver?
WIA stands for Windows Image Acquisition and is the driver standard promoted by Microsoft for basic scanning functions that don’t require additional software other than the Windows OS.
WIA is much better suited for flatbed scanners than for document scanning applications. While you can use the WIA driver in SimpleIndex, you will get much better results with the full TWAIN or ISIS drivers, which may require a separate download from your scanner manufacturer.
What Happens After You Scan?
The difference between SimpleIndex and other desktop scanning applications is that it fully automates the process of indexing and filing your documents once they are scanned. Use bar codes, OCR, database lookups and other features to identify keywords and metadata, organize files into folders, or populate your database and document management system.
Indexing is the key to making your scanned files organized and searchable so you can find them when you need them. Without automation, the indexing process can be very labor intensive, taking many times longer than it takes just to scan documents.
TWAIN & ISIS Scanning Video
Since scanning happens in the meatspace there’s really not a lot to show in a screen recording. But Google really likes videos so here’s a quick preview what it looks like when you’re scanning with SimpleIndex.
Unique Book & Magazine Scanning Features
SimpleIndex streamlines the process of scanning books and magazines. Anyone who commonly scans bound material needs SimpleIndex just for this feature!
Book scanning lets you scan bound books quickly on a flatbed scanner. The user is prompted after each scan so they only need to turn the page and press “enter” to perform the next scan. 2-page scans can be automatically split vertically or horizontally to create single page images.
When scanning a typical tabloid-sized magazine that is folded down the middle, SimpleIndex’s magazine scanning function will automatically split the images in half, reorder and rotate the pages so they appear in proper reading order when finished. This can save hundreds of hours of manual image QC, or provide your clients with a level of image quality they can’t get from anyone else.
Using Scanning in SimpleIndex
Wiki manual pages detailing the scanning functions of SimpleIndex.
KB Articles for TWAIN and ISIS Scanning
- What is Document Imaging?
- What scanners does SimpleIndex work with?
- I have a duplex scanner how do I set up SimpleIndex to scan 2 sided documents automatically?
- Can I scan with a Kofax Adrenaline based scanner interface?
- I have a scanner with Virtual ReScan (VRS) that is not scanning properly. How do I solve this issue?
- How can I change from letter to legal size documents?
- What scanners are compatible with SimpleIndex? How do I find a list?
- I finished scanning and found a page that did not get scanned or was scanned incorrectly. How can I correct this?
- How do I automatically delete blank pages from duplex documents?
Affordable Document Management
SimpleIndex® is a great solution for small businesses and departments that need a quick and affordable way to scan, organize and view documents. SimpleIndex provides a wide variety of retrieval options, many of which require no special software to find and view documents.
The most basic solution uses Windows folders and filenames to organize and find documents on a shared network drive or synced to a cloud storage platform.
SimpleIndex lets you use index field values to create folders and filenames automatically, automating the process with barcodes, OCR and database lookups where possible.
You can also use SimpleIndex with SimpleSearch to create a keyword-searchable database that lets you find and view documents based on one or more index values.
There are several advantages to using SimpleSearch instead of Windows folders:
- Find documents based on specific keywords or phrases
- Drop-down lists to select possible keyword values
- Use “And” and “Or” logic to search multiple field values
- Search the full text of OCR’d documents, Office and PDF files
- Search results are returned instantly
- Quickly browse through all matching files, even if they are in different folders
- Integrated file viewer with zoom, annotation, print and email functions
- Index data stored in a database and can be re-used for reporting and other applications
Integration with Third Party Document Management
SimpleIndex is able to integrate with Enterprise Document Management Systems using a variety of integration methods.
- SharePoint integration is built directly into SimpleIndex.
- Cloud Storage platforms like Google Drive, Box and OneDrive can be integrated via sync apps.
Output standardized and organized folders and filenames. Full-text search for Office and PDF files. - Popular document management systems like Digitech PaperVision and ImageSilo, Computhink Contentverse, Laserfiche, and others are supported out-of-the-box using SimpleExport to create custom import files.
- Integration with many other systems can be done via the default CSV data file format.
- If a custom import file format is required, SimpleExport can be configured to produce it.
Lowering the Cost of Document Management
Many small businesses are going digital with their documents. However, many also find that the document management systems available are too complex, expensive, or labor-intensive to be practical in a small office.
SimpleIndex was designed to solve this problem by removing many of the costly and cumbersome “gotchas” that make practical implementation of these systems impossible.
Here are some of the ways SimpleIndex saves you money:
- Standalone scanning, indexing & retrieval license starts at $500.
- No limitations on processing volume (“click charges”).
- Files are stored in standard formats using logical folders and filename structures
- Exported files can be synced any cloud storage platforms
- Key data is embedded in the file names and metadata tags to ensure they can be found without a third party database or app
- SimpleView provides both free and low-cost options to browse, search and view exported documents.
- SimpleSearch provides a client/server document management system with index field and full-text search for a minimal cost per workstation.
- SimpleIndex integrates with any custom database, allowing you to use existing infrastructure or free/open source database platforms instead of buying expensive licenses.
- SimpleIndex integrates seamlessly with most document and content management systems available on the market today. Leverage the low cost and enhanced feature of SimpleIndex as an alternative front-end for migrating documents to your DMS.
- SimpleIndex uses OCR, barcode recognition, database lookups and advanced pattern matching algorithms to automate the indexing and filing of captured documents. Combined with its streamlined workflow, SimpleIndex gives the highest level of automation you can get in this price range.
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?
Scanning & Document Migration for SharePoint
SimpleIndex gives you an affordable, automated way to populate custom metadata tags when migrating documents to SharePoint. SimpleIndex uses a variety of methods to extract data, including zone OCR, barcode recognition, mark recognition (OMR) and text pattern matching. The data is assigned to index fields that correspond to the custom columns in your SharePoint document library. The extracted values can be reviewed and corrected if necessary before uploading.
Uploading individual documents to SharePoint is easy. The hard part is migrating thousands of files and tagging them with custom metadata that can be used for fast, precise searching and sorting.
Without metadata, only the filename is used for searching scanned documents. OCR can be used to enable text searching of images, but there are several limitations to text searches:
- OCR cannot recognize any handwritten data
- Low quality scans or documents with complex layouts often OCR poorly
- OCR errors mean that you won’t always find all the files you are searching for
- Cannot perform date range or number range searches
- Cannot sort results by anything other than title and create/modified date
Advantages of the SimpleIndex SharePoint migration solution include:
- Complete document imaging solution as well as electronic document migration
- Advanced text pattern matching finds precise data in unstructured text
- Parse folder and file paths to find metadata values
- Unattended server processing mode available
- Easy yet powerful alternative to managed metadata services
- Far more features for the price than other SharePoint migration tools
KB Articles for SharePoint Migration
Video Demos
These videos demonstrate several ways SimpleIndex® can automatically index different types of documents. If you are new to SimpleIndex, watching these videos is the easiest way to see what it can do. You can follow along using the sample files included in the SimpleIndex Trial.
- Zone OCR with template matching
- Document barcode recognition
- PDF OCR text parsing
- Sort and index MS Office documents
- Indexing with full-text OCR
- Running jobs from an icon
The sample files are copied to your Configuration Folder when you run the SimpleIndex Trial for the first time. If you can’t find the samples, copy them with the Global Settings Wizard in the File menu.
Compare Major Scanning Solutions
Integrated Solutions Built with SimpleIndex
Zone OCR with Template Matching
Document Barcode Recognition
PDF OCR Text Parsing
Sort and Index MS Office Documents
Full Page OCR Invoice Processing
KB Articles for Optical Character Recognition
- Language Pack for Standard/Tesseract OCR
- Languages Supported in SimpleSoftware OCR Engines
- What is Document Imaging?
- Change the Dictionary Separator Value
- Change the OCR Font or Type
- Regular Expression (RegEx) - Syntax or Type
- Autonumber Increment Value
- I'm using full page OCR. The information is all appearing in the txt file but it is losing format about half way through. Data to the right is ending up at the end of the txt doc. Can this be fixed?
- Is there a way to just use part of a bar code or OCR value? For example, extract "50" from the value "124450"
- If I have a form which is filled manually by hand, can SimpleIndex read the data from it?
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 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
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?
- 1
- 2