What is the correct date format when loading data into CA Service Desk Manager using GRLoader?

book

Article ID: 37198

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Issue

When loading data using GRLoader, the load fails with errors on the date format:

<!--WARNING: Entry was processed successfully, but had warnings. See Below.-->

 <id>4E226092A6CD59498D248A08754A37BD</id>

 <name>100253017</name>

 <!--WARNING: Invalid DateFormat (MM/DD/YYYY).-->

What is the correct date format when loading data into CA Service Desk Manager using GRloader?

Environment

CA Service Desk Manager 12.7, 12.9 and 14.1

Windows 

Resolution

If using MS Excel to create the XML file to be used with GRLoader, mark all the columns as "text", left justified and set the date format of these columns to be "YYYY.MM.DD".

The date format has to be changed to avoid the date error and data to be loaded using GRLoader.

 

Additional Information

GRLoader error, date unparsable or has invalid format, in ADT-generated XML

 

Environment

Release: SDMU0M99000-14.1-Service Desk Manager-Full License
Component: