Hi Detox,
There are many better ways to read/write appointment data in EGW, the last way of which should be direct database access. You should investigate some of these ways, like xmlrpc.php, esync and import/export &c. These methods can do all the lower level work for you and make for a more stable and secure database.
If you really need to work directly with the database, you should enable the query log for your RDBMS and see the SQL being executed, then try adding some appointments and understand what’s happening (look at read queries too, not just write queries). This is probably an easier way than going through the code to understand what/how/why the SQL is being generated but that’s really not a good way unless you really really know what you’re doing.
There’s a load of other better ways and you’d be making life a lot harder for yourself if you didn’t play with those first, it’s likely they will all easily do what you want and save you the complexity of the lower levels by abstracting it away for you.
Best of luck,
WLD
I want to pull data from the database showing appointments for a specific
person in order to display them in a seperate server based programme. I
have looked at all the tables and find one refernce in the egw_caluser table
under cal_user_modified. If this is the actual appointment date, what other
tables do I need to pull from to to display?
I am using software called Servoy for our client management.
I would like to display set appointments in our client’s details, butr I
need to figure out what tables / columns to pull from.
The way i think it would work best is this: The staff would create an
appointment in Outlook (using the client ID as “location”. This would be
synce’d with Funambol to eGroupware. Then I would display the appointment
specifics in the client details in Servoy, pulling the appt specifics from
the “Location (client id)” I see in egw_cal all the data I need, but
there is no date in the cal_modified column, I see = 1328816533 listed for
a specific entry. If this is a date, I would have no idea how to translate
it into a readable date / time.
So if anyone can assist in explaining what data to pull to show an
appointment outside of eGroupware, I’d really appreciate it.
Thanks in advance!
–
View this message in context: http://egroupware.219119.n3.nabble.com/Where-in-the-database-are-appointment-times-tp3984932.html
Sent from the egroupware-users mailing list archive at Nabble.com.
Live Security Virtual Conference
Exclusive live event will cover all the ways today’s security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
