A user experimenting with this import tried the appended CSV data into their Tree. They were confused when the Import created the “Roger Moore” without apparent issue. However, the new person showed no sign of the 1924 Occupation of Barrister and the 1926 Residence in Anglia.
The problem was that they specified I00001 for Moore… but there already existed a Person with that ID. So that conflict caused the import to assign the next available ID to Roger Moore. That was the correct behavior. (If the Import was supposed to overwrite the names of that pre-existing Person and add the Occupation and Residence from the first table, then that ID should have had square brackets too.)
Yet the for the Event adding lines, the [I00001] successfully found that pre-existing individual and added the Occupation and Residence to that person.
They need to Edit → Undo CSV Import immediately. (Or at least lookup Individual I00001 and see how many extra Occupations and Residences need to be deleted.) This is a reminder that Import is a risky process. Always make a backup before risky processes.
Finally, always check the ranges of IDs in your tree before importing. Any IDs specified in the CSV should start after those if your import uses the square brackets feature.
Person, firstname, lastname, birthdate, birthplace, occupationdescr, occupationdate, occupationplace, residencedate, residenceplace
I00001, Roger, Moore, 01.01.1901, Houston, Actor, 02.02.1920, Maine, 03.05.1920, New York
Person, occupationdescr, occupationdate, occupationplace, occupationplace_id, occupationsource, residencedate, residenceplace, residenceplace_id, residencesource
[I00001], Barrister, 03.04.1924, Scotland, , , 03.05.1926, Anglia, ,
Let’s try again with suffixes for the IDs that will ensure uniqueness.
Person, firstname, lastname, gender, birthdate, birthplace, occupationdescr, occupationdate, occupationplace, residencedate, residenceplace
I00001_aug2024, Roger, Moore, male, 01.01.1901, Houston, Actor, 02.02.1920, Maine, 03.05.1920, New York
Person, occupationdescr, occupationdate, occupationplace, occupationplace_id, occupationsource, residencedate, residenceplace, residenceplace_id, residencesource
[I00001_aug2024], Barrister, 03.04.1924, Scotland, , , 03.05.1926, Anglia, ,