Contents

    Creating an import schedule

    Your task/initial situation

    You would like to automate the import of CSV or ZIP files. To do this, you need to create an import schedule that checks at certain intervals whether there are new CSV or ZIP files that need to be imported.

    Prerequisites

    • You create an export of your data at regular intervals, either as a CSV file or as a ZIP archive. In addition to the CSV file, the ZIP archive can also contain invoice and delivery note files for sales orders. For more information on this topic go here: Importing sales order data
    • You export the CSV or ZIP file to the same location at regular intervals. This location is accessible via an Internet protocol (e.g. FTP, HTTPS). A password may be required for this.
    • You have already created an import template to be able to import the file. Further reading: Creating an import template.

    Creating an import schedule

    1. Log in to the Fulfillment Portal with your access data (Go to FFN Portal).
    2. Click on the menu item Data exchange. The page Data exchange opens.
    3. Click on Import. The page Import schedules opens.
    1. Click on the Create import schedule button. The page Creating import schedules opens.
    1. Give the import schedule a name and select an import template. If you have not yet created an import template, please read the following page first: Creating an import template.
    2. Under Protocol, select the protocol via which the file can be accessed. Depending on the protocol, new configuration options appear. Complete them so that the JTL-Fulfillment Network can access the file.
    Please note: Under File path, enter the path on the server and the name of the CSV or ZIP file. Example: If the file is accessible via ftp://myserver.com/Exports/MyExport.csv, enter Exports/MyExport.csv here.
    1. Under Import interval, select how often your CSV or ZIP file should be imported. Under Interval you enter the time interval between the imports; under Start on you can select the first day on which an import is to take place.
    2. Save your import schedule. The import will now carried out regularly.

    Related topics