Number fields in SharePoint list (UniFi -> IT Glue scripts) #4
Description
Thank you for your UniFi to IT Glue scripts - I managed to get them working yesterday, there were a couple of small issues (a random "g" which caused an error, and two errors about whitespace before "@)
But, the biggest problem was none of the sites which matched made it to the second list of matched sites.
After pulling my hair out for a while it's because SharePoint Lists have a 15 digit limit on the number of digits and the IT Glue IDs are 16 digits long so when they were stored in SharePoint they were all rounded to the nearest 10! I manually changed the List settings in SharePoint to a Text field for both lists and this seems to have resolved the problem!
I'm guessing IT Glue must have increased the length of their fields since the scripts were written.
Putting this here in case it helps anyone else :-)