Import column definitions
Table 7‑4 lists and describes the default column definitions for new user data imports. The first column shows the column names used with a text import, and the second column shows the XML tags used with an XML import.
Table 7‑4 Default user data import column definitions
Column name
XML tag name
Definition
Measure Name
Measure_Name
Name of measure in Metrics Management
Location Name
Location_Name
Name of location in Metrics Management
Comparative Name
Comparative_Name
Name of comparative in Metrics Management
Period Name
Period_Name
Name of period in Metrics Management
User Data
User_Data
Value
Table 7‑5 lists and describes the additional column definitions for new user data imports. The first column shows the column names used with a text import, and the second column shows the XML tags used with an XML import.
Table 7‑5 Additional user data import column definitions
Column name
XML tag name
Definition
Skip
 
Ignore this column in Import.
Measure ID
Measure_ID
Object ID of measure in Metrics Management.
Location ID
Location_ID
Object ID of location in Metrics Management.
Comparative ID
Comparative_ID
Object ID of comparative in Metrics Management.
Period ID
Period_ID
Object ID of period in Metrics Management.
User Data Type
User_Data_Type
See Table 7‑9.
User Data Type Name
User_Data_Type_Name
See Table 7‑9.
Table 7‑6 lists and describes the default column definitions for user commentary imports.
Table 7‑6 Default user commentary import column definitions
Column name
XML tag
Definition
Measure Name
Measure_Name
Name of measure in Metrics Management
Location Name
Location_Name
Name of location in Metrics Management
Period Name
Period_Name
Name of period in Metrics Management
Commentary Type Name
Commentary_Type
_Name
Name of commentary type used in Metrics Management
Commentary
Commentary
Text commentary
Signature Name
Signature_Name
Name of user who posted commentary
Signature Time
Signature_Time
Date and time that commentary was posted
Commentary Formatted
Commentary
_Formatted
Rich text formatted commentary
Table 7‑7 lists and describes the additional column definitions for user commentary imports.
Table 7‑7 Additional user commentary import column definitions
Column name
XML tag
Definition
Measure ID
Measure_ID
Object ID of measure in Metrics Management.
Location ID
Location_ID
Object ID of location in Metrics Management.
Period ID
Period_ID
Object ID of period in Metrics Management.
Commentary Type ID
Commentary_Type_ID
Object ID of commentary type in Metrics Management.
Skip
 
Ignore this column in Import.
Table 7‑8 lists and describes column definitions for data imports that use a translator. When an object type uses a translator, translated column names or XML tags are required with an import. A translator object must also be specified. The translator object translates the Metrics Management object name according to the rules that the translator object defines.
Table 7‑8 Translated data import column definitions
Column name
XML tag name
Definition
Translated Measure Name
Translated_Measure
_Name
Name of the measure to be translated.
Translated Location Name
Translated_Location
_Name
Name of the location to be translated.
Translated Comparative Name
Translated_Comparative_Name
Name of the comparative to be translated.
Translated Period Name
Translated_Period
_Name
Name of the period to be translated.
Skip
 
Ignore this column in Import.
Table 7‑9 shows type descriptions for numeric data.
Table 7‑9 Numeric type descriptions
Value
Type description
1
<BLANK>
2
<VALID>
3
<INVALID>