XML scenarios of export/import

Goods catalogs of modern internet-shops contain from thousands up to ten thousands items. The C-Gato rexport/import module facilitates catalogs management as much as possible.

Through the module you can import goods catalog from an Excel file, export it to another format, ZIP archieve, publish on your site as scheduled and do other complex operations, e.g., integrating and analyzing price-lists of different suppliers.

Data export/import scenarios are developed on basis of the XML description language.

Data processing algorithm looks as follows:

1. Data from sources go through parsing with the help parsers specific for every source.
   These are the sources to be supported:
   
   • Catalogs and binary files
   • ZIP files
   • Excel files
   • CSV files
   • XML files
   • MS SQL Database
   • Libraries, resources and multiple properties of C-Gator
   • Web-service
   • Http
2. XML tree resulting from parsing is transformed by XSLT, language constructions or .NET insertion function.
   
3. The result of transformation is serialized to the receiver-structure.
   Serialization is available for to the following structures :
   
   • Catalogs and binary files
   • ZIP files
   • Excel files
   • CSV files
   • XML files
   • MS SQL Database
   • Library, resources and multiple properties of C-Gator
   • Web-service

The system administrator (or as scheduled) implements scenarios startup, therefore the module can be used as a solution for external applications and systems integration.

The example below shows as the Excel file is parsed, transformed by XSLT and displayed on a screen in the HTML tabular form.

Scenario of the above example processing:

<scenario>     <recordsets>       <rs name="src" type="folder">         <path>c:\bswork</path>       </rs>     </recordsets>     <script>     <foreach for="src/scenar/прайс-прав.xls[excel][лист1][rows]" item="row" foritems="true">       <if test="@row[num] &lt; 2">         <row num="@row[num]">         <foreach for="row" item="cell" foritems="true">           <col num="@cell[num]">           <get name="cell" as="string" />           </col>         </foreach>         </row>       </if>     </foreach>     </script>     </scenario>

Several variants of the C-Gator XML scenarios module use:

• Goods catalog import. Single or scheduled upload of catalogs and other associated information ( images, documents).
• Price-list generating and export in Excel file, etc.
• Initial upload of design or images. It significantly speeds up the procedure of initial site filling with images, styles, and design templates.
• Integrating attachments with non-compatible types of information retrieve and usage
• Incorporating information from different sources. For example, incorporating price-lists of CSV and Excel  formats, uploading data from CD and sites.