+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Line Breaks in Individual Reports via comment Aspects in Technical; Hi folks, Trying to create simple reports (for target setting in the sixth form) which feature a few grades, then ...
  1. #1

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Line Breaks in Individual Reports via comment Aspects

    Hi folks,

    Trying to create simple reports (for target setting in the sixth form) which feature a few grades, then a comment. I want to put the grades and comments onto an individual report which eventually shows only the rows for the subjects the sixth formers study. All fine.

    Only issue so far is that the comments don't feature any of the line breaks that I've put in (as tests) into the excel file (which is then imported).

    The line breaks themselves come from Word, and then are pasted into the excel cells. This is because this is how the teaching staff will likely enter the comments.

    Is there a way of importing the line breaks successfully?

    Cheers,

    Tom


    SIMS: 7.114
    MSOffice 2010
    Windows XP

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    When I imported via Excel many moons ago, it used to actually be a hindrance when they copied in paragraphs, and it came through in whatever form. Will try to remember what or how it happened. Have you tried putting in things like \n

  3. #3

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks vikpaw.

    Unfortunately having to manually adjust each of the many excel spread sheets, and replace breaks with \n (or whatever) wouldn't be terribly desirable.

    And there's no way I could ask teachers to do that!!

    I mean, it's not the end of the world, but you'd have thought that if SIMS wanted people to use the Individual Reports arm effectively, they'd at least allow for line breaks in comments (which constitute a large part of what a report for a student is).

    Tom

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    I just did a test, typing straight into excel and it's fine if you put an ALT+Enter so it's something to do with the way it's pasted from Word.

    To be honest, i'd advise against using this method as i tried it just over a year ago, and it muddled up some of the inbound data, so needed manual checking.

    If you do use it, try to get them to put data straight into Excel, which is what we used to do and then if they want a line break they have to ALT+ENTER. I also tell them to assume line breaks wont come up when it's merged to an individual report, but it does seem to accept them in SIMS now which it didn't before.

    Here, to do paragraphing we utilise multiple comment aspects, so we can guarantee the output.

    Can you not use something else to make input easier? SLG or TASC software / TeachersWebFolder...

    Here they have to do it in SIMS direct until we get SLG up and running, so it's straight from Word to SIMS. It should be better at understanding the line breaks that way, i'd hope. It shouldn't take them long to copy paste.
    Last edited by vikpaw; 18th October 2011 at 01:02 PM. Reason: sense

  5. #5

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Ah right, I thought ALT+Enter might work, actually...

    Unfortunately our staff don't have access to SIMS.

    What I'll do is I'll tell them they can import from Word if they want to sacrifice line breaks, and that line breaks can exist if they manually enter it in and use Alt + Enter...

    ...Although I bet that confuses them... you know what teachers are like !

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    Quote Originally Posted by tben2505 View Post
    ...
    Unfortunately our staff don't have access to SIMS.
    ...
    WHAT DO YOU MEAN?!?! No access to SIMS???
    Incidentally, are you really on 7.114?

  7. #7

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I am, yeah; is that too old?

    No we use another MIS for staff, vikpaw!

  8. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    You shouldn't be more than 3 upgrades behind, to make sure you maintain support. So you'd want to be on at least 7.132, maybe 136 or 138.
    Also, the upgrades bring cool new functionality that you're missing out on, not to mention updates to help with CENSUS and returns, so i'm guessing you must be independent.
    Sorry, was just shocked you don't let the staff get access to the MIS, even if their data is stored on another system.

  9. #9

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Well we basically run two MIS systems for one reason or another, so they have access to our other MIS, just not SIMS

    Thanks for your advice; will try and steer the staff into typing directly into Excel and use ALT + ENTER!

    Cheers,

    Tom

  10. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    I'd do some random tests after import to make sure it's all okay, or if you can convince them it's required, export the marksheets again, post import, and use them for proof reading, this will also double check that the data is properly lined up.

  11. #11

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Cheers mate appreciate that.

    Although the ALT + Enter, I've discovered, doesn't actually transfer over onto the Individual Reports in word!

    Looks like line breaks can't make it from excel to word via SIMS' Ind. Report facility!

  12. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    Quote Originally Posted by tben2505 View Post
    Cheers mate appreciate that.

    Although the ALT + Enter, I've discovered, doesn't actually transfer over onto the Individual Reports in word!

    Looks like line breaks can't make it from excel to word via SIMS' Ind. Report facility!
    It did for me, i tested before posting. I'm using Office 2007, installed on top of Office 2003, so don't know if that makes a difference. It may depend on what you're running, there are problems with Office 2010, but recently, we've found a few hotfixes from Microsoft that resolve those issues.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] HOW-TO: Bulk Update Result Set in Individual Reports (AM7)
    By LosOjos in forum MIS Systems
    Replies: 7
    Last Post: 19th December 2012, 10:15 AM
  2. [SIMS] Individual Reports: Special characters from Grade Set / Comment field?
    By NorthernSands in forum MIS Systems
    Replies: 3
    Last Post: 8th May 2011, 12:40 PM
  3. [SIMS] Data Graphs in AM7 Individual Reports - SIMS
    By Sivadam in forum MIS Systems
    Replies: 4
    Last Post: 8th March 2011, 08:53 PM
  4. [CLOSED] Layout Issue: Sig line break in first post displayed over ad.
    By SYSMAN_MK in forum EduGeek.net Site Problems
    Replies: 2
    Last Post: 19th April 2010, 10:23 PM
  5. Individual reports for students in SIMS
    By cjohnsonuk in forum MIS Systems
    Replies: 2
    Last Post: 25th March 2008, 11:27 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
  •