Changes between Initial Version and Version 1 of UserGuidelines/Import/UpdateDetection


Ignore:
Timestamp:
09/13/12 07:54:50 (9 years ago)
Author:
Dominic König
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/Import/UpdateDetection

    v1 v1  
     1= Update Detection during Imports =
     2
     3Data imports can do both - create new records in the database and update existing ones.
     4
     5If Sahana Eden can identify an import item with an existing record, this record will be updated rather than a new record being created.
     6
     7In order to identify the import item, Eden uses a cascade of rules:
     8
     9  1. Identification by UUID
     10  2. Identification by other unique keys
     11  3. Identification by table-specific rules
     12
     13== Identification by UUID ==
     14
     15Every record in the Sahana Eden database has a UUID field (universally unique identifier), see [wiki:UUID]. If an import item contains a UUID and it matches an existing database record, this record will be updated rather than creating a new record.
     16
     17== Identification by Other Unique Keys ==
     18
     19Some database tables use additional unique keys, e.g. the "name" field in organisations. These keys can be used instead of UUIDs to indicate updates - however: if there is also a UUID present in the import item, then only the UUID will be used to identify the record to update.
     20
     21== Table-Specific Identification Rules ==
     22
     23For many database tables, Sahana Eden has additional table-specific rules to identify records in cases where the import item does not contain a UUID and no match can be found by unique keys.
     24
     25=== Person Records ===
     26
     27   - ''tbw''