tgdbepe4 / corona_ch_bag_formulare

2 stars 0 forks source link

COVID19 registration forms for PC processing

Many medical doctors mentioned on Twitter that they have to manually process the registration of new CODVI19 cases with the Federal Office for Health, BAG on a printed PDF form. This takes time and sending by email is complicated because the completed sheet needs to be scanned before sending. And FAX is really very old-fashioned!

Some noted that they would suggest and help establish an electronic solution. But that also takes time and needs training in how to use it.

This gave me the idea of ​​expanding the PDF files with form fields. These new files can then now be filled in on the PC und sending via e-mail.

Download from this project

Non IT persons don't like download files from here. For this reason there is an other way to get the PDF documents. Use this link for download, https://www.mycloud.ch/s/S005BE60DADA8A0461682D10365FD646D6A4C25C3AC.

Download from similar project

There is another very similar activity, https://github.com/lakay/COVID-19_PDF-Reporting and a download page is available. I copy their PDF's to here and to the cloud folder to prevent a parallel development. And I moved my ones away to the foleder "old".

XML files for import and export

Required: Adobe Acrobat software and maybe MS Access

With Adobe Acrobat you can easily edit the forms and import and export data to the form. Best way is over using the exporting and importing via an XML-File. For this go in Adobe Acrobat to the tools -> forms -> other actions -> forms administration -> exporting -> select *.xml (this is free form translated because I use a german version).

MS Access allows very easy to import such an XML-File into a DB (data base). The only thing to have to take care is initially re declare the fields with bigger content, for example remark fields as "Langer Text" instead of "Short Text".

And adding the following PDF data import to the same table.

A report of a feasibility study can you find over the link here, https://github.com/tgdbepe4/corona_ch_bag_formulare/blob/master/tests/Machbarkeit%20BAG%20Meldeformulare%20mit%20digialen%20Formularfeldern.pdf. In the "tests" folder you can find an example files und a MS Access file as well.

Comments welcomed

Please comment and make recommendations with in the way open an issue (you can find it on the top) here in gitgub. Or just send an e-mail with your comments, corrections and recommendations to mailto:corona@bergi-it-consulting.ch.