I have been trying to write a macro in Excel for manual input data, by using Piputval with AF attributes as data reference. So far all is working well, but im wondering, is there a way that I can pass another argument with Piputval, for the engineering unit? I would like the user to have an option to enter data with engineering unit, and AF will handle the conversion on storing the data to PI back.
Would it be possible to pass the engineering unit?
The PiPutVal does not support providing an UOM. Best option i can think of is creating the UOM-logic in the Excel-client. To prevent a requirement to maintain UOM conversions in Excel, you could create a number of sub-attributes for each UOM you need to support and select the appropriate attribute to write to in Excel based on the user selected UOM.