A MasterData Upload is the process of collecting all the information necessary for building programs and records in different modules within Safefood 360°. The MasterData workbook, once completed, is uploaded to the Safefood360° system. These building blocks are then used when creating different plans or programs in Safefood 360°. A successful and well-planned Master Data upload will greatly reduce the effort when creating all your programs with Safefood 360°.

If you have not already done so, please download the MasterData workbook here.

If you require the SQM master data workbook click here. This would be used only when you have purchased the Supplier Quality Management Solution.

When completing the MasterData workbook you will see a tab called Causes and a tab called Non-conformances. If you require examples of these to complete your workbook, click here to access an excel document with examples of non-conformances and causes.

In the Master Data workbook, each tab represents a MasterData module in Safefood 360°. For example, in the Employee tab, all the information needed to bulk upload your employees to the Employee's module in Safefood360° can be completed. The first row, in grey, is an example of an entry for that worksheet.

Columns highlighted in red are mandatory information for upload. There should be no blank rows or fields in any column highlighted in red.

Highlighted in orange are the columns which are not mandatory for the MasterData upload, but are mandatory if you have Supplier Portal or Alerts to set up. They are highly recommended for the smooth operation of your Safefood360° site.

Fields with an asterix (*) contain drop-down values.

Note for Adding Suppliers to the Workbook:  Add each supplier entity to the workbook as any supplier relationships/connections will be completed during your project implementation with a different excel workbook. For example, if you have an Agent/Broker called ABC Company and they have several manufacturing sites, Company X, Company Z, Company Y, simply add each entity into the MasterData Workbook Supplier tab, and later an additional workbook will be created for the connections between entities to be established (This is the same when you have the situation where you have a Corporate site and different manufacturing facilities connected with the main corporate site).

• Make sure you remove the example highlighted in grey in the first row of each tab to avoid unnecessary uploads.
• All the duplicates (product, materials duplicates, etc.) need to be removed; this can easily be done by using an excel formula, please refer to the following link, http://www.excelfunctions.net/remove-duplicates-excel.html.

Or, use the following instructions:

* Select the range of cells, or make sure that the active cell is in a table.

* On the Data tab, in the Data Tools group, click Remove Duplicates.

* Do one or more of the following: Under Columns, select one or more columns.

* Click OK.

* Click OK.

• Blank lines need to be removed; this can be easily done by using the excel formula, please refer to the following link, https://www.extendoffice.com/documents/excel/823-excel-delete-multiple-empty-columns.html, or use the following instructions:

* Click Home > Find & Select > Go To Special, in the Go To Special dialog box, check the Blanks option.

* And then click OK, all of the blank columns of the selected range are highlighted.

* Then click Home > Delete > Delete Sheet Columns, the blank rows have been deleted from the selected range.

• Phone numbers should be entered using the full country code without any spaces or dashes (for example “+4985123123123”).
• The E-mail address should be entered in the following format: [email protected].
• Each tab in the workbook has an optional 'Folder' column which allows you to organize your data into logical groups. You can use a back-slash to define sub-folders, e.g. Management\Quality.
• Not all of the tabs need to be filled in. You can add them in manually later if you feel you are not ready yet for that Master data. However, you should try to get in as much data as you can from the start.

Mandatory information which must be provided:

- Employee’s first and last name.

- Employee’s nature of employment - can be chosen from a drop-down list with two options Employee or Agency. If Agency is selected then you will be asked to select the agency supplier.

- Employee’s position.

Mandatory information which must be provided when setting up Alerts:

- Employee’s e-mail address must be provided in case an employee will a user and to allow the alerts to work.

Optional Information:

- Employee ID or code, if applicable. If no identifier is entered then the system will automatically generate a number upon saving.

- Folder, which allows you to organize your employees into logical groups. You can use a back-slash to define sub-folders, e.g. Management\Quality.

- Employee’s address.

- Employee’s phone number.

- Employee’s mobile phone number.

- Employee’s date of birth.

- Employee’s sex.

- Employee’s nationality.

- Employee’s first language.

- Employee’s second language and proficiency.

- Employee’s date of commencement.

Mandatory information which must be provided:

- Title of the job description.

- Description of the job (Should be no longer than 255 Characters).

Optional Information:

- ID or code, if applicable. If no identifier is entered then the system will automatically generate a number.

- Folder is particularly useful for separating large functions in a company such as HR from Production.

Mandatory information which must be provided:

- Product name in the proposed naming convention, “ID Code :: Product Name” as it will be easier to search for related products when creating the programs/records and also, to avoid having duplicates.

Optional Information:

- ID or code, if applicable. If no identifier is entered then the system will automatically generate a number upon saving.

