Top
Systemwalker Desktop Patrol Reference Manual
FUJITSU Software

1.25 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, enclose the whole path in quotes. In addition, apart from quotes, the maximum string of 128 fullwidth characters or 256 halfwidth 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

Other than 0: ended abnormally

Command saving location

The following folder in CS:

CS Installation Directory \bnserv\bin


Authority required for execution/executing environment

Cautions

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 The double quotation mark is not closed.

File: mail.csv Line: 50 Corresponding User ID: ABC000001 does not exist.

File format

No.

Item

Description

1

Contents

Exceptional contents

Error contents

Exceptional Contents

Variable Information

Cause

Resolution

File: %s Line: %d The double quotation mark is not closed.

%s: Input file name

%d: incorrect line number exists

Double quotes are not correctly used to enclose the items.

Enclose each item with double quotes correctly.

File: %s Line: %d 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).

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. Refer to "3.3.2 Messages Output in Master Data CSV Export Command" for details.