|
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
|
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
|
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
|
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
|
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
|
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.
|
