Configuration File Nodes

Configuration file nodes are nodes found in a lookup table configuration file.

<FileImport>

Specifies the root element of the configuration file.

Attribute

Value

Version

Version of the configuration file uploaded. Used by the Marketing Warehouse to process versions that are still currently supported.

<ImportFile Version="1.1">

<Account>

Identifies your Webtrendsaccount and the profile to which the lookup table belongs.

Table 1. <Account> Required Attributes

Attribute

Value

ID

The ID attribute value is always "1".

ProfileFileName

Enter the values for "ProfileFileName" from the Profile Summary screen in Administration > Profiles > Summary. To load multiple profiles, provide the profile IDs separated by commas within the quotation marks. For example:

<Account ID=”1” ProfileFileName=”AVEqrAMcf45,iSTJxuiH8i7,sN7kOGMr9a4”>

<Account ID="1" ProfileFileName="K729vc8Qqj5">

<FileType>

Specifies the file type of the data file. The value is always “flatfile”.

<FileType>flatfile</FileType>

<ImportType>

<ImportType>merge</ImportType>

Specifies how data is imported to your lookup table. Supported values are merge, delete, and insert.

<PurgeExistingData>

Specifies whether to delete all existing data in the lookup table before importing new data. Supported values are true and false. This function is only valid with the merge and insert <ImportType>.

<PurgeExistingData>false</PurgeExistingData>

<PurgeExistingData>true</PurgeExistingData>

<ColumnDelimiter>

Specifies the character used to separate columns in your data file.

<ColumnDelimiter>,</ColumnDelimiter>

<ColumnDelimiter>_</ColumnDelimiter>

<EmailNotificationList>

Specifies a semicolon-delimited list of email addresses for sending success or failure notifications. You can enter as many email addresses as you like.

<EmailNotificationList> poweruser@webtrends.com;admin@webtrends.com </EmailNotificationList>

Note:

A value is not required for <EmailNotificationList>, but email notification is the simplest way of keeping track of your imports without monitoring your Warehouse data import directory and lookup tables directly. Email notifications also contain important information about import errors.

<File>

Contains the <FileName> node, which specifies the file name of the data file.

<FileName>

Specifies file name of the data file. The ImportTable attribute specifies the name of the lookup table to which the data is imported.

Table 2. <FileName> Required Attributes

Attribute

Value

ImportTable

The name of the lookup table to be updated.

<FileName ImportTable="LookupTest01">LookupTest00.txt</FileName>

Configuration File Example>
<?xml version="1.0" encoding="utf-8"?>
<FileImport Version=”1.1”>
  <Account ID="1" ProfileFileName="K729vc8Qqj5,AVEqrAMcf45,iSTJxuiH8i7,sN7kOGMr9a4">
    <FileType>flatfile</FileType>
    <ImportType>merge</ImportType>
    <PurgeExistingData>false</PurgeExistingData>
    <ColumnDelimiter>,</ColumnDelimiter>
    <EmailNotificationList>poweruser@webtrends.com;admin@webtrends.com </EmailNotificationList>
    <File>
     <FileName ImportTable="LookupTest01">LookupTest00.txt</FileName>
    </File>
  </Account>
</FileImport>