Solved

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

Posted on 2009-07-16
4
1,629 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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

808 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