Data Import File Format

The Data Import Utility allows you to import data into Emplifi Agent from a text file. The column names and values are separated by tabs. When the header row is displayed, an administrator can reorder the columns as needed. If the header row is not displayed, then the columns are shown in the default order.

Each table name is listed below. Select the table name to view the default column order. Some examples of results are also included.

Category Code Migration

Column Order

The Category Code Migration columns are:

• company_id

• category_id

• target_category_id

• code

• target_code

Example of Results

This is an example of the Category Code Migration log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

Category Migration

Column Order

The Category Migration columns are:

• company_id

• category_id

• target_category_id

• migration_sequence

• migration_type

• migration_when_type

• code_offset

• code_length

• date_added

• added_by_user_code

• date_changed

• changed_by_user_code

• web_service_id

• web_service_operation

• web_service_target_namespace

• web_service_soap_action

• description

Country

Column Order

The Country columns are:

• country

• country_name

• internet_domains

• address_format

• state_type

• postal_code_type

• area_code_type

• currency_code

Example of Results

This is an example of the Country log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

Email Address Book

Column Order

The Email Address Book columns are:

• email_id

• full_name

• email_addr

Example of Results

This is an example of the Email Address Book log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

Enclosure

Column Order

The Enclosure columns are:

• company_id

• enclosure_code

• description

• enclosure_type

• active

• unit_value

• unit_price

• unit_cost

• qty_on_hand

• reorder_point

• reorder_qty

• j05_code through j09_code

• print_label

• last_coupon_seq

• coupon_dw

• coupon_format

• qty_limit

• checking_account

• split_type

• split_save

• encl_auth_level

• j10_code through j20_code

• filename

• print_label_return

• linked_from_letter

• min_value

• max_value

• language_id

• currency_code

• currency_unit_value

• requires_approval

• exclude_from_fulfillment

• retain_rejected

• require_reject_reason

• require_void_reason

• label_standard_letter_id

• pick_websrv_provider

• require_link_to_letter

• require_send_to_match

• requires_high_value_permit

• link_on_add

• ecoupon_code

Enclosure Split

Column Order

• company_id

• enclosure_code

• split_seq

• split_code

• split_amount

• split_pct

• fa2_code through fa6_code

Example of Results

This is an example of the Enclosure Split log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

InfoCenter

Column Order

The InfoCenter columns are:

• company_id

• infocenter_type

• arrange_open_type

• experience_level

• active

• description

• last_reference1

• last_reference2

• infocenter_text

• date_added

• added_by_user_code

• date_changed

• changed_by_user_code

• infocenter_code

InfoCenter Attachment

Column Order

The InfoCenter columns are:

• company_id

• infocenter_attachment_seq

• attachment_type

• attachment_launch

• description

• file_name

• application

• app_param_1

• infocenter_code

Example of Results

This is an example of the InfoCenter Attachment log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

InfoCenter Translation

Column Order

The InfoCenter Translation columns are:

• company_id

• language_id

• description

• infocenter_text

• date_added

• added_by_user_code

• date_changed

• changed_by_user_code

• infocenter_code

Example of Results

This is an example of the InfoCenter Translation log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

Normalization Translation

Column Order

The Normalization Translation columns are:

• company_id

• category_id

• category_name

• description

• entry_seq

• normalized_code

• agent_code

• conversion_factor

• split

• split_factor

• split_code

Example of Results

This is an example of the Normalization Translation log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

Notification

Column Order

The Notification columns are:

• company_id

• notification_code

• description

• active

Example of Results

This is an example of the Notification log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

Notification Event

Column Order

The Notification Event columns are:

• company_id

• notification_code

• event_seq

• event_type

• event_id

Example of Results

This is an example of the Notification Event log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

Notification Format

Column Order

The Notification Format columns are:

• company_id

• notification_code

• format_seq

• format_type

• format_id

Example of Results

This is an example of the Notification Format log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

Notification Recipient

Column Order

The Notification Recipient columns are:

• company_id

• notification_code

• recipient_seq

• recipient_type

• recipient_category

• recipient_details

• address

• format

• device

• category_level

Example of Results

This is an example of the Notification Format log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

Product

Column Order

The Product columns are:

• company_id

• product_code

• product_description

• upc

• item_number

• mfg

• e05_code through e99_code

Example of Results

This is an example of the Product information log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

Standard Letter

Column Order

The Standard Letter columns are:

• company_id

• standard_letter_id

• letter_type_code

• standard_letter_file_name

• auto-prep

• customized

• paragraph_subject

• document_type

• language_id

• issue_association

• letter_status

Standard Letter Paragraph

Column Order

The Standard Letter Paragraph columns are:

• company_id

• standard_letter_id

• paragraph_merge_code

• standard_paragraph_id

• display_sequence

Example of Results

This is an example of the Standard Letter Paragraph log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

Standard Paragraph

Column Order

The Standard Paragraph columns are:

• company_id

• standard_letter_id

• active

• repeat_table

• paragraph_text

• language_id

Example of Results

This is an example of the Standard Paragraph log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

State

Column Order

The State columns are:

• country

• state

• state_name

Example of Results

This is an example of the State log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

Suggestion Code

Column Order

The Suggestion Code columns are:

• company_id

• suggestion_id

• code_1 and code_2

• reference_id

• reference_category

• quantity

• value

• suggestion_code_source

• suggestion_code_date

Example of Results

This is an example of the Suggestion Code log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below:

Time Period

Column Order

The Time Period columns are:

• company_id

• time_frame_id

• time_period_id

• time_period_seq

• time_period_start

• time_period_end

Example of Results

This is an example of the Time Period log file results. If you select the Input file contains header row check box, the first line of your results will show the column headings. The column names and values are tab separated, as shown below: