Road Roughness - AWM Import Process

 Import Roughness Data into AWM

This section outlines the process for importing validated Roughometer or Totalpave roughness data into the AWM Roughness Reading table. 

1. Search 'Classic Applications' in AWM Menu, select and this will open Citrix Workspace and launch RAMM Manager.
2. Confirm the correct database is selected (Papua New Guinea).
3. Go to File → Import File → Load.
4. Select the model output CSV file and click Next. Note – your csv file will need to be accessible via the C drive. So move it into a folder accessible via C drive such as ‘temp’ (create a new folder if required). 
5. Choose the Roughness table ‘rough’ and click Next.
6. Choose Delimiter ‘Comma’ and click Next.
7. For ‘Import Data Date Format’ select DMY
8. Link fields and add default values such as ‘Latest’ under the latest field. Then select Load (it will no longer be greyed out once field mapping complete). NOTE // Each field coloured red needs to have an icon next to it – either mapped to one of the input fields or have a default value provided.
9. Select survey_number in the Fields in rough table, then select the dropdown and select an existing survey header or create a new one.
10. For survey_number, you may need to add a survey header if it is a new survey, using the + button.  The ‘Survey’ name should start with S followed by a sequential ID number (use number following the previous number), then the year of survey followed by a description which should include name of road/region (or national) and the data collection method. For example, S10 – 2025 National Totalpave Survey. The date should be the latest date in the survey period. Then select the green arrow to confirm.  RAMM Manager showing dropdown for survey_number.
11. For vehicle_speed, if it is not available in the data (currently it is not included in Totalpave but is included in Rough-o-meter) enter 50 (for 50 km/h). Note// This is a default value that could be decided to be updated.
12. Still on the same page, look through table and see if any columns are empty. If so, select the column and unlink it from the CSV. Then leave it blank or populate it yourself.
13. If your data is historical and not the latest readings, you can select the ‘latest’ column and unlink it. Then from the dropdown select ‘Not latest’ and select link again to link it back to the column. 
14. Next sequentially select Next, Load, Validate, Check Duplicates and Move to RAMM. If you encounter any errors in these steps, they will need to be resolved before continuing.

Validate and Finalise Import

This section describes the final checks performed within AWM to confirm that Roughometer roughness data has been imported correctly and is visible in the Roughness Reading table. 

1. Open AWM and search for Roughness Reading.
2. Filter the table for the survey used, by selecting the filter icon above the table. Then click Add and select Survey as the column to filter by with the value to filter for being the survey used.
3. Visually check the data is now in the AWM Roughness Reading table. 

AWM Roughness Reading table after being imported.

1. If this is the latest survey on this particular section of road we need all other surveys for Roughness Reading on that road to be turned to historic. To do this, click process data and then in the status check window tick Set most recent flags for Roughness Data. Then begin processing. (Screenshots of how to do this are provided below).

Where to find the Process Data button.

Where to find the Set most recent flags for Roughness data button.