How to Create a Product Catalog with Calus Plus

In this article we will see how to create a simple product catalog with XSL and XML, with the exported data automatically from free software for warehouse Calus Plus, it is an example, but it demonstrates how to use the data of inventory items to create a more web pages to display as a showcase.

Last update of Calus Plus, version 2.8 of the famous free software for warehouse, has been inserted a simple procedure to export data product in both format, CSV (Comma-Separated Values) and XML (eXtensible Markup Language) . In this article I will not describe what they are and how they are formatted data from these two types of files, but rather explain how to use them, in this case XML into other applications or web pages.
The first format can be directly imported into Excel and then also, and the like (spreadsheets), while the second is the classic format, an industry standard for data on web pages. As we will see with the help of XSL (eXtensible Stylesheet Language) format data can be contained in the XML file according to the need. We will see only the bases from which to take inspiration and not paging is possible with server-side scripting such as PHP or. NET (you can find an article on this blog refers to the PHP that teaches how to create a dynamic page to another and multiple use an XML parser with PHP).

Procedure for exporting data from Calus Plus
Procedure for exporting data from Calus Plus
<?xml version="1.0" encoding="ISO-8859-1"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">

<html>
<head><title>Products Catalog</title></head>
<body>

<h1 align="center">Products Catalog</h1>

<table width="800" align="center" cellpadding="0"
   cellspacing="0" border="0">
<xsl:for-each select="PRODUCTS/ITEM">

<tr>
   <td width="400" align="left" height="300" valign="top">
	<img width="300" height="250" border="0"> 
 	   <xsl:attribute name="src"> 
	   <xsl:value-of select='IMAGE'/>
	   </xsl:attribute>
	   <xsl:attribute name="alt"> 
	   <xsl:value-of select='DESCRIPTION'/>
	   </xsl:attribute>
	</img>
   </td>
   <td align="center">
	<xsl:value-of select='DESCRIPTION'/><br /><br />
	<xsl:value-of select='SERIAL'/><br />
	<xsl:value-of select='CATEGORY'/><br />
	<xsl:value-of select='PRICE'/>
   </td>
</tr>

</xsl:for-each>

</table>

</body>
</html>

</xsl:template>
</xsl:stylesheet>

Once you get the product data, is simple to use them in web pages to create online catalogs accessible by all.