Saturday, 28 January 2017
  7 Replies
  6.7K Visits
0
Votes
Undo
  Subscribe

Hello, I have been using it for a little while and I have come across an issue, we are a spanish congragation in the US and when we use the english interface things print out in a 12 hour format and date comes out mm/dd/yyyy (this is what we want) but when we switch to spanish, things change to 24hr format and the date comes out to dd/mm/yyyy which creates a lot of confusion, is there any way to add a toggle for both the hour format and the date formats?

3 years ago
·
#3443
Accepted Answer
0
Votes
Undo

@Andres The line about 'adapting those' refers to what precedes it: templates (with hard coded date formats). Some know how to change the templates, others don't and need help.

It is true that nothing was said about Mac specifiacally. But the point is, both the language chosen within TB and the OS language have a bearing on how dates come out, and it looks like the OS has the final say, though,as said, you may only see this after you close and reopen TB after changing any system settings.

What I am thinking of: within TB there no 2 types of English, but there are several ways dates are rendered within the English speaking world. Same holds for Spanish. I have never seen any questions about that, though. Also not from Mac users. This warrants the conclusion that the system language settings have the last say and usually do their job correctly, as well. A US based brother would not be confronted with a UK date format, as he probably set his computer to US settings, and so on. 

Problems occur when congregation language does not equal OS language or settings. 

Foolproof way would be to hardcode date format into template. Unformatted template dates ultimately follow OS settings.

To force TB to follow you OS settings, you may have to set your OS settings wrongly, reopen TB, then set OS correct again, reopening TB.  You would really have to try and fiddle around a bit to see what works.

If TB should NOT follow OS settings, the safest way would be to hardcode date format into the template, preferably saving that as a separate template for that language.

In general, both in OS settings and in template formatting, notice the difference between d and dd (and m and mm) For June 1, d/m comes out as 1/6, and mm/dd comes out as 06/01. There are more variations, see the alternatives in your OS settings.

Honestly, since date formats in the templates are easy to format, you'd (at least I would) guess so would the time formats. I have tried everything. Formatting like HH:mm (24hr), hh:mm (12hr), h:mm (12 hr without preceding 0 for single digits), but I am not too versed in CSS or HTML or whatever it is, to get this working. I console myself with the thought that I have no one seen reporting they got it working. It is very frustrating.

@Willow Copy the template you want to change outside the templae folder (changing within is usually not possible due to permissions) Open the template with a html editor (there are plenty around and Win10 has one of its own, I always use Brackets). Look for any date in the template and remove the formatting. A date field may look like !DATE ddd, dd.MM.!. Reduce that to !DATE!. Or, if you want, replace the ddd, dd.MM bit by whatever you want the format to be. Make sure the output field starts and ends with an exclamation mark. Put the changed template into the template folder. Rename it first OR rename the original, whichever you prefer.

 


https://www.theocbase.net/support-forum/post/1097-donations.html

For accessing the database my personal preference is http://sqlitebrowser.org/

For editing templates I now use https://code.visualstudio.com/ 

 


3 years ago
·
#3460
1
Votes
Undo

Lower case "h" will give you hours between 1 and 12, and you can add "AP" to get the AM/PM flag

3 years ago
·
#3459
0
Votes
Undo

DON'T EVER GIVE UP.

In the combination schedule, I located every instance of HH:mm (there is only a handful) and replaced the HH by h. That worked....

Except that it doesn't say AM or PM. If I find anything else, I'll get back here.


https://www.theocbase.net/support-forum/post/1097-donations.html

For accessing the database my personal preference is http://sqlitebrowser.org/

For editing templates I now use https://code.visualstudio.com/ 

 


3 years ago
·
#3443
Accepted Answer
0
Votes
Undo

@Andres The line about 'adapting those' refers to what precedes it: templates (with hard coded date formats). Some know how to change the templates, others don't and need help.

It is true that nothing was said about Mac specifiacally. But the point is, both the language chosen within TB and the OS language have a bearing on how dates come out, and it looks like the OS has the final say, though,as said, you may only see this after you close and reopen TB after changing any system settings.

