|
it looks very simple if you are working in dot net. Open the connection with Excel file. and load the data in Dataset. and once you are in dataset you can save the XML file using Dataset.SaveXML(Path)
Rizwan Bashir
|
|
|
|
|
Hi - Is this a way to go about.
We have a text file with all data there is. I was able to convert this to text file using "XmlCsvReader Class". Now, I have to group this information, since it lists out all information as single xml records. There is some common information which needs to be grouped like all products for one common product_code needs to be as one record and not 3 records in XML file. How would I compare this information, more like compare nodes?
Is comparing this information in XML format fast or it is better to copy the text data into datatable, compare and then create XML document?
Thanks!
|
|
|
|
|
I have just started to learne about XML and need to write some software to help managed the exchange of data between different complaines.
I am unsure what to use for processing XML, i.e. Visual Basic 6 or using Visual Studio .Net and perhaps an MFC C++ application.
Any advice please and a site of a good example. I am quite happy with either.
|
|
|
|
|
What do you mean by processing? If you are looking for endpoints for different companies to send stuff to, then you might be better looking at webservices and an asp.net application...
|
|
|
|
|
hi,
i'm a newbie with XML and i need some help with my problem.
here it goes.. i'm trying to validate an xml document against an xml schema using the code below.. however, when in debug mode, i'm getting this error message (>> "object reference not set to an instance of an object" when i run thru this part of the code [>> while (vr.Read()); ]..
what am i missing here.. pls help... 
thanks in advance...
lupin
here's the code:
public bool ValidateMapData(string strXMLDoc, string urlPath)
// (e.g. urlPath = "C:\MyXML\myschema.xsd")
{
bool isValidXml = true;
try
{
XmlSchemaCollection sc = new XmlSchemaCollection();
sc.ValidationEventHandler += new ValidationEventHandler(ValidationFailed);
sc.Add(null, urlPath);
if(sc.Count > 0)
{
StringReader sr = new StringReader(strXMLDoc);
XmlTextReader tr = new XmlTextReader(sr);
XmlValidatingReader vr = new XmlValidatingReader(tr);
vr.ValidationType = ValidationType.Schema;
vr.Schemas.Add(sc);
vr.ValidationEventHandler += new ValidationEventHandler(ValidationFailed);
while (vr.Read());
vr.Close();
if (errorCount > 0)
{
throw new Exception(errorMessage);
}
}
}
catch(Exception e)
{
myLog.Error(this, e.Message);
isValidXml = false;
}
return isValidXml;
}
public void ValidationFailed(object sender, ValidationEventArgs e)
{
myLog.Error(this, e.Message);
errorCount ++;
}
|
|
|
|
|
I'm not sure off hand what's happening in your code, but I have an example that's worked for me. strXMLDoc should be the full XML text, and urlPath should be the path to your schema, which I believe is what your example was expecting. Try this...
private System.Collections.Specialized.StringCollection errors =
new System.Collections.Specialized.StringCollection();
private System.Collections.Specialized.StringCollection warns =
new System.Collections.Specialized.StringCollection();
public bool ValidateMapData(string strXMLDoc, string urlPath) {
errors.Clear();
warns.Clear();
System.Xml.XmlTextReader tr = new System.Xml.XmlTextReader(new System.IO.StringReader(strXMLDoc));
System.Xml.XmlValidatingReader vr = new System.Xml.XmlValidatingReader(tr);
try {
vr.Schemas.Add(System.Xml.Schema.XmlSchema.Read(new System.IO.StringReader(urlPath),
new System.Xml.Schema.ValidationEventHandler(MessageHandler)));
vr.ValidationType = System.Xml.ValidationType.Schema;
} catch (Exception ex) {
while (ex != null) {
errors.Add(ex.Message);
ex = ex.InnerException;
}
}
try {
while(vr.Read());
} catch (Exception ex) {
while (ex != null) {
errors.Add(ex.Message);
ex = ex.InnerException;
}
}
string msgs = string.Empty;
foreach (string s in errors) {
msgs += "\r\nError: " + s;
}
foreach (string s in warns) {
msgs += "\r\nWarning: " + s;
}
if (errors.Count > 0) {
msgs = "Errors validating..." + msgs;
MessageBox.Show(this, msgs, "Schema validation", MessageBoxButtons.OK, MessageBoxIcon.Error);
} else if (warns.Count > 0) {
msgs = "Warnings validating..." + msgs;
MessageBox.Show(this, msgs, "Schema validation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
} else {
return true;
}
return false;
}
private void MessageHandler(object sender, System.Xml.Schema.ValidationEventArgs args) {
if (args.Severity == System.Xml.Schema.XmlSeverityType.Error) {
errors.Add(args.Message);
} else {
warns.Add(args.Message);
}
}
Visit BoneSoft.com
|
|
|
|
|
I'm using C# in VS2005 to do some XPath queries. I've created my XPath statement using XMLSpy and it is something like:
//Unit/concat(productCode, ":", serialNumber)
I also tried with string-join, but I get the same error when I try it in my C# code:
Unhandled Exception: System.Xml.XPath.XPathException: '//Unit/concat(productCode,":",serialNumber)' has an invalid token.
Surely the concat function exists in the .net xpath library, am I doing something wrong?
The code around this is the standard routine:
<br />
xpathDoc = new XPathDocument(Filename);<br />
xpathNav = xpathDoc.CreateNavigator();<br />
xpathIter = xpathNav.Select(XPathString);<br />
- loop through the results etc -<br />
I hope someone has some pointers as to what could be wrong
Thanks
|
|
|
|
|
Hi I create a XML File In Memory But I have problem
Using XMLDoc.Load(M) to load that file that i have created
How Can i SuccessfulLy Load Back as i need to convert the XMlFile to string
Need Helps
Thanks A Million
KaKaShi HaTaKe
-- modified at 23:15 Thursday 15th June, 2006
|
|
|
|
|
Hi I have a problem of creating a XML file in the Memory Stream
Cos after i created it i will need to retreive it and convert it back to string
Dim m As New MemoryStream
Dim XmlDoc As New XmlDocument
Dim XmlNL As XmlNode
Dim yo As String
Dim textWriter As XmlTextWriter = New XmlTextWriter(m, System.Text.Encoding.UTF8)
textWriter.WriteStartDocument()
textWriter.WriteStartElement("ns0", "HCNET_ACK_Root", "http://HoHOHo.PCNET.IB.Schema.ExternalSchema.PCNET_ACK")
textWriter.WriteStartElement("BVN")
textWriter.WriteStartElement("SendingPerson", "")
textWriter.WriteString("Terry")
textWriter.WriteEndElement()
textWriter.WriteEndElement()
textWriter.Close()
XmlDoc.Load(m) The Problem Occur Here and The Error Stated
The root element is missing. at System.Xml.XmlTextReader.Read()
Pls Help
Really need help
Thanks A Million
KaKaShi HaTaKe
-- modified at 22:26 Thursday 15th June, 2006
|
|
|
|
|
There are a few things there... You're not closing all your elements, or starting or closing the document. And for reasons I don't understand, XmlDoc.Load(stream) doesn't work, but if you use a StreamReader to read it and output that to a string, XmlDoc with LoadXml() fine. Also, before reading you have to set the stream's Position to 0. Sorry, my answer's in C#, but it should be difficult to convert to VB...
MemoryStream m = new MemoryStream();
XmlDocument XmlDoc = new XmlDocument();
System.Xml.XmlTextReader reader = new XmlTextReader(m);
XmlTextWriter textWriter = new XmlTextWriter(m, System.Text.Encoding.UTF8);
textWriter.WriteStartDocument(true);
textWriter.WriteStartElement("ns0", "HCNET_ACK_Root", "http://HoHOHo.PCNET.IB.Schema.ExternalSchema.PCNET_ACK");
textWriter.WriteStartElement("BVN");
textWriter.WriteStartElement("SendingPerson", "");
textWriter.WriteString("Terry");
textWriter.WriteEndElement();
textWriter.WriteEndElement();
textWriter.WriteEndElement();
textWriter.WriteEndDocument();
textWriter.Flush();
m.Position = 0;
System.IO.StreamReader sreader = new StreamReader(m);
string xml = sreader.ReadToEnd();
textWriter.Close();
reader.Close();
XmlDoc.LoadXml(xml);
Visit BoneSoft.com
|
|
|
|
|
Hi all,
I have a xml file like this,
<RepositorySearch>
<Fields>
<ID>1</ID>
<SearchName>search name 1</SearchName>
<DocumentName>doc name 1</DocumentName>
<DocumentDescription>f</DocumentDescription>
<DocumentType></DocumentType>
</Fields>
<Fields>
<ID>2</ID>
<SearchName>search name 2</SearchName>
<DocumentName>doc name 2</DocumentName>
<DocumentDescription>descrip 2</DocumentDescription>
<DocumentType></DocumentType>
</Fields>
</RepositorySearch>
in this above, i have to check wether my input string is equal to any of the value of SearchName tag if they match ....I have to extract the below document name and documentDescription values....
urgent help plz guide me....
Thanks a million in advance..
|
|
|
|
|
What technology you need to use?
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it! 
|
|
|
|
|
XPath Query may work for you...
Brandon
|
|
|
|
|
I was wondering how to just get XSL to spit out every thing in an XML file regardless of the element its in?
At the moment, from what i have read, I use a command like so to read XML elements:
<xsl:value-of select="somthing"/>
<xsl:value-of select="somthingElse"/>
<xsl:value-of select="blah"/>
But say I had an XML file with a load of different elements and i just want the XSL to just blast them all to the page how do i tell it to write out any and every element the loop runs into?
so if i had a totaly chaotic XML file like:
<blah>
<ooii>hooble <noodle>poo</noodle> zoot <ooii>
<ibo></ibo>
<chibo>1</chibo>
<chibo>145<phoon>ixiy</phoon>ttr</chibo>
</blah>
the xsl would just read all those bizzaro tags without me having to name them indervidualy?
Thanks.
|
|
|
|
|
|
Hi,
How can i remove a table if the date it contains is older than 30 days from an xml file using xsl?
This is how the xml file looks like:
<root>
<table>
<id> 0 </id>
<date> 20060404 </date>
</table>
<table>
<id> 1 </id>
<date> 20060822 </date>
</table>
<table>
<id> 2 </id>
<date> 20060904 </date>
</table>
</root>
Thanks in advance!
|
|
|
|
|
If you are using xsl to construct a new xml file, you can chewck in the xsl value of the field
(date), and if it is less than the special one (declare that as a const), move to the next one.
Sorry, I do not remember the exact syntax, but you do have conditions and loops available in xsl
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it!
|
|
|
|
|
The xsl file i wanna make should be a stand alone one.
The other xml file is made by another program.
I never worked with xsl. Do you know where i can find some samples codes bout this?
|
|
|
|
|
Read here [^].
I am sure, there are a lot of others as well, but I w3schools are great for beginners (to my mind)
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it!
|
|
|
|
|
Hello all.
Im trying to validate a single XML file using two schemas in .NET. I cannot change the format of the XML file, which looks something like this:
<br />
<?xml version="1.0" encoding="ISO-8859-1"?><br />
<aaa><br />
<bbb>some text</bbb><br />
<ccc>more elements....</ccc><br />
<InterChangeHead xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="ich.xsd"><br />
<Version>1</Version><br />
<SenderID>xxx</SenderID><br />
<ddd>and so on..</ddd><br />
</InterChangeHead><br />
</aaa>
As you see the <InterChangeHead> refears to 'ich.xsd', this file contains the schema to validate <InterChangeHead> and its children. But i need to control the entire file. I've made a schema file that controls <aaa> and its child elements, but should this file contain a check for InterChangeHead?
In .NET i use the XMLSchemaSet, should i Add the two schemas here? Or will 'ich.xsd' automagically be loaded for me?
I've also tried to make one big schema file which controls everything, but then i get an error on the <InterChangeHead> element, because of the xmlns thingy...
Hope this makes sense to somebody 
Thanks
Arve.
|
|
|
|
|
Through trial and error i think i've almost solved this problem. But i still need some help.
This is my example xml file, which cannot be edited:
<br />
<?xml version="1.0" encoding="UTF-8"?><br />
<aaa><br />
<bbb>Text</bbb><br />
<ccc>123</ccc><br />
<ddd xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="xyz"><br />
<eee>text2</eee><br />
<ccc>text3</ccc><br />
</ddd><br />
</aaa><br />
I've made two schemas, first 'aaa_schema.xsd':
<br />
<?xml version="1.0" encoding="UTF-8"?><br />
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="unqualified" attributeFormDefault="unqualified"><br />
<xs:element name="aaa"><br />
<xs:complexType><br />
<xs:sequence><br />
<xs:element name="bbb" type="xs:string" /><br />
<xs:element name="ccc" type="xs:int" /><br />
<xs:any/><br />
</xs:sequence><br />
</xs:complexType><br />
</xs:element><br />
</xs:schema><br />
and 'ddd_schema.xsd':
<br />
<?xml version="1.0" encoding="UTF-8"?><br />
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="unqualified" attributeFormDefault="unqualified" xmlns="xyz" targetNamespace="xyz"><br />
<xs:element name="ddd" ><br />
<xs:complexType ><br />
<xs:sequence ><br />
<xs:element name="eee" type="xs:string" /><br />
<xs:element name="ccc" type="xs:string" /><br />
</xs:sequence><br />
</xs:complexType><br />
</xs:element><br />
</xs:schema><br />
What i've done is add a xs:any to the aaa_schema where the ddd element should be.
In the .NET code i've added this:
<br />
Dim arrSchema As XmlSchemaSet = New XmlSchemaSet()<br />
arrSchema.Add(Nothing, New XmlTextReader("C:\temp\aaa_schema.xsd"))<br />
arrSchema.Add("xyz", New XmlTextReader("C:\temp\ddd_schema.xsd"))<br />
But when i try to validate the file i get this message:
"The element 'ddd' in namespace 'xyz' has invalid child element 'eee' in namespace 'xyz'. List of possible elements expected: 'eee'."
What does this mean? I thought the scope of the xyz namespace in the ddd_schema file covered all the child elements, not just the ddd element?
If i edit eee and ccc in the XML file like this:
<br />
<eee xmlns="" >text2</eee><br />
<ccc xmlns="" >text3</ccc><br />
Then everything work, but in the real scenario can't change the XML file.
Anyone?
-- modified at 2:46 Friday 16th June, 2006
|
|
|
|
|
Hi All,
I am working on VC++ (exe dialog application).. I have loaded the xml file using DOM i;e using a pointer of IXMLDOMDocument and calling the load function of it. Can I know if there are any built-in function or any other alternatives to find the size of the DOM ,before and after loading the xml file??
|
|
|
|
|
Is there any algorithms or sample code for finding the difference between two xml files.
Aswathi
|
|
|
|
|
Hi there
am having an application which takes data in XML format from webserver (SQL) and imports to offline software. the second part of the same is taking XML file data and copy it to SQL database in webserver, here am able to upload the XML file to webserver, do anyone knows how to write this XML data to SQL Server using classic ASP, due to certain issues i cudn't use ASP.NET.
regards
rowdykuttan
|
|
|
|
|
we are have to upload xml file(given by client:which consists of tally data) into sqlserver.there we are facing a problem with MasterXmlfile that has structre::
UNIT NAME="Mth" RESERVEDNAME="Mth"
NAME Mth NAME
ORIGINALSYMBOL Months ORIGINALSYMBOL
ISSIMPLEUNIT Yes ISSIMPLEUNIT
FORPAYROLL Yes FORPAYROLL
UNIT(Table)
unit is a Table and Name is attribute.... now problem is we are having to two name attribute In Unit Table...and it showing error like this "A column named 'NAME already belongs to this DataTable cannot set a nested table name to the same name" hoe to over come this "with out changing xml file"
by using C#
My code as fallows:
public partial class Testxml : System.Web.UI.Page
{
protected string table_name;
protected string column_name;
protected string cmd_string;
protected string AccessConnect;
protected string query_str;
protected int field_count;
protected DataSet data_set;
protected DataSet data_setxml;
protected DataTable data_table;
protected DataRow data_row;
protected DataRow data_row1;
protected DataColumn data_column;
protected SqlConnection Conn_one;
protected SqlCommand cmd_one;
protected SqlDataReader my_red;
protected SqlCommandBuilder data_cmb;
protected SqlDataAdapter data_adp;
protected int st_int;
protected int col_int;
protected void Page_Load(object sender, EventArgs e)
{
data_table = new DataTable();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (AccessConnect != "")
{
AccessConnect = "Persist Security Info=False;User ID=sa;Password=nunetme;Initial Catalog=sat;Data Source=NUNETSERVER3";
}
Conn_one =new SqlConnection();
cmd_one = new SqlCommand();
data_set = new DataSet();
data_setxml = new DataSet();
//data_table = new DataTable();
Conn_one.ConnectionString=AccessConnect;
string strFileName="";
//strFileName =FileUpload1.FileName + ".xml";
strFileName = FileUpload1.FileName;
//strFileName = (DateTime.Now.ToShortDateString() + DateTime.Now.ToShortTimeString()).Replace("/", "").Replace(":", "").Replace(" ", "") + ".xml";
System.Object objvalue;
//Prepare file name with full path using upload directory
objvalue = System.Configuration.ConfigurationSettings.AppSettings["uploadpath"].ToString() + strFileName;
try
{
Conn_one.Open();
cmd_one.Connection = Conn_one;
data_setxml.ReadXml(objvalue.ToString());
//data_setxml.ReadXml(HttpContext.Current.Server.MapPath(objvalue.ToString()));
//data_setxml.ReadXml(HttpContext.Current.Server.MapPath(TextBox1.Text.Trim()));
foreach(System.Data.DataTable data_table in data_setxml.Tables)
{
switch (data_table.TableName.ToString())
{
case "HEADER":case "BODY":case "IMPORTDATA": case "REQUESTDESC": case "STATICVARIABLES":case "REQUESTDATA" :case "TALLYMESSAGE":
{
break;
}
//break;
case "CATEGORYALLOCATIONS.LIST":case "COSTCENTREALLOCATIONS.LIST":case "CATEGORY":case "DETAILGST.LIST":case "DETAILGST":case "HEADERGST.LIST": case "HEADERGST":case "TAXCLASSIFICATION":
{
break;
}
default:
{
//Case "CATEGORYALLOCATIONS.LIST", "COSTCENTREALLOCATIONS.LIST", "CATEGORY", "DETAILGST.LIST", "DETAILGST", "HEADERGST.LIST", "HEADERGST"
System.Text.StringBuilder dest;
dest = new StringBuilder(data_table.TableName);
dest = dest.Replace(".", "_");
table_name = dest.ToString();
// Deleting the old record updated in Temp. Tables
query_str = "Delete From " + table_name;
cmd_one = new SqlCommand(query_str);
cmd_one.Connection = Conn_one;
cmd_one.ExecuteNonQuery();
query_str = "Select * From " + table_name;
data_adp = new SqlDataAdapter(query_str, Conn_one);
data_cmb = new SqlCommandBuilder(data_adp);
data_adp.Fill(data_set, table_name);
foreach (DataRow data_row1 in data_table.Rows)
{
data_row = data_set.Tables[table_name].NewRow();
foreach (DataColumn data_column in data_table.Columns)
{
//If Column Name has "." character changed to "_" since Column name can't have "."
//and DESC reserved word the changes to be done
column_name = data_column.ColumnName;
if (data_column.ColumnName == "DESC")
{
column_name = "DESC1";
}
else
{
System.Text.StringBuilder dest1;
dest1 = new StringBuilder(data_column.ColumnName);
dest1.Replace(".", "_");
column_name = dest1.ToString();
//column_name=Replace(data_column.ColumnName,".","_");
data_row[column_name] = data_row1[data_column];
}
}
// data_set.Tables(table_name).Rows.Add(data_row)
//data_adp.Update(data_set, table_name)
data_set.Tables[table_name].Rows.Add(data_row);
data_adp.Update(data_set, table_name);
}
//Response.Write("Xml File Has Inserted Successfully");
break;
}
}
}
}
catch(Exception ex)
{
Response.Write("There is some exception please help me::" + ex.Message);
Response.Write(data_table.TableName);
Response.Write(column_name);
}
finally
{
Conn_one.Close();
}
}
}
Kindly help in this situation ....Thanks in advance.....
G.V.KISHORE
SOFTWARE ENGINEER
NUNET TECHNOLOGIES
-- modified at 10:05 Tuesday 13th June, 2006
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
