To streamline production operations, ERP-generated data files containing production orders and related information such as products and tools, can be automatically integrated into Connect. This is done with a file-based integration workflow.



Shared folder setup

  • A designated shared folder is available on the BMSedge and configured by our system installers.

  • Our system installers provide configuration files DWNL<type>.XML in this shared folder according the type of data. For example for production orders, the name is DWNLJobs.xml. Such XML file defines:

    • The filename syntax of the data files. For example JOB*.txt specifies that the filenames must start with 'JOB' and have the extension .txt.

    • The file type, e.g. CSV.

    • The data format, i.e. delimiters, date format, ...

    • The mapping of the ERP fields with the the Connect database fields.

  • Our system installers give the exact path to this folder to the customer.
    The folder looks like this: \\<BMSedgeDeviceName>\LinkToConnect

  • If desired, you can map this folder to a drive letter to simplify access.

Import process

  • This folder acts as a drop location for ERP files. You can copy your ERP files there automatically or manually.

  • Connect continuously monitors the folder for new files.

  • Upon detection, files are imported and processed automatically and one by one. As long as a file is in the shared folder, it is being processed.

  • Production orders with a past due date will not be accepted.

  • The data will appear in the appropriate Connect modules after a refresh (F5).

  • A production order can be changed as long as it is not yet executing or executed.

  • If the ERP-file contains an order, that order will be updated with the new data, if it is not yet executing. This will overrule any manual changes that have been done after the first import.


Post-processing

The file is moved to a subfolder according the result:


ResultSuccessFailure
FolderCompletedError
Log fileConfirms the operation and shows any relevant messages.Details the cause of the failure. Search for [ERR] to find the orders that are not processed


Files moved to either the completed or error folders are date-stamped. This date reflects when the processing was finished.

These files are no longer required by the ERP connection system.