|
I have XML that I need to tranform to another structure of XML. The XML I need to transform is below:
<ArrayNode>
<Base>
<aa>1</aa>
<bb>text</bb>
<cc>
<ccc>
<cccc>text#1</cccc>
<cccc2>text#1</cccc2>
</ccc>
<ccc>
<cccc>text#2</cccc>
<cccc2>text#2</cccc2>
</ccc>
</cc>
<dd>text</dd>
</Base>
<Base>
<aa>2</aa>
<bb>text2</bb>
<cc>
<ccc>
<cccc>text#3</cccc>
<cccc2>text#3<cccc2>
</ccc>
<dd>text</dd>
</Base>
</ArrayNode>
This needs be tranformed to:
<ArrayNode>
<Base>
<aa></aa>
<bb></bb>
<cc>
<ccc>
<cccc>Text#1</cccc>
<cccc2>Text#1</cccc2>
</ccc>
</cc>
<dd></dd>
</Base>
<Base>
<aa></aa>
<bb></bb>
<cc>
<ccc>
<cccc>Text#2</cccc>
<cccc2>Text#2</cccc2>
</ccc>
</cc>
<dd></dd>
</Base>
<Base>
<aa></aa>
<bb><bb>
<cc>
<ccc>
<cccc>Text#3</cccc>
<cccc2>Text#3<cccc2>
</ccc>
<cc>
<dd></dd>
</Base>
</ArrayNode>
Wherever <ccc> exists, it needs to loop over each <ccc> and insert each individual <ccc> into the rest of the data for that <Base> group. So if there are 3 <ccc>'s, it should repeat the entire <Base> group and insert one of the <ccc> nodes.
Thanks in advance
|
|
|
|
|
Hi All!
After the success of the help I got on my earlier post I have run into another problem.
While all my tags now work anywhere in the document below the BODY tag, my xsl:value-of in my earlier post fails to output any tags below the first one, for instance:
<B>
<EM>
Hello World!
</EM>
</B>
Only Outputs:
<B ONCLICK="" ONDBLCLICK="" ONMOUSEDOWN="" ONMOUSEUP="" ONMOUSEOVER="" ONMOUSEMOVE="" ONMOUSEOUT="" ONKEYPRESS="" ONKEYDOWN="" ONKEYUP="" ID="" CLASS="" TITLE="" STYLE="" DIR="" LANG="">
Hello World!
</B>
The EM Tags are being ignored completely, and when the tags are swapped the B tags are ignored completely.
Does anyone know why this is happening, and if so, can anyone suggest a fix or workaround?
Thanks!
MrWolfy 
|
|
|
|
|
Hi All!
It has just occurred to be that my original question could have been put far more simply:
How would I output unescaped HTML tags using the xsl:value-of element, I have tried disable-output-escaping="yes" but the html tags within are just ignored and seemingly not outputted at all.
Thanks!
MrWolfy
|
|
|
|
|
Have you tried copy-of instead of value-of?
|
|
|
|
|
Hi And Thanks!
Thanks Frank! Again you have provided the soloution to a problem I have been grappling with for weeks!
Thanks Again!
MrWolfy
|
|
|
|
|
|
Don't repost your question. You were given reasonable answers on your first post.
debobrata wrote: the source code I got for the XML Notepad from the Codeplex.com is not building.
The project you describe is far to ambitious for a developer that can't even compile an open source project.
led mike
|
|
|
|
|
Hai,
i want to get the attribute names from the xml using xslt...
my xml is:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="cdcatalog.xsl"?>
<!-- Edited by XMLSpy® -->
<catalog>
<cd select="true">
<title>Empire Burlesque</title>
<artist>Bob Dylan</artist>
<country>USA</country>
<company>Columbia</company>
<price>10.90</price>
<year>1985</year>
</cd>
<cd select="true">
<title>Hide your heart</title>
<artist>Bonnie Tyler</artist>
<country>UK</country>
<company>CBS Records</company>
<price>9.90</price>
<year>1988</year>
</cd>
</catalog>
Now i want to get the value select equal to true or false..
Any one help me....
Regards,
Subbu.H
|
|
|
|
|
H.Subbulakshmi wrote: i want to get the attribute names from the xml using xslt
H.Subbulakshmi wrote: Now i want to get the value select equal to true or false..
I don't know what that means but the following XSLT will render the names of all the attributes that have the value true
<xsl:for-each select="//*/@*[.='true']">
<p>
<xsl:value-of select="name()"/>
</p>
</xsl:for-each>
led mike
|
|
|
|
|
Class declaration:
[XmlRoot(Namespace="http://www.example.com/Person")]
class Person
{
[XmlElement(Form=System.Xml.Schema.XmlSchemaForm.Unqualified)]
Public string Name;
}
Serialized XML using XMLSerializer and XMLSerializerNamespace
<ns0:person xmlns:ns0="http://www.example.com/Person">
<name>Bill</name>
</ns0:person>
</pre>
I am having trouble deserializing above XML and create an instance of Person class with Name property. Also I did not find a way to pass "ns0" namespace prefix to deserialization.
Any help or direction will greatly be appreciated in any .NET compliant language.
|
|
|
|
|
Hi All!
I need to emulate the HTML <B> and <EM> tags complete with all attributes and event handlers for a little project of mine and everything works fine when these elements are seperate, Here's my xsl stylesheet:
<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:template match="/HTML/BODY/EM">
<EM ID="{@ID}" CLASS="{@CLASS}" TITLE="{@TITLE}" STYLE="{@STYLE}" DIR="{@DIR}" LANG="{@LANG}" ONCLICK="{@ONCLICK}" ONDBLCLICK="{@ONDBLCLICK}" ONMOUSEDOWN="{@ONMOUSEDOWN}" ONMOUSEUP="{@ONMOUSEUP}" ONMOUSEOVER="{@ONMOUSEOVER}" ONMOUSEMOVE="{@ONMOUSEMOVE}" ONMOUSEOUT="{@ONMOUSEOUT}" ONKEYPRESS="{@ONKEYPRESS}" ONKEYDOWN="{@ONKEYDOWN}" ONKEYUP="{@ONKEYUP}"><xsl:value-of select="self::EM"/></EM>
</xsl:template>
<xsl:template match="/HTML/BODY/B">
<B ONCLICK="{@ONCLICK}" ONDBLCLICK="{@ONDBLCLICK}" ONMOUSEDOWN="{@ONMOUSEDOWN}" ONMOUSEUP="{@ONMOUSEUP}" ONMOUSEOVER="{@ONMOUSEOVER}" ONMOUSEMOVE="{@ONMOUSEMOVE}" ONMOUSEOUT="{@ONMOUSEOUT}" ONKEYPRESS="{@ONKEYPRESS}" ONKEYDOWN="{@ONKEYDOWN}" ONKEYUP="{@ONKEYUP}" ID="{@ID}" CLASS="{@CLASS}" TITLE="{@TITLE}" STYLE="{@STYLE}" DIR="{@DIR}" LANG="{@LANG}" ><xsl:value-of select="self::B"/></B>
</xsl:template>
</xsl:stylesheet>
Now this works fine when <B> and <EM> are seperate, however when one tag is inside the other the result is no formatting at all!
The problem is that the match attribute of each xsl:template tag is only neing applied to B and EM tags in the BODY, is there any way I can apply the B and EM templates to the BODY and to all infinetly deeper nesting levels?
Thanks!
MrWolfy
|
|
|
|
|
MrWolfy wrote: the result is no formatting at all!
No formatting in what? A Browser? If so, looking at your XSL isn't helping us at all.
Post the HTML that is not rendering correctly and the browser version you are using.
led mike
|
|
|
|
|
<xsl:template match="/HTML/BODY/descendant::EM">
|
|
|
|
|
Hi and Thanks!
Thanks Frank! The code works perfectly! Problem Solved!
Thanks Again!
MrWolfy
|
|
|
|
|
You're welcome. In case you can read German or French, this is where I learnt it all:
http://selfhtml.org/
I hardly ever use websites in my native language when it comes to software development cause anglophone sites are abundant and (when they have a forum) well populated, but this one is so good I took it on as my default HTML and XSL reference.
|
|
|
|
|
wow, I did not understand that was what he was asking at all.  Nice catch!
led mike
|
|
|
|
|
Hi,
I want to create an XML Editor Tool in C#.NET (similar to what we currently have in Visual Studio).
I want this editor tool to be integrated in my project.
The intention in creating the tool is that I want to view and edit the XML in this tool itself. I should
be able to directly modify the XML in this XML editor and thereby persist it back. And the changes should be
reflected accordingly.
It should have a collapse-Expand feature. And if possible it should also support Syntax based colours.
Hence, the tool should be able to open any XML in the proper format(proper parsing check should be there)
and edit them and save it back.
I currently work in VS 2008 in C#.
It will be really helpful if someone put the code in implementing the same and thanks in advance for any kind of suggestions.
Thanks,
Deb 
|
|
|
|
|
Hi debobrata
You could use an open source text editor component called FireBall. It has features like syntax highlighting for different languages XML being one of them and it also supports collapse-expand feature. You can open any XML with file with it. As for the validation, I'm afraid you gonna have to implement that your self but the rest should be easy enough.
Regards
tptshepo
|
|
|
|
|
Hi,
Can you please provide me the link for the "FireBall" text editor component so that i can download the source code for the same. And whether the source code is available for download or not.
I was trying googling for the same, but was not able to download the source code.
Please help me in that. Atleast i need to check the editor with the source code and then i can revert you back whether it has been helpful for me or not.
Thanks and Regards,
Deb
|
|
|
|
|
|
XML Notepad[^] (from MS) is now open source. Maybe it'll help you.
|
|
|
|
|
the source code I got for the XML Notepad from the Codeplex.com is not building.
Can you please zip and send me the entire source code for the XML Notepad in my email id
which is debobrata.bose@gmail.com
Thanks and Regards,
Deb
|
|
|
|
|
Hi,
I have a problem that i have three XSD for validate a XML. I use VC++
for validate the xml
IXMLDOMSchemaCollectionPtr pSchemaCache;
pSchemaCache.CreateInstance(__uuidof(XMLSchemaCache40));
//Add schema to schemacache
hr = pSchemaCache->add(L"",_variant_t(_T("Path\\xdm1.xsd")));
//xdm1.xsd is the XSD in which i import the other two xsd.
this code always fail I don't know why this is happend, can anyone know the reason,pleasse help me.
Thanks & regards
Vicky00000
|
|
|
|
|
I have a table in database :
CREATE TABLE [LeftMenu] (
[NodeID] [int] NOT NULL ,
[ParentNodeID] [int] NULL ,
[FK_LangID] [int] NULL ,
[Text] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[lastlevel] [bit] NULL ,
[linkLevel] [bit] NULL ,
CONSTRAINT [PK_LeftMenu] PRIMARY KEY CLUSTERED
(
[NodeID]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
and i want to generate XML file from this table with relation between 'NodeID' column and 'ParentNodeID' to fill ASP.net 2 Menu Control or TreeView Control
like this example:
<menu>
<sub NodeID="1" ParentNodeID="" Text="aaa" />
<sub NodeID="2" ParentNodeID="" Text="aaa" >
<sub NodeID="3" ParentNodeID="2" Text="aaa" >
<sub NodeID="20" ParentNodeID="3" Text="aaa" />
<sub NodeID="20" ParentNodeID="3" Text="aaa" />
</sub>
<sub NodeID="10" ParentNodeID="2" Text="aaa" />
<sub NodeID="12" ParentNodeID="2" Text="aaa" />
</sub>
<sub NodeID="4" ParentNodeID="" Text="aaa" />
<sub NodeID="5" ParentNodeID="" Text="aaa" />
<sub NodeID="6" ParentNodeID="" Text="aaa">
<sub NodeID="14" ParentNodeID="6" Text="aaa" />
</sub>
<sub NodeID="7" ParentNodeID="" Text="aaa" />
<sub NodeID="8" ParentNodeID="" Text="aaa" />
<sub NodeID="9" ParentNodeID="" Text="aaa" />
</menu>
plz reply me.
Thank you
Abdullah Abdelhay
|
|
|
|
|
HI
Run this in a console app and change the connection string!
<pre>
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace MenuGen
{
class Program
{
public static string Crlf = System.Environment.NewLine;
private class LeftMenuNode
{
public int NodeID = 0;
public string ParentNodeID = string.Empty;
public int FK_LangID = 0;
public string Text = string.Empty;
public bool LastLevel = false;
public bool LinkLevel = false;
public List<LeftMenuNode> SubMenus;
public LeftMenuNode()
{
SubMenus = new List<LeftMenuNode>();
}
}
//get the menu data from the database
static void GetDBMenus(ref DataSet ds)
{
string sql = "SELECT * FROM LeftMenu";
SqlCommand cmd = new SqlCommand(sql, new SqlConnection(@"data source=***;initial catalog=***;Integrated Security=True"));
cmd.CommandType = CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
ds.Clear();
using (adapter)
{
adapter.Fill(ds);
}
}
static void Main(string[] args)
{
DataSet dsMenus = new DataSet("Menu");
//get the list of menus
GetDBMenus(ref dsMenus);
//make sure we have a table to work with
if (dsMenus.Tables.Count == 0)
return;
//kick off the menu gen process
BuilMenuXML(ref dsMenus);
//now that we've buld a class structure we can work with
//all we have to do now if
}
static void BuilMenuXML(ref DataSet ds)
{
int tab = 0;
string xml = string.Empty;
xml = "<Menu>"
+ Crlf;
//populate our custom menu class
List<LeftMenuNode> menus = new List<LeftMenuNode>();
foreach (DataRowView row in ds.Tables[0].DefaultView)
{
LeftMenuNode menuItem = new LeftMenuNode();
menuItem.NodeID = Convert.ToInt32(row["NodeID"]);
menuItem.ParentNodeID = Convert.ToString(row["ParentNodeID"] == DBNull.Value ? "" : row["ParentNodeID"]);
menuItem.Text = Convert.ToString(row["Text"]);
tab++;
xml += TabChar(tab)
+ "<Sub NodeID=" + menuItem.NodeID.ToString()
+ " ParentNodeID=" + menuItem.ParentNodeID.ToString()
+ " Text=" + menuItem.Text
+ ">"
+ Crlf;
//build sub menu items
BuilSubMenuItem(menuItem, ref ds, ref tab, ref xml);
xml += TabChar(tab)
+ "</Sub>"
+ Crlf;
tab--;
//add main menu
menus.Add(menuItem);
}
xml += "</Menu>"
+ Crlf;
System.Diagnostics.Debug.Write(xml);
//output xml
Console.Write(xml);
Console.ReadLine();
}
//build sub menus - we need the dataset so we can search for sub menus
static void BuilSubMenuItem(LeftMenuNode node, ref DataSet ds, ref int tab, ref string xml)
{
//get a list of sub menus for the node we just passed at the top
DataView view = new DataView(ds.Tables[0], "ParentNodeID = " + node.NodeID,
"ParentNodeID", DataViewRowState.CurrentRows);
//add sub menus to the collection
foreach (DataRowView row in view)
{
LeftMenuNode menuItem = new LeftMenuNode();
menuItem.NodeID = Convert.ToInt32(row["NodeID"]);
menuItem.ParentNodeID = Convert.ToString(row["ParentNodeID"]);
menuItem.Text = Convert.ToString(row["Text"]);
tab++;
xml += TabChar(tab)
+ "<Sub NodeID=" + menuItem.NodeID.ToString()
+ " ParentNodeID=" + menuItem.ParentNodeID.ToString()
+ " Text=" + menuItem.Text
+ ">"
+ Crlf;
//build sub menus for this sub menu
BuilSubMenuItem(menuItem, ref ds, ref tab, ref xml);
xml += TabChar(tab)
+ "</Sub>"
+ Crlf;
tab--;
//add sub menu to collection
node.SubMenus.Add(menuItem);
}
}
private static string TabChar(int instance)
{
string text = "";
if (instance == 0) { return ""; }
for (int i = 0; i < instance; i++)
{
text += (char)9;
}
return text;
}
}
}
</pre>
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
