+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Sims Assessment Manager Individual Reports in Technical; Does anyone know of way to convert the XML word documents created by export in SAM7 to a read only ...
  1. #1
    MACIT's Avatar
    Join Date
    Sep 2008
    Posts
    51
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Sims Assessment Manager Individual Reports

    Does anyone know of way to convert the XML word documents created by export in SAM7 to a read only format such as PDF.

    I have tried a couple of convertors with no success

    Any help appreciated.

  2. #2
    Ian_ICTDS's Avatar
    Join Date
    Jun 2009
    Location
    Warwickshire
    Posts
    70
    Thank Post
    11
    Thanked 15 Times in 12 Posts
    Rep Power
    13
    How about printing them using the XPS or Office document writer that most computers have pre-installed under printers. This would probably take a while though if you've got a lot of documents to print.

  3. #3
    MACIT's Avatar
    Join Date
    Sep 2008
    Posts
    51
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Hmm i considered this, I allready use various Printer type PDF convertors but i can t find a way a do it in batch (we are a school of 1750 students)

  4. #4

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,207
    Thank Post
    372
    Thanked 378 Times in 336 Posts
    Rep Power
    148
    I need something like this to convert a batch of .xml documents from SIMS profiles to .pdf / .doc.

    I've had a look about on the internet and nothing appears to do the job we want.

  5. #5
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Capita are currently looking at this issue so that reports can be saved to Pupil Records in PDF or similar format rather than the original Word doc.
    So watch this space .............

  6. #6
    MACIT's Avatar
    Join Date
    Sep 2008
    Posts
    51
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    I have found a way to do this.

    Using pdf995 (pdf 995: create PDF documents easily for free) The full version not the ad supported one

    You have to change the file extensions to .doc but it then works in batch mode!!!

    I am happy!!! at least until Capita give us the option to export as PDF which would, lets face it) be more sensible.

  7. #7

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    247
    Thank Post
    23
    Thanked 37 Times in 28 Posts
    Rep Power
    20
    The other way to do it would be to protect the file contents (I think word can do this) by a bit of vb after they've been created. Batch converting has got to be the easiest option though.

  8. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,974
    Thank Post
    674
    Thanked 1,384 Times in 1,146 Posts
    Rep Power
    350
    Quote Originally Posted by MACIT View Post
    I have found a way to do this.

    Using pdf995 (pdf 995: create PDF documents easily for free) The full version not the ad supported one

    You have to change the file extensions to .doc but it then works in batch mode!!!

    I am happy!!! at least until Capita give us the option to export as PDF which would, lets face it) be more sensible.

    I'm sure i managed to do this using the free version or maybe i found another tool. It was a long time ago. In fact i think i found lots of tools recommend here on EduGeek. pdf995 has this other program called omniformat with it doesn't it? I think that's still free.

    Also, try primopdf i think that had some bulk options. maybe it was only for a trial period.

    I'm not quite sure why you want a read only format apart from the size is smaller than the xml. We used to store our reports in a folder structure because we proof read and corrected them after export. Now we correct them in sims and use the document storage.

    I had a few scripts that would convert the files to .doc format. There weren't any available so i made my own but it was a pain. Much easier to do a bulk rename to .doc with a little vbscript, though it keeps the xml size.

    The other reason for having them as .doc is that you can bulk print them from a folder which you can't do with the .xml, though there is a tweak you can do to the registry so that print is an option on the right click context menu.

  9. #9
    soapyfish's Avatar
    Join Date
    Dec 2008
    Location
    Hertfordshire
    Posts
    180
    Thank Post
    49
    Thanked 7 Times in 5 Posts
    Blog Entries
    1
    Rep Power
    13
    Does anyone Know if Capita ever introduced this feature ?

  10. #10

    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
    I have a VBS script that will convert them to DOC, also there's one for printing on batch (created by another EduGeek member - can't remember who!)

    You could use the printing one to do the job, just set BullZip (or some other PDF printer) as default and run them off any batch that way

    here's the one to convert to DOC:

    Code:
    '==========================================================================
    '
    ' NAME: Word XML to DOC.vbs
    '
    ' AUTHOR: Josh Johnson
    ' DATE  : 04/02/2011
    '
    ' COMMENT: Convert SIMS XML files in to XLS files
    ' HOW TO USE: Drag a folder containing the XML files onto the script.
    '==========================================================================
    Option Explicit
    On Error Resume Next
    
    Dim Arg 			'Script argument
    Dim FSO			'File System Object
    Dim oFol			'Folder object
    Dim oFil			'File object
    Dim oFils		'Files
    Dim myWord		'Word object
    Dim myDoc		'Document object
    Dim filePath	'Path to file (need for Word to open the file)
    
    'Check arguments
    If WScript.Arguments.Length < 1 Then
    	MsgBox "Drag a folder containing Word XML files onto this script", vbOKOnly, "Error!"
    	WScript.Quit
    End If 
    
    Set FSO = CreateObject("Scripting.FileSystemObject")
    Arg = WScript.Arguments(0)
    If FSO.FolderExists(Arg) = False Then
       MsgBox "Drag and drop a folder onto this script to print the contents."
       Set FSO = Nothing
       WScript.Quit
    End If
    
    Set myWord = CreateObject("Word.Application")
    myWord.Visible = True
    myWord.Application.DisplayAlerts = False
    
    'Get folder informaton
    Set oFol = FSO.GetFolder(Arg)
    
    Set oFils = oFol.Files
       For Each oFil in oFils  '-- enumerate files in the folder using For/Each. Each oFil is a File object.
    	filePath = oFil
    	Set myDoc = myWord.Documents.Open(filePath, True, True, False, , , False, , , 8, , True)
    	myDoc.SaveAs oFol.Path & "\" & left(FSO.GetFileName(oFil), Len(FSO.GetFileName(oFil))-4) & ".doc", 0
    	myDoc.Close
    	oFil.Delete
    	If Err <> 0 Then MsgBox "Error converting " & FSO.GetFileName(oFil) & vbNewLine & Err.Description, vbOKOnly, "Error"
    	Err.Clear
    	Set myDoc = Nothing
       Next 
    myWord.Application.Quit
    Set myWord = Nothing
    Set oFils = Nothing
    Set oFol = Nothing
    MsgBox "Complete!", vbOKOnly, "Converting done"
    
    
    Function strClean (strtoclean)
    Dim objRegExp, outputStr
    Set objRegExp = New Regexp
    
    objRegExp.IgnoreCase = True
    objRegExp.Global = True
    objRegExp.Pattern = "[(?*"",\\<>&#~%{}+_.@:\/!;]+"
    outputStr = objRegExp.Replace(strtoclean, "-")
    
    objRegExp.Pattern = "\-+"
    outputStr = objRegExp.Replace(outputStr, "-")
    
    strClean = outputStr
    End Function
    and the script to print:
    Code:
    '==========================================================================
    '
    ' NAME: WordXMLPrint.vbs
    '
    ' AUTHOR: Jim Williams
    ' DATE  : 30/04/2007
    '
    ' COMMENT: Batch prints Word XML files.
    ' HOW TO USE: Drag a folder containing the XML files onto the script.
    '==========================================================================
    Option Explicit
    
    Dim Arg 			'Script argument
    Dim FSO			'File System Object
    Dim oFol			'Folder object
    Dim oFil			'File object
    Dim oFils		'Files
    Dim myWord		'Word object
    Dim filePath	'Path to file (need for Word to open the file)
    
    'Check arguments
    If WScript.Arguments.Length < 1 Then
    	MsgBox "Drag a folder containing Word XML files onto this script", vbOKOnly, "Error!"
    	WScript.Quit
    End If 
    
    Set FSO = CreateObject("Scripting.FileSystemObject")
    Arg = WScript.Arguments(0)
    If FSO.FolderExists(Arg) = False Then
       MsgBox "Drag and drop a folder onto this script to print the contents."
       Set FSO = Nothing
       WScript.Quit
    End If
    
    Set myWord = CreateObject("Word.Application")
    myWord.Visible = True
    
    'Get folder informaton
    Set oFol = FSO.GetFolder(Arg)
    
    Set oFils = oFol.Files
       For Each oFil in oFils  '-- enumerate files in the folder using For/Each. Each oFil is a File object.
          filePath = oFil
          myWord.Documents.Open filePath, True, True, False, , , False, , , 8, , True
          myWord.PrintOut False
          myWord.Documents.Close False
       Next 
    myWord.Application.Quit False
    Set myWord = Nothing
    Set oFils = Nothing
    Set oFol = Nothing
    MsgBox "Complete!", vbOKOnly, "Printing done"
    EDIT:
    to use either of those scripts, copy & paste the code in to a blank text file and save it as whatever you want with the .vbs extension, then drag the folder containing your SIMS XML documents on to the script to run it on the files in that folder
    Last edited by LosOjos; 8th June 2011 at 12:13 PM.

  11. 2 Thanks to LosOjos:

    simpsonj (10th June 2011), tobyhacker (9th June 2011)

  12. #11
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Quote Originally Posted by soapyfish View Post
    Does anyone Know if Capita ever introduced this feature ?
    Yes - for SLG.
    You can noiw publish AM7 and Profiles Reports to SLG via .pdf!
    Not sure how you can get at them directly via SIMS though, even if you can!
    I guess they must be stored somewhare!

  13. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,974
    Thank Post
    674
    Thanked 1,384 Times in 1,146 Posts
    Rep Power
    350
    Quote Originally Posted by LosOjos View Post
    I have a VBS script that will convert them to DOC, also there's one for printing on batch (created by another EduGeek member - can't remember who!)

    You could use the printing one to do the job, just set BullZip (or some other PDF printer) as default and run them off any batch that way
    I think this is the original reference: Print XML files in bulk

    I've posted a minor amendment to line 44 in that thread, in case anyone has issues with word asking for a conversion format after the script has been used.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Data Graphs in AM7 Individual Reports - SIMS
    By Sivadam in forum MIS Systems
    Replies: 4
    Last Post: 8th March 2011, 08:53 PM
  2. Example Assessment Reports in SIMS
    By garethedmondson in forum MIS Systems
    Replies: 5
    Last Post: 7th November 2009, 11:47 AM
  3. Sims Assessment Manager Reports
    By MACIT in forum MIS Systems
    Replies: 6
    Last Post: 16th April 2009, 02:07 PM
  4. Individual reports for students in SIMS
    By cjohnsonuk in forum MIS Systems
    Replies: 2
    Last Post: 25th March 2008, 11:27 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
  •