Bulk updating records
I've searched to see if anyone has had this error and I can't find anything but I might be search for the wrong thing!
I've uploaded a list which I'm happy with, now I want to upload those names again and update the information for those contacts which have changed (overwrite).
But when I upload the .csv again, I'm told that it doesn't work because they're duplicates.
Am I doing something wrong or is there a workaround?
11 Replies
Made some progress. Am able to now fully overwrite tags (multi-select) but the issue is that it seems to fully overwrite XD. Step forward. Will report back more progress.
The key change I made was to export the people from Twenty and then I left the IDs in. Presumably that made the system happy that I was 100% trying to overwrite those people (as opposed to trying to use the same emails for two differetn people).
Yeah I am now stuck.
This interacts with an issue with was PRed successfully today: https://github.com/twentyhq/twenty/issues/8822 by @Elias Ylönen
I can export and edit and then re-import the information with succesful overwrite but I can't overwrite with two different entries for the multi-select 😂
I was originally trying to use this as a workaround so now I need a workaround for my workaround...
GitHub
Multi-select field CSV import does not work · Issue #8822 · twentyh...
Bug Description Importing multi-select values from a CSV does not work. Steps to reproduce: Reset database Open companies Display Work policy field in the companies table Export companies Import ex...
GitHub
CSV importing and exporting fixes by eliasylonen · Pull Request #88...
Fixes issue #5793 (and duplicate #8822)
Fix importing multi-select and array fields.
Fix exporting and importing RAW_JSON fields.
Hi Will! 👋
Would you be able to share
- a small CSV of dummy or non-sensitive data that reproduces the issue (with as few rows and cols as possible)
- screenshots of the import window steps and the result of the import? (without sensitive data).
Then I could try to reproduce the issue on mine!
Is the issue happening in twenty.com (production), in a self-hosted environment or in a local development environment?
Just to clarify — what is getting overwritten by what?
1. upload file with multiselect1
2. upload same file (with Twenty's IDs) now with (only) multiselect2
3. Those records now only have multiselect2
I was intending to use this as a workaround for not being able to upload more than one multiselect. I was hoping the functionality would be the same except
1. ...
2. ...
3. These records now have multiselect1 and multiselect2
This is occuring in prod (twenty.com)
This .csv has the two multiselects that I'm trying to upload and results in this error
Here's the error msg and the terms in the data model
This list with one multiselect will work and will (of course) produce one multi-select in the Twenty table
This list produces a simple duplicate
This list (The same as list 4 but with Twenty's ID) does not produce a duplicate but the multiselect field (in this case called
List(s) ) only contains multiselect2 instead of containing both multiselect1 and multiselect2@Will Hi, do you still need help here?