Table of Contents

Multilanguage Print Publication Type - Field Mappings

Overview

The Multilanguage Print publication type maintains all data with translations for print and InDesign workflows. This page documents the specific fields that are populated in the Publication Line entity for each source data type.

Entity: Publication Line

The main entity for all publication types is the PIMX Publication Line table. Below shows which fields are populated based on the source data.

Item Data

Field Caption Source Description
Nummer Item No. Item.No. Item number (validated)
Vorlagencode Template Code Allocation Line."Template Code" > Item."PIMX Template Code" Template code - Allocation Line takes priority
Zusatzinfo 01-05 Additional Info 1-5 Item."PIMX Zusatzinfo 1-5" Additional info fields from the item
Translations Translations PIMX Catalog Translation (Type=Item) All language translations are stored in sublines (PIMX Publication Subline ML)

Translation Source:

  • For each language configured in the system, a translation record is created from PIMX Catalog Translation where Type = Item and Code = Item number
  • Translations populate a temporary subline table that stores language-specific data

Template Code Priority Order:

  1. If Allocation Line has "Template Code" → Use Allocation Line."Template Code"
  2. Else if Item has "PIMX Template Code" → Use Item."PIMX Template Code"

Description Source via Channel Allocation:

  1. If Channel Allocation."Manual Descriptions" = TRUE → Use Channel Allocation.Description and Channel Allocation."Description 2"
  2. If Channel Allocation."Manual Descriptions" = FALSE → Use Item.Description and Item."Description 2"

Item Group Data

Field Caption Source Description
Nummer Code Item Group Code Item group identifier
Vorlagencode Template Code Allocation Line."Template Code" > Item Group."Template Code" Template code - Allocation Line takes priority
Artikelgruppe Item Group Item Group Code Item group code reference
ArtGrp Bezeichnung Item Group Description Item Group.Description Item group description
Zusatzinfo 01-05 Additional Info 1-5 Item Group."Additional Information 1-5" Additional metadata fields
Translations Translations PIMX Catalog Translation (Type="Item Group") Multilingual group descriptions

Template Code Priority Order:

  1. If Allocation Line has "Template Code" → Use Allocation Line."Template Code"
  2. Else if Item Group has "Template Code" → Use Item Group."Template Code"

Description Source via Channel Allocation:

  1. If Channel Allocation."Manual Descriptions" = TRUE → Use Channel Allocation.Description and Channel Allocation."Description 2"
  2. If Channel Allocation."Manual Descriptions" = FALSE → Use Item Group.Description and Item Group."Description 2"

Product Group Data

Field Caption Source Description
Nummer Code Product Group Code Product group identifier
Vorlagencode Template Code Allocation Line."Template Code" > Product Group."Template Code" Template code - Allocation Line takes priority
Warengruppe Product Group Product Group Code Product group code reference
WarGrp Bezeichnung Product Group Description Product Group.Description Product group description
Zusatzinfo 01-05 Additional Info 1-5 Product Group."Additional Information 1-5" Additional metadata fields
Translations Translations PIMX Catalog Translation (Type="Product Group") Multilingual group descriptions

Template Code Priority Order:

  1. If Allocation Line has "Template Code" → Use Allocation Line."Template Code"
  2. Else if Product Group has "Template Code" → Use Product Group."Template Code"

Description Source via Channel Allocation:

  1. If Channel Allocation."Manual Descriptions" = TRUE → Use Channel Allocation.Description and Channel Allocation."Description 2"
  2. If Channel Allocation."Manual Descriptions" = FALSE → Use Product Group.Description and Product Group."Description 2"

Chapter Data

Field Caption Source Description
Nummer No. Chapter Code Chapter identifier
Vorlagencode Template Code Allocation Line."Template Code" > Chapter."Template Code" Template code - Allocation Line takes priority
Kapitel Chapter Chapter Code Chapter code reference
Kap Bezeichnung Chapter Description Chapter.Description Chapter description
Zusatzinfo 01-05 Additional Info 1-5 Chapter."Additional Information 1-5" Additional metadata fields
Translations Translations PIMX Catalog Translation (Type=Chapter) Multilingual chapter descriptions

Template Code Priority Order:

  1. If Allocation Line has "Template Code" → Use Allocation Line."Template Code"
  2. Else if Chapter has "Template Code" → Use Chapter."Template Code"

Description Source via Channel Allocation:

  1. If Channel Allocation."Manual Descriptions" = TRUE → Use Channel Allocation.Description and Channel Allocation."Description 2"
  2. If Channel Allocation."Manual Descriptions" = FALSE → Use Chapter.Description and Chapter."Description 2"

Catalog Group Data

Field Source Description
Nummer Catalog Group Code Catalog group identifier
Vorlagencode Catalog Group."Template Code" or Allocation."Template Code" Template code
Zusatzinfo 01-05 Catalog Group."Additional Information 1-5" Additional metadata fields
Translations PIMX Catalog Translation (Type="Catalogue Group") Multilingual group descriptions

Template Code Priority Order:

  1. If Allocation Line has "Template Code" → Use Allocation Line."Template Code"
  2. Else if Catalog Group has "Template Code" → Use Catalog Group."Template Code"

Description Source via Channel Allocation:

  1. If Channel Allocation."Manual Descriptions" = TRUE → Use Channel Allocation.Description and Channel Allocation."Description 2"
  2. If Channel Allocation."Manual Descriptions" = FALSE → Use Catalog Group.Description and Catalog Group."Description 2"

