Skip to main content
Skip table of contents

File synchronisation for import scenarios

This knowledge base article explains how to create a data provider and import scenario to import vendor data. By using the file synchronization feature, you can import new or modified vendor data added to the file to be imported into MYOB Advanced.

Important notes about using FTP sites

  • The path always needs to start with ftp://ftp

  • If it works in Total Commander, it will work in MYOB Advanced also, because they work the same way. However, the path may not be exactly the same. For example, in Total Commander, ftp.swfwmd.state.fl.us might work, but in MYOB Advanced you might need to use ftp://ftp.swfwmd.state.fl.us/

  • If you need to use a specific port in the Path, then you also need to use the name of the file that you are syncing, for example ftp://162.198.1.119:80/inbound/filename.txt

  • Ensure you have proper access to FTP site and the file is placed properly.

Image

Setting up file synchronisation for import scenarios with FTP sites

  1. Firstly a data provider needs to be setup as shown below.

    Image

    Image

    Image
  2. After the data provider is created, create the import scenario, link the data provider and then map the data fields to the Excel spreadsheet.

    Image
  3. Ensure the import scenario works and has the right results.

    Image
  4. Return to the data provider and click on the Files(1) option highlighted below.

    Image
  5. In the Files window, click Edit.

    Image
  6. Go to the Synchronization tab and enter the correct FTP site details.

    Image
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.