Exporting to CSV
To export the processed documents to CSV format, press the drop down arrow of Export button at the lower left corner of the program and choose Character Separated Values (CSV). Once a format has been chosen its name will appear into the Export button.
Export settings for CSV
Go to Tools->Settings->CSV Export in order to set export settings.
Export mode: The user can either export all files into a single CSV file (All files in single CSV) or export each file from their session into a separate CSV (Separate CSV for each document);
CSV Export folder: The user can set where all exported CSV files will be stored. Once this folder is set the software will remember it until it’s changed by the user.
CSV Path Expression: The user can use different macros in order to name exported files after values assigned into fields and columns. This option is very useful for grouping files too. For example, the user can have a separate folder for each vendor, then group files by month inside that folder and use the invoice number for a file name. To achieve this, the Export Path Expression must be set as:
Separator character: Can be used to set what kind of separator to use in the CSV.
Date Format: Can be used to set what kind of date format to be used in the CSV, no matter of how it looks like on the invoice. Check “use system format” in order to use the currently selected format of your Windows OS.
Table export: When there are line items in the field form, this option can be used so that the CSV displays the line items data either vertically (new row for every table row) or horizontally (all table data in a single row).
Display fields header row – If checked this option will include the field names as headers into the CSV file.
Header row on every document – If checked this option will include a separate header row for each new document in the session view. This option works only if the “new row for every table row” is selected.
Include source file path – If checked this option will include an additional column with the source file path for each file in the session view.
Include archive file path - If checked this option will include an additional column with the archive file path for each document in the session view. Works only if the Archive feature is active.
Copyright ©, SmartSoft. All rights reserved.