To properly display this page you need a browser with JavaScript support.
×
Menu
Index
Search
1. Introduction
2. ChronoScan ADVANCED/PROFESSIONAL Minimal System Requirements
3. ChronoScan Capture Applications
3.1. Technical Support
3.2. How To & Video Tutorials
3.2.1. Extracting Data from PDF Files to CSV/XLS
3.2.2. Data Capture from Invoices
3.2.3. Fast Field Definition Mode
3.2.4. Complex PDF Report Data Extraction and XML Export Tutorial
3.2.5. Direct Database lookup
3.2.6. Document split using IDR
3.2.7. Barcode Separation in Several Fields
3.2.8. Barcode Read for Several Codes
3.2.9. Document Split Using Subtypes
3.2.10. Scanning and Importing Images
3.2.10.1. Job and Batch Creation
3.2.10.2. Scanning From Twain Scanners
3.2.10.3. Importing Image Files
3.2.10.4. Barcode Reading
3.2.10.5. Document Split Using Barcodes or PatchCodes
3.2.10.6. Blank Page Detection
3.2.11. Exporting Batches
3.2.11.1. Configure Image and Data Output
3.2.11.2. Conversion Export Modules
3.2.11.2.1. ChronoScan PDF Conversion Export Module
3.2.11.2.2. Ghostscript PDF Conversion Export Module
3.2.11.2.3. Multipage Tiff Conversion Export Module
3.2.11.2.4. Nuance PDF Conversion Export Module
3.2.11.2.5. ODBC Conversion Export Module
3.2.11.2.5.1. ODBC Export to Several Tables
3.2.11.2.6. TXT Conversion Export Module
3.2.11.2.7. XML Conversion Export Module
3.2.11.2.8. Extended XML Conversion Export Module
3.2.11.3. Destination Export Modules
3.2.11.3.1. Azure Storage Destination Export Module
3.2.11.3.1.1. Azure Storage Blob upload using OAuth2
3.2.11.3.2. ChronoScan Document Routing Destination Export Module
3.2.11.3.3. CMIS Destination Export Module
3.2.11.3.4. Filesystem Destination Export Module
3.2.11.3.5. FTP Server Destination Export Module
3.2.11.3.6. Google Docs Destination Export Module (DEPRECATED)
3.2.11.3.7. Google Drive™ Destination Export Module
3.2.11.3.8. M-Files Destination Export Module
3.2.11.3.9. ShareBase Destination Export Module
3.2.11.3.10. SharePoint Server Destination Export Module
3.2.11.3.11. SMTP Destination Export Module
3.2.11.3.12. Extended SMTP Destination Export Module
3.2.12. Processing Batches
3.2.12.1. Language Detection
3.2.12.2. Intelli-Tag Processing
3.2.13. Manual Document Split
3.2.14. Split Documents Using PatchCode and Barcode
3.2.14.1. Splitting Documents Using Barcode
3.2.14.2. Splitting Documents Using PatchCode
3.3. Articles
3.3.1. How To Install ChronoScan on Windows XP SP2
3.3.2. ChronoScan Scripting Module – Added Scripting Capabilities to ChronoScan
3.3.3. Optimizing VBScript Database Connection Speed
3.3.4. V1.0.0.40 Now With Alfresco Document Scanning and CMIS Support Added
3.3.5. ChronoScan OCR Languages Support
3.3.6. Creating Text Searchable PDF
3.3.7. Export Captured Data and Documents to SharePoint
3.3.8. PDF Data Extraction
3.3.9. Export data to TXT
3.3.10. Import PDF Files
3.3.11. PatchCode Samples
3.3.12. License Activation and Deactivation
3.3.12.1. License Deactivation
3.3.13. Using CMIS with a Proxy Server
3.3.14. M-Files Integration Articles
3.3.14.1. M-FILES Import module
3.3.14.2. M-FILES Export Guide
3.3.14.3. M-FILES - Link Scanned Documents to an Existing M-FILES Object
3.3.14.4. Working with M-FILES Value Lists
3.3.14.5. Adding Documents to M-FILES Objects Linked to an External Database
3.3.14.6. Exporting values to value lists fields
3.3.15. User Mode
3.3.16. ChronoScan Personalization
3.3.17. Keyboard Accelerators Cheat Table
3.3.18. Automatic Learning Document Types and Zones
3.3.19. Using Lists
3.3.19.1. Value List on Database
3.3.19.2. Web Options for Help Lists
3.3.20. Batches Panel
3.3.21. How to Improve OCR Results and Reliability
3.3.22. How to Back Up ChronoScan
3.3.22.1. SQL Database Backup for Enterprise
3.3.23. Creating Language Specific Intelli-Tags
3.3.24. Masterkey Setup Guide
3.3.25. Advanced sFTP Export Using Custom Commands and cURL
3.3.26. Nuance 2.0 ICR Engine (Handwriting)
3.3.27. General Job Workflow
3.3.28. Checkbox Detection with Data Grids
3.3.29. Barcode Scanning - General Guidelines
3.3.30. Merging Documents With the Same Barcode Value
3.3.31. Converting an Existing Setup to Use Masterkeys
3.3.32. Using Multiple Launch Configurations
3.3.33. Using a Remote Configuration
3.3.34. ChronoScan and ODBC Database Connections
3.3.35. Getting the GUID and/or the Document Size
3.3.36. Using Office 365 Accounts for Email and Sharepoint Integration
3.3.37. Google Cloud Integration. (Google Vision OCR and Google Geolocation API)
3.3.38. Google Document AI for invoice processing
3.4. ChronoScan Core Concepts
3.4.1. OCR/ICR – Optical/Intelligent Character Recognition
3.4.2. Documents
3.4.3. Document Type
3.4.4. Barcodes
3.4.4.1. Barcode Read
3.4.4.1.1. Barcode Reading Settings
3.4.4.1.2. BARCODE Trigger Settings
3.4.4.1.2.1. BARCODE Triggers Window
3.4.4.1.2.1.1. Select Barcode Window
3.4.4.1.2.1.2. Creating Barcode Actions
3.4.4.1.2.2. VBScript Editor Window
3.4.5. PatchCodes
3.4.5.1. PatchCode Scanning and Importing
3.4.5.1.1. PatchCode Split on the Job Wizard
3.4.5.1.2. PatchCode Split on the Job Administration Window
3.4.6. Jobs
3.4.6.1. Job Wizard
3.4.6.1.1. Options
3.4.6.1.1.1. Generate Accounts Payable Application Window
3.4.6.1.1.1.1. Import Validation Mask/Values
3.4.6.1.2. Document Split
3.4.6.1.3. Data Fields
3.4.6.1.4. Output Settings
3.4.6.1.5. Summary Window
3.4.6.1.6. Job Administration Window
3.4.6.1.6.1. Select Image Window
3.4.6.1.6.2. Available Output Modules Window
3.4.6.1.6.3. Available Format Modules Window
3.4.6.1.6.4. Additional Image Processing Modules
3.4.6.1.6.4.1. Grid Cutter
3.4.6.1.6.4.2. Standard Document Rotation
3.4.6.1.6.5. Job Maintenance
3.4.7. Batches
3.4.8. Input Modules
3.4.8.1. Input Module Settings
3.4.8.2. Add PDF File Window
3.4.9. Output Modules
3.4.10. Data Fields
3.4.10.1. Data Field Properties
3.4.10.1.1. Data Field Types
3.4.10.1.2. Set Input Mask
3.4.10.1.3. Validation Functions
3.4.11. OCR Zone
3.4.11.1. Advanced OCR Zone Reading
3.4.11.1.1. Advanced Data Extraction
3.4.11.2. Default Properties for OCR Zones
3.4.12. OCR Triggers
3.4.12.1. OCR Trigger Properties
3.4.12.2. Report Split
3.4.12.3. Trigger Split
3.4.13. Intelli-Tags
3.4.14. Capture Grid and Modules Panel
3.4.14.1. Grid Configuration
3.4.14.1.1. Custom Grid Capture
3.4.14.2. Grid Creation
3.4.14.3. Grid Column and Row Setup
3.4.14.3.1. Row Height Window
3.4.14.3.2. Set Custom Column Height Window
3.4.14.3.3. Carriage Return Detection
3.4.14.4. Grid Menu Setup
3.4.14.5. eXtra Panels Settings
3.4.15. HotFolder Tasks
3.4.16. OCR Engines
3.4.17. Generative AI integration (OpenAI)
3.4.17.1. Example prompts for basic invoice processing application.
3.4.17.2. Fine-tuning OpenAI models with ChronoScan applications
3.5. ChonoScan Main Interface
3.5.1. ChronoScan Welcome Screen
3.5.1.1. License Manager
3.5.1.1.1. Activate License Window
3.5.1.1.2. ChronoScan License Manager Web Page
3.5.1.2. ChronoScan Launcher
3.5.2. Views and Panels
3.5.2.1. Triggers Panel
3.5.2.2. Object Properties Panel
3.5.2.3. Form View
3.5.2.3.1. Database Search Window
3.5.2.3.1.1. Database Navigator Window
3.5.2.4. Data Modules Panel
3.5.2.4.1. Lookup Viewer
3.5.2.4.1.1. Database Lookup Field Properties
3.5.2.4.2. XLS Extract
3.5.2.4.2.1. XLS Mapping Tool
3.5.2.4.2.2. Currency Translation
3.5.2.5. Grid View
3.5.2.5.1. Field Chooser
3.5.2.5.2. Set Document Status Window
3.5.2.5.3. Search and Replace Window
3.5.2.5.4. Search Column to Find Duplicates Window
3.5.2.6. Document Type Panel
3.5.2.6.1. Document Type Panel - Types
3.5.2.6.2. Notes Window
3.5.2.7. Preview Panel
3.5.2.8. Keyboard Panel
3.5.2.9. eTags Panel
3.5.2.10. External Data Viewer Panel
3.5.3. Scan/Input Tab
3.5.3.1. Batches Toolbar
3.5.3.1.1. Create Batch Window
3.5.3.1.1.1. Search Document Types
3.5.3.1.2. Open Batch Window
3.5.3.1.3. Execute Output Window
3.5.3.1.3.1. Add Output Window
3.5.3.1.3.2. Link Module Window
3.5.3.1.3.3. Output Report Window
3.5.3.2. Documents and Image Input Toolbar
3.5.3.2.1. Document Split Options
3.5.3.2.1.1. Barcode Document Split Configuration Window
3.5.3.2.2. Blank Page Detection
3.5.3.2.2.1. Blank Page Detection Settings
3.5.3.2.3. TWAIN Scan Input Module
3.5.3.2.3.1. Select TWAIN Source window
3.5.3.2.3.2. Other Options Window
3.5.3.2.4. Import Images Input Module
3.5.3.2.5. Import PDF Files Input Module
3.5.3.2.6. Generate Images Input Module
3.5.3.3. Document Toolbar
3.5.3.3.1. Process and Tasks Settings Window
3.5.3.3.1.1. On Process Tasks
3.5.3.3.1.1.1. OCR Processing Options
3.5.3.3.1.1.2. eTags Configuration Window
3.5.3.3.1.2. On Process Finish Tasks
3.5.3.3.2. Image Processing Window
3.5.3.3.3. OCR All Pages Window
3.5.3.3.4. Document Types Menu
3.5.3.3.4.1. Advanced Document Type Detection Menu (Masterkey Jobs)
3.5.3.3.4.1.1. Job Document Types Window
3.5.3.3.4.2. Masterkey Administration Menu
3.5.3.3.5. Filter by Image Size Window
3.5.3.3.6. Actions Menu
3.5.3.3.7. Tasks & Process Window
3.5.3.3.7.1. On Input Tasks
3.5.3.3.7.2. On Input Finish Tasks
3.5.3.3.7.3. On Export Begin Tasks
3.5.3.3.7.4. On Export Finish Tasks
3.5.3.4. Views Toolbar
3.5.3.4.1. Cursors Menu
3.5.3.4.2. Panels Menu
3.5.3.5. Help Toolbar
3.5.3.6. Style Menu
3.5.3.7. About Window
3.5.3.7.1. Update Manager
3.5.3.8. Customizable Buttons
3.5.3.8.1. Examples for Customizables Buttons
3.5.4. Data Entry Tab
3.5.4.1. Batch Operations Toolbar
3.5.4.2. Document Type Read Configuration Toolbar
3.5.4.2.1. Document Type Menu
3.5.4.2.1.1. Share Document Type Window
3.5.4.2.1.2. Document Types Manager Window
3.5.4.2.2. Intelli-Tag Manager Window
3.5.4.2.2.1. Add Value to Intelli-Tag Window
3.5.4.2.2.2. Create New Intelli-Tag List
3.5.4.2.3. OCR Trigger Assistant - Subtype
3.5.4.2.4. OCR Trigger Assistant
3.5.4.2.5. Object Properties Menu
3.5.4.2.6. Intelli-Tag Tools Window
3.5.4.3. Image Overlays Toolbar
3.5.4.4. OCR Tools Toolbar
3.5.4.5. Views Toolbar
3.5.4.6. Help Toolbar
3.5.4.7. Document Navigation Panel
3.5.5. Administration Tab
3.5.5.1. Jobs and Batches Toolbar
3.5.5.2. Configuration Parameters ChronoScan Window
3.5.5.2.1. Global Variables Window
3.5.5.2.1.1. New Element Window
3.5.5.3. Databases Toolbar
3.5.5.3.1. Database Connections Window
3.5.5.3.1.1. Data Link Properties Window
3.5.5.3.2. External Data Import Window
3.5.5.3.3. Intelli-Tag Import Configuration Window
3.5.5.3.3.1. Import Intelli-Tags from DB Window
3.5.5.3.4. Value List Window
3.5.5.3.4.1. Value List on Database Window
3.5.5.4. ChronoExDBNavUI - External Data Panel Configuration
3.5.5.4.1. Edit SELECT Statement
3.5.5.4.2. Edit INSERT Statement
3.5.5.4.3. View Column Options
3.5.6. Tasks/HotFolder Tab
3.5.6.1. Quick Options Toolbar
3.5.6.1.1. Console Window
3.5.6.1.2. Task and Notifications Window
3.5.6.2. HotFolder Toolbar
3.5.6.2.1. HotFolder Configuration Window
3.5.6.2.1.1. Variables Wizard Window
3.5.7. Description of Status Icons
3.6. ChronoScan Scripting Model
3.6.1. Objects
3.6.1.1. ChronoApp
3.6.1.2. UserField
3.6.1.3. DocType
3.6.1.4. ChronoBatch
3.6.1.5. ChronoDocument
3.6.1.6. ChronoExtDBViewer
3.6.1.7. HubGEOAPI
3.6.1.8. ChronoJob
3.6.1.9. UserButton
3.6.2. Scripting - Sample VBScripts
3.6.2.1. Lookup Fields From an External Database Using Scripts
3.6.2.2. Filling a Help List From an External Database
3.6.2.3. Set Default Field Values for Detected Document Types
3.6.2.4. Running a VBScript in Daemon Mode
3.6.2.5. Validating a Field Using an External Database
3.6.2.6. Showing an Options List Using VBScript
3.6.2.7. Invoking Web Services from VBScript Events
3.6.2.8. Export Zone Bitmap from a Capture Grid Control After Export with VBScript
3.6.2.9. Validate Fields in VBScript Using Field Value Comparison and Regular Expressions (Dual OCR)
3.6.2.10. Execute a Program and Wait Until it Finishes
3.6.2.11. Sum a Capture Grid Column
3.6.2.12. Using Custom Buttons to Split and Set Types
3.6.2.13. Checking for Batches that Failed Exporting
3.6.2.14. Validate Line Items Using Colors
3.6.2.15. Removing Old Batches from the System Automatically
3.6.2.16. Regex Match/Replace
3.6.3. Executing ChronoScan on Command line
3.6.3.1. Using Command Line Parameters on VBScript
3.6.4. Executing VBScript Before/After Export
3.6.4.1. Insert/Update Records on a Database After Export
3.6.5. Sending Email on HotFolder Events using VBScript
3.6.5.1. Send Email on Error (OnProcessFinish)
3.6.5.2. Send Email on Errors (OnExportFinish)
3.6.5.2.1. ExportStatus for Batches
3.6.5.3. Sending Email Through Gmail SMTP Server
3.6.5.4. Send Selected Document via Email Using a Customizable Button
3.7. ChronoScan Webinar
Search
Search
Search
Search
3. ChronoScan Capture Applications
3.5. ChonoScan Main Interface
3.5.5. Administration Tab
3.5.5.4. ChronoExDBNavUI - External Data Panel Configuration
3.5.5.4.2. Edit INSERT Statement
Previous page
Next page
To properly display this page you need a browser with JavaScript support.
3.5.5.4.2. Edit INSERT Statement
Here the insert statement for the selected view can be set. Make sure the statement has all of the arguments that you will need.
Go to ChronoScan WebSite
