Event Information "mouse over" date format

[ronald]

I have been trying to configure CiviEvent for our purposes and notice that even with all the various "localization" and "date format" settings adjusted to fit our locale (Australia), when I go to the "Event Information" page and hover over the event date, it is shown as "yyyy-mm-dd hh:mm:ss", even though our local format would be "dd/mm/yyyy, hh.mm" (plus am/pm). Just wondering if I have missed something or this simply cannot be localized.

(As for the multitude of settings, it would be great if one could just choose a locale and be at least roughly done with it, but I guess that's a different matter.)

TIA,

Ronald

[Donald Lobo]

I have been trying to configure CiviEvent for our purposes and notice that even with all the various "localization" and "date format" settings adjusted to fit our locale (Australia), when I go to the "Event Information" page and hover over the event date, it is shown as "yyyy-mm-dd hh:mm:ss", even though our local format would be "dd/mm/yyyy, hh.mm" (plus am/pm). Just wondering if I have missed something or this simply cannot be localized.

Can you reproduce this on http://sandbox.civicrm.org/ and if so please file an issue. We'll fix for 2.2 (and you can potentially backport the fix to 2.0/2.1)

(As for the multitude of settings, it would be great if one could just choose a locale and be at least roughly done with it, but I guess that's a different matter.)

A code contribution for this would be great I suspect you will need a db of formats for various localizations

lobo

[ronald]

Can you reproduce this on http://sandbox.civicrm.org/ and if so please file an issue. We'll fix for 2.2 (and you can potentially backport the fix to 2.0/2.1)

Yes, I can reproduce it in the sandbox and will file an issue now. Thanks.
[Edit: filed now - key CRM-3958]

(As for the multitude of settings, it would be great if one could just choose a locale and be at least roughly done with it, but I guess that's a different matter.)

A code contribution for this would be great

I know - it seems my complete lack of PHP coding skills keeps coming back to bite me... 

I suspect you will need a db of formats for various localizations

Something like this?

But then shouldn't such functionality ideally go into the underlying CMS (in my case Drupal) anyway, rather than CiviCRM?

It just seems that CiviCRM uses many more variations - it does bug me every time I configure Drupal that I have to change six or so settings but then I forget about it again. CiviCRM then reminds me again as it has something like 15 settings, they are format strings rather than menus and don't seem to make use of the existing Drupal settings. Not sure how to best address this, but from a user point of view it would be great if I set my locale once in Drupal and had CiviCRM pick that up. Same for the timezone, btw. I'm not complaining or ranting and much appreciate all the work you guys are doing - CiviCRM is really getting better and more useable with every version - just having a bit of a dream. 

Cheers,

Ronald

[Donald Lobo]

Something like this?

Did not check the web site in detail, but for our needs a map of locale to various date formats is whats needed to set default settings based on locale

But then shouldn't such functionality ideally go into the underlying CMS (in my case Drupal) anyway, rather than CiviCRM?

Not sure about that. All CMS's will not follow the same pattern etc. We could try to do a better job of getting better information from the CMS, but we've kinda stayed away from that route. Also the standalone mode would require us to maintain an internal DB of mappings

It just seems that CiviCRM uses many more variations - it does bug me every time I configure Drupal that I have to change six or so settings but then I forget about it again. CiviCRM then reminds me again as it has something like 15 settings, they are format strings rather than menus and don't seem to make use of the existing Drupal settings. Not sure how to best address this, but from a user point of view it would be great if I set my locale once in Drupal and had CiviCRM pick that up. Same for the timezone, btw. I'm not complaining or ranting and much appreciate all the work you guys are doing - CiviCRM is really getting better and more useable with every version - just having a bit of a dream. 

Itd good to dream and suggest things, but its even better to step up and contribute . Contributions can be more than code, some ideas here: http://forum.civicrm.org/index.php/topic,15.msg2189.html#msg2189

lobo

[ronald]

Something like this?

Did not check the web site in detail, but for our needs a map of locale to various date formats is whats needed to set default settings based on locale

That's exactly what it is. Localised date, time, number & currency formats plus time intervals and relative times; names of weekdays, months, quarters, and time units; plus the local names for international languages, currencies, timezones, countries, territories, continents & cities, etc. All in long, short and abbreviated versions and that's just from looking at one file. (All XML, there are also tools for handling & converting the files.)
I guess it'll be hard to get more standard than the unicode consortium. I found the site from digging around php.net for localization info and that seems to be the way they plan to go.

But then shouldn't such functionality ideally go into the underlying CMS (in my case Drupal) anyway, rather than CiviCRM?

Not sure about that. All CMS's will not follow the same pattern etc. We could try to do a better job of getting better information from the CMS, but we've kinda stayed away from that route. Also the standalone mode would require us to maintain an internal DB of mappings

Fair enough, thanks.

Itd good to dream and suggest things, but its even better to step up and contribute . Contributions can be more than code, some ideas here: http://forum.civicrm.org/index.php/topic,15.msg2189.html#msg2189

I appreciate that and strive to contribute more as I learn.

Cheers,

Ronald