+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, SIMS.net report problem in Technical; Does anyone know how to get sims.net reports to output the following: Pupil full name, Year, Reg group, address, parent/contact ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,525
    Thank Post
    513
    Thanked 2,399 Times in 1,859 Posts
    Blog Entries
    24
    Rep Power
    821

    SIMS.net report problem

    Does anyone know how to get sims.net reports to output the following:

    Pupil full name, Year, Reg group, address, parent/contact name, priority, number

    I thought of doing it this way:

    Pupil name, year, reg, address, UPN - In one report

    Parent name, priority, contact name, home number, mobile number, work number, other number, UPN

    But if there are multiple contacts, it doesn't output the UPN each time, it leaves it blank.

    Any ideas?

  2. #2

    rob_f's Avatar
    Join Date
    May 2008
    Location
    Leeds
    Posts
    224
    Thank Post
    15
    Thanked 73 Times in 56 Posts
    Rep Power
    25
    Isn't there a supress duplicates or similar named checkbox on one of the last screens of the report wizard? Have you tried that?


    Rob.

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,525
    Thank Post
    513
    Thanked 2,399 Times in 1,859 Posts
    Blog Entries
    24
    Rep Power
    821
    Quote Originally Posted by rob_f View Post
    Isn't there a supress duplicates or similar named checkbox on one of the last screens of the report wizard? Have you tried that?


    Rob.
    Yep, it simply either outputs duplicate contacts or not. It doesn't affect the blank UPN on separate parent entries

  4. #4

    rob_f's Avatar
    Join Date
    May 2008
    Location
    Leeds
    Posts
    224
    Thank Post
    15
    Thanked 73 Times in 56 Posts
    Rep Power
    25
    Erm, don't really know then. We did a very similar report to list absent pupils along with all contact phone numbers a while ago, however i'm no longer with the school so don't have access to SIMS to have a look at how we did it. It was something along the lines of setting up an RTF report template to hold it IIRC.

    Sorry!

  5. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,525
    Thank Post
    513
    Thanked 2,399 Times in 1,859 Posts
    Blog Entries
    24
    Rep Power
    821
    Quote Originally Posted by rob_f View Post
    Erm, don't really know then. We did a very similar report to list absent pupils along with all contact phone numbers a while ago, however i'm no longer with the school so don't have access to SIMS to have a look at how we did it. It was something along the lines of setting up an RTF report template to hold it IIRC.

    Sorry!
    It also has to be in csv format, for inputting into another database.

  6. #6

    rob_f's Avatar
    Join Date
    May 2008
    Location
    Leeds
    Posts
    224
    Thank Post
    15
    Thanked 73 Times in 56 Posts
    Rep Power
    25
    If this is something that would ordinarily be done by technical users, and not on a frequent basis, i would suggest putting together a bit of a script/program to do the following:

    load the csv line by line value by value into a 2d array
    if currentline(upn value)==null then set currentline(upn value) to previousline(upn value)
    spit the array back out to a csv

  7. #7

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,525
    Thank Post
    513
    Thanked 2,399 Times in 1,859 Posts
    Blog Entries
    24
    Rep Power
    821
    Quote Originally Posted by rob_f View Post
    If this is something that would ordinarily be done by technical users, and not on a frequent basis, i would suggest putting together a bit of a script/program to do the following:

    load the csv line by line value by value into a 2d array
    if currentline(upn value)==null then set currentline(upn value) to previousline(upn value)
    spit the array back out to a csv
    It isn't going to be a simple script though, as the goal is to set up the report to run automatically, then have a php script which runs at a certain time, drops all the data from a table (or 3 as the case may be) and import all the new data.

    But it seems that I am going to have to bite the bullet and write a script to do a lot of work on the data - such as stripping non-numeric characters from phone number fields and putting them in comment fields separated from the number.

    What should have been a simple thing has turned into a complex issue. As seems to be the norm with SIMS.net.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS report display/export issues
    By ndavies in forum MIS Systems
    Replies: 15
    Last Post: 17th March 2008, 04:28 PM
  2. SIMS.net RTF Report Problem
    By MARKR in forum MIS Systems
    Replies: 3
    Last Post: 21st February 2008, 09:54 AM
  3. Another Sims Report
    By Jamie_a in forum MIS Systems
    Replies: 2
    Last Post: 29th January 2008, 04:58 PM
  4. report problem
    By Jamie_a in forum MIS Systems
    Replies: 3
    Last Post: 25th April 2007, 11:00 AM
  5. SIMS Network - Problem
    By Nij.UK in forum Windows
    Replies: 0
    Last Post: 22nd June 2006, 01:59 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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