Modbus Client- Importing Register/Channel Settings

I have hundreds of Modbus holding registers that I'd like to populate as channels in the Modbus client. Each has a unique name and there is a variety of different scaling factors and units. There appears to be two methods for populating the channels: Input each individually or import them all at once using a special XML format. The single input method would be very time consuming and the XML format doesn't appear to be user friendly. I have the channel information populated in an Excel table formatted with the following headings:

ADDRESS, NAME, UNITS, Display Type, SCALE, OFFSET, DATA TYPE, Decimals

Is there a way to convert this table to the XML format so that it can be imported into the Modbus Client? Or is there some other method to facilitate creation of hundreds of Modbus channels?

Thanks

Matt

Hi,

here is the XML of one channel. All the things that you listed except the display type are visible. If you create a script it shouldn't be hard to parse it with your file.