- Define a folder where the product is stored. This helps you find and store the total amount of products you supply for easier reference later.

Mandatory information which must be provided:

- Material name in the proposed naming convention “ID Code :: Material Name” as it will be easier to find the related product and also, to avoid having duplicates.

Optional Information:

- Define a folder for the ingredient or material. This helps you organize your materials into logical groups so they can be easily sourced (e.g. Ingredients\Sweeteners).

- Select the country of origin which can be chosen from the drop-down list.

- Brief description of the ingredient or material.

Mandatory information which must be provided:

- Name of the services such as Pest Control, Calibration, Training, 3^rd Party Audits, Human Resources, etc.

Optional Information:

- ID or code, if applicable. If no identifier is entered then the system will automatically generate a number upon saving.

- Select which folder you want to save the service in. This helps you to group and categorize services into neat collections so you can easily search for, or navigate to them later.

- Description of the service.

Mandatory information which must be provided:

- The name of the non-conformance.

- Description.

Tip: Description of non-conformance won’t appear when selecting non-conformance in Safefood 360˚. The description can be included in the name of non-conformance in the following naming convention: e.g. “Foreign Body :: Metal”.

Tip: You don't need a different NC for products/materials. The same NC "Foreign Body :: Metal" can be used throughout the application.

Optional Information:

- Folder will allow you to easily distinguish the locations of non-conformances for future use.

Mandatory information which must be provided:

- The name of the root cause.

Optional Information:

- Folder, in case you intend to create an exhaustive list of different causes. It might make sense to categorize them into folders that will help the user find the correct cause type later on.

- Description of the causes.

Mandatory information which must be provided:

- The name of the brand.

Optional Information:

- Folder.

- Description.

Mandatory information which must be provided:

- The name of the production unit.

Optional Information:

- Select which folder the production unit will be saved under. This will allow you to easily distinguish the locations of production units for future use.

- Brief description of the production unit.

Mandatory information which must be provided:

- The name of the unit (units of weight, height, product, density, etc.).

- Sub Units: In the example provided in the workbook, the unit comprises 12 x 12 x 24 pallets, which means each unit has 3456 sub-units. Only numerical values should be entered here.

Optional Information:

- Folder: Save the unit of measurement into the units folder.

- Description of the unit.

Mandatory information which must be provided:

- The name of the customer.

Optional Information:

- ID or code for this customer if you have one.

- Folder.

- Phone number.

- Postal address details.

- Telephone or fax.

- Contact person, position, and e-mail address.

- 24 Hour contact number.

Mandatory information which must be provided:

- The name of the supplier.

Mandatory information which must be provided when setting up the Supplier portal:

- E-mail address: This email will be used for email notifications that are sent to the supplier

- Contact person.

- The phone number for the contact person.

Optional Information:

- The folder where you can group suppliers by type.

- 24 Hour contact should contain a full phone number (with country code). This phone number is used when SMS alerts are being sent to the supplier.

- ID or code for this supplier if you have one.

- Address.

- Telephone.

- Fax.

Note: Add each supplier entity to the workbook as any supplier relationships/connections will be completed during your project implementation with a different excel workbook. For example, if you have an Agent/Broker called ABC Company and they have several manufacturing sites, Company X, Company Z, Company Y, simply add each entity into the Master Data Workbook Supplier tab, and later an additional workbook will be created for the connections between entities to be established (this is the same when you have the situation where you have a Corporate site and different manufacturing facilities connected with the main corporate site).

Mandatory information which must be provided:

- The name of the organization.

Optional Information:

- ID or code for the organization if you have one.

- Folder: store it in the appropriate folder according to the type of organization.

- Organization telephone details.

- Postal address details.

- Contact name.

- Contact position.

- Contact’s e-mail address and phone number: These contact details are used when sending out alerts to the contact person, so make sure the email is correct and the phone number has a country code included.

Mandatory information which must be provided:

- The name of the site.

Optional Information:

- ID or code for the site if you have one.

- Folder: you can categorize your site contacts into folders allowing you to keep multiple contacts in better order.

- Site telephone details.

- Postal address details.

- Contact name.

- Contact position.

- Contact’s e-mail address and phone number: This email will be used for email notifications that are sent to the site contact. The 24 Hour Contact field should contain a full phone number (with a country code - for example, “+4985123123123”). This phone number is used when SMS alerts are being sent to the site.

Mandatory information which must be provided:

- The name and model of the item.

Optional Information:

- ID or code, if applicable. If no identifier is entered then the system will automatically generate a number upon saving.

- Folder: you can categorise your items into folders allowing you to keep them in better order.

- Serial number.

- Location.