[sims] Timetable to Exchange

[nickbro]

Want to export your timetable to Exchange Calendar Appointments, for all of the staff, for the whole year?

 

I got bored yesterday and made this: http://twitter.com/techienickb/status/360373788128460801.

 

More info and download: SIMS.net to Exchange - nb development

[FishCustard]

This looks very cool - I'm assuming it dumps it into their regular Exchange calendar?

 

If you want to update the data due to a timetable change, will it overwrite the existing data, or create new events?

[nickbro]

Yep, using Exchange Web Services. It should in theory work with Office 365 as well.

 

Yep, it will remove existing, see the notes at the bottom of SIMS.net to Exchange - nb development (just wrote about that)

[nickbro]

Example of what it will create[ATTACH=CONFIG]19759[/ATTACH]

[FishCustard]

Nice, I can see this being useful for some staff who use their Outlook calendar a lot.

 

In the docs, when you say it removes all appointments after the first date in the XML file, does that literally mean all appointments in the user's calendar are nuked, or just the ones that the script has created?

[nickbro]

Nope, unless they have appointment's starting with "Lesson:" (this is how the system looks for stuff it's created to remove)

[FishCustard]

I thought that'd be the case, just wanted to check.

[nickbro]

It was the easiest way to check, otherwise the import would take 3x as long as it looks for appointments matching the time, and name for each lesson, in each term.

[ModeratelyGruntled]

Hi there

 

Apologies for digging this up - is this still supported/expected to function as described on your website? I realise it's been a few years...

 

Ta!

[ITGURU]

I'm looking to test this too, however when the following is stated, i'm not sure i understand what it means?

 

8.Edit staffmapping.xml putting email addresses against the staff's details that SIMS will spit out

9.Edit roommapping.xml putting email addresses against the room code that SIMS will spit out

 

anyone still using this successfully and is there a way to test a few years without all when running for the first time?

[nickbro]

New Version attached. Works with office 365. Some speed improvements

SIMSExchange.zip

SIMSExchange Service.zip

[ModeratelyGruntled]

Hi Nick

 

Many Thanks for this! Just had a crack at it - crashes while connecting to Exchange. Error details and contents of exchange.exe.config below. terms.xml, report.xml, and rooms.xml are all edited as described on your site.

 

Problem Event Name: CLR20r3 Problem Signature 01: CHS.SIMSExchange.exe Problem Signature 02: 1.0.0.0 Problem Signature 03: 5a7cb06f Problem Signature 04: System.Xml Problem Signature 05: 4.7.2612.0 Problem Signature 06: 5a15cf84 Problem Signature 07: b85 Problem Signature 08: 27 Problem Signature 09: System.Xml.XmlException OS Version: 6.3.9600.2.0.0.272.7 Locale ID: 2057 Additional Information 1: 4cad Additional Information 2: 4cadb351abf16807d0dbdaa6ba5c3f74 Additional Information 3: 8cfa Additional Information 4: 8cfab193864cbc891a61eb35e978a74d

 

                                                                            simsuser                                        simspassword                                        [email protected]                                        False                                                                                ourGApassword                                        False                                        True                                        False                                        True                                                                                :Reg=8.30-9.00:1=9.00-10.00:2=10.00-11.00:3=11.25-12.25:4=12.25-13.25:5=13.55-14.50                                        False                                        1                                                                

Also - what does the "Cover" setting do?

Thanks in advance! Let me know if you need more details.

 

(apologies - I can't seem to get the xml to display nicely. Can dm you the .xml files if needed)

[nickbro]

I'll look into that when I get home hopefully. The cover option is, if you export the html from sims for cover it will process that and make cover appointments

[forkies]

I'll look into that when I get home hopefully. The cover option is, if you export the html from sims for cover it will process that and make cover appointments

 

Same error here, below is the file in the directory called "SIMSerror.log", it is happening at "Step 2: Export to Exchange"

 

Data at the root level is invalid. Line 1, position 1.
System.Xml
System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.
  at System.Xml.XmlTextReaderImpl.Throw(Exception e)
  at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()
  at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
  at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
  at System.Xml.XmlDocument.Load(XmlReader reader)
  at System.Xml.XmlDocument.Load(String filename)
  at CHS.SIMSExchange.Thread.Start()

[nickbro]

That error is either a bad staff list, bad terms.xml file or bad report from SIMS.