small question about <xml:if>

[ina]

Hello guys,

My name is ina and I have a problem with a file xlst. I am newbie and
sorry for this question, probably must be very simple.

I have this xml file

<?xml version="1.0"?>
<Datasource>
<cars><car><car _Short_Name>OPE L</car_Short_Name> <car_Contracts> <CtoF_Contrac t
From_Date="" To_Date="">
<CtoF_Contract_ Type Type="Administr ator"/>
<Company_FID>Co mpany_204736</Company_FID>
</CtoF_Contract>
</car_Contracts>
<car_Contracts> <CtoF_Contrac t From_Date="" To_Date="">
<CtoF_Contract_ Type Type="Firm"/>
<Company_FID>Co mpany_204730</Company_FID>
</CtoF_Contract>
</car_Contracts>
</car>
</cars><Companies >
<Company>
<Company_FID>Co mpany_204730</Company_FID>
<Company_Legal_ Name From_Date="" To_Date="">
<Company_Name>H HLXC Management AG</Company_Name>
<Legal_Type>Unk nown</Legal_Type>
</Company_Legal_N ame>
<Legal_Domici le From_Date="" To_Date="">
<Country>CH</Country>
</Legal_Domicile>
<Web_Site From_Date="" To_Date="">www. company.com</Web_Site>
<Site Main="Yes">
<Address From_Date="" To_Date="">
<Street>Caill e</Street>
<City>Mexico city</City>
<ZIP_City>6301f f</ZIP_City>
<Country>Mexico </Country>
</Address>
<Site_Communica tion>
<Phone From_Date="" To_Date=""></Phone>
<Fax From_Date="" To_Date=""></Fax>
<E-mail From_Date="" To_Date=""></E-mail>
</Site_Communicat ion>
</Site>
<Site Main="No">
<Address From_Date="" To_Date="">
<Street></Street>
<City></City>
<ZIP_City></ZIP_City>
<State></State>
<Country></Country>
</Address>
<Site_Communica tion>
<Phone From_Date="" To_Date=""></Phone>
<Fax From_Date="" To_Date=""></Fax>
</Site_Communicat ion>
</Site>
</Company>
<Company>
<Company_FID>Co mpany_204736</Company_FID>
<Company_Legal_ Name From_Date="" To_Date="">
<Company_Name>H HC International, Ltd.</Company_Name>
<Legal_Type>Unk nown</Legal_Type>
</Company_Legal_N ame>
</Company>
</Companies></Datasource>

and I am trying to use in xlts <xml:if> but with no success. I would
like to do it is to find the company information for each company ID in
car and type of contract.

I would like to have these results with xlts

<cars>
<car_name>OPEL> </car_name>
<administrator> HHC International, Ltd</administrator>
<domicile></domicile>
<Firm>HHLXC Management AG</Firm>
<domicile>Mexic o</domicile>
</cars>

any suggestions

[ina]

this is the xlts:

<?xml version='1.0' ?>
<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<xsl:for-each select="Datasou rce/cars/car/car_Short_Name" >
<cars>
<xsl:value-of select="."/>
</cars>
</xsl:for-each>
<xsl:for-each
select="Datasou rce/cars/car/car_Contracts/CtoF_Contract/Company_FID">
<administrato r>
<xsl:if test=". = ../../../../../Companies/Company/Company_FID">
<xsl:value-of
select="../../../../../Companies/Company/Company_Legal_N ame/Company_Name"/>
</xsl:if>
</administrator>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

Ina
ina wrote:

Hello guys,

My name is ina and I have a problem with a file xlst. I am newbie and
sorry for this question, probably must be very simple.

I have this xml file

