Francais Francais English English

SEND DELIVERY NOTES

3 functions are required to complete the transaction :

Delivery notes contain construction site information, production details, and weighing records.

Usage Example

WINDEV / WEBDEV

SI EXIM_connect("user","password","IDPeer") = Faux ALORS
        Info("Connection failed")
        RETOUR
FIN

nNbrBL est un entier
listeBL est un EXIM_concreteDN

nNbrBL = DN_howManyToUpLoad()

SI nNbrBL <> 0 ALORS
        listeBL <= DN_getListToUpload()

        POUR i = 1 _À_ TableauOccurrence(listeBL.DNs)
                // Providing all elements of the delivery note
                // ...

        FIN

        DN_uploadList(listeBL)
FIN

Visual studio .net

Dim automapiClient As New automapiSOAPPortTypeClient
Dim EXIM_concreteDN As tEXIM_concreteDN

Dim nbBl As Integer

Dim SID As Byte()

ReDim SID(20)

automapiClient.Open()

If automapiClient.EXIM_connect(SID, "user", "password", "IDPeer") Then

    nbBl = automapiClient.DN_howManyToUpLoad(SID)

    If nbBl <> 0 Then
        EXIM_concreteDN = automapiClient.DN_getListToUpload(SID)

        If EXIM_concreteDN Is Nothing Then
            Return
        End If

        ...

    End If

End If

Structure of Exchanged Data

EXIM_concreteDN

DNs is array of EXIM_concreteDNDescription
batchLocation is array of strings               <- List of material locations during weighing
                                                hopper_01 -> 20  Trémie 1 à 20
                                                pump_01 -> 20 Pompe 1 à 20
                                                silo_01 -> 20 Silo 1 à 20

EXIM_concreteDNDescription

In BRG-LAB, construction sites can be organized in different ways :

  • Project -> Construction Site -> Part of Construction Site

  • Construction Site -> Part of Construction Site

  • Construction Site

At a minimum, the construction site must be specified.

                                                (Information Transmitted by BRG-LAB)
DNnumber is string                                                      -> N° du BL
manufactureDateHour is DateTime                         -> Manufacturing Date and Time
attempt is int                                                          -> Number of Import Attempts (if an error occurred during the previous import)
errorMessageFromLastAttempt is string           -> Error Message from Last Import Attempt
automatom is string                                             -> Controller

                                                All other fields below must be filled in

plantCode is string                             -> Plant Code
formulaCode is string                           -> Formula Code
formulaRecipe is string                         -> Recipe Code
formulaNumber is string                         -> Formula Number (plantCode + separator + formulaCode + recipeCode) as displayed in the controller

ConstructionSite is EXIM_concreteDNConstructionSite     -> Construction Site

// Production
formulaDesignation is strings                   -> Commercial Designation of the Formula
volumeProduced is real                                  -> Volume Produced
// Transport
typeOfTransport is string                               -> (Optional) Vehicle Type
registrationOfTheCarrier is string              -> (Optional) Vehicle Registration

// Mixer informations                           (Optional Section Regarding Manufacturing)
mixerStartOfEmptying is DateTime                -> Date and Time of Mixer Discharge Start
mixerSendOfEmptying is DateTime                 -> Date and Time of Mixer Discharge End

// delevery information                         (Optional Section Regarding Concrete Delivery)
deleveryStartOfEmptying is DateTime                                             -> Date and Time of Concrete Truck Discharge Start
deleverySendOfEmptying is DateTime                                                      -> Date and Time of Concrete Truck Discharge End
deleveryAdditionOfWater is string                                                       -> Addition of Water on Site
deleveryManualAddition is array of EXIM_concreteDNDosage        -> Products Manually Added to the Truck on Site

airTemperature is real                          -> Air Temperature (if provided)
airHygrometry is real                           -> Air Humidity (if provided)
concreteTemperature is real                     -> Concrete Temperature (if provided)
windSpeed is real                                       -> Air Speed (if provided)
cureProduct is string                           -> Curing Product

// fields for specific automaton
automatonCode0 is string
automatonCode1 is string
automatonCode2 is string
automatonCode3 is string
automatonCode4 is string
automatonCode5 is string
automatonCode6 is string
automatonCode7 is string
automatonCode8 is string
automatonCode9 is string

// Weighing control                             (Optional Section for Weighing Ticket Transfer)
// Nominal dosage of formula
nominalFormulaEfficientWater is real                            -> Effective Water
nominalFormulaTotalWater is real                                        -> Total Water (optional)
nominalFormulaEquivalentBinder is real                          -> Equivalent Binder
nominalFormulaTotalWeight is real                                       -> Total Weight of the Formula (optional)
nominalFormula is array of EXIM_concreteDNDosage        -> Nominal Formula (per cubic meter)
batchs is array of EXIM_concreteDNBatch                         -> Weights

