-
Access the Connections page using one of these:
- Spectrum Management Console:
- Access Spectrum Management Console using the URL:
http://server:port/management
console, where server is the server name or IP
address of your Spectrum Technology Platform server and
port is the HTTP port used by Spectrum Technology Platform.Note: By default, the HTTP port is 8080.
- Click Resources > Connections.
- Spectrum Discovery:
- Access Spectrum Discovery using the URL: http://server:port/discovery, where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port used by Spectrum Technology Platform.Note: By default, the HTTP port is 8080.
- Click Connect.
- Click the Add connection button .
-
In the Connection Name box, enter a name for the connection. The name can be anything you choose.
Note: Once you save a connection you cannot change the name.
- In the Connection Type box, select Flat File.
- Enter the File Path by clicking Browse and selecting the directory of the file.
- Select the Character Encoding of the flat file from the drop-down.
- Select the Record Type as Fixed Width.
- In the Record Length field, enter the total number of characters in a file record.
- Click Add Field to add a row for a field in a file record.
- In the Name column, enter the name for the field value.
- In the Type column, select the data type of the field value.
-
In the Start Position column, enter the position in the
file record at which of the field value begins.
For the first field in a file record, the Start Position counting begins from 1.
-
In the Length field, enter the total number of
characters the field covers, including the character at the Start
Position.
The sum of the Start Position and Length values for any field should be less than or equal to the Record LengthIf the File Record is:
01234Rob Smith29Precisely
Record Length = 25
For the field 'Name':Start Position = 6
Length = 9
Name = Rob Smith
- Check the Trim check box if you wish to trim any white spaces at the beginning and/or end of a field value.
- Repeat step 10 through step 15 to add details for all fields expected in file records.
- Click the Preview button to view field values based on selections you made in previous steps of this procedure.
-
Click Test.
A message confirms the successful test of the connection.
-
Click Save.
A message confirms the successful creation of the connection.
In order to view a sample record fetched using the created Fixed Width Flat File
connection, click Preview in the header bar. File records will be
fetched and the Fields sorted according to the details provided by you.