My SellerDeck Account | Newsletter | Free Trial

Community and Knowledge Base

  #1  
Old 11-Dec-2015, 12:31 PM
G.W.Green G.W.Green is offline
Administrator
Join Date: Sep 2005
Full Name: G.W.Green
Posts: 481
Thanks: 0
Thanked 66 Times in 42 Posts
How to export catalogue content using a layout

SellerDeck 2016 enables you to export data from your catalogue in almost any format just by creating a layout with the appropriate content. The XML site map added in SellerDeck 2016 is an example of a file generated in this way. This article describes how to generate others, and provides a simple example of a product list in CSV format.
If the output is to be in XML format then you can simply add a layout to the 'XML Feeds' Library groups. For other formats you might want to create other groups. This example creates a CSV Export group and a generates a file in CSV format.
  1. First, open the SellerDeck Design Library by selecting 'Library' from the 'Design' menu, and click the 'Layout' tab.
  2. Right-click anywhere in the layout list and select ‘New Layout Type’ menu.
  3. Enter the Type Name 'CSV Export' and select 'Standard' and 'Outer Layout'.
  4. From the additional options which then appear, select 'Online Page'.



  5. Click 'OK'.
  6. Right-click the new Layout Type and select 'New Layout'. (You won't be inserting this layout into your site pages, so it doesn't need a Selector).



  7. Enter the name 'Product CSV Export' and click 'OK'
  8. Expand the 'CSV Export' group and double-click the new layout. Then paste in the following code:

    Code:
    "Product Ref","Name","Description","URL","Image Filename","Price"
    <actinic:block type="EntireSectionList"><actinic:block type="ProductList" />"<actinic:variable encoding="actinic" name="ProductReference" />","<actinic:variable encoding="strip" name="ProductName" />","<actinic:variable encoding="strip" name="ProductDescription" />","<actinic:variable name="CatalogURL" /><actinic:variable name="ProductPageName" />","<actinic:variable name="ProductImageFileNameRaw" />","<actinic:variable name="ProductPriceRaw" />"
    </actinic:block></actinic:block>
  9. To define a file to be generated from this layout, first click 'Edit Layout Details'.
  10. For the Online File Page Name enter 'products'csv'. If you want to upload the file to your site, change 'Online File Page Process Type' from 'None' to 'Upload'. In this case you can choose to upload to the site root or the online catalogue folder.


Now each time you publish a change to your catalogue the file 'products.csv' will be generated and uploaded to your web site. A local copy of the file will be found in C:\ProgramData\SellerDeck\SellerDeck 2016\Sites\Site1\SiteHTML.

Note for developers
. The three settings in 'Edit Layout Details' create separate records in the DesignProperties table for the file name, process type and upload location. These records have nDesignItemId corresponding to the layout ID in DesignObjects.
Attached Images
File Type: png EXP.png (19.9 KB, 324 views)
File Type: png EXP1.png (8.1 KB, 313 views)
File Type: png EXP2.png (20.1 KB, 324 views)
Reply With Quote
  #2  
Old 09-Jan-2018, 04:41 PM
MightyMouse MightyMouse is offline
Registered User
Join Date: Jun 2013
Full Name: Debbie Sapsed
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Didn't work for me

Hi
I followed your instructions.
The file is created but it is in one long line!
I was hoping I'd chanced upon an easy way to get an export of the products with minimalist information so that my boss can change the prices of his products easily.
Any ideas what I might have done wrong or what I could change?
TIA
Debbie
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT. The time now is 10:14 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.