+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 22
MIS Systems Thread, SIMS unique identifiers in Technical; So, I am still crafting reports to use with commandreporter to get the data I want for a program I'm ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,816
    Thank Post
    517
    Thanked 2,473 Times in 1,916 Posts
    Blog Entries
    24
    Rep Power
    836

    SIMS unique identifiers

    So, I am still crafting reports to use with commandreporter to get the data I want for a program I'm writing but I've hit a snag. Only Students seem to have a unique identifier that I can choose to export (UPN or Admission Number for example).

    Contacts/Parents don't. How am I supposed to link parents to pupils without duplication when this is the case? I can't generate one of my own via combinations of other fields as *all* those fields can change at any time. Ideas?

  2. #2
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,219
    Thank Post
    159
    Thanked 147 Times in 132 Posts
    Rep Power
    103
    Not a direct answer...

    You've said they're likely to change, that's fair enough... but if this is going to be more than just a report have a process to get latest data, input into a temp table and create a link this way? Home Tel & PCode are unlikely to change unless they change for both primary contact and child, of course this wont help when parents are separated...

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,816
    Thank Post
    517
    Thanked 2,473 Times in 1,916 Posts
    Blog Entries
    24
    Rep Power
    836
    Quote Originally Posted by dwhyte85 View Post
    Not a direct answer...

    You've said they're likely to change, that's fair enough... but if this is going to be more than just a report have a process to get latest data, input into a temp table and create a link this way? Home Tel & PCode are unlikely to change unless they change for both primary contact and child, of course this wont help when parents are separated...
    That's the thing - we have a significant number of separations, name changes, number changes etc... So we can't rely on any of them. And the data needs to be handled programatically with no input from the users, so it can't prompt to check things either. We can't have the data we want being sent to the wrong places due to the system having the wrong details either.

    The only way I can think of at the moment is to not rely on the parent data as the key data, instead do everything in reference to the child, and store the contact details in a 'message sent' table with the details that any messages were sent to. Messy I reckon, but it may be the only way to do it.

  4. #4
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,219
    Thank Post
    159
    Thanked 147 Times in 132 Posts
    Rep Power
    103
    It's frustrating as something that should be simple is made so difficult to do

  5. #5

    Join Date
    Jan 2006
    Posts
    40
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    18
    Have you looked at the Third Party Reporting stuff in the report engine? To see it you need to be a member of the CES Third Party Reporting Group in system manager. This gives you more info and it might be what your looking for.

  6. Thanks to Benji1 from:

    localzuk (11th February 2010)

  7. #6

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,816
    Thank Post
    517
    Thanked 2,473 Times in 1,916 Posts
    Blog Entries
    24
    Rep Power
    836
    I shall take a look. Although it seems our SIMS admin has gone and removed my System Manager permissions so I've got to wait until they are in tomorrow to sort it for me. (Grr!!!)

  8. #7

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,492
    Thank Post
    1,451
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    Haven't tried this one out, it's just off the top of my head, but if you create a contacts report does it not assign an 'external_id' to each one within the XML output? It will only be in the XML, you don't have the option to add it to your report in report designer. I know it does this with aspects and students but can't remember if it does with contacts.

  9. #8

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,816
    Thank Post
    517
    Thanked 2,473 Times in 1,916 Posts
    Blog Entries
    24
    Rep Power
    836
    Nope. This is what each record looks like:

    <Record>
    <Surname>Bloggs</Surname>
    <Forename>Fred</Forename>
    <MainTelephone>123456</MainTelephone>
    <Email>fredd.bloggs@example.com</Email>
    <Priority>1</Priority>
    <AdmissionNumber>006666</AdmissionNumber>
    <student_status>On roll</student_status>
    </Record>

  10. #9

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,492
    Thank Post
    1,451
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    That's a PITA.

    Ok, only way I can think to do it, though it will vastly inflate the size of the XML file, is to create a student focus report that contains the admission number and a sub report containing all the contacts, then you have the admission number of any student who has that contact link. It does mean that a contact will appear as many times as they are linked to students though.

  11. #10

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,816
    Thank Post
    517
    Thanked 2,473 Times in 1,916 Posts
    Blog Entries
    24
    Rep Power
    836
    Quote Originally Posted by JoshJohnson View Post
    That's a PITA.

    Ok, only way I can think to do it, though it will vastly inflate the size of the XML file, is to create a student focus report that contains the admission number and a sub report containing all the contacts, then you have the admission number of any student who has that contact link. It does mean that a contact will appear as many times as they are linked to students though.
    It still won't give me a UID for the contact though. Meaning duplication and no cross linking.

  12. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    Quote Originally Posted by Benji1 View Post
    Have you looked at the Third Party Reporting stuff in the report engine? To see it you need to be a member of the CES Third Party Reporting Group in system manager. This gives you more info and it might be what your looking for.
    That's what i would do, there is an ID and an External ID field that look like this:

    ID | External ID
    9018 | eed1b95b-66aa-4adb-9aab-5f05eeaa36be
    10599 | 6f8470f3-5e9c-4323-a96e-a30331a4eda9
    1645 | cd04456d-9743-40bd-8909-e566e46e59df
    10429 | ef164ce7-e432-4dc8-b78f-fd58277ad528
    1125e | f5a3a54-3e4b-4eed-933f-fe41a90f3e1e

    You can also dump to XML, you just need the permissions to access the CES ThirdPartyFields area:

    see attached.
    Attached Images Attached Images
    Last edited by vikpaw; 10th February 2010 at 06:14 AM. Reason: layout of numbers got jumbled

  13. Thanks to vikpaw from:

    localzuk (11th February 2010)

  14. #12

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,816
    Thank Post
    517
    Thanked 2,473 Times in 1,916 Posts
    Blog Entries
    24
    Rep Power
    836
    Right, I've just been up with the SIMS manager and we cannot find that group anywhere. Where is it?

  15. #13

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,816
    Thank Post
    517
    Thanked 2,473 Times in 1,916 Posts
    Blog Entries
    24
    Rep Power
    836
    Scratch that, found it. We were looking in the wrong place

  16. #14

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    I have a GOD group to which i add every single role and permission.
    Naturally i am in the GOD group.
    Great for testing

  17. #15
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Hope u ain't dis-lecks-sic then Vic!

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Unique Marksheet Names
    By Teaboy in forum MIS Systems
    Replies: 1
    Last Post: 17th July 2014, 03:25 PM
  2. [MS Office - 2007] Unique Cell Styles
    By CAM in forum Office Software
    Replies: 6
    Last Post: 14th January 2010, 01:26 PM
  3. OWA on a unique port
    By jmair in forum Windows
    Replies: 4
    Last Post: 22nd October 2008, 07:09 PM
  4. Unique identifier
    By danIT in forum MIS Systems
    Replies: 3
    Last Post: 3rd April 2007, 11:28 PM
  5. Sims.net (unique user defined reports missing)
    By edie209 in forum MIS Systems
    Replies: 3
    Last Post: 15th June 2006, 12:17 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
  •