The 1st stage differential upload is to upload a .gpg file to add, update or delete records. The existing UPDATE_MODE and STATUS fields are used to give information to do differential upload. 

1. Organizations allowed for DIFF upload

• The registries that upload donors with GRID. GRID is compulsory for DIFF.
• All registries and CBBs upload CBUs

      WMDA suggests all organizations with dataset more than 100K consider to implement DIFF upload to save effort to time.

2. How to create the .gpg file 

When there is more than one record 

• Following the same process in the FULL upload user guide  Search & Match Service Data Submission Information to prepare the differential upload .gpg file.
• The DIFF upload needs include all the fields for a DONOR/CBU exactly like the FULL upload. For no records situation for DIFF file, please check guide below.

• Changes comparing to current FULL upload (Will later be updated in the FULL upload user guide)

  Field Identifier	Required	Description	Type	Length	Comment
  UPDATE_MODE	Yes	Update mode of the inventory, i.e. FULL or DIFF	updateModeType	4	"FULL" means for full upload "DIFF" means differential upload
  STATUS	Yes	Status of the donor/CBU	statusType	2	statusType: "AV" ,"TU" ,"RS",  "DE" * AV = Available for transplantation purposes TU = Temporarily unavailable RS = Reserved DE = Deleted, permanently unavailable* *DE is only supported in DIFF upload, will be rejected in FULL upload.

When there is no record

Accepted structure
DIFF file generation normally run automatedly, and it is possible there is no record generated. We suggest our registry do send the updated for this empty file case. But the empty record file must use the structure as below to not include the <INVENTORY> element. Otherwise the data process will generate error and block new files from your registry to be processed. 
XML example as below:
        

<?xml version="1.0" encoding="UTF-8"?>
<INVENTORIES CREATION_TIME="2022-03-07T10:00:03Z">
</INVENTORIES>

Not accepted structure currently

Structure below will cause issue in WMDA data process, we added a ticket to add this feature to future release, will support it soon in June, 2024. We will send out notification when release this feature.

<?xml version="1.0" encoding="UTF-8"?>
<INVENTORIES CREATION_TIME="2022-07-15T07:49:26Z">
  <INVENTORY LISTING_ORGANIZATION="0999" POOL="0999" CONTENT_TYPE="C" UPDATE_MODE="DIFF" SNAPSHOT_TIME="2022-07-15T07:49:26Z" SCHEMA_VERSION="2.3"/>
</INVENTORIES>

3.Expected behavior

4. Business validation rules

5. Errors and warnings in the processing report

Report

File: ION-0999-D.gpg 2019-09-09 11:39:22
Pool(s): 0999
Content Type: D
Update Mode: DIFF
Start processing: 2019-09-09 11:50:00
Schema version: 2.1
Total records processed: 14
Total records with warnings: 6
Total records rejected: 4
Total valid records: 7
Total updated records: 4
Total new records: 4
Total deleted records: 2

List of Records with duplicated ID or GRID:

POOL: 0999
IDs:
TD-000004
GRIDs: 
1234000000000203420


W | 0999 | TD-000002 | N/A | (Warning) GRID 774800006001853603 must be 19 characters.
R | 0999 | TD-000002 | N/A | GRID (Record Rejected) GRID is a mandatory field.
W | 0999 | TD-000003 | N/A | (Warning) GRID 7748000060018E53612 checksum is not correct.
R | 0999 | TD-000003 | N/A | GRID (Record Rejected) GRID is a mandatory field.
W | 0999 | TD-000010 | 1234000000000001031 | STAT_END_DATE (Warning) Status end date cannot be > 5yrs in the future.
W | 0999 | TD-000010 | 1234000000000001031 | STAT_REASON (Warning) Status reason cannot be provided with status AV or RS.
R | 0999 | TD-000013 | 999900000TD00001129 | BIRTH_DATE (Record Rejected) BIRTH_DATE is a mandatory field.
W | 0999 | TD-000014 | N/A | (Warning) GRID must be 19 characters.
R | 0999 | TD-000014 | N/A | GRID (Record Rejected) GRID is a mandatory field.



Processing finished at: 2019-09-09 11:53:55
Total processing time: 0 minutes.

The processing report for differential upload has 3 parts.

• 1st part is the summary of the file upload, with more details of updated, new, and deleted records. 
• 2nd part is the duplication in the uploaded file, data uploader should clean up the duplication.
• 3rd part is the rejections and warnings. Data uploader should clean up all of them.

Summary numbers:

We define some cases:

New Record Errors/warnings:

We do not have new in DIFF upload yet.

6. Organizations use DIFF upload