Customer - Information
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 10:47:14.000
Quickvet
MSACCESS
ODBC
Quickvet
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER-1
STREAM_RESULTSY
USE_POOLINGN
Select FieldsTransform FieldsY Transform FieldsCustomer OutputY Table inputSelect FieldsY
Customer Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsIDTITLE<party.customerperson>titlefalsetrueFIRSTNAME<party.customerperson>firstNamefalsetrueLASTNAME<party.customerperson>lastNamefalsetrueACTIVE<party.customerperson>activefalsetrueHOMEPHONE<party.customerperson>contacts[0]<contact.phoneNumber>telephoneNumbertruetrueHOMEPHONE<party.customerperson>contacts[0]<contact.phoneNumber>purposes[0]true<lookup.contactPurpose>code=HOMEtrueWORKPHONE<party.customerperson>contacts[1]<contact.phoneNumber>telephoneNumbertruetrueWORKPHONE<party.customerperson>contacts[1]<contact.phoneNumber>purposes[0]true<lookup.contactPurpose>code=WORKtrueOTHERPHONE<party.customerperson>contacts[4]<contact.phoneNumber>telephoneNumbertruetrueADDRESS<party.customerperson>contacts[3]<contact.location>addresstruetrueSUBURB<party.customerperson>contacts[3]<contact.location>suburbtruetrueSTATE<party.customerperson>contacts[3]<contact.location>statetruetruePOSTCODE<party.customerperson>contacts[3]<contact.location>postcodetruetrueTYPE<party.customerperson>type[0]true<lookup.customerAccountType>$valuefalsetruetrue1000
463
146
Y
Select Fields
SelectValues
Y
1
none
AccountNumber
ID
-2
-2
Title
TITLE
-2
-2
LastName
LASTNAME
-2
-2
FirstName
FIRSTNAME
-2
-2
Address
ADDRESS1
-2
-2
Address2
ADDRESS2
-2
-2
City
SUBURB
-2
-2
State
STATE
-2
-2
Zip
POSTCODE
-2
-2
Home Phone
HOMEPHONE
-2
-2
Work Phone
WORKPHONE
-2
-2
Bad Risk
BADDEBT
-2
-2
Other Work Phone
OTHERPHONE
-2
-2
E-Mail
EMAIL
-2
-2
Status
STATUS
-2
-2
Address3
ADDRESS3
-2
-2
Address4
ADDRESS4
-2
-2
191
147
Y
Table input
TableInput
Y
1
none
Quickvet
select * from clientwn
0
N
N
87
147
Y
Transform Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var wordUtils = Packages.org.apache.commons.lang.WordUtils;
var ovpmsfuncs = Packages.org.openvpms.etl.ETLHelper
// Transform Name information
FIRSTNAME.setString(wordUtils.capitalizeFully(trim(FIRSTNAME.getString())))
LASTNAME.setString(wordUtils.capitalizeFully(trim(LASTNAME.getString())))
if (LASTNAME.getString() == "") {
LASTNAME.setString("No LastName")
}
TITLE.setString(trim(TITLE.getString()))
// Transform Address information
ADDRESS1.setString(wordUtils.capitalizeFully(trim(ADDRESS1.getString())))
ADDRESS2.setString(wordUtils.capitalizeFully(trim(ADDRESS2.getString())))
ADDRESS3.setString(wordUtils.capitalizeFully(trim(ADDRESS3.getString())))
ADDRESS4.setString(wordUtils.capitalizeFully(trim(ADDRESS4.getString())))
SUBURB.setString(wordUtils.capitalizeFully(trim(SUBURB.getString())))
STATE.setString(wordUtils.capitalize(trim(STATE.getString())))
POSTCODE.setString(trim(POSTCODE.getString()))
var ADDRESS = ""
if (ADDRESS1.getString() != null && ADDRESS1.getString() != "") {
ADDRESS = ADDRESS1.getString()
}
if (ADDRESS2.getString() != null && ADDRESS2.getString() != "") {
ADDRESS = ADDRESS + "\n" + ADDRESS2.getString()
}
if (ADDRESS3.getString() != null && ADDRESS3.getString() != "") {
ADDRESS = ADDRESS + "\n" + ADDRESS3.getString()
}
if (ADDRESS4.getString() != null && ADDRESS4.getString() != "") {
ADDRESS = ADDRESS + "\n" + ADDRESS4.getString()
}
// Transform Phone Information
HOMEPHONE.setString(trim(HOMEPHONE.getString()))
WORKPHONE.setString(trim(WORKPHONE.getString()))
OTHERPHONE.setString(trim(OTHERPHONE.getString()))
if (OTHERPHONE.getString() == null || OTHERPHONE.getString() == "") {
OTHERPHONE.setString(null)
}
//Transform Client Type
var TYPE
if (BADDEBT.getString() == "Y")
TYPE = "BAD_DEBT"
else
TYPE = "NORMAL"
//Reverse DEACTIVATE flag to make active flag
var ACTIVE
if (STATUS.getString() == "Inactive")
ACTIVE = false
else
ACTIVE = true
ADDRESS
ADDRESS
String
-1
-1
TYPE
TYPE
String
-1
-1
ACTIVE
ACTIVE
Boolean
-1
-1
322
148
Y