Patient - Information
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 10:47:10.000
Text file inputSelect FieldsY Select FieldsFilter rowsY Transform FieldsPatient OutputY Filter rowsTransform FieldsY Filter rowsDummy (do nothing)Y
Dummy (do nothing)
Dummy
Y
1
none
293
243
Y
Filter rows
FilterRows
Y
1
none
Transform Fields
Dummy (do nothing)
N
N
PATIENTID
<>
constantNumber0.0-1-1N
N
AND
PATIENTID
IS NOT NULL
296
145
Y
Patient Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsPATIENTID<party.patientpet>namefalsefalse<party.patientpet>speciesfalsefalse<party.patientpet>breedfalsefalse<party.patientpet>colourfalsefalse<party.patientpet>dateOfBirthtruefalse<party.patientpet>sexfalsefalse<party.patientpet>desexedfalsefalse<party.patientpet>deceasedfalsefalse<party.patientpet>activefalsefalse<party.patientpet>identities[0]<entityIdentity.petTag>petTagtruefalse<party.patientpet>identities[1]<entityIdentity.microchip>microchiptruefalsetruetrue1000
530
145
Y
Select Fields
SelectValues
Y
1
none
PATIENTID
-2
-2
CLIENTID
-2
-2
ACCOUNTID
-2
-2
NAME
-2
-2
SPECIES
-2
-2
BREED
-2
-2
COLOUR
-2
-2
SEX
-2
-2
DOB
-2
-2
NOTES
-2
-2
DESEXED
-2
-2
INACTIVE
-2
-2
DECEASED
-2
-2
TAG
-2
-2
MICROCHIP
-2
-2
185
145
Y
Text file input
TextFileInput
Y
1
none
N
,
"
N
1
1
N
1
N
80
0
Y
N
N
N
DOS
${NETVET_DATA}\patient.txt
CSV
None
PATIENTID
Integer
$
.
,
-
-1
2
0
none
N
CLIENTID
Integer
$
.
,
-
-1
2
0
none
N
ACCOUNTID
Integer
$
.
,
-
-1
2
0
none
N
NAME
String
-
-1
30
-1
none
N
SPECIES
String
-
-1
15
-1
none
N
BREED
String
-
-1
30
-1
none
N
COLOUR
String
-
-1
30
-1
none
N
SEX
String
-
-1
10
-1
none
N
DOB
Date
dd/MM/yyyy
-1
10
-1
both
N
NOTES
String
-
-1
50
-1
none
N
DESEXED
String
-
-1
5
-1
none
N
INACTIVE
String
-
-1
5
-1
none
N
DECEASED
String
-
-1
5
-1
none
N
TAG
Integer
$
.
,
-
-1
30
0
none
N
MICROCHIP
String
$
.
,
-
-1
30
0
none
N
0
Y
N
warning
error
line
Y
en_au
60
146
Y
Transform Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var wordUtils = Packages.org.apache.commons.lang.WordUtils;
// Transform Name information
NAME.setString(wordUtils.capitalizeFully(trim(NAME.getString())))
if (NAME.getString() == "") {
NAME.setString("No Name")
}
SPECIES.setString(wordUtils.capitalizeFully(trim(SPECIES.getString())))
if (SPECIES.getString() == "" || SPECIES.getString() == null) {
SPECIES.setString("Other")
}
BREED.setString(wordUtils.capitalizeFully(trim(BREED.getString())))
COLOUR.setString(wordUtils.capitalizeFully(trim(COLOUR.getString())))
// Transform Sex
if (SEX.getString() == "UNKNOWN")
SEX.setString("UNSPECIFIED")
var DESEXFLAG = false
if (DESEXED.getString() == "TRUE")
DESEXFLAG = true
var DECEASEDFLAG = false
if (DECEASED.getString() == "TRUE")
DECEASEDFLAG = true
var ACTIVE = true
if (INACTIVE.getString() == "TRUE")
ACTIVE = false
//if(DOB.getString() == null || DOB.getString() == "")
//DOB.setString("01/01/1980")
DESEXFLAG
DESEXFLAG
Boolean
-1
-1
DECEASEDFLAG
DECEASEDFLAG
Boolean
-1
-1
ACTIVE
ACTIVE
Boolean
-1
-1
396
146
Y