XML Development Forum RSS Feed

Xslt elements help

Wed, 24 Jun 2009 09:57:36 -0700

Hi,

I am trying to create a xslt , But I am getting below result,
Means I am getting All SNames in <SNAME> and Codes in <code>.

see below the output.
Output :
<ShortName>DOCENGTEACLE</ShortName>
<Code>666777888999</Code>

But I want something like this

<SName>DOC</SName>
<Code>666</Code>
<SName>ENG</SName>
<Code>777</Code>
<SName>TEA</SName>
<Code>888</Code>
<SName>CLE</SName>
<Code>999</Code>

or something like this is also fine

<DOCTOR>
<SName>DOC</SName>
<Code>666</Code>
</DOCTOR>
<ENGINEER>
<SName>ENG</SName>
<Code>777</Code>
</ENGINEER>
<TEACHER>
<SName>TEA</SName>
<Code>888</Code>
</TEACHER>
<CLERK>
<SName>CLE</SName>
<Code>999</Code>
</CLERK>

I applied the below xslt in my original xslt.

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="xml" encoding="utf-8" omit-xml-declaration="no" indent="yes" />

<xsl:template match="/">
<xsl:element name="SName">
<xsl:apply-templates select="//@SName"/>

</xsl:element>
<xsl:element name="Code">
<xsl:apply-templates select="//@Code">

</xsl:apply-templates>
</xsl:element>
</xsl:template>
</xsl:stylesheet>

My Actual XML File :

<Qxml>
<Qxml>
<Net>
<Property Name="DOCTOR" SName="DOC" LongDesc="YYY DOC" Code="666" STC="1"/>
<Property Name="ENGINEER" SName="ENG" LongDesc="XXX ENG" Code="777" STC="2"/>
<Property Name="TEACHER" SName="TEA" LongDesc="ZZZ TEA" Code="888" STC="3"/>
<Property Name="CLERK" SName="CLE" LongDesc="TTT CLE" Code="999" STC="4"/>
</Net>
</Qxml>
</Qxml>

Thanks

xslt help needed - urgent

Tue, 16 Jun 2009 14:39:32 -0700

completed

help on xslt needed.

Mon, 08 Jun 2009 04:39:33 -0700

Hi all,

I am a novice in xslt. I have a clean up requirement wherein i wud have to remove the <break type="paragraph"> tags if they are more than 3 and replace them with 2 tags <break type="paragraph"> .

The xml used here is in following format.

<textObjects>
<textObject>
<tag>Story</tag>
<objectMore>
<dataId>355376</dataId>
<index>0</index>
<value>
<dateTime>2009-05-30T09:31:26</dateTime>
<integer>100</integer>
</value>
</objectMore>
<text>
<inlineTag name="Story">
<inlineTag name="K4Xml">
<break type="paragraph"/>
<break type="paragraph"/>
<break type="paragraph"/>
<inlineTag name="Headline">
<break type="paragraph"/> Headline goes here<break type="paragraph"/>
</inlineTag>
<break type="paragraph"/>
<break type="paragraph"/>
<break type="paragraph"/>
<inlineTag name="Body">
<break type="paragraph"/> Body goes here<break type="paragraph"/>
</inlineTag>
<break type="paragraph"/>
<break type="paragraph"/>
<break type="paragraph"/>
<inlineTag name="Deck">
<break type="paragraph"/> Deck goes here<break type="paragraph"/>
</inlineTag>
<break type="paragraph"/>
<break type="paragraph"/>
<break type="paragraph"/>
<inlineTag name="Blurb1">
<break type="paragraph"/> Blurb goes here<break type="paragraph"/>
</inlineTag>
<break type="paragraph"/>
<break type="paragraph"/>
<break type="paragraph"/>
<inlineTag name="Strap">
<break type="paragraph"/> strap goes here<break type="paragraph"/>
</inlineTag>
<break type="paragraph"/>
<break type="paragraph"/>
<break type="paragraph"/>
<inlineTag name="Keywords">
<break type="paragraph"/> Keywords goes here<break type="paragraph"/>
</inlineTag>
<break type="paragraph"/>
<break type="paragraph"/>
<break type="paragraph"/>
<inlineTag name="VideoUrl">
<break type="paragraph"/> Video url goes here<break type="paragraph"/>
</inlineTag>
<break type="paragraph"/>
<break type="paragraph"/>
<break type="paragraph"/>
<inlineTag name="AuthorName">
<break type="paragraph"/> Author Name goes here<break type="paragraph"/>
</inlineTag>
<break type="paragraph"/>
<break type="paragraph"/>
<break type="paragraph"/>
</inlineTag>
</inlineTag>
</text>
</textObject>
</textObjects>

