MIS Systems Thread, HELP Urgent required in Technical; I'm trying to export lots of xml files (Marksheets) into one large file, it needs to be in fomatted version ...
11th December 2013, 12:37 PM #1
- Rep Power
HELP Urgent required
I'm trying to export lots of xml files (Marksheets) into one large file, it needs to be in fomatted version (to have the upn).
Whats the best way/software to do this?
It says they are in excel format but then excel doesn't pick them up as so.
I may need to convert to text first then open/save in excel....but again what software to convert 800 xml files to text.....
Thanks for any help,
11th December 2013, 12:52 PM #2
What application are these XML files from - SIMS, or something else? Are you sure they were exported correctly, do they have the correct file extension - Excel might just be expecting a .xls rather than a .xml extension or something.
Originally Posted by Deckard
If you do have 800 XML files that you need to read in, process, and combine into one report then you're probably going to have to write a script to read whatever XML format the files are in. Most programming languages these days will have good support for XML, writing a parser for a particular format shouldn't be difficult.
11th December 2013, 12:53 PM #3
@sted created a script that could take lots of xml files with computer info in and put it into one csv file.
It was something like this,
put the above in a bat file and run in the folder with csv files. I seem to remember if your first csv (01.csv) is just the column headings but without any info it will make a nice form with headings.
del all.csv /q
copy "*.csv" "all.csv" /y
otherwise pm @sted
Last edited by edutech4schools; 11th December 2013 at 12:54 PM.
11th December 2013, 12:54 PM #4
It's from SIMS. Why do you want them all in one file?
What is on the individual marksheets? You could build a large marksheet template that has all data on it, and then export that.
I'm sure recently the restriction on the number of columns in a marksheet was lifted, but i've not tested it's limits.
11th December 2013, 12:57 PM #5
Also, if you're taking a formatted marksheet, then combining them using tools will possibly break the formatting and make them unusable for importing data.
You need to explain a bit more about what you're trying to achieve.
11th December 2013, 01:10 PM #6
- Rep Power
Exporting from SIMS 800 marksheets to create one large excel. It has to be exported in 'formatted' to get the UPN number on.
Trying to create a template with all the data on - from the other 800...
11th December 2013, 01:31 PM #7
Creating a large master marksheet would be better, and hopefully easier in the long run.
11th December 2013, 02:07 PM #8
it only really works with simple text files xml/xls tend to have header/footer info that cant be done this way iirc you can try but i wouldnt hold my breath on it working
Originally Posted by edutech4schools
11th December 2013, 02:25 PM #9
@Deckard - if you tell us what data it is you're trying to extract and what you want to do with it, we may be able to help. I'm sure it'd be possible to do exactly what you're saying, but there may well be a much easier way
11th December 2013, 02:47 PM #10
I'm less experienced that everyone else is on here but you may be able to create a report in routines - design report then select the aspects and result set you want on your report which will the export into 1 excel file
The idea of creating a template with all of the data you want then exporting it sounds like the best and simplest solution
By Deckard in forum MIS Systems
Last Post: 7th December 2013, 02:16 PM
By gibboap in forum Hardware
Last Post: 7th December 2007, 12:27 AM
By SpecialAgent in forum Educational IT Jobs
Last Post: 19th July 2007, 05:24 PM
By paul in forum Educational IT Jobs
Last Post: 18th October 2006, 10:25 PM
By russdev in forum General EduGeek News/Announcements
Last Post: 6th June 2006, 07:01 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)