Integrated Data Entry

Table of Contents

ForneyVault

MetaField integrates with Forney break machines by utilizing the ForneyVault database and API's. Customers wishing to leverage the integrations to load break data from Forney break machines directly to MetaField will need to first subscribe to the ForneyVault service.

The ForneyVault API is able to receive specimen data from MetaField and store break data to the specimen record, which MetaField can retrieve through the Forney Vault API.

Forney data can be retrieved in one of two ways. The first is a scheduled tasks that runs every 30 minutes to check for new data in ForneyVault, specimens that are fully populated by the automated task will be advanced to the To Review Queue. The second method is a manual call made to the Forney API that is initiated through the Enter Test Results screen. These methods of data retrieval will only be enabled for customers with a Forney integration configured.

Posting Data to Forney

Prior to retrieving data from Forney specimens must be sent to Forney via a manual call. Updates to samples which have been created in Forney will be automatically observed by the integration and updated in ForneyVault. The automated tasks checks for samples that have been updated every 30 minutes.

Specimen post calls can be initiated through the "Export to Forney" button. When initiated, all checked records will be sent to Forney through an API call, once successfully transmitted the Exported flag will be changed to "Yes". Once exported a unique key, created by MetaField, will have been sent to Forney and stored in the MetaField database. This field will not be exposed but will serve as the link for record in ForneyVault and MetaField.

The following fields are sent to Forney from MetaField

Project Number
Lab ID
Sample Number + Specimen Test Age
Height (If specimen size defined in admin)
Diameter 1 & 2 (If specimen size defined in admin)
Set Number
Specimen Number
Specified Strength
Specified Strength Test Age

Cylinders

The "Retrieve Forney Data" button has been added to the Cast Cylinders/Grout Cylinders/Mortar Cylinders>Enter Test Results screen. When the call to Forney is initiated, MetaField will attempt to retrieve break data from Forney for each specimen that appears on the screen. MetaField will populate all data that is present either in the ForneyVault database or through predefined default values in the Administration area.

Only Cast Cylinder specimens are supported by the Forney Integration as of 2.13.

Integrated Fields

The following fields can be populated via the Retrieve Forney Data action or the scheduled Forney Data pull.

Field	Description
Diameter 1 (in)	By default, this field will not be populated by the integration. The existing value will be retained or one will have to be entered manually. Field can be configured to pull value from Forney database. Recommended, if measurements are taken at the time of break and entered in Forney interface. Default value can be defined to apply to all test results that do not have a Diameter measurement. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations or in the specimen size definition in Admin.
Diameter 2 (in)	By default this field will not be populated by the integration. Existing value will be retained or one will have to be entered manually. Field can be configured to pull value from Forney database. Recommended, if measurements are taken at time of break and entered in Forney interface. Default value can be defined to apply to all test results that do not have a Diameter measurement. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations or in the specimen size definition in Admin.
Height (in)	By default this field will not be populated by the integration. Existing value will be retained or one will have to be entered manually. Field can be configured to pull value from Forney database. Recommended, if measurements are taken at time of break and entered in Forney interface. Default value can be defined to apply to all test results that do not have a Height measurement. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations or in the specimen size definition in Admin.
Load Strength (lbs)	MaxLoad value recorded by Forney break machine will be used to populate Load Strength.
Capping Method	By default this field will not be populated by the integration. A default capping method, selected from a list of customer defined capping methods, can be applied to all test results that do have a value recorded. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations.
Fracture Type	CylFractureType value that is entered by the lab technician into the Forney break machine will be used to populate Fracture Type.
Is Cut	By default this field will not be populated by the integration. A default Is Cut can be applied to all test results when retrieving data from Forney. Otherwise, the value will default to "No". This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations.
Tested Date	Test date from Forney will be retrieved and converted to the project's time zone. If a project timezone is not defined the default customer timezone will be used.
Tested By	Forney is unable to return enough data to indicate the MetaField user that conducted the test. The integration will retrieve the initials of the lab technician that is logged into the Forney break machine at the time of the test.

Beams

The "Retrieve Forney Data" button has been added to the Beams>Enter Test Results screen. When the call to Forney is initiated, MetaField will attempt to retrieve break data from Forney for each specimen that appears on the screen. MetaField will populate all data that is present either in the ForneyVault database or through predefined default values in the Administration area.

Integrated Fields

The following fields can be populated via the Retrieve Forney Data action or the scheduled Forney Data pull.