awaiting your response.

regards
SaiDeepak M

XML vs database

Sun, 03 May 2009 23:54:16 -0700

what is the difference between xml and database?what are the advantages of xml over database?

need help in XSLT 1.0 to get the current date

Fri, 17 Apr 2009 09:01:54 -0700

HI friends,
need help in XSLT 1.0 to get the current system date
Any help is highly appreciated.

I have done the below that I read from other posts but without any luck.

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" >
<xsl:template name="today"
xmlns:cal="java:java.util.GregorianCalendar">
<xsl:variable name="rightNow" select="cal:getInstance()" />

<xsl:variable name="month" select="cal:get($rightNow, 2) + 1" />
<xsl:variable name="day" select="cal:get($rightNow, 5)" />
<xsl:variable name="year" select="cal:get($rightNow, 1)" />
<xsl:value-of
select="$year" />-<xsl:value-of
select="$month" />-<xsl:value-of
select="$day" />

<xsl:element name="CurrDate">
<xsl:attribute name="TodayDate">
<xsl:value-of select="$rightNow"/>
</xsl:attribute>
</xsl:element>

</xsl:template>

<xsl:template match="today">
<xsl:element name="CurrDate">
<xsl:attribute name="TodayDate">
<xsl:value-of select="rightNow"/>
</xsl:attribute>
</xsl:element>
</xsl:template>

</xsl:stylesheet>

How to update the content of an XML file using libxml2

Sun, 12 Apr 2009 04:17:23 -0700

Hi,

My application is written in C and I am using libxml2 to parse my configuration file. Now i need to update some values and write them back in the same file.

Can anybody let me know how i can do this.
Any example prg would be of great help.

thanks,
GK

Can this be done with XSLT?

Fri, 30 Jan 2009 10:01:58 -0700

Hi Everyone,

I've been stuck on a XSLT problem trying to convert an XML doc to another XML and now I'm wondering if it's even possible to be done with XSTL. Here is a very simple breakdown of what I'm trying to do:

Convert this XML:

<Request>
   <SomeTypeA>
       <Variable>A</Variable>
   </SomeTypeA>
    <SomeTypeB>
       <Variable>B</Variable>
   </SomeTypeB>
   <SomeTypeB>
       <Variable>B</Variable>
   </SomeTypeB>
</Request>

To:

<Group name = Request>
   <Group name = SomeTypeA>
       <Variable>A</Variable>
   </Group>
   <Group name = SomeTypeB>
      <Item>
           <Variable>A</Variable>
      </Item>
      <Item>
           <Variable>A</Variable>
      </Item>
    </Group>
</Group>

The key here is I want to group all Nodes under <Request> that have the same name, in the example above <SomeTypeB> and process them together so that they belong to the same <Group name = SomeTypeB> after the conversion and they are separate by the new <Item> tags.

So far everything I tried has failed, the closest I get is that I get two sets <Group name = SomeTypeB> tags which is incorrect for my needs.

Can this even be done with XSLT or do I have to use Java or something else?

Much appreciated if you could solve this!!

Thanks

Help needed with XSLT please!

Fri, 30 Jan 2009 00:19:54 -0700

Hi All,

I'm actually quite new to XSLT and I got this issue I need to resolve. I'm converting this web service XML request to an XML file my system will understand using XSLT. The problem is the guy who wrote it quit so now I have to make some mods to new functionality and I'm kind of stuck. The crux of the problem is that the current xslt will take an XML such as
<Table>
<TypeA>
<SomeVar> A </SomeVar>
</Type>
<TypeA>
<SomeVar> B </SomeVar>
</TypaA>
</Table>

and convert it to:

<group name = TypeA>
<Item>
<SomeVar> A </SomeVar>
</Item>
<Item>
<SomeVar> B </SomeVar>
</Item>
</group>

