Digital Content Delivery
Overview
HTTP Content Delivery allows providing more than one image per product as well as other various types of content such as Key Selling Points, Product Features, User Manuals, etc.inluding the localized content.
HTTP delivery method brings the following advantages to our customers:
-
Reduced file size as only the textual content will be supplied in the download.zip files.
-
Reduced content maintenance as only new or changed content will be shipped.
-
Possibility to download the localized content (marketing texts, etc.) prepared for the markets where the products will be distributed.
Digital Content Types
The following types of content are delivered via the digital content. If you are not subscribed to some of these media types and you would like them to be activated for your account(s) please contact Customer Support team.
|
Media Type Name |
Media Type ID |
Media Type Description |
|
1WS Product Image |
15 |
This media type is used for providing multi-size multi-angle images including thumbnails and hi-resolution images. |
|
Standard Image (200×150) |
1 |
Only one image 200×150 size is provided within this media type. This is a legacy media type as the standard images are a part of “1WS Product Image” type. |
|
1WS Medium Image (400×300) |
2 |
Only one image 400×300 size is provided within this media type. This is a legacy media type as the standard images are a part of “1WS Product Image” type. |
|
Logo Image |
17 |
This media type provides brand logo image. |
|
Marketing Description |
4 |
This media type is for the marketing text which is captured directly from the manufacturers’ websites. |
|
Key Selling Points |
5 |
This media type includes the main key selling points which are retrieved directly from the manufacturer. |
|
Product Features |
14 |
This media type provides the extended key selling points which are also captured directly from the manufacturers’ websites. |
|
What’s in the Box |
10 |
This media type provides a list of the accessories and options bundled together under a single part number. |
|
Product Data Sheet / Brochure |
11 |
These 3 media types provide the PDF documents retrieved directly from the manufacturers. These are legacy media types as they are a part of "Product Documents" media type. |
|
User Manual |
12 |
|
|
Quick Start Guide |
13 |
|
|
Material Safety Data Sheet |
16 |
This media type provides material safety data sheets (MSDS) in PDF format. These is a legacy media type as it is a part of "Product Documents" media type. |
| Product Documents | 18 | This media type combines User Manuals, Quick Start Guides, Product Brochures/Datasheets, Material Safety Data Sheets (MSDS) as well as includes the new documents such as Warranty Cards and FTC Energy Guides. |
Tables Format
This section provides the information about the digital content tables and their relationship to each other. These tables are delivered in the directory named digitalcontent in the download.zip file. The files in the digitalcontent directory contain information about the digital content items to be downloaded from the 1WorldSync Content Solutions server using HTTP.
| Digital Content Table Names in download.zip | Digital Content Table Names processed by ContentConnector |
| Digital_Content.txt | cds_DigContent |
| Digital_Content_Links.txt | cds_DigContent_Links |
| Digital_Content_Prod.txt | cds_DigContent_Prod |
| Digital_Content_Media_Types.txt | cds_DigContent_Media_Types |
| Digital_Content_Regions.txt | cds_DigContent_Regions |
| Digital_Content_Region_Links.txt | cds_DigContent_Region_Links |
| Digital_Content_Languages.txt | cds_DigContent_Langs |
| Digital_Content_Language_Links.txt | cds_DigContent_Lang_Links |
| Digital_Content_Meta.txt | cds_DigContent_Meta |
| Digital_Content_Meta_Atr_Voc.txt | cds_DigContent_Meta_AtrVoc |
| Digital_Content_Meta_Value_Voc.txt | cds_DigContent_Meta_ValVoc |
| Digital_Content_Text.txt | cds_DigContent_Text |
Each file in the digitalc ontent directory is related to a table in the 1WorldSync Content Solutions data schema. The schema in Figure 1 will help you to understand the relationship between each file and how to retrieve the content referenced within the tables.
Figure 1. Digital Content database tables
Digital_Content
The table Digital_Content contains the list of files that are located on the 1WorldSync Content Solutions’s content server, are mapped to the customer’s product(s) and have been added/changed since the last DataSource delivery to the customer.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ContentGuid (PK) |
char (36) |
not null |
Unique identifier of the digital content item, a string representation of the unique identifier data type in MSSQL.
|
|
MediaTypeID |
Int |
not null |
Media type identifier — a reference to the digital_content_media_types file. |
|
MimeType |
varchar(50) |
not null |
Mime type of the content file. For example, "image/jpeg". |
|
URL |
varchar(500) |
not null |
URL to the 1WorldSync Content Solutions’s digital content web site. The files can be downloaded using this URL. |
|
Timestamp |
char(19) |
not null |
Date and time when the digital content item was last changed at 1WorldSync Content Solutions,
|
|
Delivery: Increment |
|||
Digital_Content_Media_Types
The Digital_Content_Media_Types table contains all digital content media types that the customer can download.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
MediaTypeID (PK) |
Int |
not null |
Unique identifier of the digital content media type. For example, "5", "15". |
|
MediaType Description |
varchar (1000) |
not null |
Description of the digital content media type in English. For example, “Key Selling Points’, "1WS Product Image". |
|
Delivery: Full |
|||
Digital_Content_Prod
Digital_Content_Prod table contains products which digital content links has changed since the last delivery to the customer or which have been remapped to another 1WorldSync Content Solutions’s SKU since the last delivery.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID (PK) |
varchar (40) |
varchar (40) |
Unique product identifier — a reference to an entry in cds_Catalog. |
|
Delivery: Increment |
|||
Digital_Content_Links
Digital_Content_Links table contains all links to digital content for all products listed in the Digital_Content_Prod table.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID |
varchar(40) |
not null |
Unique product identifier — a reference to the digital_content_prod file. |
|
ContentGuid |
char(36) |
not null |
Unique content item identifier — a reference to the digital_content file. |
|
Delivery: Increment |
|||
Digital_Content_Regions
Digital_Content_Regions table contains the complete list of regions valid for the customer. For example, the customer who receives data for the Norway market will have 3 records:
- World Wide
- Scandinavian countries
- Norway
The US market customer will have two regions:
- United States
- World Wide
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
RegionCode (PK) |
varchar (20) |
not null |
Unique identifier of the region. |
|
RegionName |
varchar (200) |
not null |
Name of the region. |
|
Delivery: Full |
|||
Digital_Content_Region_Links
Digital_Content_Region_Links table contains the information on the region the digital content item belongs to.
The images will have the region code WW identifying the World Wide region as the images are not market/region specific.
The marketing components digital content (marketing text, key selling points, PDFs, etc.) will have the region-specific code the content is available in. The regions are defined by the market the customer’s account is set up with. If the content is not region-specific it will have the region code WW (World Wide region).
If a region-specific and World Wide content is available, both links will be delivered.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ContentGuid |
char (36) |
not null |
Unique digital content identifier — a reference to the digital_content file. |
|
RegionCode |
varchar (20) |
not null |
Unique region identifier — a reference to the digital_content_regions file. |
|
Delivery: Increment |
|||
Digital_Content_Languages
Digital_Content_Languages table contains the complete list of languages the customer receives data in. For example, the customer receiving data in English language will have 2 records:
- Invariant
- English
The customer with English and French languages will get:
- English
- French
- Invariant
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
LanguageCode (PK) |
varchar (20) |
not null |
Unique identifier of the language. |
|
LanguageName |
varchar (200) |
not null |
Name of the language. |
|
Delivery: Full |
|||
Digital_Content_Language_Links
Digital_Content_Language_Links table provides the information on the language the digital content item is delivered in.
The image links will have the language code "Inv" identifying the Invariant language as the images are language-independent.
The marketing components digital content (marketing text, key selling points, PDFs, etc.) will have the language-specific code the content is provided in. The languages are limited to the ones the customer’s account is set up to receive. The language-specific content is based on the availability of this data from the manufacturers.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ContentGuid |
char (36) |
not null |
Unique digital content identifier — a reference to the digital_content file. |
|
LanguageCode |
varchar (20) |
not null |
Unique language identifier — a reference to the digital_content_languages file. |
|
Delivery: Increment |
|||
Meta Attributes
The following three digital content tables provide the information on the image type, angle, size, etc. for the multiple images which are delivered in 1WS Product Image Media Type ID 15.
Digital_Content_Meta
Digital_Content_Meta table contains the meta information of digital content links.
|
Field Name |
Type/Length |
Nullable |
Field Description |
|
ContentGuid |
char (36) |
not null |
Unique digital content identifier – a reference to the cds_Digital_Content table |
|
MetaAtrID |
int |
not null |
Meta/tag attribute identifier. |
|
MetaValueID |
int |
not null |
Meta/tag value identifier. |
|
Delivery: Increment |
|||
Digital_Content_Meta_Atr_Voc
Digital_Content_Meta_Atr_Voc table contains the list of meta/tag attributes.
|
Field Name |
Type/Length |
Nullable |
Field Description |
|
MetaAtrID |
int |
not null |
Unique meta/tag attribute identifier. |
|
LanguageCode |
varchar(20) |
not null |
Unique language identifier – a reference to the cds_Digital_Content_Languages table. |
|
MetaAtrName |
varchar(20) |
not null |
Meta/tag language-dependent attribute name. For example, “Image Type”, “Image Angle”, etc. |
|
Delivery: Full |
|||
Digital_Content_Meta_Value_Voc
Digital_Content_Meta_Value_Voc table contains the list of possible values of meta/tag attributes.
|
Field Name |
Type/Lenght |
Nullable |
Field Description |
|
MetaValueID |
int |
not null |
Unique meta/tag value identifier. |
|
LanguageCode |
varchar(20) |
not null |
Unique language identifier – a reference to the cds_Digital_Content_Languages table. |
|
MetaValueName |
varchar(20) |
not null |
Meta/tag language-dependent value. |
|
Delivery: Full |
|||
Some of the values (numbers and digital content GUIDs) are language-independent and are delivered in Invariant (“Inv”) language.
Digital_Content_Text
This table is intended for all text components existing in Digital Content, which includes:
• Marketing Description
• Key Selling Points (KSP)
• Product Features
• What's In The Box
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ContentGuid (PK) |
char (36) |
not null |
Unique identifier of the digital content item. |
| LanguageCode | Varchar(20) | not null |
Unique language identifier
|
| Region Code | Varchar(20) | not null |
Unique region identifier
|
|
MediaTypeID |
Int |
not null |
Unique identifier of the digital content media type: E.g., "4" for Marketing Descriptions, or "5" for Key Selling Points |
|
Text |
Ntext |
not null |
Text presented in XML format |
|
Timestamp |
char(19) |
not null |
Date and time when the digital content item was last changed. |
|
Delivery: Increment |
|||