// Reserved for CBAO, do not fill in
Automatom       is string
waterMode       is string

EXIM_concreteDNConstructionSite

// Construction informations                            -> Construction Site Information
businessSite is string                                          -> (Optional) Project Designation
internal_ID_businessSite is int                         -> (Optional) Project ID from your database (allows for maintaining the link and potentially modifying designations)
constructionSite is string                                      -> Construction Site
internal_ID_constructionSite is string          -> Site ID from your database (allows for maintaining the link and potentially modifying designations)
partOfConstruction is string                            -> (Optional) Designation of the Part of the Construction Site
internal_ID_partOfConstruction is string        -> (Optional) ID of the Part of the Construction Site from your database (allows for maintaining the link and potentially modifying designations in BRG-LAB)
projectManager is string                                -> (Optional) Project Manager
internal_ID_projectManager is string    -> (Optional) ID of the Project Manager from your database (allows for maintaining the link and potentially modifying designations)
projectOwner is string                                  -> (Optional) Project Owner
internal_ID_projectOwner is string              -> (Optional) ID of the Project Owner from your database (allows for maintaining the link and potentially modifying designations)
customer is string                                              -> Client
internal_ID_customer is string                  -> Client ID from your database (allows for maintaining the link and potentially modifying designations)

// Delivery informations                        (Optional Section Regarding Delivery on Site)
Country                                                 -> Country according to the Alpha-3 ISO coding (https://fr.wikipedia.org/wiki/ISO_3166-1)
City is string                                  -> City
ZipCode is string                               -> Postal Code
Direction is string                     -> Construction Site Address
GPS_lat is real                                 -> GPS Coordinates Latitude (decimal degrees)
GPS_long is real                                -> GPS Coordinates Longitude (decimal degrees)

// fields for specific automaton
automatonCode0 is string
automatonCode1 is string
automatonCode2 is string
automatonCode3 is string
automatonCode4 is string
automatonCode5 is string
automatonCode6 is string
automatonCode7 is string
automatonCode8 is string

EXIM_concreteDNDosage

productCode is string                   -> Product code (the product code must be identical between the automation system and BRG-LAB in order to establish the connection).
designation is string                   -> Product designation
productType is string                   -> Material type ["AGGREGATE","CEMENT","ADDITIVE","ADMIXTURE","SPECIAL","WATER"]
Dosage is real                                  -> Dosage
dosageUnity is string                   -> Dosage unit ["Kg","l","%","DOSE"]
aggregateAbsorption is real     -> Absorption coefficient
admixtureDryExtract is real             -> % Dry extract of additives
density is real                                 -> Density (primarily for water)
additiveK is real                               -> K ratio of the addition
modificationDate is DateTime    -> Date of modification by the user (if known)

// fields for specific automaton
automatonCode0 is string
automatonCode1 is string
automatonCode2 is string
automatonCode3 is string
automatonCode4 is string

EXIM_dosage

productCode is string           -> Product Code (the product code must be identical between the controller and BRG-LAB to establish the link)
Dosage is real                          -> Dosage
dosageUnity is string           -> Dosage Unit ["Kg", "l", "%"]

EXIM_concreteDNBatch

batchNumber is real                                                             -> Batch Number
batchVolume is real                                                             -> concrete batch volume
mixerWattmeterBeforeEmptying is real                            -> Wattmeter Value at the End of Mixing Cycle (just before discharge)
mixerWaterContent is real                                                       -> Water Content Probe Value of the Concrete at the End of Mixing
mixerManualAddition is array of EXIM_dosage             -> Products Manually Added to the Mixer
mixerManualWaterCorrection is real                                      -> Water Correction Provided by the Central Operator
mixingTime is real                                                                      -> Mixing Duration in Seconds
mixingHour is hour                                                                      -> Mixing Time

// fields for specific automaton
automatonCode0 is string
automatonCode1 is string
automatonCode2 is string
automatonCode3 is string
automatonCode4 is string

batchDetails is array of EXIM_concreteDNBatchDetail

EXIM_concreteDNBatchDetail

productCode is string           -> Product Code (the product code must be identical between the controller and BRG-LAB to establish the link)
weighingOrderDry is real        -> Nominal Weighing Order (excluding water)
weighingOrderWet is real        -> Sent Weighing Order (including water)
weighingExecuted is real        -> Weighing Executed (measured)
weighingError is real           -> Weighing error (en %)
waterContent is real            -> Water content (%)
dosageUnity is string           -> Dosage Unit ["Kg", "l", "%"]
location is string                      -> (To see batchLocation)
aggregateAbsorption     is real -> Absorption coefficient (%) if not specified in the nominal formulation.
admixtureDryExtract     is real -> Dry extract of additives (%) if not specified in the nominal formulation

// fields for specific automaton
automatonCode0 is string
automatonCode1 is string
automatonCode2 is string
automatonCode3 is string
automatonCode4 is string>>>>>>> .r316