Import Data

On the Import Data page you can import your filled data template file and save your data to the SC Navigator database.

../_images/import_data.png

Select Excel File

Press the plus sign button next to “Select Excel File” and select the completed data template file in the pop-up dialog. Click save sign to import the file.

It is possible that importing data will lead to warnings. One of the warnings is of this form Attribute Variable Throughput Cost for (Food Products,Ankara_LDC,Ankara_Location,2018) has multiple (2) values for Locations groups, for which at least some are different. This means that Ankara_Location belongs to two groups, and the data is specified differently for these two groups. SC Navigator takes the highest value, but still gives a warning. It is recommended that you fix the data issue, so that you don’t have any warnings anymore.

Important

Your data will not be saved until you click the button Store data in database!

Sheet overview

In the table Overview of read sheets you’ll see a list of sheets in the Excel file. Where data was not read, the text “Sheet exists, but not read. Is this expected?” appears. For sheets containing only comments or notes, this is expected and no action is required.

If sheets where you entered data are not read, you need to debug. The most likely reason is a sheet name was entered manually and doesn’t match the expected name, or you’ve uploaded data that isn’t needed for this configuration.

Switch off Only Show Exceptions to see all the sheets from the Excel file. Sheets where you have entered data correctly have status “Sheet exists and read”.

Attribute overview

The table Overview of attributes in Excel file shows the attributes that were read and their status.

By default only attributes with issues are shown. To see all attributes, including ones that were read successfully, switch off Only Show Exceptions.

There are 6 possibilities for Result Status:

  • Part of the configuration, and present (Data will be saved)

    Data was correctly entered in a required field.

    No action required.

  • Not part of the DatasetType and not present. (No data to be saved)

    There was no data provided, but there was no data expected for the selected Dataset Type.

    No action required.

  • Part of the configuration, but not present. Is that expected? (No data to be saved)

    Nothing was read for a required field.

    You need to debug. Maybe you forgot to enter data, or entered it in the wrong area. If you have edited a previous dataset or manually added sheets or columns, check that the attribute name is correct.

  • Not part of the configuration, but present and part of the Dataset Type. Is that expected? (Data will be saved)

    Data won’t be used for this configuration, but could be used later for another configuration for the same app.

    No action is required, but could be a red flag that your configuration needs to be changed to consider all the data that you entered.

  • Not part of the configuration, but present, but not part of the Dataset Type. Is that expected? (Data will NOT be saved)

    Data was read but isn’t used for any configuration for that app. Data Navigator will ignore this extra data.

    No action is required, but could be a red flag that your configuration needs to be changed to consider all the data that you entered.

  • Not a valid SC Navigator attribute. (Data will NOT be saved)

    The app doesn’t understand this data.

    No action is required, but could be a red flag that your configuration needs to be changed to consider all the data that you entered. In that case, you would also need to find out what attribute this data belongs to.

    If you have edited a previous dataset or manually added sheets or columns, check that the attribute name is correct.

The status indicates if the data for that attribute will be saved. Some attributes are not required to run the model successfully, so they are ignored even if provided.

If you are not sure if you have all the necessary data, try to run the model and check the results. If you need help, connect with Support.

Data Errors/Warnings

After importing the data, Data Navigator checks the data and its structure. If errors are found that might affect the model, the following dialog appears:

../_images/import_errors_warnings.png

Click the “Go To Data Issues Page” button to see more details about the errors found.

After checking the errors, you may find that some do not affect the model and do not need to be fixed.

However, items that begin with “ERROR:” MUST be fixed before the data can be saved to the database.

Save dataset

After importing and checking the data, save it to the SC Navigator database.

To save a dataset, provide a unique name. (The list of existing datasets is shown for reference.)

It’s a good practice to give the dataset a name that briefly describes its use (and possibly matching or based on the configuration it belongs to). The description field can be used for more detailed information. Click the button Store data in database to save.

After saving your dataset to the database, you can access it from the application it is made for.