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).
<?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.