Click the New icon in the toolbar to save the current export specification and then clear the page making it ready for a new item.

Click the Save icon in the toolbar to save the current export specification and return to the export specifications listing.

Click the Save As icon in the toolbar to save the current export specification to a new name. You will be prompted to enter a new name. Click OK to save the export to a new name and then continue editing the export. Click Cancel to return to the existing export without saving.

Click the Delete icon in the toolbar to delete the current export specification. You will be prompted with a "Are you sure you want to delete?" dialog. Clicking Yes will permanently delete the export and then return to the export specifications listing. Click Cancel to return to the existing export without deleting.

Click the Test icon in the toolbar to test an export. Testing an export will perform a sample data extract using all of the information entered on the export specification and then outputs the results to the screen where it can be viewed and validated. Typically a test is performed to ensure that the correct data fields are being extracted and all data conversions, formats, and formulas are working correctly.

After clicking the Test icon, you will see a dialog requesting additional information:

• Export file to test: Select one of the export data files to use in the test. The first export data file entered is selected by default. Note, this prompt will only be available if multiple data export files have been entered on the export specification.

• Sample Number of records: Defaults to 100. This number determines how many records are processed and exported to the screen.

• Record IDs to export: If you want to test individual records, enter one or more item ids. Entering a value here overrides the sample number of records.

• Export Format: Select the export format for viewing the test data. 
   

tip

WidgetTip

Select MultiValue to view the exported data in a detailed data view which shows the data for each field in its native MultiValue format (including value and sub-value delimiters) and without processing it through formats, conversions, etc. This is very useful if you need to see exactly what exported data looks like, which may help you understand why the export format, conversions or formulas are not working. 

Click the OK button to view the export results or click the Cancel button to return to the Export Specification page.

 

note

WidgetNote

For this feature to work correctly you will need to: 1) Add the Kourier website as a trusted site so pop-up dialogs appear and 2) enable the automatic prompting for downloads option in your browser's internet options (e.g., for Internet Explorer this setting is found in Security | Custom Level dialog). 

To see the runtime statistics for an individual export, click the Statistics icon from the toolbar. This will take you to the Export Statistics listing which displays all export statistics that have been captured for the export.

To create the DDL from a SQL export specification, you may click the DDL button from the tool bar. Once the DDL has been created a dialog appears allowing you to view the DDL. This feature is useful when you need to only create the DDL for an single export instead of all of the exports associated with a master file.

To create the SSIS Package from a SQL Export Specification, you may click the Generate Package button from the tool bar. Note, your current SQL Export Specification will be saved before you can create the SSIS package. This will open a new Generate SSIS Package page where you will be asked to enter a number of parameters before the SSIS package can be generated.   

Click the Help balloon to open the help for this page.

Field Name

Description - Usage - Notes

Name

Enter a unique name for the export. By convention, exports are named using an Integration ID such as KS for KommerceServer, followed by an underscore and a string that describes its purpose (e.g., KS_CONTACTS). 

Title

Enter a short descriptive name for this export. This name is displayed in on-line lookups.

Last Update

Display only field, shows the last date/time that the export specification was saved.

Note

Enter a free form comment or note for this Export Specification. If a note is entered, a small icon will display on the Export Specification listing. Hovering your mouse over the icon on that listing will display about 40 characters of the note for quick reference.

Last Package Generation

Display only field, shows the last date/time that the associated SSIS package was successfully generated for this export specification.

Source File Mask

This field is very important because it determines which files in the export "inbox" will be selected for processing. Enter a file mask that best describes the file names / pattern that you will be processing. You can use literals and wildcards the same as UniBASIC does. Refer to the UniBASIC operator "MATCHES" for more information.

tip

WidgetTip

If you had file names that follow a pattern such as: Location01.csv, Location999.csv, etc., you could use a file mask like this to select and process those files: "Location"0X".csv" where Location is a literal, 0X, and ".csv" is the literal file extension. 

 

Source File Format

Enter the format of the export file to be processed:

Text Qualifier

Select the text qualifier that best describes how text values or strings are identified within the file: None, Single Quote (') or Double Quote ("). 

First Row Contains Column Names

Enable this checkbox if your import file has a row at the beginning of the document that includes the column names. This will cause the first row to be skipped during processing. 

Row Delimiter

Select the row delimiter that best describes rows are identified within the file:

1. {CR}{LF}: Carriage return and Line Feed
2. {CR}: Carriage return only
3. {LF}: Line Feed only

Target SQL Table

Enter the name the SQL Server table to be used as the destination of the exported data. This name will be used in any DDL that is generated and when generating SSIS packages for this export.

 Export Options

Enter any valid export options.