Log in
Register
Shopping Cart
English
Nederlands
español
français
italiano
Deutsch
Português
svenska
русский
BRL
EUR
GBP
INR
USD
Help & Info
|---Activation
|---Documentation
Help & Info
Activation
Documentation
Detailed Plugin Information
|---Automatic File Namer
|---|---File name generation
|---|---Error Case
|---|---Backup Copy
|---|---Counter
|---Auto File Import
|---|---Operating Mode
|---|---File Import
|---|---File Backup
|---|---Error
|---Barcode Recognition
|---|---Recognition
|---|---Action Script
|---|---Auto Orientation
|---|---Repeater
|---|---User Interface
|---Batch Separation
|---|---Separation
|---|---Advanced
|---|---User Interface
|---Data Exporter
|---PDF Import
|---OCR
|---SMTP
|---|---SMTP Server
|---|---SMTP Message
|---|---SMTP Attachment
|---|---SMTP Advanced
|---Document Profile Selector
|---Page Stamper
|---File Print
|---Device Profiles
|---Exhibit
|---Supervisor
|---Digital Signature
|---WebDAV
Detailed Plugin Information
Expand all
Collapse all
Data Exporter
Introduction
Icon
The Data Exporter is used to export information such as barcode values, data captured from OCR zones or any other ScanToPDF variable or syntax into an external file.
File types supported
TXT, CSV, XML and SQL data export.
1. Exported file path
Enter a full path to the file where exported data will be saved.
2. Auto create folder
Check this option to enable ScanToPDF to create folders automatically if required.
Useful when the exported file path contains variable data (such as dates and times)
3. File type
Choose the file type for the exported data file.
Options available
TXT - Text file
CSV - Comma Separated Values file
XML - eXtensible Markup Language file
4. If file exists then
Choose an option to be used when a file with the same name already exists.
5. File encoding
Choose a method of file encoding from the drop down box
ASCII
Unicode
UTF7
UTF8
UTF32
Big Endian Unicode
6. Data block expression
Enter an expression used for the line in the exported file.
For example
{Date():dd-MM-yyyy}, {OutputFilePath}, {GetBarcodeText()}, {ImportFilePath}
7. SQL TAB - Connection string
Enter a SQL connection string for making connection to your SQL compliant database.
Sample connection strings are available from this
external
website - https://www.connectionstrings.com/
Example
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\MyPc\Documents\scantopdf.accdb;Persist Security Info=False;
8. SQL TAB - Run the SQL update asynchornously
Check this option to have the SQL update run in real time and not in the background.
Setting this option can slow the scanning process down, depending on the speed of the database connection and the update being made.
9. SQL TAB - SQL Statment
Enter the SQL statement required to insert records into your SQL compliant database.
Example
INSERT INTO [Records]
(
[FirstName],
[LastName],
[OutputFilePath],
[PageCount]
)
VALUES
(
'John',
'Jones',
'{OutputFilePath}',
'{Document.IncludedPageCount}'
)