File for extended Item information entries (Optional)
- Organization of this page
Description
These files contain Item information to be registered in JP1/Service Support, and related information for the Items. These two files for extended Item information entries consist of an Item information CSV file and a related information CSV file. These files must be created in CSV format. To register the contents of these files in JP1/Service Support, you must execute the jssitemimportEx command.
Format (Item information CSV file)
#comments (Linefeed) #product-name, version-of-file-to-be-output,...(Linefeed) #"system-ID-of-target-system","system-name-of-target-system",...(Linefeed) "system-ID","system-name","process-work-board-ID","process-name",...(Linefeed) "system-ID","system-name","process-work-board-ID","process-name",...(Linefeed) : : #"Closed Item Number : number-of-entries" #"UnClosed Item Number : number-of-entries"
Lines starting with a hash mark (#) are treated as comments.
- Legend:
-
(Linefeed): Indicates a linefeed character.
Format (related information CSV file)
#comments (Linefeed) #product-name, version-of-file-to-be-output,...(Linefeed) #"process-work-board-ID","process-work-board-serial-number",...(Linefeed) #"process-work-board-ID","process-work-board-serial-number",...(Linefeed) #"process-work-board-ID","process-work-board-serial-number",...(Linefeed) : :
Lines starting with a hash mark (#) are treated as comments.
- Legend:
-
(Linefeed): Indicates a linefeed character.
File names
-
Item_PWB_process-work-board-ID.csv (Item information CSV file)
-
ItemRefInfo_PWB_process-work-board-ID.csv (related information CSV file)
Storage folder
An arbitrary folder on a host where the jssitemimportEx command is executed.
Note that the folder configuration must be the same as the jssitemexportEx command's output destination folder. For details about the folder configuration, see jssitemexportEx (exports extended Item information) in Chapter 12. Commands.
When the definition is applied
When you execute the jssitemimportEx command, the contents of the Item information CSV file and the related information CSV file are applied to JP1/Service Support.
What is described
The format of the Item information CSV file and the related information CSV file are the same as the format when you use the jssitemexportEx command to output Item information. In addition, the header section, the first line of the body (attribute name), and the footer section of both files can be omitted. For details about the Item information CSV file and the related information CSV file, see jssitemexportEx (exports extended Item information) in Chapter 12. Commands.
Create Item information (Item information CSV file) in the order specified in the following table.
Specification order |
Element name |
Specifiable characters |
Specifiable number of bytes#1 |
Specify or not |
---|---|---|---|---|
1 |
System ID of target system#2, #3 |
Half-width alphanumeric characters |
1 to 64 bytes |
Y |
2 |
System name of target system#3 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Note that this must be the system name corresponding to system-ID-of-target-system, which is registered in the Item management database. |
1 to 128 bytes |
Y |
3 |
Process name#3 |
Process (process display name) for the registration-target process work board. Any characters other than control characters (0x00 to 0x1F, and 0x7F). |
1 to 128 bytes |
Y |
4 |
Process work board ID#2, #3 |
Half-width alphanumeric characters |
1 to 64 bytes |
Y |
5 |
Process work board serial numbers#4 |
An integer from 1 to 2147483647 |
-- |
Y |
6 |
Version number |
An integer from 1 to 2147483647 |
-- |
Y |
7 |
Related item serial number#3 |
An integer from 1 to 2147483647. Note that this number is combined with the Escalation number to form an inter-process ID, which must be unique across Items. |
-- |
Y |
8 |
Escalation number |
An integer from 1 to 99. Note that this number is combined with the Related item serial number to form an inter-process ID, which must be unique across Items. |
-- |
Y |
9 |
Item form ID#2, #3 |
An Item form used in a process work board. Specify any one of the following:
Specify the Item form corresponding to the default process with the process display name specified for Process name. |
-- |
Y |
10 |
Version number of Item form#2, #3 |
An integer from 0 to 255 |
-- |
Y |
11 |
Item status ID |
Specify any one of the following:
You can register unused statuses on the process work board on which you want to register an Item. |
-- |
Y |
12 |
Item status name |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). You can register the Item even if the Item status name is different from the name of the Item status ID that is used in the process work board where you want to register the Item. |
1 to 255 bytes |
Y |
13 |
Edit status |
Either a null character or Edit in progress. The status is not registered in the Item management database. |
-- |
Δ |
14 |
Data type |
Specify any one of the following:
If the type of data with the same process work board serial number is either Most recent or Delete, Version number must be the greatest number. For History, Version number must not be the greatest number. |
-- |
Y |
15 |
Escalation source process work board ID#2, #5 |
Half-width alphanumeric characters |
0 to 64 bytes |
Δ |
16 |
Escalation source related Item serial number#5 |
An integer from 1 to 2147483647, or a null character. This number must be the same as the Related item serial number. |
-- |
Δ |
17 |
Escalation source escalation number#5 |
An integer from 1 to 98, or a null character. This number must be smaller than the Escalation number. |
-- |
Δ |
18 |
Escalation destination related Item serial number#5 |
An integer from 1 to 2147483647, or a null character. This number must be the same as the Related item serial number. |
-- |
Δ |
19 |
Escalation destination escalation number#5 |
An integer from 2 to 99, or a null character. This number must be greater than the Escalation number. |
-- |
Δ |
20 |
Escalation destination process work board ID#2, #5 |
Half-width alphanumeric characters |
0 to 64 bytes |
Δ |
21 |
Escalation destination system ID#5 |
Half-width alphanumeric characters. This number must be the ID of the system to which the process work board of Escalation destination process work board ID that is registered in the Item management database belongs. |
0 to 64 bytes |
Δ |
22 |
Escalation system name#5 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). This name must be the system name of Escalation destination system ID that is registered in the Item management database. |
0 to 128 bytes |
Δ |
23 |
Escalation process name#5 |
The process (process display name) of the escalation-destination process work board. Any characters other than control characters (0x00 to 0x1F, and 0x7F). This name must be the process name of Escalation destination process work board ID that is registered in the Item management database. |
-- |
Δ |
24 |
Linked serial number |
An integer from 0 to 2147483647. Register this even if the serial number does not exist in the Item form. |
-- |
Δ |
25 |
JP1/IM-M host name |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Register this even if the host name does not exist in the Item form. |
0 to 255 bytes |
Δ |
26 |
Severity#6 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
27 |
Impact level#6 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
28 |
Priority#6 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
29 |
Item type#6 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
30 |
Problem domain#6 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
31 |
Occurred type#6 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
32 |
Cause#6 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
33 |
Result#6 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
34 |
Solution category code#6 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
35 |
Workaround type#6 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
36 |
Scale of change#6 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
37 |
Release type#6 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
38 |
Occurrence date and time |
A string in YYYY/MM/DD hh:mm:ss format#7 or a null character |
-- |
Δ |
39 |
Deadline |
A string in YYYY/MM/DD hh:mm:ss format#7 or a null character |
-- |
Δ |
40 |
Start date and time |
A string in YYYY/MM/DD hh:mm:ss format#7 or a null character |
-- |
Δ |
41 |
End date and time |
A string in YYYY/MM/DD hh:mm:ss format#7 or a null character |
-- |
Δ |
42 |
Title |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
1 to 512 bytes |
Y |
43 |
Overview |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 2,048 bytes |
Δ |
44 |
Impact service |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
45 |
Reason for severity |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 512 bytes |
Δ |
46 |
Reason for impact level |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 512 bytes |
Δ |
47 |
Reason for priority |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 512 bytes |
Δ |
48 |
Workaround |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 4,096 bytes |
Δ |
49 |
Work status |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 4,096 bytes |
Δ |
50 |
Fundamental cause |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 4,096 bytes |
Δ |
51 |
Solution |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 4,096 bytes |
Δ |
52 |
Problem component and version |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 1,024 bytes |
Δ |
53 |
Schedule and main steps |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 4,096 bytes |
Δ |
54 |
Impact assessment for change |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 4,096 bytes |
Δ |
55 |
Discussions result |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 2,048 bytes |
Δ |
56 |
How to avoid the problem in the future |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 4,096 bytes |
Δ |
57 |
Free memo column |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 4,096 bytes |
Δ |
58 |
Product name |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 1,024 bytes |
Δ |
59 |
Jobnet name |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 1,024 bytes |
Δ |
60 |
Job name |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 1,024 bytes |
Δ |
61 |
SNMP source |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 1,024 bytes |
Δ |
62 |
Monitored node name |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
63 |
Alarm name |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
64 |
Customer name |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 1,024 bytes |
Δ |
65 |
Cost (planned) |
An integer from 0 to 2147483647, or a null character |
-- |
Δ |
66 |
Cost (actual) |
An integer from 0 to 2147483647, or a null character |
-- |
Δ |
67 |
Inquirer's name |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
68 |
Registrant ID#3 |
Half-width alphanumeric characters |
0 to 64 bytes |
Δ |
69 |
Registrant's name#3 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Using only space characters is not allowed. |
1 to 255 bytes |
Y |
70 |
Registrant's name (English)#3 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Using only space characters is not allowed. |
0 to 255 bytes |
Δ |
71 |
Person in charge type#8 |
Either USER or ROLE |
-- |
Y |
72 |
Person in charge ID#9 |
Half-width alphanumeric characters |
0 to 64 bytes |
Δ |
73 |
Name of person in charge#8 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Using only space characters is not allowed. |
1 to 255 bytes |
Y |
74 |
Name of person in charge (English) |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Using only space characters is not allowed. |
0 to 255 bytes |
Δ |
75 |
Respondent type#8 |
Either USER or ROLE, or a null character |
-- |
Δ |
76 |
Respondent ID#9 |
Half-width alphanumeric characters |
0 to 64 bytes |
Δ |
77 |
Respondent's name#8 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Using only space characters is not allowed. |
0 to 255 bytes |
Δ |
78 |
Respondent's name (English) |
Any characters other than control characters (0x00 to 0x1F, and 0x7F).Using only space characters is not allowed. |
0 to 255 bytes |
Δ |
79 |
Extended text 1 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 4,096 bytes |
Δ |
80 |
Extended text 2 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 4,096 bytes |
Δ |
81 |
Extended text 3 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 4,096 bytes |
Δ |
82 |
Extended text 4 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 4,096 bytes |
Δ |
83 |
Extended text 5 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 4,096 bytes |
Δ |
84 |
Extended text 6 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 2,048 bytes |
Δ |
85 |
Extended text 7 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 2,048 bytes |
Δ |
86 |
Extended text 8 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 2,048 bytes |
Δ |
87 |
Extended text 9 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 2,048 bytes |
Δ |
88 |
Extended text 10 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 2,048 bytes |
Δ |
89 |
Extended text 11 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 2,048 bytes |
Δ |
90 |
Extended text 12 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 2,048 bytes |
Δ |
91 |
Extended text 13 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 2,048 bytes |
Δ |
92 |
Extended text 14 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 2,048 bytes |
Δ |
93 |
Extended text 15 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 2,048 bytes |
Δ |
94 |
Extended text 16 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 512 bytes |
Δ |
95 |
Extended text 17 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 512 bytes |
Δ |
96 |
Extended text 18 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 512 bytes |
Δ |
97 |
Extended text 19 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 512 bytes |
Δ |
98 |
Extended text 20 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 512 bytes |
Δ |
99 |
Extended time data 1 |
A string in YYYY/MM/DD hh:mm:ss format#7 or a null character |
-- |
Δ |
100 |
Extended time data 2 |
A string in YYYY/MM/DD hh:mm:ss format#7 or a null character |
-- |
Δ |
101 |
Extended time data 3 |
A string in YYYY/MM/DD hh:mm:ss format#7 or a null character |
-- |
Δ |
102 |
Extended time data 4 |
A string in YYYY/MM/DD hh:mm:ss format#7 or a null character |
-- |
Δ |
103 |
Extended time data 5 |
A string in YYYY/MM/DD hh:mm:ss format#7 or a null character |
-- |
Δ |
104 |
Extended code data 1 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
105 |
Extended code data 2 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
106 |
Extended code data 3 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
107 |
Extended code data 4 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
108 |
Extended code data 5 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F) |
0 to 255 bytes |
Δ |
109 |
Extended numeric value data 1 |
An integer from 0 to 2147483647, or a null character |
-- |
Δ |
110 |
Extended numeric value data 2 |
An integer from 0 to 2147483647, or a null character |
-- |
Δ |
111 |
Extended numeric value data 3 |
An integer from 0 to 2147483647, or a null character |
-- |
Δ |
112 |
Extended numeric value data 4 |
An integer from 0 to 2147483647, or a null character |
-- |
Δ |
113 |
Extended numeric value data 5 |
An integer from 0 to 2147483647, or a null character |
-- |
Δ |
114 |
Type of extended user information 1#8, #9 |
Either USER or ROLE, or a null character |
-- |
Δ |
115 |
Extended user information 1#9, #10 |
Half-width alphanumeric characters |
0 to 64 bytes |
Δ |
116 |
Extended user name 1#8, #9 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Using only space characters is not allowed. |
0 to 255 bytes |
Δ |
117 |
Type of extended user information 2#8, #9 |
Either USER or ROLE, or a null character |
-- |
Δ |
118 |
Extended user information 2#9, #10 |
Half-width alphanumeric characters |
0 to 64 bytes |
Δ |
119 |
Extended user name 2#8, #9 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Using only space characters is not allowed. |
0 to 255 bytes |
Δ |
120 |
Type of extended user information 3#8, #9 |
Either USER or ROLE, or a null character |
-- |
Δ |
121 |
Extended user information 3#9, #10 |
Half-width alphanumeric characters |
0 to 64 bytes |
Δ |
122 |
Extended user name 3#8, #9 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Using only space characters is not allowed. |
0 to 255 bytes |
Δ |
123 |
Type of extended user information 4#8, #9 |
Either USER or ROLE, or a null character |
-- |
Δ |
124 |
Extended user information 4#9, #10 |
Half-width alphanumeric characters |
0 to 64 bytes |
Δ |
125 |
Extended user name 4#8, #9 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Using only space characters is not allowed. |
0 to 255 bytes |
Δ |
126 |
Type of extended user information 5#8, #9 |
Either USER or ROLE, or a null character |
-- |
Δ |
127 |
Extended user information 5#9, #10 |
Half-width alphanumeric characters |
0 to 64 bytes |
Δ |
128 |
Extended user name 5#8, #9 |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Using only space characters is not allowed. |
0 to 255 bytes |
Δ |
129 |
Editor ID |
Half-width alphanumeric characters |
0 to 64 bytes |
Δ |
130 |
Editor's name |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Using only space characters is not allowed. |
1 to 255 bytes |
Y |
131 |
Editor's name (English) |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Using only space characters is not allowed. |
0 to 255 bytes |
Δ |
132 |
Registration date and time#3 |
A string in YYYY/MM/DD hh:mm:ss format,#7 or a null character |
-- |
Δ |
133 |
Update date and time |
A string in YYYY/MM/DD hh:mm:ss format,#7 or a null character. This information must have the latest date and time among Items with the same process work board serial number when they are sorted in ascending Version number order. |
-- |
Δ |
134 |
Message ID |
Any characters other than control characters (0x00 to 0x1F, and 0x7F). Using only space characters is not allowed. |
0 to 255 bytes |
Δ |
135 |
Related information ID |
0 to 160 integer ID numbers from 100 to 2147483647, separated by vertical bars (|). A maximum of 20 IDs can be specified for each Related information type. Do not repeat Related information IDs within the same record. Details must exist in the related information CSV file. |
-- |
Δ |
136 |
Attached file ID#11 |
0 to 5 integer IDs from 1 to 2147483647, separated by vertical bars (|). If an ID has less than 10 digits, add sufficient zeros (0) at the beginning to make it a 10-digit number. Use the same Attached file ID as the file name of the applicable attached file(s). Do not repeat Attached file IDs within the same record. In addition, arrange the IDs separated by vertical bars (|) in the same order as the applicable Attached file IDs. |
-- |
Δ |
137 |
Attached file(s)#11 |
0 to five attached file names separated by vertical bars (|). Use any characters other than control characters (0x00 to 0x1F, and 0x7F). In addition, arrange the file names separated by vertical bars (|) in the same order as the applicable Attached file IDs. Within the Items that have the same process work board ID, do not use a different Attached file name if the applicable Attached file ID is the same. |
-- |
Δ |
138 |
Operational history |
Specify any one of the following:
If Version number is 1, you can specify only Creating or editing. You can also specify a null character. If you specify a null character, this element is registered as 0. |
-- |
Δ |
- Legend:
-
--: Because the value you can specify is already determined, the value itself is the specifiable number of bytes.
Y: Elements you need to specify
Δ: Specify this element if necessary
- #1
-
UTF-8 converted value. When the specified string contains full-width characters, they are converted to three or four bytes.
- #2
-
Before applying the contents of the Item information CSV file to JP1/Service Support, you must register this information in the Item management database. For Escalation destination system ID, you must specify the ID of the system to which the process work board that has the value you specified for Escalation destination process work board ID belongs.
- #3
-
For some elements, you must always specify the same value within an individual file. The following table lists the elements for which you must specify the same value.
No.
Element name
Description
1
System ID
Specify the same value within the file.
2
System name
3
Process name
4
Process work board ID
5
Related item serial number
For the identical process work board serial numbers within the file, specify the same values.
6
Item form ID
For the identical Items# within the file, specify the same Item form for all versions.
7
Version number of Item form
8
Registrant ID
For the identical Items within the file, specify the same value.
9
Registrant's name
10
Registrant's name (English)
11
Registration date and time
- #
-
The identical Item means the Items that have the same values for the following elements:
-
Related item serial number
-
Escalation number
-
Process work board ID
-
Process work board serial numbers
-
- #4
-
Process work board serial numbers and the related item serial number are changed to new numbers. The new serial numbers can be checked in the open log. Because of this, save the open log before it is overwritten.
- #5
-
You cannot change elements for the escalation source and those for the escalation destination at the same time. In addition, when you specify the process work board ID for the escalation destination or for the escalation source, you must do so for the escalation source elements or for the escalation destination elements separately.
- #6
-
The information must be the selection code display name that is used in the applicable Item form.
- #7
-
YYYY indicates the year, MM indicates the month, DD indicates the day, hh indicates the hour, mm indicates the minute, and ss indicates the second. Specifiable values are from 1970/01/02 00:00:00 to 2107/01/01 23:59:59. For example, if you want to set 10:30:25 on May 10th 2013, it will be 2013/05/10 10:30:25. Note that if you specify a date that does not exist, an error occurs.
- #8
-
Specify this information for each type and for each name separately.
- #9
-
After you set view permission for individual Items, one of Extended user information type 01 to 05 will be selected as the element that specifies the view permissions for the Items. For the selected extended user information, set the Item view permissions owner. Extended user information consists of the extended user information type, extended user information, and extended user information ID.
For details about how to set up an environment when setting view permissions for individual Items, see 9.13 Setting an environment in which view permissions are set for individual Items.
- #10
-
If you specify ROLE for each type, you can specify the following system roles for the applicable ID:
-
_jp1ITsystem
-
_jp1user
-
_jp1workmgr
-
- #11
-
The name of attached file(s) for Item information must be in the attached-file-ID_attached-file-name format. In addition, you must specify the same value for the Attached file ID of the attached file(s) as the Attached file ID. For example, if the name of the attached file is 00001_file1.txt, the Attached file ID and the Attached file will be as follows:
Attached file ID: 00001
Attached file: file1.txt
When you execute the jssitemexportEx command, if the length of the path for an attached file name is equal to or greater than 255 bytes, the file name is cut at the 255th byte. Such an attached file is registered in the Item management database with the file name specified in the Item information CSV file.
Create Item information (Related information CSV file) in the order specified in the following table.
Specification order |
Element name |
Specifiable character |
Specifiable number of bytes#1 |
Specify or not |
---|---|---|---|---|
1 |
Process work board ID#2 |
Half-width alphanumeric characters |
1 to 64 bytes |
Δ |
2 |
Process work board serial number |
An integer from 1 to 2147483647 |
-- |
Δ |
3 |
Version number |
An integer from 1 to 2147483647 |
-- |
Δ |
4 |
Related information ID |
An integer from 100 to 2147483647 |
-- |
Δ |
5 |
Item form part ID |
Elements that can be registered as related information#3 |
-- |
Δ |
6 |
Related information type |
Specify any one of the following:
Specify a value corresponding to the Item form elements ID.#3 |
-- |
Δ |
7 |
Related information details |
Specify any of the following values if Related information type is Related item(s):
When Related information type is not Related item(s), specify a null character. |
-- |
Δ |
8 |
Related information 1 |
Differs depending on the value for Related information type.
|
|
Δ |
9 |
Related information 2 |
Differs depending on the value for Related information type.
|
|
Δ |
No. |
Item form element name |
Item form elements ID |
Specifiable type of related information |
---|---|---|---|
1 |
Related information (AIM) |
JIMSD_FORM_LINKAIM |
Hardware information |
2 |
Related information (Item) |
JIMSD_FORM_LINKITEM |
Related item(s) |
3 |
Related information (URL) |
JIMSD_FORM_LINKURL |
Related information |
4 |
Additional element: Link 01 |
JIMSD_FORM_REFINFO01 |
The type defined in an Item form. Any of the following values:
|
5 |
Additional element: Link 02 |
JIMSD_FORM_REFINFO02 |
|
6 |
Additional element: Link 03 |
JIMSD_FORM_REFINFO03 |
|
7 |
Additional element: Link 04 |
JIMSD_FORM_REFINFO04 |
|
8 |
Additional element: Link 05 |
JIMSD_FORM_REFINFO05 |
In the Item information CSV file and the related information CSV file, each line consists of information for an Item. Enclose elements of Item information in double-quotation marks ("), and separate elements with commas (,). You cannot omit elements. When you do not want to specify an element, use an empty set of double-quotation marks ("") in that element's location. In addition, the specification order of the elements is determined.
The following is an example when Edit status of an Item information CSV file is omitted:
"syste-ID-of-target-system","system-name-of-target-system","process-name","process-work-board-ID","process-work-board-serial-number","version-number","related-item-serial-number","escalation-number","Item-form-ID","version-number-of-Item-form","Item-status-ID","Item-status-name","","data-type",...(Linefeed)
Note that Item information CSV files and related information CSV files must be sorted in the following order:
-
First sort key: Process work board serial number
-
Second sort key: Version number
Notes
-
Element names might be changed due to customization. For details, see Item form definition file (Optional) in Chapter 13. Definition Files. If an element name is changed due to customization, the specification order remains the same.
-
If you want to use a linefeed character as part of an element value, set the configuration file for CSV as follows before registering the Item information:
-
hptl_jp1_imss_replace_linefeed_flag: true
-
hptl_jp1_imss_replace_linefeed_string: A string to be converted to a linefeed character
For details about the configuration file for CSV, see Configuration file for CSV (hptl_jp1_imss_csv_setting.properties) in Chapter 13. Definition Files.
-
-
The File for extended Item information entries (the Item information CSV file, and the related information CSV file) 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
Definition example 1
The following is a definition example of an Item information CSV file when you register information for more than one Item:
#"JP1/Service Support","#101000","ISO-8859-1","ITEMEXPORT_ITEM" #"system-ID-of-target-system","system-name-of-target-system",...(Linefeed) "1","1","1",...(Linefeed) "2","1","1",...(Linefeed) #"Closed Item Number : 45" #"UnClosed Item Number : 5" :
Definition example 2
The following is a definition example of the related information CSV file when you register related information for more than one Item:
#"JP1/Service Support","#101000","ISO-8859-1","ITEMEXPORT_REF" #"process-work-board-ID","process-work-board-serial-number",...(Linefeed) "pwb01","1",...(Linefeed) "pwb01","1",...(Linefeed) :