Import and Export Sections - trillium_geolocation

Import and Export Sections - trillium_geolocation - 15.19

Trillium Geolocation Reference

Product type

Software

Portfolio

Verify

Product family

Trillium

Product

Trillium > Trillium Geolocation

Version

15.19

Language

English

Product name

Trillium Geolocation

Title

Trillium Geolocation Reference

2023

First publish date

2017

Last updated

2024-04-16

Published on

2024-04-16T03:27:32.653616

Multiple Import and Export sections can be specified in the configuration file. Any section name can be used (other than one of the predefined section names Server or Logging).

An Import and Export section specifies the properties and layout of a text file or data stream. An import specification describes an input file; an export specification describes an output file.

The table given below describes the keys available in the Import and Export sections of the configuration file.

Table 1. Import and Export Sections
Key	Description
Type	The import or export file type. Valid values are: Delimited FixedWidth
CodePage	The import or export file code page. Valid values are: UTF8 (Default) ANSI Unicode
FileName	The name of the import or export file. It can be overridden by the command line parameter -ef. A blank or missing entry for this parameter will result in the output being sent to stdout.
HeaderLine	Specifies whether the first line of the import file contains field names and should be ignored. False by default.
DelimiterCode	The ASCII code of the field delimiter. For instance, the ASCII code for a tab is 9, for a comma is 44 and for a pipe is 124.
FieldCount	The number of fields within the import or export file.
SampleInterval	The interval between records imported or exported. Default is 1, meaning that all records are processed.
RecordDelimiter	Specifies whether each record in a fixed width export should be separated by a carriage return. Default is Yes.
OutputFilter	Specifies whether the output data should be filtered. Valid values are: All (Default) Satisfactory Unsatisfactory
Field name<1 to n>	Specifies each field name, which can be one of the following three types: Contact field Ignore field Pass through field In an export specification, a prefix of Input will ensure that the input data gets written to the export file, whereas either no prefix or a prefix of Output will ensure that the processed data gets written. To ignore a field in the input file, set the field name to Ignore. To pass a field directly through from the import file to the export file without any processing, set the field name to `Pass Through Field n`, where `n` counts from 1 to the total number of pass through fields. These fields must be repeated in the same order in the import specification and all export specifications. A contact field may be any of the following: Record ID Title First Name Middle Initials Last Name Full Name Name Suffix Gender Job Title Salutation Department Company Building Sub Building Premise Street
Field name<1 to n> (continued)	Sub Street PO Box Sub City City Region Principality Postcode Country Extra Postcode Extra City Matchkey Code Extended ACR ACR WCR NCR Validation Ruleset Validation Rule Outer Matchscore Inner Matchscore External Reference Number
Field name<1 to n> (continued)	Other 1 Other 2 Other 3 Other 4 Other 5 Other 6 Other 7 Other 8 Other 9 Address Line 1 Address Line 2 Address Line 3 Address Line 4 Address Line 5 Address Line 6 Address Line 7 Address Line 8 Country ISO Mobile Telephone Telephone 1 Telephone 2 Telephone 3 Telephone 4 Email 1 Email 2 URL 1 URL 2
FieldWidth<1 to n>	This specifies the width of each field in a fixed width file.