Hitachi

JP1 Version 12 JP1/Service Support Configuration and Administration Guide

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.

To Page Top

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.

To Page Top

File names

To Page Top

Storage folder

JP1/SS-path\conf\command\

To Page Top

When the definition is applied

When you execute the jssitemexportEx (exports extended Item information) command, the definition is applied to JP1/Service Support.

To Page Top

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.

Table 13‒3: List of property keys that can be set in the CSV column name mapping file (Item information CSV files)

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
Table 13‒4: List of property keys that can be set in the CSV column name mapping file (related information CSV file)

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

To Page Top

Notes

To Page Top

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
   :

To Page Top

Copyright (C) 2019, Hitachi, Ltd.

Copyright (C) 2019, Hitachi Solutions, Ltd.