将iCal日历导入MySQL数据库 [英] Importing iCal calendar into MySQL database

问题描述

我搜索了很多网站，但他们所有的网站已经取得了相反的效果，但不是我需要的网站。

I've searched through a lot of sites, but all of them do in reverse already what I've achieved , but not what I need.

我需要一种方法将数据从ICAL导入MySQL数据库，实际上只是WordPress数据库中的一个表和几列。但我忽略了WordPress（因为它搞砸了我的导出）并使用直接数据库连接。

I need a way to import data FROM ICAL into a MySQL database, actually just one table and a few columns in a WordPress database. But I'm ignoring WordPress (as it messed up my export) and using direct database connection.

你们任何人都可以帮助我实现这个目标吗？导入ICAL显然很简单，我觉得太难了吗？

Can any of you help me achieve this? Is importing ICAL so obviously simple that I'm thinking way too difficult?

我的ICAL文档设置：

My ICAL docs setup:

BEGIN:VCALENDAR
VERSION:2.0C
ALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-TIMEZONE:Europe/Amsterdam
BEGIN:VEVENT
DTSTART:20120113T133300
DTEND:20120223T165900
DTSTAMP:20120118T093232
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:29007/on/on
TRANSP:OPAQUE
END:VEVENT
END:VCALENDAR

当用户导出多个事件时，从BEGIN：到END：也会重复。在状态我当前（将改为别的）一个帖子ID，无论事件是否开启（true）意味着要显示（为了保留过去事件的数据），以及第二个开启告诉前端事件是否是全天事件（从00:00到23:59）。

From "BEGIN:" to "END:" also gets repeated when a user exports multiple events. In status I've currently (will change to something else) a post ID, whether or not the event is "on"(true) meaning to be displayed (in order to preserve data of past events), and the 2nd "on" tells the front end whether an event is an all-day event (from 00:00 until 23:59).

再次提出这个问题，如何在WP数据库的表格中使用几行代码而不是插件或其他外部代码来导入它？

So again the question, how could I import this, using just a few lines of code, not a plugin or some other external code, into my table in a WP database?

提前致谢！

P.s。 - >我刚刚创建了这个档案，而不是这里的知识，在我刚才创建档案之前我还匿名回答了问题并纠正了一些我发现错误的答案。

P.s. -> I just made this profile, not here to leech knowledge, before I created the profile just now I've also answered questions anonymously and corrected some answers in which I spotted mistakes.

推荐答案

下一个不是通用工具，但可能适合您的需求

The next is not a universal tool, but may suit your needs

dhtmlxScheduler的iCal导出/导入工具

这篇关于将iCal日历导入MySQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！