Catalog Item Data

Field Source Description
Nummer Catalog Item Code Catalog item identifier
Vorlagencode Allocation."Template Code" Template code from allocation
Translations PIMX Catalog Translation (Type="Catalog Item") Multilingual item descriptions

Description Source via Channel Allocation:

  1. If Channel Allocation."Manual Descriptions" = TRUE → Use Channel Allocation.Description and Channel Allocation."Description 2"
  2. If Channel Allocation."Manual Descriptions" = FALSE → Use Catalog Item.Description and Catalog Item."Description 2"

Document Data

Field Source Description
Nummer Document Code Document identifier
Vorlagencode Document."Template Code" or Allocation."Template Code" Template code
Link Document."Public Link" Public URL for the document
MIME Type Document."Mime Type" MIME type of the document
Source File Name Document."Source File Name" Original file name
Document Usage Document."Document Usage" Document usage classification
Repository Type Document."Repository Type" Type of file repository
External Container Id Document."External Container Id" External container reference
External Id Document."External Id" External document identifier
Bezeichnung 2 Document."Description 2" Secondary description
Translations PIMX Catalog Translation (Type=Document) Multilingual document metadata

Template Code Priority Order:

  1. If Allocation Line has "Template Code" → Use Allocation Line."Template Code"
  2. Else if Document has "Template Code" → Use Document."Template Code"

Description Source via Channel Allocation:

  1. If Channel Allocation."Manual Descriptions" = TRUE → Use Channel Allocation.Description and Channel Allocation."Description 2"
  2. If Channel Allocation."Manual Descriptions" = FALSE → Use Document.Description and Document."Description 2"

Keyword Data

Field Source Description
Nummer Keyword."Keyword ID" or Classification Keyword identifier based on ID source setting
Priority Keyword.Order Keyword priority/order
Translations PIMX Catalog Translation (Type=Keyword) Multilingual keyword text

Feature Data

Field Source Description
Nummer Feature Number or Reference/Classification Feature identifier based on ID source
Type Enum Product Feature."Field Type" Feature data type (Text, Number, Range, Boolean, etc.)
Feature Value Type Derived from Product Feature."Field Type" Value type for storage
Display Text Value Product Feature.Value Text representation of value
Display Number Value Product Feature."Value Numeric" Numeric value
Display Number To Value Product Feature."Value Numeric To" Range end value (for ranges)
Value Logical Product Feature."Value Logical" Boolean value
Value Date Product Feature."Value Date" Date value
Importance Product Feature.Importance Feature importance level
Relevance Product Feature.Relevance Feature relevance level
Usage Type Code Product Feature."Usage Type Code" Usage type classification
Translations PIMX Catalog Translation (Type=Feature) Multilingual feature names and descriptions

Description Text Data

Field Source Description
Nummer Description Text.Number Text identifier
Langtext Description Text.Description or "Plain Text Description" Rich or plain text content
Translations PIMX Description Text Translation Language-specific text versions
- Description Title Translated title
- Description Title 2 Translated subtitle
- Beschreibung or "Plain Text Beschreibung" Translated text content

Variant Data

Field Source Description
Nummer Item Variant Code Variant identifier
Translations PIMX Catalog Translation (Type=Variants) Multilingual variant descriptions

Product Content Data

Field Source Description
Level Product Content.Level Content hierarchy level
Priority Product Content."Line No." Content priority/order
Vorlagencode Product Content."Template Code" Template code
Data (Blob) Product Content."Data Blob" HTML or rich content data

Content Header Data

Field Source Description
Level 0 (Fixed) Fixed at 0 for headers
Priority 0 (Fixed) Fixed at 0 for headers
Vorlagencode Content Header."Template Code" Template code
Data (Blob) Content Header."Data Blob" HTML or rich content data

Subline Table: Publication Subline ML

For multilanguage print, translations are stored in the PIMX Publication Subline ML temporary table:

Field Source Description
Publication Code Publication Header Code Publication identifier
Line Guid Publication Line."Line GUID c1" Line reference
Language PIMX Catalog Translation."Language Code" Language code
Beschreibung Translation record Translated description
Beschreibung 2 Translation record Translated description 2
Value Translated value Language-specific feature/keyword value
Text PIMX Description Text Translation Language-specific text content

Shared Fields (All Entities)

Field Source Description
Vorlagencode Allocation."Template Code" or Entity."Template Code" Template code from allocation or entity
Priority Allocation.Order or Entity.Order Sort order/priority
Code Publication Header Code Publication identifier

Translation Processing

The multilanguage print type implements translations through:

  1. Primary Translation: Gets data from the source entity
  2. Translation Lookup: Queries PIMX Catalog Translation table for each configured language
  3. Subline Creation: Creates a subline record in PIMX Publication Subline ML for each language
  4. Missing Translation Handling: Based on Publication Group "Replace Missing Translations" setting:
    • Uses default value if configured
    • Skips translation if not configured

Key Differences from Other Publication Types

Multilanguage Print vs API (Simple):

  • Multilanguage Print: Includes translation sublines for all languages
  • API (Simple): Only main language, no sublines

Multilanguage Print vs API Translations:

  • Multilanguage Print: Includes main language + all translations
  • API Translations: Single non-default language, no main language

Multilanguage Print vs Multilanguage API:

  • Same entities and fields
  • Multilanguage Print optimized for print/design workflows
  • Multilanguage API optimized for API consumption