+ 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,624
    Thank Post
    1,240
    Thanked 778 Times in 675 Posts
    Rep Power
    235
    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,038
    Thank Post
    83
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    @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
    5,968
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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
    5,968
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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
    5,968
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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,589
    Thank Post
    228
    Thanked 856 Times in 735 Posts
    Rep Power
    296
    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,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    @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
    165
    Thank Post
    41
    Thanked 6 Times in 5 Posts
    Rep Power
    22
    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
  •