Product - Lab Conversion
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 17:01:13.040
Lab InputSelect Lab fieldsY Select Lab fieldsTransform Lab FieldsY Transform Lab FieldsProduct Lab OutputY
Lab Input
XBaseInput
Y
1
none
F:\VETAID\LABTEST.DBF
0
N
N
N
91
113
Y
Product Lab Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsPRODUCTIDNAME<product.service>namefalsefalseACTIVE<product.service>activefalsefalseTESTCOST<product.service>prices[0]<productPrice.unitPrice>pricetruefalsetruetrue1000
554
112
Y
Select Lab fields
SelectValues
Y
1
none
TESTNO
-2
-2
TESTGROUP
-2
-2
TESTITEM
-2
-2
TESTCOST
-2
-2
DEACTIVATE
-2
-2
TESTNO
PRODUCTID
String
20
0
TESTGROUP
-
25
-2
TESTITEM
-
30
-2
TESTCOST
-
6
2
219
113
Y
Transform Lab Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var wordUtils = Packages.org.apache.commons.lang.WordUtils;
// Transform ProductID
PRODUCTID.setString("LAB" + PRODUCTID.getString())
//Transform name
var NAME = TESTGROUP.getString() + " - " + TESTITEM.getString()
var ACTIVE = !DEACTIVATE.getBool()
NAME
NAME
String
-1
-1
ACTIVE
ACTIVE
Boolean
-1
-1
377
114
Y