🐞 Another CSV import bug I just ran into - I just uploaded a batch of new contacts. A few were repeat participants. Instead of it merging the new data into the old contact entry, it replaced it, therefore unlinking the old interviews!! I'm pretty positive I selected "Merge". The new entry also didn't fully upload some of the date fields... I guess I'll re-upload later when all this CSV stuff is fixed (and then re-link those old interviews. Luckily I remember them)
Hi Emi Fogg, thank you for raising this issue with us and I'm sorry to hear that you ran into this bug. I'm one of the engineers who has been working on the Contacts page recently, so I'll be looking into this. Just to ensure I've got a full understanding of the bug, can you please confirm that this is all correct?
You had some existing contacts already in your Contacts page.
You uploaded a CSV which contained a mix of new and existing contacts.
You selected Merge.
Once it finished, the new contacts uploaded fine.
Unfortunately, the existing contacts were overridden by your duplicate versions from the CSV.
As a result, the affected contacts were unlinked from transcripts.
In addition, some of the date fields in the CSV did not upload.
I also had a few clarification questions which will help me narrow down the root cause. Any info you can give would be appreciated:
Which field did you merge on?
Did your merged contacts wipe out any existing data? That is, if you had any field data, was it removed after the CSV upload finished?
For the dates which didn't upload, can I ask what format the dates were in? Eg "01-20-2024", "20 Jan 2024", etc.
For the affected date fields, did all contacts in your CSV skip that column, or just a few of them?
Feel free to DM me if you have any PII concerns about replying in this thread.
The new contacts uploaded mostly fine. Some also had issues with Date fields not populating.
I merged on a number field (a user ID)
Did your merged contacts wipe out any existing data? That is, if you had any field data, was it removed after the CSV upload finished? The one contact that should have merged was the one that deleted the old entry
Just a few of the dates were affected. I can share the CSV I uploaded in a DM