MMOG.np User Guide
29/01/2021 Set up MMOG.np / Customer perspective 6
Release 2.4.0 © Odette International Ltd
1.2. Create suppliers using the “bulk” import functionality
You can create supplier records by using the “bulk” import functionality.
MMOG.np requires UTF-8 encoded plain text files to import data csv files.
How to create csv files?
There are several ways to create csv files
- export data from other systems (e.g. ERP database or other databases)
- export from Excel
- manually by using a plain text editor
We describe here how you can create a csv file based on an Excel template provided by Odette to
import data.
Download the Odette Excel template: https://odette.org/mmog/resources.
Open the template.
Please note:
- The template must include a header line as defined in the sample-files UUID, title, role,
manufacturing_site, contact_name, email, telephone, address.line_1, address.line_2,
address.zip_code, address.city, address.state, address country (ISO 3166-1). and assessment
mailbox.
- The role must be supplier
- For the import of suppliers, you must specify the “manufacturing_site”
- The validation of fields is implemented according to the normal validation within MMOG.np
e.g. mandatory fields, unique fields
- All entries must be correct for the import to be successful
- The application shows any import problems to be solved when importing files
- When the same UUID is used several times in a file:
o if it is imported for the first time, a "duplicate UUID error" will be triggered
o if the UUID is already in the database, the last record in the list with that UUID will
be the one that is taken into account.