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

Create a Mapping File (Flatfile)

The mapping file is a template file provided as input to the CA Asset Converter. The CA Asset Converter reads the mapping file, retrieves the connection properties, and reads the specified file path information for each file used for the mapping. The CA Asset Converter uses the mapping file to read data from specified flatfiles, process the data, and generate the expected asset files.

Note: The XML files must be well-formed and comply with XML and XSD standards.

Example: FlatFile Mapping

The following sample FlatFile mapping contains connection properties.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<asset-converter xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<datasource type="flatfile">

<connection-properties>

<property filename="main" filepath="MainFile.txt" key="1" column_name="true"/>
<property filename="system" filepath="SystemFile.txt" key="1" column_name="true"/>

</connection-properties>
<delimiter>

<text-delimiter value=","/>

</delimiter>

</datasource>
</asset-converter>