The following table defines the complete hierarchical import structure.
The 'Values' field shows what Actinic expects. The 'Default' value is the value given where no value is provided in the import file.
BrochurePage
Header Keyword |
Field Name |
Values |
Default Value |
BrochurePage |
Page Title |
Page name |
|
|
Page Filename |
File name |
'Page name'.html |
|
Page Type |
0 = Normal |
0 |
|
Button Icon |
Icon file name |
|
|
Alternate Icon |
Alternate (mouse over) file name |
|
|
Meta Keywords |
Text (for search engines) |
|
|
Meta Description |
Text (for search engines) |
|
|
Is Home Page |
Only one brochure page can be the home page. 1 = Yes |
0 |
|
Hide on the Web Site |
Doesn't apply to the home page. 1 = Yes |
0 |
|
IsDeleted |
Yes, brochure pages can be imported and marked for deletion at the same time. This means the page is present in the content tree but isn't being used yet. Usually this will be because you are importing a file that either you or someone else originally created via the Export feature, which exports all deleted nodes on the content tree. 1 = Yes |
0 |
|
nContentCategory |
Numerical ID of the content category the brochure page is within |
|
|
Variable Name (User Defined Variable) |
The user-definable variables that are settable at brochure page level. There could be any number of these |
|
BrochureFragment
Header Keyword |
Field Name |
Values |
Default Value |
BrochureFragment |
Fragment Title |
Fragment name |
|
|
Fragment Image |
File name of image (.gif, .jpg or .png) incl. path to image. |
|
|
Fragment Text |
Text (up to 20,000 characters) |
|
|
Image clickable |
0 = No |
0 |
|
Is linked |
0 = No |
0 |
|
Link type |
-1 = not linked |
-1 |
|
Linked Item ID |
A product name (and optional section names). Do not specify a product reference 1 - full path from a top-level section e.g. sectionname|productname where 'sectionname' is a top-level section 2 - wildcard path if the product is unique in the catalog e.g. *|productname 3 - wildcard path where a number of unique section names each have an identically named product e.g. *|subsectionX|productname |
|
|
Link Text |
The message text will form a hyperlink to a page in your Catalog site. |
|
|
Hide Fragment |
0 = No |
0 |
|
IsDeleted |
Yes, brochure fragments can be imported and marked for deletion at the same time. This means the fragment is present in the content tree but isn't being used yet. Usually this will be because you are importing a file that either you or someone else originally created via the Export feature, which exports all deleted nodes on the content tree. 1 = Yes |
0 |
|
nContentCategory |
Numerical ID of the content category the fragment is within |
|
|
Variable Name (User Defined Variable) |
The user-definable variables that are settable at product level. There could be any number of these |
|
Customer Groups
This is the information that is normally set up in 'Marketing | Customer Groups' - see Customer Groups. The 'Retail' schedule is not importable as it is the root schedule used by Actinic.
Customer Groups MUST be defined before any sections/products are created.
Header Keyword |
Field Name |
Values |
Default Value |
PriceSchedule Business and Designer only |
Schedule Name
|
The name of the customer group you have created. |
|
|
Base Schedule
|
The name of the Base Schedule for this customer group |
|
|
Calculation Method |
0 = Addition |
0 |
|
Calculation Factor
|
Number used in the calculation |
|
Section
These are the sections in your store.
Header Keyword |
Field Name |
Values |
Default Value |
Section |
Section name |
Text |
|
|
Section description |
Text |
|
|
Section image
|
File name of image (.gif, .jpg or .png) incl. path to image. |
|
|
Section meta description (As in Section dialog, 'Meta Tags' tab) |
Text |
|
|
Section meta keywords (As in Section dialog, 'Meta Tags' tab) |
Text |
|
|
Section included in search Field 'Allow searching by sections' in Settings | Search Settings must be checked |
1 = Include |
1 |
|
Section hidden on web site (As in Section dialog, 'General' tab) |
1 = Hide |
0 |
|
Page Name (As in Section dialog, 'Layout' tab) |
File name for the section page. This must not include path characters. |
|
|
IsDeleted (Is this section to be marked for a purge?) |
Usually this will be because you are importing a file that either you or someone else originally created via the Export feature, which exports all deleted nodes on the content tree. 1 = Yes |
0 |
|
Section Use Parent settings (Are you using the default shopping mode settings?) |
1 = Yes |
1 |
|
Single Add to Cart button (Are you using a single add to cart button for the section?) |
1 = Yes |
0 |
|
Section Quantity placement (aka 'Shopping Mode') |
0 = Quantity on product page |
0 |
|
Exclude Section from Froogle Data Feed |
1 = Exclude 0 = Don't exclude |
0 |
|
Page Title |
Title for the page |
|
|
Include to Site Map |
1 = Include 0 = Don't include |
1 |
|
Variable Name (User Defined Variable) |
The user-definable variables that are settable at section level. There could be any number of these |
|
Product
The products in your store. This bears a lot of similarity to the fields described for a standard import in Valid Fields For Importing.
Header Keyword |
Field Name |
Values |
Default Value |
Product |
Product reference |
|
|
|
Short description If you use auto-generated product references
the 'Short description' field is mandatory. |
255 characters. |
|
|
Full description (If the text contains 1 or more carriage returns the
description must be contained within double quote marks " . ".) |
Maximum 20,000 characters including any description for all components, attributes and choices, and HTML. |
|
|
Report description (As in 'Report Description' tab) |
Text. |
|
|
Price |
Price in lowest currency unit e.g. pence / cents. |
0 |
|
Image filename (.gif, .jpg or .png) |
File name of image (.gif, .jpg or .png) incl. path to image. |
|
|
Can Be Ordered Online |
1 = Yes |
1 |
|
Max quantity orderable (As in 'Details' tab) |
0 = upper limit is 32767 |
0 |
|
Min quantity orderable (As in 'Details' tab) |
|
1 |
|
Date prompt text (As in 'Layout' tab) |
If you enter a value, the buyer must enter a date. Maximum of 50 characters for this prompt. |
|
|
Other info prompt (As in 'Layout' tab) |
If you enter a value, the buyer must enter a value. Maximum of 50 characters for this prompt. |
|
|
Tax treatment (As in Product dialog) |
0 = Zero Rated |
0 |
|
Detail URL or file (As in 'Links' tab) |
URL or file path |
|
|
Detail link text (As in 'Links' tab)'Detail URL or file' must also be used |
Text |
|
|
Hide on web site (As in 'General' tab) |
1 = Hide |
0 |
|
Shipping data (As in 'Details' tab) |
The weight of the product as defined in 'Business Settings | Shipping & Handling' |
|
|
Price text (As in 'Layout' tab) |
Text for Price |
Price: |
|
Button text (As in Product dialog, 'Layout' tab) |
Text for online buy button |
Add To Shopping Cart |
|
Use external data Business /Designer only. Product actually resides in an external spreadsheet or database. |
1 = Yes |
0 |
|
Stock checks enabled (As in 'Stock' tab) |
1 = Yes |
0 |
|
Stock in hand (As in 'Stock' tab) |
|
0 |
|
Stock warning level (As in 'Stock' tab) |
Numeral. The default is 5 units. |
0 |
|
Stock suspend level (As in 'Stock' tab) |
Numeral. The default is 2 units. |
0 |
|
Pricing model To be used if some products have components |
0 = Product Price |
0 |
|
Ship Separately |
0 = Don't Ship Separately 1 = Ship Separately |
0 |
|
V4 Tax 1 Data (As in Product dialog) This field is used for creating a custom value to the 'Tax 1' field. |
6=0=nnnn |
Tax1 |
|
V4 Tax 2 Data (As in Product dialog) This field is used for creating a custom value to the 'Tax 2' field. Tax2 must have been defined in Catalog in order to import this field. |
6=0=nnnn |
Tax2 |
|
V5 Tax 1 Data Tax rates can be displayed to 4 decimal
places |
|
0 |
|
V5 Tax 2 Data Tax2 must have been defined in Catalog in order to import this field. |
|
0 |
|
IsDeleted Is this product to be marked for a purge? If you import in 'update' mode and the import file contains a deleted product, the matching product in the content tree will be marked for deletion. |
Usually this will be because you are importing a file that either you or someone else originally created via the Export feature, which exports all deleted nodes on the content tree. 1 = Yes |
0 |
|
No Order Line for Main Product |
Enter '1' if you want there to be no orderline for this product in the shopping cart |
|
|
Date prompt minimum year (Minimum year shown in date prompt drop-down list) |
Enter a four-digit year |
|
|
Date prompt maximum year (Maximum year shown in date prompt drop-down list) |
Enter a four-digit year |
|
|
Generate pop-up page |
Enter '1' of you are using a pop-up window to show extended product info |
0 |
|
Extended info text (The text to appear in the extended information window) |
Enter text |
|
|
Extended info image (The image to appear in the extended information window) |
File name/path expected |
|
|
Display by image (Do you want people to click on the product image to open the pop-up window?) |
Enter '1' if yes. |
0 |
|
Display by link (Do you want people to click on a link to open the pop-up window?) |
Enter '1' if yes |
0 |
|
Display by button (Do you want people to click on a grey button to open the pop-up window?) |
Enter '1' if yes |
0 |
|
Extended info page name (The filename of the extended product information page) |
File name/path expected |
|
|
Extended info link text (The text to be used in either the link or on the button for opening the pop-up extended info window) |
This is mandatory if you are using either a link or a button. |
|
|
Digital download filename (The filename of the product you would like to be available as a download once the customer has paid for it online) |
File name/path expected |
|
|
Auto Ship (if you want any orders with this digitally downloadable item to be marked as shipped automatically) |
1 = Auto-ship 0 = Don't auto-ship |
0 |
|
Product Group ID (ID of the group this product is in) |
A numerical ID |
|
|
Product type (The type of product this is) |
0 - normal 1 - duplicate 2 - brochure fragment |
0 |
|
Original Product Reference (If it is a duplicate, enter the reference of the original product) |
Valid product reference expected |
|
|
Product duplicate index (If you are importing a duplicate, you can supply a unique number for it) |
If you leave this blank, Actinic will supply a value. |
Auto-assigned sequential number. |
|
Linked item ID (The ID of the linked item) |
URL Product reference Section ID |
|
|
Link type (The type of link that this fragment (or product in the 'Links' tab) is using) |
-1 = not linked |
-1 |
|
Is linked (indicates if the product is using the 'Advanced Link' or the fragment is using the 'Link') |
1 = Link used 0 = Link not used |
0 |
|
Fragment title (Enter the title of the fragment) |
Required if the 'Product Type' is set to '2'. |
|
|
Fragment text (If you are importing a brochure fragment, enter the text for the fragment) |
Required if the fragment layout allows for text to be included. |
|
|
Fragment image (Enter the filename (and path) of the image for this fragment) |
File path expected. |
|
|
Image clickable (Whether or not the fragment/product image will launch the link) |
1 = Clickable 0 = Not clickable |
0 |
|
Link text (The text for the fragment link/product advanced link) |
|
|
|
Exclude from froogle data feed (If you want this product to be excluded from the Froogle data feed) |
1 = Excluded 0 = Not excluded |
0 |
|
Thumbnail (Enter the filename (and path) of the thumbnail image for this product) |
File path expected. |
|
|
nContentCategory |
Numerical ID of the content category this product is within |
|
|
Include in Best Sellers List |
0 = Don't include 1 = Include |
1 |
|
Include in New Products List |
0 = Don't include 1 = Include |
1 |
|
Include in Also Bought List |
0 = Don't include 1 = Include |
1 |
|
Variable Name (User Defined Variable) |
The user-definable variables that are settable at product level. There could be any number of these |
|
Component
Header Keyword |
Field Name |
Values |
Default Value |
Component
|
Component name If a component has 1 or more attributes it cannot be associated with a product - use permutations instead. |
|
|
|
Price The component price must follow the component name. |
Price in lowest currency unit e.g. pence /
cents |
0 |
|
Quantity |
|
1 |
|
Name HTML Value used in online store, not Component Name. |
Can be blank |
|
|
Is optional |
1 = Optional |
0 |
|
Selected by default |
1 = Yes |
0 |
|
Associated Product Reference A product name (and optional section names). Do not specify a product reference 1 - full path from a top-level section e.g. sectionname|productname where 'sectionname' is a top-level section 2 - wildcard path if the product is unique in the catalog e.g. *|productname 3 - relative path if both product with component and the associated product are in the same section e.g. |Office Chair 4 - relative path if the associated product is in a subsection of the section containing the product with component e.g. |subsection|Office Chair 5 - wildcard path where a number of unique section names each have an identically named product e.g. *|subsectionX|productname |
A product name (and optional section names). Do not specify a product reference. |
None |
|
Uses Associated Product Prices |
1 = Yes |
0 |
|
Uses Associated Product Name |
1 = Yes |
0 |
|
Uses Associated Product Tax |
1 = Yes |
0 |
|
Component as separate order line |
1 = Yes |
0 |
|
Include No Choice Label (will only work if the component has a single attribute) |
1 = Yes |
0 |
|
No Choice Label Text |
Enter text |
'None' |
|
IsDeleted Is this component to be marked for a purge? |
Usually this will be because you are importing a file that either you or someone else originally created via the Export feature, which exports all deleted nodes on the content tree. 1 = Yes |
0 |
|
Variable Name (User Defined Variable) |
The user-definable variables that are settable at component level. There could be any number of these |
|
Attribute
Header Keyword |
Field Name |
Values |
Default Value |
Attribute
|
Attribute Name |
|
|
|
Name HTML Value used in online store, not Attribute Name. |
Can be blank |
|
|
Type Business /Designer only, used for Searchable Properties |
1 = Text |
1 |
|
IsDeleted Is this attribute to be marked for a purge? |
Usually this will be because you are importing a file that either you or someone else originally created via the Export feature, which exports all deleted nodes on the content tree. 1 = Yes |
0 |
|
Variable Name (User Defined Variable) |
The user-definable variables that are settable at attribute level. There could be any number of these |
|
Choice
Header Keyword |
Field Name |
Values |
Default Value |
Choice
|
Choice name |
|
|
|
Name HTML Value used in online store, not Choice Name. |
Can be blank |
|
|
IsDeleted Is this choice to be marked for a purge? |
Usually this will be because you are importing a file that either you or someone else originally created via the Export feature, which exports all deleted nodes on the content tree. 1 = Yes |
0 |
|
Variable Name (User Defined Variable) |
The user-definable variables that are settable at choice level. There could be any number of these |
|
Permutation
Header Keyword |
Field Name |
Values |
Default Value |
Permutation |
Permutation String A list of attribute:choice pairs, separated by semicolons (;)e.g.: size:-1 (means set attribute 'size' to 'don't care') colour:red (means set attribute 'colour' to choice 'red') size:-1;color:red (means set them both) |
Set a string to specify the Permutation's Choices
|
|
|
Price (As in Component dialog, Permutations table) |
Price in lowest currency unit e.g. pence/cents |
0 |
|
Is Valid (As in Component dialog, Permutations table) |
1 = Yes |
0 |
|
Associated Product Reference A product name (and optional section names). Do not specify a product reference 1 - full path from a top-level section e.g. sectionname|productname where 'sectionname' is a top-level section 2 - wildcard path if the product is unique in the catalog e.g. *|productname 3 - relative path if both product with component and the associated product are in the same section e.g. |Office Chair 4 - relative path if the associated product is in a subsection of the section containing the product with component e.g. |subsection|Office Chair 5 - wildcard path where a number of unique section names each have an identically named product e.g. *|subsectionX|productname |
A product name (and optional section names). Do not specify a product reference. |
(None) |
|
Pricing |
0: Component prices 1: Associated product prices 2: Override |
|
|
Uses Associated Product Name |
1 = Yes |
0 |
|
Uses Associated Product Tax |
1 = Yes |
0 |
|
Variable Name (User Defined Variable) |
The user-definable variables that are settable at permutation level. There could be any number of these |
|
Price
Actinic Business/Designer only
This is the data for customer group prices, and quantity-dependent pricing (in the 'Prices' tab of a product or the 'Prices' area in a component).
Specifying the following will delete all prices of a given priced item:
Price action=delete
Price rows can be used after Product, Component or Permutation data records.
Header Keyword |
Field Name |
Values |
Default Value |
Price |
Schedule The name of the customer group that will be linked to one or more customer accounts. 'Retail' or the name of your base schedule is not importable. |
|
|
|
Price Enter the customized price expressed as the lowest currency unit, e.g. 103 for £1.03. |
|
Schedule price |
|
Generated Whether or not the price is automatically calculated based on the Customer Group settings. |
1 = Yes |
1 |
|
Enabled Whether or not this customer group price is active for this product. |
1 = Yes |
?? |
|
Minimum Used for a quantity discount structure. For full details see Quantity-Based Pricing. |
The maximum value will be automatically computed on import. i.e. For minimum values of 10, 20, 30 |
0 |
|
Customer message A message that is just for customers that are part of this customer group. |
|
|
SearchProperty
Actinic Business/Designer only
Header Keyword |
Field Name |
Values |
Default Value |
SearchProperty
|
Referred Property As in Business Settings | Search Settings, 'Searchable Properties' tab For user-definable variables, use the 'Name' For attributes, the format is: Attribute Type: Attribute Name where Attribute Type has values: 1 = Text color |
Variable Name or 'Attribute Type: Attribute Name' |
|
|
Label As in Business 'Searchable Properties' tab |
|
|
|
HTML Representation As in Business Settings | Search Settings, 'Searchable Properties' tab |
The ID of the layout that lays out this searchable property |
0 |
|
Default choice As in 'Searchable Properties' tab |
Specific variable value or Choice, or '-1' for 'Any' (as long as 'Is optional' is set to 1) |
0 |
|
Is optional As in 'Searchable Properties' tab |
1 = Yes |
0 |
|
Allow Multiple Selection As in 'Searchable Properties' tab. Only applies to CheckBox and List. |
1 = Yes |
0 |
ShippingZone
These are not replaceable. In other words, importing these will not erase all the zones present in the shipping database.
Header Keyword |
Field Name |
Values |
Default Value |
ShippingZone |
Name |
The unique name of the zone. |
|
|
Description |
A brief description of the zone. |
|
ShippingZoneMember
Header Keyword |
Field Name |
Values |
Default Value |
ShippingZoneMember |
Name Will become a member of the most recently defined shipping zone. |
|
|
|
State |
The state, region or province code, if applicable. |
|
ShippingClass
These are not replaceable. In other words, importing these will not erase all the classes present in the shipping database.
Header Keyword |
Field Name |
Values |
Default Value |
ShippingClass |
Name |
The unique name of the class - e.g. 'First Class.' |
|
|
Description |
A brief description of the class. |
|
BandDefinition
Header Keyword |
Field Name |
Values |
Default Value |
BandDefinition |
Zone One of the ShippingZone names |
The name of the Zone this definition applies to. |
|
|
Class One of the ShippingClass names |
The name of the Class this definition applies to. |
|
|
Incremental Charge |
The incremental cost for excess expressed in lowest currency unit. |
0 |
|
Incremental Weight, quantity or value -depending on
shipping calculation basis |
The incremental weight / quantity or value |
|
|
Excess Action |
Action to take if the order exceeds the highest value in the shipping band table. 0 = Do not allow excess |
0 |
Band
Header Keyword |
Field Name |
Values |
Default Value |
Band
|
Zone One of the ShippingZone names. |
The name of the Zone this definition applies to. |
|
|
Class One of the ShippingClass names. An import of a single band will remove all bands with the same zone and class. |
The name of the Class this definition applies to. |
|
|
Weight or value Note: If you import shipping tables in 'update' mode then any row whose weight (or quantity/value) is not in the import file will remain in the shipping table i.e. will not be overridden. |
The weight, quantity or value of the band. |
|
|
Cost |
The cost expressed in lowest currency unit. |
|
|
Calculation Basis |
0 = weight |
0 |
Customer
Actinic Business/Designer only.
Info for 'Customer Accounts' dialog, 'Account' tab.
Header Keyword |
Field Name |
Values |
Default Value |
Customer
|
Customer Name
|
|
|
|
External Reference |
|
|
|
Price Schedule Actual name of existing customer group must be used. |
e.g. Retail |
|
|
Status |
0 = Active 1 = Suspended |
0 |
|
Payment Method As well as the values opposite, this field can also be set to a PSP value. e.g. if you have run the PSP installer then view file 'OCCUpgrade.ini' in the 'OCCUpgrade' sub-directory. Near the top is a section beginning with: [OCC-ID] After it are lines such as: WorldPay=4 Setting the 'Payment Method' field to '4' will set the customer account to WorldPay. |
10000 = cash on delivery 10001 = check on delivery 10002 = invoice with order 10003 = invoice and payment with delivery 10004 = send credit card details independently 10005 = Credit Card details captured for later processing 10006 = Payment on Account |
0 |
|
Email On Order |
1 = Yes 0 = No |
0 |
|
Email Address |
|
|
|
Telephone |
|
|
|
Fax |
|
|
|
Contact Name |
|
|
|
Salutation |
|
|
|
Title |
|
|
|
Notes |
|
|
|
Invoice Address Value as for the field 'Customer Address Name' in the 'Customer Address' header |
A 'Customer Address Name' is expected |
|
|
Invoice Address Rule 'Only invoice address' field in the 'Account' tab |
1 = Yes |
0 |
|
Purge Is this customer account to be marked as 'deleted' ready for purging? |
1 = Yes |
0 |
CustomerAddress
Actinic Business/Designer Only
Info for 'Customer Accounts' dialog, 'Addresses' tab.
Header Keyword |
Field Name |
Values |
Default Value |
CustomerAddress |
Customer Address Name |
|
|
|
Address Line 1 |
|
|
|
Address Line 2 |
|
|
|
Address Line 3 |
|
|
|
Address Line 4 |
|
|
|
Address Post/Zip Code |
|
|
|
Address Country ID |
Value from the 'Country Code' field in the 'Countries' table in Settings | Locations file, e.g. France = FR This value is case-sensitive. |
|
|
Valid Invoice Address |
1 = Yes |
0 |
|
Valid Delivery Address |
1 = Yes |
0 |
|
Address State ID Required if the country has states / provinces. |
Value from the 'State Name' field in the 'States' table in 'Settings | Locations'. E.g. Arizona = AZ This value is case-sensitive. |
|
|
Exempt Tax 1 'Allow exemption' field in 'Business Settings | Tax' tab for 'Tax1' must be selected. |
1 = Yes |
0 |
|
Exempt Tax 1 Data |
|
|
|
Exempt Tax 2 'Allow exemption' field in 'Business Settings | Tax' tab for 'Tax2' must be selected. |
1 = Yes
|
0 |
|
Exempt Tax 2 Data |
|
|
|
Purge Is the address to be marked as 'deleted' ready for purging? |
1 = Yes |
0 |
CustomerBuyer
Actinic Business/Designer only
Info for 'Customer Accounts' dialog, 'Buyers' tab.
Header Keyword |
Field Name |
Values |
Default Value |
CustomerBuyer
|
Buyer Username |
Username |
|
|
Password |
Password |
|
|
Status |
0 = Active |
0 |
|
Invoice Address Rule |
0 = Only allow this address |
0 |
|
Invoice Address |
Required |
|
|
Delivery Address Rule |
0 = Only allow this address |
0 |
|
Delivery Address |
Required |
|
|
Email On Order |
1 = Yes |
0 |
|
Email Address |
Required if 'Email On Order' field name is '1' |
|
|
Maximum Order Value |
Required if 'Limit Order Value' field name is '1' Limit in lowest currency unit e.g. pence/cents |
|
|
Name |
|
|
|
Salutation |
|
|
|
Title |
|
|
|
Phone |
|
|
|
Fax |
|
|
|
Limit Order Value |
1 = Yes |
0 |
|
Hide Retail Prices |
1 = Yes |
0 |
|
Purge Is the buyer to be marked as 'deleted' ready for purging? |
1 = Yes |
0 |