Synopsis
jobschcsvtodef CSV file
Description
This command converts registration information on job nets, groups, holidays in the calendar, and schedule patterns from the CSV format into the control statement format. The conversion result is output in standard output.
The file used to save the conversion results can then be used as the definition file specified by the jobschsetnet, jobschsetgrp, jobschsethol, and jobschsetcal commands.
Options
CSV file
Specify the source CSV file to be converted. Specify one of the following CSV files:
Job net definition CSV file
CSV file with the job net control statements and job control statements entered.
Group definition CSV file
CSV file with the group control statements and control statements for job nets within groups entered.
Calendar holiday definition CSV file
CSV file with the calendar holiday control statements entered.
Schedule pattern definition CSV file
CSV file with the schedule pattern control statements entered.
The format for each CSV file is shown below.
- Format for job net definition CSV files
Create job net definition CSV files using the following format:
NET
control statement, control statement, ...
option value, option value, ...
JOB
control statement, control statement, ...
option value, option value, ...
option value, option value, ...
.
Enter "NET". "NET" is the keyword that indicates the beginning of a job net control statement.
Enter the options of the job net control statement. Make sure to enter the mandatory options. See "4.9.1 Job Net Control Statement" or further information on options.
Enter the values of the options in the same order as those entered in Row 2. The values for these options can be omitted.
Enter "JOB". "JOB" is the keyword that indicates the beginning of a job control statement.
Enter the options of the job control statement. Make sure to enter the mandatory options. See "4.9.2 Job Control Statement" or further information on options.
Enter the values of the options in the same order as those entered in Row 5. The values for these options can be omitted.
The synopsis is the same as for Row 6. Add as many lines as the number of jobs to be registered.
Note
If there are multiple option values for a single control statement, use a semicolon (;) to separate option values. If there are multiple schedule patterns, however, delimit them with spaces.
- Example of how to create job net definition CSV files
NET jobnetname,jobnetcomment,starttime,execpattern,holidayshift,defaulthost,job,operate hanbai,Sales Management,2000,Every Friday,IGN,king,4,PAUSE JOB jobname,jobnumber,jobcomment,restartpoint,pre_job,iconposition,operate kanri1,1,Customer Inquiry,ON,1;1,NONE kanri2,2,Payment Details,,1,1;2, NONE kanri3,3,Data Search,,1,2;2,DISABLE kanri4,4,Backup,,2;3,1;3,NONE
- Format for group definition CSV files
Create group definition CSV files using the following format: GRP control statement, control statement, ... option value, option value, ... GNT control statement, control statement, ... option value, option value, ... option value, option value, ... .
Enter "GRP". "GRP" is the keyword that indicates the beginning of a group control statement.
Enter the options of the group control statement. Make sure to enter the mandatory options. See "4.10.1 Group Control Statement" for further information on options.
Enter the values of the options in the same order as those entered in Row 2. The values for these options can be omitted.
Enter "GNT". "GNT" is the keyword that indicates the beginning of a group job net control statement.
Enter the options of the group job net control statement. Make sure to enter the mandatory options. See "4.10.2 Group Job Net Control Statement" for further information on options.
Enter the values of the options in the same order as those entered in Row 5. The values for these options can be omitted.
The synopsis is the same as for Row 6. Add as many lines as the number of job nets in a group to be registered.
Note
If there are multiple option values for a single control statement, use a semicolon (;) to separate option values.
- Example of how to create group definition CSV files
GRP groupname,groupcomment,jobnet shuuhou,Weekly Report,2 GNT jobnetname,jobnetnumber,pre_jobnet eigyou,1, hanbai,2,1
- Format for calendar holiday definition CSV files
Create calendar holiday definition CSV files in the following format:
HOL |
Enter "HOL". "HOL" is the keyword that indicates the beginning of a holiday information control statement.
Enter the options of the holiday information control statement. Make sure that mandatory options are entered. Refer to "Holiday Information Control Statement" for details about options.
Enter the option values, matching the order of the options in row 2. Option values can be omitted.
Note
If there are multiple options values for a single control statement, delimit them with semicolons (;).
- Example of how to create calendar holiday definition CSV files
HOL |
- Format for schedule pattern definition CSV files
Create schedule pattern definition CSV files in the following format:
CAL |
Enter "CAL". "CAL" is the keyword that indicates the beginning of a schedule pattern control statement.
Enter the options of the schedule pattern control statement. Make sure that mandatory options are entered. Refer to "Schedule Pattern Control Statement" for details about options.
Enter the option values, matching the order of the options in row 2. Option values can be omitted.
Note
If there are multiple options values for a single control statement, delimit them with semicolons (;).
- Example of how to create schedule pattern definition CSV files
CAL |
Command Location
Windows | Systemwalker Operation Manager installation directory\MpWalker.JM\bin |
Solaris | /usr/bin |
Output Example
The following example shows the output results for this command if the CSV files shown in the examples of how to create CSV files are input.
- Output example of information on job net control statements and job control statements.
NET jobnetname selling jobnetcomment SalesManagement holidayshift IGN execpattern EveryFriday starttime 2000 defaulthost king job 4 operate PAUSE ; JOB jobname management1 jobnumber 1 jobcomment CustomerInquiry restartpoint ON iconposition 1,1 operate NONE ; JOB jobname management2 jobnumber 2 jobcomment CreditDetails pre_job 1 iconposition 1,2 operate NONE ; JOB jobname management3 jobnumber 3 jobcomment DataSearch pre_job 1 iconposition 2,2 operate DISABLE ; JOB jobname management4 jobnumber 4 jobcomment Backup pre_job 2,3 iconposition 1,3 operate NONE ;
- Output example of information on group control statements and group job net control statements
GRP groupname weeklyreport groupcomment WeeklyReport jobnet 2 ; GNT jobnetname sales jobnetnumber 1 ; GNT jobnetname selling jobnetnumber 2 pre_jobnet 1 ;
- Output example of information on the holiday information control statement
HOL |
- Output example of information on the schedule pattern control statement
CAL |