AnsweredAssumed Answered

Asset import data greater length than destination field

Question asked by Manirul_Hak on Nov 5, 2015
Latest reply on Nov 13, 2015 by Alexandre_Almeida

Hi Team,

I am importing huge amount of asset data but there are some field which are showing error as the length of some source field data is greater than the destination field max size.As for example, PO Number in source csv is more than 20 characters but the maximum acceptable value in destination field is 20. So its showing error:- Web Service threw exception CA.Common.Utilities.Exceptions.ValidationException: 1. The Purchase Order ID contains data with an invalid type or size. The expected data type (size) is string(20), and the actual data is ***********

at CA.Applications.Business.Asset.Save()

at WebService.Service.SaveWithNormalization(Byte[] RequestStream)

For some other fields ,I am facing the same issue as for example for Room Location.It takes max 30 string but the data we have in this field is greater than 30 character. I can not change these values as these are customer provided and they dont want to change these values as well. So how can I resolve this issue?

Someone please help me to get it resolved.