473,387 Members | 1,799 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Copy XML and Change Element Value using XSLT

hi,

I have a xml in which I want to replace the element(s) value with XSLT

Xml message

Expand|Select|Wrap|Line Numbers
  1. <Message>
  2. <case>
  3. <party1>
  4. <!--  there are other elements -->
  5. <notes id="1">abcd</notes>
  6. <notes id="2">abcd</notes>
  7. <notes id="3">abcd</notes>
  8.    -----
  9.  
  10. <notes id=n>some text</notes>
  11. </party1>
  12.  
  13. <party2>
  14. <!--  there are other elements -->
  15. <notes id="1">abcd</notes>
  16. <notes id="2">abcd</notes>
  17. <notes id="3">abcd</notes>
  18.    -----
  19.  
  20. <notes id=n>some text</notes>
  21. </party2>
  22.  
  23. <client1>
  24.  
  25. <!--  there are other elements -->
  26. <notes id="1">abcd</notes>
  27. <notes id="2">some text</notes>
  28. <notes id="3">some text</notes>
  29.    -----
  30.  
  31. <notes id="n">some text</notes>
  32.  
  33. </client1>
  34.  
  35. <client2>
  36.  
  37. <!--  there are other elements -->
  38. <notes id="1">some text</notes>
  39. <notes id="2">some text</notes>
  40. <notes id="3">some text</notes>
  41.    -----
  42.  
  43. <notes id="n">some text</notes>
  44.  
  45. </client2>
  46.  
  47.  
  48. </case>
  49. </Message>
From the above xml I want to copy all the elements to another xml but, I want to modify the values <notes> element to some other value.

I have managed to construct a XSL like this.

XSL :
Expand|Select|Wrap|Line Numbers
  1. <?xml version='1.0' encoding='ISO-8859-1'?> 
  2. <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> 
  3. <xsl:output method="xml" indent="yes"/>
  4. <xsl:strip-space elements="*"/>
  5. <xsl:key name="nvalue" match="notes" use="text()"/>
  6.  
  7. <xsl:template match="node()">
  8.         <xsl:copy>
  9.                 <xsl:copy-of select="@*"/>
  10.          <xsl:apply-templates select="node()"/>
  11.         </xsl:copy>
  12. </xsl:template>
  13.  
  14. <xsl:apply-templates select="notes"/>
  15.  
  16. <xsl:template match="notes">
  17. <notes>replace notes</notes>
  18. </xsl:template>
  19.  
  20. </xsl:stylesheet>
please help me with the XSL