Field	Description
Width 1/2/3 (in)	By default, this field will not be populated by the integration. The existing value will be retained or one will have to be entered manually. Field can be configured to pull value from Forney database. Recommended, if measurements are taken at the time of the break and entered in Forney interface. Default value can be defined to apply to all test results that do not have a Width (MORBreakWidth) measurement available from Forney. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations or in the specimen size definition in Admin.
Depth 1/2/3 (in)	By default this field will not be populated by the integration. The existing value will be retained or one will have to be entered manually. Field can be configured to pull value from Forney database. Recommended, if measurements are taken at the time of the break and entered in Forney interface. Default value can be defined to apply to all test results that do not have a Depth (MORBreakDepth) measurement in Forney. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations or in the specimen size definition in Admin.
Span(in)	By default this field will not be populated by the integration. The existing value will be retained or one will have to be entered manually. Field can be configured to pull value from Forney database. Recommended, if measurements are taken at time of break and entered in Forney interface. Default value can be defined to apply to all test results that do not have a Span (Length1) measurement in Forney. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations or in the specimen size definition in Admin.
Load Strength (lbs)	MaxLoad value recorded by Forney break machine will be used to populate Load Strength.
Location of Failure	The values "0", "1" and "2" are pulled from Forney Vault. The corresponding report values (e.g. Middle, Outer 1/3) can be configured in MetaField Admin.
Testing Method	By default this field will not be populated by the integration. A default Is Method can be applied to all test results when retrieving data from Forney. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations .
Forming Method	By default this field will not be populated by the integration. A default Is Method can be applied to all test results when retrieving data from Forney. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations .
LOF Distance 1/2/3	"MORBreakDistance" value recorded from Forney break machine will be referenced to populate these 3 fields.
Alt. Multiplier	By default this field will not be populated by the integration. A default Is Method can be applied to all test results when retrieving data from Forney. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations .
Wet or Dry	By default this field will not be populated by the integration. A default Is Method can be applied to all test results when retrieving data from Forney. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations .
Tested Date	Test date from Forney will be retrieved and converted to the project's time zone. If a project timezone is not defined the default customer timezone will be used.
Tested By	Forney is unable to return enough data to indicate the MetaField user that conducted the test. The integration will retrieve the initials of the lab technician that is logged into the Forney break machine at the time of the test.

Cubes

The "Retrieve Forney Data" button has been added to the Grout Cubes / Mortar Cubes>Enter Test Results screen. When the call to Forney is initiated, MetaField will attempt to retrieve break data from Forney for each specimen that appears on the screen. MetaField will populate all data that is present either in the ForneyVault database or through predefined default values in the Administration area.

Integrated Fields

The following fields can be populated via the Retrieve Forney Data action or the scheduled Forney Data pull.

Field	Description
Width 1	By default, this field will not be populated by the integration. The existing value will be retained or one will have to be entered manually. Field can be configured to pull value from Forney Database. Recommended, if measurements are taken at the time of break and entered in Forney interface. Default value can be defined to apply to all test results that do not have a Width 1 (Length 1 in Forney) measurement. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations or in the specimen size definition in Admin.
Width 2	By default this field will not be populated by the integration. The existing value will be retained or one will have to be entered manually. Field can be configured to pull value from Forney Database. Recommended, if measurements are taken at the time of break and entered in Forney interface. Default value can be defined to apply to all test results that do not have a Width 2 (Width 1 in Forney) measurement. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations or in the specimen size definition in Admin.
Load Strength (lbs)	MaxLoad value recorded by Forney break machine will be used to populate Load Strength.
Capping Method	By default this field will not be populated by the integration. A default capping method, selected from a list of customer defined capping methods, can be applied to all test results that do have a value recorded. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations.
Is Cut	By default this field will not be populated by the integration. A default Is Cut can be applied to all test results when retrieving data from Forney. Otherwise, the value will default to "No". This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations.
Tested Date	Test date from Forney will be retrieved and converted to the project's time zone. If a project timezone is not defined the default customer timezone will be used.
Tested By	Forney is unable to return enough data to indicate the MetaField user that conducted the test. The integration will retrieve the initials of the lab technician that is logged into the Forney break machine at the time of the test.

Prisms

The "Retrieve From Forney" action is available on grout and mortar prism sample types within the To Test queue in LIMS. When the call to Forney is initiated, MetaField will attempt to retrieve break data from Forney for each specimen that appears on the screen. MetaField will populate all data that is present either in the ForneyVault database or through predefined default values in the Administration area.

Field	Description
Width 1,2,3,4	By default, this field will not be populated by the integration. The existing value will be retained or one will have to be entered manually. Field can be configured to pull value from Forney Database. Recommended, if measurements are taken at the time of break and entered in Forney interface.
Height 1,2,3,4	By default this field will not be populated by the integration. The existing value will be retained or one will have to be entered manually. Field can be configured to pull value from Forney Database. Recommended, if measurements are taken at the time of break and entered in Forney interface.
Load Strength (lbs)	MaxLoad value recorded by Forney break machine will be used to populate Load Strength.
Capping Method	By default this field will not be populated by the integration. A default capping method, selected from a list of customer defined capping methods, can be applied to all test results that do have a value recorded. This field can be configured in Administration>General>Integrations. Documentation can be found at General - Integrations.
Is Cut	By default this field will not be populated by the integration. A default Is Cut can be applied to all test results when retrieving data from Forney. Otherwise, the value will default to "No".
Tested Date	Test date from Forney will be retrieved and converted to the project's time zone. If a project timezone is not defined the default customer timezone will be used.
Tested By	Forney is unable to return enough data to indicate the MetaField user that conducted the test. The integration will retrieve the initials of the lab technician that is logged into the Forney break machine at the time of the test.