Upload Data to Master Tables
  • 02 Jun 2022
  • 1 Minute à lire
  • Sombre
    Lumière
  • PDF

Upload Data to Master Tables

  • Sombre
    Lumière
  • PDF

The content is currently unavailable in French. You are viewing the default English version.
Résumé de l’article

Upload Data to Master Tables

Data Operators

Data Operators have the right to add data to assigned Master Tables. The Master Tables access for Data Operators is provided by the Operator, also known as the Admin.

To upload data to Master Tables, follow the sequence below:

  1. Log in to the DL Asset Track Participant with valid login credentials.

  2. The Master Table page is the only section available on the Navigation Panel.

  3. A list of all the Master Tables that are accessible appears on the screen.

  4. Locate the required Master Table and click on it.

Upload Button

Note: The Upload button is only seen if the login is using the Data Operator account.

Required master tables.png

  1. Click on the Upload button on the top right corner.

Upload data button.png

  1. The Upload sidebar appears on the right.

Upload sidebar.png

Upload Instructions

The Upload sidebar has vital information about uploading data on master tables.
• Making changes in the data may impact the calculations.
• Please upload verified and correct data only.
• Duplicate entry is not allowed. Please check the input file for duplicate entries.
• Please check the file for the overlapping date range and remove any discrepancies before uploading.
• Row versions will be maintained for the same key values.
• The maximum file size is 10 MB.

  1. Click on the Download Template link.
  2. An Excel Worksheet is saved on the device. Locate and open the Excel Worksheet.
Master Table Template

The Excel Worksheet, also known as the Master Table Template, is saved with a platform-generated name. A sample name would be Template-1635944512312 - A prefix of ‘Template’ followed by a series of numbers.
The Master Table Template contains all the columns present on the Master Table on the platform.

Master Table Template .png

  1. Fill in the values on the Master Table Template for the respective columns. Once the data is updated, save the template.
Note:

Remember to close the Master Table Template worksheet before uploading it on the platform.

  1. Click on the Upload area on the Upload sidebar. As the instruction states, drag and drop a file to upload it on the platform.
  2. After the Master Table Template is uploaded, the Upload button on the bottom right of the sidebar gets activated.

Upload add to master table.png

  1. Click on the Upload button to successfully add data to the Master Table.

Cet article vous a-t-il été utile ?

What's Next
Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.