Exporting File-Based Job Data

The Remote Sampler data adaptor service can be configured to extract job data for completed jobs from the web API and write the output to XML files that can be easily parsed for import into other third party data-systems. This allows data captured with Remote Sampler to be quickly imported into other systems for which dedicated integration is not yet supported.

An XSD schema file for this XML format is available here: JobGroupForExport.xsd

The data exported from Remote Sampler is written to XML files in the format described below.

Example Job Data Export Formatting

<?xml version="1.0" encoding="utf-8"?>
<JobGroupForExport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <JobGroupName />
  <Jobs>
    <JobForExport>
      <UniqueJobKey>1499103(v2)</UniqueJobKey>
      <JobName>1499103</JobName>
      <JobId>1499103</JobId>
      <JobParts>
        <JobPartForExport>
          <JobPartName>1499103</JobPartName>
          <JobPartId>1499103(v2)</JobPartId>
          <JobPartDescription>1499103</JobPartDescription>
          <CollectionDate>2017-10-20T13:43:43.57</CollectionDate>
          <CollectedByUserName>SAMG</CollectedByUserName>
          <CompletionStatus>Success</CompletionStatus>
          <StatusMessage>Job part completed successfully</StatusMessage>
          <TargetCollectionLocation>
            <DisplayText>DOHLRES2</DisplayText>
            <Latitude>52.123</Latitude>
            <Longitude>-1.765</Longitude>
            <GridEast>0</GridEast>
            <GridNorth>0</GridNorth>
            <BuildingName />
            <BuildingNumber />
            <Street />
            <City />
            <Zip />
            <Zone />
            <ReferenceNumber />
          </TargetCollectionLocation>
          <ActualCollectionLocation>
            <DisplayText>DOHLRES2</DisplayText>
            <Latitude>52.123</Latitude>
            <Longitude>-1.765</Longitude>
            <GridEast>0</GridEast>
            <GridNorth>0</GridNorth>
            <BuildingName />
            <BuildingNumber />
            <Street />
            <City />
            <Zip />
            <Zone />
            <ReferenceNumber />
          </ActualCollectionLocation>
          <DataFields>
            <DataFieldForExport>
              <DisplayText>Free Chlorine Value</DisplayText>
              <FieldName>chlorine (free) (on-site)|CL2_F_WY</FieldName>
              <DataType />
              <EntryTime>2017-10-20T13:43:43.57</EntryTime>
              <ValueWasEntered>false</ValueWasEntered>
              <FieldId>10654291</FieldId>
              <RawValue>0.45</RawValue>
              <ReportableValue>0.45</ReportableValue>
              <WasRequestedOnImport>true</WasRequestedOnImport>
            </DataFieldForExport>
            <DataFieldForExport>
              <DisplayText>Total Chlorine Value</DisplayText>
              <FieldName>chlorine (total) (on-site)|CL2_T_WY</FieldName>
              <DataType />
              <EntryTime>2017-10-20T13:43:43.57</EntryTime>
              <ValueWasEntered>true</ValueWasEntered>
              <FieldId>10654292</FieldId>
              <RawValue>0.67</RawValue>
              <ReportableValue>0.67</ReportableValue>
              <WasRequestedOnImport>true</WasRequestedOnImport>
            </DataFieldForExport>
            <DataFieldForExport>
              <DisplayText>Temperature Reading</DisplayText>
              <FieldName>temperature|TEMP_WY</FieldName>
              <DataType />
              <EntryTime>2017-10-20T13:43:43.57</EntryTime>
              <ValueWasEntered>true</ValueWasEntered>
              <FieldId>10654300</FieldId>
              <RawValue>9.8</RawValue>
              <ReportableValue>9.8</ReportableValue>
              <WasRequestedOnImport>true</WasRequestedOnImport>
            </DataFieldForExport>
          </DataFields>
          <CollectedItems>
            <CollectedItemForExport>
              <ItemId>3355730</ItemId>
              <DisplayText>350ml Plastic, Blue cap. Pre-sterilised & pre-dosed with sodium thiosulphate.</DisplayText>
              <ItemType>YBN</ItemType>
              <WasCollected>true</WasCollected>
              <FailedCollectionReason />
              <CollectionTime>2017-10-20T13:43:35.543</CollectionTime>
              <Latitude>52.123</Latitude>
              <Longitude>-1.765</Longitude>
            </CollectedItemForExport>
          </CollectedItems>
          <UserComments>
            <UserCommentForExport>
              <UserCommentText>A comment entered by the user</UserCommentText>
              <CommentReason>Not all required daily and weekly checks have been completed</CommentReason>
              <CommentTime>10/20/2017 1:43:04 PM</CommentTime>
              <WasMandatory>true</WasMandatory>
            </UserCommentForExport>
          </UserComments>
          <UserImages />
          <Attributes />
        </JobPartForExport>
      </JobParts>
    </JobForExport>
  </Jobs>
  <UniqueKey>55115bac-a6a8-4432-b19a-d92d9a7314b7</UniqueKey>
</JobGroupForExport>