Hey there, can any1 tell my what i need to change ...
# general
r
Hey there, can any1 tell my what i need to change so that my "custom list import" doesnt duplicate everything, and just add the new record to my list? If this was the wrong place to post, im sorry im new at posting on this channel.
p
If I understand correctly, when you run this import it creates a new distinct list, but you want to update the original list. If that is the case, change your update type to Update, rather than add new, or add and update. Also, add the internal id of the actual list to your file. It will be the same number for each row. The internal id will be listed on the list of custom lists. Your file only needs the internal id and the values you want to add.
r
My problem is that when i run the CVS import as shown in the picture, it adds all the values again, even if i do "update" Instead of just adding the new ones, which is supposed to be the "test" values. Ill try using only the Internal ID and name, and see if this way it adds in the new values.
See here i only want to add "test" And if i run this, it adds all the fields. even if i only take "update" what am i missing here? @Patrick Olson
p
Okay. Then everything I wrote above is the same, but you need to add the ID field from the Values sublist. You need to add all of the internal ids of the values to your import. Rows without internal ids will be added.
message has been deleted
r
oooooh, så the ids, that is there will NOT be added, and then the new ones that are blank will be added i see
p
message has been deleted
Sorry. The naming is crappy here. I was just testing in a demo account
r
you are my hero!
p
I just updated my file to add 6.1 and change some of the names to strings
r
message has been deleted
worked like a charm
👍 1
Thanks a bunch! Have a great day!
p
I'm interested why you wouldn't just remove existing values from your import. Do you have to update them often?
But I'm glad I could help!
🙏 1
r
The customer wants to see the values in excel, they are a bit oldschool. But when doing this i need to update the CSV every time with the Id's så they dont get created again... Is there any way to bypass this?