Hi all
I have this xml file (generated from Lotus Domino 6) and would like to transform it to a simpler one by extracting only data between the gif tag (I cut the gif data to reduce the file here); I wrote an xls to do it to transform the xml file. What am I doing wrong ? because what I get is all the data in the xml file instead of my expected output file
((
Need your help
Ndeye, a new "xslter"
*my xml input file :
<?xml version="1.0" ?>
<!DOCTYPE document (View Source for full doctype...)>
- <document xmlns="http://www.lotus.com/dxl" version="6.5" replicaid="C1256DC700510DFF" form="Person" response="false" conflict="false"> + <noteinfo noteid="356e" unid="60C4C68E08994352C1256E00003026AB" sequence="2"> + <updatedby> + <item name="full_name" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false">
- <item name="Picture" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false">
- <richtext>
- <pardef id="1" leftmargin="1%" rightmargin="99%" keeptogether="true" align="left" linespacing="1" spacebefore="1" spaceafter="1" newpage="false" list="none" readingorder="lefttoright">
- <code event="hidewhen">
<formula>(!@IsDocBeingEdited &
NoPhotoThanks="NoPhoto")|(@IsDocBeingEdited & isweb)</formula> </code> </pardef>
- <par def="1">
- <picture width="182px" height="136px" align="baseline"> <gif>R0lGODlhtgCIAOcAAP///4CAgIiIiGhoYFBQSKioiCgoKCAgGBAICCgoIPD4+Hh4eAAAAKCggHh4 cIiIgCAgIDAwKBgQEHBwaJiYeICAcPDw8JiYgJCQiAgICHBwcGBgWJCQkDAoIICAeBgYEFBQQEhQ</gif> </picture> </par> <par /> </richtext> </item> + <item name="jobdescrip_me" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false"> + <item name="Phone_Me" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false"> + <item name="EMail_me" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false"> + <item name="ShowHasPic" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false"> + <item name="$Revisions" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false"> </document>
*my xsl input file :
<?xml version="1.0" encoding="UTf-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl
utput method="xml" version="1.0" indent="yes"/> <xsl:template match="/"> <xsl:apply-templates select="gif"/> </xsl:template> <xsl:template match="gif"> <gifdata> <xsl:value-of select="."/> </gifdata> </xsl:template> </xsl:stylesheet>
*my expected xml ouput :
<?xml version="1.0" encoding="UTf-8"?>
<gifdata>
R0lGODlhtgCIAOcAAP///4CAgIiIiGhoYFBQSKioiCgoKCAgGBAICCgoIPD4+Hh4eAAAAKCggHh4 cIiIgCAgIDAwKBgQEHBwaJiYeICAcPDw8JiYgJCQiAgICHBwcGBgWJCQkDAoIICAeBgYEFBQQEhQ </gifdata>
I have this xml file (generated from Lotus Domino 6) and would like to transform it to a simpler one by extracting only data between the gif tag (I cut the gif data to reduce the file here); I wrote an xls to do it to transform the xml file. What am I doing wrong ? because what I get is all the data in the xml file instead of my expected output file
Need your help
Ndeye, a new "xslter"
*my xml input file :
<?xml version="1.0" ?>
<!DOCTYPE document (View Source for full doctype...)>
- <document xmlns="http://www.lotus.com/dxl" version="6.5" replicaid="C1256DC700510DFF" form="Person" response="false" conflict="false"> + <noteinfo noteid="356e" unid="60C4C68E08994352C1256E00003026AB" sequence="2"> + <updatedby> + <item name="full_name" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false">
- <item name="Picture" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false">
- <richtext>
- <pardef id="1" leftmargin="1%" rightmargin="99%" keeptogether="true" align="left" linespacing="1" spacebefore="1" spaceafter="1" newpage="false" list="none" readingorder="lefttoright">
- <code event="hidewhen">
<formula>(!@IsDocBeingEdited &
NoPhotoThanks="NoPhoto")|(@IsDocBeingEdited & isweb)</formula> </code> </pardef>
- <par def="1">
- <picture width="182px" height="136px" align="baseline"> <gif>R0lGODlhtgCIAOcAAP///4CAgIiIiGhoYFBQSKioiCgoKCAgGBAICCgoIPD4+Hh4eAAAAKCggHh4 cIiIgCAgIDAwKBgQEHBwaJiYeICAcPDw8JiYgJCQiAgICHBwcGBgWJCQkDAoIICAeBgYEFBQQEhQ</gif> </picture> </par> <par /> </richtext> </item> + <item name="jobdescrip_me" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false"> + <item name="Phone_Me" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false"> + <item name="EMail_me" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false"> + <item name="ShowHasPic" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false"> + <item name="$Revisions" sign="false" seal="false" sealed="false" authors="false" names="false" readers="false" placeholder="false"> </document>
*my xsl input file :
<?xml version="1.0" encoding="UTf-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl
*my expected xml ouput :
<?xml version="1.0" encoding="UTf-8"?>
<gifdata>
R0lGODlhtgCIAOcAAP///4CAgIiIiGhoYFBQSKioiCgoKCAgGBAICCgoIPD4+Hh4eAAAAKCggHh4 cIiIgCAgIDAwKBgQEHBwaJiYeICAcPDw8JiYgJCQiAgICHBwcGBgWJCQkDAoIICAeBgYEFBQQEhQ </gifdata>