Import user database from spreadsheet

[Paul Heneghan]

Hello all,

Has anyone got any clues as to how I can import a user database from a spreadsheet? We've got about 650 users on an antiquated access system that happened to use Dallas DS1990A buttons. We've just bought a miniserver and are trying to work out how to get our user database across without having to add our users back in one by one.

Can I do text/decimal/hex manipulation in the spreadsheet to generate the appropriate XML to go in the config file? I can see a few complications with this straight away:

- We only have the iButton serial numbers in the old system - no family code (probably 01), but more worryingly, no CRC

- Excel doesn't seem to like 8-byte Hex numbers, so I might have to use Python or similar to handle the iButton numbers

- Having looked at the xml config file in Loxone, I don't know how some of the attributes are generated or what they do - see U and WF below:

<C Type="UserCaption" V="109" U="0e07eb3c-0343-029e-ffffe04fce2221dd" Title="User">

<C Type="User" V="109" U="0e07eb3c-03a7-04d2-ffffe04fce2221dd" Title="admin" Pwd="xxx" LastEdit="0" Main="true"/>

<C Type="User" V="109" U="0e19d43c-0175-0ed2-ffffe04fce2221dd" Title="Heneghan_Paul" WF="16384" Pwd="xxx" Pwd2="xxx" LastEdit="0" iButton="504403223651134209"/>

</C>

I would also like to populate the user groups ...

Cheers,

Paul