Hello. I'm not sure when it occurred, but I recently noticed that the excel template for the Import User SDK example has broken help columns for Groups and Reporting groups, where they formulars just show a REF error. I believe this will affect how users interact with this example.
You need to be logged in to reply to this post and participate in the Geotab Community discussions.
Hi @AshleyFC-1448 ,
I think something is definitely broken. I can't even login to download the template. I keep getting this error: 
Hi @ssartor-1546
I'm not having any issues logging in to any database I have access to.
If I use the web form to create the user to be imported, everything works as expected, except the Excel template is currently broken.
The direct link to the Excel template is - https://geotab.github.io/sdk/software/js-samples/templates/import-users-template.xlsx
Hi @AshleyFC-1448 ,
I downloaded the template you linked and I'm not seeing and #REF errors. Those cells shouldn't have any formulas in them, since you're just filling out the groups.
Edited by AshleyFC-1448
@ssartor-1546 - They are in a column that is hidden by default after Group Names(s) in Column F and Reporting Group Names(s) in Column I
From what I can gather from the IF statements, they are attempting to validate if the separator between named groups is valid.
It is possible that whatever data these helper columns provide is no longer needed, as the Data to Import column doesn't pull from these helpers.
I think those columns are probably deprecated from a previous version. You can just ignore them and fill out the template like normal and everything still works. Just use column AI for validation. Once that turns green you know you've filled everything out properly.
Thanks @ssartor-1546 , I was provided the sheet from a client having issues with it. They had Green in column AI, but due to the groups being incorrectly named, such as "Company" rather than "Company Group", it was giving them some pain points.
I managed to assist with it using a script of my own :D