Why isn't my data transferring over to NCDOT?

In this article, learn how to troubleshoot the NCDOT data transfer


Applicable Subscription Levels:   

QC MANAGER |  STARTER  |  PRO  |  PRO+  |  ENTERPRISE


In this article, topics include:

How do I know if data has been transferred to NCDOT's database? 

How can I tell if an item has passed inspection?

How can I tell if an item is ready to be shipped?

How and When is data transferred to NCDOT?

What is the minimum information required for an NCDOT cast item (concrete test information)?

What is the minimum information required for an NCDOT product item (product information)?

What should I do if an Item failed to be transferred to NCDOT's database?

If I can see an item in my system, why can't my inspector find it on his tablet?

How do I add a Concrete Mix ID to my dropdown lists?

How do I know if data has been transferred to NCDOT's database?

The best way to determine if your product or cast data has been transferred to NCDOT's system is using the NCDOT Production Report with Inspections.  This report pulls data directly from the NCDOT database.  An item that appears on this report has been transferred to NCDOT's database.

How can I tell if an item has passed inspection?

The best way to determine if your product has passed inspection is by using the NCDOT Production Report with Inspections.  This report pulls data directly from the NCDOT database and includes columns for the Inspection Date and Inspection Results.  If these fields have been filled in on this report, the inspection is complete.  If these fields are blank for an item, the inspection is incomplete, or the inspector has not yet synced his tablet to the NCDOT database.

How can I tell if an item is ready to be shipped?

In order for a product to be received on the project site, an Authorized Field Inspection Report (FIR) for the item must exist in NCDOT's HiCAMS system.  To check the HiCAMS system, use NCDOT's Alternate ID Lookup page. Use your product's serial number as the Alternate ID (wildcard searches are available).  The FIR Status must be "Authorized" before the product can be received on an NCDOT job site.  See example below:



How and When is data transferred to NCDOT?

NCDOT uses Idencia to capture and collate product data provided by Precast and Prestressed producers.  Data flows from the Producer's Idencia database, to NCDOT's Idencia database, and finally to NCDOT's Highway Construction and Materials System (HiCAMS).  Below is a brief overview of how and when this data is transferred.

  1. Product data are entered by the Producer into the Producer's Idencia database
  2. Once every hour, data captured in the Producer's Idencia database is transferred to NCDOT's Idencia database.  Only data captured since the last transfer is sent.

    NOTE:  Unless additional configuration is completed in your Idencia Management Portal, ALL data you capture in your Idencia database will be transferred to NCDOT's Idencia database.  If you capture information for jobs not associated with NCDOT, and you would like to transfer ONLY data related to NCDOT products, contact your Customer Liaison for assistance in configuring your system to send only NCDOT data to the NCDOT database.

  3. Product Inspection data are entered by NCDOT inspectors into the NCDOT Idencia database
  4. Every night at approximately 8:00 pm, completed product inspections are transferred from NCDOT's Idencia database to NCDOT's HiCAMS system.  A Field Inspection Report (FIR) is created for each inspected product.
  5. Field Inspection Reports are approved by NCDOT Supervisors

IMPORTANT NOTE:  Products can not be accepted on an NCDOT job site without an approved Field Inspection Report in HiCAMS.  A passing inspection recorded by the NCDOT Inspector while on site at your plant IS NOT enough for the product to be accepted on the job site. The project's Resident Engineer MUST find an approved Field Inspection Report in the HiCAMS system in order to receive your product onto the job site.  Please verify an approved Field Inspection report exists prior to shipment.

What is the minimum information required for an NCDOT cast item (concrete test information)?

Precast

Captured on the cast item when completing the NCDOT Concrete Test process:  Pour Date, Pour Number, Concrete Mix, Slump, Air Content, Concrete Temperature, and Ambient Temperature.

Prestressed

Captured on the cast item when completing the NCDOT Prestress Concrete Test process:  Pour Date, Bed/Pour Number, Concrete Mix, Air Content, Slump, or Spread and Flow, Concrete Temperature, Ambient Temperature, Cap Used, and Cylinder Diameter.

What is the minimum information required for an NCDOT product item (product information)?

Precast

Captured on the Custom Item Type when creating / importing Custom Item Types for each job:  Material, Material ID, Material Type, Material Type ID, Producer, Producer ID

