[sims] XML spreadsheet from SIMS.net crashing??

[ljlbray]

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

[LosOjos]

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...

[vikpaw]

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.