+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Tables used for School Calendar in Technical; Hello, I am trying to get together an API to expose some data from sims. My primary requirement is based ...
  1. #1

    Join Date
    Mar 2014
    Location
    Poole
    Posts
    2
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Tables used for School Calendar

    Hello,

    I am trying to get together an API to expose some data from sims. My primary requirement is based around calendar data.

    My primary contact is on holls for a week. Thus I was wondering, (if it not against any capita / sims licensing terms), if anyone could tell me the names of the tables I should be looking at?

    In addition, I have been reading posts on this forum which imply that sims actually has its own api's, so if anyone knows if there is a calendar api please let me know.

    Apologies for being so clueless about sims but I can see there are a lot of learned people on this forum and thus reach out to you for help!

    With kind regards,

    Tom

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,480
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    Use the SIMS reporting engine. I'm pretty sure what your asking for has been done, over and over again. If you be a bit more specific I'm sure someone will pop up with a more detailed answer then opening SIMS and going Reports > Design report and then scheduling once your happy with (.csv) export.

  3. Thanks to matt40k from:

    mobilemercenary (31st March 2014)

  4. #3

    Join Date
    Mar 2014
    Location
    Poole
    Posts
    2
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi Matt,

    Many thanks for your quick reply. To clarify, I am trying to expose the data contained in the school calendar in real time via a JSON api.

    Thus for example, when a request is made to my-sims-api.com/get-calendar?start-date=01012014&end-date=01032014 then the api will return the json equivalent of,

    10-01-2014: Whole school assembly
    10-01-2014: Exam briefing for Year 8's
    10-01-2014 : Year 3 Rugby Match against x school
    11-01-2014: Etc. Etc.

    With kind regards,

    Tom

  5. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,885
    Thank Post
    748
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    You should speak to @David_Grashoff about the SIMS API , that would be the best method to access the SIMS data if you really must do it that way and don't want to use the reporting engine and / or the command reporter tool.

    I would also say, it's been mentioned a lot , but i don't know of many people who've had success dealing with the SIMS calendar. It might be worth checking with @rpwillis as Salamander can do funky stuff with the SIMS data.

    p.s. to EG.

    EDIT: altered link to David

  6. 2 Thanks to vikpaw:

    mobilemercenary (31st March 2014), rpwillis (31st March 2014)

  7. #5

    Join Date
    Apr 2008
    Location
    Keighley, West Yorks
    Posts
    393
    Thank Post
    57
    Thanked 54 Times in 48 Posts
    Rep Power
    23
    If you do fancy / are happy to look at the other way, then this post is one of the many which explain it:

    Timetables from SIMS

    I have several batch files running at various times of the day/night/week pulling data out, then various PHP scripts parsing it for display purposes.

    Peter

  8. Thanks to howartp from:

    mobilemercenary (31st March 2014)

  9. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,885
    Thank Post
    748
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    I don't think the Calendar is as easily accessible as timetables, but there have been a couple of threads on it here for data transfer in both directions, and there were also some in SupportNet but the window for catching old threads there is quickly diminishing.



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 22
    Last Post: 14th November 2010, 09:19 PM
  2. MS Schools Agreement - Home Use for governors
    By stratisphere in forum Licensing Questions
    Replies: 3
    Last Post: 19th March 2010, 10:12 AM
  3. Laptops / Netbooks for school use
    By jke1 in forum Hardware
    Replies: 1
    Last Post: 21st January 2010, 01:02 PM
  4. Using google mail for school email, is it a good idea?
    By joseph in forum Wireless Networks
    Replies: 9
    Last Post: 27th August 2009, 11:23 PM
  5. Straw Poll for PDA/UMPC/Phone use in schools
    By Luke_T in forum Netbooks, PDA and Phones
    Replies: 2
    Last Post: 23rd June 2009, 01:18 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •