Calendar starts on Sunday?

navier98 wrote on Tuesday, June 12, 2012:

Hi:

Is there a way to have the calendar start on Sunday?

thanks!

navier98 wrote on Thursday, June 14, 2012:

Please… Does anyone know how to make the little calendar start on Sunday instead of Monday?
Which file to modify?

thanks!!

yehster wrote on Thursday, June 14, 2012:

In the table openemr_module_vars
there is a row for “pcFirstDayOfWeek”
if you change the pn_value in that row to 0, (default at install time is 1) that should work.

nursejeff wrote on Monday, June 18, 2012:

Thank you yehster.

These little changes make a huge difference.

My office staff is cheering.

Jeff Guillory
NP Health Clinic

wizard353 wrote on Sunday, June 22, 2014:

Kevin,

Please pardon the rank noob question, but how do I modify the value in the table openemr_module_vars as described above? A search of the volume finds three files starting with that name, but none of them contain the string in question, so I suspect that they are database files that have to be accessed through MySQL, and I don’t want to screw anything up.

openemr_module_vars.frm
openemr_module_vars.MYD
openemr_module_vars.MRI

It would be nice if this value could be made one of the configuration options in the administrative pages.

Thanks,

Dave

cmswest wrote on Sunday, June 22, 2014:

use phpmyadmin under Administration->Other->Database, find the table and click edit on the entry

or if you want to do it in mysql run this query:

UPDATE openemr_module_vars SET pn_value=0 WHERE pn_id=219

based on its description:

+-------+--------------+-------------------------+----------+
| pn_id | pn_modname   | pn_name                 | pn_value |
+-------+--------------+-------------------------+----------+
|   234 | PostCalendar | pcNotifyEmail           |          |
|   233 | PostCalendar | pcNotifyAdmin           | 0        |
|   232 | PostCalendar | pcCacheLifetime         | 3600     |
|   231 | PostCalendar | pcUseCache              | 0        |
|   230 | PostCalendar | pcDefaultView           | day      |
|   229 | PostCalendar | pcTimeIncrement         | 5        |
|   228 | PostCalendar | pcAllowUserCalendar     | 1        |
|   227 | PostCalendar | pcAllowSiteWide         | 1        |
|   226 | PostCalendar | pcTemplate              | default  |
|   225 | PostCalendar | pcEventDateFormat       | %Y-%m-%d |
|   224 | PostCalendar | pcDisplayTopics         | 0        |
|   223 | PostCalendar | pcListHowManyEvents     | 15       |
|   222 | PostCalendar | pcAllowDirectSubmit     | 1        |
|   221 | PostCalendar | pcUsePopups             | 0        |
|   220 | PostCalendar | pcDayHighlightColor     | #EEEEEE  |
|   219 | PostCalendar | pcFirstDayOfWeek        | 1        |
|   218 | PostCalendar | pcUseInternationalDates | 0        |
|   217 | PostCalendar | pcEventsOpenInNewWindow | 0        |
|   216 | PostCalendar | pcTime24Hours           | 0        |
+-------+--------------+-------------------------+----------+

fsgl wrote on Sunday, June 22, 2014:

For users unaccustomed to running a query in phpMyAdmin, see this section of Rod’s tutorial. Reassuring when there are pictures.