View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
14354Bug reportsImport/Exportpublic2018-12-17 13:162019-04-30 09:11
Reportercharlottej990 Assigned ToLouisGac 
PrioritynoneSeverityminor 
Status closedResolutionnot fixable 
Product Version3.15.x 
Summary14354: Date Stamp exports with 1980-01-01 00:00:00 when Date Stamp was not collected
Description

When you create a new survey you can select if you want to collect Date Stamp (its under Notifications & Data).
If you leave this as 'No', you do not want to collect the Date Stamp, and you then export your responses, there is a column for Date Stamp in the exported file and it is populated with 1980-01-01 00:00:00.

Steps To Reproduce

When you create a new survey you can select if you want to collect Date Stamp (its under Notifications & Data).

You leave this as default 'No' setting.

You create the survey & collect responses & create responses/participants tables as needed.

Go to Responses > Export Responses

Select CSV and make sure you have 'all responses' selected so you see data.

Click Export.

TagsNo tags attached.
Attached Files
limesurveyexport1980.csv (4,681 bytes)    
Response ID,Date submitted,Last page,Start language,Seed,Token,This is a long text question
4,1980-01-01 00:00:00,1,en,188626250,1234,hello
5,1980-01-01 00:00:00,1,en,1682552990,1234,I am a spooky automated computer answer OOOoooooOOo
6,1980-01-01 00:00:00,1,en,1894440296,1234,I am a spooky automated computer answer OOOoooooOOo
7,1980-01-01 00:00:00,1,en,2075879208,1234,I am a spooky automated computer answer OOOoooooOOo
8,1980-01-01 00:00:00,1,en,1576736215,1234,I am a spooky automated computer answer OOOoooooOOo
9,1980-01-01 00:00:00,1,en,177736200,1234,I am a spooky automated computer answer OOOoooooOOo
10,,,en,1842962603,1234,
11,,,en,587613812,1234,
12,,,en,1856226948,1234,
13,,,en,62201214,1234,
14,,,en,1750782759,1234,
15,1980-01-01 00:00:00,1,en,1156080488,1234,I am a spooky automated computer answer OOOoooooOOo
16,1980-01-01 00:00:00,1,en,2054933728,1234,I am a spooky automated computer answer OOOoooooOOo
17,1980-01-01 00:00:00,1,en,771160794,1234,I am a spooky automated computer answer OOOoooooOOo
18,1980-01-01 00:00:00,1,en,2144512145,1234,I am a spooky automated computer answer OOOoooooOOo
19,1980-01-01 00:00:00,1,en,1039472446,1234,I am a spooky automated computer answer OOOoooooOOo
20,,,en,2146720526,1234,
21,1980-01-01 00:00:00,1,en,326325284,1234,I am a spooky automated computer answer OOOoooooOOo
22,1980-01-01 00:00:00,1,en,180471359,1234,I am a spooky automated computer answer OOOoooooOOo
23,1980-01-01 00:00:00,1,en,1180956532,1234,I am a spooky automated computer answer OOOoooooOOo
24,,,en,134314552,1234,
25,1980-01-01 00:00:00,1,en,1085404833,1234,I am a spooky automated computer answer OOOoooooOOo
26,1980-01-01 00:00:00,1,en,623794745,1234,I am a spooky automated computer answer OOOoooooOOo
27,1980-01-01 00:00:00,1,en,374260897,1234,I am a spooky automated computer answer OOOoooooOOo
28,1980-01-01 00:00:00,1,en,956378957,1234,I am a spooky automated computer answer OOOoooooOOo
29,1980-01-01 00:00:00,1,en,1661183416,1234,I am a spooky automated computer answer OOOoooooOOo
30,1980-01-01 00:00:00,1,en,1340584700,1234,I am a spooky automated computer answer OOOoooooOOo
31,1980-01-01 00:00:00,1,en,1904954410,1234,I am a spooky automated computer answer OOOoooooOOo
32,1980-01-01 00:00:00,1,en,1926845349,1234,I am a spooky automated computer answer OOOoooooOOo
33,1980-01-01 00:00:00,1,en,2031581791,1234,I am a spooky automated computer answer OOOoooooOOo
34,1980-01-01 00:00:00,1,en,368331665,1234,I am a spooky automated computer answer OOOoooooOOo
35,1980-01-01 00:00:00,1,en,2119325599,1234,I am a spooky automated computer answer OOOoooooOOo
36,1980-01-01 00:00:00,1,en,1495063841,1234,I am a spooky automated computer answer OOOoooooOOo
37,1980-01-01 00:00:00,1,en,816047665,1234,I am a spooky automated computer answer OOOoooooOOo
38,1980-01-01 00:00:00,1,en,1435428480,1234,I am a spooky automated computer answer OOOoooooOOo
39,1980-01-01 00:00:00,1,en,709493936,1234,I am a spooky automated computer answer OOOoooooOOo
40,,,en,2055005571,1234,
41,,,en,1297174707,1234,
42,1980-01-01 00:00:00,1,en,1569713790,1234,I am a spooky automated computer answer OOOoooooOOo
43,1980-01-01 00:00:00,1,en,1739554695,1234,I am a spooky automated computer answer OOOoooooOOo
44,1980-01-01 00:00:00,1,en,1947635331,1234,I am a spooky automated computer answer OOOoooooOOo
45,1980-01-01 00:00:00,1,en,1632218260,1234,I am a spooky automated computer answer OOOoooooOOo
46,1980-01-01 00:00:00,1,en,1257357857,1234,I am a spooky automated computer answer OOOoooooOOo
47,1980-01-01 00:00:00,1,en,1832221770,1234,I am a spooky automated computer answer OOOoooooOOo
48,,,en,163261826,1234,
49,1980-01-01 00:00:00,1,en,41168219,1234,I am a spooky automated computer answer OOOoooooOOo
50,1980-01-01 00:00:00,1,en,851914402,1234,I am a spooky automated computer answer OOOoooooOOo
51,1980-01-01 00:00:00,1,en,1703823646,1234,I am a spooky automated computer answer OOOoooooOOo
52,1980-01-01 00:00:00,1,en,1254263975,1234,I am a spooky automated computer answer OOOoooooOOo
53,1980-01-01 00:00:00,1,en,857198544,1234,I am a spooky automated computer answer OOOoooooOOo
54,1980-01-01 00:00:00,1,en,1727317363,1234,I am a spooky automated computer answer OOOoooooOOo
55,1980-01-01 00:00:00,1,en,2115131894,1234,I am a spooky automated computer answer OOOoooooOOo
56,1980-01-01 00:00:00,1,en,110434012,1234,I am a spooky automated computer answer OOOoooooOOo
57,1980-01-01 00:00:00,1,en,458707448,1234,I am a spooky automated computer answer OOOoooooOOo
58,1980-01-01 00:00:00,1,en,199833775,1234,I am a spooky automated computer answer OOOoooooOOo
59,1980-01-01 00:00:00,1,en,43326682,1234,I am a spooky automated computer answer OOOoooooOOo
limesurveyexport1980.csv (4,681 bytes)   
Bug heat6
Complete LimeSurvey version number (& build)3.15.4+181109
I will donate to the project if issue is resolvedNo
BrowserChrome/IE11
Database type & versionmariaDB 10.1
Server OS (if known)
Webserver software & version (if known)
PHP Version7.2.12

