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 ...
1st February 2011, 04:47 PM #1
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.
IDG Tech News
1st February 2011, 04:56 PM #2
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
1st February 2011, 05:04 PM #3
here is one of the file that I have removed anything that will id anyone or thing.
2nd February 2011, 12:27 AM #4
You can always use AutoIt to put together a simple open-file, print-file, close-file script.
Originally Posted by Admiral208
2nd February 2011, 02:44 PM #5
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
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)
2nd February 2011, 07:14 PM #6
- Rep Power
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?
2nd February 2011, 08:03 PM #7
That might have been one of my macros to paste pages together for printing? If so I can alter it slightly for you.
Thanks to ChrisH from:
Anjelica (3rd February 2011)
2nd February 2011, 08:32 PM #8
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.
3rd February 2011, 11:28 AM #9
I don't know why I bother?
Originally Posted by Sylv3r
3rd February 2011, 11:46 AM #10
- Rep Power
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!!!
Originally Posted by ChrisH
3rd February 2011, 12:01 PM #11
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!!
2 Thanks to Admiral208:
dhicks (25th June 2011), mac_shinobi (28th June 2013)
3rd February 2011, 12:50 PM #12
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:
"C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE" /x /n /dde
[REM _DDE_Minimize][FileOpen("%1")][t=IsDocumentDirty()][FilePrint 0][SetDocumentDirty t][DocClose]
[FileOpen("%1")][FilePrint 0][FileExit 2]
(Each new line is a seperate field on the window)
Probably not supposed to do that, but it works
4th February 2011, 05:32 PM #13
- Rep Power
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.
4th February 2011, 05:36 PM #14
Sorry just had Ofsted in, so I have been a bit busy. Glad you got it sorted in the end.
26th May 2011, 04:58 PM #15
- Rep Power
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???
Originally Posted by altecsole
By mikeruddell2 in forum MIS Systems
Last Post: 11th November 2010, 12:34 PM
By reggiep in forum Windows
Last Post: 31st July 2009, 12:43 PM
By Sylv3r in forum How do you do....it?
Last Post: 2nd July 2009, 10:41 PM
By SimpleSi in forum Coding
Last Post: 10th June 2009, 09:25 AM
By ajbritton in forum Windows
Last Post: 7th April 2008, 12:07 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)