Support

Home Forums Translations Date Format of csv export – german

Date Format of csv export – german

Posted: February 20, 2018 at 5:25 am

Viewing 10 reply threads


motio

February 20, 2018 at 5:25 am

Hey,

we found this forum entry that helped us a lot:
https://eventespresso.com/topic/date-format-of-csv-exports/

We use the following date format “D., d.m.y”. Unfortunately it uses the englisch short form for the days. I set everywhere the german language and don’t know how to change this in the export.


motio

February 20, 2018 at 2:13 pm

For more clarification:
now the format in the export is: Tue., 20.02.18
it should be: Di., 20.02.18


Tony

  • Support Staff

February 21, 2018 at 12:27 pm

Hi there,

Currently the dates output to the CSV will not be localized even if you change the date format as you’ve found, I’ve created a ticket requesting some feedback from our developers on this.

Currently if you want to use the above format and localize the output you will need to filter the export right before its output.

Can you post the cull column names for the date fields you want localized? I’ll provide an example of how you can do the above.


motio

February 21, 2018 at 12:39 pm

Hey Tony,

thank you for the information.

I use the “Filtered CSV Report” and there are two columns:
-Ticketdatum
-Time registration occurred[REG_date]

The important is the “Ticketdatum” that we need for further processing.


Tony

  • Support Staff

February 21, 2018 at 2:18 pm

Ok, try something like this:

https://gist.github.com/Pebblo/db38b33d16d8651c11bb1ef09bff7942

That uses hardcoded values for the column names but should work.


motio

February 23, 2018 at 9:25 am

Hi,
there must be an error somewhere.
Now it shows in both a time/number(?) e.g.”22:23 22:23″ in both columns. But this doesn’t match a date of registration nor an event date.


Tony

  • Support Staff

February 23, 2018 at 9:27 am

I edited the code shortly after uploading the code as I’d used $date_format = get_option( 'time_format' ); here:

https://gist.github.com/Pebblo/db38b33d16d8651c11bb1ef09bff7942#file-example-php-L18

Pull the latest changes from the above snippet and restest, it should show the date correctly.


motio

February 23, 2018 at 12:03 pm

I updated the code.
Now the format is correct but…
– the dates are not correct (in the admin they are both different)
– the “Ticketdatum” shows only one date but there should be multiple dates


Tony

  • Support Staff

February 26, 2018 at 2:12 pm

Hmm, yeah I see, this will need some further investigation from our developers.

I’ve requested some feedback from one of them and will update this thread once I know more.


motio

March 8, 2018 at 4:20 am

Hey Tony,
did you get any feedback from the developers for that topic?


Josh

  • Support Staff

March 9, 2018 at 7:24 am

Thanks for checking in. The ticket needs to be assigned to a developer and after it’s been assigned to a developer they’ll review and we’ll update this topic with their feedback.

Viewing 10 reply threads

The support post ‘Date Format of csv export – german’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso