Input-Datei eines Lieferanten

Owned by Former user (Deleted)
Oct 02, 2023
1 min read

Dieses Dokument klärt, welche Kriterien die Produktdaten eines Lieferaten erfüllen muss.

Eindeutigkeit der Attributnamen

Die Input Datei muss eindeutige Attributnamen oder -IDs verwenden.

Etwaige doppelt gelieferte Attribute bekommen eine UUID als Suffix angehängt, welche sich bei jeder Prozessierung ändert. Dies führt dazu, dass solche Attribute bei jeder Prozessierung im Attributmapping Task als neue, ungemappte Attribute erscheinen. Es ist also schon bei den Quelldaten auf Eindeutigkeit der Attribute zu achten und diese ggf. vom Datenlieferanten einzufordern.

Behandlung von sprachabhängigen Attributen

Ein Lieferant kann sprachabhängige Attribute auf verschiedene Weisen liefern:

  • der gesamte Katalog ist mehrsprachig vorhanden

    • 1 Zeile je Produkt und Sprache

  • nur Teile des Katalogs (einzelne Attribute) sind mehrsprachig vorhanden

    • sofern es entsprechende sprachabhängige Zielattribute gibt, können diese auf die jeweilige Sprache des Quellattributes gemappt werden

  • der Lieferant übermittelt eine Übersetzungstabelle für Attribute

    • Beim Einlesen der Quelle wird Onedot die Übersetzungstabelle auf den Katalog anwenden und die Attribute in der gewünschten Sprache liefern

 

<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page { mso-header-data:""; mso-footer-data:""; margin:0.75in 0.7in 0.75in 0.7in; mso-header-margin:0.3in; mso-footer-margin:0.3in; mso-page-orientation:Portrait; }tr {mso-height-source:auto; mso-ruby-visibility:none;}col {mso-width-source:auto; mso-ruby-visibility:none;}br {mso-data-placement:same-cell;}ruby {ruby-align:left;}.style0 { mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:12pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; border:none; mso-protection:locked visible; mso-style-name:Normal; mso-style-id:0;}.font0 { color:#000000; font-size:12pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; }.font1 { color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; }.font2 { color:#FFFFFF; font-size:12pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; }td {mso-style-parent:style0; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:12pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; border:none; mso-protection:locked visible; mso-ignore:padding;}.style0 { text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:12pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; mso-protection:locked visible; mso-style-name:"Normal"; }.style1 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style2 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style3 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style4 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style5 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style6 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style7 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style8 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style9 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style10 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style11 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style12 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style13 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style14 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.x15 { mso-style-parent:style0; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:12pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; mso-protection:locked visible; }.style16 { text-align:general; vertical-align:bottom; white-space:nowrap; background:#4472C4; mso-pattern:auto none; color:#FFFFFF; font-size:12pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; mso-protection:locked visible; mso-style-name:"Accent1"; }.style17 { text-align:general; vertical-align:bottom; white-space:nowrap; background:#B4C7E7; mso-pattern:auto none; color:#000000; font-size:12pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; mso-protection:locked visible; mso-style-name:"40% - Accent1"; }.x18 { mso-style-parent:style16; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:#4472C4; mso-pattern:auto none; color:#FFFFFF; font-size:12pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; mso-protection:locked visible; }.x19 { mso-style-parent:style17; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:#B4C7E7; mso-pattern:auto none; color:#000000; font-size:12pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; mso-protection:locked visible; }.x20 { mso-style-parent:style16; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:#4472C4; mso-pattern:auto none; color:#FFFFFF; font-size:12pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; border-top:none; border-right:none; border-bottom:3px solid #4472C4; border-left:none; mso-diagonal-down:none; mso-diagonal-up:none; mso-protection:locked visible; }.x21 { mso-style-parent:style16; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:#4472C4; mso-pattern:auto none; color:#FFFFFF; font-size:12pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; mso-protection:locked visible; }--></style><div class="cells-worksheet" data-sheet-number="0" data-sheet-name="Sheet1"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse:collapse;table-layout:fixed;width:821pt"> <colgroup> <col span="3" style="mso-width-source:userset;width:185px"></col> <col span="6" style="width:90px"></col> </colgroup> <tbody> <tr class="x21" style="mso-height-source:userset;height:17pt" id="r0"> <td class="x20" style="height:14.75pt;width:138.75pt">Onedot Internes Format für das Onboarding</td> <td class="x21" style="width:138.75pt"></td> <td class="x21" style="width:138.75pt"></td> <td class="x21" style="width:67.5pt"></td> <td class="x21" style="width:67.5pt"></td> <td class="x21" style="width:67.5pt"></td> <td class="x21" style="width:67.5pt"></td> <td class="x21" style="width:67.5pt"></td> <td class="x21" style="width:67.5pt"></td> </tr> <tr class="x19" style="mso-height-source:userset;height:17pt" id="r1"> <td class="x19" style="height:14.75pt">Sprache</td> <td class="x19">Artikelnummer</td> <td class="x19">Produkttitel</td> <td class="x19">Langtext</td> <td class="x19">Kurztext</td> <td class="x19">Länge</td> <td class="x19">Breite</td> <td class="x19">Höhe</td> <td class="x19">Farbe</td> </tr> <tr style="mso-height-source:userset;height:16pt" id="r2"> <td style="height:16pt">DE</td> <td style="text-align:right">1234</td> <td>Hose</td> <td>Hose lang</td> <td>Hose lang</td> <td></td> <td></td> <td></td> <td>grün</td> </tr> <tr style="mso-height-source:userset;height:16pt" id="r3"> <td style="height:16pt">FR</td> <td style="text-align:right">1234</td> <td>Pontalon</td> <td>Pontalon</td> <td>Pontalon</td> <td></td> <td></td> <td></td> <td>vert</td> </tr> <tr style="mso-height-source:userset;height:16pt" id="r4"> <td style="height:16pt">IT</td> <td style="text-align:right">1234</td> <td>Pontalone</td> <td>Pontalone</td> <td>Pontalone</td> <td></td> <td></td> <td></td> <td>verde</td> </tr> <tr style="mso-height-source:userset;height:64pt;mso-xlrowspan:4" id="r5"> <td colspan="3" style="height:64pt;mso-ignore:colspan"></td> <td colspan="6" style="mso-ignore:colspan"></td> </tr> <tr class="x21" style="mso-height-source:userset;height:16pt" id="r6"> <td class="x21" style="height:16pt">Lieferantenkatalog DE</td> <td class="x21"></td> <td class="x21"></td> <td class="x21"></td> <td class="x21"></td> <td class="x21"></td> <td class="x21"></td> <td class="x21"></td> <td class="x21"></td> </tr> <tr class="x19" style="mso-height-source:userset;height:16pt" id="r7"> <td class="x19" style="height:16pt">Sprache</td> <td class="x19">Artikelnummer</td> <td class="x19">Produkttitel</td> <td class="x19">Langtext</td> <td class="x19">Kurztext</td> <td class="x19">Länge</td> <td class="x19">Breite</td> <td class="x19">Höhe</td> <td class="x19">Farbe</td> </tr> <tr style="mso-height-source:userset;height:16pt" id="r8"> <td style="height:16pt">DE</td> <td style="text-align:right">1234</td> <td>Hose</td> <td>Hose lang</td> <td>Hose lang</td> <td></td> <td></td> <td></td> <td>grün</td> </tr> <tr style="mso-height-source:userset;height:16pt" id="r9"> <td colspan="3" style="height:16pt;mso-ignore:colspan"></td> <td colspan="6" style="mso-ignore:colspan"></td> </tr> <tr class="x18" style="mso-height-source:userset;height:16pt" id="r10"> <td class="x18" style="height:16pt">Lieferantenkatalog FR</td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> </tr> <tr class="x19" style="mso-height-source:userset;height:16pt" id="r11"> <td class="x19" style="height:16pt">Langue</td> <td class="x19">Numéro d'article</td> <td class="x19">Titre du produit</td> <td class="x19">Texte long</td> <td class="x19">Texte court</td> <td class="x19">Longueur</td> <td class="x19">Largeur </td> <td class="x19">Hauteur </td> <td class="x19">Couleur</td> </tr> <tr style="mso-height-source:userset;height:16pt" id="r12"> <td style="height:16pt">FR</td> <td style="text-align:right">1234</td> <td>Pontalon</td> <td>Pontalon</td> <td>Pontalon</td> <td></td> <td></td> <td></td> <td>vert</td> </tr> <tr style="mso-height-source:userset;height:16pt" id="r13"> <td colspan="3" style="height:16pt;mso-ignore:colspan"></td> <td colspan="6" style="mso-ignore:colspan"></td> </tr> <tr class="x18" style="mso-height-source:userset;height:16pt" id="r14"> <td class="x18" style="height:16pt">Lieferantenkatalog IT</td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> </tr> <tr class="x19" style="mso-height-source:userset;height:16pt" id="r15"> <td class="x19" style="height:16pt">Lingua</td> <td class="x19">Numero dell'articolo</td> <td class="x19">Titolo del prodotto</td> <td class="x19">Testo lungo</td> <td class="x19">Testo breve</td> <td class="x19">Lunghezza</td> <td class="x19">Larghezza</td> <td class="x19">Altezza</td> <td class="x19">Colore</td> </tr> <tr style="mso-height-source:userset;height:16pt" id="r16"> <td style="height:16pt">IT</td> <td style="text-align:right">1234</td> <td>Pontalone</td> <td>Pontalone</td> <td>Pontalone</td> <td></td> <td></td> <td></td> <td>verde</td> </tr> <tr style="mso-height-source:userset;height:32pt;mso-xlrowspan:2" id="r17"> <td colspan="3" style="height:32pt;mso-ignore:colspan"></td> <td colspan="6" style="mso-ignore:colspan"></td> </tr> <tr class="x18" style="mso-height-source:userset;height:16pt" id="r18"> <td colspan="3" class="x18" style="mso-ignore:colspan;height:16pt">Dictionary - Übersetzung von sprachabhängigen Quellatributten</td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> <td class="x18"></td> </tr> <tr style="mso-height-source:userset;height:16pt" id="r19"> <td style="height:16pt">Artikelnummer</td> <td>Numéro d'article</td> <td>Numero dell'articolo</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr style="display:none"> <td style="width:138.75pt"></td> <td style="width:138.75pt"></td> <td style="width:138.75pt"></td> <td style="width:67.5pt"></td> <td style="width:67.5pt"></td> <td style="width:67.5pt"></td> <td style="width:67.5pt"></td> <td style="width:67.5pt"></td> <td style="width:67.5pt"></td> </tr> </tbody></table></div>