Solved

Missing Tag <?xml version="1.0" encoding="ISO-8859-1" ?> in my XML output file

Posted on 2009-07-16
4
1,627 Views
Last Modified: 2012-05-07
Hi,
On my web page, a button generates an XML file (on click) whose data comes from SQL server. This XML file output is to be used as an import file to a legacy system. XML file is generated without dramas but the problem is that the tag <?xml version="1.0" encoding="ISO-8859-1" ?> is not included on the top of the XMl file, this tag is needed by the recievning application.

I'm practically out of clue as to where or what i missed. Can anyone help me understand and suggest a fix on my problem?

Here is the event on my webpage. And on the snippet is my XSL template...


    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Using conn As New Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("CENTRIS_SMIConnectionString").ConnectionString)
            Dim cmd As New Data.SqlClient.SqlCommand("SMI_P001_XML_Download", conn)
            cmd.CommandType = Data.CommandType.StoredProcedure
            conn.Open()
            'Add parameters (NationalUPN) selected from form for WHERE clause
            cmd.Parameters.Add("@NationalUPN", Data.SqlDbType.VarChar)
            cmd.Parameters("@NationalUPN").Value = DropDownList2.SelectedValue.ToString

            'Add parameters (AcademicYear) selected from form for WHERE clause
            cmd.Parameters.Add("@AcademicYear", Data.SqlDbType.Int)
            cmd.Parameters("@AcademicYear").Value = DropDownList3.SelectedValue.ToString

            'Add parameters (SchoolDestination) selected from form for WHERE clause
            cmd.Parameters.Add("@SchoolDest", Data.SqlDbType.Int)
            cmd.Parameters("@SchoolDest").Value = DropDownList1.SelectedValue.ToString

            Dim da As New Data.SqlClient.SqlDataAdapter(cmd)
            Dim ds As New Data.DataSet
            da.Fill(ds)
            Dim nowString As String = Now.ToString("dd-MM-yyyy hh.mm.ss")
            Dim fileName As String = "D:\TEMP\000LLL_CTF_SMI_" & nowString & ".xml"
            'Dim fileName As String = "C:\Documents and Settings\jackson.suanque.NTSCHOOLS\Desktop\MySMIStudentTrackerExport_" & nowString & ".xml"
            ds.WriteXml(fileName)
            Dim doc As System.Xml.XmlDataDocument = New System.Xml.XmlDataDocument(ds)
            Dim transform As New System.Xml.Xsl.XslCompiledTransform()
            transform.Load("D:\Inetpub\wwwroot\WebSite2\SMI_Tracker_Download2.xsl")
            'transform.Load(Server.MapPath("SMI_Tracker_Download1.xsl"))
            Dim writer As System.Xml.XmlTextWriter = New System.Xml.XmlTextWriter(fileName, System.Text.Encoding.UTF8)
            writer.Formatting = System.Xml.Formatting.Indented
            writer.Indentation = 2
            transform.Transform(doc, Nothing, writer)
        End Using
    End Sub


<?xml version="1.0" standalone="yes" ?> 
- <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
  <xsl:output method="xml" indent="yes" encoding="ISO-8859-1" omit-xml-declaration="no" /> 
- <xsl:template match="/">
- <CTfile>
  <xsl:call-template name="callHeader" /> 
  <xsl:call-template name="callCTFpupilData" /> 
  </CTfile>
  </xsl:template>
- <xsl:template name="callHeader">
- <Header>
- <DocumentName>
  <xsl:value-of select="/NewDataSet/Table/DocumentName" /> 
  </DocumentName>
- <CTFversion>
  <xsl:value-of select="/NewDataSet/Table/CTFversion" /> 
  </CTFversion>
- <DateTime>
  <xsl:value-of select="/NewDataSet/Table/DateTime" /> 
  </DateTime>
- <DocumentQualifier>
  <xsl:value-of select="/NewDataSet/Table/DocumentQualifier" /> 
  </DocumentQualifier>
- <SupplierID>
  <xsl:value-of select="/NewDataSet/Table/SupplierID" /> 
  </SupplierID>
  <xsl:call-template name="callSourceSchool" /> 
  <xsl:call-template name="callDestSchool" /> 
  </Header>
  </xsl:template>
- <xsl:template name="callSourceSchool">
- <SourceSchool>
- <LEA>
  <xsl:value-of select="/NewDataSet/Table/SchoolSourceLEACode" /> 
  </LEA>
- <Estab>
  <xsl:value-of select="/NewDataSet/Table/SourceSchoolEstablishmentCode" /> 
  </Estab>
- <SchoolName>
  <xsl:value-of select="/NewDataSet/Table/SchoolName" /> 
  </SchoolName>
- <AcademicYear>
  <xsl:value-of select="/NewDataSet/Table/AcademicYear" /> 
  </AcademicYear>
  </SourceSchool>
  </xsl:template>
- <xsl:template name="callDestSchool">
- <DestSchool>
- <LEA>
  <xsl:value-of select="/NewDataSet/Table/DestLEA" /> 
  </LEA>
