When attempting to load an XML file into CA-CMDB using the GRLoader utility, GRLoader may give an error that a date value is unparsable or has an invalid format. If the XML was created by an Advantage Data Transformer script, it will have been generated with a string date in the format Mon dd, yyyy. GRLoader requires yyyy.mm.dd. Both are valid date formats, but for GRLoader, the date generated by ADT needs to be converted to the format acceptable to GRLoader. The attached ADT Reusable Transformations can be imported into Mapper and used to convert values of any date datatypes to strings in the proper format for GRLoader.
Whether the date is coming from Excel or a database such as SQL Server or it's the System Date, you'll need to convert it to the format GRLoader wants as input. GRLoader doesn't care if the value includes the time or not, but the date format is year first and dots between date parts. Attached is an ADT export file containing a set of Reusable Transformations to do this. GRLoader will load a default time of 12:00 AM, ignoring the time value in the XML if it exists.
Reusable Transformations to convert dates to the format required by GRLoader.
If you get a script generation error about mismatched types, DATE and DATETIME, then you may need to switch between "Date_2_YYYYMMDD_wDots" and "DateTime_2_YYYYMMDD_wDots".
Instructions for installing Reusable Transformations.
Note about modifying Reusable Transformations
When any instance of an RT is modified, that change is propagated to every instance - on other programs as well as in the metadata store - so it's recommended that before making any changes, backup the original Reusable Transformation. If you find later that you need that original form in another program, it will still be available.