Extracting Asset Data › How to Extract Asset Data › Create a Mapping File (Flatfile) › Define Connection Properties (Flatfile)

Define Connection Properties (Flatfile)

You can define connection properties for a mapping file for a flatfile.

Important! One property tag is mandatory within the connection properties.

• Main or Master file represents unique or non-replicated asset data.
• Dependent files represent replicated asset data.
• Main file contains primary keys, which are reference fields for the dependent files.

The file used in the asset tag is always treated as the Master file. All group tags must reference a file (master or dependant). All the attributes of the group must be mapped to the columns of the file.

To define connection properties for a flatfile

1. Specify the datasource type as either FlatFile or flatfile.
2. Specify the following property tag attributes:

   filename

   (Required) Name of the input flatfile.

   filepath

   (Required) Path of the input flatfile.

   key value

   (Required) Primary key of the defined file.

   column name

   (Optional) Defines the column heading. Valid values include the following:

   • true. Read the data from the second row.
   • false. Read the data from the first row (column heading).

   Note: If this attribute is missing, the CA Asset Converter reads data from row 1.

3. (Optional) Specify the delimiter parameter using the text-delimiter tag under Delimiter.

   text-delimiter

   (Optional) The default text-delimiter tag is a comma (,). You can also specify the following delimiters:

   • Pipe (|)
   • Pound (#)
   • Tilde (~)