Changes between Version 13 and Version 14 of Onyx to CiviCRM

Timestamp:

12/13/13 08:57:48 (10 years ago)

Author:

Richard Bramley

Comment:

--

Onyx to CiviCRM

@@ -24 +24 @@
  - CANCELLED
  - COMPLETED
-- [ ] Title (participant_attribute_value.pat_title)
+- [x] Title (participant_attribute_value.pat_title)
 - [x] First Name (Participant.firstName)
 - [x] Surname (Participant.lastName)
-- [ ] Address
+- [x] Address
  - participant_attribute_value.pat_address1
  - participant_attribute_value.pat_address2
@@ -64 +64 @@
     , p.first_name
     , p.last_name
+    , pa.address_1
+    , pa.address_2
+    , pa.address_3
+    , pa.address_4
+    , pa.address_5
+    , pa.postcode
     , p.birth_date
     , p.gender
@@ -92 +98 @@
         pa.participant_id
       , GROUP_CONCAT(if(pa.attribute_name = 'pat_title', pa.text_value, NULL)) AS title
+      , GROUP_CONCAT(if(pa.attribute_name = 'pat_address1', pa.text_value, NULL)) AS address_1
+      , GROUP_CONCAT(if(pa.attribute_name = 'pat_address2', pa.text_value, NULL)) AS address_2
+      , GROUP_CONCAT(if(pa.attribute_name = 'pat_address3', pa.text_value, NULL)) AS address_3
+      , GROUP_CONCAT(if(pa.attribute_name = 'pat_address4', pa.text_value, NULL)) AS address_4
+      , GROUP_CONCAT(if(pa.attribute_name = 'pat_postcode', pa.text_value, NULL)) AS postcode
+      , GROUP_CONCAT(if(pa.attribute_name = 'pat_ethnicity', pa.text_value, NULL)) AS ethnicity
+      , GROUP_CONCAT(if(pa.attribute_name = 'pat_gp', pa.text_value, NULL)) AS gp
+      , GROUP_CONCAT(if(pa.attribute_name = 'pat_nhsnumber', pa.text_value, NULL)) AS nhsNumber
+      , GROUP_CONCAT(if(pa.attribute_name = 'pat_telephone', pa.text_value, NULL)) AS telephone
+      , GROUP_CONCAT(if(pa.attribute_name = 'pat_workphone', pa.text_value, NULL)) AS workphone
     FROM participant_attribute_value pa
     GROUP BY pa.participant_id