View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
15799 | Bug reports | Import/Export | public | 2020-01-29 16:35 | 2021-11-26 17:05 |
Reporter | Mazi | Assigned To | c_schmitz | ||
Priority | low | Severity | partial_block | ||
Status | closed | Resolution | won't fix | ||
Product Version | 3.22.1 | ||||
Summary | 15799: Token export uses wrong column names for invitation and reminder sent dates | ||||
Description | Token export file uses "invited" and "reminded" as column names for invitation and reminder sent dates while at the DB it actually is "sent" and "remindersent", see screenshots | ||||
Steps To Reproduce | Export token details as CSV file and compare to DB layout. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | Version 3.22.x | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Chrome | ||||
Database type & version | MySQL 5 | ||||
Server OS (if known) | Ubuntu 14 TLS | ||||
Webserver software & version (if known) | Apache 2 | ||||
PHP Version | 7.2.26 | ||||
And when you import : you loose |
|
Nope, I tested with the sample from the screenshot and it imports the invitation sent date stamp fine. So there seems to be some kind of mapping? I just stumbled upon that when trying to import a large CSV file directly into the token table using phpmyadmin. There it complained that the column name "invited" doesn't exist. |
|
It was same in 2.6 … and surely before. My opinion : not a bug or an API broker. |
|
Since import is working fine even with the wrong headings, I also think this is nothing urgent. But at a certain date someone must have added the mapping, for whatever reason?! Can we find that out? My 2 cents is that if we are exporting the tokens from the database, we should also stick to the proper column headings so a direct DB import would still be doable. |
|
It's why i check in 2.6lts … Before 2.6lts ! too old … |
|
I guess invited/reminded sounded more user-friendly at some point. Anyway, I don't see any necessity to change it. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2020-01-29 16:35 | Mazi | New Issue | |
2020-01-29 16:35 | Mazi | File Added: export_columns.png | |
2020-01-29 16:35 | Mazi | File Added: db_columns.png | |
2020-01-29 16:47 | cdorin | Assigned To | => cdorin |
2020-01-29 16:47 | cdorin | Status | new => assigned |
2020-01-29 17:12 | DenisChenu | Note Added: 55567 | |
2020-01-29 17:40 | Mazi | Note Added: 55568 | |
2020-01-30 07:35 | DenisChenu | Note Added: 55569 | |
2020-01-30 07:36 | DenisChenu | File Added: Capture d’écran du 2020-01-30 07-36-46.png | |
2020-01-30 14:48 | Mazi | Note Added: 55574 | |
2020-01-30 15:06 | DenisChenu | Note Added: 55575 | |
2021-02-04 10:15 | cdorin | Status | assigned => new |
2021-02-04 21:20 | cdorin | Assigned To | cdorin => |
2021-02-04 21:20 | cdorin | Status | new => acknowledged |
2021-03-10 22:20 | ollehar | Priority | none => low |
2021-11-26 17:05 | c_schmitz | Assigned To | => c_schmitz |
2021-11-26 17:05 | c_schmitz | Status | acknowledged => closed |
2021-11-26 17:05 | c_schmitz | Resolution | open => won't fix |
2021-11-26 17:05 | c_schmitz | Note Added: 67595 | |
2021-11-26 17:05 | c_schmitz | Bug heat | 4 => 6 |