Skip to Main Content
OIDC Test User Management Ideas Portal
Status Needs review
Created by Guest
Created on Jan 20, 2021

csv header discrepancy

It is not easy to export a user list and then simply re-imort it using the mass update tool:

the columns are not identical, but that is less a problem (you have to add a column for new email address and delete the last to time based colums, that's easy).

What is cumbersome is that the header naming is not identically and has to be corrected. The csv from the export seems to be newer, but the mass update csv accepts only those of slightly different naming:

EXPORT HEADER:

CurrentEmail (required),FirstName,LastName,ProfileCountry,Language,EntitlementCountry,EntitlementGroup(s),CostAllocationGroup,UserManagementGroup(s),Role(s),GlobalFulfillmentContact,FulfillmentContactCountry(s),Locked ....

UPDATE HEADER:

CurrentEmail (required),NewEmail (only required if changing email address),Firstname,Lastname,ProfileCountry,Language,EntitlementCountry,EntitlementGroups(s),CostAllocationGroup,UserManagementGroups(s),Role(s),GlobalFulfillmentContact,FulfillmentContactCountry(s),Locked

(differnces in plural, and capital letters)

  • Admin
    Marcus Kellermann
    Reply
    |
    Jun 10, 2021

    Robin, can you please ensure that you are saving your file as UTF-8 encoded file. Some text editors will switch it to Ansi which will break non-Asci characters. If you are still have issue please submit a service request and our support team will help workout any issues

  • Guest
    Reply
    |
    Mar 23, 2021

    Has this been addressed? Several days ago I could still mass update users, and now (since today) I cannot even use the example file that can be downloaded as an update template, as the process tells me that the headers are not correct...