Export the complete record data in the system

Hi, please i need your help to export the complete record data with the demographic , forms informations. i followed what is explained here https://bahmni.atlassian.net/wiki/spaces/BAH/pages/58523681/Complete+Data+exports+for+endTB but i see a lot of csv files difficult to understand where to get the patient attributes like age, gender … if someone can help, really need to export clinical informations. @gsluthra can you have a look?

Thank you, regards.

Hi @esther

Can you please provide some more details on what data are you wanting to export? Is it all the patient attributes (like name, age, gender, etc) and then also the various observations recorded for each patient?

One way to export data is to create an appropropriate “report” and then choose the “CSV” option while running the report. That way, you can download the relevant data. https://bahmni.atlassian.net/wiki/spaces/BAH/pages/90472551/Reports

If a particular report template doesn’t have all data you need, then one can write a custom SQL based report for that.

Alternatively, there is also a new Bulk FHIR Report feature recently added into Bahmni (although it doesn’t export obs data, just patient, medication and orders). https://www.youtube.com/watch?v=MOFFWx7_mp8

cc: @jess

@gsluthra ok i see thank you. Please can you help i would like to add the visit number in each report in order to know that this is the information for the first visit, second visit etc …

If you see the VISIT Report here, https://bahmni.atlassian.net/wiki/spaces/BAH/pages/90472551/Reports#Reports-1.VisitsReport, you can see that there is a Visit Date and Visit ID. If you sort data by Patient and then by Visit Date/ID, then it should be clear that each row is of a different visit.

If you want to show a column called “Visit Seq”… which shows 1,2 then that might require a custom SQL to be written. Could be a bit complicated. Something like this maybe: https://copyprogramming.com/howto/how-to-show-sequential-number-in-mysql-query-result