Transform script asset upate

Brian DeBlis
Tera Expert

Hi all,

I am trying to create a transform script that updates all assets under a single purchase order line with asset tags and serial numbers. Since the only field to coalesce is the POL and is the same value, how do I update all records? For example, I have 250 different asset tags and serial numbers, but all 250 have the same POL number, how do I write a transform script for that? 

2 REPLIES 2

Tony Chatfield1
Kilo Patron

Hi, exactly what\how is entirely dependent on your configuration and data and neither are clear from your post.

Does your import file have 1 row per Asset? If yes then what are the unique identifiers for the Assets model, serial number etc in the file and do these values map to exists Assets and product models in your instance?
If you could share example import data and example of exists asset data (excel, csv or plain text) it would be easier for the community to review and advise.

Tony,

You are correct that it is 1 asset per row. The only identifier is the Purchase Order line, which is not unique that ties them all together. What I am trying to do is to map asset tag and serial number to assets created from receiving a POL automatically. Here are the fields in the excel that is being used as the source.

 

BrianDeBlis_0-1690816084649.png