+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, SIMS Exporting primary parent contact main email addresses in Technical; I am trying to create a report which contains the following: Admission number Parent main email address Quite simple I ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,684
    Thank Post
    516
    Thanked 2,453 Times in 1,899 Posts
    Blog Entries
    24
    Rep Power
    833

    SIMS Exporting primary parent contact main email addresses

    I am trying to create a report which contains the following:

    Admission number
    Parent main email address

    Quite simple I think. However, I am getting the following:

    * Admission Number
    * Blank Email
    * New Row
    * Blank Admission Number
    * Email

    But not consistently. Sometimes, the admission number is on the same row as an email address, somtimes not. Sometimes, the same email address is repeated on multiple rows etc...

    Any ideas how I can get Admission numbers and Email addresses on the same rows?

    I need it in a simple format, as I intend to import it programmatically into our cashless catering system. I'd prefer not to have to figure out some form of weird parsing mechanism to get it to stick things together properly...

  2. #2

    Join Date
    Feb 2006
    Location
    Dorset/Hants
    Posts
    87
    Thank Post
    2
    Thanked 13 Times in 10 Posts
    Rep Power
    20
    Quote Originally Posted by localzuk View Post
    I am trying to create a report which contains the following:

    Admission number
    Parent main email address

    Quite simple I think. However, I am getting the following:

    * Admission Number
    * Blank Email
    * New Row
    * Blank Admission Number
    * Email
    Is it because you are getting results for multiple contacts? Can you put the contact name in the result to see, if so then you are either probably not filtering via contact priority or the priorities are not set appropriately in SIMS. As an alternative you might try "return first result only" on the sub report filter.

    tim

  3. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    I've just created this report in my SIMS.net, I have it set up as following:

    Students -> On Roll
    Student Fields: Admission Number
    Contact Sub Report Fields: Main Home Email
    Contact Sub Report Filter: Parental Responsibility = True, Priority = 1,
    Include Records with no such contacts = False
    Display fist record only = True
    Output: Excel Standard Portrait, Divider frequency = 0, Suppress Duplicates = False

    That works perfectly for me, I'll send the rptdef if you like
    Last edited by LosOjos; 29th January 2010 at 10:11 AM.

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,969
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    ARGH! emails in SIMS, my nightmare from before xmas.

    It depends how you ask for the information. See if JoshJohnson's report does what you require if not, i'll edit my data collection report that i did recently, which extracts all emails for all priority 1 and 2 parents.

    If you supress duplicates or only allwo return of 1st match from sub-query that could solve the problem as with J'J's report.

    It all depends on what data you have in your system. You can ask for Main Email, but SIMS lets you have a Main Work, Main Home, etc, so even though you ask for main you can get more than 1 back. There is a separate table called Emails that holds all emails, and you could sub-report on that, and set filter to be Main, but you would still get multiple matches.

    If you only have one main email marked per contact it's not that bad.

    I've posted elsewhere regards emails / data collection / schoolcomms as it took me weeks to get the report definition correct. I've posted it on SupportNet but not sure if it's on the 'Geek. Only downside is that it goes to Word in an array of tables, and so i structured it a certain way, but it's a basis to start from.

    Be warned, it was so complicated that i had to run a main report followed by 4 sub-reports (actual separately created reports called from within the word rtf template, not just sub-queries) to get all the information we held in the system out.
    Last edited by vikpaw; 30th January 2010 at 12:05 PM. Reason: addition rtf template

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Importing Email Addresses into Sims.NET
    By Geoff in forum MIS Systems
    Replies: 49
    Last Post: 27th September 2012, 02:07 PM
  2. Sims Parent Email records to Outlook
    By Simcfc73 in forum MIS Systems
    Replies: 0
    Last Post: 13th January 2010, 01:29 PM
  3. Exporting email from AOL
    By richard_s in forum Windows
    Replies: 0
    Last Post: 11th March 2009, 09:55 AM
  4. Email addresses
    By jcollings in forum How do you do....it?
    Replies: 23
    Last Post: 23rd October 2008, 06:56 PM
  5. understand Parent main menu option
    By jkmoch in forum EduGeek Joomla 1.0 Package
    Replies: 0
    Last Post: 4th May 2008, 06:39 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
  •