doufu7835 2012-03-11 17:58
浏览 119
已采纳

将Google日历与SQL数据库同步(以及其他方式)?

I would like a Google Calendar to sync with my SQL database. I have a database that contains events (in PST timezone), with the fields 'title' (event title), 'date' (event date, day/month/time ie 05/03/2012), 'time' (event start time in 24h ie 03:00 or 23:30), 'end' (event end time in 24h ie 05:00), and 'embed' that contains the event description. All the fields are strings (not int or date/time).

I'd like to have the Google Calendar sync with the information in the database, and also the other way around (if a new event is added to the calendar, add it to the database).

How can I do this?

  • 写回答

1条回答 默认 最新

  • donglan8999 2012-04-21 19:02
    关注

    You would need to find an XML parser that will get the Google Cal export however often you need, then submit that to the database. The only problem you will run into with that is redundancy if you don't make the parser check if a similar event is already in the database.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 MATLAB动图的问题
  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名