search

meeting-room-booking-system / mrbs-code

MRBS application code
Other
127 stars 62 forks source link

Import PHP #1682

Open jberanek opened 8 years ago

jberanek commented 8 years ago

Can you please help m e with importing ICS into MRBS ??

Kind regards,

kais

Reported by: kais1

Original Ticket: mrbs/support-requests/958

jberanek commented 8 years ago

There is a standalone page (ie it is not linked to from any other page) called import.php. Point your browser at this page and follow the instructions and let me know what problems you are having.

Original comment by: campbell-m

jberanek commented 8 years ago

Thank you for your quick reply, Can you please tell me what should I edit to import my ICS calendar to it ?

Original comment by: kais1

Attachments: https://sourceforge.net/p/mrbs/support-requests/_discuss/thread/f40cf5ad/9fea/attachment/alternate

jberanek commented 8 years ago

The events in your ICS calendar will need to have a LOCATION property that corresponds to a room.

Original comment by: campbell-m

jberanek commented 8 years ago

Sorry to be a pain I just can't find the import button and I can't find where I should add the path of my ICS file

Original comment by: kais1

Attachments: https://sourceforge.net/p/mrbs/support-requests/_discuss/thread/f40cf5ad/2ed0/attachment/alternate

jberanek commented 8 years ago

There is no import button. Enter the following URL in your browser: yourdomain/path/to/mrbs/import.php

Original comment by: campbell-m

jberanek commented 8 years ago

Can you please help me I'm having this error

Could not import UID:040000008200E00074C5B7101A82E008000000004046FE6A728ED101000000000000000010000000B4FEA3A6B3D8F44B95FC8D660715A47B

Original comment by: kais1

Attachments: https://sourceforge.net/p/mrbs/support-requests/_discuss/thread/f40cf5ad/ee48/attachment/alternate

jberanek commented 8 years ago

The import is failing because, as it says, the location '(p) 01234 567890' does not exist as a room in MRBS. The import page would create the room if an area had been given, but, as it wasn't, it failed.

I think I will change import.php when I get the time so that you can specify on the form an area to use if one is not given, but in the meantime you will need to make sure that the location exists, or if it doesn't that you have specified an area.

The location in the file you have been using looks like a mobile phone number, so I'm not sure that that's what you intended? In your ics file, each VEVENT needs to have a LOCATION, which should look something like this:

LOCATION:room_name

where 'room_name' is an existing MRBS room, or else something like this:

LOCATION:area_name/room_name

where 'area_name' is an existing MRBS area and 'room_name' is the name of the room, which will be created if necessary.

Original comment by: campbell-m

jberanek commented 8 years ago

I have now edited the last two posts to anonymise the phone number.

Original comment by: campbell-m

jberanek commented 8 years ago

Thank you for your help, I exported the ics from outlook. The phone numbers belong to the meeting description. I don't know why the number have been added as location. I replaced all the numbers by test as below but the numbers desepeared from the description BEGIN:VCALENDAR PRODID:-//Microsoft Corporation//Outlook 14.0 MIMEDIR//EN VERSION:2.0 METHOD:PUBLISH X-CALSTART:20130901T000000 X-CALEND:20160725T000000 X-WR-RELCALID:{0000002E-F175-8BBC-B44F-526371E6CDB8} X-WR-CALNAME:Community Psych Rota BEGIN:VTIMEZONE TZID:GMT Standard Time BEGIN:STANDARD DTSTART:16011028T020000 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10 TZOFFSETFROM:+0100 TZOFFSETTO:-0000 END:STANDARD BEGIN:DAYLIGHT DTSTART:16010325T010000 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3 TZOFFSETFROM:-0000 TZOFFSETTO:+0100 END:DAYLIGHT END:VTIMEZONE BEGIN:VEVENT CLASS:PUBLIC CREATED:20160404T120336Z DESCRIPTION:\n DTEND;VALUE=DATE:20160621 DTSTAMP:20160425T112218Z DTSTART;VALUE=DATE:20160620 LAST-MODIFIED:20160404T120359Z LOCATION:test PRIORITY:5 SEQUENCE:0 SUMMARY;LANGUAGE=en-gb:Henry C (s) TRANSP:TRANSPARENT UID:040000008200E00074C5B7101A82E008000000004046FE6A728ED101000000000000000 010000000B4FEA3A6B3D8F44B95FC8D660715A47B X-ALT-DESC;FMTTYPE=text/html:<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//E N">\n\n\n\n\n\n\n\n\n

\n\n\n X-MICROSOFT-CDO-BUSYSTATUS:FREE X-MICROSOFT-CDO-IMPORTANCE:1 X-MICROSOFT-DISALLOW-COUNTER:FALSE X-MS-OLK-AUTOFILLLOCATION:FALSE X-MS-OLK-AUTOSTARTCHECK:FALSE X-MS-OLK-CONFTYPE:0 END:VEVENT BEGIN:VEVENT CLASS:PUBLIC CREATED:20160404T120312Z DESCRIPTION:\n DTEND;VALUE=DATE:20160607 DTSTAMP:20160425T112218Z DTSTART;VALUE=DATE:20160606 LAST-MODIFIED:20160404T120333Z LOCATION:test PRIORITY:5 SEQUENCE:0 SUMMARY;LANGUAGE=en-gb:Morris G (s) TRANSP:TRANSPARENT UID:040000008200E00074C5B7101A82E00800000000D010D45D728ED101000000000000000 010000000F6F43C53FCAE994F9A14BA444CD9272A X-ALT-DESC;FMTTYPE=text/html:<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//E N">\n\n\n\n\n\n\n\n\n

\n\n\n X-MICROSOFT-CDO-BUSYSTATUS:FREE X-MICROSOFT-CDO-IMPORTANCE:1 X-MICROSOFT-DISALLOW-COUNTER:FALSE X-MS-OLK-AUTOFILLLOCATION:FALSE

Original comment by: kais1

Attachments: https://sourceforge.net/p/mrbs/support-requests/_discuss/thread/f40cf5ad/4274/attachment/alternate

jberanek commented 8 years ago

So in the example above you will either need to make sure there is a (unique) room called 'test', or edit the LOCATION line to read:

LOCATION:area\test

where 'area' exists, and then MRBS will create the room 'test'.

PS When replying could you post by following the link rather than replying to the email, otherwise the entire email appears here. Thanks.

Original comment by: campbell-m

jberanek commented 8 years ago

Thank you very much Campbell for your patience

Original comment by: kais1