docs.healthdata.beICT Information Session 2023.06.09
Dernière mise à jour: 2023-07-17 13:12
INVITATION
Dear colleague,
The healthdata.be team hereby invites you to a new series of open Q & A Sessions. These meetings will address a variety of critical topics that have been brought to our attention, and aim to support you by the implementation of the HD web services and csv upload for the register projects of healthdata.be (Sciensano) .
In our continual efforts to ensure these sessions are as beneficial as possible, we kindly request that you share any specific concerns, outstanding issues, or valuable feedback ahead of the meeting. This will assist us in tailoring our preparations to meet your needs.
At present, we have scheduled these 1 hour online sessions to occur on a weekly basis, each Friday 10h30-11h30. Depending on the volume of feedback and the progression of the sessions, we might adjust the frequency to a bi-weekly occurrence in the foreseeable future. Changes in the schedule will be communicated in advance.
In the first session, 09/06/2023 at 10h30-11h30, we will start with answering questions received after previous IT information session of 15/05/2023. Questions you share before the end of business on the coming Wednesday, will also be addressed.
Please feel free to direct any questions or inquiries to email onboarding.
| -- Do not delete or change any of the following text. -- |
| When it's time, join your Webex meeting here. Join meeting More ways to join: Join from the meeting link https://sciensano.webex.com/sciensano/j.php?MTID=ma44a86e2ef029aa9957d7bbc943119ee . Join by meeting number Meeting number (access code): 2741 935 2969 Meeting password: MwSJi2iBv83 (69754242 from phones and video systems) Tap to join from a mobile device (attendees only) +44-20-3478-5289,,27419352969#69754242# United Kingdom Toll Some mobile devices may ask attendees to enter a numeric password. Join by phone +44-20-3478-5289 United Kingdom Toll Global call-in numbers Join from a video system or application Dial 27419352969@sciensano.webex.com You can also dial 62.109.219.4 and enter your meeting number. If you are a host, click here and login site to view host information. Need help? Go to https://help.webex.com |
The agenda (questions) and the presentations (with answers) will be made available on our https://docs.healthdata.be/hd-ict-information-sessions
We look forward to your presence at our meetings.
Kind Regards,
The healthdata.be team
RESOURCES
Recording of the session
expiry date 2023.07.24
Slide deck of the session
Questions and answers to the session
EAM: Entity Access Management; ACC: Online Acceptance Environment; TECH DOC: Technical Documentation: MISC: Miscellaneous
| Q01 | Is combined data transfer via API + Form Entry possible? | Yes combined data transfer is possible. Records can be sent via API and also by form entry. However, these forms of data transfer can't be combined on the same record, since the usage of API results in an automatic submit, rendering manual adaptations impossible. When using CSV upload, there is an option to load the data in draft mode which will not automatically submit the record and allow you to modify the record on the web form. CSV, API and form entry are all possible on the online acceptance environment. |
| Q02 | This acceptance environment is only for testing purposes? | Yes, the acceptance environment is only for testing. The data is not send to healthdata.be and will be deleted every week. |
| Q03 | Will acceptance environment become available for all hospitals by default ? | Yes, the acceptance environment is available for all hospitals by default. We will proactively create and send out all credentials by June 16th 2023. |
| Q04 | I can't see my institution in the dropdown list. | We will proactively create and send out all credentials by June 16th 2023. |
| Q05 | Is it possible to upload a portion of the data via CSV and complete the rest through the web form? | Yes. If the CSV data is uploaded data in 'draft' mode, yes, you can make modifications in the web UI. To upload in draft mode, add a new column with header 'STATUS' and value 'DRAFT'. Also, see Q01. |
| Q06 | Can we use the same user for the API, is this by Basic Authentication by Postman | Yes, this is basic authentication in Postman. Each organization will receive 3 sets of credentials: for web form, for API transfer and for CSV upload. The usage of the same user is not possible. |
| Q07 | Is it possible after data transfer via API to alter or complete the register via the web UI? | No, this is only possible when loading data via CSV. Please refer to Q01 and Q06 for more details. |
| Q08 | Can Electronic Health Record (EHR) suppliers also gain access to the online acceptance environment, or do they have to work via the hospital acceptance logins? | Yes, Electronic Health Record (EHR) suppliers can also have a separate account giving them access to the online acceptance environment without making use of a hospital's credentials. |
| Q09 | To view the results in the HD4DP2 online acceptance environment, we have to specify test@sciensano.be as an author in CSV or JSON? | Yes, for the online acceptance environment you need to define the test@sciensano.be as Author and Co-Author for the author group Test group. |
| Q10 | So for production we need a user who has access to all the registers to use the API or is there a special admin user ? | On your local installation you have your own specified (technical) user/password to use the API calls for all registers. This user/password has been provided during the installation. If the user/password is not known anymore, it will be provided again by logging a request via Service Desk. |
| Q11 | The service portal says I need a pasword for every register,and ask it by the eam ? | The Entity Access Management (EAM) portal processes user access requests for specific projects (register). For API user/password and SFTP access is not included in the EAM portal. The API/SFTP credentials are valid for all registries the organization is participating in. These credentials are provided to your organization upon installation. If the user/password is not known anymore, it can be provided again by logging a request via Service Desk. |
| Q12 | Is it possible to get correct CSV sample for testing ? | We have updated the example files with full and correct data and we have supplied extra files so all fields are covered in the example files. Please consult our project DOCS pages with information about each project and links to the updated CSV & API sample files on the FAIR portal. |
| Q13 | About the upload of the stable data of the BCFR register with a CSV file, what is to specify as "TX_AUTHOR_GR" : the email of the author group (author) or the name of the author group (To be filled in the format <first_name last_name> of the author, with just 1 space) ? | TX_AUTHOR_GR should be the name of the Author Group. E.g. "TX_AUTHOR_GR": "Tom Mat", "TX_AUTHOR": "tom.mat@example.com", "TX_COAUTHOR": "tom.mat@example.com" |
| Q14 | For a CSV file, can you tell us which column must be added for a draft file submit? | Add a new column with header 'STATUS' and value 'DRAFT'. |
| Q15 | Is it possible to give end users specific authorisation on their sftp folders? Or is it always for authorisation for all the registers? | Access to the sftp folder (and also API) is organization-based authentication and not user-based. API and CSV upload is intended to be managed by the local IT department. |
| Q16 | Should the folders per project also be available per project on our local installation? I now only have /upload/nippin | To see the folders per project, you need to connect to the port 2222, with username starting with organization-<id>. For more information, please consult the relevant DOCS page. The upload NIPPIN folder is accessed using other connection information. |
| Q17 | How can we be invited to these sessions? We have now received the invitation via via. Can we register somewhere? | All hospitals are automatically invited to these regular sessions via the contact persons registered in our systems. Once you receive an invitation, you're welcome to forward it to any colleague who you think would benefit from attending. If you would like to add an email address to the contact list for the IT sessions, please send an email to onboarding.healthdata@sciensano.be. |
| Q18 | Is Mycarenet already working. We don't get any xml in the sftp folder, no reaction from Service Portal on this question (since 2 weeks) ? | At this moment we are in close collaboration with RIZIV and MyCareNet to get the process up and running as soon as possible. Please refer to the relevant DOCS page for a detailed overview on the whole MyCareNet status. |
| Q19 | According to documentation, there should be a table nippin_message in the local DB. But I do not have/see this table? | The nippin_message is not located in the local database but in the nippin database. Please refer to the relevant DOCS page for more information. |
| Q20 | Is it possible to have correct payload for the API testing? | We have updated the example files with full and correct data and supplied extra files so all fields are covered in the example files. Please consult our project DOCS pages with information about each project and links to the updated CSV & API sample files on the FAIR portal. |
| Q21 | How do we get access to the Local DB? | The read-only postgres user/pasword for the local database and nippin database has been provided during installation. If the user/password is unknown, this can be retrieved via the Service Portal. |
| Q22 | For the CSV upload, if I understand correctly, the name of the group (TX_AUTHOR_GR) is the name of the author (example if the author is Tom Mat, the name of the group will be "Tom Mat") ? | Yes, that is correct. TX_AUTHOR_GR should be the name of the author group. E.g. "TX_AUTHOR_GR": "Tom Mat", "TX_AUTHOR": "tom.mat@example.com", "TX_COAUTHOR": "tom.mat@example.com" |
| Q23 | Hello, how to get access to acc env ? | A request can be made via our Service Portal, but we will proactively create and send out all credentials to the HD4DP SPOC's by June 16th 2023. |
| Q24 | A lot of login and password are pending .... is there delay ? | The user access request process consists of several steps (processing the request, approval by SPOC, account creation). Due to the high amount of requests received recently, there is a delay in each of the different steps. We are working hard to reduce the delay. |
This documentation is being updated regularly. We try to provide as correct, complete and clear as possible information on these pages. Nevertheless, if you see anything in the documentation that is not correct, does not match your experience or requires further clarification, please create a support ticket via our portal (https://healthdatabe.atlassian.net/servicedesk/customer/portals) or send us an e-mail via support.healthdata@sciensano.be to report this documentation issue. Please, do not forget to mention the URL or web address of the page with the documentation issue. We will then adjust the documentation as soon as possible. Thank you!