While performing the initial data load from CA Asset Portfolio Management to CA software Asset Manager, all of the imports fail due to a missing tpl-locations-countries-mapping.xml file

book

Article ID: 5212

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

During the the initial data load from CA Asset Portfolio Management to CA Software Asset Manager, after selecting the load data button, all of the data imports in CA Software Asset Manager fail with the error: 

File list: 
- 0001003047.csv (UTF-8) (Headline validation: loose) 
tpl-locations-countries-mapping.xml 
Data sources: none 
Restricted import: no 
Not processed 
The following errors occurred: 
<template>: File not found (tpl-locations-countries-mapping.xml) (ASP-I9) 

 

Environment

CA Software Asset Manager 4.x
CA Asset Portfolio Management 14.1, any patch level

Resolution

Attached to this tech doc is the tpl-locations-countries-mapping.xml file.  

Install the tpl-locations-countries-mapping.xml file into the following directory on the SAM server: 

\Program Files (x86)\CA\SAM\app\uploads\prod\data_exchange\superuser\import_templates

Information on the XML file's contents is provided under "Additional Information"

Additional Information

The following is the contents of the file "tpl-locations-countries-mapping.xml". 

<?xml version="1.0" encoding="utf-8"?>
<import_template>
  <column>
    <table_colname>import_country_id</table_colname>
    <fk_mapping>
      <element>
        <fk_csv_colname>import_country_id</fk_csv_colname>
        <fk_colname>import_id</fk_colname>
      </element>
    </fk_mapping>
  </column>
</import_template>

Attachments

1558533885282tpl-locations-countries-mapping.xml get_app