wiki:UserGuidelines/Admin/RecordMerging

Version 4 (modified by Dominic König, 9 years ago) ( diff )

--

Record Merging

There are times when you have multiple records in the database which are duplicates.

For some simple 'leaf' resources it may be possible to simply delete one of them (e.g. Contacts).

However where other records point to this one, it is better to merge the 2 records together.

Identify the 2 record IDs, decide which one you wish to keep & which one should be deprecated & then merge them as follows:

auth.override=True
resource = s3db.resource("pr_person")
# (Good, Bad)
resource.merge(117, 90)
# If succesful:
db.commit()

It is also possible to specify that some fields should be retained from the one which is being deprecated.

There may of course be addiional records, such as Human Resource or Contacts. There may of course be addiional records, such as Human Resource or Contacts.

Note: See TracWiki for help on using the wiki.