|
Would you please suggest me taht how to process large .csv files(more than 1000 lines) FASTER, so that it can be processed faster by XML Processor to convert into xml files.
But it works with small file(less than 1000 lines). But incase of large .csv files it gives following Memory Managament Error.
"Your system is low on virtual memory.Windows is increasing the size of the virtual memory paginf file...."
Please solve my problem with the code in C#.NET
With Regards
Tapan
|
|
|
|
|
hi every buddy!
well I'm trying to display the XML data (sample given below ) in a table using XSL and as i've highlighted in the XML the results node is the one giving me trouble. I'm trying to do this in XSL as:
<tr class="nonSelectedRow">
<pre><xsl:for-each select="*[node() and node()!='Results']"></pre>
<th><xsl:value-of select="name()"/></th>
</xsl:for-each>
</tr>
-------------------------------------------
The problem is that I wanna display the data in two seperate tables such as
<pre>----------------------------------------
inputs |
----------------------------------------
property | phase | basis | calc | Value |
----------------------------------------</pre>
and...........
<pre>
----------------------------------------------------
inputs | Outputs |
----------------------------------------------------
property | phase | basis | calc | Compound |Value |
----------------------------------------------------</pre>
The XML part is given here:
--------------------------------
<code>
<CallSequence>
<Call>
<ObjectType>Material Object</ObjectType>
<ObjectName>Mix out</ObjectName>
<Interface>ICapeThermoMaterialObject</Interface>
<Method>SetProp</Method>
<Arguments>
<Property>Volume</Property>
<Phase>Overall</Phase>
<Basis>Mole</Basis>
<Calc>Mixture</Calc>
<pre> <Results>
<Value>0.000018075</Value>
</Results></pre>
</Arguments>
<ReturnCode>No Error</ReturnCode>
</Call>
<Call>
<ObjectType>Material Object</ObjectType>
<ObjectName>Mix out</ObjectName>
<Interface>ICapeThermoMaterialObject</Interface>
<Method>GetProp</Method>
<Arguments>
<Property>Fraction</Property>
<Phase>Overall</Phase>
<Basis>mole</Basis>
<Calc>null</Calc>
<pre> <Results>
<Compound>
<Name>Hydrogen</Name>
<Value>0.355979900</Value>
</Compound>
<Compound>
<Name>Methane</Name>
<Value>0.018735784</Value>
</Compound>
<Compound>
<Name>Benzene</Name>
<Value>0.401813320</Value>
</Compound>
<Compound>
<Name>Toluene</Name>
<Value>0.223470992</Value>
</Compound>
<Compound>
<Name>BiPhenyl</Name>
<Value>0.000000005</Value>
</Compound>
</Results></pre>
</Arguments>
<ReturnCode>No Error</ReturnCode>
</Call>
</CallSequence>
</code>
Can anyone tell me how to display the data in this format using the way I'm trying to do in XSL. Coz I wanna make it as general as possible. I dont wanna be specific so that it can cater the changes in the future.
Thanks in advance!!!
Rocky
You can't climb up a <i>steep</i> ladder with your hands in your pockets.
|
|
|
|
|
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<head>
<title>Call Sequence</title>
</head>
<body>
<xsl:apply-templates select="CallSequence/Call/Arguments"/>
</body>
</html>
</xsl:template>
<xsl:template match="Arguments">
<table>
<tr>
<xsl:apply-templates select="*[name() != 'Results'] | Results/child::node()[1] | Results/child::node()[1] / child::node()[2]"/>
</tr>
</table>
</xsl:template>
<xsl:template match="*">
<th><xsl:value-of select="name()"/></th>
</xsl:template>
</xsl:stylesheet>
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
Thanks u so much George, that worked for me, actually I modified it and used only this part
*[name() != 'Results'] | Results/child::node()[1] | Results/child::node()[1] / child::node()[2]
just for the confirmation i wanna ask you that '[2]' selects two child nodes right??
and by the way can u tell me the name of some really good book on XML/XSL?
Thanks again... you Rock
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
The XPath 'Results/child::node()[1]/child::node()[2]' selects the second child 'child::node()[2]' of the first child 'child::node()[1]' of the element 'Results'. The '[2]' actually means 'position() = 2'. You can kind of think of '[2]' as an array index, where the base is 1.
I have learned XSLT from the first edition of this book:
XSLT Programmer's Reference, Second Edition
by Michael Kay
Wrox Press © 2001 (938 pages)
ISBN:0764543814
There is also a third edition the covers XSLT 2.0:
XSLT 2.0 Programmer's Reference, Third Edition
by Michael Kay
Wrox Press © 2004 (955 pages)
They have a tutorial/reference type structure which makes them useful for some time.
I also found the following useful also:
XSLT Cookbook, Second Edition
by Sal Mangamo
O'Reilly Media,Inc. © 2006 (751 pages)
ISBN: 0-596-00974-7
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
Thanks very much u know I really appreciate this. I'll try and get hold of these books!
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
Alternative:
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<head>
<title>Call Sequence</title>
</head>
<body>
<xsl:apply-templates select="CallSequence/Call/Arguments"/>
</body>
</html>
</xsl:template>
<xsl:template match="Arguments">
<table>
<tr>
<xsl:apply-templates select="*"/>
</tr>
</table>
</xsl:template>
<xsl:template match="*">
<th><xsl:value-of select="name()"/></th>
</xsl:template>
<xsl:template match="Results">
<xsl:apply-templates select="*[1] | *[1]/Value"/>
</xsl:template>
</xsl:stylesheet>
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
Hi,
i'd would like to add that line <?xml-stylesheet type=\"text/xsl\" href=\"{0}\"?>
to my xml file using the xmlDocument-Class but i don't know how? Atm i use the following code
using (XmlWriter writer = XmlWriter.Create(FullFilePath, settings))
{
writer.WriteRaw(string.Format("<?xml-stylesheet type=\"text/xsl\" href=\"{0}\"?>", Globals.StylesheetXSL));
writer.WriteStartElement("root");
writer.WriteEndElement();
writer.Flush();
writer.Close();
}
-- modified at 10:49 Thursday 30th August, 2007
|
|
|
|
|
error1408 wrote: using the xmlDocument-Class
error1408 wrote: using (XmlWriter writer = XmlWriter.Create(FullFilePath, settings))
XmlWriter is NOT XmlDocument. I strongly recommend you use the documentation[^] to find information.
|
|
|
|
|
I KNOW, that is the code I use at the moment...
I do not know how to do exactly the same with the xmlDocument-Class. Thats why i'm asking.
|
|
|
|
|
error1408 wrote: I do not know how to do exactly the same with the xmlDocument-Class.
I fail to see how that negates my original reply... I strongly recommend you use the documentation to find information.
|
|
|
|
|
I searched the documentation for my problem. And i found nothing. I checked every method.
And because i found nothing, i asked you.
|
|
|
|
|
error1408 wrote: I searched the documentation for my problem. And i found nothing.
You should probably provide that information in your initial post.
error1408 wrote: I checked every method.
I guess you missed this one[^]
|
|
|
|
|
THANK YOU. You're the man! Why didn't i see it before? At last the ugly code can be banished! Hurray 
led mike wrote: You should probably provide that information in your initial post.
Yes perhaps
|
|
|
|
|
I wonder why Microsoft keeps hiding this information in the documentation? 
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
 Yeah and Google is culpable as well since they provide a perfectly usable Search Engine.
