Implementing Apriori Algorithm with XQuery - XML / XSL Discussion Boards

First Prev Next

reconfirm

santoshkumar11876-Mar-12 7:06

santoshkumar1187

6-Mar-12 7:06

hello

Re: reconfirm

Chandrasekharan P9-Apr-12 21:02

Chandrasekharan P

9-Apr-12 21:02

Validation failed!!!

"GET OUT OF HERE" was the message

Every new day is another chance to change your life.

xml data will not display on the screen on a php page

awolarczuk1-Mar-12 0:05

awolarczuk

1-Mar-12 0:05

Hi all
I have a php page with is connected to a xml file to display the data, for some reason this data will not display it will only dispplay the header and footer, i have worked out there has to be something wrong with the products.php as when i use a problem called xlm notepad and open the xml and attach the XLST or XLS it will display in the text window

if someone could please tell me how to get this fixed as i need to get it fixed asap

here is the code for the product.php

HTML

<!-- 
  Adby Designs
  By Adam Wolarczuk
  Aug 2011
-->

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"  "http://www.w3.org/TR/html4/loose.dtd">

<html lang="en">

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<title>Products - Australian Financial and Mortgage Services </title>
		
		<meta http-equiv="content-script-type" content="text/javascript" >
		<meta http-equiv="content-type" content="text/html;charset=iso-8859-1" >
		<link href="settings.css" rel="stylesheet" type="text/css">


</head>

<body>
	<div id="container"><!-- Top of the page and page location -->
		
		<div id= "ptitle">PRODUCTS AND SERVICES</div>
		
		<?php include("menu.php"); ?>
		
		<?php

	 // $product = $_GET['product']
			// (use '//' to comment out a single line)
	
				  $xp = new XsltProcessor();
				 // $product = $_GET['product']
				
				  $xsl = new DomDocument;
				  $xsl->load('products.xsl');
				  
				  $xp->importStylesheet($xsl);
				  
				  $xml_doc = new DomDocument;
				  $xml_doc->load('products.xml');
				
				  $xp->setParameter('', 'product', 1);
				 
				      if ($html = $xp->transformToXML($xml_doc)) {
				      echo $html;
				  } else {
				      trigger_error('XSL transformation failed.', E_USER_ERROR);
  }			   ?>
		
		
		<!-- *****This is for the bottom table links****-->
		
			<?php include("footer.php"); ?>

		<!--**** This is for the bottom table links***-->

	<!-- Bottom  of the page and page location -->
  
    
    </div>


</body>

</html>

this is the code for the products.xml

