与日历集成 - 来自数据库应用程序
我们使用 PowerBuilder 开发一个小型企业数据库应用程序。的一部分 功能包括安排约会（秘书安排 通过我们的应用程序预约她的医生）。安排预约 存储为数据库记录并可通过我们的应用程序查看/编辑。 相当标准的东西。
我们希望能够将这些预约与医生的预约联系起来 自己的日历，特别是他的手机日历。我正在寻找想法 （示例 PBuilder 代码会很棒，但 .NET 代码也可以）了解如何执行此操作。我的想法是：
1）使用 Google Calendar API 将每个预约链接到医生的预约 个人谷歌日历。如果他随后将手机同步到 Google 日历，他会同步的。这样做的缺点是我们有 将医生的 Google 用户/密码存储在我们的数据库应用程序中，并且 他们必须有一个谷歌帐户，因为它只能使用该帐户。
2) 每次预约时发送 iCalendar 电子邮件 医生的电子邮件地址。这是一个好方法吗？他们必须首先 使用电子邮件客户端（例如 Outlook 或 iPhone 电子邮件）接受电子邮件 预约请求。如果他们使用 Outlook 接受它，他们必须 将他们的手机同步到他们的 Exchange 服务器等。是否有 执行此操作的示例 PB/.NET 代码？我知道如何发送电子邮件，但我需要有关发送 iCalendar 电子邮件的帮助。
任何反馈/建议（例如访问/检查的好网站/工具） 欢迎。
We develop a small business database application with PowerBuilder. Part of the
functionality includes scheduling appointments (a secretary schedules an
appointment for her doctor via our application). The scheduling appointment
is stored as a database record and viewable/editable via our application.
Pretty standard stuff.
We would like the ability to have these appointments tied to the doctor's
own calendar, notably his mobile phone calendar. I'm looking for ideas
(sample PBuilder code would be great, but .NET code would also work) on how to do this. My ideas were:
1) Use the Google Calendar API to link each appointment made to the doctor's
personal Google Calendar. If he then syncs his mobile phone to Google
Calendar, he'll have it synched. The disadvantage to this is that we'd have
to store the doctor's Google user/password in our database app, and that
they'd have to have a Google account, as it would only work with that.
2) Sending an iCalendar e-mail every time an appointment is made to the
doctor's e-mail address. Is this a good way to do it? They'd have to first
use an e-mail client (such as Outlook or iPhone e-mail) to accept the e-mail
appointment request. And if they used Outlook to accept it, they'd have to
have their mobile phone synced to their Exchange server, etc. Is there any
sample PB/.NET code on doing this? I know how to send out e-mails, but I would like help on sending an iCalendar e-mail.
Any feedback/suggestions (such as a good website/tool to visit/check on) is
welcome.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您不需要在您的应用中存储医生的 Google 用户名和密码。您只需要秘书和医生都拥有 Google 帐户，并且允许秘书的帐户编辑医生的日历即可。
然后，您可以向秘书询问他们的用户名和密码，生成 authsub 令牌，然后在应用程序实例的剩余生命周期中使用该令牌。
然而，它确实依赖于拥有谷歌帐户。如果他们这样做，我怀疑这将是一个比发送带有 ICS 的电子邮件更简单的解决方案（从用户的角度来看）...但我有偏见，作为一名从事 Google Mobile Sync 工作的 Google 员工:)
You wouldn't need to store the doctor's Google username and password in your app. You'd just need both the secretary and the doctor to have Google accounts, with the doctor's calendar allowing the secretary's account to edit it.
You could then just ask the secretary for their username and password, generate an authsub token, and then use that token for the rest of the lifetime of the application instance.
However, it does rely on having Google accounts, certainly. If they do, I suspect this would be a simpler solution (from the users' point of view) than sending an email with the ICS in... but I'm biased, as a Google employee who works on Google Mobile Sync :)
我会选择选项 1，因为它是最自动化的做事方式。
您可以设置一个名为 DocCalendar 的 Google 日历，并将其与医生的 GMail 帐户共享。在您的应用程序中修改的任何约会也应该在此日历中进行修改。
医生可以将此共享的“DocCal”日历与他/她的手机同步。
I would go with Option 1 as it it the most automated way of doing things.
You can set up a Google calendar called DocCalendar and shared it with the doctor's GMail account. Whatever appointments are modified in your app should be modified in this calendar as well.
The doctor can sync the this shared 'DocCal' calendar with his/her phone.
这一切听起来都是倒退的。向第三方系统提供任何类型的医疗相关记录听起来是个坏主意。但如果您需要，为什么不在网络服务器上发布 .ics 文件（可以选择进行某种身份验证），然后让医生订阅它呢？您可以从 Google 日历、Outlook 以及几乎所有日历应用程序订阅日历。
选项 1 需要您做更多工作，并且限制您使用 Google。
选项 2 对医生来说需要做更多的工作。
This all sounds backwards; making any kind of medical related records available to 3rd party systems sounds like a bad idea. But if you need to it, why not publish a .ics file on a webserver (optionally with some kind of authentication) then have the doctor subscribe to it? You can subscribe to calenders from Google Calender, Outlook, and virtually every calender app under the sun.
Option 1 is a lot more work for you and limits you to using Google.
Option 2 is a lot more work for the doctor.