Now I need to get rid of the <Table> tags from the input XML altogether and still produce the same output after XSLT is applied.

Here is the XSLT which currently handles this conversion:

<xsl:template name="GroupTable">
<xsl:element name="Group">
<xsl:attribute name="name">
<xsl:value-of select="local-name(node()[local-name()][1])"/>
</xsl:attribute>
<xsl:copy-of select="@*"/>
<xsl:for-each select="node()">
<xsl:if test="local-name() != ''">
<Item>
<xsl:for-each select="node()">
<xsl:call-template name="CheckNode"/>
</xsl:for-each>
</Item>
</xsl:if>
</xsl:for-each>
</xsl:element>

I dont know what a couple of things do:

1) <xsl:copy-of select="@*"/> .. Which nodes does this include?
2) "local-name(node()[local-name()][1])"/ what does this evaluate to?
3) Why there are two for loops to go through the set, shouldn't it go through the nodes only once?

Sorry if some of these are stupid questions - I'm very new to this.

Thanks,

Jiggs

XML Filtering - Help for a newbie please

Thu, 29 Jan 2009 23:09:35 -0700

Hi,
I am using XML for the first time to display item on a sales and wants page and need some help in displaying only those items of a particular category.
My idea is to have one that displays all items but then have a navigation bar that will allow visitors to see items by category.

My XML file would look something like this:

<?xml version="1.0" encoding="ISO8859-1"?>
<?xml-stylesheet type="text/xsl" href="sales.xsl"?>
<SALESWANTS>
<ITEM id="00001">
<Category>Car</Category>
<TITLE category="Car">Car make</TITLE>
<Description>car description</Description>
<ContactNo>contact number</ContactNo>
<Email>email address</Email>
</ITEM>

<ITEM id="00002">
<Category>Furniture</Category>
<TITLE category="Furniture">Furniture Title</TITLE>
<Description>Furniture Description</Description>
<ContactNo>contact number</ContactNo>
<Email>email address</Email>
</ITEM>

<ITEM id="00003">
<Category>Toys</Category>
<TITLE category="Toys">Toy Title</TITLE>
<Description>Toys</Description>
<ContactNo>contact number</ContactNo>
<Email>email address</Email>
</ITEM>
</SALESWANTS>

I have currently created a separate XML and XSL sheet for each category, which works, but I want to know if there is a better, more dynamic, way of doing what I want without having to alter several XML and XSL sheets.

Many thanks in advance.

How can I use the current object in a loop as part of a query?

Tue, 06 Jan 2009 13:52:39 -0700

Hi,

I have an XML document with 2 parts, meta data and data.
In the data part I have a list of word elements and each word element has several test elements indicating tests that were done of this word and the results of these tests (each test has a separate test element which is a sub element of word). each test element has a passed attribute with a Boolean value

In the metadata part I have a list of all the tests that were conducted in general (on all the words).

I want to loop around the tests in the metadata part and for each test I want to count the words that have this test as a subelement with a True value to the passed attribute. I couldn't find any way to do this.

what I'm trying to basically do is to use the name of the test in the current part of the loop as part of a separate XPath query?

Here is an example of the XML document:

