+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
MIS Systems Thread, Sims Problems in Technical; Hi, I've got a couple of issues with Sims (well 5 in total) and a couple of them they have ...
  1. #1

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,903
    Thank Post
    25
    Thanked 96 Times in 76 Posts
    Rep Power
    51

    Sims Problems

    Hi,

    I've got a couple of issues with Sims (well 5 in total) and a couple of them they have said that they can't replicate the issue with my data at their place so it must be something wrong locally.

    They both seem to be related to UDF that I have created.

    The latest on is for a date field.

    When I run the report in Excel this fields data is wrong. The date seems to flip round when its allowed to do so.

    So when a date is entered as 11/01/2008 it flips it round to 01/11/2008

    If the date can't be flipped round say 17/01/08 it leaves it alone.

    When I export it to RTF the date seems to be fine.

    They said I should check the regional settings and then came back and said its a local system problem as they can't get it to fail on their system.

    The other issue is running a report I get 'Subquery returned more than 1 value.'

    Anyone else had any problems with UDF's.

  2. #2
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,497
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    76
    On the face of it, that does sound like a date format / regional setting question. If this is so and Capita can't replicate it, ask them how they have their test environment set up and then match your settings to theirs and try again.

  3. #3

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,404
    Thank Post
    38
    Thanked 387 Times in 262 Posts
    Rep Power
    85
    As a guess the machine you are using has an American date setting.

  4. #4

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,903
    Thank Post
    25
    Thanked 96 Times in 76 Posts
    Rep Power
    51
    So the machine has selective American settings???

    I need to look in the registry and work out the setting that selects column B to change some of the settings to US if it can but leaves the ones it can't and leaves column C alone.

    Also it only switches on the US settings via Excel but not word.

    Need to speak to Microsoft cos this must be a OS error. Thanks Sims people for pointing out M$ core problems.

    CAN YOU SMELL THE SARCASM??????????????????

  5. #5

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,556
    Thank Post
    112
    Thanked 178 Times in 145 Posts
    Rep Power
    72
    I have a vague recollection of this issue a while back. I'm not in til Monday but I'll dig through my stuff and see if I can find anything.

  6. #6
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,497
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    76
    I did detect your sarcasm, but I have seen SIMS do very funny things with exporting dates, and presenting them in a format different to what Excel seems to think they are.

    Quote Originally Posted by Simcfc73 View Post
    Also it only switches on the US settings via Excel but not word.
    In which case, can you export your report to Word (complete with UK settings) and then paste that into Excel?

  7. #7

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,601
    Thank Post
    110
    Thanked 771 Times in 599 Posts
    Rep Power
    183
    The reason that world might not be exhibiting the issue is because it purely treats the dates as text. Excel will try to be clever and format the cells as 'date' and if your regional settings are wrong it will mess this up. It does sound more like a Windows or Excel issue than SIMS.

    You could try opening your export in a different spreadsheet app - e.g. OpenOffice Calc.

  8. #8

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,903
    Thank Post
    25
    Thanked 96 Times in 76 Posts
    Rep Power
    51
    Quote Originally Posted by Ric_ View Post
    The reason that world might not be exhibiting the issue is because it purely treats the dates as text. Excel will try to be clever and format the cells as 'date' and if your regional settings are wrong it will mess this up. It does sound more like a Windows or Excel issue than SIMS.

    You could try opening your export in a different spreadsheet app - e.g. OpenOffice Calc.
    But why would it only do selective changes and why would other exported data display correctly?

    It only messes up the UDF field that I created, the other date fields that are exported are all correct.

    This is the data exported to Word

    Mr, **** 11 March 2008 17/03/2008 11/03/2008 08 March 2008

    The same data in excel

    Mr, **** 11-Mar-08 17/03/2008 03/11/2008 08-Mar-08

    Must be an issue with UDFs.

  9. #9

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,404
    Thank Post
    38
    Thanked 387 Times in 262 Posts
    Rep Power
    85
    I will ask someone to try this out for you again. I don't suppose you have a case reference?

  10. #10

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,125
    Thank Post
    217
    Thanked 1,353 Times in 826 Posts
    Blog Entries
    4
    Rep Power
    528
    Quote Originally Posted by Simcfc73 View Post
    But why would it only do selective changes and why would other exported data display correctly?
    Cause word just treats it as text, whereas excel formats it as a date.

    It's not an OS error, its a a misconfiguration.

    look in your date/time and regional settings

    hope this helps

  11. #11

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,903
    Thank Post
    25
    Thanked 96 Times in 76 Posts
    Rep Power
    51
    Nope, every setting on the computers I have tried is set to UK, there's no settings either in the regional settings or in Excel that are not set to UK.

    Logically it would change the other dates to US if it was set wrong wouldn't it?

  12. #12
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,497
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    76
    As I said earlier, can you export the report to Word and then paste it into Excel? A bit cumbersome, but if it works...

  13. #13

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,125
    Thank Post
    217
    Thanked 1,353 Times in 826 Posts
    Blog Entries
    4
    Rep Power
    528
    Wouldn't necessarily change all the dates, as I said, just those which are processed as a "date" and not as Text.

    Possibly on the server? just need to check all possibilities.

  14. #14

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,404
    Thank Post
    38
    Thanked 387 Times in 262 Posts
    Rep Power
    85
    Just to confirm what the SIMS Service Desk have done. We have taken your data onto our machine and run the report without exhibiting the problem that you describe.

    They were able to replicate it by doing the following:
    • Go to Control Panel
    • Select Regional Settings
    • Select Regional Options tab
    • Top drop down menu to English (United States)
    • Customize button – select date tab
    • Changed short date format to MM/dd/yyyyy

    So this would indicate that it is an environmental setting at the school in Regional Settings.

    Hopefully you will be able to resolve this now.

  15. #15
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    31

    Wink

    Quote Originally Posted by PhilNeal View Post
    Just to confirm what the SIMS Service Desk have done. We have taken your data onto our machine and run the report without exhibiting the problem that you describe.

    They were able to replicate it by doing the following:
    • Go to Control Panel
    • Select Regional Settings
    • Select Regional Options tab
    • Top drop down menu to English (United States)
    • Customize button – select date tab
    • Changed short date format to MM/dd/yyyyy

    So this would indicate that it is an environmental setting at the school in Regional Settings.

    Hopefully you will be able to resolve this now.
    Lmao.. pwnt



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

Similar Threads

  1. SIMS SQL access and capita problems
    By the_travisty in forum MIS Systems
    Replies: 6
    Last Post: 29th August 2008, 12:53 PM
  2. Sims Admissions Problems
    By sallyb in forum MIS Systems
    Replies: 0
    Last Post: 9th December 2007, 10:23 PM
  3. Problems installing SQL 2005 for SIMS
    By timbo343 in forum Windows
    Replies: 6
    Last Post: 7th November 2007, 11:27 AM
  4. sims august update problems
    By Jonny_sims in forum MIS Systems
    Replies: 2
    Last Post: 12th September 2007, 04:56 PM
  5. Printing problems in SIMS Attendance
    By sidewinder in forum MIS Systems
    Replies: 0
    Last Post: 21st May 2007, 03:26 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
  •