Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Export to Excel or PDF or CVS Date format is wrong

teksur
Topic Author
Offline
Junior Member

More

8 years 7 months ago #137117 by teksur

Replied by teksur on topic Export to Excel or PDF or CVS Date format is wrong

Well, way I see it answer is already here. Someone just need put these 2 codes(Export Excel and Display responses) working together and then we have it

The topic has been locked.

holch
Offline
LimeSurvey Community Team

More

8 years 7 months ago #137118 by holch

Replied by holch on topic Export to Excel or PDF or CVS Date format is wrong

How about sponsoring the feature? As I said, I don't see that anyone will take this over any time soon.

Help us to help you!

Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
Always provide a LSS file (not LSQ or LSG).

Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.

The topic has been locked.

teksur
Topic Author
Offline
Junior Member

More

8 years 7 months ago #137119 by teksur

Replied by teksur on topic Export to Excel or PDF or CVS Date format is wrong

holch wrote: How about sponsoring the feature? As I said, I don't see that anyone will take this over any time soon.

What do you mean by sponsoring?
I am going to by premium package 12 months if I get this working somehow.
Someone said I could do plugin myself.

The topic has been locked.

holch
Offline
LimeSurvey Community Team

More

8 years 7 months ago #137127 by holch

Replied by holch on topic Export to Excel or PDF or CVS Date format is wrong

Well, I don't know what the premium package includes (this is from the Limesurvey GmbH), but from what I know it is the comfort update at the moment, which is well worth its money.

The rest is based on Limesurey's current features. If you require different features there are a few options:

- Make a feature request (which I think you already did) and wait for its implementation. However, just like with other software this might happen, or not. Even if you spend thousands of dollars/euros on commercial survey packages this is not guaranteed. Back in the day when we used a very expensive survey tool we had tons of feature requests, some made it in the package, others didn't.
Sponsoring: Find a developer that will implement this into Limesurvey, if possible. Of course they probably won't do this for free.
Implement it as a plugin (if possible).

Help us to help you!

Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
Always provide a LSS file (not LSQ or LSG).

Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.

The following user(s) said Thank You: DenisChenu

The topic has been locked.

teksur
Topic Author
Offline
Junior Member

More

8 years 7 months ago #137128 by teksur

Replied by teksur on topic Export to Excel or PDF or CVS Date format is wrong

holch wrote: Well, I don't know what the premium package includes (this is from the Limesurvey GmbH), but from what I know it is the comfort update at the moment, which is well worth its money.

The rest is based on Limesurey's current features. If you require different features there are a few options:

- Make a feature request (which I think you already did) and wait for its implementation. However, just like with other software this might happen, or not. Even if you spend thousands of dollars/euros on commercial survey packages this is not guaranteed. Back in the day when we used a very expensive survey tool we had tons of feature requests, some made it in the package, others didn't.

Sponsoring: Find a developer that will implement this into Limesurvey, if possible. Of course they probably won't do this for free.

Implement it as a plugin (if possible).

I thank you for explaining to me these options. I have to think about them.

The topic has been locked.

Joffm
Offline
LimeSurvey Community Team

More

8 years 5 months ago #139931 by Joffm

Replied by Joffm on topic Export to Excel or PDF or CVS Date format is wrong

Hi, teksur,
I know this topic may be outdated.
But I just want to explain a in my opinion short and easy way to transfer the database format "YYYY-MM-DD" to an EXCEL format (days since 1.1.1900 or whatever).

Export your data as SPSS file (you only need the data file)
Open this in EXCEL (delimiter is komma)
Add a column after the date column (the date will look like '17-06-2016 00:00:00', maybe because of my German EXCEL)
In the new column enter the formula "=RIGHT(LEFT(B1;11);10)*1"
You will get the value 42528, the EXCEL representation of the date.
This you can format to your need with the EXCEL functionality.

Kind regards
Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless

Attachments:

zz.PNG

The topic has been locked.

Joffm
Offline
LimeSurvey Community Team

More

7 years 3 months ago #159353 by Joffm

Replied by Joffm on topic Export to Excel or PDF or CVS Date format is wrong

Hello, emilyjohn,

why do you very frequently reply to absolutely outdated topics? And mostly insubstantial.

Here you just quoted a part of holch's answer 1 year 4 months ago.

What is the reason for that?

Regards
Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless

The following user(s) said Thank You: DenisChenu

The topic has been locked.

tomy137
Offline
New Member

More

7 years 1 month ago #161413 by tomy137

Replied by tomy137 on topic Export to Excel or PDF or CVS Date format is wrong

Hi there,

This is an outdated topic but the associated Mantis likewise : bugs.limesurvey.org/view.php?id=11293

That's not a big deal, I don't understand why there is so few consideration about this question.

Maybe on this script (LimeSurvey/application/helpers/export_helper.php) :

Code:

  {
            $fieldno = strtoupper($field['sql_name']);
            if($field['SPSStype']=='DATETIME23.2') {
                // convert mysql  datestamp (yyyy-mm-dd hh:mm:ss) to SPSS datetime (dd-mmm-yyyy hh:mm:ss) format
                if (isset($row[$fieldno])) {
                    list( $year, $month, $day, $hour, $minute, $second ) = preg_split( '([^0-9])', $row[$fieldno] );
                    if ($year != '' &amp;&amp; (int)$year >= 1900) {
                        echo $q.date('d-m-Y H:i:s', mktime( $hour, $minute, $second, $month, $day, $year ) ).$q;
                    } else {
                        echo ($na);
                    }
                }  else {
                    echo ($na);
                }
            }

Thanks in advance for your reply,

The topic has been locked.

LouisGac
Visitor

7 years 1 month ago #161414 by LouisGac

Replied by LouisGac on topic Export to Excel or PDF or CVS Date format is wrong

Hi tomy,

LimeSurvey is OpenSource, so if you're a PHP coder and you found a fix for a bug, feel free to submit a pull request to the gitHub repository:

github.com/LimeSurvey/LimeSurvey/blob/master/CONTRIBUTING.md

The topic has been locked.

DenisChenu
Offline
LimeSurvey Community Team & Official Partner

More

6 years 9 months ago #166687 by DenisChenu

Replied by DenisChenu on topic Export to Excel or PDF or CVS Date format is wrong

PS : for excel, since we use github.com/mk-j/PHP_XLSXWriter , best is to set the column type to datetime format.
After : excel see really datetime, and user can set his own format easily.

Same can be done with numeric item, but i don't know if we can use #0.#

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.

The topic has been locked.

Moderators: holch, tpartner

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans

Get started

Welcome to the LimeSurvey Community Forum

Export to Excel or PDF or CVS Date format is wrong

Lime-years ahead

Legal

About Us

Open Source