Page 1 of 1

SalesQuote XML Import CustomFields SettingID spaces

PostPosted: Mon Apr 15, 2019 9:24 pm
by pricerc
This had me a bit puzzled.

Writing a transform to convert XML files designed for Jiwa6 into Jiwa7 format.

I wasn't expecting the trailing spaces in CustomField/SettingID to be significant, but it seems they are; I needed to pad them out to 36 characters to be recognised.

The clue was in one that I had exported that had them in.

Re: SalesQuote XML Import CustomFields SettingID spaces  Topic is solved

PostPosted: Tue Apr 16, 2019 10:28 am
by Mike.Sheen
Yes - I can see for example when the Inventory Maintenance deserialises the legacy XML it tries to locate the custom field using the item index untrimmed:

Code: Select all
Dim customField As JiwaApplication.CustomFields.CustomField = CustomFields(xmlCustomField.SettingID)


If we trim that SettingID it'd be able to locate the SettingID and go on to deserialise the value correctly.

Logged DEV-7428 to look into this.

Re: SalesQuote XML Import CustomFields SettingID spaces

PostPosted: Tue Jul 09, 2019 10:40 am
by pricerc
Thought I should report that this problem appears to exist in

Code: Select all
SalesOrder.CustomFieldValues.ItemFromSettingID("52C6823F25454A2FAC3E")


So if your deserializer is using that method, it would account for the problem.