ich arbeite seit vielen Jahren begeistert mit CAO, aber das nur als kleine Einleitung.
Ich möchte nun den Artikelstamm für einen Export in OXID aufbereiten und habe den Export sowie den Import mit HeidiSQL in einer Testdatenbank auf Funktion überprüft.
Export in CSV (UTF-8, damit Umlaute erhalten bleiben) klappt vorzüglich.
Ich habe dann die Datei direkt ohne irgendwelche Änderungen versucht wieder zu importieren.
Das klappt auch, allerdings erhalte ich immer 64 Warnungen wie folgt:
Code: Alles auswählen
/* 2015-01-23 20:40:51 [MySQL] */ SHOW WARNINGS;
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'ERSATZ_ARTIKEL_ID' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'WARENGRUPPE' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'ARTIKELTYP' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'ME_ID' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'PR_EINHEIT' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'INVENTUR_WERT' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'BASISPR_ME_ID' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'STEUER_CODE' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'AUTODEL_FLAG' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'EK_LIEFERZEIT_ID' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'AUFW_KTO' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'HERSTELLER_ID' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'PFAND1_ARTIKEL_ID' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'PFAND2_ARTIKEL_ID' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'ETIKETT_PRINT' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'LIEFSTATUS' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'LIEFERTERMIN' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'VAR_ID' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'NE_ZUSCHLAG_FLAG' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'NE_GEWICHT' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'ERSTELLT' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'GEAEND' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_ARTIKEL_ID' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_VISIBLE' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_DATE_NEU' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_FAELLT_WEG_AB' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_CLICK_COUNT' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_SYNC' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_ZUB' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1264): Data truncated; out of range for column 'SHOP_CHANGE_DATE' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_CHANGE_FLAG' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_DEL_FLAG' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_LIEFSTATUS' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_CHANGE_LIEF' at row 1 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'ERSATZ_ARTIKEL_ID' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'WARENGRUPPE' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'ARTIKELTYP' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'ME_ID' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'PR_EINHEIT' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'BASISPR_ME_ID' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'STEUER_CODE' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'AUTODEL_FLAG' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'EK_LIEFERZEIT_ID' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'AUFW_KTO' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'HERSTELLER_ID' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'PFAND1_ARTIKEL_ID' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'PFAND2_ARTIKEL_ID' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'ETIKETT_PRINT' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'LIEFSTATUS' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'LIEFERTERMIN' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'VAR_ID' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'NE_ZUSCHLAG_FLAG' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'NE_GEWICHT' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'ERSTELLT' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'GEAEND' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_ARTIKEL_ID' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_VISIBLE' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_DATE_NEU' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_FAELLT_WEG_AB' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_CLICK_COUNT' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_SYNC' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1265): Data truncated for column 'SHOP_ZUB' at row 2 */
/* 2015-01-23 20:40:51 [] */ /* Warning (1264): Data truncated; out of range for column 'SHOP_CHANGE_DATE' at row 2 */Nun könnte ich ja drüber hinwegsehen, da alles importiert wird und CAO fehlerfrei funktioniert.
Aber ich möchte die Warnungen gerne verstehen und falls möglich vermeiden.
Welche Daten werden da denn abgeschnitten?
Die Felddeklarationen und die Inhalte sind ok, ich habe mal die ersten Spalten der Fehlermeldungen geprüft, was sollte da z.B. bei Spalte ERSATZ_ARTIKEL_ID in Zeile 1 nicht stimmen?
Hat jemand von Euch da dieselben Erfahrungen gemacht und eine Lösung?
Beste Grüße
Thomas