Multinational CB
  • Getting Started
    • Overview
    • Activation
  • Data Management
    • Overview
    • Certification Bodies
    • Certified Entities
      • Mark CE Data as Confidential
    • Certifications
    • Data Import
      • Certification File Templates
        • XML General Rules
        • Manage Data in XML
      • Data Import Methods
        • File Upload
        • FTP
        • API Integration
      • FTP Settings
      • Global Mapping
        • Data Mapping
          • Data Mapping by Country
          • 🆕 Data Mapping by Sectors
        • Field Mapping
      • Import Activities
      • Import Settings
  • Error Handling
    • Error Handling
    • Resolve Field Mapping Issues
    • Resolve Field Check Issues
    • Resolve Data Mapping Issues
    • Resolve Data Check Issues
  • Settings
    • Accounts
    • Users
    • Settings
      • User Settings
      • Notification Settings
      • Security Settings
  • IAF CertSearch Data Structure
    • Templates
    • Certified Entity and Certification Fields Glossary
Powered by GitBook
On this page
  • Getting Started
  • Prerequisites
  • How to import Certification data via FTP
  1. Data Management
  2. Data Import
  3. Data Import Methods

FTP

PreviousFile UploadNextAPI Integration

Getting Started

FTP allows you to upload data in bulk from your server every 24 hours. This works for both Excel and XML formats. Users are required to set up an Active FTP connection and the filenames to be retrieved from the server.

Average Transfer Speed: 30 secs ~ 2 mins, may vary depending on the quality of the data

Acceptable Formats: XLSX and XML

Recommended: Small, Medium, and Large Certification Bodies that have anywhere between 20 to 50,000 certifications


Prerequisites

  1. Set up an Active FTP Connection

  2. In your FTP server, upload files (.xlsx or XML) with your

  3. Define the filenames you want to retrieve from the server


How to import Certification data via FTP

  1. go to 'Import Certification' page

  2. Choose 'FTP' as your data import method

  3. If an FTP connection is not yet added, you'll be asked to set it up

  4. Fill out or edit the following text fields

    • FTP Access Status

      • Active, continuously fetch/download the files from the FTP

      • Inactive, stops fetching /downloading the files from the FTP

    • FTP Server Protocol

      • FTP, relies on usernames and passwords for authentication

      • SFTP, uses SSH keys for authentication, which are much more secure

    • Server Host

    • Server Port

    • Server Username

    • Server Password

      • If SFTP is selected, add the Private Key

  5. To check if the FTP is successfully connected, click the 'Test FTP Connection' button.

  6. Once the FTP is connected, click the 'Save and Continue' button.

  7. In the next screen, add the file names you want to fetch from the FTP server

    • You can tick the 'Wildcard' option if you have multiple files in the FTP directory to be fetched with a common naming convention

      Example:

      The filename is certs and the 'Wildcard' option is ticked.

      Then, the system will look for the following filenames in the directory:

      • certs_1.xlsx

      • 2_certs.xlsx

      • 3_certs_4.xlsx

  8. Once added, click the 'Fetch Data' button

  9. Once done, the process proceeds to Step 2 where data validation is initiated

  10. Once validated, your data will successfully be added to IAF CertSearch

formatted data