Replace csv file without real email

firstname,lastname,email,language
"Karl","Lastname","karl-Lastname@example.org","de"

@DennisChenu
Could you please explain what you mean with "without real email"?

@example.org : http://example.org/
I think previously it's your email ?

No!
The example csv-file I added to this bug report contained:

firstname,lastname,email,language
Karl-Heinz,"Kallewirsch","karl-heinz@kallewirsch.de","de"

But this was only to reproduce the bug if you import this file twice (or more times). You will then have multiple entries.

I have done this with a larger file containing more entries. All of them were duplicated!

grafik.png (1,838 bytes)   

grafik.png (1,838 bytes)   

Ok, but i replace with

firstname,lastname,email,language
"Karl","Lastname","karl-Lastname@example.org","de"

John Doe in German ?

The previous website exist

sorry, but I think we are far away from the original bug-report topic.

It is !!not!! a question of the conding of the csv-file. The problem is, that any csv-import creates DUPLICATES.

The coding (UTF-8) of the file is O.K., because the import within limesurvey recognizes the content.

But if I import the file twice or more times it creates two or more DUPLICATES.

firstname,lastname,email,language
"Karl-Heinz","Kallewirsch","karl-heinz@kallewirsch.de","de"

But if I import the file twice or more times it creates two or more DUPLICATES.

It's exactly what i test : see the updated Way to reproduce

import csv
select option to identify duplicates
import same csv a second time
select option to identify duplicates

I am having problems to find out what you want to tell me!

I understand, you tested it with the file I provided and did !!not!! get any DUPLICATES?

And I can tell, that always I did it, I got DUPLICATES and I can repreduce it as often as you like with the same result.

I just don't understand your point…
I confirm your issue.

I just update the CSV file to remove real name and real website.
You know GPDR ? W have domain name example.org and example.com managed by w3c for website example.

Capture d’écran du 2024-06-14 09-56-42.png (26,933 bytes)   

Capture d’écran du 2024-06-14 09-56-42.png (26,933 bytes)   

OK - sorry, I did not get your point so far!
So you confirm the bug - fine!

By the way: the example was not a real name and domain! Just test data! Anyhow, to replace with example.com is fine!

kallewirsch/./de was a real website.

I found a website where there are link to some company. If company didn't pit website : website are x.com … Elon are happy ;)

you are right - din't test it. In future, I will use example.com - thanks for hint!

Just to mention that the issue still exists in 6.5.15: importing the same CSV file twice to CPDB creates duplicates of all contacts.

This makes it very inconvenient to keep the CPDB up to date from an external data source, because update-needing records have to be processed one by one.

Is there any news on this issue? I have the same problem and I'm using version 6.13.0+250415. When I submit a CSV, even with the "avoid duplicates" option enabled, the entry still shows up in the CPDB as a duplicate.

Thank in advance for any help.

Will work on this. Thanks

https://github.com/LimeSurvey/LimeSurvey/pull/4748

New function, please, separating the current one.
And if current one is not used in LS core : set it at deprecated please :)

Just see for last comment of coderabbit