I'm going to raise this query with an example, see if anyone can give me an idea/solution.
I have María Pérez Fernández (username mperezf)who has been a user of the platform for two years.
It joins the company Martina Pérez Flores, along with 49 other people, and, therefore, I prepare a csv with the data of the 50 new users. The username for Martina is mperezf.
Result: after uploading the csv with the data of the new users, the user of Martina Pérez Flores will NOT have been created and the user of María Pérez Fernández will have become the data (name, surname and all others) of Martina Pérez Florez.
The problem is the matching username. Logically the username has to be a unique data, which is not repeated. But, you shouldn't skip a warning message like "The mperezf user already exists, your data will be modified, are you sure you want to continue?"
Is there a quick way to verify that in the csv there is no username that is identical to that of another user already existing on the platform? I can only automate it, in a way, as follows: export all users already created on the platform to an Excel, add the new ones and search for duplicates. But I still find it a task that consumes an exaggerated time.
Are there any rules that 100% guarantee that a username has not been created before?
We see that the functionality of creating users using csv is very limited, because it only works when the username does not co-indice with any other. If it matches, the information is always overwritten. Also, this happens without you being aware of what's going to happen, because at no point do you get a warning message about what's going to happen (it can take quite a while before you realize the error):
If you checked the S option in the csv, all the data you've put in the csv, including empty data, is overwritten. That is, all the data in the username row will be assigned to the previously existing user and if there is any empty field in the csv, it will also be flushed to the previously existing user.
If in the csv you have checked the option M, do not force the data, so if there is an empty field in Excel, the one that already existed will be respected, but all those listed in the Excel will be assigned to the existing user previously.
Couldn't there be, for example, a "create" C operation, in which data is never overwritten and warned in the event that you try to create a new user with an existing username?
My idea of improvement is that some procedure is enabled to generate new users (not to modify existing ones) by uploading a csv, ensuring that the data of an existing user will not be overwritten.
Customer support service by UserEcho