I am trying to import on my Items & BOMS WS Item Details (See attached for screen shot of import)
I have a series of fields that are filtered picklist to a workspace, which in turn for the fields used in the Item WS workspace filtering from the linked WS are also single selection picklist.
Is it not possible to import so that these filtered picklist get in the Item WS get a valid value during the import.
Is the only way to then update to manually go throught the new imported records and make valid selections for these filtered picklist fields (crappy due to the large amount of records I have to import).
Ok, I can live with the manual update, I have also come up with a script upon editing of an Item to verify these picklist fields since they define my part number scheme, I can validate from my part number field.
But it will be much easier to load items than to edit them.