This Action Map exports Perfion data to a custom XML format.
This example is provided as inspiration only. It must be adapted to your Perfion environment to work. Perfion Support does not assist with such adaptations. Please contact your Perfion Partner or your Perfion consultant if you need assistance.
Action Map
- All lines containing a Command are created as virtuals. This is a recommended best practice
- The "." in the first and third From field means "current Perfion database"
- Two datasets (products and brands) are created and mapped separately to begin with
- The command SELECT.XSLT creates the customized XML data via the related XSLT script
Sample data for building Action Map
NOTE: Line breaks are omitted if you paste scripts from the table below directly to an action. In stead, paste script to Notepad++ and then copy from there. That will preserve line breaks when you paste into an action.
| Action Map - From | To | Command | Action | Script | Note |
| . | PRODUCTS | SELECT.PERFION | <Query> <Select languages='EN'> <Feature id='**' view='Config' /> </Select> <From id ='100'/> <Where> <Clause id='NoOfCups' operator='>=' value='2' /> </Where> </Query> |
||
| table | @FORMAT | ||||
| . | BRANDS | SELECT.PERFION | <Query> <Select languages='EN'> <Feature id='**' view='Config' /> </Select> <From id ='BrandName'/> </Query> |
||
| table | @FORMAT | ||||
| PRODUCTS | PRODUCTSEXPORT | SELECT | |||
| _Value | SKU | ||||
| BrandName | BrandName | ||||
| DiameterCM | Diameter | ||||
| HeightCM | Height | ||||
| ItemName_EN | ProductName | ||||
| RRP | ListPrice | ||||
| WidthCM | Width | ||||
| BRANDS | BRANDSEXPORT | SELECT | |||
| _Value | BrandName | ||||
| Country_EN | Country | ||||
| Description_EN | Description | ||||
| . | EXPORT | SELECT.XSLT |
<?xml version="1.0" encoding="utf-8" standalone="yes"?> <!--Create variables to reference the named DataSources in Action Mapping--> <!-- ************************************************************************************************************************************* <!--Template to generate a list of all Products, and some select info about them (incl. lookup info from Manufacturers)--> <!--Output some information about the Brands (via calling another template to do the detailed work)--> </Product> <!--Template to generate contents about a Brand (passed in as parameter)--> </xsl:stylesheet> |
||
| EXPORT | C:\Perfion Data\ActionSources\Export\ProductsWithBrand.xml | WRITE.XML |
Comments
0 comments
Please sign in to leave a comment.