I have an app that uses mySQL to keep a calendar. I would like to sync this calender add/update/remove entries to a google calendar on a regualr interval. MS Platform. Would prefer it to be PHP\XML so that I can maintain once overall infastructure is developed. Will provide mysql table for example. Will expect to implement myself for secuirty reasons. Post support may be needed for defect correction.
Some has asked for specifics to better scope the project. The direction of the info is from mySQL to Google Calendar however a bonus would be to allow Google Calendar to block mySQL time slots with a basic description.
See attached file for table and example data.
Map located below.
schedid - Table key
mdate - Date of scheduled appointment
mtime - Time of scheduled appointment
<A> - Alerts - Do not map
<F> - Appointmenet length
<G> - Notes field - Do not map
<H> - Confirmed 1 = yes
<K> - Appt lenght actual; related to time clocked in\out - Do not map
<N> - Appointment type. See n Type codes
<O> - Appt scheduled with - Do not map
<Q> - Time clocked in\time clocked out - Do not map
<N> type codes:
5 Office Visit
6 Red Eye
7 Spec Check
8 DNF JLW
10 Pickup Glasses
AcctID to Google Calendar: What field
mdate to Google Calendar:When start date
mtime to Google Calendar:when start time
<f> to calculate end date\time in Google Calendar
<n> process for friendly name to Google Calendar: What Field if possible