Wayne29
asked on
XSLT.TransForm method in C# :
Hi All,
My application takes in "Word 2003 XML" file name as an INPUT parameter and tries to APPLY XSLT file on this word 2003 document(xml) file and to extract the DATA ONLY entered by the user and puts into a file called as "out.xml".
The below is the code snippet.
The last statement in the code snippet is not working fine.
Can any body correct this and let me know.
'Transform the Document / XML file into PURE XML DATA ONLY FILE
''Create a new XslTransform object.
Dim xslt As New XslTransform
''''Load the stylesheet.
xslt.Load(CType("c:\inetpu
''''Create a new XPathDocument and load the XML data to be transformed.
Dim mydata As New XPathDocument("sample.xml"
Dim resolver As XmlUrlResolver = New XmlUrlResolver
resolver.Credentials = System.Net.CredentialCache
''''Transform the data and send the output to the console.
xslt.Transform(SaveLocatio
My application takes in "Word 2003 XML" file name as an INPUT parameter and tries to APPLY XSLT file on this word 2003 document(xml) file and to extract the DATA ONLY entered by the user and puts into a file called as "out.xml".
The below is the code snippet.
The last statement in the code snippet is not working fine.
Can any body correct this and let me know.
'Transform the Document / XML file into PURE XML DATA ONLY FILE
''Create a new XslTransform object.
Dim xslt As New XslTransform
''''Load the stylesheet.
xslt.Load(CType("c:\inetpu
''''Create a new XPathDocument and load the XML data to be transformed.
Dim mydata As New XPathDocument("sample.xml"
Dim resolver As XmlUrlResolver = New XmlUrlResolver
resolver.Credentials = System.Net.CredentialCache
''''Transform the data and send the output to the console.
xslt.Transform(SaveLocatio
Carl Tawn
Can you expand a little on "Not working fine" ?
ASKER
Thanks Carl for your timely reponse.
"Not working fine", in the sense, the "out.xml" is coming EMPTY only with the ROOT TAG.
So for the timebeing I have used the below code to get "out.xml" only with the data.
But I do not want the below code to be in place as it is an additional overhead of loading Word Instance.
I would be very happy if my earlier approach (above) works!
So Basically what I am doing is, "Saving the file (doc/xml) which the user has given to me, by Applying XSLT"
to get PURE XML (data only). With this pure xml file, I am putting the values back to database. So next time he generates my template, he sees the latest values .....
Dim wordApp As Word.ApplicationClass
Dim wordDoc As Word.DocumentClass
Try
wordApp = New Word.ApplicationClass
wordDoc = New Word.DocumentClass
wordApp.Visible = True
wordDoc = wordApp.Documents.Open(tem
' x.Documents.Open(FileName:
', ReadOnly:=False, AddToRecentFiles:=False, PasswordDocument:="", _
'PasswordTemplate:="", Revert:=False, WritePasswordDocument:="",
'WritePasswordTemplate:=""
wordDoc.Activate()
With wordApp.ActiveDocument
.XMLSaveDataOnly = False
.XMLUseXSLTWhenSaving = True
.XMLSaveThroughXSLT = _
"C:\inetpub\wwwroot\Assess
.XMLHideNamespaces = False
.XMLShowAdvancedErrors = True
.XMLSchemaReferences.HideV
.XMLSchemaReferences.Autom
.XMLSchemaReferences.Ignor
.XMLSchemaReferences.Allow
.XMLSchemaReferences.ShowP
End With
wordApp.ActiveDocument.Sav
LockComments:=False, Password:="", AddToRecentFiles:=True, _
WritePassword:="", ReadOnlyRecommended:=False
SaveNativePictureFormat:=F
False)
wordDoc.Close()
wordApp.Quit()
wordApp = Nothing
wordDoc = Nothing
Catch ex As Exception
Throw New Exception(ex.Message.ToStr
Finally
wordApp = Nothing
wordDoc = Nothing
End Try
"Not working fine", in the sense, the "out.xml" is coming EMPTY only with the ROOT TAG.
So for the timebeing I have used the below code to get "out.xml" only with the data.
But I do not want the below code to be in place as it is an additional overhead of loading Word Instance.
I would be very happy if my earlier approach (above) works!
So Basically what I am doing is, "Saving the file (doc/xml) which the user has given to me, by Applying XSLT"
to get PURE XML (data only). With this pure xml file, I am putting the values back to database. So next time he generates my template, he sees the latest values .....
Dim wordApp As Word.ApplicationClass
Dim wordDoc As Word.DocumentClass
Try
wordApp = New Word.ApplicationClass
wordDoc = New Word.DocumentClass
wordApp.Visible = True
wordDoc = wordApp.Documents.Open(tem
' x.Documents.Open(FileName:
', ReadOnly:=False, AddToRecentFiles:=False, PasswordDocument:="", _
'PasswordTemplate:="", Revert:=False, WritePasswordDocument:="",
'WritePasswordTemplate:=""
wordDoc.Activate()
With wordApp.ActiveDocument
.XMLSaveDataOnly = False
.XMLUseXSLTWhenSaving = True
.XMLSaveThroughXSLT = _
"C:\inetpub\wwwroot\Assess
.XMLHideNamespaces = False
.XMLShowAdvancedErrors = True
.XMLSchemaReferences.HideV
.XMLSchemaReferences.Autom
.XMLSchemaReferences.Ignor
.XMLSchemaReferences.Allow
.XMLSchemaReferences.ShowP
End With
wordApp.ActiveDocument.Sav
LockComments:=False, Password:="", AddToRecentFiles:=True, _
WritePassword:="", ReadOnlyRecommended:=False
SaveNativePictureFormat:=F
False)
wordDoc.Close()
wordApp.Quit()
wordApp = Nothing
wordDoc = Nothing
Catch ex As Exception
Throw New Exception(ex.Message.ToStr
Finally
wordApp = Nothing
wordDoc = Nothing
End Try
Can you post the starting section of the XML ? Its possibly a namespace issue in your document.
ASKER
The below is the starting section of the XML file (word 2003 document saved as XML file)
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><?mso-ap
<w:wordDocument xmlns:w="http://schemas.microsoft.com/office/word/2003/wordml" xmlns:v="urn:schemas-micro
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><?mso-ap
<w:wordDocument xmlns:w="http://schemas.microsoft.com/office/word/2003/wordml" xmlns:v="urn:schemas-micro
And have you catered for all the required namespaces in your XSL ?
ASKER
I think you are about to catch it.
Please find below the complete XSLT file which extracts "DATA ONLY" for a given XML/DOC of Word 2003.
But I am not sure which namespace to be changed to meet my requirements.
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0"
exclude-result-prefixes="w
xmlns:w="http://schemas.microsoft.com/office/word/2003/wordml"
xmlns:v="urn:schemas-micro
xmlns:w10="urn:schemas-mic
xmlns:sl="http://schemas.microsoft.com/schemaLibrary/2003/core"
xmlns:aml="http://schemas.microsoft.com/aml/2001/core"
xmlns:wx="http://schemas.microsoft.com/office/word/2003/auxHint"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:o="urn:schemas-micro
xmlns:dt="uuid:C2F41010-65
xmlns:st1="urn:schemas-mic
<xsl:output encoding="utf-8"/>
<!-- root template -->
<xsl:template match="/">
<Assessment>
<xsl:apply-templates select="w:wordDocument/w:b
</Assessment>
</xsl:template>
<!-- outside of root XML element -->
<xsl:template match="w:* | v:* | w10:* | sl:* | aml:* | wx:* | o:* | dt:* | st1:* | *[@w:st='on']">
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="*">
<xsl:copy>
<xsl:copy-of select="@*"/>
<xsl:apply-templates mode="arbitraryXML"/>
</xsl:copy>
</xsl:template>
<xsl:template match="text()"/>
<!-- inside root XML element -->
<xsl:template match="w:* | v:* | w10:* | sl:* | aml:* | wx:* | o:* | dt:* | st1:* | *[@w:st='on']" mode="arbitraryXML">
<xsl:apply-templates mode="arbitraryXML"/>
</xsl:template>
<xsl:template match="*" mode="arbitraryXML">
<xsl:copy>
<xsl:copy-of select="@*"/>
<xsl:apply-templates mode="arbitraryXML"/>
</xsl:copy>
</xsl:template>
<xsl:template match="text()" mode="arbitraryXML"/>
<xsl:template match="w:t" mode="arbitraryXML">
<xsl:value-of select="."/>
</xsl:template>
</xsl:stylesheet>
Please find below the complete XSLT file which extracts "DATA ONLY" for a given XML/DOC of Word 2003.
But I am not sure which namespace to be changed to meet my requirements.
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0"
exclude-result-prefixes="w
xmlns:w="http://schemas.microsoft.com/office/word/2003/wordml"
xmlns:v="urn:schemas-micro
xmlns:w10="urn:schemas-mic
xmlns:sl="http://schemas.microsoft.com/schemaLibrary/2003/core"
xmlns:aml="http://schemas.microsoft.com/aml/2001/core"
xmlns:wx="http://schemas.microsoft.com/office/word/2003/auxHint"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:o="urn:schemas-micro
xmlns:dt="uuid:C2F41010-65
xmlns:st1="urn:schemas-mic
<xsl:output encoding="utf-8"/>
<!-- root template -->
<xsl:template match="/">
<Assessment>
<xsl:apply-templates select="w:wordDocument/w:b
</Assessment>
</xsl:template>
<!-- outside of root XML element -->
<xsl:template match="w:* | v:* | w10:* | sl:* | aml:* | wx:* | o:* | dt:* | st1:* | *[@w:st='on']">
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="*">
<xsl:copy>
<xsl:copy-of select="@*"/>
<xsl:apply-templates mode="arbitraryXML"/>
</xsl:copy>
</xsl:template>
<xsl:template match="text()"/>
<!-- inside root XML element -->
<xsl:template match="w:* | v:* | w10:* | sl:* | aml:* | wx:* | o:* | dt:* | st1:* | *[@w:st='on']" mode="arbitraryXML">
<xsl:apply-templates mode="arbitraryXML"/>
</xsl:template>
<xsl:template match="*" mode="arbitraryXML">
<xsl:copy>
<xsl:copy-of select="@*"/>
<xsl:apply-templates mode="arbitraryXML"/>
</xsl:copy>
</xsl:template>
<xsl:template match="text()" mode="arbitraryXML"/>
<xsl:template match="w:t" mode="arbitraryXML">
<xsl:value-of select="."/>
</xsl:template>
</xsl:stylesheet>
Do you have a more complete XML doc I could test against ?
ASKER
Please find below the complete Word ML file of my document.
Thanks for your efforts.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><?mso-ap
AAMATQByAHMABABNAGkAcwBzAA
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
AAAAAAD//wMAAAAHAE0AYQByAH
ZAA=
</w:fldData></w:fldChar></
AA==
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
AAAA//8CAAAAAwBZAGUAcwACAE
</w:fldData></w:fldChar></
Thanks for your efforts.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><?mso-ap
AAMATQByAHMABABNAGkAcwBzAA
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
AAAAAAD//wMAAAAHAE0AYQByAH
ZAA=
</w:fldData></w:fldChar></
AA==
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
</w:fldData></w:fldChar></
AAAA//8CAAAAAwBZAGUAcwACAE
</w:fldData></w:fldChar></
It works ok for me.
The only thing I changed in your code was to replace "SaveLocation" with the path to the source XML file. I'm not sure what "SaveLocation" refers to in your code, so maybe this is the cause of the problem.
The only thing I changed in your code was to replace "SaveLocation" with the path to the source XML file. I'm not sure what "SaveLocation" refers to in your code, so maybe this is the cause of the problem.
ASKER
Please find the entire code snippet of calling the same.
User has uploaded a file and i have saved it into SERVER in a predefined folder whose path is in "SaveLocation" variable.
Private Sub btnUpload_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpload.Click
REM Upload File
REM Update Database
Dim blUpdate As Boolean
Dim SaveLocation As String
Dim objXSLT As New XslTransform
Dim dSet As New DataSet
Dim i, j As Integer
Try
If Not File1.PostedFile Is Nothing And File1.PostedFile.ContentLe
Dim fn As String = System.IO.Path.GetFileName
SaveLocation = Server.MapPath("Templates"
Try
File1.PostedFile.SaveAs(Sa
Response.Write("The file has been uploaded.")
Catch Exc As Exception
Response.Write("Error: " & Exc.Message)
End Try
Else
Response.Write("Please select a file to upload.")
End If
'Transform the Document / XML file into PURE XML DATA ONLY FILE
''Create a new XslTransform object.
Dim xslt As New XslTransform
''''Load the stylesheet.
xslt.Load(CType("c:\inetpu
''''Create a new XPathDocument and load the XML data to be transformed.
Dim mydata As New XPathDocument(SaveLocation
Dim resolver As XmlUrlResolver = New XmlUrlResolver
resolver.Credentials = System.Net.CredentialCache
''''Transform the data and send the output to the console.
xslt.Transform(SaveLocatio
'Read this XML and put data into dataset
'SaveAsDataOnly(SaveLocati
'dSet.ReadXml("c:\inetpub\
'UpdateAssessmentDetails(d
'Response.Redirect("Assess
Catch ex As Exception
Throw New Exception(ex.Message.ToStr
End Try
End Sub
User has uploaded a file and i have saved it into SERVER in a predefined folder whose path is in "SaveLocation" variable.
Private Sub btnUpload_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpload.Click
REM Upload File
REM Update Database
Dim blUpdate As Boolean
Dim SaveLocation As String
Dim objXSLT As New XslTransform
Dim dSet As New DataSet
Dim i, j As Integer
Try
If Not File1.PostedFile Is Nothing And File1.PostedFile.ContentLe
Dim fn As String = System.IO.Path.GetFileName
SaveLocation = Server.MapPath("Templates"
Try
File1.PostedFile.SaveAs(Sa
Response.Write("The file has been uploaded.")
Catch Exc As Exception
Response.Write("Error: " & Exc.Message)
End Try
Else
Response.Write("Please select a file to upload.")
End If
'Transform the Document / XML file into PURE XML DATA ONLY FILE
''Create a new XslTransform object.
Dim xslt As New XslTransform
''''Load the stylesheet.
xslt.Load(CType("c:\inetpu
''''Create a new XPathDocument and load the XML data to be transformed.
Dim mydata As New XPathDocument(SaveLocation
Dim resolver As XmlUrlResolver = New XmlUrlResolver
resolver.Credentials = System.Net.CredentialCache
''''Transform the data and send the output to the console.
xslt.Transform(SaveLocatio
'Read this XML and put data into dataset
'SaveAsDataOnly(SaveLocati
'dSet.ReadXml("c:\inetpub\
'UpdateAssessmentDetails(d
'Response.Redirect("Assess
Catch ex As Exception
Throw New Exception(ex.Message.ToStr
End Try
End Sub
Have you stepped through with the debugger to check that the Xml and Xsl loaded ok ? The actual transform itself appears to be ok in my sample app.
ASKER
the out.xml is coming up with Root Tag so I don't think XSLT is not applied properly.
During debug all is fine.
My only worry is somehow XSLT file is not able to read through the rest of the NODES/MARKUPS in the template IN THIS APPROACH.
may be I need to carry on this issue.
During debug all is fine.
My only worry is somehow XSLT file is not able to read through the rest of the NODES/MARKUPS in the template IN THIS APPROACH.
may be I need to carry on this issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.