<?xml version="1.0" encoding="ISO-8859-1"?>
<compare>
<info>
<file type="semcor">/freespace/stud/omerholz/NLP/SemCor/ Compare/scstat_br-ca01_wf.xml</file>
<file type="rawresults">/freespace/stud/omerholz/NLP/res ults/2009-01-03-12-47/raw_results/prob_ss_given_W_final_ca01.xml</fil e>
<list type="tests">
<item type="test" name="firstequal">Test whether the supersense with the highest rank is identical</item>
<item type="test" name="hresholdnonordered">Test whether the group of highest ranked supersenses is identical, not checking whether the order is identical</item>
<item type="test" name="hresholdordered">Test whether the group of highest ranked supersenses is identical, not checking whether the order is identical</item>
</list>
</info>
<comparison>
<word lemma="shot">
<test name="firstequal" passed="False" description="True">
<description>Test whether the supersense with the highest rank is identical</description>
<sense type="semcor" rank="1">noun.act</sense>
</test>
<test threshold="0.8" name="hresholdnonordered" passed="True" description="True">
<description>Test whether the group of highest ranked supersenses is identical, not checking whether the order is identical</description>
<sense type="semcor" rank="1" sense="noun.act">1.0</sense>
</test>
<test threshold="0.8" name="hresholdordered" passed="False" description="True">
<description>Test whether the group of highest ranked supersenses is identical, not checking whether the order is identical</description>
<sense type="semcor" rank="1" sense="noun.act">1.0</sense>
</test>
</word>
<word lemma="office">
<test name="firstequal" passed="False" description="True">
<description>Test whether the supersense with the highest rank is identical</description>
<sense type="semcor" rank="1">noun.group</sense>
</test>
<test threshold="0.8" name="hresholdnonordered" passed="True" description="True">
<description>Test whether the group of highest ranked supersenses is identical, not checking whether the order is identical</description>
<sense type="semcor" rank="1" sense="noun.group">1.0</sense>
</test>
<test threshold="0.8" name="hresholdordered" passed="False" description="True">
<description>Test whether the group of highest ranked supersenses is identical, not checking whether the order is identical</description>
<sense type="semcor" rank="1" sense="noun.group">1.0</sense>
</test>
</word>
</comparison>
<compare>

And this is an example of an XSLT code I was trying to use but it doesn't work (I hope that reading it will give better insight to what I was trying to achieve):

<xsl:for-each select="compare/info/list[@type='tests']/item">
<xsl:variable name="tname" select="@name" />
<xsl:value-of select="translate('count(/compare/comparison/word/ test[@name="%s" and @passed="True"]/parent::node()/@lemma)', '%s'$tname"/>
</xsl:for-each>

Anyone has an idea how I may use the name of the test in the current part of the loop as part of a separate XPath query?

Thanks for any help :)

New to XML need help

Thu, 18 Dec 2008 17:00:37 -0700

I need to create an example xml document with CSS and DTD

here is the code I have so far, but I cannot make it to view correctly in the browser the chapter information does not display. can anyone help?

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE CATALOG SYSTEM "catalog1.dtd">
<?xml-stylesheet type="text/css" href="catalog.css"?>
<CATALOG>
−
<BOOK>
<TITLE>XML HACKS</TITLE>
<AUTHOR>MICHAEL FITZGERALD</AUTHOR>>
<PUBLISHER>O'REILLY</PUBLISHER>
<CREDITS>MICHAEL FITZGERAL IS PRINCIPAL OF WY'EAST COMMUNICATIONS, A WRITING, TRAINING, AND PROGRAMMING CONSULTANT SPECIALIZED IN XML PROGRAMMING LANGUAGE</CREDITS>

<ONE>Chapter 1 - Looking at XML Documents</ONE>

Some browsers, such as Microsoft Internet Explorer version 5 or later, let you display XML documents directly. For example, if you download the code for this book, you can browse to ch01_02.xml in Internet Explorer, as you see in Figure 1.2. As you see in the figure, the whole XML document we've created is displayed. You can even click the – sign in front of the <document> element to collapse all the contents of that element into a single line (which will have a + sign in front of it, indicating that that line may be expanded). In this way, you can display a raw XML document in Internet Explorer.

<TWO>Chapter 2 - CREATING XML DOCUMENTS</TWO>

Yesterday you got an introduction to XML; today, you're going to get down to work by creating XML documents piece by piece. Here's an overview of today's topics:

* Writing XML
* The parts of an XML document
* XML prologs
* XML declarations
* Comments
* Processing instructions
* Elements
* CDATA sections
* Entities
* XML tools
* XML validators

You'll start creating XML documents at the logical beginning point—by choosing the correct software for this task.

<THREE>Chapter 3 - TRANSFORMING XML DOCUMENTS</THREE>

Before we move on to see the nuts-and-bolts of XSLT, you may want to download an editor that supports XSLT so you can try out some of these examples yourself. An editor you could use is XMLSpy Home Edition (from www.altova.com) which is free.
In all our examples both in this chapter and the next, we will use base XML file shown below as data, which we will then transform using XSLTs. I would recommend that you copy this file into your chosen editor and run the transformations as we go through them (in the XMLSpy editor, this would be done from the menu XSL Transformation).