Captured on each Item when completing the NCDOT Product process: Pour Date, Pour Number, Concrete Mix  

Prestressed

Captured on the Custom Item Type when creating / importing Custom Item Types for each job:  Bridge Number, County, Material, Material ID, Material Type, Material Type ID, NCDOT Contract Number, Producer, Producer ID.

Captured on each Item when completing the NCDOT Product process: Pour Date, Pour Number, Concrete Mix  

What should I do if an Item failed to be transferred to NCDOT's database?

All new data and data updates are transferred from your Idencia database to NCDOT's Idencia database once every hour.  Items with a modified date greater than the last transfer time will be transferred at the next transfer time.  If data was missed, or for some reason failed to transfer to NCDOT's database, you can update the item's modified date/time to the current time so that it will be re-transferred in the upcoming hour.  To do this:
1.  In the Management Portal, select the item from the Items list
2.  Click Edit in the top right-hand corner of the screen.
3.  Click Save (you do not need to actually make any changes, just clicking Save will update the item's modified date/time to the current date/time).
The item will be transferred to NCDOT's system in the next scheduled transfer.
If the inspector is onsite, and the item MUST be inspected, you can force your application to transfer data to NCDOT's database early by following these steps:
1.  In the Management Portal, open the Data Transfers menu
2.  Select "Start Data Transfer".    
 
TransferButton
The "Start Data Transfer" option will begin the transfer of data updated since the last successful transfer.
 

If I can see an item in my system, why can't my inspector find it on his tablet?

Inspectors can only see items on their tablet that have been properly transferred from your database to NCDOT's database.  If the item was just created or updated in the last hour, the new/updated data may not have had time to transfer to NCDOT's database.  Data is transferred from your database to NCDOT's database once every hour.  If enough time has passed, and your inspector still cannot see the item on his tablet, try the following troubleshooting tips:
 
1.  In your Idencia Management Portal, check the NCDOT Production Report with Inspections. 
If the item appears on this report, your inspector should be able to see it on his tablet.  If the item appears on this report and your inspector still can't see the item on his tablet, have your inspector re-sync his tablet.  
If the item does not appear on this report, continue to step 2.
2.  In your Idencia Management Portal, verify that the item exists in the Items list.  
On the Items page, type in the last few characters of the item's serial number.
If the serial number is found, but it does not exist on the NCDOT Production Report with Inspections, continue to step 3.

3. If the data exists in your Idencia system but has failed to transfer to NCDOT's idencia system, follow the instructions for what to do if an item failed to be transferred to NCDOT's database.

If the items still don't transfer after updating the item's modified date or going through the 'Start Data Transfer', continue to step 4.

4. In your Idencia Management Portal, check to see if your data transfers are restricted by customer.

  • Open the Data Transfers menu
  • Select Remote Data Setup
  • Select the tab Remote Data Targets

    tempsnip

If the Restrict to Customer is NCDOT and Restrict Items to Customer is True then only items within a Job with NCDOT as a customer will transfer. 

Check that your Jobs have the correct setup and if needed, follow the instructions in the How do I maintain a customer list? article to manage your customer list.

Remember that all new data and data updates are transferred from your Idencia database to NCDOT's Idencia database once every hour.

How do I add a Concrete Mix ID to my drop down lists?* 

*Pro+ Subscribers follow the instructions below. Other subscription levels, please contact Support.

On occasion, you may have a new Concrete Mix approved by NCDOT.  In order to get the new Mix ID to appear in your drop down lists on the mobile device, follow the steps below.

To Update the NCDOT Product Process

1.  In your Idencia Management Portal, navigate to Setup --> Processes

2.  Click on the NCDOT Product process

3.  Under Phases & Steps click on the Concrete Mix step

4.  Click Edit

5.  Add a new line in the Options box and enter your new Mix ID.  If the Options box does not appear,
     check the Select value from list of options checkbox, then enter each Mix ID on a separate line.

6.  Click Save

To update the NCDOT Concrete Test Process

1.  In your Idencia Management Portal, navigate to Setup --> Processes

2.  Click on the NCDOT Concrete Test process

3.  Under Phases & Steps click on the Concrete Mix step

4.  Click Edit

5.  Add a new line in the Options box and enter your new Mix ID.  If the Options box does not appear,
     check the Select value from list of options checkbox, then enter each Mix ID on a separate line.

6.  Click Save