Time: Importing Data into LCP from DSPTCH

LCP Tracker

To access the LCP Tracker export, first navigate to the job you want to export data for. From there, go to the "Compliance" tab at the top, and click "Wage Determination" on the side menu. On that page there will be a "Tabulate" button next to the Create New Wage Determination button.

Compliance --> Wage Determination --> Tabulate

Clicking Tabulate will open a tabular view of the LCP Export, as seen below.

The table displays data for the entire Job by default. Since LCP only accepts one week at a time, the data must be filtered to the desired week before exporting.

To do so, click on the "Filters" button on the left hand side menu (outlined in the red box). This will pull up some options of columns you can filter by.

The two important ones are "week_end_date" and "class_code".

week_end_date will be necessary to export a single week of data. Select the checkbox of the week that data is being exported from

class_code can be very useful for a job with a mix of PWA and non-PWA workers. De-selecting (Blanks) will exclude workers that are not PWA.

Filter options - "week_end_date" and "class_code" are useful for exporting the data you need.

Once the table is filtered as necessary, export the data by clicking the "Exports" button on the left hand side menu and choosing "to Excel" under "Export all rows."

Hit "Exports" then "to Excel" to export your data in LCP format.

It is important to use "to Excel" for the LCP export as that is what LCP Tracker expects.

Uploading exports to LCP Tracker

Once the export is downloaded, upload it to LCP Tracker by following these steps:

Login to LCP tracker and navigate to the "1. Payroll Records" tab
Click "Upload Records"
Choose the Week end date, project and location sections
1. If there is payroll data syncing with DSPTCH, leave the "Calculate fringes automatically box un-checked
Choose the file downloaded from DSPTCH to upload
Hit "Upload"

After clicking "Upload", a progress bar should appear with records being uploaded and verified. Upon success, a screen will open to Craft Match or Edit the uploaded records.

For more information about how to Craft Match or Edit, please refer to LCP Tracker's Documentation

We have seen the upload process run into errors when using the Microsoft Edge browser. If you are getting errors when uploading, try uploading while using Google Chrome.