What is the problem we are trying to solve?

Right now, facilities, LGUs and labs are piling up COVID related data in their respective offices. For many, these files are either PDFs, or in excel/csv file format (especially those that have no integrated information systems). In order to submit this data to COVID Kaya, they need to manually input data from the files that they already have. This is tedious work (i.e in some LGUs, they a backlog of atleast 10,000 files not encoded to COVID Kaya

What are the options to solve this problem?

One way of automating the submission is by using the APIs that are currently available in COVID Kaya.

In order to use these APIs, the facilities and LGUs should have a system that can consume the APIs and convert their data to FHIR compliant JSON files, and use the APIs to POST data to COVID Kaya. This has proven to be a challenge for many LGUs and facilities with NO information systems. Or even with facilities with information systems, they will still need to customize their respective information systems to consume the COVID Kaya APIs.

Another option is to the ETL functionality that is being proposed for COVID Kaya.

In the ETL functionality, COVID Kaya will have an upload module where facilities just need to upload their files and provide the data mappings to COVID Kaya data fields. This is a fast way to solve the problem with the following caveats