Cronjobs Import/en: Unterschied zwischen den Versionen
Aus Wiki csv4you
Haemel (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „*''Days'' :The weekdays for your cron job (several times or weekdays mark/delete with Ctrl + left mouse button) :No selection = every day :In order for your ti…“) |
Haemel (Diskussion | Beiträge) |
||
Zeile 88: | Zeile 88: | ||
:In order for your time settings to be saved, an import template must absolutely be selected! | :In order for your time settings to be saved, an import template must absolutely be selected! | ||
− | + | Do not forget to '''Save''' your settings! | |
[[Category:DATAPOOL]] | [[Category:DATAPOOL]] |
Version vom 5. Juli 2016, 17:24 Uhr
Cronjobs "Import" gives the possibility to automatically import different data feeds - daily at certain times - into your data pool (for example, due to inventory changes). The following data types can be imported currently via a cronjob: products, inventory and categories.
To create a new cron job, click on the button [Create new cronjob (import)].
To change a cron job use the button [Edit].
Inhaltsverzeichnis
Cronjob (Import)
Watch out!
For the correct application of an import cron job, the creation of a corresponding import template is mandatory. To setup a new import template - a data import must be performed once "manually! </ Span>
- Name of Cronjob
- a descriptive name for this cronjob
- Type
- Type of the import template: Product or Inventory
- URL import file
- enter the URL to your import file here OR the file name and FTP server (FTP-Server 1, 2, 3 - as set up under MY ACCOUNT->Base Settings-> Tab FTP data).
- 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)
Type - Product or Inventory
Depending on the type of cron job, are either settings for the type product or inventory to make.
Settings "Produkt"
- Template
- Select a saved "Product" import template
- The import of product data and inventory data must be performed at least 1x by hand (under Data Pool -> Data Import). Only then can the template be assigned. If the selected template does not fit the specified file type - the column mapping is flawed and your cron job will break off or does not start at all.
This means:
For import-cronjobs of the type Product you need a template type Product.
For import-cronjobs of the type Inventory you need a template type Inventory.
- 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.
Watch out!
Data sets without unique ID are created again with each import and so appear several times in the DATAPOOL.
- 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.
- Example:
- Your data pool contains 20 fields with different values, but you want to import only the columns TITLE and EAN, e.g. because some product titles of your offer have changed and should be updated. Then mark the option here and select only the columns EAN and TITLE. EAN numbers should of course not be changed to allow a correct assignment of the new title.
- 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.
Settings "Inventory"
- Import Template
- Select saved inventory import template
- Set all inventory levels to 0 before importing
- When checked, the inventory levels of all products in the data source are set to a value of 0 before importing.
XML-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
Time Settings
- Time
- Highlight the respective times at which your file should be imported.
- Days
- The weekdays for your cron job (several times or weekdays mark/delete with Ctrl + left mouse button)
- No selection = every day
- In order for your time settings to be saved, an import template must absolutely be selected!
Do not forget to Save your settings!