Top
Systemwalker Desktop Patrol V14g Reference Manual
Systemwalker

1.22 dtpmstcv.exe(CSV Conversion of Master Data)

Functionality

This command converts the Master data in CSV format created in the version prior to Systemwalker Desktop Patrol V13.0.0 into a new format later than Systemwalker Desktop Patrol V13.0.0.


Record format

Dtpmstcv.exe

Input File Name


Option

Input File Name:

Specify the file list (ini file) of conversion object. It cannot be omitted.

When the path contains space, please enclose the whole path in quotes. In addition, apart from quotes, the maximum string of 256 characters can be specified.

The format of the file list of conversion object is shown as follows:

[USER]

EMP_FILE=c:\v12\emp.csv    ・・・・・・  Employee Master CSV (Input)

SECT_FILE=c:\v12\sect.csv ・・・・・・ Affiliated Master CSV (Input)

MAIL_FILE=c:\v12\mail.csv ・・・・・・ E-mail Master CSV (Input)

PASS_FILE=c:\v12\pass.csv ・・・・・・ Password Master CSV (Input)

OUT_FILE=c:\v13\user.csv ・・・・・・ New User Management Information CSV (Output)

[GROUP]

GRP_FILE=c:\v12\grp.csv ・・・・・・ Section Mater CSV (Input)

OOUT_FILE=c:\v13\grp.csv ・・・・・・ New Section Management Information CSV (Output)

[ERROR]

ERR_FILE=c:\v13\err.dtl ・・・・・・ Error Details File


Return value

0: ended normally

Non-zero: ended abnormally


Command saving location

The following folder in CS:

CS Installation Directory \bnserv\bin


Authority required for execution/executing environment

Cautions

When the specified output file has existed in OUT_FILE parameter of conversion object file list, overwrite it or delete it when an exception occurred. If the file created previously is required, please modify the file name or move this file to another location before executing this command.


Command execution example

Specify the conversion object file list “C:\mast\dtpmstcv.ini”, and converts Master data.

"C:\Program Files\Fujitsu\Systemwalker Desktop Patrol\bnserv\bin\dtpmstcv.exe" C:\mast\dtpmstcv.ini


Execution result/output format

As the conversion source data format causes the failure, the causes of exception will be output to the error details file specified in ERR_FILE parameter of conversion object file list.

An example of an error details file is shown as follows:

File: emp.csv Line: 90 Double quotes are not matching.

File: mail.csv Line: 50 The corresponding user ID: ABC000001 does not exit.


File format

No.

Item

Description

1

Contents

Exceptional contents


Error contents

Exceptional Contents

Variable Information

Cause

Resolution

File: %s Line: %d Double quotes are not matching.

%s: Input file name

%d: incorrect line number exists

Double quotes are not correctly used to enclose the items.

Please enclose each item with double quotes correctly.

File: %s Line: %d The corresponding user ID: %s does not exist.

%s: Input file name

%d: incorrect line number exists

%s: user ID

The data corresponding to user ID of input data does not exist in the employee Master of conversion object (old CSV format).

Please check the conversion object file and confirm whether the user ID is correctly defined.

When the processing failed, a message indicating failure will be output. Please refer to “3.3.2 Messages Output in Master Data CSV Export Command” for details.