Failure while importing users in Spotfire Analyst. Error: Error parsing the uploaded document: Incorrect number of columns in line #XXXXX: expected 5, was 6

Failure while importing users in Spotfire Analyst. Error: Error parsing the uploaded document: Incorrect number of columns in line #XXXXX: expected 5, was 6

You may come across below error while importing users in TIBCO Spotfire Analyst using Administration Manager :

Error message: Could not import users.

UserDirectoryServiceException at Spotfire.Dxp.Services:
Error parsing the uploaded document: Incorrect number of columns in line #288: expected 5, was 6 (HRESULT: 80131509)

Stack Trace:
   at Spotfire.Dxp.Services.WebServiceBase`1.InvokeService[T](ServiceMethod`1 serviceMethod, ExceptionFactoryMethod exceptionFactoryMethod, String customMethodNameForLogging)
   at Spotfire.Dxp.Services.UserDirectory.UserDirectoryService.ImportUsers(ImportUsersFlags flags, String attachmentId)
   at Spotfire.Dxp.Forms.Application.Administration.AdministrationForm.<>c__DisplayClass54_0.<importUsersButton_Click>b__0()
   at Spotfire.Dxp.Framework.ApplicationModel.Progress.<>c__DisplayClass21_0.<Start>b__0()
   at Spotfire.Dxp.Framework.ApplicationModel.MonitorableProgress.Start[T](Func`1 action)
   at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()

Cause:
This is due to a syntactical error in the text file format used for importing users in Spotfire.

Below is the file format to bulk import the users:

User name;Domain name;password; display name;email

Example:
----------- 
Test ; SPOTFIRE ;Test123; Test ; Test@mydomain.com

Test1 ; SPOTFIRE ; spotfire123;Test1 ; Test1@mydomain.com
------------
In above file format, if you put  extra semicolon ( ; ) like below at the end of any line by mistake, it throws error for that particular line number while importing users: Incorrect number of columns in line #XX: expected 5, was 6

Erroneous example:
------------ 
Test ; SPOTFIRE ;Test123; Test ; Test@mydomain.com;
------------ Remove the extra semicolon ( ; ) from mentioned line number in error message to resolve this error and re-import the users.

• How to add/import users and groups in bulk to Spotfire, using Administration Manager in Spotfire Analyst.
  • https://support.tibco.com/s/article/Sample-file-to-Add-Import-users-and-groups-in-bulk-to-Spotfire-using-Administration-Manager-in-Spotfire-Analyst