[sims] SIMS to Exchange Calendar Tool

[victory2012]

Here's a version with error logging

 

 

 

hi nick thanks for this, ive run it and found it wasnt finding my autodiscover uri ? i think ive fixed that but to confirm should that be the https://exchange/autodiscover/autdiscover.xml?

 

i now run it and it stops at step 2 export to exchnage nothing in the log file for staff, the sims log file has " Object reference not set to an instance of an object." in it but no idea what it is referring to.

 

Thanks

 

Edit - also getting The request failed. The remote server returned an error: (404) Not Found. in the staff log file.... maybe my uri is wrong?

Edited October 15, 2014 by victory2012

[Boredguy]

Tested your updated version this morning with error checking, and my two test staff accounts happily deleted and recreated appointments, and the one that has cover assigned also had that entry added into the calendar.

 

Only niggle I have is that the program does auto close, or say it's finished all the processing so it just sits there with 3 of the 4 green bars full (since I'm not doing rooms), other than that it's fine.

[victory2012]

Right think i figured it out now..need to put /ews/exchange.asmx uri in.

 

I have it working but i need to go through the report and change Mon,Tue etc.. to Day1,Day2 etc... is there any chance of having option in config to change what we use in sims? if your able do that be great as it runs perfect once i change do find and replace on the report.xml.

 

report did run ok when i was testing now im using full report.xml from sims its throwing up a "Object reference not set to an instance of an object." error in the log files... any help be most appreciated feel am nearly there..

 

 

Many Thanks

Edited October 15, 2014 by victory2012

[nickbro]

Ok, here is an updated version with more error logging.

 

 

 

I've also attached a service that can be run on a server which monitors the cover folder. Make sure you set it to use a local path. Double clicking on the file runs a tester but you can install it via

c:\Windows\Microsoft.NET\Framework\v4.0.30319\InstallUtil.exe CHS.SIMSExchange.Service.exe

to uninstall it with the /u switch

SIMSExchange.zip

SIMSExchange Service.zip

Edited October 17, 2014 by nickbro

[Boredguy]

Nick, is there any way to get the main SIMS Exchange window to closed once it has completed the transfer? I have it set to silent but the window still remains open with the green bars all at 100%

 

Also I managed to resolve the issue of the non timetabled lessons. As I've got a powershell script doing a find and replace for the day names, I've created a separate xml file with the staff records in the same syntax and just added their PPA/Meetings manually, and the powershell then finds the closing report tag and replaces it with the whole contents of my meetings xml one.

[nickbro]

Cool, if you want to provide what your system currently using day name wise I'll add it to the system and try and figure out why it's not closing with the silent tag, need to do it at home as that has more up to date source code now.

[Boredguy]

Our SIMS timetable has the days defined as 1Mon -> 2Fri, but renaming the entries to Day1->Day10 isn't a problem now as I've just added the report generation and the subsequent re-write to our daily scheduled tasks that pull out a half dozen other SIMS reports at the time table (such as the timetable from the Periods view for our own booking system)

[nickbro]

Ok, I'll add direct support for 1Mon -> 2Fri in the next release, and fix the silent issue.

 

I'll be adding to the SIMSExchange Service the ability for it to monitor a folder for file changes and then process them in the next release of that app. It's proving very reliable for me at the moment for cover (I did have to set the service to auto restart when it stops through, but it processes within 2 minutes of exporting the cover arrangements)

[nickbro]

Updated exe

SIMSExchange.zip

[nickbro]

New SIMSExchage Service, if anyone wants to try it out?

SIMSExchange Service.zip

[victory2012]

Hi Nick

 

just testing for you now.. im getting an error in the log file

 

Object reference not set to an instance of an object.

CHS.SIMSExchange

System.NullReferenceException: Object reference not set to an instance of an object.

at CHS.SIMSExchange.Staff..ctor(XmlNode node)

at CHS.SIMSExchange.Thread.Start()

 

 

do you know what this means?

 

Also is there any chance you can add direct support for Mon, Tue , Wed etc... for the day for us ......

 

Many Thanks as always

[masimbam]

Hi Nick

Many thanks for this tool. I'm running the latest version but nothing seems to be happening, and nothing is reported in the error logs. As the app runs, I get the first progress bar run across the screen, but when the status message on the bottom changes to Connecting to Exchange the application quits. Any ideas.

[nickbro]

Have you set the exchange url?

[masimbam]

Yes the Exchange uri is in as well as the EXIMP credentials

[drewjpotter]

Hello,

 

I have tried the script with the exchange uri but it does not work, it says "Export to Exchange" and then immediately closes.

 

I can't debug the code because there is no error message.

 

Would you be kind enough to offer some tips or even release some of the source code for debugging?

 

We would really like to get this tool working at Yateley School.

 

Andrew

[nickbro]

Did you try the version above? It should create a log file with any error messages

[drewjpotter]

I tried the version above and modified the config file and got this error:

 

The directory name \\cri-svr-004.crick.internal\wwwroot\Cover is invalid.

 

However, I did not have this directory in the config file.

[vdp]

Hi, we have been using this successfully for some months now, but all of a sudden it has duplicating the lessons in teachers calendars. Is anyone else seeing this? Or able to tell me how to stop it?

 

Thanks!

[Reverend_Dan]

Just downloaded this, and Thanks to Nick btw.

 

Its doing this for me also. I think its not handling our two week timetable and its changing every day in the cycle to either a day1 or day2 putting them in and then crashing. with this error

 

Object reference not set to an instance of an object.

CHS.SIMSExchange

System.NullReferenceException: Object reference not set to an instance of an object.

at CHS.SIMSExchange.Staff..ctor(XmlNode node)

at CHS.SIMSExchange.Thread.Start()

 

It never makes it past the first staff name before it dies.

 

Example of a record

 

 
 
   Mr
   Bowman
   Bill
   216
   Fri2
   09:10
   10:10
   8H3/Hi
   Year 8