+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Exporting specific information, help please in Technical; I need to export some data from sims and i just need some pointers on how to get this specific ...
  1. #1
    mrbios's Avatar
    Join Date
    Jun 2007
    Location
    Stroud, Gloucestershire
    Posts
    2,446
    Thank Post
    349
    Thanked 254 Times in 209 Posts
    Rep Power
    98

    Exporting specific information, help please

    I need to export some data from sims and i just need some pointers on how to get this specific information in a specific format...

    I've had an export from nova-t4 given to me but it wasn't ideal as it put all the classes in columns rather than rows.

    I need the 3 columns to be:
    Admission numbers / Class / Year of intake

    The tricky bit is that i need it to be listed by class which the sims reports don't appear to allow me to do.

    So what i want to see is:
    Class 7B/CM1 in Column A 20-30 times, then the admission number of every student in that class in Column B. Then the next class and so on. Column C isn't quite so important as i can enter that manually really.

    Is this possible? and if so how?

  2. #2
    FishCustard's Avatar
    Join Date
    Feb 2013
    Location
    Croydon
    Posts
    420
    Thank Post
    72
    Thanked 40 Times in 36 Posts
    Rep Power
    17
    You don't need to sort by class in the report, as once you've got the data into Excel you can just sort the class code column (or have I got the wrong end of the stick?)

  3. #3

    rush_tech's Avatar
    Join Date
    Jul 2006
    Location
    Nottingham
    Posts
    1,408
    Thank Post
    111
    Thanked 265 Times in 201 Posts
    Rep Power
    194
    ^^what he said sort the data in excel a lot easier

  4. #4
    mrbios's Avatar
    Join Date
    Jun 2007
    Location
    Stroud, Gloucestershire
    Posts
    2,446
    Thank Post
    349
    Thanked 254 Times in 209 Posts
    Rep Power
    98
    Ok, I've just tried that but first i need to fill in the blanks.

    Each user has admission number in once, then blank below until the next user...normally a simple task but for some reason it won't let me unless i highlight the empty cells and delete the non existent contents (there was a space in there) quick method for resolving that please?

    EDIT: to explain a bit better, if i go to find + select, go to special and select blanks it fails to highlight the cells until i've highlighted them and pressed delete even though those cells are empty. I've tried a TRIM command to remove the space, but i still seem to have to do it.
    Last edited by mrbios; 20th November 2013 at 07:07 PM.

  5. #5
    FishCustard's Avatar
    Join Date
    Feb 2013
    Location
    Croydon
    Posts
    420
    Thank Post
    72
    Thanked 40 Times in 36 Posts
    Rep Power
    17
    Untick 'suppress duplicate records' when running the SIMS report.

  6. Thanks to FishCustard from:

    mrbios (20th November 2013)

  7. #6
    mrbios's Avatar
    Join Date
    Jun 2007
    Location
    Stroud, Gloucestershire
    Posts
    2,446
    Thank Post
    349
    Thanked 254 Times in 209 Posts
    Rep Power
    98
    Perfect, hopefully this will get me a few steps closer to what i wanted. Thanks for the help, no doubt i'll be back

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] export custom discover groups HELP Please
    By woodham in forum MIS Systems
    Replies: 2
    Last Post: 26th October 2011, 09:29 AM
  2. Replies: 6
    Last Post: 11th February 2011, 06:19 PM
  3. Replies: 5
    Last Post: 4th July 2006, 05:39 PM
  4. questionaire linked to database help please!!!!!!!!!!!!!!!!!
    By suesmate in forum Educational Software
    Replies: 8
    Last Post: 3rd May 2006, 06:07 PM
  5. E Learning Credits - Help Please
    By MuppetQueen in forum Budgets and Expenditure
    Replies: 4
    Last Post: 12th December 2005, 03:10 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
  •