As shown in the XML file below, in order to render a XML document using an XSLT, the XSLT name is specified just after the first statement of the XML file, using the following directive:
<INTRODUCTION>

Developers and system administrators alike are uncovering the true power of XML, the Extensible Markup Language that enables data to be sent over the Internet from one computer platform to another or one application to another and retain its original format. Flexible enough to be customized for applications as diverse as web sites, electronic data interchange, voice mail systems, wireless devices, web services, and more, XML is quickly becoming ubiquitous. XML Hacks is a roll-up-your-sleeves guide that distills years of ingenious XML hacking into a complete set of practical tips, tricks, and tools for web developers, system administrators, and programmers who want to go far beyond basic tutorials to leverage the untapped power of XML. With plenty of useful real-world projects that illustrate how to define, read, create, and manipulate XML documents, XML Hacks shows readers how to put XML's power to work on the Internet and within productivity applications. Each Hack in this book can be read easily in a few minutes, saving programmers and administrators countless hours of searching for the right answer. And this is an O'Reilly Hacks book, so it's not just practical, imminently useful, and time-saving. It's also fun. From Anatomy of an XML Document to Exploring SOAP Messages XML Hacks shows you how to save time and accomplish more with fewer resources. If you want much more than the average XML user--to explore and experiment, do things you didn't know you could do with XML, discover clever shortcuts, and show off just a little--this invaluable book is a must-have.
</INTRODUCTION>
<PREFACE>

