Simple delphi application sync with Google Calendar and/or i-Calendar
€30-250 EUR
Dalam Kemajuan
Disiarkan lebih dari 3 tahun yang lalu
€30-250 EUR
Dibayar semasa penghantaran
We have a Firebird database with some tables like CHILD, APPOINTMENTS, APPOINTMENTS_REASON, VISITS. We will provide further details on tables if needed.
The business logic is that a client who is a child can create an appointment. This information is stored under the APPOINTMENT table.
What we want to implement is the following
1) We want the records that are stored in APPOINTMENTS table to be synced with Google calendar automatically when the application is started and on demand. Also we need to sync down the google appointments which are not in the application automatically and on demand.
2) When an appointment is stored in APPOINTMENTS table through the Google Calendar, we should find if the client's name,surname,phone, match an existing record in CHILD table and assign the corresponding foreign key to the APPOINTMENTS row.
3) We need a mechanism for achieve a correct syncing without data loss, bidirectionally from and to Google Calendar, to the desktop application, the user needs to have always updated its calendar with the newest appointments.
We need the implementation to be compatible with Delphi XE2, database components FIBPlus (but this is not a big problem, we can adapt the SQL queries to our components), we need a unit/units that can be reused in our project easily. If component for google sync is used, please refer which and if you are using some paid component, let us know to estimate the cost. Also if it is possible the same logic to adapt also for i-calendar (Apple calendar) it would be interesting.