The Serial Number inserted via GRLOADER is getting modified when it's only numeric.

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

In the CI detail page, the Serial Number updated via GRLOADER is different than what is mentioned in the load file.

 

Steps:

-> Create an input file with the serial number '3669687248'.

system_name	class	serial_number	name	resource_status	Family			model	manufacturer	status
1	Application	3669687248	TestCI100	Active	Software.Application			B8075	Xerox	Active

-> Load via GRLOADER:

Grloader -u Username -p Password -s http://<hostname:port> -i test.xlsx -a -n -E

-> In the GUI the serial number is changed:

Environment

Service Desk Manager 17.x

Resolution

The reported behavior is by design for numeric values.

Grloader Reads Excel file/spreadsheet first by capturing values ---> Passed on to GRLoader Core logic to determine what data is passed and what column types are ---> Then calls SDM web services to create database entry.

So when Grloader reads the Excel sheet, it reads as NUMERIC data, and since it is greater than 2147483647 (the integer maximum that can be stored in SDM). It only reads as 2147483647.

As a workaround for the serial_number column, ensure the formatting/conditional formatting is changed for the column from NUMERIC to text.  Or the value can be a mix of numbers and letters. This would load the data perfectly.