Along with XML has come a thundering horde of graphical XML editors that do everything short of buttering your toast. Many editors are readily available (see http://www.xmlsoftware.com/editors.html for a comprehensive though not exhaustive list), but I'll mention only a few safe bets here.
xmlspy 2004 by Altova (http://www.xmlspy.com) is a feature-rich, graphical editor for XML for the Windows environment. xmlspy has also been tested on Red Hat Linux running Wine, and Mac OS/X running Microsoft Virtual PC for Mac. The Home Edition of this popular editor is available for free, but you must pay for licensess for Professional and Enterprise editions. I'll give you a quick feature fly-over of xmlspy—though there are a number of features I won't get around to mentioning.
xmlspy can help you create documents and schemas by hand or from templates (examples), organize work into projects, and import text and database files. You can view documents as text with syntax highlighting or in a grid view, check spelling, validate against DTDs and XML Schema documents, perform XSLT transformations [Hack #33] and evaluate XPath location paths. xmlspy provides support for WSDL (http://www.w3.org/TR/wsdl) and SOAP [Hack #63] . You can also use xmlspy to generate Java, C++, or C# code [Hack #99] from DTDs or XML Schema documents.
Figure 1-10 shows the document valid.xml in xmlspy with helper panes on the right. These panes let you insert elements, attributes, and entities with a single click. The Project pane on the left gives you quick access to all kinds of templates.

</PREFACE>
<INDEX>A-Z</INDEX>
</BOOK>
−

XSLT attribute-centric to element-centric conversion problem

Mon, 15 Dec 2008 07:22:01 -0700

Hi. I have problem constructing XML element-centric for ACCESS 03 import.
To convert is no problem, but then how to use the data is what i have been working on whole day without result... im desparate :(

this is the XML file example:

<?xml version="1.0" encoding="UTF-8" ?>
- <service-list>
<date-created>3.12.2008</date-created>
- <user-filter>
<cn>0000000</cn>
<group />
<user />
</user-filter>
- <users>
- <user name="9asd2862" phone-number="049849849" lump="AAA6" date-expire="19.06.2010">
- <services>
<service name="Balík 150 minút" activated="false" />
<service name="Bezpečnostný balík" activated="false" />
<service name="Zvýšenie objemu dát" activated="false" />
</services>
</user>

and there are like 16k user entries like this.
i need to create a list of all users and their activated services. like

name / phone / lump / date-expire / service-name / service-activated

this line has to be repeated for every service entry so the final DB in access should look like this

test1 / 123456 / aaa6 / 12.12.2010 / test-service / true
test1 / 123456 / aaa6 / 12.12.2010 / test-service2 / false
test1 / 123456 / aaa6 / 12.12.2010 / test-service3 / true
test2 / 123412 / aaa1 / 12.12.2010 / test-service / true
test2 / 123412 / aaa1 / 12.12.2010 / test-service2 / true
test2 / 123412 / aaa1 / 12.12.2010 / test-service3 / true

and so on...

any ideaz?

thanks in advance ;)

XML instead of ADO.net

Wed, 26 Nov 2008 01:33:59 -0700

Hi , everybody, Are u having a good time? I am not......
I am working on a IVR project.We have completed the design stage, now coding.

My boss said me to determine whether using XML for data manipulation will be faster than normal process( for ex ADO.net).
We r working in C#(.net) & SQL server 2005. He wants to use 2 functions :

xmlBuilder()

xmlParser()

xmlBuilder(CRecordset *rs,char* retValue) will be used to build an XML string for the recordset.
this xml string will be saved in the character array.

Then we use xmlParser(retXML,"Location",index,filename) to search or find............
retXML is the xml string saved in the char array.
I have worked in ADO.net there with in_memory database(dataset...) data handling is faster.

what do u think?

Should we use XML?

Pls reply, quick if possible.

Best of luck.

Help transforming XML

Wed, 12 Nov 2008 00:41:04 -0700

Hi, I would like to transform the following XML structure.

<Region>
<description>RegionDesc</description>
<Group>
<description>GroupDesc</description>
<id>1</id>
<Events>
<Event>
<eventID>100</eventID>
</Event>
<Event>
<eventID>200</eventID>
</Event>
</Events>
</Group>
<Group>
<description>GroupDesc</description>
<id>2</id>
<Events>
</Events>
</Group>
</Region>

I would like to be able to "flatten" the view so that the number of events are stored in an attribute. I'd also like to make the parent Region's description an attribute to each Group.

<Group>
<region>RegionDesc</region>
<description>GroupDesc</description>
<id>1</id>
<eventCount>2</eventCount>
</Group>
<Group>
<region>RegionDesc</region>
<description>GroupDesc</description>
<id>2</id>
<eventCount>0</eventCount>
</Group>

Any help would be greatly appreciated!!

Trouble with zooming

Fri, 07 Nov 2008 07:13:56 -0700

I am making a GUI for an project and trying to implement zooming as well...

Everything is fine except the fact that when i zoom to much in i dont get a scroll bar even if i put in a scrollviewer...here is the code

<Window
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/present
ation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    x:Class="wpftest.Window1"
    Title="Window1" Height="500" Width="500" xmlns:d="http://schemas.microsoft.com/expression/blend/2008
" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="d">
    <Grid>
        <Grid.RowDefinitions>
            <RowDefinition Height="230*" />
            <RowDefinition Height="185*" />
            <RowDefinition Height="25*" />
        </Grid.RowDefinitions>
        <Slider Width="100" HorizontalAlignment="Right" x:Name="uiScaleSlider" ToolTip="Zoom" Value="1" Minimum="1" Maximum="10" Grid.Row="2" Margin="0,3,0,0" SmallChange="0.1" />
        <ScrollViewer HorizontalScrollBarVisibility="Auto" VerticalScrollBarVisibility="Auto" Grid.Row="1" Grid.RowSpan="1">
            <Grid Grid.Row="1" Grid.Column="0" Grid.RowSpan="1" Margin="0,0,0,0">
                <Grid.RenderTransform>
                    <ScaleTransform ScaleX="{Binding Path=Value, ElementName=uiScaleSlider}" ScaleY="{Binding Path=Value, ElementName=uiScaleSlider}"/>
                </Grid.RenderTransform>
                <Rectangle Name="rectangle1" Stroke="Black" Margin="156.698,40.008,236.714,56.678">
                   
                </Rectangle>
            </Grid>
        </ScrollViewer>
    </Grid>
</Window>

first i was using a stackpanel instead of grid but i couldnt put them how i wanted... and instead of rendertransform i used layouttransform but then the elements scaled in a strange way...anyone know how to solve this :(

xml

Wed, 15 Oct 2008 01:40:16 -0700

how can i read data from xml and write data to xml file in delphi 2007.give some sample code

XML Stylesheets with unique XML

Wed, 10 Sep 2008 03:14:14 -0700

The company I work for have developed a system that sends multiple difference XML based notices via web service and wants to be able to select some XML, which could be different every time, and apply a stylesheet to it so that the user can see it in a nice format. The question is, can there just be one stylesheet or should there be one per notice? As the notices or XML docments we produce contain different amounts of data with data of differing types and length it is my opinion that seperate xsl's should be produced but that in theory if the stylesheet was not massively complex and the data sets were similar i.e. of a similar length etc. it could be done in one stylesheet.

Anyone know if I'm right or not or if there is an easy way to display unique XML data using a single stylesheet?

Cheers

Free Download XML ebooks

Sun, 07 Sep 2008 22:38:10 -0700

Dear Friends,

You are free to download ebooks of XML, HTML, SQL Server, software, oracle, Unix, Linus and much more.

Download from
http://freedownload12.blogspot.com/

transform XML to XML

Mon, 25 Aug 2008 08:55:41 -0700

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

Display XML using XSL

Wed, 25 Jun 2008 23:27:27 -0700

Hi,

I want to display the contents of XML file using XSL one by one after clicking a button. Can anyone help regarding this matter. It's urgent....plz help....

Thanks
Devi

dtd question

Tue, 13 May 2008 02:44:24 -0700

can i specify fixed number of children in dtd?

For example <!ELEMENT book (pages)*>
I want the number of pages to be exactly or less than 100 instead of 0 or more.

Can i achieve the above?

Thanks in advance.

Regards,
Vamshi

windows movie maker

Thu, 17 Apr 2008 14:38:56 -0700

hi,
does anyone know a xml code that would allow me to put text in the corner of every frame of a movie being edited in windows movie maker ?
it would be like making a "title on selected clip" but there would be a selection for text in corner "preferably the bottom right corner"

i already have the code that allows pics to do this function but when u have a "pic" thats nothing but text with a tranparent background the text is bunched up and barley readable

thanks for your input

XSL and Excel

Tue, 15 Apr 2008 07:49:30 -0700

I have an xml file saved from Excel. The first cell in the first row contains a number that represents the row my column headings will start. I'm trying to get the value from this cell and put it into a variable for later on.

An excert from my original xml file:
<Row>
<Cell><Data ss:Type="Number">7</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s70"><Data ss:Type="String">Some Bank</Data></Cell>
<Cell ss:StyleID="s64"/>
<Cell ss:StyleID="s64"/>
<Cell ss:StyleID="s64"/>
<Cell ss:StyleID="s64"/>
<Cell ss:StyleID="s64"/>
<Cell ss:StyleID="s73"/>
<Cell ss:StyleID="s73"/>
</Row>

The only thing I can guarentee with the original file is this 1st cell will contain the row number the column headings start on. So my question is how do I reference that first cell? I've tried putting the value out in a comment just to see if I can reference it and it does not like it.

<xsl:comment>
<xsl:value-of select="ss:Row/ss:Cell[1]"/>
<xsl:value-of select="$dataRowStart"/> -- this value is 8
</xsl:comment>

My output xml looks something like this:

<?xml version="1.0" encoding="UTF-8"?>

<Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:o="urn:schemas-microsoft-com:office:office">
<FA_Report-September_2007>

Any/all help is greatly appreciated due this being completely new to me.

ampersands in URLS in XML compliant HTML

Tue, 18 Mar 2008 12:17:29 -0700

I have a problem with ampersands in URL's that use ampersands.

The use of ampersand is kind of important in a URL. You probably know this already but the ampersand in a URL often to set GET parameters for a request to a server side script.

The problem is that it seems XML needs all ampersands to be written of the form & but I don't think the JavaScript below would work then.

Here is an example of some code I'm referring to. You can see the "&url=" that causes the problem.

<a onclick="javascript:window.open('/cgi-bin/linkmailer.pl?&url=http://www.csgnetwork.com/tempconvjava.html'...

How can you use ampersands in attribute values of XML compliant code?

XSL Formating a web Page question.

Fri, 14 Mar 2008 05:42:40 -0700

I would like to have an evenly spaced table that will be ten cells wide, but I do not know how to write the .xsl file so that it knows when to start a new row. I would like a row of pictures, and then a row of captions for those pictures in a separate cell below the picture. Once I have ten items in a row I would then like it to start a new row. I am new to xml, and am not sure this is even possible. Any help would be appreciated.

Thanks,

Smurf