Report and forms generator

[teryhill]

Throwing this out there to start some discussion.

Would this be a good Laravel project?

[Trodrige]

Hi, @teryhill I don't get it clearly. Can you explain, so I understand what you mean? Thanks

[teryhill]

@Trodrige

Let's start this off by separating the two.

The need for a replacement form generator, the one That was in Libre was functional and would generate a very basic form. Most people did not know it existed nor how to use it (I haven't done much with it)

There is no means for generating a report other than coding it.

I would like to see a drag and drop form generator. Also a drag and drop report generator. There would also need to be a report repository like the current forms repository in Libre. You can create a form and add it to the encounter. These generators need to be user friendly. Most of the end users will not be seasoned developers.

[aethelwulffe]

"Forms" mean (typically) Clinical Data entry forms.

These should be built up out of typical DB query blocks for supplying data/field types such as lists and common elements like Patient Name etc... In addition, you want to give the user a wizard that allows typical data types, like text boxes and the like.

The preference for any design like this is to 1.  Utilize pre-existing fields whenever possible, especially for medical diagnosis, medications/prescription, demographics and patient history data, and of course when there is a field that already belongs to a standard clinical form (like the vitals form) it should "talk" to the tables owned by those forms.  This is very important for clinical review, and vitally important for reporting.  Creating forms that no other part of the system can retrieve data from is a very bad prospect (such as the current "Layout Based Forms" do.

Honesty, to design something like this, it is pretty important to have a fair background in clinical type data.  Otherwise, you can, like me, invest in a lot of effort to get up to speed with it.

On 2017-09-28 19:37, Terry Hill wrote:

@Trodrige https://github.com/trodrige

Let's start this off by separating the two.

The need for a replacement form generator, the one in Libre is functional and will generate a very basic form. Most people do not know it exists nor how to use it (I haven't done much with it)

There is no means for generating a report other than coding it.

I would like to see a drag and drop form generator. Also a drag and drop report generator. There would also need to be a report repository like the current forms repository in Libre. You can create a form and add it to the encounter. These generators need to be user friendly. Most of the end users will not be seasoned developers.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/LibreHealthIO/LibreEHR/issues/675#issuecomment-332992094, or mute the thread https://github.com/notifications/unsubscribe-auth/AAhzF3GWeuSJPnWdiAWQiasqOEYUhBmjks5snC22gaJpZM4PiFfV.

[Trodrige]

Ok, @teryhill and @aethelwulffe I'll love to take this on. Will need headstart and resources (if any on clinical type data etc), some directives as we go through.

[teryhill]

We are here to help. Let us know what you need. I would suggest a very simple start. Just give a basic report and a form.

[Trodrige]

I understand we need report and forms generator. @teryhill I'm trying to see how I Laravel comes in here, but it's not clear. Can you say how/why you see it as a Laravel project? Maybe I'll pick up from there.

[teryhill]

Does not need to be a Laravel project. I just threw that out there. However you want to do it. The report generator will need to be able to download the reports in various formats like CSV , PDF , DOC , ODT or plain txt. as a few. What ever you want to use is basically up to you. Would be good if the tool has a small foot print or is some thing already in the assets directory.

[Trodrige]

@teryhill sorry for not replying earlier. In Documentation/8_ForDevelopers/3rd_Party_Form_API.txt there are steps, format and functions for form creation in LibreEHR. I did not see any doc on reports part. Now, this is what I understand:

1. Information in generated reports is based on the forms fields that generate the corresponding information. For e.g at Reports->Visits->Encounters, the report generated depends on the values of the fields in the form above.
2. We want the forms to be editable by users (drag and drop) so that they can generate customized reports.

Questions:

1. I understand reports are generated based on the values chosen on the form above. What do you mean by 'drag and drop report generator' in this case?
2. Have I gotten these right?

@teryhill I think we should discuss more on this. We can talk on Skype, if ok by you

[teryhill]

@Trodrige There are no doc's on the report generation, this is a new item, that is why you do not see any in the documentation.

A drag and drop report generator will give the user an option to select a database or databases then select fields to report on and build a query.

You are on track.

[teryhill]

@Trodrige also I have tried video conferencing with others and because I use satellite internet it has never worked, sorry perhaps @aethelwulffe can talk with you or may be he can set it up thru the chat with you.

[aethelwulffe]

I wouldn't mind talking to you @Trodrige , be glad to. I suggest the librehealth.io rocketchat video calling tool. I will sort of need to schedule the time though. Got any suggestions (coordinated Universal Time/GMT +date)?

[tmccormi]

There are a couple of high end "drag and Drop" report creation tools, we have implemented for Pentaho in the past to do this. Not a easy task, even when the system already exists to do it as most of the work is making the database understandable to the user.

You can see what I originally had done with Pentaho for OpenEMR at: https://github.com/oemr501c3/openemr-insights - some of this could be used if we wanted to go that way.

This is a good comparison of the open source tools that are out there that do this: http://www.innoventsolutions.com/comparison-matrix.html

[Trodrige]

@aethelwulffe I'll set up tomorrow and let you know when we can talk, thanks.

Thanks, @tmccormi for the suggestions. I'll look at them and further discuss with @aethelwulffe

[Trodrige]

Hi, @aethelwulffe can we talk at 11:00pm(UTC), date: 01-10-2017?

[aethelwulffe]

If that is the same as 2017-01-10, then that sounds great!  I am registering that as 7PM my time.  I have a workshop sort of meetup that I supervise during that time, but that should not affect us being able to have a good discussion.

On 2017-09-30 10:07, Tigpezeghe Rodrige wrote:

Hi, @aethelwulffe https://github.com/aethelwulffe can we talk at 11:00pm(UTC), date: 01-10-2017?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/LibreHealthIO/LibreEHR/issues/675#issuecomment-333310824, or mute the thread https://github.com/notifications/unsubscribe-auth/AAhzFwDfzHmQ8s3Ex9ttA-PY5w0koo9iks5snksWgaJpZM4PiFfV.

[Trodrige]

OK, great. On Sep 30, 2017 17:42, "Art Eaton" notifications@github.com wrote:

If that is the same as 2017-01-10, then that sounds great! I am registering that as 7PM my time. I have a workshop sort of meetup that I supervise during that time, but that should not affect us being able to have a good discussion.

On 2017-09-30 10:07, Tigpezeghe Rodrige wrote:

Hi, @aethelwulffe https://github.com/aethelwulffe can we talk at 11:00pm(UTC), date: 01-10-2017?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/LibreHealthIO/LibreEHR/issues/ 675#issuecomment-333310824, or mute the thread https://github.com/notifications/unsubscribe- auth/AAhzFwDfzHmQ8s3Ex9ttA-PY5w0koo9iks5snksWgaJpZM4PiFfV.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/LibreHealthIO/LibreEHR/issues/675#issuecomment-333320468, or mute the thread https://github.com/notifications/unsubscribe-auth/APZj2_c0D8aUtg7jTNY42G1u9U8EtcDyks5snm-LgaJpZM4PiFfV .

[Trodrige]

Hi @aethelwulffe, sorry for the long absence. We have to talk on this issue. I suggest we talk today at 9:00 pm if it's ok.

[aethelwulffe]

9PM EST? Yaoundé time is five hours ahead of me, so maybe I should assume at 4PM EST vs. 2AM your time.

I shall have a go of it.

On 2017-10-10 11:09, Tigpezeghe Rodrige wrote:

Hi @aethelwulffe https://github.com/aethelwulffe, sorry for the long absence. We have to talk on this issue. I suggest we talk today at 9:00 pm if it's ok.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/LibreHealthIO/LibreEHR/issues/675#issuecomment-335505108, or mute the thread https://github.com/notifications/unsubscribe-auth/AAhzF-qOI4_pTTya2sulGAOBO8BGTn34ks5sq4ivgaJpZM4PiFfV.

[teryhill]

Are you going to try the on the chat?

[aethelwulffe]

That is the hope.

[teryhill]

Maybe I can watch 8^)

[Trodrige]

Wow wow, @aethelwulffe that was supposed to be 09:00 PM UTC. So it is 10:00 PM for me, and 05:00 PM for you. Is this ok?

[aethelwulffe]

UTC is cool!  gotcha.  1700UTC!  video call via the chat utility here?

On 2017-10-10 12:42, Tigpezeghe Rodrige wrote:

Wow wow, @aethelwulffe https://github.com/aethelwulffe that was supposed to be 09:00 PM UTC. So it is 10:00 PM for me, and 05:00 PM for you. Is this ok?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/LibreHealthIO/LibreEHR/issues/675#issuecomment-335534782, or mute the thread https://github.com/notifications/unsubscribe-auth/AAhzFy2DcziJsxW1a1Qsr4-aPsyjC6Y-ks5sq55XgaJpZM4PiFfV.

[Trodrige]

Yup, here --> https://chat.librehealth.io

[Trodrige]

@aethelwulffe we still have to discuss this issue.

[Trodrige]

@aethelwulffe we have a discussion pending on this issue. I really want to work in this, and need your guidance. On Oct 10, 2017 6:08 PM, "Art Eaton" notifications@github.com wrote:

UTC is cool! gotcha. 1700UTC! video call via the chat utility here?

On 2017-10-10 12:42, Tigpezeghe Rodrige wrote:

Wow wow, @aethelwulffe https://github.com/aethelwulffe that was supposed to be 09:00 PM UTC. So it is 10:00 PM for me, and 05:00 PM for you. Is this ok?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/LibreHealthIO/LibreEHR/issues/ 675#issuecomment-335534782, or mute the thread https://github.com/notifications/unsubscribe- auth/AAhzFy2DcziJsxW1a1Qsr4-aPsyjC6Y-ks5sq55XgaJpZM4PiFfV.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/LibreHealthIO/LibreEHR/issues/675#issuecomment-335542729, or mute the thread https://github.com/notifications/unsubscribe-auth/APZj2yXIoFjK-ZaW51RrizS1PkTNL4W7ks5sq6SJgaJpZM4PiFfV .

[tmccormi]

We need a form creation tool, so happens the the LibreHealth toolkit has one that generates XML that could, potentially, be used to dynamically present forms for the EHR. @judywawira and I have talked about standing up a lh-toolkit "service" that does nothing but allow the design of forms (drag and drop) so that the XML can be consumed by the EHR ...

[Trodrige]

@teryhill this is the issue I had problems implementing. It seems @tmccormi has a solution to it.

[teryhill]

@Trodrige I don't know if it is a solution or a suggestion. Why don't you ping ivange94 and see if he has an Idea of how to utilize the code in the toolkit as a standalone function that could be used in the EHR.

[Trodrige]

Ok, @teryhill I'll contact Ivange94 for help on this.

[Trodrige]

@tmccormi can you tell more about the LibreHealth Toolkit form creation tool. A little detail what you mean by "service", and how EHR consumes it. Thanks

[tmccormi]

You'll need to chat on the forum with the toolkit team. Judy G demo'ed it to me and we discussed possibilities. Maybe we arrange another demo?

Tony McCormick

On Oct 29, 2017 12:22 PM, "Tigpezeghe Rodrige" notifications@github.com wrote:

@tmccormi https://github.com/tmccormi can you tell more about the LibreHealth Toolkit form creation tool. A little detail what you mean by "service", and how EHR consumes it. Thanks

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/LibreHealthIO/LibreEHR/issues/675#issuecomment-340287076, or mute the thread https://github.com/notifications/unsubscribe-auth/AARci3vn5ImEkifrMkJI7_m9ofXq94czks5sxNBpgaJpZM4PiFfV .

-- Please be aware that e-mail communication can be intercepted in transmission or misdirected. Please consider communicating any sensitive information by telephone. The information contained in this message may be privileged and confidential. If you are NOT the intended recipient, please notify the sender immediately with a copy to hipaa-security@mrsb-ltd.com and destroy this message.

[Trodrige]

That'll be great. When do we do it?

[dhruv-chauhan]

Hi, I would like to take up this project for GSoc2018. I'd like the mentors to give me a start on this one.

[judywawira]

Discussions happen on the forum - forum.librehealth.io and in the chat room — chat.librehealth.io specifically the #gsoc channel

On Jan 18, 2018, 10:42 AM -0500, Dhruv Chauhan notifications@github.com, wrote:

Hi, I would like to take up this project for GSoc2018. I'd like the mentors to give me a start on this one. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

[teryhill]

The GSoC participants need to submit an outline of the proposed project. What they are going to do and How they intend to accomplish it. Then the student is selected based on their proposal.