Setting up Secondary Transport Costing data¶
Secondary Transport Costing can read configurations and datasets from the SC Navigator database. To import your data to this database, you need to use Data Navigator. Please see the Data Navigator documentation for more details about this app.
- Launch Data Navigator.
- Select Secondary Transport Costing as the application type.
- In the Menu bar, select Secondary Transport Costing Data Wizard.
- Read the instructions and click Start wizard.
- Follow the prompts in the wizard. When you have answered all questions, an overview of your answers appears. Click Next to go to the Save Configuration page.
- Enter a name and description for your configuration. Click Finish to exit the wizard and save the configuration to the database.
- Click the arrow icon next to Download Template to download
Excel Template. The file contains the relevant sheets according to your configuration in Secondary Transport Costing Data Wizard.
Excel Templateand enter the required data, e.g. your Location Data. Fill in all sheets and save the Excel file.
- Go back to Data Navigator and click Import Dataset Basic.
- Enter a name for the dataset to be imported from the Excel file you just created. You can also enter a description.
- Click the plus icon next to Select Excel File. Select the Excel file that you created above.
- Click the upload file icon to upload the Excel file to the database. Data Navigator returns a success message. If something goes wrong, error/warning message(s) will appear at the bottom of the page. The Import Dataset page provides information to correct the issues, or explains why the data cannot be imported.
- After importing, click Review Data to review what was imported to the database. If everything looks fine, you can close Data Navigator.