<?xml version="1.0"?>
<Datasource>
<cars><car><car _Short_Name>OPE L</car_Short_Name> <car_Contracts> <CtoF_Contrac t
From_Date="" To_Date="">
<CtoF_Contract_ Type Type="Administr ator"/>
<Company_FID>Co mpany_204736</Company_FID>
</CtoF_Contract>
</car_Contracts>
<car_Contracts> <CtoF_Contrac t From_Date="" To_Date="">
<CtoF_Contract_ Type Type="Firm"/>
<Company_FID>Co mpany_204730</Company_FID>
</CtoF_Contract>
</car_Contracts>
</car>
</cars><Companies >
<Company>
<Company_FID>Co mpany_204730</Company_FID>
<Company_Legal_ Name From_Date="" To_Date="">
<Company_Name>H HLXC Management AG</Company_Name>
<Legal_Type>Unk nown</Legal_Type>
</Company_Legal_N ame>
<Legal_Domici le From_Date="" To_Date="">
<Country>CH</Country>
</Legal_Domicile>
<Web_Site From_Date="" To_Date="">www. company.com</Web_Site>
<Site Main="Yes">
<Address From_Date="" To_Date="">
<Street>Caill e</Street>
<City>Mexico city</City>
<ZIP_City>6301f f</ZIP_City>
<Country>Mexico </Country>
</Address>
<Site_Communica tion>
<Phone From_Date="" To_Date=""></Phone>
<Fax From_Date="" To_Date=""></Fax>
<E-mail From_Date="" To_Date=""></E-mail>
</Site_Communicat ion>
</Site>
<Site Main="No">
<Address From_Date="" To_Date="">
<Street></Street>
<City></City>
<ZIP_City></ZIP_City>
<State></State>
<Country></Country>
</Address>
<Site_Communica tion>
<Phone From_Date="" To_Date=""></Phone>
<Fax From_Date="" To_Date=""></Fax>
</Site_Communicat ion>
</Site>
</Company>
<Company>
<Company_FID>Co mpany_204736</Company_FID>
<Company_Legal_ Name From_Date="" To_Date="">
<Company_Name>H HC International, Ltd.</Company_Name>
<Legal_Type>Unk nown</Legal_Type>
</Company_Legal_N ame>
</Company>
</Companies></Datasource>

and I am trying to use in xlts <xml:if> but with no success. I would
like to do it is to find the company information for each company ID in
car and type of contract.

I would like to have these results with xlts

<cars>
<car_name>OPEL> </car_name>
<administrator> HHC International, Ltd</administrator>
<domicile></domicile>
<Firm>HHLXC Management AG</Firm>
<domicile>Mexic o</domicile>
</cars>

any suggestions

[Andy Dingley]

ina wrote:

like to do it is to find the company information for each company ID in
car and type of contract.

Try this. It's not great code, but it should be readable. Making it
better would need more information, particularly about error handling,
handling changes of address etc. It could get to be quite complex.

The XML schema is also less well-designed than it could be. Be generous
with container elements to wrap up related items, be careful with case,
be careful with plurals
<xsl:output method ="xml" indent="yes" />

<xsl:template match="/">

<cars>
<xsl:for-each select="/Datasource/cars/car">
<!--
You'd be better with a <car> container element here
<car>
-->
<car_name><xsl: value-of select="./car_Short_Name"
/></car_name>
<xsl:for-each select="./car_Contracts">
<xsl:variable name="contract" select="." />
<xsl:variable name="contract-type"
select="$contra ct/CtoF_Contract/CtoF_Contract_T ype/@Type" />
<xsl:variable name="company"
select="/Datasource/Companies/Company [Company_FID =
$contract/CtoF_Contract/Company_FID] " />

<xsl:choose>
<xsl:when test="$contract-type = 'Administrator' " >
<administrator> <xsl:value-of
select="$compan y/Company_Legal_N ame/Company_Name" /></administrator>
</xsl:when>

<xsl:when test="$contract-type = 'Firm'" >
<Firm><xsl:valu e-of select="$compan y/Company_Legal_N ame/Company_Name"
/></Firm>
</xsl:when>
</xsl:choose>

<domicile><xsl: value-of select="$compan y/Site [@Main='Yes']
/Address/Country" /></domicile>
</xsl:for-each>

<!-- </car> -->
</xsl:for-each>
</cars>
</xsl:template>

[ina]

Andy Dingley <di*****@codesm iths.com> wrote:

ina wrote:

like to do it is to find the company information for each company ID in
car and type of contract.

Try this. It's not great code, but it should be readable. Making it
better would need more information, particularly about error handling,
handling changes of address etc. It could get to be quite complex.

The XML schema is also less well-designed than it could be. Be generous
with container elements to wrap up related items, be careful with case,
be careful with plurals
<xsl:output method ="xml" indent="yes" />

<xsl:template match="/">

<cars>
<xsl:for-each select="/Datasource/cars/car">
<!--
You'd be better with a <car> container element here
<car>
-->
<car_name><xsl: value-of select="./car_Short_Name"
/></car_name>
<xsl:for-each select="./car_Contracts">
<xsl:variable name="contract" select="." />
<xsl:variable name="contract-type"
select="$contra ct/CtoF_Contract/CtoF_Contract_T ype/@Type" />
<xsl:variable name="company"
select="/Datasource/Companies/Company [Company_FID =
$contract/CtoF_Contract/Company_FID] " />

