navier98 wrote on Tuesday, June 12, 2012:
Hi:
Is there a way to have the calendar start on Sunday?
thanks!
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.