Issue with order line item number during impex execution

[Former Member]

We use linenumber attribute from AbstractOrderEntry for order line item number. We receive order line details from external ERP system. We used to receive line number as 1.1, 2.1, 3.1... etc. But some occasions we receive line number as 1.1.1, 1.1.2 or 1.1..1, 1.1..2 and in this case this line items are not getting updated in order entry.

Sample Order Impex for your reference:

insert_update orderentry;order(OrderNumber)[unique=true];lineNumber[unique=true];reqShipDate[dateformat=yyyyMMdd];entryNumber;itemSubNum;product(code,$catalogVersion) ;"ORDID";"1.1";"20180913";"0000000000000011";"11";"PDT_CODE_1"; ;"ORDID";"2.1";"20180913";"0000000000000021";"21";"PDT_CODE_2"; ;"ORDID";"1.1.1";"20180913";"0000000000000011";"11";"PDT_CODE_3"; ;"ORDID";"1.1.2";"20180913";"0000000000000011";"11";"PDT_CODE_4"; ;"ORDID";"1.1.3";"20180913";"0000000000000011";"11";"PDT_CODE_5"; ;"ORDID";"1.1.4";"20180913";"0000000000000011";"11";"PDT_CODE_6"; ;"ORDID";"1.1..5";"20180913";"0000000000000011";"11";"PDT_CODE_7";

FYI - We already have millions of order existing in table. Could you please let us know what we can do here.

[former_member1320010]

Hi , the entryNumber is same for below entires . is this intentional ?

;"ORDID";"1.1.1";"20180913";"0000000000000011";"11";"PDT_CODE_3"; ;"ORDID";"1.1.2";"20180913";"0000000000000011";"11";"PDT_CODE_4"; ;"ORDID";"1.1.3";"20180913";"0000000000000011";"11";"PDT_CODE_5"; ;"ORDID";"1.1.4";"20180913";"0000000000000011";"11";"PDT_CODE_6"; ;"ORDID";"1.1..5";"20180913";"0000000000000011";"11";"PDT_CODE_7";

[Former Member]

Yes, and all this details are coming from external system.

[geffchang]

Personally, I think this is a data management issue. Delete the incorrect records, and re-import correct data.

[Former Member]

This order details are coming from external system where we can't change the format. When I execute the above the impex only 2 line items are getting added. which is 1.1 and 2.1