/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
-
2007/05/29 10:46:03.315
Reminder InputSelect valuesY Add sequenceReminder OutputY Select valuesTransform ValuesY Transform ValuesAdd sequenceY
Reminder Input
TextFileInput
Y
1
none
N
,
"
N
1
1
N
1
N
80
0
Y
N
N
N
DOS
${NETVET_DATA}\reminder.txt
CSV
None
PATIENTID
Integer
$
.
,
-
-1
6
0
none
N
REMINDER
String
-
-1
15
-1
none
N
DATE
Date
dd/MM/yyyy
$
.
,
-
-1
10
-1
none
N
DUE
Date
dd/MM/yyyy
$
.
,
-
-1
10
-1
none
N
0
N
N
warning
error
line
Y
en_au
150
129
Y
Add sequence
Sequence
Y
1
none
REMINDERNO
N
SEQ_
Y
1
1
9999999
576
131
Y
Reminder Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsREMINDERNOREMTYPE<act.patientReminder>reminderType[0]<participation.reminderType>entitytrue<entity.reminderType>$valuefalseREMINDERNO<act.patientReminder>reminderType[0]<participation.reminderType>acttrue<act.patientReminder>$valuefalsePATIENTID<act.patientReminder>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseREMINDERNO<act.patientReminder>patient[0]<participation.patient>acttrue<act.patientReminder>$valuefalseREMINDER<act.patientReminder>product[0]<participation.product>entitytrue<product.*>$valuefalseREMINDERNO<act.patientReminder>product[0]<participation.product>acttrue<act.patientReminder>$valuefalseDATE<act.patientReminder>startTimetruefalseDUE<act.patientReminder>endTimetruefalseSTATUS<act.patientReminder>statustruefalsefalsetrue1000
690
131
Y
Select values
SelectValues
Y
1
none
PATIENTID
-2
-2
REMINDER
-2
-2
DATE
-2
-2
DUE
-2
-2
296
129
Y
Transform Values
ScriptValueMod
Y
1
none
0
Script 1
//Script here
REMINDER.setString(replace(upper(REMINDER.getString())," ",'_'))
var now = new Date();
var STATUS = "IN_PROGRESS"
if (dateDiff(DUE.getDate(),now,"m") > 24)
STATUS = "CANCELLED"
// Transform into reminder types
var REMCODE = REMINDER.getString()
if (substr(REMCODE,0,4) == "VACC" && REMCODE != "VACCALI") {
var REMTYPE = "CANINE"
}
else if (substr(REMCODE,0,4) == "VACF") {
var REMTYPE = "FELINE"
}
else if (REMCODE == "CARTIN") {
var REMTYPE = "CARTROPHEN"
}
else if (REMCODE == "VACDHP") {
var REMTYPE = "CANINE"
}
else if (substr(REMCODE,0,3) == "PRO") {
var REMTYPE = "PROGRAM"
}
else if (REMCODE == "VACCALI") {
var REMTYPE = "RABBIT"
}
else if (REMCODE == "VACGOAT") {
var REMTYPE = "GOAT"
}
else if (REMCODE == "HWRECALL") {
var REMTYPE = "HEARTWORM"
}
else if (substr(REMCODE,0,4) == "DENT") {
var REMTYPE = "DENTAL"
}
else {
var REMTYPE = "OTHER"
}
STATUS
STATUS
String
-1
-1
REMTYPE
REMTYPE
String
-1
-1
446
132
Y