<xsl:choose>
<xsl:when test="$contract-type = 'Administrator' " >
<administrator> <xsl:value-of
select="$compan y/Company_Legal_N ame/Company_Name" /></administrator>
</xsl:when>

<xsl:when test="$contract-type = 'Firm'" >
<Firm><xsl:valu e-of select="$compan y/Company_Legal_N ame/Company_Name"
/></Firm>
</xsl:when>
</xsl:choose>

<domicile><xsl: value-of select="$compan y/Site [@Main='Yes']
/Address/Country" /></domicile>
</xsl:for-each>

<!-- </car> -->
</xsl:for-each>
</cars>
</xsl:template>

[ina]

Thanks Andy. It is a great help :D

I am newbie in XML and I do not know the grammar very well.
I will try it.
Thanks

Ina
Andy Dingley <di*****@codesm iths.com> wrote:

ina wrote:

like to do it is to find the company information for each company ID in
car and type of contract.

Try this. It's not great code, but it should be readable. Making it
better would need more information, particularly about error handling,
handling changes of address etc. It could get to be quite complex.

The XML schema is also less well-designed than it could be. Be generous
with container elements to wrap up related items, be careful with case,
be careful with plurals
<xsl:output method ="xml" indent="yes" />

<xsl:template match="/">

<cars>
<xsl:for-each select="/Datasource/cars/car">
<!--
You'd be better with a <car> container element here
<car>
-->
<car_name><xsl: value-of select="./car_Short_Name"
/></car_name>
<xsl:for-each select="./car_Contracts">
<xsl:variable name="contract" select="." />
<xsl:variable name="contract-type"
select="$contra ct/CtoF_Contract/CtoF_Contract_T ype/@Type" />
<xsl:variable name="company"
select="/Datasource/Companies/Company [Company_FID =
$contract/CtoF_Contract/Company_FID] " />

<xsl:choose>
<xsl:when test="$contract-type = 'Administrator' " >
<administrator> <xsl:value-of
select="$compan y/Company_Legal_N ame/Company_Name" /></administrator>
</xsl:when>

<xsl:when test="$contract-type = 'Firm'" >
<Firm><xsl:valu e-of select="$compan y/Company_Legal_N ame/Company_Name"
/></Firm>
</xsl:when>
</xsl:choose>

<domicile><xsl: value-of select="$compan y/Site [@Main='Yes']
/Address/Country" /></domicile>
</xsl:for-each>

<!-- </car> -->
</xsl:for-each>
</cars>
</xsl:template>

[ina]

Thanks Andy. It is a great help :D

I am newbie in XML and I do not know the grammar very well.
I will try it.
Thanks

Ina
Andy Dingley <di*****@codesm iths.com> wrote:

ina wrote:

like to do it is to find the company information for each company ID in
car and type of contract.

Try this. It's not great code, but it should be readable. Making it
better would need more information, particularly about error handling,
handling changes of address etc. It could get to be quite complex.

The XML schema is also less well-designed than it could be. Be generous
with container elements to wrap up related items, be careful with case,
be careful with plurals
<xsl:output method ="xml" indent="yes" />

<xsl:template match="/">

<cars>
<xsl:for-each select="/Datasource/cars/car">
<!--
You'd be better with a <car> container element here
<car>
-->
<car_name><xsl: value-of select="./car_Short_Name"
/></car_name>
<xsl:for-each select="./car_Contracts">
<xsl:variable name="contract" select="." />
<xsl:variable name="contract-type"
select="$contra ct/CtoF_Contract/CtoF_Contract_T ype/@Type" />
<xsl:variable name="company"
select="/Datasource/Companies/Company [Company_FID =
$contract/CtoF_Contract/Company_FID] " />

<xsl:choose>
<xsl:when test="$contract-type = 'Administrator' " >
<administrator> <xsl:value-of
select="$compan y/Company_Legal_N ame/Company_Name" /></administrator>
</xsl:when>

<xsl:when test="$contract-type = 'Firm'" >
<Firm><xsl:valu e-of select="$compan y/Company_Legal_N ame/Company_Name"
/></Firm>
</xsl:when>
</xsl:choose>

<domicile><xsl: value-of select="$compan y/Site [@Main='Yes']
/Address/Country" /></domicile>
</xsl:for-each>

<!-- </car> -->
</xsl:for-each>
</cars>
</xsl:template>