<products>
    <product cat-ref="HL" id="HL01">
        <title lang="en">Standard Variable</title>
        <Description>
            <p>
            	"Standard Variable"
            	A standard variable loan offers the customer freedom of choice with complete
                repayment flexibility and a full range of features. <br/> The interest rate on these
                types of loans fluctuates (up or down) as interest rates change in our financial
                markets.</p>

           
          <list type="numbered">
                <list-intro>There are additional benefits associated with a standard variable
                    loan:</list-intro>

                <list-item>Flexibility to choose between interest only repayments or principal and
                    interest repayments.</list-item>
                <list-item>Redraw facility is available and you can utilise this option to redraw
                    payments already made in advance.</list-item>
                <list-item>You can have a partial or 100% interest offset facility attached to your
                    loan when the loan includes repayments for principal and interest. Interest
                    offset is not available on interest only loans.</list-item>
                <list-item>Principal reduction may be made at any time without attracting additional
                    fees.</list-item>
                <list-item>You also have the option of taking the loan over a maximum of 30 years
                    but you can opt to repay your loan in full within a shorter period of time
                    without attracting additional penalty charges.</list-item>
                <list-item>Clients can make as many additional payments to their standard variable
                    loan as they wish.</list-item>
            </list>          

            <p>It is important to note that lenders may have other associated costs to cover
                administration fees. Our consultants can compare these facilities and ensure that
                the appropriate loan structure is put in place to help you achieve your financial
                needs.<br/></p>
        </Description>
    </product>
    <product cat-ref="HL" id="HL02">
        <title lang="en">Basic Variable</title>
        <Description>
			Basic Variable
            <p>Basic variable rate loans are sometimes referred to as the 'no frills' alternative to the standard 
			variable rate loans. The interest rate is lower than a standard variable loan, making them attractive 
			to the budget conscious borrower. It offers a lower variable rate but with fewer features. These loans 
			normally have no ongoing fees associated with it.</p>
        </Description>
    </product>
	
	  <product cat-ref="HL" id="HL03">
        <title lang="en">Introductory (Honeymoon)</title>
        <Description>
            Introductory (Honeymoon)
	
			<p>An Introductory Variable Rate loan generally offers a guaranteed low rate for an initial period of 
			time (usually 12 months) after which most interest rates will revert to the Standard Variable Rate.
			It is Ideal for those wishing to take advantage of lower initial repayments.</p>
        </Description>
    </product>
	
		  <product cat-ref="HL" id="HL04">
        <title lang="en">Fixed Rate Loan</title>
        <Description>
            Fixed Rate Loan
	
			<p>Fixed rate loans are funds lent over a set term at a set interest rate. This gives the borrower 
			the certainty of knowing exactly what their monthly repayments will be should their circumstances change. 
			Some lenders may impose early repayment penalties if you make a lump sum reduction to your loan or you pay 
			the loan out in full. However, a fixed rate loan is ideal in a rising interest rate market as this guarantees
			you of your interest rate and repayments for a set time.</p>
        </Description>
    </product>
	
		  <product cat-ref="HL" id="HL05">
        <title lang="en">Refinancing</title>
        <Description>
            Refinancing
	
			<p>Mortgage refinancing is a process of renegotiating your original mortgage agreement. </p>

			<p>With the lending sector constantly changing and lenders constantly enhancing their products to attract new customers, existing customers are left behind, often with products that are no longer as well placed in the market as they once were. It is always important to keep an eye on how your mortgage stacks up against current market leaders and having a mortgage broker can simplify this for you.</p>

			<p>While there are inherent costs in altering your existing mortgage you must compare these to the savings made over the entire term of your loan.</p>
        </Description>
    </product>
    
     <product cat-ref="HL" id="HL06">
        <title lang="en">Bridging Loan</title>
        <Description>
            Bridging Loan
	
			<p>A Bridging Loan is available to borrowers who wish to purchase a new home now and sell your current home later. 
			These loans are especially helpful to 'bridge' the gap between the sale of one property and the purchase of another.
			 The interest rate on a Bridging Home Loan is usually the same as a Standard Variable Rate Loan. A Bridging Loan ensures 
			 that the borrower will not miss out on a desired property because they haven't sold the current home</p>
        </Description>
    </product>



    <product cat-ref="NCL" id="NCL02">
        <title lang="en">Credit Impaired</title>
        <Description>
            <p>Low Documentation (or No documentation) loans are designed for the self-employed or small company borrower whose financial statements may not be available for many different reasons (eg Accountant hasn't completed their financials). The borrower must have a sizeable deposit or equity in existing real estate property. Generally, most lenders lend a maximum of 80% of the property value with mortgage insurance applying above 60%.</p>

			<p>These loans are usually a variable rate and offer most of the features and benefits attached to the lender's standard variable rate loan product. A Low Document Loan can be just as competitive as a full documentation loan, however they provide less hassle as the borrower doesn't have to provide the lender income documentation.</p>
        </Description>
    </product>
    
    <product cat-ref="NCL" id="NCL03">
        <title lang="en">Low Document Loans</title>
        <Description>
            <p>At some point in the past, a borrower may have experienced difficulty in meeting their monthly commitments due to lack of work, suffered unexpected business losses or had a difference of opinion with a former credit provider. Unfortunately, in these cases the former credit provider may have lodged a payment default (or black mark) on their credit report with a credit recording agency. When applying for finance, a default lodged on a credit report may cause some frustration as a lender may not take an understanding view of the borrower’s explanation surrounding the default.</p>
        </Description>
    </product>
    
     <product cat-ref="NCL" id="NCL04">
        <title lang="en">Second Mortgages</title>
        <Description>
        
        	<p>Second Mortgages</p>
            <p>A second mortgage is an additional loan on a property. Second mortgages usually carry a higher interest charge as the first mortgage carries first priority in the case of default. The second mortgage also carries rights to the property, but these are subordinate to those of the first mortgage. In the case of approving a client for a second mortgage, the lender will calculate the affordability and risk of the first mortgage before calculating whether you would be able to meet any additional repayments.</p>
        </Description>
    </product>


    <product cat-ref="CEL" id="CEL01">
        <title lang="en">Hire Purchase</title>
        <Description>
        <p>Hire Purchase</p>
            <p>The Hire Purchase Agreement is simply a contract where the lender allows the client the right to possess and use an item of equipment in return for regular payments. When the final payment is made, the title of the goods is transferred to the customer. This product is designed for businesses wishing to finance the purchase of motor vehicles and trucks, industrial plant and equipment, business and professional equipment.
Features and benefits include:</p>

  <list type="numbered">
                <list-intro>Features and benefits include:</list-intro>

                <list-item>Repayment schedules can be structured to suit a customer’s cash flow.</list-item>
                <list-item>Can be arranged with no deposit or an amount that suits the customer.</list-item>
                <list-item>Flexible repayments allow for accurate capital budgeting..</list-item>
                <list-item>Balloon payments at the end of the term can be arranged</list-item>
                 <list-item>Client gains automatic ownership at end of term..</list-item>
                <list-item>Interest and depreciation are tax deductible if business expense.</list-item>
                <list-item>Client can repay the contract before the term ends.</list-item>

            
            </list>      
        </Description>
    </product>
    
     <product cat-ref="CEL" id="CEL02">
        <title lang="en">Finance Lease</title>
        <Description>
            <p>Finance Lease</p>
            
            <p>Here the lender purchases the plant, equipment or vehicle required by the client (the lessee). The lender then leases the goods to the customer under a lease agreement.
When the lease expires the lessee can either:.</p>
        <list type="numbered">
                <list-intro>There are additional benefits associated with a standard variable
                    loan:</list-intro>

                <list-item>Return the equipment to the lender who can sell it elsewhere. If the net sale is less than the residual value, the customer must make up the shortfall.</list-item>
                <list-item>Refinance the residual value.</list-item>
                <list-item>Pay out the contract.</list-item>
                <list-item>Make an offer to purchase, which may be accepted by the lender..</list-item>
            
            </list>          




 </Description>
    </product>
    
         <product cat-ref="BF" id="BF01">
        <title lang="en">Commercial Mortgages</title>
        <Description>
            <b>Commercial Mortgages</b>
            
            <p>A commercial mortgage is similar to a regular residential loan except that the loan is applied to a purchase of commercial property. Commercial property generally includes retail shops or offices, warehouses and factory units.</p>
            <p>Commercial mortgages are handled the same way as regular residential mortgages in that lenders want to ensure that their money will be making them more money. They will want to certify that the property being targeted is worth their investment and that the borrower’s credentials are trustworthy.</p>
            <p>If you are looking to acquire a commercial mortgage the first thing to do is put together a package detailing the potential of the property your want to buy. If possible you should do a little market research that demonstrates the property’s main selling points such as: if it is in a high traffic area, if it is easily accessible, etc… any feature that will make it more attractive in the eyes of a lender, whose main goal is to know that he or she will not lose money on this deal.</p>
            <p>Finding the right lender is the next step and that is where we come in. We do more than just find the right lender for their clients; we also offer support, information and advice. Commercial property can be a great investment if well located and properly managed.</p>
                    




 </Description>
    </product>
    
            <product cat-ref="BF" id="BF02">
        <title lang="en">Short Term Business Loans</title>
        <Description>
            <b><u>Short Term Business Loans</u></b>
            
            <p>From time to time business or investors find themselves in a situation where they need funds to get them through a short term slump, or to take advantage of a lucrative investment opportunity that presents itself. The business or investor may not be able to access normal loan funds in time to ward off financial difficulties or to take advantage of the opportunity that has presented itself. In both cases short term business loans may be the answer. Short term business loans are for business purposes only and usually the term is measured in months rather than years. The rate is much higher than normal business loans, (3%-10% per month are standard) but are usually easy and quick to obtain. These are pure asset lends with a maximum LVR of 80%. As it is a straight asset lend, credit checks and financials are not usually required.</p>
            




 </Description>
    </product>
    
      <product cat-ref="BF" id="BF03">
        <title lang="en">Medium-Long Term Business Loans</title>
        <Description>
            <b><u>Medium-Long Term Business Loans</u></b>
            
        <p>Many bank lenders charge hefty interest rate penalties for their business purpose loans. A surcharge of 1-2 percent is not uncommon and some overdraft rates are in excess of 12%. Non bank lenders are able to provide business purpose loans at the same rate as owner occupied home loan rates. If you need money for business purposes, why get ripped off by the banks when you can access the equity in your home or investment property at rates well below 7%.</p>
            




 </Description>
    </product>
    
     <product cat-ref="IP" id="IP01">
        <title lang="en">Why is an Investment Property a Good Strategy ?</title>
        <Description>
            <b><u>Why is an Investment Property a Good Strategy ?</u></b>
            
       <p>Most people like property because they can see it, touch it and watch it grow in value over a period of time. If bought in the right area (location), it can offer good returns in capital growth in future years. Also, the depreciation, coupled with rental income, makes this method an easy way to get into property and make it an attractive proposition.</p>
       <p>If you already own a property it makes getting into an investment property much easier as you can use the equity in your home as a deposit towards an investment property.</p>     




 </Description>
    </product>
    
         <product cat-ref="IP" id="IP02">
        <title lang="en">Negative Gearing</title>
        <Description>
            <b><u>Negative Gearing</u></b>
            
       <p>Negative Gearing is the situation when an investment such as property is purchased with the assistance of borrowed funds and where the rental income after the deduction of expenses (such as interest, bank fees, insurance and strata fees) is less than the interest commitment in the course of a financial year.</p>
     <p>For tax purposes this negative net income can then be offset against any positive income from other sources. This is a very handy tool in minimizing tax.</p>




 </Description>
    </product>
    
           <product cat-ref="IP" id="IP03">
        <title lang="en">Capital Gains Tax</title>
        <Description>
            <b><u>Capital Gains Tax</u></b>
            
      <p>Capital gains are the profits made on selling assets. Your primary place of residence is exempt from any capital gains tax. An investment property sold at a profit will attract a capital gains tax on the profit. The amount will be added to your regular income and taxed at your marginal rate. However, depending on your situation at the time of selling a property, the capital gains tax could be adjusted to be reduced by way of new investments put in place. You should get advice on this matter before selling so that you can structure it correctly.</p>




 </Description>
    </product>
    
       <product cat-ref="OP" id="OP01">
        <title lang="en">Line of Credit</title>
        <Description>
            <b><u>Line of Credit</u></b>
            
     <p>A Line of Credit provides a borrower with access to the equity in their home or investment properties whenever they wish for any worthwhile purpose. It is similar to an overdraft facility in that funds can be withdrawn up to the original loan approved amount at anytime. The interest rate on a Line of Credit facility is usually a variable rate that fluctuates with the market. A borrower can generally access their Line of Credit via a Cheque Book, Credit Card, ATM, Phone and Internet. A Line of Credit provides a borrower with easy access to funds ensuring peace of mind in times of need.</p>




 </Description>
    </product>
    
          <product cat-ref="OP" id="OP02">
        <title lang="en">Reverse Mortgages</title>
        <Description>
            <b><u>Reverse Mortgages</u></b>
            
     <p>Unlike conventional mortgage products reverse mortgages (also known as equity release), focus exclusively on a specific segment of the population: retirees. They allow retiring homeowners to access a largely untapped asset to fund a standard of living that for many would otherwise be out of reach. 
Reverse mortgages are similar to conventional residential mortgages in that the borrower raises funds against the security of the home. However, reverse mortgages are very different to conventional mortgages when it comes to drawdown, cash flow, and repayments.</p>
<p>In a normal mortgage, the principal amount of the loan is generally advanced as a lump sum to the borrower in order to a purchase a property. The borrower must then make regular principal and interest payments during the term of the loan. If the borrower defaults on the loan, the lender may recover the outstanding balance of the loan (including any unpaid interest) by enforcing its mortgage and selling the mortgaged home.
That is not the case with a reverse mortgage. In addition to having the option of receiving the principal in an upfront lump sum payment, the retiree can also choose to receive the principal in the form of regular part-payments from the lender during the term of the loan.
The retiree is not required to make any repayments (whether of principal or interest) to the lender during the term of the loan, however in some cases may have the option to do so. Instead, the entire loan (including accrued interest) falls due on the death of the retiree, or when the retiree moves out of the mortgaged home permanently, for example into a nursing home or if the property is sold.</p>
<p>The lender then recovers the loan by either having the beneficiaries of the retiree's estate pay the debt, or by enforcing its mortgage and selling the mortgaged home. In most cases, the lender will give the retiree's beneficiaries up to six months to finalise the debt. If the lender sells the property, they will give any funds left over to the estate of the retiree</p>


 </Description>
    </product>
    
    








    
    
    <categories>
        <category cat-id="HL">Home Loans</category>
        <category cat-id="NCL">Non-conforming Loans</category>
        <category cat-id="CEL">Car/Equipment Loans</category>
        <category cat-id="BF">Business Finance</category>
		<category cat-id="IP">Investment Property</category>
		<category cat-id="OP">Other Loans</category>
    </categories>
</products>

this is the code for the products.xsl

XML

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    version="1.0">
    <xsl:key name="product-by-cat" match="product" use="@cat-ref"/>
    <xsl:key name="product-by-id" match="product" use="@id"/>
    
    <xsl:strip-space elements="*"/>
    <xsl:output indent="yes"/>
    
    <xsl:param name="product"/>
    <xsl:param name="base-page" select="'product.php'"/>
    
    <xsl:template match="products">
        <div id="productsdesc">
            <xsl:if test="normalize-space($product)">
                <xsl:apply-templates select="key('product-by-id', $product)/Description"/>
            </xsl:if>
        </div>
        <div id="products">
                     <table>
                        <xsl:for-each select="categories/category[position() mod 3 = 1]">
                            <tr>
                                <th><xsl:apply-templates select="."/></th>
                                <th><xsl:apply-templates select="following-sibling::category[1]"/></th>
                                <th><xsl:apply-templates select="following-sibling::category[2]"/></th>
                            </tr>
                            <xsl:call-template name="get-next-row">
                                <xsl:with-param name="cat1" select="@cat-id"/>
                                <xsl:with-param name="cat2" select="following-sibling::category[1]/@cat-id"/>
                                <xsl:with-param name="cat3" select="following-sibling::category[2]/@cat-id"/>
                                <xsl:with-param name="count" select="1"/>
                            </xsl:call-template>
                        </xsl:for-each>
                    </table>
        </div>
    </xsl:template>
    
    <xsl:template name="get-next-row">
        <xsl:param name="cat1"/>
        <xsl:param name="cat2"/>
        <xsl:param name="cat3"/>
        <xsl:param name="count"/>
        <xsl:if test="key('product-by-cat', $cat1)[position() = $count ]| key('product-by-cat', $cat2)[position() = $count] | key('product-by-cat', $cat3)[position() = $count]">
            <tr>
                <td><a href="{concat($base-page, '?product=', key('product-by-cat', $cat1)[position() = $count ]/@id)}"><xsl:apply-templates select="key('product-by-cat', $cat1)[position() = $count ]/title"/></a></td>
                <td><a href="{concat($base-page, '?product=', key('product-by-cat', $cat2)[position() = $count ]/@id)}"><xsl:apply-templates select="key('product-by-cat', $cat2)[position() = $count ]/title"/></a></td>
                <td><a href="{concat($base-page, '?product=', key('product-by-cat', $cat3)[position() = $count ]/@id)}"><xsl:apply-templates select="key('product-by-cat', $cat3)[position() = $count ]/title"/></a></td>
            </tr>
            <xsl:call-template name="get-next-row">
                <xsl:with-param name="cat1" select="$cat1"/>
                <xsl:with-param name="cat2" select="$cat2"/>
                <xsl:with-param name="cat3" select="$cat3"/>
                <xsl:with-param name="count" select="$count + 1"/>
            </xsl:call-template>
        </xsl:if>
    </xsl:template>
    
    <xsl:template match="p">
        <p>
            <xsl:apply-templates select="node()"/>
        </p>
        <br/>
    </xsl:template>
    
    <xsl:template match="list">
        <p class="list_intro">
            <xsl:apply-templates select="list-intro"/>
        </p>
        <br/>
        <ol>
            <xsl:for-each select="list-item">
                <li><xsl:apply-templates/></li>
            </xsl:for-each>
        </ol>
    </xsl:template>
    
    
</xsl:stylesheet>

this is the code for the products.xlst

XML

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    version="1.0">
    <xsl:key name="product-by-cat" match="product" use="@cat-ref"/>
    <xsl:key name="product-by-id" match="product" use="@id"/>
    
    <xsl:strip-space elements="*"/>
    <xsl:output indent="yes"/>
    
    <xsl:param name="product"/>
    <xsl:param name="base-page" select="'../product.php'"/>
    
    <xsl:template match="products">
        <div id="productsdesc">
            <xsl:if test="normalize-space($product)">
                <xsl:apply-templates select="key('product-by-id', $product)/Description"/>
            </xsl:if>
        </div>
        <div id="products">
                     <table>
                        <xsl:for-each select="categories/category[position() mod 3 = 1]">
                            <tr>
                                <th><xsl:apply-templates select="."/></th>
                                <th><xsl:apply-templates select="following-sibling::category[1]"/></th>
                                <th><xsl:apply-templates select="following-sibling::category[2]"/></th>
                            </tr>
                            <xsl:call-template name="get-next-row">
                                <xsl:with-param name="cat1" select="@cat-id"/>
                                <xsl:with-param name="cat2" select="following-sibling::category[1]/@cat-id"/>
                                <xsl:with-param name="cat3" select="following-sibling::category[2]/@cat-id"/>
                                <xsl:with-param name="count" select="1"/>
                            </xsl:call-template>
                        </xsl:for-each>
                    </table>
        </div>
    </xsl:template>
    
    <xsl:template name="get-next-row">
        <xsl:param name="cat1"/>
        <xsl:param name="cat2"/>
        <xsl:param name="cat3"/>
        <xsl:param name="count"/>
        <xsl:if test="key('product-by-cat', $cat1)[position() = $count ]| key('product-by-cat', $cat2)[position() = $count] | key('product-by-cat', $cat3)[position() = $count]">
            <tr>
                <td><a href="{concat($base-page, '?product=', key('product-by-cat', $cat1)[position() = $count ]/@id)}"><xsl:apply-templates select="key('product-by-cat', $cat1)[position() = $count ]/title"/></a></td>
                <td><a href="{concat($base-page, '?product=', key('product-by-cat', $cat2)[position() = $count ]/@id)}"><xsl:apply-templates select="key('product-by-cat', $cat2)[position() = $count ]/title"/></a></td>
                <td><a href="{concat($base-page, '?product=', key('product-by-cat', $cat3)[position() = $count ]/@id)}"><xsl:apply-templates select="key('product-by-cat', $cat3)[position() = $count ]/title"/></a></td>
            </tr>
            <xsl:call-template name="get-next-row">
                <xsl:with-param name="cat1" select="$cat1"/>
                <xsl:with-param name="cat2" select="$cat2"/>
                <xsl:with-param name="cat3" select="$cat3"/>
                <xsl:with-param name="count" select="$count + 1"/>
            </xsl:call-template>
        </xsl:if>
    </xsl:template>
    
    <xsl:template match="p">
        <p>
            <xsl:apply-templates select="node()"/>
        </p>
        <br/>
    </xsl:template>
    
    <xsl:template match="list">
        <p class="list_intro">
            <xsl:apply-templates select="list-intro"/>
        </p>
        <br/>
        <ol>
            <xsl:for-each select="list-item">
                <li><xsl:apply-templates/></li>
            </xsl:for-each>
        </ol>
    </xsl:template>
    
    
</xsl:stylesheet>

thank you all for your help in advance

generating html tree from xml file using xslt.

anikbutt2210-Feb-12 1:41

anikbutt22

10-Feb-12 1:41

hi guys.i want to generate html tree from xml file using xslt.. how can i do tht.. i have tried plenty of examples from net.. but didnt get the correct.. code... plz reply.. regards,

How to open zipfile and xls

Themba Zwane8-Feb-12 7:53

Themba Zwane

8-Feb-12 7:53

How to open Zip file and Xls files

Re: How to open zipfile and xls

Richard MacCutchan8-Feb-12 21:54

Richard MacCutchan

8-Feb-12 21:54

In what language, for what purpose?

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

Re: How to open zipfile and xls

ZurdoDev19-Mar-12 9:02

ZurdoDev

19-Mar-12 9:02

Double-click on it.

There are only 10 types of people in the world, those who understand binary and those who don't.

Implementing Apriori Algorithm with XQuery

helloworld202018-Jan-12 1:47

helloworld2020

18-Jan-12 1:47

Hi,

I am trying to implement Apriori Algorithm(Mining Association Rules from XML Data) with XQuery. Unfortunately, I am not familiar with XQuery language. So, I need your help to fix the bug in the code given below

xquery version "1.0";

declare function  apriori($l,  $L,  $minsup, $total, $src)
{
let $C := removeDuplicate(candidateGen($l))
let $l := getLargeItemsets($C, $minsup, $total, $src)
let $L := $l union $L
return if (empty($l)) then
$L
else
 apriori($l, $L, $minsup, $total, $src)
}

let $src := doc(/transactions.xml)//items
let $minsup := 0.4
let $total := count($src) * 1.00
let $C := distinct-values($src/*)
let $l :=(for $itemset in $C
let $items := (for $item in $src/*
where $itemset = $item
return $item)
let $sup := (count($items) * 1.00) div $total
where $sup >= $minsup
return <largeItemset>
<items> {$itemset} </items>
<support> {$sup} </support>
</largeItemset>)
let $L := $l
return <largeItemsets> {apriori($l, $L,$minsup, $total, $src)}
</largeItemsets>

Error:
[DataDirect][XQuery][err:XPST0003]Error at line 14, column 1. Expected ";", but encountered "let"

Thanks for any help Smile | :)

splitting the xmlnode based on nodelength

harinit11-Jan-12 22:20

harinit

11-Jan-12 22:20

Hi,

My Sample XML is as follows:

<Students>
  <Student>
    <roll id="1" />
    <StudName id="stud1" />
    <Class1 val="cls1" />
    <Class2 val="cls2" />
    <Class3 val="cls3" />
    <Class4 val="cls4" />
    <Class5 val="cls5" />
    <Class6 val="cls6" />
  </Student>
  <Student>
    <roll id="2" />
    <StudName id="stud2"/>
    <Class1 val="cls7" />
    <Class2 val="cls8" />
    <Class3 val="cls9" />
    <Class4 val="cls10" />
    <Class5 val="cls11" />
    <Class6 val="cls12" />
    </Student>
  <Student>
    <roll id="3" />
    <StudName id="stud3" />
    <Class1 val="cls13" />
    <Class2 val="cls14" />
    <Class3 val="cls15" />
    <Class4 val="cls16" />
    <Class5 val="cls17" />
    <Class6 val="cls18" />
    </Student>
  <Student>
    <roll id="4" />
    <StudName id="stud4" />
    <Class1 val="cls19" />
    <Class2 val="cls20" />
    <Class3 val="cls21" />
    <Class4 val="cls22" />
    <Class5 val="cls23" />
    <Class6 val="cls24" />
   </Student>
  <Student>
    <roll id="5" />
    <StudName id="stud5" />
    <Class1 val="cls25" />
    <Class2 val="cls26" />
    <Class3 val="cls27" />
    <Class4 val="cls28" />
    <Class5 val="cls29" />
    <Class6 val="cls30" />
   </Student>
</Students>

Now i need to prepare XSLT such that if nodes are more than 3 then i need to get only roll and studname nodes.

I need to get the result as

<Students>
  <Student>
    <roll id="1" />
    <StudName id="stud1" />    
  </Student>
  <Student>
    <roll id="2" />
    <StudName id="stud2"/>    
    </Student>
  <Student>
    <roll id="3" />
    <StudName id="stud3" />
    </Student>
  <Student>
    <roll id="4" />
    <StudName id="stud4" />
   </Student>
  <Student>
    <roll id="5" />
    <StudName id="stud5" />
   </Student>
</Students>

Please provide me the required XSLT such that i need to get the above output...
Thanks in advance

Harini

Re: splitting the xmlnode based on nodelength

chriselst13-Jan-12 0:48

chriselst

13-Jan-12 0:48

I don't understand;

harinit wrote:
if nodes are more than 3

From your input and output it looks as if you are doing nothing more than removing all the ClassX nodes.

Every man can tell how many goats or sheep he possesses, but not how many friends.

Re: splitting the xmlnode based on nodelength

harinit16-Jan-12 22:37

harinit

16-Jan-12 22:37

Hi i am sorry for not explaining correctly...
My sample xml is as follows:

<Students>
  <Student>
    <roll id="1" />
    <StudName id="stud1" />
    <Class1 val="cls1" />
    <Class2 val="cls2" />
    <Class3 val="cls3" />
    <Class4 val="cls4" />
    <Class5 val="cls5" />
    <Class6 val="cls6" />
  </Student>
  <Student>
    <roll id="2" />
    <StudName id="stud2"/>
    <Class1 val="cls7" />
    <Class2 val="cls8" />
    <Class3 val="cls9" />
    <Class4 val="cls10" />
    <Class5 val="cls11" />
    <Class6 val="cls12" />
    </Student>
  <Student>
    <roll id="3" />
    <StudName id="stud3" />
    <Class1 val="cls13" />
    <Class2 val="cls14" />
    <Class3 val="cls15" />
    <Class4 val="cls16" />
    <Class5 val="cls17" />
    <Class6 val="cls18" />
    </Student>
  <Student>
    <roll id="4" />
    <StudName id="stud4" />
    <Class1 val="cls19" />
    <Class2 val="cls20" />
    <Class3 val="cls21" />
    <Class4 val="cls22" />
    <Class5 val="cls23" />
    <Class6 val="cls24" />
   </Student>
  <Student>
    <roll id="5" />
    <StudName id="stud5" />
    <Class1 val="cls25" />
    <Class2 val="cls26" />
    <Class3 val="cls27" />
    <Class4 val="cls28" />
    <Class5 val="cls29" />
    <Class6 val="cls30" />
   </Student>
</Students>

We need to get the length of xml node including child nodes.
Suppose if the length of xml exceeds the configured length then it should be formatted as small xml file with root elements.

Example: consider the <student> node(including child nodes) exceedes the length 100 then we should format the xml as given below using XSLT.

<Students>
  <Student>
    <roll id="1" />
    <StudName id="stud1" />
    <Class1 val="cls1" />
    <Class2 val="cls2" />
    <Class3 val="cls3" />
    <Class4 val="cls4" />
    <Class5 val="cls5" />
    <Class6 val="cls6" />
  </Student>
</Students>

<Students>
  <Student>
    <roll id="2" />
    <StudName id="stud2"/>
    <Class1 val="cls7" />
    <Class2 val="cls8" />
    <Class3 val="cls9" />
    <Class4 val="cls10" />
    <Class5 val="cls11" />
    <Class6 val="cls12" />
  </Student>
</Students>

Re: splitting the xmlnode based on nodelength

woopsydoozy16-Mar-12 7:59

woopsydoozy

16-Mar-12 7:59

XML

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>
    <xsl:output method="xml" indent="yes"/>

    <xsl:template match="Students">
      <Students>
        <xsl:for-each select="*">
          <xsl:choose>
            <xsl:when test="count(./*) > 3">
              <Student>
                <xsl:copy-of select="roll"/>
                <xsl:copy-of select="StudName"/>
              </Student>
            </xsl:when>
            <xsl:otherwise>
              <xsl:copy-of select="."/>
            </xsl:otherwise>
          </xsl:choose>
        </xsl:for-each>
      </Students>
    </xsl:template>
</xsl:stylesheet>

VStudio and xsd.exe create different schema

Tomerland4-Jan-12 10:22

Tomerland

4-Jan-12 10:22

Dear readers,

for an xml-file I creat the corresponding schema-file (.xsd) in two ways: a) with VStudio and b) with the tool "xsd.exe"

Both results are in some way different. e.g. at data-types or at the label "minoccurs". It seems not to be so dramatic.

But, I use these schema-files for xmlmaps in excel, and here I have a dramatic impact. I get totally different behavior for both xsd-version.

Does anybody know, why both tools give a different result?

For my use-case, the VStudio-generated xsd is better, but how can I access is without Vstudio?

Thanks in advance

how to look for a VALUE in an xml document. Not a node.

dotolee12-Dec-11 7:22

dotolee

12-Dec-11 7:22

How do i check if a certain value exists?
For example, if my document looks like this:

HTML

<Systems>
    <systemData>
         <name>Name1</name>
         <status>Active</status>
         <slot>0</slot>
    </systemData>
    <systemData>
         <name>Name2</name>
         <status>Active</status>
         <slot>1</slot>
    </systemData>
</Systems>

how would i query the document to see if "Name1" exists?

Re: how to look for a VALUE in an xml document. Not a node.

Tarun.K.S12-Dec-11 18:10

Tarun.K.S

12-Dec-11 18:10

Hi,

You can use XPath for this.
Below is a code snippet:

XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(@"C:\SystemX.xml");   // Loading the xml file stored in C drive.

string xPath = "/Systems/systemData[name='Name5']";  // XPath expression to find Name5
XmlNode xmlNode = xmlDoc.SelectSingleNode(xPath);  // Find the node.

// If not found, show warning.
if (xmlNode == null)
{
   MessageBox.Show("Name5 not found");
}

Hope this helps.
Good luck! Thumbs Up | :thumbsup:

Integrity is telling myself the truth. And honesty is telling truth to other people.

My Blog![^]

Re: how to look for a VALUE in an xml document. Not a node.

Member 86251126-Mar-12 22:40

Member 8625112

6-Mar-12 22:40

XmlNode NodeItems = XMLdoc.SelectSingleNode("Systems/Systemdata/name");

NodeItem.InnerText will give you VALUE in particular node

How to load xml questions into jquery flipcard?

burakmartonalti14-Nov-11 19:16

burakmartonalti

14-Nov-11 19:16

Hello everyone,

I have an xml file name is questions.xml, I am checking these questions by using .xsd file but I need to load them in to jquery flipcard in order to show them on the html file, I will paste my questions.xml file here so could you please help me how to load these questions one by one using jquery flipcard and xml file?

questions.xml

Statement of Intent
Cut-off Claim
Indian Reserve
Treaty Right

Esquimalt & Nanaimo Railway
Fiduciary Duty
Douglas Treaties
Indian Act

Indian Reserve
Esquimalt & Nanaimo Railway
Band
Section 35

First Nation
Band Council
Statement of Intent
Cut-off Claim

Esquimalt & Nanaimo Railway
Fiduciary Duty
Statement of Intent
Cut-off Claim

Indian Reserve
Section 35
Indian Act
First Nation

Indian Reserve
Douglas Treaties
Band
Indian Act

Indian Reserve
Band
Fiduciary Duty
First Nation

First Nation
Statement of Intent
Band Council
Indian Reserve

Treaty Right
Statement of Intent
Treaty
Section 35

Cut-off Claim
Treaty Right
First Nation
Indian Reserve

Indian Act
Treaty
Band Council
Treaty Right

Section 35
Band
First Nation
Statement of Intent

Statement of Intent
Readiness
Interim Measures
INAC (Indian & Northern Affairs)

Interim Measures
First Nation
Main Table
Ministry of Aboriginal Affairs (MAA)

INAC (Indian & Northern Affairs)
Unity Protocol
Ministry of Aboriginal Affairs (MAA)
Readiness

Unity Protocol
British Columbia Treaty Commission (BCTC)
Hul'qumi'num Treaty Group
First Nations Summit

Hul'qumi'num Treaty Group
INAC (Indian & Northern Affairs)
British Columbia Treaty Commission (BCTC)
Third Parties

Unity Protocol
Main Table
Interim Measures
Hul'qumi'num Treaty Group

INAC (Indian & Northern Affairs)
Hul'qumi'num Treaty Group
Ministry of Aboriginal Affairs (MAA)
Unity Protocol

Hul'qumi'num Treaty Group
Third Parties
Ministry of Aboriginal Affairs (MAA)
Interim Measures

Main Table
British Columbia Treaty Commission (BCTC)
Unity Protocol
Hul'qumi'num Treaty Group

Ministry of Aboriginal Affairs (MAA)
Interim Measures
Third Parties
First Nations Summit

Framework Agreement
Land-based Jurisdictional Model
Land Tenure
RFiscal Arrangements

Aboriginal Rights
Expropriation
Treaty Mandates
Extinguishment

Aboriginal Title
Land-based Jurisdictional Model
Crown Grant
Expropriation

Aboriginal Rights
Land Tenure
Fiscal Arrangements
Treaty Mandates

Extinguishment
Aboriginal Rights
Framework Agreement
Expropriation

Land Tenure
Aboriginal Title
Extinguishment
Aboriginal Rights

Treaty Mandates
Land-based Jurisdictional Model
Expropriation
Extinguishment

Aboriginal Rights
Crown Grant
Treaty Mandates
Aboriginal Title

Land Tenure
Extinguishment
Aboriginal Title
Crown Grant

Aboriginal Title
Framework Agreement
Expropriation
Fiscal Arrangements

Overlaps
Crown Activity
Agreement in Principle (AIP)
Traditional Territory

Food Fish
Traditional Territory
Crown Tenure
Underlying Title

Food Fish
Crown Activity
Crown Tenure
Underlying Title

Traditional Territory
Crown Land
Food Fish
Land Quantum

Agreement in Principle (AIP)
Crown Tenure
Sub-surface
Underlying Title

Crown Activity
Traditional Territory
Crown Land
Sub-Surface

Sub-surface
Agreement in Principle (AIP)
Food Fish
Crown Activity

Food Fish
Traditional Territory
Crown Activity
Underlying Title

Crown Land
Land Quantum
Crown Tenure
Crown Activity

Overlaps
Crown Land
Sub-surface
Land Quantum

Final Agreement
Constitution
Expropriation
Indemnity

Expropriation
Citizenship Code
Eligibity
Compensation

Citizenship Code
Constitution
Compensation
Final Agreement

Eligibity
Self-Government
Citizenship Code
Indemnity

Compensation
Eligibity
Constitution
Final Agreement

Constitution
Final Agreement
Eligibity
Expropriation

Compensation
Final Agreement
Constitution
Citizenship Code

Citizenship Code
Constitution
Eligibity
Indemnity

Jurisdiction
Legal Uniformity
Implementation
Ratification

Resource-revenue Sharing
Ratification
Cooperative Management
Specific Claim

Financial Transfer Arrangements
Treaty Settlement Land
First Nations Roads
Legal Uniformity

Jurisdiction
Resource-revenue Sharing
Cooperative Management
Treaty Settlement Land

First Nations Roads
Resource-revenue Sharing
Capacity-building
Implementation

Treaty Settlement Land
Legal Uniformity
Resource-revenue Sharing
Cooperative Management

Treaty Settlement Land
Jurisdiction
Cooperative Management
Legal Uniformity

Ratification
Resource-revenue Sharing
Specific Claim
Financial Transfer Arrangements

Implementation
First Nations Roads
Financial Transfer Arrangements
Capacity-building

Treaty Settlement Land
Financial Transfer Arrangements
First Nations Roads
Cooperative Management

Resource-revenue Sharing
Financial Transfer Arrangements
Specific Claim
Jurisdiction

Xslt Transformation

tellaston134527-Oct-11 6:03

tellaston1345

27-Oct-11 6:03

Hi Guys,
I am doing xslt transformation on a sample xmldoc using the xslt below. The problem I am having is its not matching on the 'Publication' tag. If I remove the namespace it works fine. Is there a way to get the match on the 'Publication' tag with the namespace in it?

Any help would be much appreciated,
Thanks.
----Sample XML------

XML

<?xml version="1.0" encoding="utf-8"?>
<Publication xmlns="http://www.mycompany.com/Sampleproject/XmlSchema">
  <PublicationDetails>
    <AgencyId>1</AgencyId>
    <PublicationId>PublicationId1</PublicationId>
    <PublicationDateTime>1900-01-01T01:01:01-07:00</PublicationDateTime>
    <OriginatingSystemName>OriginatingSystemName1</OriginatingSystemName>
    <DestinationSystemName>DestinationSystemName1</DestinationSystemName>
</Publication>

---- Sample Xslt ------

XML

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
  <xsl: output method="xml" indent="yes"/>

  <xsl:template match="@* | node()">
    <xsl:copy>
      <xsl:apply-templates select="@* | node()"/>
    </xsl:copy>
  </xsl:template>

  <xsl:template match="Publication">
      <xsl:apply-templates select ="PublicationDetails"/>
  </xsl:template>


  <xsl:template match="PublicationDetails">
    <SubmittingAgency>
    </SubmittingAgency>
  </xsl:template>

</xsl:stylesheet>

Exception: "XsltContext is needed for this query because of an unknown function"

NarVish20-Oct-11 22:57

NarVish

20-Oct-11 22:57

I would like to convert the text data to uppercase and I wrote the expression as below

"/RawData/page/text[upper-case(.)='ABC']"

its throwing an exception "XsltContext is needed for this query because of an unknown function"
Reference:
http://www.w3schools.com/xpath/xpath_functions.asp
a

Re: Exception: "XsltContext is needed for this query because of an unknown function"

NarVish21-Oct-11 0:49

NarVish

21-Oct-11 0:49

problem solved with translate function.

textNode = docRawData.SelectSingleNode("/RawData/page/text[translate(text(),\"abcdefghijklmnopqrstuvwxyz\",\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\")='" + rows[n].Trim() + "']");

XPath problem with % value

NarVish18-Oct-11 0:29

NarVish

18-Oct-11 0:29

Hi,

I'm trying to get the text element which contains value 1.345%, I tried as below to get the results. but the nodeList count is 0. please correct to get the correct results

XmlNodeList nodeList = rawData.SelectNodes("/RawData/page/text[.=<![CDATA[1.345%]]>");

If the value is simple text or integer, its working fine with the below code.

XmlNodeList nodeList = rawData.SelectNodes("/RawData/page/text[.='corporation'");

Re: XPath problem with % value

jschell18-Oct-11 8:52

jschell

18-Oct-11 8:52

Both examples are missing a right square backet. If your second example works though then that wouldn't be the cause. But you should still fix it.

Instead the problem is that you can't treat CDATA like that. At least googling suggests you can't.

Re: XPath problem with % value

NarVish18-Oct-11 18:39

NarVish

18-Oct-11 18:39

I just forgot to put right square bracket. what to do, to make it work with the value "10.5%" instead "corporation". Thanks in advance

XmlNodeList nodeList = rawData.SelectNodes("/RawData/page/text[.='corporation']");

Re: XPath problem with % value

NarVish18-Oct-11 22:00

NarVish

18-Oct-11 22:00

I found that the problem is not with "%". The values is having extra spaces as " 10.34%"

So the below expression is not working.
"/Data/page/content[.='10.34%']".

its working with the expression "/Data/page/content[.=' 10.34%']".
Please guide me to solve this issue. Thanks in advance

<Data>
<page>
<content>  10.34%</content>
</page>
</Data>

Re: XPath problem with % value

NarVish18-Oct-11 22:36

NarVish

18-Oct-11 22:36

Issued solved with the below expression

"/Data/page/content[normalize-space(.)='10.34%']".

Last Visit: 31-Dec-99 18:00 Last Update: 26-Apr-24 11:57

Refresh

ᐊ Prev 1...6 7 8 91011 12 13 14 15 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.