|
|
|
|
|
I'm trying to create ASPX page with DataGrid, that includes template column, which looks like TextBox. I order to enable data binding to textbox I'm using the following syntax:
<asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "ID")%>' ID="txtID" /> using XSL.
I supposed, the XSL code should be the same, while escaping '<','>' etc.:
<asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "ID")%>' ID="txtID" />.
In this case I'm getting the following error:
Parser Error Message: Code blocks are not supported in this page, because it is not compiled.
Please, assist.
Alex
-- modified at 10:06 Wednesday 29th August, 2007
|
|
|
|
|
It is objecting to the "<%# ... %>" code which gets placed in the .aspx page before it gets compiled. By the time you place your code in the page, the page has already been compiled. Also, why place a textbox in this way when you can do it statically in design mode?
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
Is there any workaround? Is it possible to implement this in code-behind file?
|
|
|
|
|
There are a some ways but you have to stay away from the code blocks. You may need to as your question in the ASP.NET Forum to get a better answer, but you can use XSL in the creation of a custom control or during the binding processs you can add content to a cell or even modify the whole row. However, you have to stay away from coding blocks.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
Thanks anyway
|
|
|
|
|
how to create a xml document from a given xpath
Keshav Kamat
India
|
|
|
|
|
What do you mean? XPath is just a query. If you are talking about the resulting sequence or node set from an executed XPath query, what programming or mark-up language are you using? 
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
I am trying to put a ":" inside the XML tags. e.g.
<cnn:data>
right now it is this way:
<cnn_x0020_data>
|
|
|
|
|
The ":" is used to add a namespace to an element, for example: <xsl:element/>, where xsl is the namespace. If you are not using ":" for this reason, it should not be embedded in an element.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