- <Estab>
  <xsl:value-of select="/NewDataSet/Table/DestEstab" /> 
  </Estab>
  </DestSchool>
  </xsl:template>
- <xsl:template name="callCTFpupilData">
- <CTFpupilData>
  <xsl:call-template name="callPupil" /> 
  </CTFpupilData>
  </xsl:template>
- <xsl:template name="callPupil">
- <Pupil>
- <UPN>
  <xsl:value-of select="/NewDataSet/Table/NationalUPN" /> 
  </UPN>
- <Surname>
  <xsl:value-of select="/NewDataSet/Table/LegalSurname" /> 
  </Surname>
- <ForeName>
  <xsl:value-of select="/NewDataSet/Table/Firstname" /> 
  </ForeName>
- <DOB>
  <xsl:value-of select="/NewDataSet/Table/DOB" /> 
  </DOB>
- <Gender>
  <xsl:value-of select="/NewDataSet/Table/Sex" /> 
  </Gender>
  <xsl:call-template name="callBasicDetails" /> 
  <xsl:call-template name="callAddress" /> 
  </Pupil>
  </xsl:template>
- <xsl:template name="callBasicDetails">
- <BasicDetails>
- <FormerUPN>
  <xsl:value-of select="/NewDataSet/Table/PreviousNationalUPN" /> 
  </FormerUPN>
- <PreferredSurname>
  <xsl:value-of select="/NewDataSet/Table/Surname" /> 
  </PreferredSurname>
- <PreferredForename>
  <xsl:value-of select="/NewDataSet/Table/OtherNames" /> 
  </PreferredForename>
- <NCYearActual>
  <xsl:value-of select="/NewDataSet/Table/NCYearActual" /> 
  </NCYearActual>
- <Ethnicity>
  <xsl:value-of select="/NewDataSet/Table/Ethnicity" /> 
  </Ethnicity>
- <EthnicitySource>
  <xsl:value-of select="/NewDataSet/Table/EthnicitySource" /> 
  </EthnicitySource>
  <xsl:call-template name="callLanguages" /> 
- <FSMEligible>
  <xsl:value-of select="/NewDataSet/Table/FSMeligible" /> 
  </FSMEligible>
- <MedicalFlag>
  <xsl:value-of select="/NewDataSet/Table/MedicalFlagQualifier" /> 
  </MedicalFlag>
- <EnrolStatus>
  <xsl:value-of select="/NewDataSet/Table/EnrolStatus" /> 
  </EnrolStatus>
- <Statemented>
  <xsl:value-of select="/NewDataSet/Table/SENStatemented" /> 
  </Statemented>
  </BasicDetails>
  </xsl:template>
- <xsl:template name="callLanguages">
- <Languages>
- <Type>
- <LanguageQualifier>
  <xsl:value-of select="/NewDataSet/Table/LanguageQualifier" /> 
  </LanguageQualifier>
- <Language>
  <xsl:value-of select="/NewDataSet/Table/Language" /> 
  </Language>
  </Type>
  </Languages>
  </xsl:template>
- <xsl:template name="callAddress">
- <Address>
- <AddressLines>
- <Line1>
  <xsl:value-of select="/NewDataSet/Table/AddressLine1" /> 
  </Line1>
- <Line2>
  <xsl:value-of select="/NewDataSet/Table/AddressLine2" /> 
  </Line2>
- <Line3>
  <xsl:value-of select="/NewDataSet/Table/AddressLine3" /> 
  </Line3>
- <Line4>
  <xsl:value-of select="/NewDataSet/Table/Town" /> 
  </Line4>
- <Line5>
  <xsl:value-of select="/NewDataSet/Table/County" /> 
  </Line5>
- <Postcode>
  <xsl:value-of select="/NewDataSet/Table/PostCode" /> 
  </Postcode>
  </AddressLines>
  </Address>
  </xsl:template>
  </xsl:stylesheet>

Open in new window

0
Comment
Question by:jsuanque
  • 3
4 Comments
 
LVL 3

Accepted Solution

by:
DelTreme earned 250 total points
ID: 24869655
In this line:

Dim writer As System.Xml.XmlTextWriter = New System.Xml.XmlTextWriter(fileName, System.Text.Encoding.UTF8)

You create a TextWriter using the UTF8 encoding. Try this one instead:

Dim writer As System.Xml.XmlTextWriter = New System.Xml.XmlTextWriter(fileName, System.Text.Encoding.GetEncoding(1252))

That should at least output the data in Latin-1 (ISO-8859-1).
0
 

Author Comment

by:jsuanque
ID: 24874405
Hello DelTreme,

Tried your suggestion but that doesn't work.
0
 

Author Comment

by:jsuanque
ID: 24947225
Found it. I just added ...
            writer.WriteStartDocument()
in the code and Voila.
0
 

Author Closing Comment

by:jsuanque
ID: 31604220
Thanks though it didn't fix my problem immediately but it certainly did guide me where to look for the issue.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Initial get page response times and IIS8 15 51
Disable extension 8 38
cannot connect to sqlserver 8 30
Convert Select to DropDownListFor MVC 5 2 17
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question