Users monitoring this issue

alexwinter

Activities

DenisChenu

DenisChenu

2018-12-19 11:43

developer   ~50004

submitdate is a datetime SQL, need to be a real date time.
alexwinter

alexwinter

2018-12-19 11:57

reporter   ~50005

Hi DenisChenu, do you mean that the submitdate column in the database is not the correct data type? this is the reason it fails to exclude this attribute from the export?
DenisChenu

DenisChenu

2018-12-19 12:09

developer   ~50006

No, it's a datetime SQL type, i don't see any issue here actually.

1980-01-01 mean completed, null/empty mean not completed : not an issue for me.

An export can set it to Y/"" but … I don't care of it. see Y or 1980-01-01 mean "submitted"
alexwinter

alexwinter

2018-12-19 12:55

reporter   ~50007

It would seem to me that the submitdate field is being used incorrectly, if this field is a datetime field it would be incorrect to display that field as a "Y" string

I understand what you are saying, however from a users perspective seeing a datetime of "1980-01-01" is confusing they would not understand the inner workings of the product and would see it as incorrect data.
DenisChenu

DenisChenu

2018-12-19 19:39

developer   ~50014

My point of view

  1. Have 1980 in DB is not an issue : MySQL allow 0000-00-00 00:00:00 but not MSQL and pgSQL if i remind
  2. When export : https://manual.limesurvey.org/Export_responses#Export_to_application_.28Excel.2F.csv.29
    2.A. using Answer code : don't update (except if adding an checkbox)
    2.B. Using Full answers : why not export as gT(Yes), but unsure here …

Issue History

Date Modified Username Field Change
2018-12-17 13:16 charlottej990 New Issue
2018-12-17 13:16 charlottej990 File Added: limesurveyexport1980.csv
2018-12-17 13:17 alexwinter Issue Monitored: alexwinter
2018-12-19 11:43 DenisChenu Note Added: 50004
2018-12-19 11:57 alexwinter Note Added: 50005
2018-12-19 12:09 DenisChenu Note Added: 50006
2018-12-19 12:55 alexwinter Note Added: 50007
2018-12-19 19:39 DenisChenu Note Added: 50014
2019-01-10 16:00 LouisGac Assigned To => LouisGac
2019-01-10 16:00 LouisGac Status new => resolved
2019-01-10 16:00 LouisGac Resolution open => not fixable
2019-04-30 09:11 c_schmitz Status resolved => closed
2021-08-02 21:49 guest Bug heat 4 => 6