+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 39
MIS Systems Thread, Absence Analysis in Technical; Hi all, Thanks to those who have downloaded and come back to me with suggestions or bug fixes. I totally ...
  1. #16
    trolley01's Avatar
    Join Date
    Mar 2009
    Location
    Wisbech
    Posts
    71
    Thank Post
    3
    Thanked 18 Times in 14 Posts
    Rep Power
    14

    Cool New Version: 1.10!

    Hi all,

    Thanks to those who have downloaded and come back to me with suggestions or bug fixes. I totally forgot that other schools have different timetable structures - but this is now rectified and you can specify your own timetable structure so that the Cover reports show accurate information. Other fixes include:

    • Generate Data no longer fails when Absences have been recorded which do not have an end date.
    • Generate Data ignores all absences which have neither a start no end date as they are erroneous
    • Periods can be defined which are then used to determine Class cover information
    • Improved Class lookups when analysing Cover Data
    • Pivot tables have had any school specific filters removed from them


    I am looking into whether I can make the workbook import it's data from the HTML output directory for cover. Also before the next update, a way to import information from an old version workbook to save importing everything again.

    Thanks again everyone, and keep the comments coming.

    Page with Information
    Direct Download
    Last edited by trolley01; 10th January 2011 at 09:59 PM.

  2. 2 Thanks to trolley01:

    Sivadam (12th January 2011), vikpaw (10th January 2011)

  3. #17
    DrCheese's Avatar
    Join Date
    Apr 2008
    Posts
    1,019
    Thank Post
    97
    Thanked 158 Times in 107 Posts
    Rep Power
    58
    Hiya,
    We're getting "Invalid absences data file" when importing on the latest version using the report that we imported. I've tried cutting the data right down to just a month or so and we're still getting it. Do you have any sample exports that we could check it against?

    We've got the Class and Cover data imported file, our SIMS manager loves it already!

    THanks

  4. #18
    trolley01's Avatar
    Join Date
    Mar 2009
    Location
    Wisbech
    Posts
    71
    Thank Post
    3
    Thanked 18 Times in 14 Posts
    Rep Power
    14
    DrCheese,

    The SIMS Absences export should look like this:Test Absences.xlsx

    If you still can not get the file to import, can you send it to craig@craig-tolley.co.uk and I will have a look why.

    What version of SIMS are you running?

  5. Thanks to trolley01 from:

    DrCheese (11th January 2011)

  6. #19
    DrCheese's Avatar
    Join Date
    Apr 2008
    Posts
    1,019
    Thank Post
    97
    Thanked 158 Times in 107 Posts
    Rep Power
    58
    aha, ours has an extra column just called "Count" and is missing the "Role" Column. No idea why but adding/deleting those afterwards in the exported excel file solved the problem.
    Thanks
    FYI, we're running Version 7.136

  7. #20
    trolley01's Avatar
    Join Date
    Mar 2009
    Location
    Wisbech
    Posts
    71
    Thank Post
    3
    Thanked 18 Times in 14 Posts
    Rep Power
    14
    Glad you got it to work. It might be worth checking the definition of the Absences: Absences report in SIMS. It should pick up the role from the latest contract with a person, or return a blank if no contracts exist.

    Do you use Personnel in SIMS?

  8. #21
    trolley01's Avatar
    Join Date
    Mar 2009
    Location
    Wisbech
    Posts
    71
    Thank Post
    3
    Thanked 18 Times in 14 Posts
    Rep Power
    14

    Cool New Version: 1.20!

    Hi all,

    More bug fixes and enhancements to the workbook. Thanks again to people for comments, suggestions and problem reports. Much appreciated.

    Anyhow, new features in this version:

    • Fixed Ribbon buttons in Microsoft Excel 2007
    • Fixed missing VBA reference in Import Cover
    • Fixed further missing VBA references in Import Cover
    • Inserted missing declarations in Import Absences and Import Classes
    • Import Cover Days now updates and shows correct information
    • Cover Cover Type report dates are now shown in date order
    • Clear Data leaves header rows in place enabling Import to run
    • Tables have gridlines
    • Import Previous Version command added
    • Lessons Covered by Reason report added


    Main feature here is that you can import an older version of the workbook in the new version, without having to import all your cover, class and absence data again from scratch. Look at the site below for info on this feature.

    Thanks again everyone, and keep the comments coming.

    Information Page
    Direct Download Link

  9. Thanks to trolley01 from:

    Sivadam (20th January 2011)

  10. #22

    Join Date
    Oct 2009
    Location
    Bournemouth
    Posts
    15
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    10
    I'm unable to get either Absenses or Classes data generated from Green Abbey training data to import. Both say 0 records imported. The Excel reports output from SIMS look fine - same as the example provided above. Have enabled Macros in the Trust Centre and tried to Clear data as the supplied file contains data already - that doesn't work either.

    Any ideas please?

  11. #23
    trolley01's Avatar
    Join Date
    Mar 2009
    Location
    Wisbech
    Posts
    71
    Thank Post
    3
    Thanked 18 Times in 14 Posts
    Rep Power
    14
    That seems strange. Can you send me a copy of the absences and classes files that you are trying to import? If you could send them to craig@craig-tolley.co.uk, along with the downloaded workbook that you are trying to import to.

    I have just tested it again on mine and it all works fine.

    Just to check - on the versions tab the last line should read '1.21 - Fixed Incorrect Link from Cover Analysis Reports'

  12. #24
    trolley01's Avatar
    Join Date
    Mar 2009
    Location
    Wisbech
    Posts
    71
    Thank Post
    3
    Thanked 18 Times in 14 Posts
    Rep Power
    14
    Just fixed an bug where if multiple sheets are selected in the absences or classes workbook it will fail to import any records. Now available on the site.

    Information Page
    Direct Download Link

  13. #25
    trolley01's Avatar
    Join Date
    Mar 2009
    Location
    Wisbech
    Posts
    71
    Thank Post
    3
    Thanked 18 Times in 14 Posts
    Rep Power
    14

    Cool New Version 1.27!

    Hi,

    Just a quick post if anyone is still watching this. Fixed a couple of minor issues and allowed Absence files with no Role information to be imported.

    Page with Information
    Direct Download

    Craig.

  14. Thanks to trolley01 from:

    Sivadam (2nd February 2011)

  15. #26
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Keep up the good work trolley01.
    And thanks again.

  16. #27
    trolley01's Avatar
    Join Date
    Mar 2009
    Location
    Wisbech
    Posts
    71
    Thank Post
    3
    Thanked 18 Times in 14 Posts
    Rep Power
    14

    Wink Absence & Cover Analysis - Version 1.33!

    Hi everyone!

    New version out! Had a good look at performance in this one. Much quicker to import information now. Also fixed quite a big issue where the cover staff data was not being imported. You may have to re-import your Cover data again if you see some reports with blank data.

    Hope people are finding this useful. If you have any suggestions please post them on here or PM me.

    Page with Information
    Direct Download

    Craig.

  17. #28

    Join Date
    Feb 2008
    Posts
    5
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi Craig,

    Now we are in the holidays I have some time to look at this. I can see this being very useful. I have tried it with one set of data which worked well once I figured out that I had to enter :1 as period name (The lessons are labelled 2Fri:1) I have tried it with a second set of data but can't get the periods to work, the lessons are labelled Fri 2 1 if have tried " 1" but the leading space is removed. Is there a way around this?

    Cheers

  18. #29
    trolley01's Avatar
    Join Date
    Mar 2009
    Location
    Wisbech
    Posts
    71
    Thank Post
    3
    Thanked 18 Times in 14 Posts
    Rep Power
    14
    Hi,

    Do you have a 2 week timetable?

    Is there any chance you could send me one of your exported cover sheets? You can delete the staff names for privacy. My email is craig at craig-tolley.co.uk (replacing at with @). I will then have a look and see if I can fix this for you.

  19. Thanks to trolley01 from:

    academic_mwnci (22nd August 2011)

  20. #30

    Join Date
    Feb 2008
    Posts
    5
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Just a quick update for anyone else looking for the solution that Craig helped out with. So without any quotes for a two week timetable with the lesson format of similar to Fri 2 1. If you simply put the week number a space and the lesson number i.e. 2 4
    Here is the periods table from that school
    Period Name Period Type
    1 1 Lesson
    1 2 Lesson
    1 3 Lesson
    1 4 Lesson
    1 5 Lesson
    1 6 Lesson
    2 1 Lesson
    2 2 Lesson
    2 3 Lesson
    2 4 Lesson
    2 5 Lesson
    2 6 Lesson
    Registration Registration

    Hope that helps someone.

    Richard

SHARE:
+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. [SIMS] Absence Pay Rate
    By vikpaw in forum MIS Systems
    Replies: 1
    Last Post: 30th July 2010, 08:55 AM
  2. Staff Absence
    By AndySimmo in forum MIS Systems
    Replies: 20
    Last Post: 7th October 2009, 09:52 AM
  3. Student Absence Excuses
    By sippo in forum General Chat
    Replies: 1
    Last Post: 15th May 2009, 10:19 AM
  4. Staff Absence Tracking Tool/Software
    By knightrider in forum MIS Systems
    Replies: 2
    Last Post: 17th February 2009, 03:36 PM
  5. Absence monitoring per lesson - S/W needed
    By mark in forum Educational Software
    Replies: 9
    Last Post: 25th January 2006, 11:28 AM

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
  •