Import and Export LDC Data - The Data Cycle

Laptop Data Collector (LDC) and Roadsoft Data Cycle

After successfully installing Roadsoft and the Laptop Data Collector, agencies can begin to export, import, and collect data using the LDC.

A video tutorial on The Data Collection Cycle is available

Because there are keyboard shortcuts defined within the LDC, typical keyboard shortcuts such as Ctrl + C (copy) and Ctrl + V (paste) will not work.

 

Step 1 – Define the Area of Data Collection

If collecting data for roads, such as road condition, rating, or surface type, create a filter containing the desired road network. To create this filter, continue following the steps in this section.
If collecting data for signs, culverts, driveways, and guardrails, either create a filter OR move on to Step 2 – Create LDC Export from Roadsoft. 

With the desired layer visible and active (see Use the Map Interface for assistance with layers):

1.       Select Filter from the map options.

2.       Select Filter Builder.

3.       Choose the desired filter field, operator, and value.

4.       Select the Add button to apply the chosen filter criteria.

See Use the Filter Builder for additional help with the Filter Builder.

·         Repeat step 3 and 4 to add additional filter criteria.

5.       Select the Save option at the top of the window.

6.       Enter a filter name in the Name field.  

7.       Select the Save As button.

8.       Select Apply as Filter.

9.       Close the window.

Step 2 – Create LDC Export from Roadsoft

1.       In Roadsoft, select LDC from the main menu options.

2.       Select Export Data for LDC.

3.       Select the Yes button in the window asking, “Are you collecting data for the Asset Management Council (TAMC)?” when collecting PASER data for the TAMC (applicable to road data only and required when collecting PASER data for submitting data to the TAMC). Select No to continue if the data collection if the data collection is not road data or the road data collection is not for TAMC submission.

4.       Select a Data Type(s) from the Export to LDC window by clicking once in the desired checkbox.

Road collection requires the application of a filter and upon selection, the Load Saved Filter window automatically opens.  If choosing any other asset, the default setting is to export everything for the selected asset. Select the Open [Asset Name] Filter Builder link to open the Filter Builder and either make a new filter or apply a saved filter. See Use the Filter Builder for help with the Filter Builder.

5.       Select an export option.

·         Select the Export to Folder radio button to export the data file to a specified folder.

a.       Select an export path option.

·         Select the Folder icon to choose an Export Path.

                                                                        i.      Select a file export location in the Browse for Folder window.

o   Select theOK button to use the current location selection.

o   Select the Cancel button to exit the window without exporting.

o   Select the Make New Folder button to create a new folder.

a.       Select the OK button to use the new folder as the export location, or select the Cancel button to exit the window without exporting.

 

·         Select an existing path using the drop-down list.

Note the chosen export path. The export creates a RStoLDC_[jurisdiction name]_[date & time].ldcz  Example: RStoLDC_Houghton(County)_2014_08_14_12_30.ldcz) which is needed for Step 3 – Import the LDC Export into LDC.

·         Select the Export Directly to LDC Data Folder option to export the data directly to the LDC.

Applicable only when Roadsoft and the LDC are installed on the same machine.

6.       Select the Export button to complete the export, or select the Cancel button to exit without exporting.

7.       Select the OK button in the Export Created confirmation window.

 

If the export file was created using the Export to Folder process, locate the .ldcz file and save it to a removable drive if the file location is not accessible by the LDC. Once the file is accessible by the LDC, move to Step 3 – Import the LDC Export into LDC. If the export file was created using the Export Directly to LDC Data Folder process, skip to Step 4 – Start Collecting Data.

Step 3 - Import the LDC Export into LDC

1.       Start the Laptop Data Collector (LDC).

2.       Select the Folder icon to the right of the DB field in the LDC login window.

3.       Locate and select the .ldcz file saved in the previous instruction section, Step 2 – Create LDC Export from Roadsoft.

4.       Select the Open button.

5.       Enter a crew name, or use the drop-down list to select an existing crew name in the Crew field.

6.       Select the OK button and move to Step 4- Start Data Collecting.

Step 4 – Start Collecting Data

The LDC is now ready for collecting data based on the imported network criteria. For example, if a road network export from Roadsoft included the Latest Surface Rating with values of Poor, Very Poor, and Failed – only roads that fit those criteria are editable for collection in the LDC. See Connect a GPS for help with GPS connection to the LDC. See the Roadsoft Manual for assistance with collecting specific data types.

Certain items are not editable and/or collectable using the LDC:

·         Road framework

·         Crash Data

·         Traffic Count Data

Step 5 - Export Collected Data from LDC

Once data collection is complete in the LDC, export the data collection from the LDC for import into Roadsoft.

1.       Select the File option from the main menu.

2.       Select an export option.

·         Select the Export DB/Data to Roadsoft… to export the data file to a specified folder.

a.       Select an export path option.

·         Select the Folder icon to choose an Export Path.

                                                            i.                     Select a file export location in the Browse for Folder window.

o   Select theOK button to use the current location selection.

o   Select the Cancel button to exit the window without exporting.

o   Select the Make New Folder button to create a new folder.

a.       Select the OK button to use the new folder as the export location, or select the Cancel button to exit the window without exporting.

·         Select an existing path using the drop-down list.

Note the chosen export path. The export creates a LDCtoRS_[jurisdiction name]_[date & time].ldc2rs Example: LDCtoRS_Houghton(County)_2014_08_14_12_30.ldc2rs) which is needed for Step 6 – Import Collected Data to Roadsoft.

b.      Select the Export button to complete the export, or select the Cancel button to exit without exporting.

c.       Select the OK button in the Export Created confirmation window.

·         Select the Upload Data to Roadsoft… option to export the data directly to Roadsoft.

Applicable only when Roadsoft and the LDC are installed on the same machine.

·         Select the Yes button to complete the export directly into Roadsoft.

                                                               i.      Select the OK button in the Upload Successful window.

·         Select the No button to exit the Upload Data to Roadsoft window without exporting.

 

If the export file was created using the Export DB/Data to Roadsoft process, locate the .ldc2rs file and save it to a removable drive if the location is not accessible by the LDC. Once the file is accessible by the LDC, move to Step 6  – Import Collected Data to Roadsoft. If the export file was created using the Upload Data to Roadsoft process, skip Step 6 – Import Collected Data to Roadsoft.

Step 6 - Import Collected Data to Roadsoft

With Roadsoft open:

1.       Select the LDC option from the main menu.

2.       Select Import Data from LDC.

3.       Select the Browse for LDC Export button.

4.       Locate and select the saved the .ldc2rs file saved in the previous instruction section, Step 5 – Export Collected Data from LDC.

5.       Select theOpen button to continue with the export, or select the Cancel button to return to the Import Data from LDC window.

6.       Select the Import LDC Data button, or select the Cancel button to exit without exporting.

7.       Select an import option.

·         Select the Yes button in the window asking, “It is highly recommended that you perform a Roadsoft Data Backup prior to importing LDC data. Do you wish to do a backup prior to importing?” to complete a backup prior to importing (highly recommended).

a.       Select a backup file location and create the backup. Import will automatically start when the backup is complete.

See Backup, Move & Restore Databases for additional assistance with backing up the database.

·         Select the No button to continue the import without backing up.

·         Select the Cancel button to exit without importing.

It is important to perform all steps of the Data Cycle before using the LDC for further data collection. This ensures that the most up-to-date data is used.