Please note that the Datastore is currently in its first release. Therefore, data queries may sometimes result in unexpected outputs. In particualar, invalid publisher data has been known to cause problems when importing data into the Datastore.
How is the data updated?¶
Every night two processes take place.
- Firstly the IATI Registry reviews and updates all its indexes, checking that all items in its catalogue still exist (or are accessible), and whether the data stored on the publishers’ websites has changed.
- Secondly the Datastore reviews all changes in the Registry. New activities are added to the database and changed activities are reloaded. Any database records of activities that have been removed from the Registry are also deleted.
- Warning! Note that this is an overnight job so it can take up to 24 hours for new publishers’ data to appear in the store.
When the data is imported into the database certain fields are cleaned to ensure consistent output without altering the meaning of the data. Date and money formats are standardised, as are country, currency and language codes. The original XML is stored as a ‘blob’ with the activity record.