1. 

   jasmondluk, Member

   Is it possible to export to a calendar .ics file from my event records in my database? Thanks.
2. 

   myDBR Team, Key Master

   What exactly would you like to do? Can you elaborate?

   --
   myDBR Team
3. 

   jasmondluk, Member

   I have a database table that consists fields for the event start date/time, end date/time, subject and location. Can I use mydbr to convert it to the ics file?
4. 

   myDBR Team, Key Master

   You can use the calendar functionality to show a calendar. myDBR calendar functionality allows for you to export events as ics files.

   --
   myDBR Team
5. 

   jasmondluk, Member

   I know how to show a calendar. How to export to ics file? Thanks.
6. 

   myDBR Team, Key Master

   Use option:

   select 'dbr.calendar.options', 'ical', 1;

   See the documentation.

   --
   myDBR Team
7. 

   jasmondluk, Member

   I put the line but I am not able to see the download ics option.

   select 'dbr.css', 'html.pdf .fc .fc-daygrid-day.fc-day-today {background-color: inherit}';
   select 'dbr.css', 'div.title {font-size:24px }';
   select 'dbr.css', 'div.left_text { text-align: left; font-size:14px }';
   select 'dbr.css', 'div.left_text2 { text-align: left; font-size:16px }';
   select 'dbr.css', 'div.right_text1 { text-align: right; font-size:14px }';
   select 'dbr.css', 'div.right_text2 { text-align: right; font-size:18px }';
   select 'dbr.css', 'div.text2 { border: 1px solid black; font-size:16px; padding-top:5px; padding-bottom:5px }';

   select 'dbr.text', null, 'left_text2';
   select 'dbr.text', '';
   select 'dbr.text', null, 'left_text2';
   select 'dbr.text', '2023-08-01至 2023-08-31 (0堂)', 'left_text';
   select 'dbr.text', '';
   select 'dbr.text', '必須帶齊英數作業，此進度表及File。同學必須得中心導師批准下方可改動溫習內容。
   這是一個指引。如校內有突發測驗，同學應以校內測驗為先。', 'text2';
   select 'dbr.text', '';

   select 'dbr.calendar', 800;
   select 'dbr.calendar.options', 'weekNumbers', 0;
   select 'dbr.calendar.options', 'firstDay', 1;
   select 'dbr.calendar.options', 'ical', 1;

   select 'dbr.css', '.fc-event-time {font-size:0.8em}';
   ;

   select 'dbr.text', '';
   select 'dbr.text', '';
   select 'dbr.text', '注意事項：', 'left_text';
   select 'dbr.text', '1）用紅筆將校内小測、默書寫上。', 'left_text';
   select 'dbr.text', '2）補習前應在家中先溫習及帶備所有關於該科的影印本／工作紙／作業／課本。', 'left_text';
   select 'dbr.text', '3）主動向導師諝教溫習方法及内容。', 'left_text';
   select 'dbr.text', '4）收到校内考試/測發時間表。請用紅筆寫上當天考試科目，立刻影印時間表給我們！', 'left_text';
   select 'dbr.text', '5）一切溫習以校内測驗為主。但即使如此，亦應帶備原定已編定的溫習資料 。', 'left_text';
   select 'dbr.text', '6）學員每次遺失或忘記帶進度表，必須到校務處重印，並需每次繳付＄8.00以作行政費用。', 'left_text';
   select 'dbr.text', '';
   select 'dbr.text', '學員填寫上次測驗分數：中文：______ 英文：______ 數學：______ 科學：______ 最高分科目：______ 最低分：______', 'right_text1';
   select 'dbr.text', '';
   select 'dbr.text', '';
   select 'dbr.text', '家長簽名:____________________ 中心主任____________', 'right_text2';
8. 

   myDBR Team, Key Master

   Did you try clicking on the event?

   --
   myDBR Team
9. 

   jasmondluk, Member

   Am I able to export all the events to the ics instead of a single event each time?
10. 

    myDBR Team, Key Master

    The newest myDBR version has iCalendar extension, which allows for you to create *.ics files with multiple entries.

    --
    myDBR Team
11. 

    jasmondluk, Member

    I am on latest 6.6.3, could you please advise how to create *.ics files with multiple entries? Thanks.
12. 

    myDBR Team, Key Master

    See the documentation.

    —
    myDBR Team

Reply

You must log in to post.