Importing assets via csv - creates identical user
I am using ServiceDesk plus for asset/facilities management for my organisation. Before SD+ i had all my asset information on an Excel spreadsheet.
I have since been able to modify the spreadsheet to suit SD+ and saved it as a csv file.
One of the columns in the CSV file is "User".
The problem is when I import the csv file and map the user column to the corresponding "user" field, SD+ creates a new user with an identical name and doesn't use the user information thats already in SD+. So i end up with duplicates of each user;
I now have the task of re-assigning all 400 assets to the correct user name so that relationships can be formed... then delete the phantom users that have been created.
Has anyone had a similar problem and is there a solution?
I have since been able to modify the spreadsheet to suit SD+ and saved it as a csv file.
One of the columns in the CSV file is "User".
The problem is when I import the csv file and map the user column to the corresponding "user" field, SD+ creates a new user with an identical name and doesn't use the user information thats already in SD+. So i end up with duplicates of each user;
I now have the task of re-assigning all 400 assets to the correct user name so that relationships can be formed... then delete the phantom users that have been created.
Has anyone had a similar problem and is there a solution?