Many thanks in advance
Oct 3 '08 #1
4 29220
Dormilich
8,658 Expert Mod 8TB
What's the problem? It's working as you intend (...once you correct the xml (it's not well-formed)—put the attribute values in quotes)

regards
Oct 3 '08 #2
jkmyoung
2,057 Expert 2GB
Well, from your code you'd be missing the id attributes on notes nodes. Is that the problem?

Could change your notes template accordingly.
Expand|Select|Wrap|Line Numbers
  1. <xsl:template match="notes"> 
  2.         <xsl:copy> 
  3.                 <xsl:copy-of select="@*"/> 
  4.                 <xsl:text>replace notes</xsl:text>
  5.         </xsl:copy> 
  6. </xsl:template> 
  7.  
<xsl:copy-of select="@*"/> is the line that would copy the id attributes.
Oct 3 '08 #3
Thank you very much for point it out !! Yes I'm missing the @ attribute template. I have corrected it. like this.



Expand|Select|Wrap|Line Numbers
  1. <?xml version="1.0"?>
  2. <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  3.     <xsl:template match="*">
  4.         <xsl:copy>
  5.             <xsl:apply-templates select="@*|*|text()"/>
  6.         </xsl:copy>
  7.     </xsl:template>
  8.     <xsl:template match="notes">
  9.         <notes><xsl:apply-templates select="@*"/>replaced Value</notes>
  10.     </xsl:template>
  11.  
  12.     <xsl:template match="@*|text()">
  13.         <xsl:copy/>
  14.     </xsl:template>
  15.  
  16. </xsl:stylesheet>
But, I'm getting another issue it not working on the xml on which I intend to work
please let me know if changes for my XSL on below XML


Expand|Select|Wrap|Line Numbers
  1. <?xml version="1.0"?>
  2. <message xmlns="somexsd">
  3.   <control sequence_id="1">
  4.     <msg_type>kFSM</msg_type>
  5.     <msg_version>1.1.1</msg_version>
  6.   </control>
  7.   <case id="TEST" type="Personal">
  8.     <party id="Client" sequence_number="1" type="Client">
  9.       <title>Col</title>
  10.       <forename>Sdfasd</forename>
  11.       <surname>jsdfgsdf</surname>
  12.       <known_as>Col Sdfasd Jsdfgsdf</known_as>
  13.       <full_name>Col Sdfasd jsdfgsdf</full_name>
  14.       <notes type="Personal" />
  15.       <notes type="Contact" />
  16.       <notes type="NDI changes" />
  17.       <notes type="Income Summary" />
  18.       <notes type="Earned income" />
  19.       <notes type="Other income" />
  20.       <notes type="Employee benefits" />
  21.       <contact>
  22.         <address>
  23.           <house_name_number />
  24.           <line_1 />
  25.           <line_2 />
  26.           <line_3 />
  27.           <line_4 />
  28.           <postcode />
  29.         </address>
  30.         <telephone type="daytime">
  31.           <number />
  32.         </telephone>
  33.         <telephone type="evening">
  34.           <number />
  35.         </telephone>
  36.         <telephone type="mobile">
  37.           <number />
  38.         </telephone>
  39.         <email>
  40.           <address />
  41.         </email>
  42.         <best_time />
  43.       </contact>
  44.       <date_of_birth />
  45.       <nationality>GBR</nationality>
  46.       <national_insurance_number />
  47.       <health>
  48.         <notes type="Health" />
  49.       </health>
  50.       <relationship_to />
  51.       <residential_status />
  52.       <highest_tax_rate />
  53.       <employment sequence_number="1">
  54.         <earnings type="Basic">
  55.           <frequency>Annually</frequency>
  56.         </earnings>
  57.         <earnings type="Bonus">
  58.           <frequency>Annually</frequency>
  59.         </earnings>
  60.         <earnings type="Payslip">
  61.           <frequency>Monthly</frequency>
  62.         </earnings>
  63.         <start_date />
  64.       </employment>
  65.       <employment sequence_number="2">
  66.         <earnings type="Basic">
  67.           <frequency>Annually</frequency>
  68.         </earnings>
  69.         <earnings type="Bonus">
  70.           <frequency>Annually</frequency>
  71.         </earnings>
  72.         <earnings type="Total">
  73.           <frequency>Monthly</frequency>
  74.         </earnings>
  75.       </employment>
  76.       <employment sequence_number="3">
  77.         <benefit type="Death in service" />
  78.         <benefit type="Dependants pension" />
  79.         <benefit type="Sickness period 1">
  80.           <duration />
  81.           <earnings_related />
  82.         </benefit>
  83.         <benefit type="Sickness period 2">
  84.           <duration />
  85.           <earnings_related />
  86.         </benefit>
  87.       </employment>
  88.       <income sequence_number="1" type="Agreed investment and asset">
  89.         <amount_net />
  90.         <frequency>Monthly</frequency>
  91.       </income>
  92.       <income sequence_number="9" type="Other Total" />
  93.       <income type="State benefits">
  94.         <amount_net />
  95.         <frequency>Monthly</frequency>
  96.       </income>
  97.       <income sequence_number="1" type="Earned">
  98.         <amount_gross />
  99.         <frequency>Annually</frequency>
  100.       </income>
  101.       <income sequence_number="1" type="Earned and Other">
  102.         <amount_net>0</amount_net>
  103.         <frequency>Monthly</frequency>
  104.       </income>
  105.       <income sequence_number="1" type="Other">
  106.         <frequency>Monthly</frequency>
  107.         <income_ind />
  108.       </income>
  109.       <income sequence_number="2" type="Other">
  110.         <frequency>Monthly</frequency>
  111.         <income_ind />
  112.       </income>
  113.       <income sequence_number="3" type="Other">
  114.         <frequency>Monthly</frequency>
  115.         <income_ind />
  116.       </income>
  117.       <income sequence_number="4" type="Other">
  118.         <frequency>Monthly</frequency>
  119.         <income_ind />
  120.       </income>
  121.       <income sequence_number="5" type="Other">
  122.         <frequency>Monthly</frequency>
  123.         <income_ind />
  124.       </income>
  125.       <income sequence_number="6" type="Other">
  126.         <frequency>Monthly</frequency>
  127.       </income>
  128.       <expenditure type="Agreed general">
  129.         <amount />
  130.       </expenditure>
  131.       <expenditure type="Agreed mortgage">
  132.         <amount />
  133.       </expenditure>
  134.       <expenditure type="Agreed liability">
  135.         <amount />
  136.       </expenditure>
  137.       <expenditure type="Agreed protection policy">
  138.         <amount />
  139.       </expenditure>
  140.       <expenditure type="Agreed investment policy">
  141.         <amount />
  142.       </expenditure>
  143.       <expenditure type="Rent">
  144.         <amount />
  145.       </expenditure>
  146.       <expenditure type="Council tax">
  147.         <amount />
  148.       </expenditure>
  149.       <expenditure type="Utilities">
  150.         <amount />
  151.       </expenditure>
  152.       <expenditure type="Telephone">
  153.         <amount />
  154.       </expenditure>
  155.       <expenditure type="Food">
  156.         <amount />
  157.       </expenditure>
  158.       <expenditure type="Travel">
  159.         <amount />
  160.       </expenditure>
  161.       <expenditure type="Leisure">
  162.         <amount />
  163.       </expenditure>
  164.       <expenditure type="General insurance">
  165.         <amount />
  166.       </expenditure>
  167.       <expenditure type="Estimated">
  168.         <amount />
  169.       </expenditure>
  170.       <expenditure type="General total">
  171.         <amount>0</amount>
  172.       </expenditure>
  173.       <affordability type="Net disposable income">
  174.         <amount>0</amount>
  175.       </affordability>
  176.       <affordability type="Prepared to spend">
  177.         <amount />
  178.       </affordability>
  179.       <affordability type="Lumpsums">
  180.         <information_ind code="" type="Available lump sums" />
  181.       </affordability>
  182.       <retirement>
  183.         <company_pension>
  184.           <future_joining_date />
  185.         </company_pension>
  186.         <information_ind type="Divorced Pension" code="" />
  187.       </retirement>
  188.       <investment />
  189.       <estate>
  190.         <notes type="Steps taken" />
  191.         <notes type="Will restructure" />
  192.         <notes type="Use of trusts" />
  193.         <notes type="Making gifts" />
  194.         <notes type="Funding life assurance" />
  195.         <notes type="Equalising estate" />
  196.       </estate>
  197.       <need type="Critical Illness">
  198.         <in_scope_ind code="Y">Yes</in_scope_ind>
  199.         <description>A cash sum if critically ill</description>
  200.         <required type="Lump sum">
  201.           <amount />
  202.         </required>
  203.         <required type="Future liabilities">
  204.           <amount />
  205.         </required>
  206.         <required type="Extra living costs">
  207.           <amount />
  208.         </required>
  209.         <required type="Total">
  210.           <amount>0</amount>
  211.         </required>
  212.         <duration>
  213.           <years />
  214.         </duration>
  215.         <existing_provision type="CI policies" />
  216.         <existing_provision type="Investments" />
  217.         <existing_provision type="Other capital" />
  218.         <existing_provision type="Total">0</existing_provision>
  219.         <shortfall>0</shortfall>
  220.         <attitude_to_risk />
  221.       </need>
  222.       <need type="Family Protection Income">
  223.         <in_scope_ind code="N">No</in_scope_ind>
  224.         <description>Providing an income for Dependants on death</description>
  225.         <required type="Income" />
  226.         <required type="Lump sum" />
  227.         <duration>
  228.           <whole_of_life_ind />
  229.         </duration>
  230.         <existing_provision type="Life policies lump sums" />
  231.         <existing_provision type="Investment lump sums" />
  232.         <existing_provision type="Other capital" />
  233.         <existing_provision type="Death in service" />
  234.         <existing_provision type="Total lump sums" />
  235.         <existing_provision type="Life policies income" />
  236.         <existing_provision type="Investment income" />
  237.         <existing_provision type="Dependants pension" />
  238.         <existing_provision type="State Benefits" />
  239.         <existing_provision type="Total income" />
  240.         <shortfall type="Income" />
  241.         <shortfall type="Lump sum" />
  242.       </need>
  243.       <need type="Family Protection Lumpsum">
  244.         <in_scope_ind code="N">No</in_scope_ind>
  245.         <description>Providing a Capital sum on death</description>
  246.         <required type="Lump sum" />
  247.         <duration>
  248.           <whole_of_life_ind />
  249.         </duration>
  250.       </need>
  251.       <need type="Disability">
  252.         <in_scope_ind code="N">No</in_scope_ind>
  253.         <description>An income if ill or disabled</description>
  254.         <required />
  255.         <deferred_period />
  256.         <duration />
  257.         <existing_provision type="Emp benefits tp 4 weeks" />
  258.         <existing_provision type="PHI policies to 4 weeks" />
  259.         <existing_provision type="Emp benefits to 13 weeks" />
  260.         <existing_provision type="PHI policies to 13 weeks" />
  261.         <existing_provision type="Emp benefits to 26 weeks" />
  262.         <existing_provision type="PHI policies to 26 weeks" />
  263.         <existing_provision type="Emp benefits to 52 weeks" />
  264.         <existing_provision type="PHI policies to 52 weeks" />
  265.         <existing_provision type="Emp benefits to expiry" />
  266.         <existing_provision type="PHI policies to expiry" />
  267.         <shortfall type="To expiry" />
  268.       </need>
  269.       <need type="Mortgage/Loans">
  270.         <in_scope_ind code="N">No</in_scope_ind>
  271.         <description>Protection for your Mortgage/Loans</description>
  272.         <required type="Mortgages/Loans" />
  273.         <required type="Liabilities" />
  274.         <required type="Total" />
  275.         <duration />
  276.         <existing_provision type="Sums Assured" />
  277.         <existing_provision type="CI benefits" />
  278.         <existing_provision type="Other capital" />
  279.         <existing_provision type="Total on death" />
  280.         <existing_provision type="Total on critical illness" />
  281.         <shortfall type="On death" />
  282.         <shortfall type="On critical illness" />
  283.       </need>
  284.       <need type="Family Protection">
  285.         <in_scope_ind code="N">No</in_scope_ind>
  286.       </need>
  287.       <need type="Retirement Income">
  288.         <in_scope_ind code="Y">Yes</in_scope_ind>
  289.         <description>Improving retirement income</description>
  290.         <required />
  291.         <notes type="Transitional Protection" />
  292.         <notes type="Certificate Details" />
  293.         <notes type="ASP Details" />
  294.         <information_ind type="Transitional Protection" />
  295.         <information_ind type="Someone else ASP" />
  296.       </need>
  297.       <need type="Long Term Care">
  298.         <in_scope_ind code="Y">Yes</in_scope_ind>
  299.         <description>Long term care</description>
  300.         <required type="Cost of care">
  301.           <amount>20000</amount>
  302.         </required>
  303.         <required type="Partner Income">
  304.           <amount />
  305.         </required>
  306.         <existing_provision type="Investment Income">0</existing_provision>
  307.         <existing_provision type="Pension Income">0</existing_provision>
  308.         <existing_provision type="State Benefits" />
  309.         <shortfall>20000</shortfall>
  310.         <attitude_to_risk />
  311.       </need>
  312.       <need type="IHT first death">
  313.         <in_scope_ind code="N">No</in_scope_ind>
  314.         <description>Inheritance tax planning 1st Death</description>
  315.         <existing_provision type="Non exempt gifts" />
  316.         <existing_provision type="Non exempt trust money" />
  317.         <existing_provision type="Partner assets" />
  318.         <existing_provision type="IHT exemptions" />
  319.         <existing_provision type="Total estate" />
  320.         <existing_provision type="Tax free estate" />
  321.         <existing_provision type="Taxable estate" />
  322.         <shortfall type="IHT first death" />
  323.         <notes type="Non exempt gifts" />
  324.         <notes type="Non exempt trust money" />
  325.         <notes type="IHT exemptions" />
  326.       </need>
  327.       <need type="IHT second death">
  328.         <in_scope_ind code="N">No</in_scope_ind>
  329.         <description>Inheritance tax planning 2nd Death</description>
  330.         <existing_provision type="Non exempt gifts" />
  331.         <existing_provision type="Non exempt trust money" />
  332.         <existing_provision type="Sums liable" />
  333.         <existing_provision type="IHT exemptions" />
  334.         <existing_provision type="Total estate" />
  335.         <existing_provision type="Tax free estate" />
  336.         <existing_provision type="Taxable estate" />
  337.         <shortfall type="IHT second death" />
  338.         <notes type="IHT exemptions" />
  339.         <notes type="Sums liable" />
  340.       </need>
  341.       <need type="Investments">
  342.         <in_scope_ind code="N">No</in_scope_ind>
  343.         <description>Review your lump sum investment options</description>
  344.         <required type="Income" />
  345.         <deferred_period />
  346.         <duration />
  347.         <existing_provision type="Agreed investment amount" />
  348.         <commitment type="Planned expenditure" />
  349.         <commitment type="Debt repayment" />
  350.         <commitment type="Client pension" />
  351.         <commitment type="Cash reserve" />
  352.         <commitment type="Total" />
  353.         <commitment type="Available to invest" />
  354.         <notes type="Investment reason" />
  355.         <notes type="Goals not achieved" />
  356.         <notes type="Income reason" />
  357.         <notes type="Agreed investment source" />
  358.       </need>
  359.       <need type="Savings">
  360.         <in_scope_ind code="N">No</in_scope_ind>
  361.         <description>Saving for that special occasion</description>
  362.         <commitment type="Prepared to save" />
  363.         <notes type="Savings reason" />
  364.         <notes type="Savings other reason" />
  365.       </need>
  366.       <need type="LTC Calculator">
  367.         <in_scope_ind code="N">No</in_scope_ind>
  368.         <required type="Cost of care" />
  369.         <required type="Partner Income" />
  370.         <existing_provision type="Investment Income" />
  371.         <existing_provision type="Pension Income" />
  372.         <existing_provision type="State Benefits" />
  373.         <shortfall />
  374.       </need>
  375.       <need type="Replacement policy">
  376.         <notes type="Policy details" />
  377.         <notes type="Reason" />
  378.         <notes type="Consequences" />
  379.         <notes type="Other options" />
  380.       </need>
  381.       <customer_reference_number />
  382.       <CIS_number />
  383.       <proof_of_identity>
  384.         <id_verification />
  385.         <address_verification />
  386.         <document type="Customer ID">
  387.           <date type="Issue/Expiry" />
  388.         </document>
  389.         <document type="Address ID">
  390.           <date type="Issue/Expiry" />
  391.         </document>
  392.         <notes type="ID Benefit type" />
  393.         <notes type="Other ID Benefit type" />
  394.         <notes type="Address" />
  395.         <notes type="Other address verification" />
  396.         <notes type="Address Benefit type" />
  397.         <notes type="Other address benefit type" />
  398.         <notes type="Proof of Identity" />
  399.         <date_obtained>
  400.           <date />
  401.         </date_obtained>
  402.       </proof_of_identity>
  403.       <information_ind type="Accounts" />
  404.       <information_ind type="Fixed interest" />
  405.       <information_ind type="Cash ISAs" />
  406.       <information_ind type="Equity ISAs" />
  407.       <information_ind type="Shares" />
  408.       <information_ind type="Bonds" />
  409.       <information_ind type="Unit trusts" />
  410.       <information_ind type="Annuities" />
  411.       <information_ind type="Various" />
  412.       <notes type="Investment ISA Cash amount" />
  413.     </party>
  414.     <party id="Partner" sequence_number="2" type="Partner">
  415.       <full_name />
  416.       <notes type="Personal" />
  417.       <notes type="Contact" />
  418.       <notes type="Income Summary" />
  419.       <notes type="Earned income" />
  420.       <notes type="Other income" />
  421.       <notes type="Employee benefits" />
  422.       <contact>
  423.         <address />
  424.         <telephone type="daytime" />
  425.         <telephone type="evening" />
  426.         <telephone type="mobile" />
  427.         <email />
  428.         <same_as />
  429.       </contact>
  430.       <nationality />
  431.       <health>
  432.         <notes type="Health" />
  433.       </health>
  434.       <employment sequence_number="1">
  435.         <earnings type="Basic">
  436.           <frequency>Annually</frequency>
  437.         </earnings>
  438.         <earnings type="Bonus">
  439.           <frequency>Annually</frequency>
  440.         </earnings>
  441.         <earnings type="Payslip">
  442.           <frequency>Monthly</frequency>
  443.         </earnings>
  444.         <start_date />
  445.       </employment>
  446.       <employment sequence_number="2">
  447.         <earnings type="Basic">
  448.           <frequency>Annually</frequency>
  449.         </earnings>
  450.         <earnings type="Bonus">
  451.           <frequency>Annually</frequency>
  452.         </earnings>
  453.         <earnings type="Total">
  454.           <frequency>Monthly</frequency>
  455.         </earnings>
  456.       </employment>
  457.       <employment sequence_number="3">
  458.         <benefit type="Death in service" />
  459.         <benefit type="Dependants pension" />
  460.         <benefit type="Sickness period 1">
  461.           <duration />
  462.           <earnings_related />
  463.         </benefit>
  464.         <benefit type="Sickness period 2">
  465.           <duration />
  466.           <earnings_related />
  467.         </benefit>
  468.       </employment>
  469.       <income sequence_number="1" type="Agreed investment and asset">
  470.         <frequency>Monthly</frequency>
  471.       </income>
  472.       <income sequence_number="9" type="Other Total" />
  473.       <income type="State benefits">
  474.         <frequency>Monthly</frequency>
  475.       </income>
  476.       <income sequence_number="1" type="Earned">
  477.         <frequency>Annually</frequency>
  478.       </income>
  479.       <income sequence_number="1" type="Earned and Other">
  480.         <frequency>Monthly</frequency>
  481.       </income>
  482.       <income sequence_number="1" type="Other">
  483.         <frequency>Monthly</frequency>
  484.         <income_ind />
  485.       </income>
  486.       <income sequence_number="2" type="Other">
  487.         <frequency>Monthly</frequency>
  488.         <income_ind />
  489.       </income>
  490.       <income sequence_number="3" type="Other">
  491.         <frequency>Monthly</frequency>
  492.         <income_ind />
  493.       </income>
  494.       <income sequence_number="4" type="Other">
  495.         <frequency>Monthly</frequency>
  496.         <income_ind />
  497.       </income>
  498.       <income sequence_number="5" type="Other">
  499.         <frequency>Monthly</frequency>
  500.         <income_ind />
  501.       </income>
  502.       <income sequence_number="6" type="Other">
  503.         <frequency>Monthly</frequency>
  504.       </income>
  505.       <expenditure type="Agreed general" />
  506.       <expenditure type="Agreed mortgage" />
  507.       <expenditure type="Agreed liability" />
  508.       <expenditure type="Agreed protection policy" />
  509.       <expenditure type="Agreed investment policy" />
  510.       <expenditure type="Rent" />
  511.       <expenditure type="Council tax" />
  512.       <expenditure type="Utilities" />
  513.       <expenditure type="Telephone" />
  514.       <expenditure type="Food" />
  515.       <expenditure type="Travel" />
  516.       <expenditure type="Leisure" />
  517.       <expenditure type="General insurance" />
  518.       <expenditure type="Estimated" />
  519.       <expenditure type="General total" />
  520.       <affordability type="Net disposable income" />
  521.       <retirement>
  522.         <company_pension>
  523.           <future_joining_date />
  524.         </company_pension>
  525.         <information_ind type="Divorced Pension" />
  526.       </retirement>
  527.       <investment />
  528.       <estate>
  529.         <notes type="Steps taken" />
  530.         <notes type="Will restructure" />
  531.         <notes type="Use of trusts" />
  532.         <notes type="Making gifts" />
  533.         <notes type="Funding life assurance" />
  534.         <notes type="Equalising estate" />
  535.       </estate>
  536.       <need type="Critical Illness">
  537.         <in_scope_ind code="N">No</in_scope_ind>
  538.         <description>A cash sum if critically ill</description>
  539.         <required type="Lump sum" />
  540.         <required type="Future liabilities" />
  541.         <required type="Extra living costs" />
  542.         <required type="Total" />
  543.         <duration />
  544.         <existing_provision type="CI policies" />
  545.         <existing_provision type="Investments" />
  546.         <existing_provision type="Other capital" />
  547.         <existing_provision type="Total" />
  548.         <shortfall />
  549.       </need>
  550.       <need type="Family Protection Income">
  551.         <in_scope_ind code="N">No</in_scope_ind>
  552.         <description>Providing an income for Dependants on death</description>
  553.         <required type="Income" />
  554.         <required type="Lump sum" />
  555.         <duration>
  556.           <whole_of_life_ind />
  557.         </duration>
  558.         <existing_provision type="Life policies lump sums" />
  559.         <existing_provision type="Investment lump sums" />
  560.         <existing_provision type="Other capital" />
  561.         <existing_provision type="Death in service" />
  562.         <existing_provision type="Total lump sums" />
  563.         <existing_provision type="Life policies income" />
  564.         <existing_provision type="Investment income" />
  565.         <existing_provision type="Dependants pension" />
  566.         <existing_provision type="State Benefits" />
  567.         <existing_provision type="Total income" />
  568.         <shortfall type="Income" />
  569.         <shortfall type="Lump sum" />
  570.       </need>
  571.       <need type="Family Protection Lumpsum">
  572.         <in_scope_ind code="N">No</in_scope_ind>
  573.         <description>Providing a Capital sum on death</description>
  574.         <required type="Lump sum" />
  575.         <duration>
  576.           <whole_of_life_ind />
  577.         </duration>
  578.       </need>
  579.       <need type="Disability">
  580.         <in_scope_ind code="N">No</in_scope_ind>
  581.         <description>An income if ill or disabled</description>
  582.         <required />
  583.         <deferred_period />
  584.         <duration />
  585.         <existing_provision type="Emp benefits to 4 weeks" />
  586.         <existing_provision type="PHI policies to 4 weeks" />
  587.         <existing_provision type="Emp benefits to 13 weeks" />
  588.         <existing_provision type="PHI policies to 13 weeks" />
  589.         <existing_provision type="Emp benefits to 26 weeks" />
  590.         <existing_provision type="PHI policies to 26 weeks" />
  591.         <existing_provision type="Emp benefits to 52 weeks" />
  592.         <existing_provision type="PHI policies to 52 weeks" />
  593.         <existing_provision type="Emp benefits to expiry" />
  594.         <existing_provision type="PHI policies to expiry" />
  595.         <shortfall type="To expiry" />
  596.       </need>
  597.       <need type="Mortgage/Loans">
  598.         <in_scope_ind code="N">No</in_scope_ind>
  599.         <description>Protection for your Mortgage/Loans</description>
  600.         <required type="Mortgages/Loans" />
  601.         <required type="Liabilities" />
  602.         <required type="Total" />
  603.         <duration />
  604.         <existing_provision type="Sums Assured" />
  605.         <existing_provision type="CI benefits" />
  606.         <existing_provision type="Other capital" />
  607.         <existing_provision type="Total on death" />
  608.         <existing_provision type="Total on critical illness" />
  609.         <shortfall type="On death" />
  610.         <shortfall type="On critical illness" />
  611.       </need>
  612.       <need type="Family Protection">
  613.         <in_scope_ind code="N">No</in_scope_ind>
  614.       </need>
  615.       <need type="Retirement Income">
  616.         <in_scope_ind code="N">No</in_scope_ind>
  617.         <description>Improving retirement income</description>
  618.         <required />
  619.         <notes type="Transitional Protection" />
  620.         <notes type="Certificate Details" />
  621.         <notes type="ASP Details" />
  622.         <information_ind type="Transitional Protection" />
  623.         <information_ind type="Someone else ASP" />
  624.       </need>
  625.       <need type="Long Term Care">
  626.         <in_scope_ind code="N">No</in_scope_ind>
  627.         <description>Long term care</description>
  628.         <required type="Cost of care" />
  629.         <required type="Partner Income" />
  630.         <existing_provision type="Investment Income" />
  631.         <existing_provision type="Pension Income" />
  632.         <existing_provision type="State Benefits" />
  633.         <shortfall />
  634.       </need>
  635.       <need type="LTC Calculator">
  636.         <in_scope_ind code="N">No</in_scope_ind>
  637.         <required type="Cost of care" />
  638.         <required type="Partner Income" />
  639.         <existing_provision type="Investment Income" />
  640.         <existing_provision type="Pension Income" />
  641.         <existing_provision type="State Benefits" />
  642.         <shortfall />
  643.       </need>
  644.       <need type="IHT first death">
  645.         <in_scope_ind code="N">No</in_scope_ind>
  646.         <description>Inheritance tax planning 1st Death</description>
  647.         <existing_provision type="Non exempt gifts" />
  648.         <existing_provision type="Non exempt trust money" />
  649.         <existing_provision type="Partner assets" />
  650.         <existing_provision type="IHT exemptions" />
  651.         <existing_provision type="Total estate" />
  652.         <existing_provision type="Tax free estate" />
  653.         <existing_provision type="Taxable estate" />
  654.         <shortfall type="IHT first death" />
  655.         <notes type="Non exempt gifts" />
  656.         <notes type="Non exempt trust money" />
  657.         <notes type="IHT exemptions" />
  658.       </need>
  659.       <need type="IHT second death">
  660.         <in_scope_ind code="N">No</in_scope_ind>
  661.         <description>Inheritance tax planning 2nd Death</description>
  662.         <existing_provision type="Non exempt gifts" />
  663.         <existing_provision type="Non exempt trust money" />
  664.         <existing_provision type="Sums liable" />
  665.         <existing_provision type="IHT exemptions" />
  666.         <existing_provision type="Total estate" />
  667.         <existing_provision type="Tax free estate" />
  668.         <existing_provision type="Taxable estate" />
  669.         <shortfall type="IHT second death" />
  670.         <notes type="IHT exemptions" />
  671.         <notes type="Sums liable" />
  672.       </need>
  673.       <need type="Investments">
  674.         <in_scope_ind code="N">No</in_scope_ind>
  675.         <description>Review your lump sum investment options</description>
  676.         <required type="Income" />
  677.         <deferred_period />
  678.         <duration />
  679.         <existing_provision type="Agreed investment amount" />
  680.         <commitment type="Planned expenditure" />
  681.         <commitment type="Debt repayment" />
  682.         <commitment type="Partner pension" />
  683.         <commitment type="Cash reserve" />
  684.         <commitment type="Total" />
  685.         <commitment type="Available to invest" />
  686.         <notes type="Investment reason" />
  687.         <notes type="Goals not achieved" />
  688.         <notes type="Income reason" />
  689.         <notes type="Agreed investment source" />
  690.       </need>
  691.       <need type="Savings">
  692.         <in_scope_ind code="N">No</in_scope_ind>
  693.         <description>Saving for that special occasion</description>
  694.         <commitment type="Prepared to save" />
  695.         <notes type="Savings reason" />
  696.         <notes type="Savings other reason" />
  697.       </need>
  698.       <customer_reference_number />
  699.       <CIS_number />
  700.       <proof_of_identity>
  701.         <id_verification />
  702.         <address_verification />
  703.         <document type="Customer ID">
  704.           <date type="Issue/Expiry" />
  705.         </document>
  706.         <document type="Address ID">
  707.           <date type="Issue/Expiry" />
  708.         </document>
  709.         <notes type="ID Benefit type" />
  710.         <notes type="Other ID Benefit type" />
  711.         <notes type="Address" />
  712.         <notes type="Other address verification" />
  713.         <notes type="Address Benefit type" />
  714.         <notes type="Other address benefit type" />
  715.         <notes type="Proof of Identity" />
  716.         <date_obtained>
  717.           <date />
  718.         </date_obtained>
  719.       </proof_of_identity>
  720.       <information_ind type="Accounts" />
  721.       <information_ind type="Fixed interest" />
  722.       <information_ind type="Cash ISAs" />
  723.       <information_ind type="Equity ISAs" />
  724.       <information_ind type="Shares" />
  725.       <information_ind type="Bonds" />
  726.       <information_ind type="Unit trusts" />
  727.       <information_ind type="Annuities" />
  728.       <information_ind type="Various" />
  729.       <notes type="Investment ISA Cash amount" />
  730.     </party>
  731.     <party id="Joint" type="Joint" sequence_number="3">
  732.       <known_as />
  733.       <expenditure type="Agreed general" />
  734.       <expenditure type="Agreed mortgage" />
  735.       <expenditure type="Agreed liability" />
  736.       <expenditure type="Agreed protection policy" />
  737.       <expenditure type="Agreed investment policy" />
  738.       <expenditure type="Rent" />
  739.       <expenditure type="Council tax" />
  740.       <expenditure type="Utilities" />
  741.       <expenditure type="Telephone" />
  742.       <expenditure type="Food" />
  743.       <expenditure type="Travel" />
  744.       <expenditure type="Leisure" />
  745.       <expenditure type="General insurance" />
  746.       <expenditure type="Estimated" />
  747.       <expenditure type="General total" />
  748.       <affordability type="Net disposable income" />
  749.       <need type="Savings">
  750.         <in_scope_ind code="N">No</in_scope_ind>
  751.         <description>Saving for that special occasion</description>
  752.         <commitment type="Prepared to save" />
  753.         <notes type="Savings reason" />
  754.         <notes type="Savings other reason" />
  755.       </need>
  756.       <need type="Investments">
  757.         <in_scope_ind code="N">No</in_scope_ind>
  758.         <description>Review your lump sum investment options</description>
  759.         <required type="Income" />
  760.         <deferred_period />
  761.         <duration />
  762.         <existing_provision type="Agreed investment amount" />
  763.         <commitment type="Planned expenditure" />
  764.         <commitment type="Debt repayment" />
  765.         <commitment type="Client pension" />
  766.         <commitment type="Partner pension" />
  767.         <commitment type="Cash reserve" />
  768.         <commitment type="Total" />
  769.         <commitment type="Available to invest" />
  770.         <notes type="Investment reason" />
  771.         <notes type="Goals not achieved" />
  772.         <notes type="Income reason" />
  773.         <notes type="Agreed investment source" />
  774.       </need>
  775.       <need type="Mortgage/Loans">
  776.         <in_scope_ind code="N">No</in_scope_ind>
  777.         <description>Protection for your Mortgage/Loans</description>
  778.         <required type="Mortgages/Loans" />
  779.         <required type="Liabilities" />
  780.         <required type="Total" />
  781.         <duration />
  782.         <existing_provision type="Sums Assured" />
  783.         <existing_provision type="CI benefits" />
  784.         <existing_provision type="Other capital" />
  785.         <existing_provision type="Total on death" />
  786.         <existing_provision type="Total on critical illness" />
  787.         <shortfall type="On death" />
  788.         <shortfall type="On critical illness" />
  789.       </need>
  790.       <information_ind type="Accounts" />
  791.       <information_ind type="Fixed interest" />
  792.       <information_ind type="Cash ISAs" />
  793.       <information_ind type="Equity ISAs" />
  794.       <information_ind type="Shares" />
  795.       <information_ind type="Bonds" />
  796.       <information_ind type="Unit trusts" />
  797.       <information_ind type="Annuities" />
  798.       <information_ind type="Various" />
  799.     </party>
  800.     <adviser type="Financial">
  801.       <full_name>Mr. Test Adviser</full_name>
  802.       <contact>
  803.         <telephone type="daytime">
  804.           <number>(34)5345345</number>
  805.         </telephone>
  806.         <telephone type="mobile">
  807.           <number>(23)4234234</number>
  808.         </telephone>
  809.       </contact>
  810.       <company_reference_number>1232367</company_reference_number>
  811.       <manager sequence_number="1">
  812.         <full_name>Mrs. Jane Smythe</full_name>
  813.         <contact>
  814.           <telephone type="daytime">
  815.             <number>(0000) 4564564</number>
  816.           </telephone>
  817.           <telephone type="mobile">
  818.             <number>(3435) 345 4540</number>
  819.           </telephone>
  820.         </contact>
  821.         <company_reference_number>3214567</company_reference_number>
  822.       </manager>
  823.     </adviser>
  824.     <factfind>
  825.       <asset sequence_number="1">
  826.         <ownership_pc />
  827.         <benefit type="Current value" />
  828.         <benefit type="Income" />
  829.         <notes type="Additional information" />
  830.         <information_ind type="Another asset" />
  831.       </asset>
  832.       <asset sequence_number="2">
  833.         <ownership_pc />
  834.         <benefit type="Current value" />
  835.         <benefit type="Income" />
  836.         <notes type="Additional information" />
  837.         <information_ind type="Another asset" />
  838.       </asset>
  839.       <asset sequence_number="3">
  840.         <ownership_pc />
  841.         <benefit type="Current value" />
  842.         <benefit type="Income" />
  843.         <notes type="Additional information" />
  844.         <information_ind type="Another asset" />
  845.       </asset>
  846.       <asset sequence_number="4">
  847.         <ownership_pc />
  848.         <benefit type="Current value" />
  849.         <benefit type="Income" />
  850.         <notes type="Additional information" />
  851.         <information_ind type="Another asset" />
  852.       </asset>
  853.       <asset sequence_number="5">
  854.         <ownership_pc />
  855.         <benefit type="Current value" />
  856.         <benefit type="Income" />
  857.         <notes type="Additional information" />
  858.         <information_ind type="Another asset" />
  859.       </asset>
  860.       <asset sequence_number="6">
  861.         <ownership_pc />
  862.         <benefit type="Current value" />
  863.         <benefit type="Income" />
  864.         <notes type="Additional information" />
  865.       </asset>
  866.       <mortgage sequence_number="1">
  867.         <outstanding_amount type="Repayment" />
  868.         <outstanding_amount type="Interest only" />
  869.         <repayment>
  870.           <frequency>Monthly</frequency>
  871.           <duration />
  872.         </repayment>
  873.         <redemption_penalty>
  874.           <duration type="Total" />
  875.           <duration type="Remaining" />
  876.         </redemption_penalty>
  877.         <information_ind type="Another mortgage" />
  878.         <notes type="Additional information" />
  879.       </mortgage>
  880.       <mortgage sequence_number="2">
  881.         <outstanding_amount type="Repayment" />
  882.         <outstanding_amount type="Interest only" />
  883.         <repayment>
  884.           <frequency>Monthly</frequency>
  885.           <duration />
  886.         </repayment>
  887.         <redemption_penalty>
  888.           <duration type="Remaining" />
  889.           <duration type="Total" />
  890.         </redemption_penalty>
  891.         <information_ind type="Another mortgage" />
  892.         <notes type="Additional information" />
  893.       </mortgage>
  894.       <mortgage sequence_number="3">
  895.         <outstanding_amount type="Repayment" />
  896.         <outstanding_amount type="Interest only" />
  897.         <repayment>
  898.           <frequency>Monthly</frequency>
  899.           <duration />
  900.         </repayment>
  901.         <redemption_penalty>
  902.           <duration type="Remaining" />
  903.           <duration type="Total" />
  904.         </redemption_penalty>
  905.         <information_ind type="Another mortgage" />
  906.         <notes type="Additional information" />
  907.       </mortgage>
  908.       <mortgage sequence_number="4">
  909.         <outstanding_amount type="Repayment" />
  910.         <outstanding_amount type="Interest only" />
  911.         <repayment>
  912.           <frequency>Monthly</frequency>
  913.           <duration />
  914.         </repayment>
  915.         <redemption_penalty>
  916.           <duration type="Remaining" />
  917.           <duration type="Total" />
  918.         </redemption_penalty>
  919.         <information_ind type="Another mortgage" />
  920.         <notes type="Additional information" />
  921.       </mortgage>
  922.       <mortgage sequence_number="5">
  923.         <outstanding_amount type="Repayment" />
  924.         <outstanding_amount type="Interest only" />
  925.         <repayment>
  926.           <frequency>Monthly</frequency>
  927.           <duration />
  928.         </repayment>
  929.         <redemption_penalty>
  930.           <duration type="Remaining" />
  931.           <duration type="Total" />
  932.         </redemption_penalty>
  933.         <information_ind type="Another mortgage" />
  934.         <notes type="Additional information" />
  935.       </mortgage>
  936.       <mortgage sequence_number="6">
  937.         <outstanding_amount type="Repayment" />
  938.         <outstanding_amount type="Interest only" />
  939.         <repayment>
  940.           <frequency>Monthly</frequency>
  941.           <duration />
  942.         </repayment>
  943.         <redemption_penalty>
  944.           <duration type="Remaining" />
  945.           <duration type="Total" />
  946.         </redemption_penalty>
  947.         <notes type="Additional information" />
  948.       </mortgage>
  949.       <policy sequence_number="1" category="Accounts">
  950.         <ownership_pc />
  951.         <contribution type="Current" />
  952.         <benefit type="Current value">
  953.           <notice_period />
  954.         </benefit>
  955.         <benefit type="Income" />
  956.         <information_ind type="Another account" />
  957.         <notes type="Accounts" />
  958.       </policy>
  959.       <policy sequence_number="2" category="Accounts">
  960.         <ownership_pc />
  961.         <contribution type="Current" />
  962.         <benefit type="Current value">
  963.           <notice_period />
  964.         </benefit>
  965.         <benefit type="Income" />
  966.         <information_ind type="Another account" />
  967.         <notes type="Accounts" />
  968.       </policy>
  969.       <policy sequence_number="3" category="Accounts">
  970.         <ownership_pc />
  971.         <contribution type="Current" />
  972.         <benefit type="Current value">
  973.           <notice_period />
  974.         </benefit>
  975.         <benefit type="Income" />
  976.         <information_ind type="Another account" />
  977.         <notes type="Accounts" />
  978.       </policy>
  979.       <policy sequence_number="4" category="Accounts">
  980.         <ownership_pc />
  981.         <contribution type="Current" />
  982.         <benefit type="Current value">
  983.           <notice_period />
  984.         </benefit>
  985.         <benefit type="Income" />
  986.         <information_ind type="Another account" />
  987.         <notes type="Accounts" />
  988.       </policy>
  989.       <policy sequence_number="5" category="Accounts">
  990.         <ownership_pc />
  991.         <contribution type="Current" />
  992.         <benefit type="Current value">
  993.           <notice_period />
  994.         </benefit>
  995.         <benefit type="Income" />
  996.         <information_ind type="Another account" />
  997.         <notes type="Accounts" />
  998.       </policy>
  999.       <policy sequence_number="6" category="Accounts">
  1000.         <ownership_pc />
  1001.         <contribution type="Current" />
  1002.         <benefit type="Current value">
  1003.           <notice_period />
  1004.         </benefit>
  1005.         <benefit type="Income" />
  1006.         <notes type="Accounts" />
  1007.       </policy>
  1008.       <policy sequence_number="1" category="Cash ISAs">
  1009.         <contribution type="Current" />
  1010.         <contribution type="Tax year" />
  1011.         <benefit type="Current value" />
  1012.         <benefit type="Income" />
  1013.         <information_ind type="Another cash isa" />
  1014.         <notes type="Cash ISAs" />
  1015.       </policy>
  1016.       <policy sequence_number="2" category="Cash ISAs">
  1017.         <contribution type="Current" />
  1018.         <contribution type="Tax year" />
  1019.         <benefit type="Current value" />
  1020.         <benefit type="Income" />
  1021.         <information_ind type="Another cash isa" />
  1022.         <notes type="Cash ISAs" />
  1023.       </policy>
  1024.       <policy sequence_number="3" category="Cash ISAs">
  1025.         <contribution type="Current" />
  1026.         <contribution type="Tax year" />
  1027.         <benefit type="Current value" />
  1028.         <benefit type="Income" />
  1029.         <information_ind type="Another cash isa" />
  1030.         <notes type="Cash ISAs" />
  1031.       </policy>
  1032.       <policy sequence_number="4" category="Cash ISAs">
  1033.         <contribution type="Current" />
  1034.         <contribution type="Tax year" />
  1035.         <benefit type="Current value" />
  1036.         <benefit type="Income" />
  1037.         <information_ind type="Another cash isa" />
  1038.         <notes type="Cash ISAs" />
  1039.       </policy>
  1040.       <policy sequence_number="5" category="Cash ISAs">
  1041.         <contribution type="Current" />
  1042.         <contribution type="Tax year" />
  1043.         <benefit type="Current value" />
  1044.         <benefit type="Income" />
  1045.         <information_ind type="Another cash isa" />
  1046.         <notes type="Cash ISAs" />
  1047.       </policy>
  1048.       <policy sequence_number="6" category="Cash ISAs">
  1049.         <contribution type="Current" />
  1050.         <contribution type="Tax year" />
  1051.         <benefit type="Current value" />
  1052.         <benefit type="Income" />
  1053.         <notes type="Cash ISAs" />
  1054.       </policy>
  1055.       <policy sequence_number="1" category="Equity ISAs">
  1056.         <contribution type="Current" />
  1057.         <contribution type="Tax year" />
  1058.         <benefit type="Current value" />
  1059.         <benefit type="Income" />
  1060.         <fund />
  1061.         <information_ind type="Another equity isa" />
  1062.         <notes type="Equity ISAs" />
  1063.       </policy>
  1064.       <policy sequence_number="2" category="Equity ISAs">
  1065.         <contribution type="Current" />
  1066.         <contribution type="Tax year" />
  1067.         <benefit type="Current value" />
  1068.         <benefit type="Income" />
  1069.         <fund />
  1070.         <information_ind type="Another equity isa" />
  1071.         <notes type="Equity ISAs" />
  1072.       </policy>
  1073.       <policy sequence_number="3" category="Equity ISAs">
  1074.         <contribution type="Current" />
  1075.         <contribution type="Tax year" />
  1076.         <benefit type="Current value" />
  1077.         <benefit type="Income" />
  1078.         <fund />
  1079.         <information_ind type="Another equity isa" />
  1080.         <notes type="Equity ISAs" />
  1081.       </policy>
  1082.       <policy sequence_number="4" category="Equity ISAs">
  1083.         <contribution type="Current" />
  1084.         <contribution type="Tax year" />
  1085.         <benefit type="Current value" />
  1086.         <benefit type="Income" />
  1087.         <fund />
  1088.         <information_ind type="Another equity isa" />
  1089.         <notes type="Equity ISAs" />
  1090.       </policy>
  1091.       <policy sequence_number="5" category="Equity ISAs">
  1092.         <contribution type="Current" />
  1093.         <contribution type="Tax year" />
  1094.         <benefit type="Current value" />
  1095.         <benefit type="Income" />
  1096.         <fund />
  1097.         <information_ind type="Another equity isa" />
  1098.         <notes type="Equity ISAs" />
  1099.       </policy>
  1100.       <policy sequence_number="6" category="Equity ISAs">
  1101.         <contribution type="Current" />
  1102.         <contribution type="Tax year" />
  1103.         <benefit type="Current value" />
  1104.         <benefit type="Income" />
  1105.         <fund />
  1106.         <notes type="Equity ISAs" />
  1107.       </policy>
  1108.       <policy sequence_number="1" category="Fixed interest">
  1109.         <ownership_pc />
  1110.         <contribution type="Current" />
  1111.         <benefit type="Current value" />
  1112.         <benefit type="Income" />
  1113.         <fund />
  1114.         <information_ind type="Another fixed interest" />
  1115.         <notes type="Fixed interest" />
  1116.       </policy>
  1117.       <policy sequence_number="2" category="Fixed interest">
  1118.         <ownership_pc />
  1119.         <contribution type="Current" />
  1120.         <benefit type="Current value" />
  1121.         <benefit type="Income" />
  1122.         <fund />
  1123.         <information_ind type="Another fixed interest" />
  1124.         <notes type="Fixed interest" />
  1125.       </policy>
  1126.       <policy sequence_number="3" category="Fixed interest">
  1127.         <ownership_pc />
  1128.         <contribution type="Current" />
  1129.         <benefit type="Current value" />
  1130.         <benefit type="Income" />
  1131.         <fund />
  1132.         <information_ind type="Another fixed interest" />
  1133.         <notes type="Fixed interest" />
  1134.       </policy>
  1135.       <policy sequence_number="4" category="Fixed interest">
  1136.         <ownership_pc />
  1137.         <contribution type="Current" />
  1138.         <benefit type="Current value" />
  1139.         <benefit type="Income" />
  1140.         <fund />
  1141.         <information_ind type="Another fixed interest" />
  1142.         <notes type="Fixed interest" />
  1143.       </policy>
  1144.       <policy sequence_number="5" category="Fixed interest">
  1145.         <ownership_pc />
  1146.         <contribution type="Current" />
  1147.         <benefit type="Current value" />
  1148.         <benefit type="Income" />
  1149.         <fund />
  1150.         <information_ind type="Another fixed interest" />
  1151.         <notes type="Fixed interest" />
  1152.       </policy>
  1153.       <policy sequence_number="6" category="Fixed interest">
  1154.         <ownership_pc />
  1155.         <contribution type="Current" />
  1156.         <benefit type="Current value" />
  1157.         <benefit type="Income" />
  1158.         <fund />
  1159.         <notes type="Fixed interest" />
  1160.       </policy>
  1161.       <policy sequence_number="1" category="Shares">
  1162.         <ownership_pc />
  1163.         <contribution type="Current" />
  1164.         <benefit type="Current value" />
  1165.         <benefit type="Income" />
  1166.         <duration />
  1167.         <fund />
  1168.         <information_ind type="Another share holding" />
  1169.         <notes type="Shares" />
  1170.       </policy>
  1171.       <policy sequence_number="2" category="Shares">
  1172.         <ownership_pc />
  1173.         <contribution type="Current" />
  1174.         <benefit type="Current value" />
  1175.         <benefit type="Income" />
  1176.         <duration />
  1177.         <fund />
  1178.         <information_ind type="Another share holding" />
  1179.         <notes type="Shares" />
  1180.       </policy>
  1181.       <policy sequence_number="3" category="Shares">
  1182.         <ownership_pc />
  1183.         <contribution type="Current" />
  1184.         <benefit type="Current value" />
  1185.         <benefit type="Income" />
  1186.         <duration />
  1187.         <fund />
  1188.         <information_ind type="Another share holding" />
  1189.         <notes type="Shares" />
  1190.       </policy>
  1191.       <policy sequence_number="4" category="Shares">
  1192.         <ownership_pc />
  1193.         <contribution type="Current" />
  1194.         <benefit type="Current value" />
  1195.         <benefit type="Income" />
  1196.         <duration />
  1197.         <fund />
  1198.         <information_ind type="Another share holding" />
  1199.         <notes type="Shares" />
  1200.       </policy>
  1201.       <policy sequence_number="5" category="Shares">
  1202.         <ownership_pc />
  1203.         <contribution type="Current" />
  1204.         <benefit type="Current value" />
  1205.         <benefit type="Income" />
  1206.         <duration />
  1207.         <fund />
  1208.         <information_ind type="Another share holding" />
  1209.         <notes type="Shares" />
  1210.       </policy>
  1211.       <policy sequence_number="6" category="Shares">
  1212.         <ownership_pc />
  1213.         <contribution type="Current" />
  1214.         <benefit type="Current value" />
  1215.         <benefit type="Income" />
  1216.         <duration />
  1217.         <fund />
  1218.         <notes type="Shares" />
  1219.       </policy>
  1220.       <policy sequence_number="1" category="Bonds">
  1221.         <ownership_pc />
  1222.         <contribution type="Current" />
  1223.         <benefit type="Current value" />
  1224.         <benefit type="Income" />
  1225.         <duration />
  1226.         <fund />
  1227.         <information_ind type="Another bond" />
  1228.         <notes type="Bonds" />
  1229.       </policy>
  1230.       <policy sequence_number="2" category="Bonds">
  1231.         <ownership_pc />
  1232.         <contribution type="Current" />
  1233.         <benefit type="Current value" />
  1234.         <benefit type="Income" />
  1235.         <duration />
  1236.         <fund />
  1237.         <information_ind type="Another bond" />
  1238.         <notes type="Bonds" />
  1239.       </policy>
  1240.       <policy sequence_number="3" category="Bonds">
  1241.         <ownership_pc />
  1242.         <contribution type="Current" />
  1243.         <benefit type="Current value" />
  1244.         <benefit type="Income" />
  1245.         <duration />
  1246.         <fund />
  1247.         <information_ind type="Another bond" />
  1248.         <notes type="Bonds" />
  1249.       </policy>
  1250.       <policy sequence_number="4" category="Bonds">
  1251.         <ownership_pc />
  1252.         <contribution type="Current" />
  1253.         <benefit type="Current value" />
  1254.         <benefit type="Income" />
  1255.         <duration />
  1256.         <fund />
  1257.         <information_ind type="Another bond" />
  1258.         <notes type="Bonds" />
  1259.       </policy>
  1260.       <policy sequence_number="5" category="Bonds">
  1261.         <ownership_pc />
  1262.         <contribution type="Current" />
  1263.         <benefit type="Current value" />
  1264.         <benefit type="Income" />
  1265.         <duration />
  1266.         <fund />
  1267.         <information_ind type="Another bond" />
  1268.         <notes type="Bonds" />
  1269.       </policy>
  1270.       <policy sequence_number="6" category="Bonds">
  1271.         <ownership_pc />
  1272.         <contribution type="Current" />
  1273.         <benefit type="Current value" />
  1274.         <benefit type="Income" />
  1275.         <duration />
  1276.         <fund />
  1277.         <notes type="Bonds" />
  1278.       </policy>
  1279.       <policy sequence_number="1" category="Unit trusts">
  1280.         <ownership_pc />
  1281.         <contribution type="Current" />
  1282.         <benefit type="Current value" />
  1283.         <benefit type="Income" />
  1284.         <duration />
  1285.         <fund />
  1286.         <information_ind type="Another unit trust" />
  1287.         <notes type="Unit trusts" />
  1288.       </policy>
  1289.       <policy sequence_number="2" category="Unit trusts">
  1290.         <ownership_pc />
  1291.         <contribution type="Current" />
  1292.         <benefit type="Current value" />
  1293.         <benefit type="Income" />
  1294.         <duration />
  1295.         <fund />
  1296.         <information_ind type="Another unit trust" />
  1297.         <notes type="Unit trusts" />
  1298.       </policy>
  1299.       <policy sequence_number="3" category="Unit trusts">
  1300.         <ownership_pc />
  1301.         <contribution type="Current" />
  1302.         <benefit type="Current value" />
  1303.         <benefit type="Income" />
  1304.         <duration />
  1305.         <fund />
  1306.         <information_ind type="Another unit trust" />
  1307.         <notes type="Unit trusts" />
  1308.       </policy>
  1309.       <policy sequence_number="4" category="Unit trusts">
  1310.         <ownership_pc />
  1311.         <contribution type="Current" />
  1312.         <benefit type="Current value" />
  1313.         <benefit type="Income" />
  1314.         <duration />
  1315.         <fund />
  1316.         <information_ind type="Another unit trust" />
  1317.         <notes type="Unit trusts" />
  1318.       </policy>
  1319.       <policy sequence_number="5" category="Unit trusts">
  1320.         <ownership_pc />
  1321.         <contribution type="Current" />
  1322.         <benefit type="Current value" />
  1323.         <benefit type="Income" />
  1324.         <duration />
  1325.         <fund />
  1326.         <information_ind type="Another unit trust" />
  1327.         <notes type="Unit trusts" />
  1328.       </policy>
  1329.       <policy sequence_number="6" category="Unit trusts">
  1330.         <ownership_pc />
  1331.         <contribution type="Current" />
  1332.         <benefit type="Current value" />
  1333.         <benefit type="Income" />
  1334.         <duration />
  1335.         <fund />
  1336.         <notes type="Unit trusts" />
  1337.       </policy>
  1338.       <policy sequence_number="1" category="Annuities">
  1339.         <ownership_pc />
  1340.         <benefit type="Income" />
  1341.         <information_ind type="Another annuity" />
  1342.         <notes type="Annuities" />
  1343.       </policy>
  1344.       <policy sequence_number="2" category="Annuities">
  1345.         <ownership_pc />
  1346.         <benefit type="Income" />
  1347.         <information_ind type="Another annuity" />
  1348.         <notes type="Annuities" />
  1349.       </policy>
  1350.       <policy sequence_number="3" category="Annuities">
  1351.         <ownership_pc />
  1352.         <benefit type="Income" />
  1353.         <information_ind type="Another annuity" />
  1354.         <notes type="Annuities" />
  1355.       </policy>
  1356.       <policy sequence_number="4" category="Annuities">
  1357.         <ownership_pc />
  1358.         <benefit type="Income" />
  1359.         <information_ind type="Another annuity" />
  1360.         <notes type="Annuities" />
  1361.       </policy>
  1362.       <policy sequence_number="5" category="Annuities">
  1363.         <ownership_pc />
  1364.         <benefit type="Income" />
  1365.         <information_ind type="Another annuity" />
  1366.         <notes type="Annuities" />
  1367.       </policy>
  1368.       <policy sequence_number="6" category="Annuities">
  1369.         <ownership_pc />
  1370.         <benefit type="Income" />
  1371.         <notes type="Annuities" />
  1372.       </policy>
  1373.       <policy sequence_number="1" category="Various">
  1374.         <ownership_pc />
  1375.         <benefit type="Current value" />
  1376.         <benefit type="Income" />
  1377.         <information_ind type="Another various" />
  1378.         <notes type="Various" />
  1379.         <notes type="Description" />
  1380.       </policy>
  1381.       <policy sequence_number="2" category="Various">
  1382.         <ownership_pc />
  1383.         <benefit type="Current value" />
  1384.         <benefit type="Income" />
  1385.         <information_ind type="Another various" />
  1386.         <notes type="Various" />
  1387.         <notes type="Description" />
  1388.       </policy>
  1389.       <policy sequence_number="3" category="Various">
  1390.         <ownership_pc />
  1391.         <benefit type="Current value" />
  1392.         <benefit type="Income" />
  1393.         <information_ind type="Another various" />
  1394.         <notes type="Various" />
  1395.         <notes type="Description" />
  1396.       </policy>
  1397.       <policy sequence_number="4" category="Various">
  1398.         <ownership_pc />
  1399.         <benefit type="Current value" />
  1400.         <benefit type="Income" />
  1401.         <information_ind type="Another various" />
  1402.         <notes type="Various" />
  1403.         <notes type="Description" />
  1404.       </policy>
  1405.       <policy sequence_number="5" category="Various">
  1406.         <ownership_pc />
  1407.         <benefit type="Current value" />
  1408.         <benefit type="Income" />
  1409.         <information_ind type="Another various" />
  1410.         <notes type="Various" />
  1411.         <notes type="Description" />
  1412.       </policy>
  1413.       <policy sequence_number="6" category="Various">
  1414.         <ownership_pc />
  1415.         <benefit type="Current value" />
  1416.         <benefit type="Income" />
  1417.         <notes type="Various" />
  1418.         <notes type="Description" />
  1419.       </policy>
  1420.       <policy sequence_number="1" category="Protection">
  1421.         <contribution type="Current">
  1422.           <increase />
  1423.         </contribution>
  1424.         <benefit type="Current value">
  1425.           <valuation_date />
  1426.         </benefit>
  1427.         <benefit type="Death" />
  1428.         <benefit type="Critical illness" />
  1429.         <benefit type="Disability">
  1430.           <deferred_period />
  1431.         </benefit>
  1432.         <duration>
  1433.           <start_date />
  1434.         </duration>
  1435.         <information_ind type="Another policy" />
  1436.         <notes type="Additional information" />
  1437.       </policy>
  1438.       <policy sequence_number="2" category="Protection">
  1439.         <contribution type="Current">
  1440.           <increase />
  1441.         </contribution>
  1442.         <benefit type="Current value">
  1443.           <valuation_date />
  1444.         </benefit>
  1445.         <benefit type="Death" />
  1446.         <benefit type="Critical illness" />
  1447.         <benefit type="Disability">
  1448.           <deferred_period />
  1449.         </benefit>
  1450.         <duration>
  1451.           <start_date />
  1452.         </duration>
  1453.         <information_ind type="Another policy" />
  1454.         <notes type="Additional information" />
  1455.       </policy>
  1456.       <policy sequence_number="3" category="Protection">
  1457.         <contribution type="Current">
  1458.           <increase />
  1459.         </contribution>
  1460.         <benefit type="Current value">
  1461.           <valuation_date />
  1462.         </benefit>
  1463.         <benefit type="Death" />
  1464.         <benefit type="Critical illness" />
  1465.         <benefit type="Disability">
  1466.           <deferred_period />
  1467.         </benefit>
  1468.         <duration>
  1469.           <start_date />
  1470.         </duration>
  1471.         <information_ind type="Another policy" />
  1472.         <notes type="Additional information" />
  1473.       </policy>
  1474.       <policy sequence_number="4" category="Protection">
  1475.         <contribution type="Current">
  1476.           <increase />
  1477.         </contribution>
  1478.         <benefit type="Current value">
  1479.           <valuation_date />
  1480.         </benefit>
  1481.         <benefit type="Death" />
  1482.         <benefit type="Critical illness" />
  1483.         <benefit type="Disability">
  1484.           <deferred_period />
  1485.         </benefit>
  1486.         <duration>
  1487.           <start_date />
  1488.         </duration>
  1489.         <information_ind type="Another policy" />
  1490.         <notes type="Additional information" />
  1491.       </policy>
  1492.       <policy sequence_number="5" category="Protection">
  1493.         <contribution type="Current">
  1494.           <increase />
  1495.         </contribution>
  1496.         <benefit type="Current value">
  1497.           <valuation_date />
  1498.         </benefit>
  1499.         <benefit type="Death" />
  1500.         <benefit type="Critical illness" />
  1501.         <benefit type="Disability">
  1502.           <deferred_period />
  1503.         </benefit>
  1504.         <duration>
  1505.           <start_date />
  1506.         </duration>
  1507.         <information_ind type="Another policy" />
  1508.         <notes type="Additional information" />
  1509.       </policy>
  1510.       <policy sequence_number="6" category="Protection">
  1511.         <contribution type="Current">
  1512.           <increase />
  1513.         </contribution>
  1514.         <benefit type="Current value">
  1515.           <valuation_date />
  1516.         </benefit>
  1517.         <benefit type="Death" />
  1518.         <benefit type="Critical illness" />
  1519.         <benefit type="Disability">
  1520.           <deferred_period />
  1521.         </benefit>
  1522.         <duration>
  1523.           <start_date />
  1524.         </duration>
  1525.         <information_ind type="Another policy" />
  1526.         <notes type="Additional information" />
  1527.       </policy>
  1528.       <policy sequence_number="7" category="Protection">
  1529.         <contribution type="Current">
  1530.           <increase />
  1531.         </contribution>
  1532.         <benefit type="Current value">
  1533.           <valuation_date />
  1534.         </benefit>
  1535.         <benefit type="Death" />
  1536.         <benefit type="Critical illness" />
  1537.         <benefit type="Disability">
  1538.           <deferred_period />
  1539.         </benefit>
  1540.         <duration>
  1541.           <start_date />
  1542.         </duration>
  1543.         <information_ind type="Another policy" />
  1544.         <notes type="Additional information" />
  1545.       </policy>
  1546.       <policy sequence_number="8" category="Protection">
  1547.         <contribution type="Current">
  1548.           <increase />
  1549.         </contribution>
  1550.         <benefit type="Current value">
  1551.           <valuation_date />
  1552.         </benefit>
  1553.         <benefit type="Death" />
  1554.         <benefit type="Critical illness" />
  1555.         <benefit type="Disability">
  1556.           <deferred_period />
  1557.         </benefit>
  1558.         <duration>
  1559.           <start_date />
  1560.         </duration>
  1561.         <information_ind type="Another policy" />
  1562.         <notes type="Additional information" />
  1563.       </policy>
  1564.       <policy sequence_number="9" category="Protection">
  1565.         <contribution type="Current">
  1566.           <increase />
  1567.         </contribution>
  1568.         <benefit type="Current value">
  1569.           <valuation_date />
  1570.         </benefit>
  1571.         <benefit type="Death" />
  1572.         <benefit type="Critical illness" />
  1573.         <benefit type="Disability">
  1574.           <deferred_period />
  1575.         </benefit>
  1576.         <duration>
  1577.           <start_date />
  1578.         </duration>
  1579.         <information_ind type="Another policy" />
  1580.         <notes type="Additional information" />
  1581.       </policy>
  1582.       <policy sequence_number="10" category="Protection">
  1583.         <contribution type="Current">
  1584.           <increase />
  1585.         </contribution>
  1586.         <benefit type="Current value">
  1587.           <valuation_date />
  1588.         </benefit>
  1589.         <benefit type="Death" />
  1590.         <benefit type="Critical illness" />
  1591.         <benefit type="Disability">
  1592.           <deferred_period />
  1593.         </benefit>
  1594.         <duration>
  1595.           <start_date />
  1596.         </duration>
  1597.         <notes type="Additional information" />
  1598.       </policy>
  1599.       <policy sequence_number="1" category="Company Pension">
  1600.         <contribution type="Member">
  1601.           <earnings_related />
  1602.           <increase />
  1603.         </contribution>
  1604.         <contribution type="Employer">
  1605.           <earnings_related />
  1606.           <increase />
  1607.         </contribution>
  1608.         <contribution type="Mortgage" />
  1609.         <benefit type="Earnings related">
  1610.           <earnings_related />
  1611.         </benefit>
  1612.         <benefit type="Retirement income" />
  1613.         <benefit type="Current fund" />
  1614.         <benefit type="Death in service" />
  1615.         <benefit type="Retirement fund" />
  1616.         <benefit type="Tax free cash" />
  1617.         <duration>
  1618.           <start_date />
  1619.         </duration>
  1620.         <information_ind type="Another pension" />
  1621.         <information_ind type="Transfer Another Arrangement" />
  1622.         <information_ind type="Transfer Benefits Current" />
  1623.         <notes type="Additional Information" />
  1624.       </policy>
  1625.       <policy sequence_number="2" category="Company Pension">
  1626.         <contribution type="Member">
  1627.           <earnings_related />
  1628.           <increase />
  1629.         </contribution>
  1630.         <contribution type="Employer">
  1631.           <earnings_related />
  1632.           <increase />
  1633.         </contribution>
  1634.         <contribution type="Mortgage" />
  1635.         <benefit type="Earnings related">
  1636.           <earnings_related />
  1637.         </benefit>
  1638.         <benefit type="Retirement income" />
  1639.         <benefit type="Current fund" />
  1640.         <benefit type="Death in service" />
  1641.         <benefit type="Retirement fund" />
  1642.         <benefit type="Tax free cash" />
  1643.         <duration>
  1644.           <start_date />
  1645.         </duration>
  1646.         <information_ind type="Another pension" />
  1647.         <information_ind type="Transfer Another Arrangement" />
  1648.         <information_ind type="Transfer Benefits Current" />
  1649.         <notes type="Additional Information" />
  1650.       </policy>
  1651.       <policy sequence_number="3" category="Company Pension">
  1652.         <contribution type="Member">
  1653.           <earnings_related />
  1654.           <increase />
  1655.         </contribution>
  1656.         <contribution type="Employer">
  1657.           <earnings_related />
  1658.           <increase />
  1659.         </contribution>
  1660.         <contribution type="Mortgage" />
  1661.         <benefit type="Earnings related">
  1662.           <earnings_related />
  1663.         </benefit>
  1664.         <benefit type="Retirement income" />
  1665.         <benefit type="Current fund" />
  1666.         <benefit type="Death in service" />
  1667.         <benefit type="Retirement fund" />
  1668.         <benefit type="Tax free cash" />
  1669.         <duration>
  1670.           <start_date />
  1671.         </duration>
  1672.         <information_ind type="Another pension" />
  1673.         <information_ind type="Transfer Another Arrangement" />
  1674.         <information_ind type="Transfer Benefits Current" />
  1675.         <notes type="Additional Information" />
  1676.       </policy>
  1677.       <policy sequence_number="4" category="Company Pension">
  1678.         <contribution type="Member">
  1679.           <earnings_related />
  1680.           <increase />
  1681.         </contribution>
  1682.         <contribution type="Employer">
  1683.           <earnings_related />
  1684.           <increase />
  1685.         </contribution>
  1686.         <contribution type="Mortgage" />
  1687.         <benefit type="Earnings related">
  1688.           <earnings_related />
  1689.         </benefit>
  1690.         <benefit type="Retirement income" />
  1691.         <benefit type="Current fund" />
  1692.         <benefit type="Death in service" />
  1693.         <benefit type="Retirement fund" />
  1694.         <benefit type="Tax free cash" />
  1695.         <duration>
  1696.           <start_date />
  1697.         </duration>
  1698.         <information_ind type="Another pension" />
  1699.         <information_ind type="Transfer Another Arrangement" />
  1700.         <information_ind type="Transfer Benefits Current" />
  1701.         <notes type="Additional Information" />
  1702.       </policy>
  1703.       <policy sequence_number="5" category="Company Pension">
  1704.         <contribution type="Member">
  1705.           <earnings_related />
  1706.           <increase />
  1707.         </contribution>
  1708.         <contribution type="Employer">
  1709.           <earnings_related />
  1710.           <increase />
  1711.         </contribution>
  1712.         <contribution type="Mortgage" />
  1713.         <benefit type="Earnings related">
  1714.           <earnings_related />
  1715.         </benefit>
  1716.         <benefit type="Retirement income" />
  1717.         <benefit type="Current fund" />
  1718.         <benefit type="Death in service" />
  1719.         <benefit type="Retirement fund" />
  1720.         <benefit type="Tax free cash" />
  1721.         <duration>
  1722.           <start_date />
  1723.         </duration>
  1724.         <information_ind type="Another pension" />
  1725.         <information_ind type="Transfer Another Arrangement" />
  1726.         <information_ind type="Transfer Benefits Current" />
  1727.         <notes type="Additional Information" />
  1728.       </policy>
  1729.       <policy sequence_number="6" category="Company Pension">
  1730.         <contribution type="Member">
  1731.           <earnings_related />
  1732.           <increase />
  1733.         </contribution>
  1734.         <contribution type="Employer">
  1735.           <earnings_related />
  1736.           <increase />
  1737.         </contribution>
  1738.         <contribution type="Mortgage" />
  1739.         <benefit type="Earnings related">
  1740.           <earnings_related />
  1741.         </benefit>
  1742.         <benefit type="Retirement income" />
  1743.         <benefit type="Current fund" />
  1744.         <benefit type="Death in service" />
  1745.         <benefit type="Retirement fund" />
  1746.         <benefit type="Tax free cash" />
  1747.         <duration>
  1748.           <start_date />
  1749.         </duration>
  1750.         <information_ind type="Transfer Another Arrangement" />
  1751.         <information_ind type="Transfer Benefits Current" />
  1752.         <notes type="Additional Information" />
  1753.       </policy>
  1754.       <policy sequence_number="1" category="Personal Pension">
  1755.         <contribution type="Member">
  1756.           <increase />
  1757.         </contribution>
  1758.         <contribution type="Mortgage" />
  1759.         <benefit type="Earnings related">
  1760.           <duration />
  1761.           <earnings_related />
  1762.         </benefit>
  1763.         <benefit type="Retirement fund" />
  1764.         <benefit type="Current fund" />
  1765.         <benefit type="Retirement income" />
  1766.         <benefit type="Tax free cash" />
  1767.         <fund />
  1768.         <information_ind type="Another pension" />
  1769.         <information_ind type="Employer Contributions" />
  1770.         <information_ind type="Transfer Another Arrangement" />
  1771.         <information_ind type="Transfer Benefits Current" />
  1772.         <notes type="Additional Information" />
  1773.       </policy>
  1774.       <policy sequence_number="2" category="Personal Pension">
  1775.         <contribution type="Member">
  1776.           <increase />
  1777.         </contribution>
  1778.         <contribution type="Mortgage" />
  1779.         <benefit type="Earnings related">
  1780.           <duration />
  1781.           <earnings_related />
  1782.         </benefit>
  1783.         <benefit type="Retirement fund" />
  1784.         <benefit type="Current fund" />
  1785.         <benefit type="Retirement income" />
  1786.         <benefit type="Tax free cash" />
  1787.         <fund />
  1788.         <information_ind type="Another pension" />
  1789.         <information_ind type="Employer Contributions" />
  1790.         <information_ind type="Transfer Another Arrangement" />
  1791.         <information_ind type="Transfer Benefits Current" />
  1792.         <notes type="Additional Information" />
  1793.       </policy>
  1794.       <policy sequence_number="3" category="Personal Pension">
  1795.         <contribution type="Member">
  1796.           <increase />
  1797.         </contribution>
  1798.         <contribution type="Mortgage" />
  1799.         <benefit type="Earnings related">
  1800.           <duration />
  1801.           <earnings_related />
  1802.         </benefit>
  1803.         <benefit type="Retirement fund" />
  1804.         <benefit type="Current fund" />
  1805.         <benefit type="Retirement income" />
  1806.         <benefit type="Tax free cash" />
  1807.         <fund />
  1808.         <information_ind type="Another pension" />
  1809.         <information_ind type="Employer Contributions" />
  1810.         <information_ind type="Transfer Another Arrangement" />
  1811.         <information_ind type="Transfer Benefits Current" />
  1812.         <notes type="Additional Information" />
  1813.       </policy>
  1814.       <policy sequence_number="4" category="Personal Pension">
  1815.         <contribution type="Member">
  1816.           <increase />
  1817.         </contribution>
  1818.         <contribution type="Mortgage" />
  1819.         <benefit type="Earnings related">
  1820.           <duration />
  1821.           <earnings_related />
  1822.         </benefit>
  1823.         <benefit type="Retirement fund" />
  1824.         <benefit type="Current fund" />
  1825.         <benefit type="Retirement income" />
  1826.         <benefit type="Tax free cash" />
  1827.         <fund />
  1828.         <information_ind type="Another pension" />
  1829.         <information_ind type="Employer Contributions" />
  1830.         <information_ind type="Transfer Another Arrangement" />
  1831.         <information_ind type="Transfer Benefits Current" />
  1832.         <notes type="Additional Information" />
  1833.       </policy>
  1834.       <policy sequence_number="5" category="Personal Pension">
  1835.         <contribution type="Member">
  1836.           <increase />
  1837.         </contribution>
  1838.         <contribution type="Mortgage" />
  1839.         <benefit type="Earnings related">
  1840.           <duration />
  1841.           <earnings_related />
  1842.         </benefit>
  1843.         <benefit type="Retirement fund" />
  1844.         <benefit type="Current fund" />
  1845.         <benefit type="Retirement income" />
  1846.         <benefit type="Tax free cash" />
  1847.         <fund />
  1848.         <information_ind type="Another pension" />
  1849.         <information_ind type="Employer Contributions" />
  1850.         <information_ind type="Transfer Another Arrangement" />
  1851.         <information_ind type="Transfer Benefits Current" />
  1852.         <notes type="Additional Information" />
  1853.       </policy>
  1854.       <policy sequence_number="6" category="Personal Pension">
  1855.         <contribution type="Member">
  1856.           <increase />
  1857.         </contribution>
  1858.         <contribution type="Mortgage" />
  1859.         <benefit type="Earnings related">
  1860.           <duration />
  1861.           <earnings_related />
  1862.         </benefit>
  1863.         <benefit type="Retirement fund" />
  1864.         <benefit type="Current fund" />
  1865.         <benefit type="Retirement income" />
  1866.         <benefit type="Tax free cash" />
  1867.         <fund />
  1868.         <information_ind type="Employer Contributions" />
  1869.         <information_ind type="Transfer Another Arrangement" />
  1870.         <information_ind type="Transfer Benefits Current" />
  1871.         <notes type="Additional Information" />
  1872.       </policy>
  1873.       <policy sequence_number="1" category="Preserved Pension">
  1874.         <benefit type="Pension benefit" />
  1875.         <benefit type="Current fund" />
  1876.         <duration />
  1877.         <fund />
  1878.         <information_ind type="Another pension" />
  1879.         <information_ind type="Transfer Another Arrangement" />
  1880.         <information_ind type="Transfer Benefits Current" />
  1881.         <notes type="Additional Information" />
  1882.       </policy>
  1883.       <policy sequence_number="2" category="Preserved Pension">
  1884.         <benefit type="Pension benefit" />
  1885.         <benefit type="Current fund" />
  1886.         <duration />
  1887.         <fund />
  1888.         <information_ind type="Another pension" />
  1889.         <information_ind type="Transfer Another Arrangement" />
  1890.         <information_ind type="Transfer Benefits Current" />
  1891.         <notes type="Additional Information" />
  1892.       </policy>
  1893.       <policy sequence_number="3" category="Preserved Pension">
  1894.         <benefit type="Pension benefit" />
  1895.         <benefit type="Current fund" />
  1896.         <duration />
  1897.         <fund />
  1898.         <information_ind type="Another pension" />
  1899.         <information_ind type="Transfer Another Arrangement" />
  1900.         <information_ind type="Transfer Benefits Current" />
  1901.         <notes type="Additional Information" />
  1902.       </policy>
  1903.       <policy sequence_number="4" category="Preserved Pension">
  1904.         <benefit type="Pension benefit" />
  1905.         <benefit type="Current fund" />
  1906.         <duration />
  1907.         <fund />
  1908.         <information_ind type="Another pension" />
  1909.         <information_ind type="Transfer Another Arrangement" />
  1910.         <information_ind type="Transfer Benefits Current" />
  1911.         <notes type="Additional Information" />
  1912.       </policy>
  1913.       <policy sequence_number="5" category="Preserved Pension">
  1914.         <benefit type="Pension benefit" />
  1915.         <benefit type="Current fund" />
  1916.         <duration />
  1917.         <fund />
  1918.         <information_ind type="Another pension" />
  1919.         <information_ind type="Transfer Another Arrangement" />
  1920.         <information_ind type="Transfer Benefits Current" />
  1921.         <notes type="Additional Information" />
  1922.       </policy>
  1923.       <policy sequence_number="6" category="Preserved Pension">
  1924.         <benefit type="Pension benefit" />
  1925.         <benefit type="Current fund" />
  1926.         <duration />
  1927.         <fund />
  1928.         <information_ind type="Transfer Another Arrangement" />
  1929.         <information_ind type="Transfer Benefits Current" />
  1930.         <notes type="Additional Information" />
  1931.       </policy>
  1932.       <liability sequence_number="1">
  1933.         <repayment>
  1934.           <frequency>Monthly</frequency>
  1935.           <duration />
  1936.         </repayment>
  1937.         <notes type="Additional information" />
  1938.         <information_ind type="Another liability" />
  1939.       </liability>
  1940.       <liability sequence_number="2">
  1941.         <repayment>
  1942.           <frequency>Monthly</frequency>
  1943.           <duration />
  1944.         </repayment>
  1945.         <notes type="Additional information" />
  1946.         <information_ind type="Another liability" />
  1947.       </liability>
  1948.       <liability sequence_number="3">
  1949.         <repayment>
  1950.           <frequency>Monthly</frequency>
  1951.           <duration />
  1952.         </repayment>
  1953.         <notes type="Additional information" />
  1954.         <information_ind type="Another liability" />
  1955.       </liability>
  1956.       <liability sequence_number="4">
  1957.         <repayment>
  1958.           <frequency>Monthly</frequency>
  1959.           <duration />
  1960.         </repayment>
  1961.         <notes type="Additional information" />
  1962.         <information_ind type="Another liability" />
  1963.       </liability>
  1964.       <liability sequence_number="5">
  1965.         <repayment>
  1966.           <frequency>Monthly</frequency>
  1967.           <duration />
  1968.         </repayment>
  1969.         <notes type="Additional information" />
  1970.         <information_ind type="Another liability" />
  1971.       </liability>
  1972.       <liability sequence_number="6">
  1973.         <repayment>
  1974.           <frequency>Monthly</frequency>
  1975.           <duration />
  1976.         </repayment>
  1977.         <notes type="Additional information" />
  1978.       </liability>
  1979.       <gift sequence_number="1">
  1980.         <Information_ind type="Another gift" />
  1981.       </gift>
  1982.       <gift sequence_number="2" />
  1983.       <gift sequence_number="3" />
  1984.       <gift sequence_number="4" />
  1985.       <gift sequence_number="5" />
  1986.       <gift sequence_number="6" />
  1987.       <notes type="Referral" />
  1988.       <notes type="Investment asset summary" />
  1989.       <notes type="Investment asset source" />
  1990.       <notes type="Your Personal Review 1" />
  1991.       <notes type="Dependants" />
  1992.       <notes type="Family protection summary" />
  1993.       <notes type="Family protection existing provision" />
  1994.       <notes type="Family Protection Income" />
  1995.       <notes type="Family Protection Lumpsum" />
  1996.       <notes type="Protection policy summary" />
  1997.       <notes type="Additional information" />
  1998.       <notes type="Fixed assets" />
  1999.       <notes type="Mortgage" />
  2000.       <notes type="Liabilities" />
  2001.       <notes type="Retirement analysis" />
  2002.       <notes type="Long Term Care" />
  2003.       <notes type="Key facts" />
  2004.       <notes type="Savings" />
  2005.       <notes type="Joint Investment analysis" />
  2006.       <notes type="Client Investment analysis" />
  2007.       <notes type="Partner Investment analysis" />
  2008.       <notes type="Long Term Care Calculator" />
  2009.       <notes type="Affordability" />
  2010.       <notes type="Income expenditure summary" />
  2011.       <notes type="General expenditure" />
  2012.       <notes type="Mortgage analysis" />
  2013.       <notes type="Pensions summary" />
  2014.       <notes type="IHT" />
  2015.       <notes type="Replacement policy" />
  2016.       <notes type="Critical illness analysis" />
  2017.       <notes type="Client disability analysis" />
  2018.       <notes type="Partner disability analysis" />
  2019.       <notes type="Agenda" />
  2020.       <notes type="Notes summary" />
  2021.       <notes type="Portfolio considerations" />
  2022.     </factfind>
  2023.     <document type="Introductory Pack">
  2024.       <information_ind type="Received" code="" />
  2025.       <date type="Received">
  2026.         <date />
  2027.       </date>
  2028.     </document>
  2029.     <document type="Cost of service" />
  2030.     <document type="Product range">
  2031.       <date />
  2032.     </document>
  2033.     <MI>
  2034.       <source_of_enquiry />
  2035.       <introducer>
  2036.         <company_name />
  2037.         <branch />
  2038.       </introducer>
  2039.       <referral />
  2040.       <information_ind type="DPA" code="N">No</information_ind>
  2041.       <information_ind type="Observed interview" code="N">No</information_ind>
  2042.       <information_ind type="Business checked" code="N">No</information_ind>
  2043.       <contact type="Presentation meeting">
  2044.         <date />
  2045.       </contact>
  2046.       <contact type="First meeting">
  2047.         <date>
  2048.           <date />
  2049.         </date>
  2050.         <venue />
  2051.       </contact>
  2052.       <contact type="First contact">
  2053.         <date>
  2054.           <date />
  2055.         </date>
  2056.         <method />
  2057.       </contact>
  2058.       <case_referral_number />
  2059.     </MI>
  2060.   </case>
  2061. </message>
Oct 4 '08 #4
Dormilich
8,658 Expert Mod 8TB
you have to add the xml namespace to your xsl.
Expand|Select|Wrap|Line Numbers
  1. <?xml version="1.0"?>
  2. <xsl:stylesheet version="1.0" 
  3.     xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  4.     xmlns:mskichu="somexsd"
  5.     xmlns="somexsd">
note: if this still doesn't work, you have to add the namespace prefix to your XPath expressions.

on the other hand, if you need the namespace for xsd validation, define it as xmlns:xsd (not as default namespace).

regards
Oct 4 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: AA | last post by:
Hello, I need to extract an element from a xml document something like this <myXml> <Header> <Name/> <LastName/> <Age/> </Head> <Body> <Properties>
6
by: Martin | last post by:
Hi, I have a xml file like the one below <?xml version="1.0" encoding="utf-8"?><e1 xmlns:e1="http://tempuri.org/Source1.xsd" e1:att1="1" e1:att2="2" e1:rest="345"/> If I try to create a...
2
by: Rick | last post by:
I have an XML document that is generated from Infopath, I need to change the value of a namespace that is defined in a node in the form: <xsf:xDocumentClass "xmlns:my=valuehere">. when i navigate...
5
by: nospam | last post by:
I'm trying to transform an xml file that contains empty short elements like the following: <element attrib="abc"/> using the XmlTransform class. But I cannot seem to preserve the short format...
4
by: ina | last post by:
Hello all, I am newbie in xml and have a problem with this parse. I have this xml.file <Style> <Strategy>
2
by: tschwartz | last post by:
I have an xml document in which elements are hierarchically related to eachother conceptually. Unfortunately, the hierarchical relationship is not modelled in the schema (i.e., the elements are...
3
by: Andy Dingley | last post by:
>From a thread over in c.i.w.a.h "RFC: From XHTML to HTML via XSLT" http://groups.google.co.uk/group/comp.infosystems.www.authoring.html/msg/f112c230061ffe86 As is well-known, the XSLT HTML...
6
by: kluge.wolfram | last post by:
Hi, i get stucked on a transformation problem using XSLT. What i need is to copy an XML Tree to an output XML without any automatic changes. Since i used <xsl:copyor <xsl:copy-ofthere occur...
6
by: John Larson | last post by:
Hi All, I am some information from INSPEC database records in XML to build a relational database of my own. I am currently trying to extract information by doing an XSLT transform of the XML...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.