CSV column name mapping file (jp1imss_itemcsv_columnmap.conf)
- Organization of this page
Description
This file defines the header information of Item information CSV files and related information CSV files which are output by executing the jssitemexportEx (exports extended Item information) command.
By using a CSV column name mapping file, you can change the name of the elements that are displayed in the header information (the first line of the body in each file). You cannot change the order that elements are displayed, hidden, and output. Note that if you omit the definition, the elements are output with preset names.
For details about Item information CSV files and related information CSV files to be output, see jssitemexportEx (exports extended Item information) in Chapter 12. Commands.
Format
#Item CSV hedder I.SYSTEMID=ID of the target system I.SYSTEMNAME=Name of the target system I.PROCESS=Process name I.PWBID=Process work board ID : #ItemRef CSV hedder R.PWBID=Process work board ID R.PITEMNO=Process work board serial number R.VERNO=Version number R.REFINFOID=Related information ID :
Lines starting with a hash mark (#) are treated as comments.
File names
-
jp1imss_itemcsv_columnmap.conf (CSV column name mapping file)
-
jp1imss_itemcsv_columnmap.conf.model (Model CSV column name mapping file)#
- #
-
You can use the model file to reset the contents of the CSV column name mapping file. To do so, delete the existing CSV column name mapping file, then copy and rename the model file.
Storage folder
JP1/SS-path\conf\command\
When the definition is applied
When you execute the jssitemexportEx (exports extended Item information) command, the definition is applied to JP1/Service Support.
What is described
When you change the name of a header element, change the value of the applicable property key. When you do so, do not change or delete the property key itself. If you change or delete it, the applicable property key is regarded as not defined, and a pre-defined value (the default value) is set.
When you specify a property key value, apply the following rules:
- Specifiable characters and conditions
-
Specify characters other than control characters (0x00 to 0x1F, and 0x7F).
- Specifiable number of bytes
-
1 to 255 bytes.
The number of bytes is the character length after conversion to UTF-8. Full-width characters are converted to three or four bytes.
The following table lists the property keys that can be set in the CSV column name mapping file for each file.
No. |
Property key |
Element name (default value) |
---|---|---|
1 |
I.SYSTEMID |
System ID of the target system |
2 |
I.SYSTEMNAME |
System name of the target system |
3 |
I.PROCESS |
Process name |
4 |
I.PWBID |
process work board ID |
5 |
I.PITEMNO |
Process work board serial number |
6 |
I.VERNO |
Version number |
7 |
I.ITEMNO |
Related item serial number |
8 |
I.EITEMNO |
Escalation number |
9 |
I.FORMID |
Item form ID |
10 |
I.FORMNO |
Version number of Item form |
11 |
I.ITEMSTATUSID |
Item status ID |
12 |
I.ITEMSTATUSNAME |
Item status name |
13 |
I.EDITSTATUS |
Edit status |
14 |
I.DATATYPE |
Data type |
15 |
I.ORGPWBID |
Escalation source process work board ID |
16 |
I.ORGITEMNO |
Escalation source related Item serial number |
17 |
I.ORGEITEMNO |
Escalation source escalation number |
18 |
I.ESCITEMNO |
Escalation destination related Item serial number |
19 |
I.ESCEITEMNO |
Escalation destination escalation number |
20 |
I.ESCPWBID |
Escalation destination process work board ID |
21 |
I.ESCSYSTEMID |
Escalation destination system ID |
22 |
I.ESCSYSTEMNAME |
Escalation destination system name |
23 |
I.ESCPROCESS |
Escalation destination process name |
24 |
I.ITEMENTRY_SEQNO |
Linked serial number |
25 |
I.ITEMENTRY_ACTHOST |
JP1/IM-M host name |
26 |
I.ITEMSEVERITY |
Severity |
27 |
I.IMPACT |
Impact level |
28 |
I.PRIORITY |
Priority |
29 |
I.ITEM_CATEGORY |
Item type |
30 |
I.ISSUE_CATEGORY |
Problem domain |
31 |
I.PHENOMENON |
Occurred type |
32 |
I.CAUSE |
Cause |
33 |
I.RESULT |
Result |
34 |
I.SOLUTIONCODE |
Solution category code |
35 |
I.AVOIDANCETYPE |
Workaround type |
36 |
I.CHANGE_SCALE |
Scale of change |
37 |
I.RELEASE_TYPE |
Release type |
38 |
I.ACCRUALDATE |
Occurrence date and time |
39 |
I.DEADLINE |
Deadline |
40 |
I.STARTDATE |
Start date and time |
41 |
I.COMPDATE |
End date and time |
42 |
I.TITLE |
Title |
43 |
I.SUMMARY |
Overview |
44 |
I.EFFECTSRV |
Impact service |
45 |
I.ITEMSEVERITY_REASON |
Reason for severity |
46 |
I.IMPACT_REASON |
Reason for impact level |
47 |
I.PRIORITY_REASON |
Reason for priority |
48 |
I.AVOIDANCE |
Workaround |
49 |
I.SITUATION |
Work status |
50 |
I.ROOTCAUSE |
Fundamental cause |
51 |
I.SOLUTION |
Solution |
52 |
I.FAILLOCATION |
Problem component and version |
53 |
I.SCHEDULE |
Schedule and main steps |
54 |
I.IMPACTEVAL |
Impact assessment for change |
55 |
I.DELIBERATIONRST |
Discussions result |
56 |
I.MEASURES |
How to avoid the problem in the future |
57 |
I.FREEDESC |
Free memo column |
58 |
I.PRODUCTNAME |
Product name |
59 |
I.JOBNETNAME |
Jobnet name |
60 |
I.JOBNAME |
Job name |
61 |
I.SNMPSRC |
SNMP source |
62 |
I.NODENAME |
Monitored node name |
63 |
I.ALARMNAME |
Alarm name |
64 |
I.CUSTOMER |
Customer name |
65 |
I.ESTIMATEDCOST |
Cost (planned) |
66 |
I.ACTUALCOST |
Cost (actual) |
67 |
I.INQUIRY |
Inquirer's name |
68 |
I.REGISTRANTID |
Registrant ID |
69 |
I.REGISTRANTNAME |
Registrant's name |
70 |
I.REGISTRANTNAMEEN |
Registrant's name (English) |
71 |
I.ASSIGNEDTYPE |
Person in charge type |
72 |
I.ASSIGNEDID |
Person in charge ID |
73 |
I.ASSIGNED |
Name of person in charge |
74 |
I.ASSIGNEDNAMEEN |
Name of person in charge (English) |
75 |
I.RESPONDENTTYPE |
Respondent type |
76 |
I.RESPONDENTID |
Respondent ID |
77 |
I.RESPONDENT |
Respondent's name |
78 |
I.RESPONDENTNAMEEN |
Respondent's name (English) |
79 |
I.USERTEXT01 |
Extended text 1 |
80 |
I.USERTEXT02 |
Extended text 2 |
81 |
I.USERTEXT03 |
Extended text 3 |
82 |
I.USERTEXT04 |
Extended text 4 |
83 |
I.USERTEXT05 |
Extended text 5 |
84 |
I.USERTEXT06 |
Extended text 6 |
85 |
I.USERTEXT07 |
Extended text 7 |
86 |
I.USERTEXT08 |
Extended text 8 |
87 |
I.USERTEXT09 |
Extended text 9 |
88 |
I.USERTEXT10 |
Extended text 10 |
89 |
I.USERTEXT11 |
Extended text 11 |
90 |
I.USERTEXT12 |
Extended text 12 |
91 |
I.USERTEXT13 |
Extended text 13 |
92 |
I.USERTEXT14 |
Extended text 14 |
93 |
I.USERTEXT15 |
Extended text 15 |
94 |
I.USERTEXT16 |
Extended text 16 |
95 |
I.USERTEXT17 |
Extended text 17 |
96 |
I.USERTEXT18 |
Extended text 18 |
97 |
I.USERTEXT19 |
Extended text 19 |
98 |
I.USERTEXT20 |
Extended text 20 |
99 |
I.USERTIME01 |
Extended time data 1 |
100 |
I.USERTIME02 |
Extended time data 2 |
101 |
I.USERTIME03 |
Extended time data 3 |
102 |
I.USERTIME04 |
Extended time data 4 |
103 |
I.USERTIME05 |
Extended time data 5 |
104 |
I.USERCODE01 |
Extended code data 1 |
105 |
I.USERCODE02 |
Extended code data 2 |
106 |
I.USERCODE03 |
Extended code data 3 |
107 |
I.USERCODE04 |
Extended code data 4 |
108 |
I.USERCODE05 |
Extended code data 5 |
109 |
I.USERINT01 |
Extended numeric value data 1 |
110 |
I.USERINT02 |
Extended numeric value data 2 |
111 |
I.USERINT03 |
Extended numeric value data 3 |
112 |
I.USERINT04 |
Extended numeric value data 4 |
113 |
I.USERINT05 |
Extended numeric value data 5 |
114 |
I.USEREXTTYPE01 |
Type of extended user information 1 |
115 |
I.USEREXTINFO01 |
Extended user information 1 |
116 |
I.USEREXTNAME01 |
Extended user name 1 |
117 |
I.USEREXTTYPE02 |
Type of extended user information 2 |
118 |
I.USEREXTINFO02 |
Extended user information 2 |
119 |
I.USEREXTNAME02 |
Extended user name 2 |
120 |
I.USEREXTTYPE03 |
Type of extended user information 3 |
121 |
I.USEREXTINFO03 |
Extended user information 3 |
122 |
I.USEREXTNAME03 |
Extended user name 3 |
123 |
I.USEREXTTYPE04 |
Type of extended user information 4 |
124 |
I.USEREXTINFO04 |
Extended user information 4 |
125 |
I.USEREXTNAME04 |
Extended user name 4 |
126 |
I.USEREXTTYPE05 |
Type of extended user information 5 |
127 |
I.USEREXTINFO05 |
Extended user information 5 |
128 |
I.USEREXTNAME05 |
Extended user name 5 |
129 |
I.CREATOR_ID |
Editor ID |
130 |
I.CREATORNAME |
Editor's name |
131 |
I.CREATORNAMEEN |
Editor's name (English) |
132 |
I.CREATIONDATE |
Registration date and time |
133 |
I.LASTUPDATE |
Update date and time |
134 |
I.MESSAGEID |
Message ID |
135 |
I.REFINFOID |
Related information ID |
136 |
I.APDFILEID |
Attached file ID |
137 |
I.FILENAME |
Attached file(s) |
138 |
I.OPERATIONHISTORY |
Operational history |
No. |
Property key |
Item name (default value) |
---|---|---|
1 |
R.PWBID |
Process work board ID |
2 |
R.PITEMNO |
Process work board serial number |
3 |
R.VERNO |
Version number |
4 |
R.REFINFOID |
Related information ID |
5 |
R.PARTID |
Item form elements ID |
6 |
R.INFOTYPE |
Related information type |
7 |
R.REFDETAIL |
Related information details |
8 |
R.REFINFO1 |
Related information 1 |
9 |
R.REFINFO2 |
Related information 2 |
Notes
-
The CSV column name mapping file (jp1imss_itemcsv_columnmap.conf) must be created or edited with a character encoding that is compatible with the system locale of the machine on which JP1/Service Support is installed. You can use one of the following character encodings:
-
In a Japanese environment: MS932
-
In an English environment: ISO-8859-1
-
In a Chinese environment: GB18030
-
Definition example
The following is a definition example:
#Item CSV hedder I.SYSTEMID=System ID 1 of the target system I.SYSTEMNAME=System name 2 of the target system I.PROCESS=Process name 1 I.PWBID=Process work board ID 2 : #ItemRef CSV hedder R.PWBID=Process work board ID 2 R.PITEMNO=Process work board serial number 2 R.VERNO=Version number 3 R.REFINFOID=Related information ID 3 :