What I am thinking of: within TB there no 2 types of English, but there are several ways dates are rendered within the English speaking world. Same holds for Spanish. I have never seen any questions about that, though. Also not from Mac users. This warrants the conclusion that the system language settings have the last say and usually do their job correctly, as well. A US based brother would not be confronted with a UK date format, as he probably set his computer to US settings, and so on. 

Problems occur when congregation language does not equal OS language or settings. 

Foolproof way would be to hardcode date format into template. Unformatted template dates ultimately follow OS settings.

To force TB to follow you OS settings, you may have to set your OS settings wrongly, reopen TB, then set OS correct again, reopening TB.  You would really have to try and fiddle around a bit to see what works.

If TB should NOT follow OS settings, the safest way would be to hardcode date format into the template, preferably saving that as a separate template for that language.

In general, both in OS settings and in template formatting, notice the difference between d and dd (and m and mm) For June 1, d/m comes out as 1/6, and mm/dd comes out as 06/01. There are more variations, see the alternatives in your OS settings.

Honestly, since date formats in the templates are easy to format, you'd (at least I would) guess so would the time formats. I have tried everything. Formatting like HH:mm (24hr), hh:mm (12hr), h:mm (12 hr without preceding 0 for single digits), but I am not too versed in CSS or HTML or whatever it is, to get this working. I console myself with the thought that I have no one seen reporting they got it working. It is very frustrating.

@Willow Copy the template you want to change outside the templae folder (changing within is usually not possible due to permissions) Open the template with a html editor (there are plenty around and Win10 has one of its own, I always use Brackets). Look for any date in the template and remove the formatting. A date field may look like !DATE ddd, dd.MM.!. Reduce that to !DATE!. Or, if you want, replace the ddd, dd.MM bit by whatever you want the format to be. Make sure the output field starts and ends with an exclamation mark. Put the changed template into the template folder. Rename it first OR rename the original, whichever you prefer.

 


https://www.theocbase.net/support-forum/post/1097-donations.html

For accessing the database my personal preference is http://sqlitebrowser.org/

For editing templates I now use https://code.visualstudio.com/ 

 


3 years ago
·
#3428
0
Votes
Undo

This has been discussed on various occasions now. As you must have noted, none of us got it working within the templates. Repeating the question will not help solve anything, I am afraid. 

At least some did get it working by changing their OS settings. This may be tricky though, especially if TB language is not OS language, and you would have to try a few times to get things set in their right order.


https://www.theocbase.net/support-forum/post/1097-donations.html

For accessing the database my personal preference is http://sqlitebrowser.org/

For editing templates I now use https://code.visualstudio.com/ 

 


3 years ago
·
#3426
0
Votes
Undo

Dear Brothers,

I am having a similar problem.  Some of our friends here in the US get really confused by the 24 hour format.  Is there a way to edit our templates so that it displays the weekend assignemnts in 12 hour format just as the midweek portion does?  

The templates i am working with are:

   - Combination Schedule

   - Weekend Meeting (Ourgoinbg speakers schedule & assignment)

 

I was able to adjust our templates to use the correct date format.  But cannot figure out how to adjust the time.  Any help would be greatly appreciated.

 

Thanks,

Andres

4 years ago
·
#1736
0
Votes
Undo

We welcome our US brothers to the rest of the world! Jokes aside, this has surfaced before. Sometimes overruling TheocBase with Windows (changing Windows setting into wrong and then back into right again after changing the Theocbase interface language) has worked. But I cannot guarantee.

If in the Extra Print Options you choose "show time" rather than "show duration", the starttime will not appear (wrongly) in the schedules. That wouldn't fix the dates though.

Does it happen in all templates? I would worry about the assignment slips, since I do not know how to influence those. As for the other html templates, you might consider adapting the existing ones into whatever you need. If necessary you could even have an English combination template and a Spanish one. Especially the combination template has the date format hard coded. If you need help adapting those, you can get it here.


https://www.theocbase.net/support-forum/post/1097-donations.html

For accessing the database my personal preference is http://sqlitebrowser.org/

For editing templates I now use https://code.visualstudio.com/ 

 


4 years ago
·
#1729
0
Votes
Undo

Additionally, I have checked my computer time zones and formats and they all check out.

  • Page :
  • 1
There are no replies made for this post yet.
Be one of the first to reply to this post!