/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
-
2007/04/20 14:09:23.197
RxWorks
MSACCESS
ODBC
RxWorks
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
PORT_NUMBER
-1
STREAM_RESULTS
Y
USE_POOLING
N
Transform Clinic FieldsLocationY Select Clinic FieldsTransform Clinic FieldsY Table inputSelect Clinic FieldsY
Location
OpenVPMSLoaderPlugin
Y
1
none
OpenVPMSCODE<party.organisationLocation>namefalsefalse<party.organisationLocation>currencyfalseAUDfalse<party.organisationLocation>contacts[0]<contact.location>addressfalsefalse<party.organisationLocation>contacts[0]<contact.phoneNumber>telephoneNumbertruefalse<party.organisationLocation>contacts[0]<contact.email>emailAddressfalsefalse<entityRelationship.practiceLocation>targettrue<party.organisationLocation>$valuefalse<entityRelationship.practiceLocation>sourcetrue<party.organisationPractice>1falsetruetrue1000
674
243
Y
Select Clinic Fields
SelectValues
Y
1
none
Clinic Code
CODE
-2
-2
Clinic Name
NAME
-2
-2
Clinic Address
ADDRESS
-2
-2
Clinic Phone Number
PHONENO
-2
-2
Clinic Fax Number
FAXNO
-2
-2
Clinic Email Address
EMAIL
-2
-2
256
247
Y
Table input
TableInput
Y
1
none
RxWorks
SELECT *
FROM Clinic
0
N
N
119
250
Y
Transform Clinic Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
471
246
Y