Checking PPNs pre import

[andynewey]

Is there any way I can check the part numbers of an import file before importing it.  I have an historic entitlement file with early 2000 lines of entitlement in it and the reseller has a history of of providing incorrect part numbers.  Ideally I would like to run this check myself without the need of a developer to run a script.

[Mark Manders]

How are they imported? How can the system check if the numbers are correct? Is it about duplicates, or formats? If there is a way this can be done through a script, you can apply that to the transform map/import set, but that only works if that's the way you import.

Please provide more information on the import and how the check should be done. Because the answer to your current question can either be 'check the list before it's imported manually' to 'run the import with a complex script that only has to be created once'.

[dreinhardt · Accepted solution]

Hi @andynewey,

of course, you can use the PPN table [samp_sw_product_definition] and provide all part numbers as a "IS ONE OF" filter. This will also help you to get insights about the used Publisher/Product per PPN.

Please add the column "Active", based on this you can identify active/inactive PPN

Best, Dennis

[andynewey]

Thank you for this. I was expecting days of working through these part numbers individually.  I never knew how powerful the filter was.