+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 27
How do you do....it? Thread, Print XML files in bulk in Technical; This is really annoying me. We are printing out multiple reports that have been generated in SIMS but they are ...
  1. #1
    Admiral208's Avatar
    Join Date
    Mar 2008
    Location
    Bridgwater
    Posts
    712
    Thank Post
    171
    Thanked 62 Times in 54 Posts
    Rep Power
    39

    Print XML files in bulk

    This is really annoying me.

    We are printing out multiple reports that have been generated in SIMS but they are exported in an XML format. This is normally not a problem because the files can be opened in word and printed as you would any other normal document.

    However, what I cant do is highlight multiple XML documents, right click and print.

    Im sure this can be done, either with a registry hack or some other method.

    Someone must be able to help me. I have tried renaming the extension to .doc as mentioned in another forum on here, and I still cant right click and print.

    James

  2. #2

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,247
    Thank Post
    2,789
    Thanked 937 Times in 877 Posts
    Rep Power
    343
    Any chance you can make a few random xml type documents from sims that does not have any data in them as none of us need to view or access the said data about students or whatever.

    Can then have a play around with the said files and see if we can do anything with them

  3. #3
    Admiral208's Avatar
    Join Date
    Mar 2008
    Location
    Bridgwater
    Posts
    712
    Thank Post
    171
    Thanked 62 Times in 54 Posts
    Rep Power
    39
    here is one of the file that I have removed anything that will id anyone or thing.
    Attached Files Attached Files

  4. #4

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,500
    Thank Post
    1,186
    Thanked 745 Times in 647 Posts
    Rep Power
    229
    Quote Originally Posted by Admiral208 View Post
    However, what I cant do is highlight multiple XML documents, right click and print.
    You can always use AutoIt to put together a simple open-file, print-file, close-file script.

  5. #5
    altecsole's Avatar
    Join Date
    Jun 2005
    Location
    Morecambe, Lancashire, UK.
    Posts
    281
    Thank Post
    39
    Thanked 36 Times in 26 Posts
    Rep Power
    24
    I have a vbscript to do this. Just make sure the word files are in a folder then drag the folder onto the script to print. Make sure the default printer is set first though! Might want to try with a couple of documents first, just to be safe
    Attached Files Attached Files

  6. 7 Thanks to altecsole:

    abuxton678 (4th December 2012), Admiral208 (3rd February 2011), Griff (21st November 2012), LosOjos (4th February 2011), mac_shinobi (22nd June 2012), Valentine (20th March 2012), vikpaw (30th June 2011)

  7. #6

    Join Date
    Oct 2010
    Posts
    37
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    10
    This has been mentioned in another thread but I'm still struggling. I want to find a way of combining a group of .xml files (all in the same folder and now renamed sequentially - File001.xml, File002.xml etc.) into one file that can be analysed. Each .xml file contains a small table (3-5 rows with 8 columns). I used to open each one individually and cut and paste the data. OK for a small group but now my head of 6th form wants all the students in it (380). There was a bit of code for a macro in the previous thread but it lost me. Can anyone make any suggestions?

  8. #7
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,943
    Thank Post
    115
    Thanked 272 Times in 250 Posts
    Rep Power
    104
    That might have been one of my macros to paste pages together for printing? If so I can alter it slightly for you.

  9. Thanks to ChrisH from:

    Anjelica (3rd February 2011)

  10. #8

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,153
    Thank Post
    369
    Thanked 365 Times in 323 Posts
    Rep Power
    145
    I have the same problem here - if you rename the extensions to .doc they all seem to open fine and can print multiples without problems.

  11. #9
    altecsole's Avatar
    Join Date
    Jun 2005
    Location
    Morecambe, Lancashire, UK.
    Posts
    281
    Thank Post
    39
    Thanked 36 Times in 26 Posts
    Rep Power
    24
    Quote Originally Posted by Sylv3r View Post
    I have the same problem here - if you rename the extensions to .doc they all seem to open fine and can print multiples without problems.
    I don't know why I bother?

  12. #10

    Join Date
    Oct 2010
    Posts
    37
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    10
    Quote Originally Posted by ChrisH View Post
    That might have been one of my macros to paste pages together for printing? If so I can alter it slightly for you.
    Chris: That would be great if you could. Even if you could steer me in the right direction I would be eternally grateful. A virtual pint in the virtual pub would be waiting for you!!!

  13. #11
    Admiral208's Avatar
    Join Date
    Mar 2008
    Location
    Bridgwater
    Posts
    712
    Thank Post
    171
    Thanked 62 Times in 54 Posts
    Rep Power
    39
    ok, I have found another strange way round this problem.

    In Word, click open, navigate to the folder where the xml files are and select them all. Click on tools and then there is an option to print.

    Shown that by one of the women in the office who now thinks she knows more about computers than me!! damn her!!

  14. 2 Thanks to Admiral208:

    dhicks (25th June 2011), mac_shinobi (28th June 2013)

  15. #12
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,121
    Thank Post
    414
    Thanked 150 Times in 148 Posts
    Blog Entries
    3
    Rep Power
    60
    Another option which I've just tested on my machine here is going into the File Types, opening up DOC, copying all the settings for the Print option, Opening up XML, creating a New action and pasting all the Print settings from DOC into it, then it works how you want it.

    So in my case, the options for printing were set as:

    &Print
    "C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE" /x /n /dde
    [REM _DDE_Minimize][FileOpen("%1")][t=IsDocumentDirty()][FilePrint 0][SetDocumentDirty t][DocClose]
    WinWord
    [FileOpen("%1")][FilePrint 0][FileExit 2]
    System

    (Each new line is a seperate field on the window)

    Probably not supposed to do that, but it works

  16. #13

    Join Date
    Oct 2010
    Posts
    37
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    10
    Oh good grief. I feel like a fool now. Just spent the afternoon with my head of ICT trying to write a macro to merge my .xml files. We gave up. I got home and typed Merge Multiple Documents into Google and got this: Combine and Merge Multiple Documents in Microsoft Office Word 2007 My Digital Life It's so simple too. I couldn't merge all three hundred in one go but it can certainly manage 30 at a time on my laptop. Will try more with a more powerful PC at work.

  17. #14
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,943
    Thank Post
    115
    Thanked 272 Times in 250 Posts
    Rep Power
    104
    Sorry just had Ofsted in, so I have been a bit busy. Glad you got it sorted in the end.

  18. #15

    Join Date
    Mar 2009
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by altecsole View Post
    I have a vbscript to do this. Just make sure the word files are in a folder then drag the folder onto the script to print. Make sure the default printer is set first though! Might want to try with a couple of documents first, just to be safe
    This script worked but now whenever I try to open an XML file, Word prompts me with a list of options to convert the file! Any fix for this???

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [SIMS] Printing XML Files in Batch
    By mikeruddell2 in forum MIS Systems
    Replies: 11
    Last Post: 11th November 2010, 11:34 AM
  2. Replies: 4
    Last Post: 31st July 2009, 11:43 AM
  3. .XML Bulk conversion
    By Sylv3r in forum How do you do....it?
    Replies: 3
    Last Post: 2nd July 2009, 09:41 PM
  4. Help parsing XML files using VB
    By SimpleSi in forum Coding
    Replies: 5
    Last Post: 10th June 2009, 08:25 AM
  5. Search replace across multiple XML files
    By ajbritton in forum Windows
    Replies: 6
    Last Post: 6th April 2008, 11:07 PM

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
  •