+ Post New Thread
Results 1 to 10 of 10
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 ...
  1. #1

    Join Date
    Dec 2013
    Location
    Norton Canes
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    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,

    N

  2. #2

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,653
    Thank Post
    1,257
    Thanked 781 Times in 678 Posts
    Rep Power
    236
    Quote Originally Posted by Deckard View Post
    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?
    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.

    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.

  3. #3

    Join Date
    Apr 2010
    Posts
    2,054
    Thank Post
    83
    Thanked 188 Times in 155 Posts
    Rep Power
    84
    @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,

    del all.csv /q
    copy "*.csv" "all.csv" /y
    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.

    otherwise pm @sted
    Last edited by edutech4schools; 11th December 2013 at 11:54 AM.

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    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.

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    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.

  6. #6

    Join Date
    Dec 2013
    Location
    Norton Canes
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    URGENT HELP

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

    Thanks

    N

  7. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    Creating a large master marksheet would be better, and hopefully easier in the long run.

  8. #8


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    6,646
    Thank Post
    229
    Thanked 865 Times in 743 Posts
    Rep Power
    297
    Quote Originally Posted by edutech4schools View Post
    @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.

    otherwise pm @sted
    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

  9. #9

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,498
    Thank Post
    1,456
    Thanked 1,201 Times in 814 Posts
    Rep Power
    712
    @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

  10. #10

    Join Date
    Mar 2013
    Posts
    168
    Thank Post
    42
    Thanked 6 Times in 5 Posts
    Rep Power
    23
    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

SHARE:
+ Post New Thread

Similar Threads

  1. HELP Urgently required template/marksheet
    By Deckard in forum MIS Systems
    Replies: 3
    Last Post: 7th December 2013, 01:16 PM
  2. Please Help URGENT
    By gibboap in forum Hardware
    Replies: 18
    Last Post: 6th December 2007, 11:27 PM
  3. Lead SIMS Analyst Urgently Required!
    By SpecialAgent in forum Educational IT Jobs
    Replies: 0
    Last Post: 19th July 2007, 04:24 PM
  4. ICT Tech Urgently required Preston
    By paul in forum Educational IT Jobs
    Replies: 8
    Last Post: 18th October 2006, 09:25 PM
  5. urgently required People to conduct interviews..
    By russdev in forum General EduGeek News/Announcements
    Replies: 4
    Last Post: 6th June 2006, 06:01 AM

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
  •