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-06-14 11:33 |
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 | 6 | ||||
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! |
|
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 |