Exporting appointments

ggd wrote on Tuesday, July 29, 2008:

Hello!

I’m still evaluating OpenEMR (with GNUmed) and wonder if it is possible to export Calendar-data (Appointments) in order to be used with some other application?

In my case, I use Emacs and org-mode as my GTD system and would like to have all OpenEMR appointments in Emacs’ *.org files.

Sincerely,
Gour

cfapress wrote on Monday, August 04, 2008:

Does Emacs support the iCal or vCal standard?

I’ve considered creating some export/import functionality within the Calendar of OpenEMR. I would stick with the iCal or vCal standard. It seems to be the most widely standardized format out there.

Jason

ggd wrote on Monday, August 04, 2008:

<quote>Does Emacs support the iCal or vCal standard?
</quote>

Yes, Emacs’ org-mode support export to iCal.

<quote>
I’ve considered creating some export/import functionality within the Calendar of OpenEMR. I would stick with the iCal or vCal standard. It seems to be the most widely standardized format out there.
<quote>

Right. Those formats are good-enough.

Sincerely,
Gour

sraj49 wrote on Sunday, January 31, 2010:

Hello,
Where is Caledar data posted in the data base? Thanks for the help

Raj

bradymiller wrote on Sunday, January 31, 2010:

hey,
Check out this page for database stuff in openemr:
http://www.openmedsoftware.org/wiki/OpenEMR_System_Architecture#Database
(search for table openemr_postcalendar_events on this page, which holds the appt data, also note other openemr_* postnuke calendar tables nearby)
-brady

sraj49 wrote on Monday, February 01, 2010:

Thanks Brady. long time. Happy New Year…though belated…Yes I did look at the system architecture. I don’t find the openemr_postnuke calender table at the root. I have only the following tables….
#
# Browse openemr_postcalendar_categories
# Browse openemr_postcalendar_events
# Browse openemr_postcalendar_limits
# Browse openemr_postcalendar_topics

I added a sample appointment after logging in to see where the dat goes……I don’t find the same on openemr_postcalendar_events. Am I missing something here?

Raj

sraj49 wrote on Monday, February 01, 2010:

Thanks Brady. I got it. There was an issue purely due to me and has been respolved. Thanks

Raj

zhhealthcare wrote on Saturday, May 08, 2010:

Did you manage to sync the calendar data?  If would you like to share how you did it?