processxmlrequest

Processes a series of commands formed as a XML request, this allows to replace and/or update the routes for an item using a single XML document

 

Properties in XML Structure:

 

Property

Columnname in Table

Description

parentitemcode

itemcode

Item Code

position

pos_id

position id

operation

ag_id

link to beas_ag

workcenter

aplatz_id

link to beas_aplatz

description

bez

description2

anweisung

kstst_id

kstst_id

activ

aktivformel

activ formular
"" = activ
N= deactivated
G=x    if amount > x
K=x    if amount < x
Z=x=y if amount between x and y

zeitaufnkz

zeitaufndkz

zeitaufndat

zeitaufndat

setupforcalculator

traplatz

setupforsched

tr2aplatz

maschinetime

thaplatz

labortime

tnaplatz

maschinelabortime

teaplatz

use

nutzen

number

anzahl

idletime

tl

wagegroup

lohngruppe

shareableresource

mehrmasch_bed

timesper

menge_je

timesin

menge_zeitje

1 (minute) or 60 (hours)

clockmandantory

bde

y/n

maschinegrouping

mehrmaschinenbelegung

y/n

picture1 ... 3

bild1 ...3

3 Pictures

inspectionplanqc

qs_id

cardcode

cardcode

 

hmtoggle_plus1Example 1 for: processxmlrequest replace an entire Routing Group:

 

declare=bom=ue_api_routing

 

setvar=xmlbuffer=<routegroup>&

<command>replace</command>&

<item>&

<parentitemcode>_CEDRENEA</parentitemcode>&

<route>&

 <position>10</position>&

 <operation>CORTE</operation>&

 <workcenter>Soldar</workcenter>&

 <routingdescription>CORTE</routingdescription>&

 <activ></activ>&

 <setupforcalculator>0.000000</setupforcalculator>&

 <setupforsched>0.000000</setupforsched>&

 <maschinetime>0.000000</maschinetime>&

 <labortime>0.000000</labortime>&

 <maschinelabortime>30.000000</maschinelabortime>&

 <use>1</use>&

</route>&

<route>&

 <position>20</position>&

 <operation>DECA</operation>&

 <workcenter>Soldar</workcenter>&

 <routingdescription>DECA</routingdescription>&

 <activ></activ>&

 <setupforcalculator>0.000000</setupforcalculator>&

 <setupforsched>0.000000</setupforsched>&

 <maschinetime>0.000000</maschinetime>&

 <labortime>0.000000</labortime>&

 <maschinelabortime>30.000000</maschinelabortime>&

 <use>1</use>&

</route>&

<route>&

 <position>30</position>&

 <operation>Soldar</operation>&

 <workcenter>Soldar</workcenter>&

 <routingdescription>Soldadura</routingdescription>&

 <activ></activ>&

 <setupforcalculator>0.000000</setupforcalculator>&

 <setupforsched>0.000000</setupforsched>&

 <maschinetime>0.000000</maschinetime>&

 <labortime>0.000000</labortime>&

 <maschinelabortime>30.000000</maschinelabortime>&

 <use>1</use>&

</route>&

<commit>true</commit>&

</item>&

</routegroup>

 

bom=processxmlrequest=<xmlbuffer>

 

 

hmtoggle_plus1Example 2 for: processxmlrequest update route entries, each <route> entry acts as an UPSERT, if the entry exists it updates it, if it does not exists it creates it

 

declare=bom=ue_api_routing

 

setvar=xmlbuffer=<routegroup>&

<command>update</command>&

<item>&

<parentitemcode>_CEDRENEA</parentitemcode>&

<route>&

 <position>10</position>&

 <operation>CORTE</operation>&

 <workcenter>Soldar</workcenter>&

 <routingdescription>CORTE</routingdescription>&

 <activ></activ>&

 <setupforcalculator>0.000000</setupforcalculator>&

 <setupforsched>0.000000</setupforsched>&

 <maschinetime>0.000000</maschinetime>&

 <labortime>0.000000</labortime>&

 <maschinelabortime>30.000000</maschinelabortime>&

 <use>1</use>&

 <commit>true</commit>&

</route>&

<route>&

 <position>25</position>&

 <operation>DECA</operation>&

 <workcenter>Soldar</workcenter>&

 <routingdescription>DECA</routingdescription>&

 <activ></activ>&

 <setupforcalculator>0.000000</setupforcalculator>&

 <setupforsched>0.000000</setupforsched>&

 <maschinetime>0.000000</maschinetime>&

 <labortime>0.000000</labortime>&

 <maschinelabortime>30.000000</maschinelabortime>&

 <use>1</use>&

 <commit>true</commit>&

</route>&

<route>&

 <position>30</position>&

 <operation>BURN-IN</operation>&

 <workcenter>BURN-IN</workcenter>&

 <routingdescription>BURN-INNN000101</routingdescription>&

 <activ></activ>&

 <setupforcalculator>0.000000</setupforcalculator>&

 <setupforsched>0.000000</setupforsched>&

 <maschinetime>0.000000</maschinetime>&

 <labortime>0.000000</labortime>&

 <maschinelabortime>30.000000</maschinelabortime>&

 <use>1</use>&

 <commit>true</commit>&

</route>&

</item>&

</routegroup>

 

bom=processxmlrequest=<xmlbuffer>