Customer - Information
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 10:47:14.000
Client InputSelect FieldsY Select FieldsTransform FieldsY Transform FieldsCustomer OutputY
Client Input
XBaseInput
Y
1
none
${VETAID_DATA}/CLIENT.DBF
0
N
N
N
65
149
Y
Customer Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsCLNUMBERCLTITLE<party.customerperson>titlefalsetrueCLINITS<party.customerperson>initialsfalsetrueCLFSTNAME<party.customerperson>firstNamefalsetrueCLSURNAME<party.customerperson>lastNamefalsetrueACTIVE<party.customerperson>activefalsetrueCLPHONENUM<party.customerperson>contacts[0]<contact.phoneNumber>telephoneNumbertruetrueCLPHONEAREA<party.customerperson>contacts[0]<contact.phoneNumber>areaCodetruetrueCLPHONENUM<party.customerperson>contacts[0]<contact.phoneNumber>purposes[0]true<lookup.contactPurpose>code=HOMEtrueWKPHONENUM<party.customerperson>contacts[1]<contact.phoneNumber>telephoneNumbertruetrueWKPHONEAREA<party.customerperson>contacts[1]<contact.phoneNumber>areaCodetruetrueWKPHONENUM<party.customerperson>contacts[1]<contact.phoneNumber>purposes[0]true<lookup.contactPurpose>code=WORKtrueCLADDRESS<party.customerperson>contacts[3]<contact.location>addresstruetrueCLSUBURB<party.customerperson>contacts[3]<contact.location>suburbtruetrueCLSTATE<party.customerperson>contacts[3]<contact.location>statetruetrueCLPOSTCODE<party.customerperson>contacts[3]<contact.location>postcodetruetrueFAXPHONEAREA<party.customerperson>contacts[4]<contact.faxNumber>areaCodetruetrueFAXPHONENUM<party.customerperson>contacts[4]<contact.faxNumber>faxNumbertrue<lookup.contactPurpose>code=WORKtruetruetrue1000
466
147
Y
Select Fields
SelectValues
Y
1
none
CLNUMBER
-2
-2
CLTITLE
-2
-2
CLINITS
-2
-2
CLFSTNAME
-2
-2
CLSURNAME
-2
-2
DEACTIVATE
-2
-2
CLCOMPANY
-2
-2
CLPHONE
-2
-2
WKPHONE
-2
-2
FAX
-2
-2
CLADDRESS1
-2
-2
CLADDRESS2
-2
-2
CLSUBURB
-2
-2
CLSTATE
-2
-2
CLPOSTCODE
-2
-2
CLTYPE
-2
-2
BADDEBT
-2
-2
191
148
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
CLFSTNAME.setString(wordUtils.capitalizeFully(trim(CLFSTNAME.getString())))
CLSURNAME.setString(wordUtils.capitalizeFully(trim(CLSURNAME.getString())))
if (CLSURNAME.getString() == "") {
CLSURNAME.setString("No LastName")
}
CLTITLE.setString(trim(CLTITLE.getString()))
CLINITS.setString(trim(CLINITS.getString()))
// Transform Address information
CLADDRESS1.setString(wordUtils.capitalizeFully(trim(CLADDRESS1.getString())))
CLADDRESS2.setString(wordUtils.capitalizeFully(trim(CLADDRESS2.getString())))
CLSUBURB.setString(wordUtils.capitalizeFully(trim(CLSUBURB.getString())))
CLSTATE.setString(wordUtils.capitalize(trim(CLSTATE.getString())))
CLPOSTCODE.setString(trim(CLPOSTCODE.getString()))
var CLADDRESS = CLADDRESS1.getString() + " " + CLADDRESS2.getString()
// Transform Phone Information
CLPHONE.setString(trim(CLPHONE.getString()))
WKPHONE.setString(trim(WKPHONE.getString()))
FAX.setString(trim(FAX.getString()))
var CLPHONENUM
var WKPHONENUM
var FAXPHONENUM
var CLPHONEAREA
var WKPHONEAREA
var FAXPHONEAREA
try {
if (substr(CLPHONE.getString(),0,1) == "(") {
CLPHONENUM = trim(substr(CLPHONE.getString(),5))
if (CLPHONENUM == "")
CLPHONEAREA = ""
else
CLPHONEAREA = trim(substr(CLPHONE.getString(),1,4))
}
else {
CLPHONENUM = CLPHONE.getString()
CLPHONEAREA = ""
}
}
catch (e) {
CLPHONENUM = CLPHONE.getString()
CLPHONEAREA = ""
}
try {
if (substr(WKPHONE.getString(),0,1) == "(") {
WKPHONENUM = trim(substr(WKPHONE.getString(),5))
if (WKPHONENUM == "")
WKPHONEAREA = ""
else
WKPHONEAREA = trim(substr(WKPHONE.getString(),1,4))
}
else {
WKPHONENUM = WKPHONE.getString()
WKPHONEAREA = ""
}
}
catch (e) {
WKPHONENUM = WKPHONE.getString()
WKPHONEAREA = ""
}
if (FAX.getString() == null || FAX.getString() == "") {
FAXPHONENUM = null
FAXPHONEAREA = null
}
else {
try {
if (substr(FAX.getString(),0,1) == "(") {
FAXPHONENUM = trim(substr(FAX.getString(),5))
if (FAXPHONENUM == "")
FAXPHONEAREA = ""
else
FAXPHONEAREA = trim(substr(WKPHONE.getString(),1,4))
}
else {
FAXPHONENUM = FAX.getString()
FAXPHONEAREA = ""
}
}
catch (e) {
FAXPHONENUM = FAX.getString()
FAXPHONEAREA = ""
}
}
//Transform Client Type
CLTYPE.setString(upper(trim(CLTYPE.getString())))
//Reverse DEACTIVATE flag to make active flag
var ACTIVE = !DEACTIVATE.getBool()
CLADDRESS
CLADDRESS
String
255
-1
CLPHONEAREA
CLPHONEAREA
String
-1
-1
CLPHONENUM
CLPHONENUM
String
-1
-1
WKPHONEAREA
WKPHONEAREA
String
-1
-1
WKPHONENUM
WKPHONENUM
String
-1
-1
FAXPHONENUM
FAXPHONENUM
String
-1
-1
FAXPHONEAREA
FAXPHONEAREA
String
-1
-1
ACTIVE
ACTIVE
Boolean
-1
-1
321
148
Y