View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
19558 | Bug reports | Central participant database | public | 2024-05-12 11:33 | 2024-07-06 16:15 |
Reporter | khfischbach | Assigned To | |||
Priority | none | Severity | minor | ||
Status | confirmed | Resolution | open | ||
Product Version | 6.5.x | ||||
Summary | 19558: import csv created duplicates | ||||
Description | when importing a csv-file and selecting the option to avoid duplicates, the entry still shows up in the CPDB as duplicate. | ||||
Steps To Reproduce | Steps to reproduceimport csv Expected resultexisting entry to be updated only Actual resultentry is added as duplicate (firstname, lastname, email) | ||||
Tags | No tags attached. | ||||
Bug heat | 16 | ||||
Complete LimeSurvey version number (& build) | 6.5.6 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox | ||||
Database type & version | unknown | ||||
Server OS (if known) | hosted at limesurvey.net | ||||
Webserver software & version (if known) | |||||
PHP Version | unknown | ||||
@truthslog What does it tell me? |
|
anyone at home? |
|
anyone at home? |
|
Replace csv file without real email t_liste_eigentuemer_export_d_20240327_test.csv (87 bytes)
firstname,lastname,email,language "Karl","Lastname","karl-Lastname@example.org","de" |
|
@DennisChenu |
|
@example.org : http://example.org/ |
|
No! firstname,lastname,email,language 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! |
|
Ok, but i replace with
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. t_liste_eigentuemer_export_d_20240327_test-2.csv (94 bytes)
firstname,lastname,email,language "Karl-Heinz","Kallewirsch","karl-heinz@kallewirsch.de","de" |
|
It's exactly what i test : see the updated Way to reproduce import csv |
|
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 just update the CSV file to remove real name and real website. |
|
OK - sorry, I did not get your point so far! 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. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2024-05-12 11:33 | khfischbach | New Issue | |
2024-05-12 11:33 | khfischbach | File Added: t_liste_eigentuemer_export_d_20240327_test.csv | |
2024-05-12 11:33 | khfischbach | Issue Monitored: khfischbach | |
2024-05-12 11:33 | khfischbach | Bug heat | 0 => 2 |
2024-05-20 04:15 | truthslob | Bug heat | 2 => 4 |
2024-05-20 10:11 | khfischbach | Note Added: 80132 | |
2024-05-20 10:11 | khfischbach | Bug heat | 4 => 6 |
2024-06-11 08:54 | khfischbach | Note Added: 80270 | |
2024-06-13 08:30 | khfischbach | Note Added: 80283 | |
2024-06-13 10:38 | DenisChenu | File Deleted: t_liste_eigentuemer_export_d_20240327_test.csv | |
2024-06-13 10:39 | DenisChenu | Status | new => confirmed |
2024-06-13 10:39 | DenisChenu | Note Added: 80297 | |
2024-06-13 10:39 | DenisChenu | File Added: t_liste_eigentuemer_export_d_20240327_test.csv | |
2024-06-13 10:39 | DenisChenu | Bug heat | 6 => 8 |
2024-06-13 10:40 | DenisChenu | Steps to Reproduce Updated | |
2024-06-13 11:36 | khfischbach | Note Added: 80303 | |
2024-06-13 12:17 | DenisChenu | Note Added: 80317 | |
2024-06-13 12:18 | DenisChenu | Bug heat | 8 => 6 |
2024-06-13 12:52 | khfischbach | Note Added: 80320 | |
2024-06-13 12:52 | khfischbach | File Added: grafik.png | |
2024-06-13 18:22 | DenisChenu | Note Added: 80347 | |
2024-06-13 18:25 | DenisChenu | Note Edited: 80347 | |
2024-06-14 08:03 | khfischbach | Note Added: 80352 | |
2024-06-14 08:03 | khfischbach | File Added: t_liste_eigentuemer_export_d_20240327_test-2.csv | |
2024-06-14 09:45 | DenisChenu | Note Added: 80358 | |
2024-06-14 09:56 | khfischbach | Note Added: 80359 | |
2024-06-14 09:58 | DenisChenu | Note Added: 80360 | |
2024-06-14 09:58 | DenisChenu | File Added: Capture d’écran du 2024-06-14 09-56-42.png | |
2024-06-14 10:03 | khfischbach | Note Added: 80361 | |
2024-06-14 10:45 | DenisChenu | Note Added: 80365 | |
2024-06-14 11:33 | khfischbach | Note Added: 80370 | |
2024-07-06 16:07 | guest | Bug heat | 6 => 12 |
2024-07-06 16:13 | lavamind | Note Added: 80544 | |
2024-07-06 16:13 | lavamind | Bug heat | 12 => 14 |
2024-07-06 16:15 | lavamind | Issue Monitored: lavamind | |
2024-07-06 16:15 | lavamind | Bug heat | 14 => 16 |