MIS Systems Thread, [PARS][SIMS] Diary Export > Outlook 2007 > iPad in Technical; So I've had a look through here at the various methods through which people have been forcing SIMS timetables into ...
11th June 2012, 05:28 PM #1
[PARS][SIMS] Diary Export > Outlook 2007 > iPad
So I've had a look through here at the various methods through which people have been forcing SIMS timetables into Outlook.
And thought "I'm going to test PARS' diary export function instead". And it produces a usable .ics that imports fine into Outlook 2007.
However, when said Outlook/Exchange calendar is synced with an iPad, the timetable doesn't get pulled in. Events created in Outlook 2007 get pulled in fine and events created on the iPad get pushed back up to Exchange without issue.
So I suspect that the PARS/Microsoft-based .ics export is missing something that makes it iPad-friendly after reading around that in general the iPad chokes on Microsoft .ics files, but handles others fine.
Anyone know what the difference is?
(I'm well aware I've strayed outside the realm of MIS, but I'm hoping another PARS user has run into this).
12th June 2012, 09:59 AM #2
Could you export from outlook to another format. Perhaps go out to google and back, or something intermediate. Or just do a straight export / copy to another calendar and test that.
12th June 2012, 01:39 PM #3
Update: it copies items from the School Diary in SIMS (Y8 Hockey Trip in Wensleydale). But it doesn't copy timetabled lessons.
I'm reluctant to set a precedent of syncing MIS data (even one step removed) to Google and I'm waiting on a Tasc ticket. It appears to be a case of "known issue, needs to be shoved through something else to work (i.e Google)", but I'm hoping to just write a script to parse and fix the broken bits.
12th June 2012, 03:03 PM #4
Do it as a proof of concept though , plus along the way you might figure out what is wrong...
12th June 2012, 05:09 PM #5
Right, got this sorted.
When PARS creates the UID: field for an event during the .ics export, it populates every UID as UID:-1. This isn't an issue in Outlook, but an iPad appears to assume (because UIDs are the same) that all events are the same and only imports the last event.
Searching and replacing the UID field so it increments/is unique for each event and then importing the modified .ics makes events go across without issue.
Tested with a couple of hundred events across two calendars.
:let i=1|g/UID:-1/s//\=”UID:1”.i/|let i=i+1
Fix will also be in PARS 5.561
Last edited by pete; 12th June 2012 at 05:27 PM.
13th June 2012, 11:21 AM #6
13th June 2012, 11:35 AM #7
It's worth noting that the RFC for the iCalendar spec strongly suggests UIDs should be unique (at least within the same file) and ideally fully unique (since if you were sharing calendars, you might get wierd UID clashes).
I suggested timestamp+randomnumber as the UID field to Tasc - since it takes very little time to generate, timestamp alone would lead to dupes.
If I has to scale this past 5 users, I'd amend my method to sling a randomly-generated hash into the UID. Something like First_Last@HASHVALUE-calendar.domain.tld which would avoid issues for UID clashes.
13th June 2012, 11:39 AM #8
... or just use a GUID generator...
13th June 2012, 11:53 AM #9
sounds like an app in the making for you hackathon
Originally Posted by matt40k
13th June 2012, 12:09 PM #10
Haha, ain't touching Outlook, Calanders or Exchange... leaving that for Trolley01. Speaking of which, he should have a release soon...
By PICNIC in forum MIS Systems
Last Post: 14th May 2013, 09:39 AM
By pdr in forum MIS Systems
Last Post: 23rd May 2012, 03:14 PM
By Frazer in forum MIS Systems
Last Post: 24th January 2008, 11:36 AM
By choran in forum Windows
Last Post: 14th January 2008, 08:41 PM
By Mintsoft in forum Windows
Last Post: 7th July 2006, 12:52 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)