Übersetzungen exportieren
Aus Wiki csv4you
Wechseln zu:
Navigation
,
Suche
Einstellungen
Gruppe
Abonnements Anbieterdaten
Abonnements Marktplätze
Abonnements Preisvergleiche
Abonnements Shopsysteme
Anforderungen Systemumgebung
Cronjobs Import
Datenimport
Datensicherung Exportprofile
Datensicherung Importvorlagen
Datensicherung Interne Kategorien
Datensicherung Produkte
Ebay FAQ
Ebay Fehlermeldungen
Ebay Hilfe
Ebay How to
Ebay Varianten
Erweiterte Feldfunktionen
Exportprofile - eigene Spaltenzuordnung
Exportprofile Bilder
Exportprofile Cronjob
Exportprofile Filter
Exportprofile Grundeinstellungen
Exportprofile Kategorieauswahl
Exportprofile Sonstiges
Exportprofile Varianten
FAQ
Grundeinstellungen Amazon
Grundeinstellungen API
Grundeinstellungen Datenquellen
Grundeinstellungen Ebay
Grundeinstellungen FTP-Daten
Grundeinstellungen Gambio GX3
Grundeinstellungen Medien
Hauptseite
Importvorlagen
Individuelle Schnittstellen
Interne Kategorien
Kategoriezuordnung
Letzte Aktivitäten - API
Letzte Aktivitäten - Download
Letzte Aktivitäten - Importieren
Listings Amazon
Listings eBay
Listings Sonstige
Mein Konto Start
MS Excel Tipps
Persönliche Angaben
Preiskalkulation
Produkte
Produkte Varianten
Produkttemplates
Schnellanleitung
Universaldateien
Vergleichen
Videos
Vorlage:Cronjobs
Übersicht Tickets
Sprache
aa - Afar
ab - Abkhazian
ace - Achinese
ady - Adyghe
ady-cyrl - Adyghe (Cyrillic script)
aeb - Tunisian Arabic
aeb-arab - Tunisian Arabic (Arabic script)
aeb-latn - Tunisian Arabic (Latin script)
af - Afrikaans
ak - Akan
aln - Gheg Albanian
am - Amharic
an - Aragonese
ang - Old English
anp - Angika
ar - Arabic
arc - Aramaic
arn - Mapuche
arq - Algerian Arabic
ary - Moroccan Arabic
arz - Egyptian Arabic
as - Assamese
ase - American Sign Language
ast - Asturian
atj - Atikamekw
av - Avaric
avk - Kotava
awa - Awadhi
ay - Aymara
az - Azerbaijani
azb - South Azerbaijani
ba - Bashkir
ban - Balinese
bar - Bavarian
bbc - Batak Toba
bbc-latn - Batak Toba (Latin script)
bcc - Southern Balochi
bcl - Central Bikol
be - Belarusian
be-tarask - Belarusian (Taraškievica orthography)
bg - Bulgarian
bgn - Western Balochi
bh - Bhojpuri
bho - Bhojpuri
bi - Bislama
bjn - Banjar
bm - Bambara
bn - Bangla
bo - Tibetan
bpy - Bishnupriya
bqi - Bakhtiari
br - Breton
brh - Brahui
bs - Bosnian
bto - Iriga Bicolano
bug - Buginese
bxr - Russia Buriat
ca - Catalan
cbk-zam - Chavacano
cdo - Min Dong Chinese
ce - Chechen
ceb - Cebuano
ch - Chamorro
cho - Choctaw
chr - Cherokee
chy - Cheyenne
ckb - Central Kurdish
co - Corsican
cps - Capiznon
cr - Cree
crh - Crimean Turkish
crh-cyrl - Crimean Tatar (Cyrillic script)
crh-latn - Crimean Tatar (Latin script)
cs - Czech
csb - Kashubian
cu - Church Slavic
cv - Chuvash
cy - Welsh
da - Danish
de - German
de-at - Austrian German
de-ch - Swiss High German
de-formal - German (formal address)
din - Dinka
diq - Zazaki
dsb - Lower Sorbian
dtp - Central Dusun
dty - Doteli
dv - Divehi
dz - Dzongkha
ee - Ewe
egl - Emilian
el - Greek
eml - Emiliano-Romagnolo
en - English
en-ca - Canadian English
en-gb - British English
eo - Esperanto
es - Spanish
es-formal - español (formal)
et - Estonian
eu - Basque
ext - Extremaduran
fa - Persian
ff - Fulah
fi - Finnish
fit - Tornedalen Finnish
fj - Fijian
fo - Faroese
fr - French
frc - Cajun French
frp - Arpitan
frr - Northern Frisian
fur - Friulian
fy - Western Frisian
ga - Irish
gag - Gagauz
gan - Gan Chinese
gan-hans - Gan (Simplified)
gan-hant - Gan (Traditional)
gcr - Guianan Creole
gd - Scottish Gaelic
gl - Galician
glk - Gilaki
gn - Guarani
gom - Goan Konkani
gom-deva - Goan Konkani (Devanagari script)
gom-latn - Goan Konkani (Latin script)
gor - Gorontalo
got - Gothic
grc - Ancient Greek
gsw - Swiss German
gu - Gujarati
gv - Manx
ha - Hausa
hak - Hakka Chinese
haw - Hawaiian
he - Hebrew
hi - Hindi
hif - Fiji Hindi
hif-latn - Fiji Hindi (Latin script)
hil - Hiligaynon
ho - Hiri Motu
hr - Croatian
hrx - Hunsrik
hsb - Upper Sorbian
ht - Haitian Creole
hu - Hungarian
hu-formal - magyar (formal)
hy - Armenian
hz - Herero
ia - Interlingua
id - Indonesian
ie - Interlingue
ig - Igbo
ii - Sichuan Yi
ik - Inupiaq
ike-cans - Eastern Canadian (Aboriginal syllabics)
ike-latn - Eastern Canadian (Latin script)
ilo - Iloko
inh - Ingush
io - Ido
is - Icelandic
it - Italian
iu - Inuktitut
ja - Japanese
jam - Jamaican Creole English
jbo - Lojban
jut - Jutish
jv - Javanese
ka - Georgian
kaa - Kara-Kalpak
kab - Kabyle
kbd - Kabardian
kbd-cyrl - Kabardian (Cyrillic script)
kbp - Kabiye
kg - Kongo
khw - Khowar
ki - Kikuyu
kiu - Kirmanjki
kj - Kuanyama
kk - Kazakh
kk-arab - Kazakh (Arabic script)
kk-cn - Kazakh (China)
kk-cyrl - Kazakh (Cyrillic script)
kk-kz - Kazakh (Kazakhstan)
kk-latn - Kazakh (Latin script)
kk-tr - Kazakh (Turkey)
kl - Kalaallisut
km - Khmer
kn - Kannada
ko - Korean
ko-kp - Korean (North Korea)
koi - Komi-Permyak
kr - Kanuri
krc - Karachay-Balkar
kri - Krio
krj - Kinaray-a
krl - Karelian
ks - Kashmiri
ks-arab - Kashmiri (Arabic script)
ks-deva - Kashmiri (Devanagari script)
ksh - Colognian
ku - Kurdish
ku-arab - Kurdish (Arabic script)
ku-latn - Kurdish (Latin script)
kum - Kumyk
kv - Komi
kw - Cornish
ky - Kyrgyz
la - Latin
lad - Ladino
lb - Luxembourgish
lbe - Lak
lez - Lezghian
lfn - Lingua Franca Nova
lg - Ganda
li - Limburgish
lij - Ligurian
liv - Livonian
lki - Laki
lmo - Lombard
ln - Lingala
lo - Lao
loz - Lozi
lrc - Northern Luri
lt - Lithuanian
ltg - Latgalian
lus - Mizo
luz - Southern Luri
lv - Latvian
lzh - Literary Chinese
lzz - Laz
mai - Maithili
map-bms - Basa Banyumasan
mdf - Moksha
mg - Malagasy
mh - Marshallese
mhr - Eastern Mari
mi - Maori
min - Minangkabau
mk - Macedonian
ml - Malayalam
mn - Mongolian
mo - Moldovan
mr - Marathi
mrj - Western Mari
ms - Malay
mt - Maltese
mus - Creek
mwl - Mirandese
my - Burmese
myv - Erzya
mzn - Mazanderani
na - Nauru
nah - Nāhuatl
nan - Min Nan Chinese
nap - Neapolitan
nb - Norwegian Bokmål
nds - Low German
nds-nl - Low Saxon
ne - Nepali
new - Newari
ng - Ndonga
niu - Niuean
nl - Dutch
nl-informal - Nederlands (informeel)
nn - Norwegian Nynorsk
no - Norwegian
nov - Novial
nrm - Norman
nso - Northern Sotho
nv - Navajo
ny - Nyanja
nys - Nyungar
oc - Occitan
olo - Livvi-Karelian
om - Oromo
or - Odia
os - Ossetic
pa - Punjabi
pag - Pangasinan
pam - Pampanga
pap - Papiamento
pcd - Picard
pdc - Pennsylvania German
pdt - Plautdietsch
pfl - Palatine German
pi - Pali
pih - Norfuk / Pitkern
pl - Polish
pms - Piedmontese
pnb - Western Punjabi
pnt - Pontic
prg - Prussian
ps - Pashto
pt - Portuguese
pt-br - Brazilian Portuguese
qqq - Message documentation
qu - Quechua
qug - Chimborazo Highland Quichua
rgn - Romagnol
rif - Riffian
rm - Romansh
rmy - Romani
rn - Rundi
ro - Romanian
roa-tara - Tarantino
ru - Russian
rue - Rusyn
rup - Aromanian
ruq - Megleno-Romanian
ruq-cyrl - Megleno-Romanian (Cyrillic script)
ruq-latn - Megleno-Romanian (Latin script)
rw - Kinyarwanda
sa - Sanskrit
sah - Sakha
sat - Santali
sc - Sardinian
scn - Sicilian
sco - Scots
sd - Sindhi
sdc - Sassarese Sardinian
sdh - Southern Kurdish
se - Northern Sami
sei - Seri
ses - Koyraboro Senni
sg - Sango
sgs - Samogitian
sh - Serbo-Croatian
shi - Tachelhit
shi-latn - Tachelhit (Latin script)
shi-tfng - Tachelhit (Tifinagh script)
shn - Shan
si - Sinhala
simple - Simple English
sk - Slovak
skr - Saraiki
skr-arab - Saraiki (Arabic script)
sl - Slovenian
sli - Lower Silesian
sm - Samoan
sma - Southern Sami
sn - Shona
so - Somali
sq - Albanian
sr - Serbian
sr-ec - Serbian (Cyrillic script)
sr-el - Serbian (Latin script)
srn - Sranan Tongo
ss - Swati
st - Southern Sotho
stq - Saterland Frisian
sty - cебертатар
su - Sundanese
sv - Swedish
sw - Swahili
szl - Silesian
ta - Tamil
tay - Tayal
tcy - Tulu
te - Telugu
tet - Tetum
tg - Tajik
tg-cyrl - Tajik (Cyrillic script)
tg-latn - Tajik (Latin script)
th - Thai
ti - Tigrinya
tk - Turkmen
tl - Tagalog
tly - Talysh
tn - Tswana
to - Tongan
tpi - Tok Pisin
tr - Turkish
tru - Turoyo
ts - Tsonga
tt - Tatar
tt-cyrl - Tatar (Cyrillic script)
tt-latn - Tatar (Latin script)
tum - Tumbuka
tw - Twi
ty - Tahitian
tyv - Tuvinian
tzm - Central Atlas Tamazight
udm - Udmurt
ug - Uyghur
ug-arab - Uyghur (Arabic script)
ug-latn - Uyghur (Latin script)
uk - Ukrainian
ur - Urdu
uz - Uzbek
uz-cyrl - Uzbek (Cyrillic script)
uz-latn - Uzbek (Latin script)
ve - Venda
vec - Venetian
vep - Veps
vi - Vietnamese
vls - West Flemish
vmf - Main-Franconian
vo - Volapük
vot - Votic
vro - Võro
wa - Walloon
war - Waray
wo - Wolof
wuu - Wu Chinese
xal - Kalmyk
xh - Xhosa
xmf - Mingrelian
yi - Yiddish
yo - Yoruba
yue - Cantonese
za - Zhuang
zea - Zeelandic
zh - Chinese
zh-cn - Chinese (China)
zh-hans - Simplified Chinese
zh-hant - Traditional Chinese
zh-hk - Chinese (Hong Kong)
zh-mo - Chinese (Macau)
zh-my - Chinese (Malaysia)
zh-sg - Chinese (Singapore)
zh-tw - Chinese (Taiwan)
zu - Zulu
Format
Für die Offline-Übersetzung exportieren
Im systemeigenen Format exportieren
Hole
{{DISPLAYTITLE:Data Import}}<languages/> The '''Data Import''' offers the opportunity to integrate product data from CSV, XML, or other files into the DataPool as master data or to update already imported records. Every data import can be set up to run completely automated - via cronjobs. Additionally, all Data Import settings can be saved in a custom import template. Data can be imported from various sources. Choose one of the options. '''Attention!''' <span style="white-space: pre-wrap">Stock levels are read in via a separate import - not with the product import. The corresponding products must already be available in the Data Pool (1. Product import -> 2. Inventory import).</span> == Import Options == Select a file and - if already present - a suitable template. In import templates, the assignments between the columns in your import file and the fields in the DATAPOOL can be saved. Thus, the individual field assignments must not be re-established for each import. Importing of data can be repeated very quickly and as often as desired. If you change existing assignments during an import, the used import template is thereby also changed. If you are importing an XML file, a check mark must be set in "XML-data" box. '''Aufpassen!''' <span style="white-space: pre-wrap">MS-Excel-Dateien sollten keine Makros und keine Berechnungen enthalten. Hier kann es sonst u.U. zu Fehlern beim Import kommen.<br />Dateinamen dürfen generell keine Sonderzeichen oder Umlaute enthalten!</span> After your file has been imported, a new window will appear ... === Option A: Import File from PC === Upload an import file from your local computer. === Option B: Import File from URL === Specify an HTTP or FTP address. To import from an FTP server, you must first make the required settings under: My Account -> Base Settings -> FTP data. === Variante C: Import Internal Supplier Data === If data of a supplier on csv4you already has been activated for you, you can import the relevant product data into a new data source here. == Your file has been loaded == Set the properties for the file to import. Depending on the file type, the displayed properties can vary. It will also give you the file name and the number of temporarily recognized records are shown. '''Watch out!''' <span style="white-space: pre-wrap">Item numbers (Item IDs) can be a maximum of 50 characters long.</span> === General Settings === *''File Type (Content)'' :Type of the file to be imported: #''Categories:'' Import of category data only #''Products:'' Import and update of product and category data #''Inventory:'' Updating of inventory data (visible only after products have already been created) *''Column Mapping Template'' :Please note, that a selected template for column mapping should match the file type. === CSV-Specific Settings === *''Separator'' :Specify the data- or column separator that is used in your import file. *''Text Qualifier'' :Specify the text qualifier that is used in your import file. *''Headers in Row'' :Specify which row contains the column labels (usually this is the 1st) === XML-Specific Settings === *''XML-element of the product data'' :Enter the XML-element of the actual product entries, e.g .: ''product'' *''Variants'' :XML-element for Variants, z.B.: ''product->variant'' Then press the button [Apply these Settings] for a current view in the area ''Assign your columns to the master data in the DATAPOOL''. == Cell Mapping und Import Options == === [ Master Data Mapping ] === Assigning your columns contents to the fields in the DATAPOOL *''Field name in database'' :List of available fields in the system :A maximum of 20 additional fields can be defined via DATAPOOL -> Base Settings -> Data Source -> Actions -> Edit Additional Data Feelds. These should then appear here as field names. *''Columns of the File'' :Column names of your import file. :Assign the column names of your import file to a corresponding field in the DATAPOOL. Categories can also get created and updated via the product import. Any space in the ID field is converted automatically to an underscore. *''Advanced options'' :Allows you to assign a fixed value as the content of a field, for example, ''NEW''. :In addition, the content from several columns of your import file can be assigned to a single field in the DATAPOOL. For this, put your field names in square brackets. Example: ''[title]'' - ''[EAN]'' === [ Additional Language Sets ] === If you have activated additional languages, they are displayed here. Datenfelder für zusätzliche Sprachen, falls in Ihrer Importdatei vorhanden. === [ Import Options ] === Select Import Options *''Create missing items in the Data Pool'' :If items are found during the import, which are not already present in the Data Pool, they will be created (items with changed product ID are also considered new items). Deselect this option, if only a synchronization of already existing items shall be made. *''Data sets even without an own ID'' :Data sets without unique ID are also imported (by default). Do you want to make sure that only those records with a unique ID get imported, remove the check mark. *''Remove formatting from the text!'' :All HTML code will be removed from the imported data. *''If UPDATE: Ignore missing columns!'' :Only applicable for UPDATES: If you want to transfer only certain columns from your file, this option must be enabled. That way, only the data from the selected columns in your file is imported and the rest will be ignored. Otherwise, this data would be deleted or overwritten with an "EMPTY" value. *''Incorporate categories from import file'' :If your import file contains product categories, you can incorporate these as internal categories in the data pool. Already existing data will be updated at every import. Newly added categories are then created as new internal categories. *''Creating a backup of the old data before importing'' :Before importing, a backup of your existing data will be created. *''Currency Conversion'' :Please, always use here the setting ''Standard''! Adjust this to a particular currency only, if you are certain what this function does '''and''' if [[Export_Settings_Grundeinstellungen#General | example 4]] - applies to your import. *''Import template - Save As'' :Save your import settings as a template with a descriptive name, for example, 'IMPORT Template XTCommerce' (if you leave this blank, "default" will be used). This way, you do not have to make - for repeated imports - the columns assignment again and again, but to only choose the appropriate import template. Also, the update of an existing column mapping is possible here. '''Watch out!''' <span style="white-space: pre-wrap">For the automatic import of data via a cronjob, creating and assigning of an import template is mandatory!</span> *''Create as new Export Interface'' :If selected, a new individual interface is generated using the imported columns (see ''Export ->Individual Interfaces''). == Import Particularities == === Parent Item === To declare an item as the Parent, write the value 'isParent' in the field 'Parent-ID' at the 'Advanced Options'. === Currency Conversion === For all currency conversions in the export area, the system always starts from prices in EUR. Problems could arise, if you import prices in another currency as the EUR (for example, USD, GBP or SEK) '''and''' these prices should be converted again in another currency during the export. This only works, if the prices are converted in EUR during the import into the database (can be set at the import). The Conversion of prices in EUR during the import is not required, if import and export currency are the same. That means, you can import the prices in USD, if you later also export the prices in USD. Here is an example of how to convert your prices during the import from USD in EUR: *Price Edit (Data Import -> Master Data -> Columns assignment), edit your column ''price'', which may have a different name in your import file: :[[File:import_edit_price.png||400px|Parents]] * then insert the function, as described in the picture: :[[File:Choose_price_and_your_currency.png||400px|Parents]] [[Category:Datenpool]]
Navigationsmenü
Ansichten
Spezialseite
Meine Werkzeuge
Deutsch
Anmelden
NAVIGATION
Hauptseite
Schnellanleitung
Erweiterte Feldfunktionen
Ebay Hilfe
FAQ
Kategorien
Datenpool
Export
Listings
Mein Konto
Suche
Hilfe
MediaWiki Hilfe
Letzte Änderungen
Werkzeuge
Spezialseiten