Input Record Format

The Enterprise Designer specifies the allowable input file formats for the type of dataflow in use. Typically, the dataflow would read the input record as either a text, database or XML file. Each of these input file types have specific format requirements which are covered in detail in the Spectrum™ Technology Platform Dataflow Designer's Guide. For instance, for an input text file, the guide covers the permitted record types, character encoding, field separators, etc.

The following are a couple of example input record text files. These example input records contain an optional header line, as well as optional input fields.

Example Geocoding Input Record

The following is an example text input record file with USA addresses.

mainAddress;areaName3;areaName1;postalCode;country
26 EDISON DR;NISKAYUNA;NY;12309;USA
92 MCCRACKEN RD;MILLBURY;MA;01527;USA
22 CARRIAGE LN;NEWARK;DE;19711;USA
8 HARBOR VIEW RD; S BURLINGTON;VT;05403;USA
124 VERNON RD;GREENVILLE;PA;16125;USA
31 FORD ST;MAUMEE;OH;43537;USA
155 WINTER ST;S WALPOLE;MA;02071;USA

Example Reverse Geocoding Input Record

The following is an example text input record file with input coordinates.

X|Y|Country
-72.672229|42.076406|USA
-82.436915|34.870463|USA
-95.7849|42.1603|USA
-113.532|53.5421|CAN
-71.2577|46.8461|CAN
-115.423|32.6561|MEX

Example Interactive Geocoding Input Record

The following is an example text input record file.

MainAddressLine;AreaName1;AreaName3;PostCode1;County;Country;OriginX;OriginY
ABBOTSFIELD;;Toronto;;;;;
札幌市中央;;;;;;;
Broadway;;;;;; -74.00218;40.719025

Example KeyLookup Input Record

The following is an example text input record file.

Key;KeyType;Country
P0000GL5UVYI; PB_KEY;USA
P0000GL41OME;PB_KEY;USA
GASA_422263850; GNAF_PID;AUS
GANSW705177946;GNAF_PID;AUS