@HanLouTay - Using notepad++ should be fine, i use that all the time, and you can do a saveas vbs file type. Also, it will colour the code to make it easier to understand and edit.
I think as @LosOjos said, it's most likely being blocked by spybot / the teatimer - monitors registry access mostly, but could be triggered generally as it's an unsafe file type. You should be able to mark it as safe or put it on the ignore list if you have access to the settings.
Sometimes the location of the file makes a difference, try running it from your desktop and if not, then the C drive, sometimes running it from the network can give odd results.
Owing to staff using macs, and file association issues which I frustratingly can't seem to get resolved, the XML files are not opening by default in Excel on macs.
If I can convert them to XLS, they will, by default, open in Excel. Then, if I can covert them back to XML, I can bath import them (you can't batch import XLS).
I know this is a rather laborious workaround - but some staff are really getting confused!!
Only if this is possible of course!
I would have thought that a proper conversion back to XML would be really arduous, but a simple rename might be sufficient. You can import from spreadsheets but you'd have to manually match the columns. I'm pretty sure that you can just rename the xls to xml. I think i used to just copy and paste the data back into an original xml file if it ever went awry.
Assessment Manager Marksheets Import
Date : 14/03/2012 08:45:23
File Name G and T Register10s.xml
File Name G and T Register11s.xml
File Name G and T Register12s.xml
File Name G and T Register13s.xml
File Name G and T Register14s.xml
File Name G and T Register15s.xml
File Name G and T Register8s.xml
File Name G and T Register9s.xml
vikpaw - each row and column has to be mapped to XML headings in order to save as XML from Excel; it's never that easy!
It is theoretically possible to write a script that will convert an XLS back to SIMS format XML, however it's a different story creating sheets that would import automatically back in to SIMS - you'd end up having to match the columns anyway.
The problem is that in each "formatted" marksheet (has to be formatted type for the fully automatic import) there are a couple of hidden rows inside the XML which contain aspect and result set ID's - it is these hidden fields that tell SIMS how to import the data back in. Without them, you're left having to match them up manually. Unfortunately, the initial conversion to XLS results in the loss of that data, meaning any conversion back to XML would still fail.
Sorry about that!
Thats fine thanks for the replies guys!
That's what I thought. So it's manual import. Unless you can get a macro / script to copy paste the data into an equally named .xml file.
There are currently 1 users browsing this thread. (0 members and 1 guests)