Changes between Version 3 and Version 4 of CiviCRM Module HSCIC Importer Planning

Timestamp:

10/08/13 10:05:03 (11 years ago)

Author:

Nick Holden

Comment:

--

CiviCRM Module HSCIC Importer Planning

@@ -112 +112 @@
 The monthly update file (egpam.zip -> egpam.csv) is an amalgamation of entries in both the above two formats into a single file for GP and GP practice data. Updated branch data is in ebranchsam.csv which is contained in eamendam.zip each month.
 
+Note that addresses are 'unstructured' other than postcode. We could replicate the address matching approach we've implemented for the NIHR !BioResource module, but (a) beware of google maps API limit and (b) the street address for practices rarely begins with a number, so is less predictable. A reliable source of address data is becoming a higher priority.
+
+
 === Process ===
 
@@ -118 +121 @@
 Match each GP to a health worker record in CiviCRM, ensure relationship links to correct GP Practice. Include senior partner / principal GP relationship.
 
-How to deal with archive data? Do we care?
+How to deal with archive data? Do we care? For the time being, assume we don't care. What matters to us is a currently-viable record of each practice so that we can construct mailing lists, etc., not a historically accurate record of all changes.
 
-See https://api.drupal.org/api/drupal/modules%21system%21system.api.php/function/hook_cron/7 for details on using cron to schedule the work
+This requires an amendment to the CiviCRM object model for Practice addresses - an additional item of custom data for the 'organisation code' which comprises the practice code plus a three digit identifier. This will be optional - it only has relevance for branch surgery addresses, not main addresses.
+
+See https://api.drupal.org/api/drupal/modules%21system%21system.api.php/function/hook_cron/7 for details on using hook_cron to schedule the work.
+
+To begin with, we should limit our work to loading in GP surgeries, GPs themselves, and addresses / telephone numbers for GP surgeries and branch surgeries. Links to health authorities and other entitities would be possible, but is outside of scope for the time being.
+
 
 === Psuedocode ===
+
+{{{
 
 wget monthly GP + practice amendment file
@@ -135 +145 @@
 if different, unpack zip file
 process csv file
+
+}}}