+ 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
    18,530
    Thank Post
    527
    Thanked 2,648 Times in 2,049 Posts
    Blog Entries
    24
    Rep Power
    925

    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,235
    Thank Post
    162
    Thanked 153 Times in 138 Posts
    Rep Power
    104
    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
    18,530
    Thank Post
    527
    Thanked 2,648 Times in 2,049 Posts
    Blog Entries
    24
    Rep Power
    925
    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,235
    Thank Post
    162
    Thanked 153 Times in 138 Posts
    Rep Power
    104
    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
    19
    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
    18,530
    Thank Post
    527
    Thanked 2,648 Times in 2,049 Posts
    Blog Entries
    24
    Rep Power
    925
    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,771
    Thank Post
    1,511
    Thanked 1,294 Times in 884 Posts
    Rep Power
    813
    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
    18,530
    Thank Post
    527
    Thanked 2,648 Times in 2,049 Posts
    Blog Entries
    24
    Rep Power
    925
    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,771
    Thank Post
    1,511
    Thanked 1,294 Times in 884 Posts
    Rep Power
    813
    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
    18,530
    Thank Post
    527
    Thanked 2,648 Times in 2,049 Posts
    Blog Entries
    24
    Rep Power
    925
    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
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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 07: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
    18,530
    Thank Post
    527
    Thanked 2,648 Times in 2,049 Posts
    Blog Entries
    24
    Rep Power
    925
    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
    18,530
    Thank Post
    527
    Thanked 2,648 Times in 2,049 Posts
    Blog Entries
    24
    Rep Power
    925
    Scratch that, found it. We were looking in the wrong place

  16. #14

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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,450
    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, 04:25 PM
  2. [MS Office - 2007] Unique Cell Styles
    By CAM in forum Office Software
    Replies: 6
    Last Post: 14th January 2010, 02:26 PM
  3. OWA on a unique port
    By jmair in forum Windows
    Replies: 4
    Last Post: 22nd October 2008, 08:09 PM
  4. Unique identifier
    By danIT in forum MIS Systems
    Replies: 3
    Last Post: 4th April 2007, 12:28 AM
  5. Sims.net (unique user defined reports missing)
    By edie209 in forum MIS Systems
    Replies: 3
    Last Post: 15th June 2006, 01: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
  •