Use export templates to export ACTIVE Net's financial and transaction data so that it can be imported into your organization's main system.
Each export template includes a header and one or more columns. You can specify rules for each column to determine how the information is displayed so that it can be properly imported into another application.
Export Templates Header List page
Change Export Template Header page
Change Export Template Detail for Export page
Change Export Translation Rule page
Administration > Financial Settings > Export Templates
From the Export Template page, click Import Template to open the Import Template page, where you can select a file to import.
From the Export Template Header List page, click Add New to go to the Change Export Template Header page, where you can create a new header.
From the Export Template Header List page, click an underlined Name to display the Change Export Template Header page, where you can make any necessary changes.
The following options are included on the Export Templates Header List page:
Name | Type | Description |
General |
||
Name |
Hyperlink |
Click this link to go to the Change Export Template Header page, where you can modify an existing export template header. |
Base Type |
Text |
View the base type for the export template:
|
Output Type |
Text |
Output type of the export template:
Note: You can override output type when you perform the export. |
Export Type |
Dropdown list |
The export type of the export template:
Note: You can override the export type when you perform the export. |
Actions |
||
Details |
Hyperlink |
Click this link to go to the Export Template Detail List page, where you can add column and increment details. |
Copy |
Hyperlink |
Click this link to go to the Change Export template Header page, where you can modify export template header details. |
Export |
Hyperlink |
Click this link to select where to export the file into your system. |
The following options are included on the Change Export Template Header page:
Name of Field | Type | Description |
Name |
Text |
The name of the export template. Required. |
Record ID |
Read only |
System-assigned record ID of the export template, to be used only by the polling application for triggered exports. |
Output Type |
Dropdown list |
The default output type of the export template:
Note: You can change the output type when you perform the export. |
Header Row Template |
Dropdown list |
Select the template for the header (first row) to determine its formatting. |
Trailer Row Template |
Dropdown list |
Select the template for the trailer rows (all rows below the header row) to determine their formatting. |
Export Type |
Dropdown list |
The default export type of the export template:
Note: You can override the export type when you perform the export. |
Base Type |
Dropdown list |
Select the basis for the export template:
|
Include Detail Header? |
Checkbox |
Option to include the detail header.
If this option is checked, then the first line of the export template is header text.
If this option is not checked, then the first line of the export template is the first line of data. |
From the Export Template Header List page, click the Details link of a header to go to the Export Template Detail List page.
From here, click Add New to go to the Change Export Template Detail for Export page, where you can create a new record.
From the Export Template Header List page, click the Details link of a header to go to the Export Template Detail List page.
From this list, click a Column to display the Change Export Template Detail for Export page, where you can make any necessary changes.
The following options are included on the Change Export Template Detail for Export page:
Name of Field | Type | Description |
Contents | Dropdown list | Name of the raw data element or field in the database tables
that can be included in the export.
Select User Defined to define a new field/column that is not in the database. |
Header Text |
Text |
The first line of the export template.
This only appears as header text if the option to Include Header Detail is selected.
If this option is not selected, then the first line of the export template is the first line of data. |
Text |
Text |
If User Defined is selected from the Contents list, then the name of the new field/column value is defined here. |
Prompt for Value? | Checkbox | If User Defined is
selected from the Contents
list, then the value can be prompted at the time the export is
generated.
You can use this to record the name of the person running the export or the day the export was run. |
Column Order | Numeric | The order in which the columns are outputted.
Entries with the same column order number are outputted in the order they were entered when creating the export template. |
Column Width | Numeric | The column width to be used for fixed length exports. |
Absolute Value? | Checkbox | Option to show all numbers as positive.
This is commonly used to switch credit and debit values from ACTIVE Net by creating a leading or ending minus sign to show negative value in a separate field. |
Math Operator | Dropdown list | Choice of operator to apply to contents.
Includes Math Operations and Left or Right subset options. |
Operator Value | Numeric | Number to complete the operation started with the math operator.
A common example is to multiply a number by 100 to eliminate decimals. Also used to define the number of characters to print using left, right or subset strings. |
Substring | Numeric | Subset character to print in addition to string defined by math operator above. |
Qualifier | Text | Character to print before and after contents.
Typically this is a " to deal with comma delimited export templates, or it is left blank. |
Format | Text | Enter a numbering format.
This affects the date and time, and numeric fields.
You can enter the name for a standard template:
Alternatively, you can enter a custom format using any combination of the following characters:
Note: The actual character displayed is location-specific (for example, a period in North America, but a comma in Europe).
Note: The actual character displayed is location-specific (for example, a comma in North America, but a period in Europe).
For date formats:
For example: November 26th, 2009
|
Trim Rules |
Dropdown list |
Trim rules determine how values are formatted when you create the financial export.
For example: If a string=" abc "
If a field length is ten character spaces, for example "abcdefghij", and you just enter four character spaces "abcd", then:
|
Custom Question |
Dropdown list |
Custom question.
This field only appears if one of the following choices is selected from the Contents list:
|
Name Format |
Dropdown list |
Select the order to display first and last names for columns that include a full name. |
Increment Details(enabled only if User Defined is selected in the Contents list) |
||
Increment Column |
Checkbox |
Option to automatically specify the value of the column for each record exported, starting with the Increment Start value for the first record, and incrementing the value for each succeeding record by the Increment Step value.
For example, the first record exported may be assigned the value of 100, and with an Increment Step value of 1, the next exported records will have the values of 101, 102, and so on. |
Increment Start |
Numeric |
The initial value of the column that is assigned to the first record exported. |
Increment Step |
Numeric |
The value to add to the column for each succeeding record exported. |
To add new column translation rules
From the Export Template Header List page, click the Details link of a header to go to the Export Template Detail List page.
From this list, click the translation Rules link next to a particular column to display the Export Template Detail List page.
From here, click Add New to go to the Change Export Translation Rule page, where you can create a new record.
To modify column translation rules
From the Export Template Header List page, click the underlined Details link of a header to go to the Export Template Detail List page.
From this list, click the translation Rules link for a column to display the Export Template Detail List page.
From here, select an underlined Source Value link to display the Change Export Translation Rule page for this column rule, where you can make any necessary changes.
The following options are included on the Change Export Translation Rule page:
Name of Field | Type | Description |
Source Value |
Text |
Leave as default If Column Data Is. |
Operator |
Dropdown list |
The operator to be used for comparison, as selected from =, >, <, >=, <=. |
Comparison Value |
Text |
Value expected to be returned from the database. |
Translated Value |
Text |
Desired value to export instead of database value. |
For example:
If the payment types are number coded where 1 means Cash, 2 means Check, etc., and you would like to have the words exported instead of the number codes, the rules would be configured for the Payment Type column as such:
Source Value | If Column Data Is |
Operator | = |
Comparison Value | 1 |
Translated Value | Cash |
Source Value | If Column Data Is |
Operator | = |
Comparison Value | 2 |
Translated Value | Check |
Note: The number of rules depends on the number of codes (for example: 3 = Credit Card, 4 = Credit Memo, etc).