Export to Excel or PDF or CVS Date format is wrong

Plus d'informations
il y a 2 ans 5 mois #136883 par teksur
teksur a créé le sujet : Export to Excel or PDF or CVS Date format is wrong
I have version Version 2.50+ Build 160525.
Display responses date looks like this:
14.02.2012
Export to Excel or PDF or CVS result is this:
2012-02-14 00:00:00

Any idea why?

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #136893 par DenisChenu
DenisChenu a répondu au sujet : Export to Excel or PDF or CVS Date format is wrong
Because : we always use english date format when exporting.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #136962 par teksur
teksur a répondu au sujet : Export to Excel or PDF or CVS Date format is wrong

DenisChenu écrit: Because : we always use english date format when exporting.


Why? I don't get the logic behind this.
I want to use date format dd.mm.yyyy in survey. It is natural for me to use it also in Excel file when I need to work there.
How do I manage this problem?

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #136964 par DenisChenu
DenisChenu a répondu au sujet : Export to Excel or PDF or CVS Date format is wrong
Make a feature request or make an "new export plugin"

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #136965 par teksur
teksur a répondu au sujet : Export to Excel or PDF or CVS Date format is wrong

DenisChenu écrit: Make a feature request or make an "new export plugin"

Thanks, I made feature request.

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #137036 par holch
holch a répondu au sujet : Export to Excel or PDF or CVS Date format is wrong
It is always good to make a feature request. It shows the developers where improvements can be made, what the users out there need/want, etc.

However, I have my doubts that this will be implemented any time soon. It is very common that while the date might be changed in the application itself, within the database one format is fixed. Of course it would be a nice to have, but I think there are far more important things on the feature request list than this. Especially as you can correct this fairly easy in Excel.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #137050 par teksur
teksur a répondu au sujet : Export to Excel or PDF or CVS Date format is wrong

holch écrit: Especially as you can correct this fairly easy in Excel.

Could you share me this easy way pls?
I tried to change format in cell and that unfortunately did not work.

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #137062 par holch
holch a répondu au sujet : Export to Excel or PDF or CVS Date format is wrong
Well, depending on the number of response I would either look for a formula on how to convert 2012-02-14 into 14.02.2012.

But if the number of entries and the time range isn't too big, I would sort the table regarding date and then copy the correct date to all from the same day. If you have a survey going on for many days, then this is of course quite tedious. Then I would look into formulas in Excel to convert this. If you want to go the formula way, this could be a start. Someone is trying to do the exact oposite of you, but it should give you some idea on how to proceed.

superuser.com/questions/793137/how-to-co...-mm-dd-in-excel-2007

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #137087 par teksur
teksur a répondu au sujet : Export to Excel or PDF or CVS Date format is wrong

holch écrit: Well, depending on the number of response I would either look for a formula on how to convert 2012-02-14 into 14.02.2012.

But if the number of entries and the time range isn't too big, I would sort the table regarding date and then copy the correct date to all from the same day. If you have a survey going on for many days, then this is of course quite tedious. Then I would look into formulas in Excel to convert this. If you want to go the formula way, this could be a start. Someone is trying to do the exact oposite of you, but it should give you some idea on how to proceed.

superuser.com/questions/793137/how-to-co...-mm-dd-in-excel-2007


Thank you for these, but I don't think this is good idea to work this in Excel. This survey what I am working now will last for years and there are birthdays and similar things. I don't need any calculation for them. I am using this as database form and this dump to Excel is very important, because rest of work will be done in Excel. This form has more than 100 questions.

In datebase date is in right format for me dd.mm.yyyy so in export you have code that will change that to yyyy-mm-dd and add time 00:00:00(I don't know why, not needed at all)
From my perspective it has too much PHP for me :)
So little tick in Export don't change my date to yyyy-mm-dd format would be great! :)
I don't know PHP, but I have hunch that it would not need so many if and else commands from good PHP coder like you :laugh:
I only see one other option that I would have to loose this date picker component and use normal textfield where they have to enter date in dd.mm.yyyy format.

What do you think?

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #137088 par DenisChenu
DenisChenu a répondu au sujet : Export to Excel or PDF or CVS Date format is wrong

teksur écrit: In datebase date is in right format for me dd.mm.yyyy so in export you have code that will change that to yyyy-mm-dd and add time 00:00:00(I don't know why, not needed at all)

DateTime format in SQL : always Y-M-D h:m:s

ANd if you import a 01/02/03 in excel in french or in english : date is different. Using same format , always : you are sure firt is year, seond i month and last is day of month.

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #137093 par teksur
teksur a répondu au sujet : Export to Excel or PDF or CVS Date format is wrong

DenisChenu écrit:

teksur écrit: In datebase date is in right format for me dd.mm.yyyy so in export you have code that will change that to yyyy-mm-dd and add time 00:00:00(I don't know why, not needed at all)

DateTime format in SQL : always Y-M-D h:m:s

ANd if you import a 01/02/03 in excel in french or in english : date is different. Using same format , always : you are sure firt is year, seond i month and last is day of month.

Denis

I was little confused, because you said earlier that "Because : we always use english date format when exporting." You are right it is in database this yyyy-mm-dd format. But you are able to show this in in my format dd.mm.yyyy in Browse responses -> Display responses. Everything is fine for me in there. Why I can't have this to Excel?

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #137109 par holch
holch a répondu au sujet : Export to Excel or PDF or CVS Date format is wrong
One thing is how things are displayed (just a reformatting), the other aspect is how it is saved in the database.

I am not a real programmer myself, but I know a few things. And it is never that simple as it looks. When you make those supposed "minor" changes, there can be a lot of impact. For example: EM can use date to make calculations. If the format written into the database is not always the same, EM needs to identify the format and be able to work with it. That is a big deal.

There is probably some way to read the date out of your question, reformat it and write it into an equation type question, but this is out of my league.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #137117 par teksur
teksur a répondu au sujet : 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 :)

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #137118 par holch
holch a répondu au sujet : 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.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 5 mois #137119 par teksur
teksur a répondu au sujet : Export to Excel or PDF or CVS Date format is wrong

holch écrit: 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.

Connexion ou Créer un compte pour participer à la conversation.

Commencez dès maintenant !

Créez simplement un compte et commencez à utiliser LimeSurvey dès aujourd'hui.

Inscrivez-vous maintenant

Inscrivez-vous à notre Newsletter!