Does the GRLoader utility convert spreadsheet data types?

Document ID : KB000056593
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Does the GRLoader utility convert spreadsheet data types?

Solution:

While importing data from an Excel spreadsheet, GRLoader automatically performs data conversions. 

  • The dates specified in the spreadsheet are automatically converted into the standard CA Service Desk Manager (CA SDM) dates in the yyyy.mm.dd hh:mm:ss format
  • The numeric values specified in the spreadsheet are automatically converted to strings
  • The boolean values specified in the spreadsheet are automatically converted into 0 or 1
  • Strings are NOT altered.
  • Blank spreadsheet cells are ignored by GRLoader
  • If GRLoader finds a formula, it first evaluates the formula and then applies the specified rules based on the result