+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, XML spreadsheet from SIMS.net crashing?? in Technical; Our Data Manager has to manipulate XML spreadsheets as part of his routines and re-upload them. Excel crashes when he ...
  1. #1
    ljlbray's Avatar
    Join Date
    Mar 2009
    Posts
    135
    Thank Post
    37
    Thanked 21 Times in 13 Posts
    Rep Power
    15

    XML spreadsheet from SIMS.net crashing??

    Our Data Manager has to manipulate XML spreadsheets as part of his routines and re-upload them. Excel crashes when he tries to save the downloaded XML, then recovers, so no data is lost - but it's obviously not liking the XML. He can save the report as an excel sheet, but then takes 6 attempts to save as an XML after this.

    Thanks in advance for anybody who has any ideas!

    Laura

  2. #2

    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
    SIMS XML exports - no end of fun with these things!

    I find that exporting the marksheets "unformatted" (your DM should know how) is more reliable. Also, exporting them to a file then opening that file seems to be more reliable than exporting straight from SIMS in to Excel.

    It makes no sense to me, but those are just a couple of things I have noticed...

  3. Thanks to LosOjos from:

    ljlbray (10th October 2011)

  4. #3

    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
    I used to get that a lot. I think its an Office problem, having a fit. I would run all office and windows updates and reboot, then try again. I went through a phase of everything crashing office, and getting into a recovery loop.
    I don't think unformatted would work, if you need to reupload the data, unless you fiddle with it, then paste it onto a formatted sheet later.
    Last thing to do would be to reinstall office. I have Office 2007 sitting on top of Office 2003, so it's a weird setup to start with.
    It's also worth deleting 'My SIMS Documents' and 'tempsimsrpt' folder from the user to clear out templates as well as trying a new computer.
    I think sometimes one of the program crashes and leaves temp files and remnants behind that cause Excel to have a fit.

  5. Thanks to vikpaw from:

    ljlbray (10th October 2011)

SHARE:
+ Post New Thread

Similar Threads

  1. Producing ID badges for All Staff from SIMS.Net
    By _techie_ in forum MIS Systems
    Replies: 3
    Last Post: 22nd June 2010, 10:02 AM
  2. Programatic data extraction from SIMS.net Data Base
    By NetworkGeezer in forum MIS Systems
    Replies: 108
    Last Post: 16th February 2010, 09:22 PM
  3. Exporting Attendance Data from SIMS.Net
    By u8dmtm in forum MIS Systems
    Replies: 7
    Last Post: 8th September 2009, 02:27 PM
  4. Producing Classlists from Sims.net NOT Nova
    By mattpant in forum MIS Systems
    Replies: 8
    Last Post: 9th September 2008, 06:26 PM
  5. Where can I get the sims.net SDK from?
    By moogle33 in forum MIS Systems
    Replies: 1
    Last Post: 5th April 2007, 01:25 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •