hmis icon indicating copy to clipboard operation
hmis copied to clipboard

need sample database data

Open hewrie opened this issue 6 years ago • 21 comments

Details: i have running hmis from idea. but there are no data on hmis. please give sql data for trying hmis. and give username and password for login. thank you

hewrie avatar Sep 25 '19 04:09 hewrie

We will include a sample sql in the project folder itself.

buddhika75 avatar Sep 28 '19 04:09 buddhika75

Oke thank you.. I'll waiting for.

hewrie avatar Sep 28 '19 10:09 hewrie

can u please share the sql file of this project. i am not able to search that file in folder

ayushi84 avatar Sep 30 '20 19:09 ayushi84

A blank database is automatically creased by EcliseLink.

buddhika75 avatar Sep 30 '20 22:09 buddhika75

Thanks for replying. But it is not created may be. Can u send me SQL file of blank dtabase. Please it is very helpful for me.

On Thu, 1 Oct 2020, 04:00 Dr. M H B Ariyaratne, [email protected] wrote:

A blank database is automatically creased by EcliseLink.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/hmislk/hmis/issues/414#issuecomment-701680995, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIF6TU2BYGU7XHQMX7C2FGLSIOWRBANCNFSM4I2HMYOA .

ayushi84 avatar Oct 01 '20 00:10 ayushi84

i found the folder of sql file but create table command file is not there. Please help me. its urgent Untitled

ayushi84 avatar Oct 01 '20 18:10 ayushi84

Are you working with Netbeans? If so, please create a database (MySQL for example) and create a connection string. The open the persistance.xml file. Create a new data source using the connection. Then select create-tables as an option. Then it will create a database for you.

https://www.eclipse.org/eclipselink/documentation/2.5/jpa/extensions/p_ddl_generation.htm

buddhika75 avatar Oct 02 '20 06:10 buddhika75

wanted to try out this application. i am kindly requesting demo data

simendipeter avatar Oct 17 '20 06:10 simendipeter

I have created db in mysql....below is my persistence.xml: <?xml version="1.0" encoding="UTF-8"?> <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"> <persistence-unit name="hmisPU" transaction-type="JTA"> <jta-data-source>java:app/dsArogys</jta-data-source> <exclude-unlisted-classes>false</exclude-unlisted-classes> <shared-cache-mode>ALL</shared-cache-mode> <properties> <!--<property name="javax.persistence.schema-generation.database.action" value="create-or-extend-tables"/> --> <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" /> <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/hmis" /> <property name="javax.persistence.jdbc.user" value="root" /> <property name="javax.persistence.jdbc.password" value="" /> </properties> </persistence-unit> </persistence>

I have noticed there are 2 persistence.xml files in the project, which 1 should I change?

azharshaikh7866 avatar Apr 17 '21 17:04 azharshaikh7866

There should be atleast a sql script for admin user. Post-installation there is nothing much that can be added as it gives "You are NOT authorized" message everywhere. Please help me to add a user.

azharshaikh7866 avatar Apr 17 '21 20:04 azharshaikh7866

Sorry for the delay. I will add a startup script that will create the database on the first run. Until that, I will give a blank database. Please give me two days,

buddhika75 avatar Apr 19 '21 03:04 buddhika75

There should be atleast a sql script for admin user. Post-installation there is nothing much that can be added as it gives "You are NOT authorized" message everywhere. Please help me to add a user.

I am also facing the same issue. do you have a sample dataset that can be added first time and then we can explore the app? or atleast a way to add an admin user?

aartigrover84 avatar Aug 02 '21 10:08 aartigrover84

Sorry for the delay to reply. Please find it in the next commit.

On Mon, 2 Aug 2021 at 16:01, aartigrover84 @.***> wrote:

There should be atleast a sql script for admin user. Post-installation there is nothing much that can be added as it gives "You are NOT authorized" message everywhere. Please help me to add a user.

I am also facing the same issue. do you have a sample dataset that can be added first time and then we can explore the app? or atleast a way to add an admin user?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/hmislk/hmis/issues/414#issuecomment-890916317, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAJLRQWEF4OIQYY7ZCCUKTLT2ZXXBANCNFSM4I2HMYOA .

buddhika75 avatar Aug 02 '21 11:08 buddhika75

Hi, after running the system successfully, it gives "You are NOT authorized" message everywhere. Please help me to add a user.

mkyenze avatar Feb 11 '22 06:02 mkyenze

Need to add privileges.

On Fri, 11 Feb 2022 at 12:21, mkyenze @.***> wrote:

Hi, after running the system successfully, it gives "You are NOT authorized" message everywhere. Please help me to add a user.

— Reply to this email directly, view it on GitHub https://github.com/hmislk/hmis/issues/414#issuecomment-1035925521, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAJLRQVXLIVXVJOAVDJTXKLU2SWWRANCNFSM4I2HMYOA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you commented.Message ID: @.***>

buddhika75 avatar Feb 11 '22 08:02 buddhika75

Thanks solved. what about this, This user has no privilage to login to any Department. Please conact system administrator.

mkyenze avatar Feb 11 '22 10:02 mkyenze

Need to add departments for users to log in.

Can I have an online discussion with you to demonstrate the functions? I am available during the weekend. We do not have good documentation. We had to slow down the development as we are involved in COVID-19 related developments. Soon wi will come back to this open-source development.

On Fri, 11 Feb 2022 at 15:46, mkyenze @.***> wrote:

Thanks solved. what about this, This user has no privilage to login to any Department. Please conact system administrator.

— Reply to this email directly, view it on GitHub https://github.com/hmislk/hmis/issues/414#issuecomment-1036052132, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAJLRQXPKNG4RZGCIZQEUSLU2TOW3ANCNFSM4I2HMYOA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you commented.Message ID: @.***>

buddhika75 avatar Feb 11 '22 11:02 buddhika75

thank you so much, i will contact you if anything else of difficult arises

mkyenze avatar Feb 11 '22 11:02 mkyenze

Hi, how can i do away with this page and start feeding in info into db

Very Dangerous Section. Please do not touch this page without the written permission from the lead software developer.

On Fri, Feb 11, 2022 at 2:27 PM Dr. M H B Ariyaratne < @.***> wrote:

Need to add departments for users to log in.

Can I have an online discussion with you to demonstrate the functions? I am available during the weekend. We do not have good documentation. We had to slow down the development as we are involved in COVID-19 related developments. Soon wi will come back to this open-source development.

On Fri, 11 Feb 2022 at 15:46, mkyenze @.***> wrote:

Thanks solved. what about this, This user has no privilage to login to any Department. Please conact system administrator.

— Reply to this email directly, view it on GitHub https://github.com/hmislk/hmis/issues/414#issuecomment-1036052132, or unsubscribe < https://github.com/notifications/unsubscribe-auth/AAJLRQXPKNG4RZGCIZQEUSLU2TOW3ANCNFSM4I2HMYOA

. Triage notifications on the go with GitHub Mobile for iOS < https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675

or Android < https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub .

You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/hmislk/hmis/issues/414#issuecomment-1036106556, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOFYO3JDETZEP2272B5S2QTU2TXANANCNFSM4I2HMYOA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you commented.Message ID: @.***>

mkyenze avatar Feb 14 '22 07:02 mkyenze

Please have an online zoom session so that I can demonstrate. Due to the lack of time, difficult to document all. Sorry

On Mon, 14 Feb 2022 at 13:51, mkyenze @.***> wrote:

Hi, how can i be able to fill information here

Very Dangerous Section. Please do not touch this page without the written permission from the lead software developer.

— Reply to this email directly, view it on GitHub https://github.com/hmislk/hmis/issues/414#issuecomment-1038783394, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAJLRQXJSUXQPLWC2GVF6X3U3C3BLANCNFSM4I2HMYOA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you commented.Message ID: @.***>

buddhika75 avatar Jun 23 '22 17:06 buddhika75

I have been looking forward to trying this application but couldn't get it running. if someone can provide a video tutorial for setting up dev environment to run the application it will help many new comers like me

ippezshelby avatar Jun 23 '22 20:06 ippezshelby

Details are in the wiki https://github.com/hmislk/hmis/wiki

Blank Database is created when run for the first time. Data Needed to be added to the system using the UI.

buddhika75 avatar Oct 28 '23 18:10 buddhika75