Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Return to Overview

There are 4 methods to upload your demurrage data from your Excel spreadsheet into our 'Demurrage Claims' table. Please note that this function is currently supported by Google Chrome browser only.

To access the 'Demurrage Claims' page, click 'Demurrage' from the navigation sidebar on the left. 

Image Modified

Table of Contents
maxLevel2
minLevel2

...

2. You are now ready to upload your file. In the ‘Demurrage Claims’ page, click on the three dots located at the top right corner of the page, followed by ‘Upload File(s)’. Upload your Excel spreadsheet and a pop-up message will appear if the data has been uploaded successfully. 
Please note that once you upload your file, only the data records in that file will be displayed in the ‘Demurrage Claims’ table. This allows you to check your uploaded data first before saving and does not mean that your existing data has been replaced. Once you click 'Save Claims', all your existing data, together with the uploaded data will be reflected.

Note: For data exported directly as an excel file from the demurrage claims table (right click>export>excel), you will be required to save the file first before you can upload the file.



3. You will be able to see all the uploaded data in the ‘Demurrage Claims’ table. Click 'Save Claims' to save your data in the table. Please note that values in red are invalid and have to be resolved before saving your data. Otherwise, clicking 'Save Claims' will save all the other data successfully but will only save the values in red as empty values. 



4. In your Excel spreadsheet, if you have any items that are not named exactly as those in the drop down list in the 'Demurrage Claims' table, you may use the 'Find and Replace' function in Excel. For example, you may change ‘Payment/Receipt’ (listed in your Excel) to ‘Payable/Receivable’ (listed in the 'Demurrage Claims' table). Use Ctrl + F and click on the 'Replace' tab. Type 'Payment' under 'Find what' and type 'Payable' under 'Replace with' and click ‘Replace All’. Do the same for 'Receipt'. You may then upload the data into the table successfully.

...

1. To ensure that the header names of the columns in your Excel spreadsheet match exactly with those in the 'Demurrage Claims' table without changing the former, you may download the standard table layout as an Excel or CSV file from the 'Demurrage Claims' table and input your data before uploading the file. 



2. You may use any table layout (reset or customised). Right-click anywhere in the table and click 'Export', and choose the format of the file (CSV or Excel) to be downloaded into your device for your usage. 

Please note that this function will export any existing data in your 'Demurrage Claims' table into the Excel spreadsheet. Otherwise, you may delete any existing data first before exporting the table for use as the standard table layout.


3. Open the newly exported file (standard table layout) and fill in your data. You are now ready to upload your file. 

...

Please note that once you upload your file, only the data records in that file will be displayed in the ‘Demurrage Claims’ table. This allows you to check your uploaded data first before saving and does not mean that your existing data has been replaced. Once you click 'Save Claims', all your existing data, together with the uploaded data will be reflected.

Note: For data exported directly as an excel file from the demurrage claims table (right click>export>excel), you will be required to save the file first before you can upload the file.




4. You will be able to see all the uploaded data in the ‘Demurrage Claims’ table. Click 'Save Claims' to save your data in the table. Please note that values in red are invalid and have to be resolved before saving your data. Otherwise, clicking 'Save Claims' will save all the other data successfully but will only save the values in red as empty values. 



5. In your Excel spreadsheet, if you have any items that are not named exactly as those in the drop down list in the 'Demurrage Claims' table, you may use the 'Find and Replace' function in Excel. For example, you may change ‘Payment/Receipt’ (listed in your Excel) to ‘Payable/Receivable’ (listed in the 'Demurrage Claims' table). Use Ctrl + F and click on the 'Replace' tab. Type 'Payment' under 'Find what' and type 'Payable' under 'Replace with' and click ‘Replace All’. Do the same for 'Receipt'. You may then upload the data into the table successfully.

...

3. You will be able to see all the uploaded data in the ‘Demurrage Claims’ table. Click 'Save Claims' to save your data in the table. Please note that values in red are invalid and have to be resolved before saving your data. Otherwise, clicking 'Save Claims' will save all the other data successfully but will only save the values in red as empty values. 


4. In your Excel spreadsheet, if you have any items that are not named exactly as those in the drop down list in the 'Demurrage Claims' table, you may use the 'Find and Replace' function in Excel. For example, you may change ‘Payment/Receipt’ (listed in your Excel) to ‘Payable/Receivable’ (listed in the 'Demurrage Claims' table). Use Ctrl + F and click on the 'Replace' tab. Type 'Payment' under 'Find what' and type 'Payable' under 'Replace with' and click ‘Replace All’. Do the same for 'Receipt'. You may then upload the data into the table successfully.

...

3. You will be able to see all the uploaded data in the ‘Demurrage Claims’ table. Click 'Save Claims' to save your data in the table. Please note that values in red are invalid and have to be resolved before saving your data. Otherwise, clicking 'Save Claims' will save all the other data successfully but will only save the values in red as empty values. 


4. In your Excel spreadsheet, if you have any items that are not named exactly as those in the drop down list in the 'Demurrage Claims' table, you may use the 'Find and Replace' function in Excel. For example, you may change ‘Payment/Receipt’ (listed in your Excel) to ‘Payable/Receivable’ (listed in the 'Demurrage Claims' table). Use Ctrl + F and click on the 'Replace' tab. Type 'Payment' under 'Find what' and type 'Payable' under 'Replace with' and click ‘Replace All’. Do the same for 'Receipt'. You may then upload the data into the table successfully.

...