tben2505 Posted November 7, 2011 Posted November 7, 2011 Hi folks, As most of you will be aware, the Individual Reports facility export the Word document reports as XML files. Whilst I appreciate this is for efficiency reasons, many of our staff find it confusing and some machines are not set up properly to open them with the correct software (and we have many Macs, too). So I was wondering if anyone knew of any software to convert them straight to Word dox or even PDFs; just so that the staff can double click on them and not be presented with XML code which scares them and makes them thing everything is broken! Cheers, Tom
LosOjos Posted November 7, 2011 Posted November 7, 2011 Copy and paste this script in to Notepad, save it with a .vbs extension, then simply drag the folder containing all the SIMS generated XML documents on to it (make sure ONLY the XML documents are in the folder): '========================================================================== ' ' 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 EDIT: should probably explain what it does! The script will open each XML document in word and resave it as a DOC, then remove the original XML. I created it for compatibility issues much like you're having where staff aren't aware they need to open the XML in Word to view it properly. 2
tben2505 Posted November 7, 2011 Author Posted November 7, 2011 Copy and paste this script in to Notepad, save it with a .vbs extension, then simply drag the folder containing all the SIMS generated XML documents on to it (make sure ONLY the XML documents are in the folder): '========================================================================== ' ' 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 EDIT: should probably explain what it does! The script will open each XML document in word and resave it as a DOC, then remove the original XML. I created it for compatibility issues much like you're having where staff aren't aware they need to open the XML in Word to view it properly. WOW! You genius!!! Thank you SO much :)
tben2505 Posted November 7, 2011 Author Posted November 7, 2011 Do you have on for XML > XLS, too? And once converted to XLS; do they still go back into SIMS ok?? Cheers T
LosOjos Posted November 7, 2011 Posted November 7, 2011 Do you have on for XML > XLS, too? Indeed I do: '========================================================================== ' ' NAME: Excel XML to XLS.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 myExcel 'Excel object Dim myWorkbook 'Workbook object Dim filePath 'Path to file (need for Excel to open the file) 'Check arguments If WScript.Arguments.Length < 1 Then MsgBox "Drag a folder containing Excel 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 myExcel = CreateObject("Excel.Application") myExcel.Visible = True myExcel.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 myWorkbook = myExcel.Workbooks.Open(filePath) myWorkbook.SaveAs oFol.Path & "\" & left(FSO.GetFileName(oFil), Len(FSO.GetFileName(oFil))-4) & ".xls", 56 myWorkbook.Close oFil.Delete If Err <> 0 Then MsgBox "Error converting " & FSO.GetFileName(oFil) & vbNewLine & Err.Description, vbOKOnly, "Error" Err.Clear Set myWorkbook = Nothing Next myExcel.Application.Quit Set myExcel = 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 That one works exactly the same as the previous And once converted to XLS; do they still go back into SIMS ok?? Not as simply as the XML, as the XML stores additional data to allow SIMS to fully automate the re-import process, however you can still import it, it just requires you to manually identify the aspect and result set for each column (I'm afraid that's a limitation of XLS that can't be avoided)
tben2505 Posted November 7, 2011 Author Posted November 7, 2011 Splendid my friend: thanks again you're a real help! Tom
LosOjos Posted November 7, 2011 Posted November 7, 2011 Splendid my friend: thanks again you're a real help! Tom Any time
tben2505 Posted November 8, 2011 Author Posted November 8, 2011 Copy and paste this script in to Notepad, save it with a .vbs extension, then simply drag the folder containing all the SIMS generated XML documents on to it (make sure ONLY the XML documents are in the folder): '========================================================================== ' ' 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 EDIT: should probably explain what it does! The script will open each XML document in word and resave it as a DOC, then remove the original XML. I created it for compatibility issues much like you're having where staff aren't aware they need to open the XML in Word to view it properly. LosOjos, I don't suppose I could be particularly fussy and ask for this script to process the files not in alphabetical order, but in Date Modified Order (earliest to latest) or just in the order that they are in the folder to begin with? It's just, I export the XML files for the year group sorted by reg group, so they come out in that order, therefore processing them in that order to convert to Word then allows me to convert to one single Word/PDF file still in reg group order! Just if it's possible, otherwise I can just export separate batches by reg group
vikpaw Posted November 15, 2011 Posted November 15, 2011 I tried to make a script to sort the contents once but it was too complex, the vbs commands didn't seem capable of managing it easily.If it doesn't process in the order you have it setup, then it's probably easier just to do it in batches.
LosOjos Posted November 15, 2011 Posted November 15, 2011 (edited) LosOjos, I don't suppose I could be particularly fussy and ask for this script to process the files not in alphabetical order, but in Date Modified Order (earliest to latest) or just in the order that they are in the folder to begin with? Sorry about the epic delay in replying to you, but I've just not had time to look at it until now. I believe this will do the trick: '========================================================================== ' ' NAME: Word XML to DOC [by Date].vbs ' ' AUTHOR: Josh Johnson ' DATE : 04/02/2011 ' ' COMMENT: Convert SIMS XML files in to XLS files [date sorted] ' HOW TO USE: Drag a folder containing the XML files onto the script. '========================================================================== Option Explicit On Error Resume Next Const adDate = 7 Const adVarChar = 200 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) Dim rsFolder 'recordset to sort folder '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 rsFolder = CreateObject("ADODB.Recordset") 'Get folder informaton Set oFol = FSO.GetFolder(Arg) With rsFolder.Fields .Append "Path", adVarChar, 200 .Append "Name", adVarChar, 200 .Append "DateLastModified", adDate End With rsFolder.Open() Set oFils = oFol.Files For Each oFil in oFils rsFolder.AddNew rsFolder("Path") = oFil rsFolder("Name") = oFil.Name rsFolder("DateLastModified") = oFil.DateLastModified Next rsFolder.Sort = "DateLastModified ASC" Set myWord = CreateObject("Word.Application") myWord.Visible = True myWord.Application.DisplayAlerts = False rsFolder.MoveFirst() While Not rsFolder.EOF Set myDoc = myWord.Documents.Open(rsFolder("Path").Value, True, True, False, , , False, , , 8, , True) myDoc.SaveAs Left(rsFolder("Path").Value, Len(rsFolder("Path").Value)-4) & ".doc", 0 myDoc.Close FSO.DeleteFile rsFolder("Path").Value If Err <> 0 Then MsgBox "Error converting " & rsFolder("Name").Value & vbNewLine & Err.Description, vbOKOnly, "Error" Err.Clear Set myDoc = Nothing rsFolder.MoveNext() Wend 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 EDIT: Just updated the code, there was a major error in it! Edited November 15, 2011 by LosOjos 1
vikpaw Posted November 16, 2011 Posted November 16, 2011 Nice one @losojos - that was one of the methods i'd seen, but didn't get round to making it work properly.
HanLouTay Posted January 26, 2012 Posted January 26, 2012 Sorry about the epic delay in replying to you, but I've just not had time to look at it until now. I believe this will do the trick: '========================================================================== ' ' NAME: Word XML to DOC [by Date].vbs ' ' AUTHOR: Josh Johnson ' DATE : 04/02/2011 ' ' COMMENT: Convert SIMS XML files in to XLS files [date sorted] ' HOW TO USE: Drag a folder containing the XML files onto the script. '========================================================================== Option Explicit On Error Resume Next Const adDate = 7 Const adVarChar = 200 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) Dim rsFolder 'recordset to sort folder '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 rsFolder = CreateObject("ADODB.Recordset") 'Get folder informaton Set oFol = FSO.GetFolder(Arg) With rsFolder.Fields .Append "Path", adVarChar, 200 .Append "Name", adVarChar, 200 .Append "DateLastModified", adDate End With rsFolder.Open() Set oFils = oFol.Files For Each oFil in oFils rsFolder.AddNew rsFolder("Path") = oFil rsFolder("Name") = oFil.Name rsFolder("DateLastModified") = oFil.DateLastModified Next rsFolder.Sort = "DateLastModified ASC" Set myWord = CreateObject("Word.Application") myWord.Visible = True myWord.Application.DisplayAlerts = False rsFolder.MoveFirst() While Not rsFolder.EOF Set myDoc = myWord.Documents.Open(rsFolder("Path").Value, True, True, False, , , False, , , 8, , True) myDoc.SaveAs Left(rsFolder("Path").Value, Len(rsFolder("Path").Value)-4) & ".doc", 0 myDoc.Close FSO.DeleteFile rsFolder("Path").Value If Err <> 0 Then MsgBox "Error converting " & rsFolder("Name").Value & vbNewLine & Err.Description, vbOKOnly, "Error" Err.Clear Set myDoc = Nothing rsFolder.MoveNext() Wend 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 EDIT: Just updated the code, there was a major error in it! Hey, I have done as suggested but when I open my saved VBS file it opens up Spybot S&D File Scanner! I presume this is an issue with my computer rather than the script. Any suggestions?
LosOjos Posted January 26, 2012 Posted January 26, 2012 Hey, I have done as suggested but when I open my saved VBS file it opens up Spybot S&D File Scanner! I presume this is an issue with my computer rather than the script. Any suggestions? I'm afraid I don't have a clue! It could be that you have SpyBot's Resident TeaTimer feature enabled and this is blocking the script because it is trying to access your file system (don't worry, it only accesses files in the folder you drag on to the script in order to open and convert them as necessary). Try temporarily disabling TeaTimer before running the script. Another possibility is that you've accidentally associated .VBS files with SpyBot so it's trying to open the script rather than Windows running it. Try my first solution and if you still have a problem, let me know which version of Windows your running and I'll dig out the instructions to check file associations for you.
HanLouTay Posted January 26, 2012 Posted January 26, 2012 Thanks for the speedy reply! I'm on a school network so I don't want to/can't go about fiddling with settings! I've been using notepad ++ to paste the script in to. I tried normal notepad but it didn't give differing file types (ie VBS) to save to. Maybe this is where I am going wrong?! thanks
LosOjos Posted January 26, 2012 Posted January 26, 2012 Thanks for the speedy reply! I'm on a school network so I don't want to/can't go about fiddling with settings! I've been using notepad ++ to paste the script in to. I tried normal notepad but it didn't give differing file types (ie VBS) to save to. Maybe this is where I am going wrong?! thanks Possibly; it definitely needs a .VBS extension to work. Can you see the file extension when you view it in Explorer? If so, check that it is .VBS and simply change it if not (VBS are just plain text files really, but the VBS extension tells Windows to run the contents as a script). It may also be that your Network Manager has disabled script running for users - it might be worth having a word with them
vikpaw Posted January 28, 2012 Posted January 28, 2012 @HanLouTay - Using notepad++ should be fine, i use that all the time, and you can do a saveas vbs file type. Also, it will colour the code to make it easier to understand and edit. I think as @LosOjos said, it's most likely being blocked by spybot / the teatimer - monitors registry access mostly, but could be triggered generally as it's an unsafe file type. You should be able to mark it as safe or put it on the ignore list if you have access to the settings. Sometimes the location of the file makes a difference, try running it from your desktop and if not, then the C drive, sometimes running it from the network can give odd results.
tben2505 Posted March 13, 2012 Author Posted March 13, 2012 Any time Mr genius!! May I call on your powers again!!? I wonder if you could make this script do the opposite, turning XLS to XML!!? Forever grateful! T
LosOjos Posted March 13, 2012 Posted March 13, 2012 Mr genius!! May I call on your powers again!!? I wonder if you could make this script do the opposite, turning XLS to XML!!? Forever grateful! T It's theoretically possible to write a script that would convert this back to XML, but may I ask what you're hoping to achieve? The reason I ask, is that there's very little I can think of that you can do with the XML file once you have it...
tben2505 Posted March 13, 2012 Author Posted March 13, 2012 Owing to staff using macs, and file association issues which I frustratingly can't seem to get resolved, the XML files are not opening by default in Excel on macs. If I can convert them to XLS, they will, by default, open in Excel. Then, if I can covert them back to XML, I can bath import them (you can't batch import XLS). I know this is a rather laborious workaround - but some staff are really getting confused!! Only if this is possible of course! Cheers, Tom
vikpaw Posted March 14, 2012 Posted March 14, 2012 I would have thought that a proper conversion back to XML would be really arduous, but a simple rename might be sufficient. You can import from spreadsheets but you'd have to manually match the columns. I'm pretty sure that you can just rename the xls to xml. I think i used to just copy and paste the data back into an original xml file if it ever went awry.
tben2505 Posted March 14, 2012 Author Posted March 14, 2012 I would have thought that a proper conversion back to XML would be really arduous, but a simple rename might be sufficient. You can import from spreadsheets but you'd have to manually match the columns. I'm pretty sure that you can just rename the xls to xml. I think i used to just copy and paste the data back into an original xml file if it ever went awry. Renaming them, although at first appears successful, returns the following error message after trying to import: Assessment Manager Marksheets Import Date : 14/03/2012 08:45:23 File Name G and T Register10s.xml Invalid file File Name G and T Register11s.xml Invalid file File Name G and T Register12s.xml Invalid file File Name G and T Register13s.xml Invalid file File Name G and T Register14s.xml Invalid file File Name G and T Register15s.xml Invalid file File Name G and T Register8s.xml Invalid file File Name G and T Register9s.xml Invalid file
vikpaw Posted March 14, 2012 Posted March 14, 2012 @tben2505 what if you do a file save as to xml does that help any, because that is all the simple version of the script would be doing anyway.
LosOjos Posted March 14, 2012 Posted March 14, 2012 @tben2505 what if you do a file save as to xml does that help any, because that is all the simple version of the script would be doing anyway. You can't do that @vikpaw - each row and column has to be mapped to XML headings in order to save as XML from Excel; it's never that easy! It is theoretically possible to write a script that will convert an XLS back to SIMS format XML, however it's a different story creating sheets that would import automatically back in to SIMS - you'd end up having to match the columns anyway. The problem is that in each "formatted" marksheet (has to be formatted type for the fully automatic import) there are a couple of hidden rows inside the XML which contain aspect and result set ID's - it is these hidden fields that tell SIMS how to import the data back in. Without them, you're left having to match them up manually. Unfortunately, the initial conversion to XLS results in the loss of that data, meaning any conversion back to XML would still fail. Sorry about that!
vikpaw Posted March 14, 2012 Posted March 14, 2012 That's what I thought. So it's manual import. Unless you can get a macro / script to copy paste the data into an equally named .xml file.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now