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