Mass updating Custom Fields.

[Tomas]

I have an excel sheet with Serial numbers and Inventory ID’s. What would be the best way to Mass update a Custom field with the Inventory ID’s based on the Assets Serial number?

[B_L_]

personally I would create individual queries based on every line, split them in batches.
Run a small batch and then update them all.
individual queries have the advantage that -to me- it's often easier to spot differences, weirdnesses and so on.