MMOG.np USER GUIDE
How to bulk-import on sites
Release 3.1.0
MMOG.np User Guide
11/01/2023 Set up MMOG.np 2
Release 3.1.0 © Odette International Ltd
CREATE SITES USING THE “BULK” IMPORT FUNCTIONALITY
Important:
- To add a site, you must be logged-in as a C-Admin
- You can add sites manually (one by one) or use the ‘Bulk imports’ option
- The ‘Bulk imports’ option should be considered only if you have more than 10 sites otherwise
it is probably more efficient to add them manually
You can add sites for your company by using the ‘Bulk imports’ option.
MMOG.np requires UTF-8 encoded plain text files to import data (csv files).
There are several ways to create csv files
- export data from other systems (e.g., CRM database or other databases)
- export from Excel
- manually by using a plain text editor
Here we describe how you can create a csv file based on the Excel template provided by Odette.
Download the Excel template (Sample site-import) provided in the User Manuals zip file
https://www.odette.org/mmognp/mmog.pdf
Open the template.
Please note:
- The template must include a header line as defined in the sample-files UUID*, title,
address.line_1, address.line_2, address.zip_code, address.city, address.state,
address.country (ISO 3166-1).
*The UUID (Universally Unique ID) term is incorrect: All that is required is a unique ID (UID)
for the site within your own organisation.
- The validation of fields is implemented according to the validation within MMOG.np e.g.,
mandatory fields, unique fields
MMOG.np User Guide
11/01/2023 Set up MMOG.np 3
Release 3.1.0 © Odette International Ltd
- All entries must be correct for the import to be successful but the application shows any
import problems to be solved when importing files
- When the same UID is used several times in a file:
o if it is imported for the first time, a "duplicate UID error" will be triggered
o if the UID is already in the database, the latest record in the list will be the one that
is taken into account.
Populate the Excel template with data:
Using Excel, we suggest to use "save as ..." and choose comma separated values (csv).
Once you have your csv file, select Bulk imports in the ‘My company’ menu.
Import Data.
MMOG.np User Guide
11/01/2023 Set up MMOG.np 4
Release 3.1.0 © Odette International Ltd
You have imported new sites.
You can see that sites have been created, by selecting Sites in the ‘My company’ menu
You can now allocate Catalogue versions to the sites according to your licence.
MMOG.np User Guide
11/01/2023 Set up MMOG.np 5
Release 3.1.0 © Odette International Ltd
Please note:
- There are several csv formats but not all of them generate the correct data format.
- csv stands for "comma separated values" but Excel exports often use semicolon as the field
separator because in Europe the comma is often used as the decimal separator (e.g., 10,45).
- You can choose the field separator within the application (; or ,)
- If MMOG.np shows an error like "Unexpected text encoding error: "\xEF" from ASCII-8BIT to
UTF-8" please choose another export in Excel.
- If you get the following error messages “not a UTF-8 Format” or “Missing columns: UUID”
when you try to import sites using the bulk import option, this is because UTF-8 is the only
encoding admissible. Depending on your operating system, when converting your Excel file
into csv, the file generated is encoded in UTF-8 BOM, not UTF-8.
To fix this issue, once you have created the .csv format using Excel, you should save it in UTF-
8 format using a tool such as Notepad++. You can download Notepad++ from the internet
free of charge.
To save file as UTF-8 using Notepad++, open the file with Notepad++. select option
“encoding” (Encode in UTF-8) and Save file.
