what is patientids in query

[saurav12994]

What is patientids in given query? I can't understand whether it is folder consisting of two files aih_n_aih.txt and apac_cnspcn.txt or a file

java -Xmx8g -Dfile.encoding=UTF-8 -cp projectdir/bin/uber-sus-openehr-builder-1.0.1-SNAPSHOT.jar br.uerj.lampada.openehr.susbuilder.EHRGenerator --patients patientids --ehr-dir outputdir --type < ehr|version|composition > --format < json|xml > [--aih]

[sergiofreire]

In Orbda DB there are seven tables: 1) hospitalisations - data related to patient's hospitalisations 2) the other tables are related to outpatients' data

We do not have a patient identifier in the hospitalisation table. In this table there is a field called n_aih that is a hashed hospitalisation identifier. We used it to generate an ehr-id for hospitalised patients. In fact a patient may have more than one hospitalisation, but we do not intend to be precise here.

In the outpatient tables, the ap_cnspcn field is a hashed patient identifier that is used to generate an ehr-id for outpatient patients.

There are two files in the project homepage apac_cnspcn.txt - contains all the values of the ap_cnspcn field in all outpatient tables aih_n_aih.txt - contains all the values of the n_aih field in the hospitalisation table

If you want to generate ehrs for hospitalisations (-aih option), you will have to make patientids point to the aih_n_aih.txt file Otherwise patientids will point to the apac_cnspcn.txt file

Hope it helps.

On Fri, Aug 4, 2017 at 3:39 AM, saurav12994 notifications@github.com wrote:

What is patientids in given query

java -Xmx8g -Dfile.encoding=UTF-8 -cp projectdir/bin/uber-sus- openehr-builder-1.0.1-SNAPSHOT.jar br.uerj.lampada.openehr.susbuilder.EHRGenerator --patients patientids --ehr-dir outputdir --type < ehr|version|composition > --format < json|xml > [--aih]

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3, or mute the thread https://github.com/notifications/unsubscribe-auth/AEZfOyUQSMmrZBewTz1b2XpftOo3p3ftks5sUrybgaJpZM4OtVXt .

[saurav12994]

if i use --patients aih_n_aih.txt file and remove [--aih ] i think this also works

On Sun, Aug 6, 2017 at 4:33 AM, Sergio Miranda Freire < notifications@github.com> wrote:

In Orbda DB there are seven tables: 1) hospitalisations - data related to patient's hospitalisations 2) the other tables are related to outpatients' data

We do not have a patient identifier in the hospitalisation table. In this table there is a field called n_aih that is a hashed hospitalisation identifier. We used it to generate an ehr-id for hospitalised patients. In fact a patient may have more than one hospitalisation, but we do not intend to be precise here.

In the outpatient tables, the ap_cnspcn field is a hashed patient identifier that is used to generate an ehr-id for outpatient patients.

There are two files in the project homepage apac_cnspcn.txt - contains all the values of the ap_cnspcn field in all outpatient tables aih_n_aih.txt - contains all the values of the n_aih field in the hospitalisation table

If you want to generate ehrs for hospitalisations (-aih option), you will have to make patientids point to the aih_n_aih.txt file Otherwise patientids will point to the apac_cnspcn.txt file

Hope it helps.

On Fri, Aug 4, 2017 at 3:39 AM, saurav12994 notifications@github.com wrote:

What is patientids in given query

java -Xmx8g -Dfile.encoding=UTF-8 -cp projectdir/bin/uber-sus- openehr-builder-1.0.1-SNAPSHOT.jar br.uerj.lampada.openehr. susbuilder.EHRGenerator --patients patientids --ehr-dir outputdir --type < ehr|version|composition > --format < json|xml > [--aih]

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3, or mute the thread https://github.com/notifications/unsubscribe-auth/ AEZfOyUQSMmrZBewTz1b2XpftOo3p3ftks5sUrybgaJpZM4OtVXt .

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3#issuecomment-320475223, or mute the thread https://github.com/notifications/unsubscribe-auth/Aalp8gqB6lwaSW1OSDvvzf55rLq5ciJIks5sVPTEgaJpZM4OtVXt .

[sergiofreire]

On Sun, Aug 6, 2017 at 3:13 AM, saurav12994 notifications@github.com wrote:

if i use --patients aih_n_aih.txt file and remove [--aih ] i think this also works

The program may run but should not generate any ehrs because the ids in aih_n_aih.txt will not be found in the outpatient tables. I ran the program the way you said and I got endless messages like this [2017-08-07 21:14:43.428] [945e7a811e8bd8f7f7baa4f99423d057]:: No composition created for patient ...

[saurav12994]

So, i should create folder name patientids and put both txt file in it and then run it

On 8 Aug 2017 5:48 a.m., "Sergio Miranda Freire" notifications@github.com wrote:

On Sun, Aug 6, 2017 at 3:13 AM, saurav12994 notifications@github.com wrote:

if i use --patients aih_n_aih.txt file and remove [--aih ] i think this also works

The program may run but should not generate any ehrs because the ids in aih_n_aih.txt will not be found in the outpatient tables. I ran the program the way you said and I got endless messages like this [2017-08-07 21:14:43.428] [945e7a811e8bd8f7f7baa4f99423d057]:: No composition created for patient ...

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3#issuecomment-320814994, or mute the thread https://github.com/notifications/unsubscribe-auth/Aalp8nLh7s7oPhjBFT4PwItYOI95dIwSks5sV6lEgaJpZM4OtVXt .

[sergiofreire]

On Tue, Aug 8, 2017 at 4:41 AM, saurav12994 notifications@github.com wrote:

So, i should create folder name patientids and put both txt file in it and then run it

You should run the program once with the option --aih and with the file aih_n_aih.txt as --patients It will generate the ehrs for the hospitalization table.

Then you run the program again without the option --aih and with the file apac_cnspcn.txt as --patients It will generate the ehrs for the outpatient tables.

On 8 Aug 2017 5:48 a.m., "Sergio Miranda Freire" <notifications@github.com

wrote:

On Sun, Aug 6, 2017 at 3:13 AM, saurav12994 notifications@github.com wrote:

if i use --patients aih_n_aih.txt file and remove [--aih ] i think this also works

The program may run but should not generate any ehrs because the ids in aih_n_aih.txt will not be found in the outpatient tables. I ran the program the way you said and I got endless messages like this [2017-08-07 21:14:43.428] [945e7a811e8bd8f7f7baa4f99423d057]:: No composition created for patient ...

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3#i ssuecomment-320814994, or mute the thread https://github.com/notifications/unsubscribe-auth/Aalp8nLh7 s7oPhjBFT4PwItYOI95dIwSks5sV6lEgaJpZM4OtVXt .

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3#issuecomment-320877254, or mute the thread https://github.com/notifications/unsubscribe-auth/AEZfO-Sgsrw1BBLvQsLoQPuUBtgp5eVPks5sWBENgaJpZM4OtVXt .

[saurav12994]

can you share your builder.prop file please?

[sergiofreire]

It is the same as that in github, except for the connection parameters, of course.

On Sun, Aug 13, 2017 at 9:21 AM, saurav12994 notifications@github.com wrote:

can you share your builder.prop file please?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3#issuecomment-322038854, or mute the thread https://github.com/notifications/unsubscribe-auth/AEZfO-7BcalNqye-S7lBr47f-zryeiVCks5sXuphgaJpZM4OtVXt .

[saurav12994]

i waant to know that which password you use because in linux postgresql create databse without password , so i am little bit confused

On Tue, Aug 15, 2017 at 5:52 AM, Sergio Miranda Freire < notifications@github.com> wrote:

It is the same as that in github, except for the connection parameters, of course.

On Sun, Aug 13, 2017 at 9:21 AM, saurav12994 notifications@github.com wrote:

can you share your builder.prop file please?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3# issuecomment-322038854, or mute the thread https://github.com/notifications/unsubscribe- auth/AEZfO-7BcalNqye-S7lBr47f-zryeiVCks5sXuphgaJpZM4OtVXt

.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3#issuecomment-322344741, or mute the thread https://github.com/notifications/unsubscribe-auth/Aalp8pz6IaA32NE5ITKd-rMeFiJhIq5Rks5sYOTYgaJpZM4OtVXt .

[sergiofreire]

See this link on how to set the postgres password http://suite.opengeo.org/docs/latest/dataadmin/pgGettingStarted/firstconnect.html

On Mon, Aug 14, 2017 at 11:49 PM, saurav12994 notifications@github.com wrote:

i waant to know that which password you use because in linux postgresql create databse without password , so i am little bit confused

On Tue, Aug 15, 2017 at 5:52 AM, Sergio Miranda Freire < notifications@github.com> wrote:

It is the same as that in github, except for the connection parameters, of course.

On Sun, Aug 13, 2017 at 9:21 AM, saurav12994 notifications@github.com wrote:

can you share your builder.prop file please?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3# issuecomment-322038854, or mute the thread https://github.com/notifications/unsubscribe- auth/AEZfO-7BcalNqye-S7lBr47f-zryeiVCks5sXuphgaJpZM4OtVXt

.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3# issuecomment-322344741, or mute the thread https://github.com/notifications/unsubscribe-auth/Aalp8pz6IaA32NE5ITKd- rMeFiJhIq5Rks5sYOTYgaJpZM4OtVXt .

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3#issuecomment-322363519, or mute the thread https://github.com/notifications/unsubscribe-auth/AEZfOzDo46sZHMRmf0dOFW4whAOl2ok2ks5sYQc5gaJpZM4OtVXt .

[saurav12994]

what is patientids ? I don't get any file named patientids

[saurav12994]

please share your builder. prop file of your windows system i want to check connection parameter and please share your project directory folder. I will be highly obliged if you help me

[sergiofreire]

PostgreSQL

db.url=jdbc:postgresql://localhost:5432/orbda db.username=postgres db.password=*****

pretty.print=false log.step=10000

archetype.repository=./repository/archetypes template.repository=./repository/templates terminology.file=./repository/terminologies/terminology.csv

log.config=log4j.properties

On Mon, Aug 28, 2017 at 7:08 PM, saurav12994 notifications@github.com wrote:

please share your builder. prop file i want to check connection parameter

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3#issuecomment-325497541, or mute the thread https://github.com/notifications/unsubscribe-auth/AEZfO7agQ7xAqwow1C8-yPAWh_-aOAXLks5sczpygaJpZM4OtVXt .

[sergiofreire]

You have made this question before and I have already replied to it. See previous e-mails. patientids points to a file, either containing hospitalizations ids or outpatient ids.

On Mon, Aug 28, 2017 at 6:44 PM, saurav12994 notifications@github.com wrote:

[image: image] https://user-images.githubusercontent.com/27879922/29795023-0f0487be-8c68-11e7-854a-068e1c2d0348.png what is patientids ?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3#issuecomment-325491888, or mute the thread https://github.com/notifications/unsubscribe-auth/AEZfO1bIk1UxrYaCq-dta_YmTUUJXSfJks5sczS3gaJpZM4OtVXt .

[saurav12994]

archetype.repository=./repository/archetypes template.repository=./repository/templates terminology.file=./repository/terminologies/terminology.csv

does i need to change in above line when i am doing project in windows because ./abc/abc is used in linux while we use abc\abc in windows but when i tried to change it it gives me error can't file

On Wed, Aug 30, 2017 at 5:06 AM, Sergio Miranda Freire < notifications@github.com> wrote:

You have made this question before and I have already replied to it. See previous e-mails. patientids points to a file, either containing hospitalizations ids or outpatient ids.

On Mon, Aug 28, 2017 at 6:44 PM, saurav12994 notifications@github.com wrote:

[image: image] https://user-images.githubusercontent.com/27879922/29795023-0f0487be- 8c68-11e7-854a-068e1c2d0348.png what is patientids ?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3# issuecomment-325491888, or mute the thread https://github.com/notifications/unsubscribe- auth/AEZfO1bIk1UxrYaCq-dta_YmTUUJXSfJks5sczS3gaJpZM4OtVXt

.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3#issuecomment-325834601, or mute the thread https://github.com/notifications/unsubscribe-auth/Aalp8kbUg8XvX8FJubTX9D-nteMKpZGwks5sdKBxgaJpZM4OtVXt .

[sergiofreire]

On Tue, Aug 29, 2017 at 8:42 PM, saurav12994 notifications@github.com wrote:

archetype.repository=./repository/archetypes template.repository=./repository/templates terminology.file=./repository/terminologies/terminology.csv

does i need to change in above line when i am doing project in windows because ./abc/abc is used in linux while we use abc\abc in windows

No! At least not in the windows machine that I used.

On Wed, Aug 30, 2017 at 5:06 AM, Sergio Miranda Freire < notifications@github.com> wrote:

You have made this question before and I have already replied to it. See previous e-mails. patientids points to a file, either containing hospitalizations ids or outpatient ids.

On Mon, Aug 28, 2017 at 6:44 PM, saurav12994 notifications@github.com wrote:

[image: image] https://user-images.githubusercontent.com/27879922/29795023-0f0487be- 8c68-11e7-854a-068e1c2d0348.png what is patientids ?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3# issuecomment-325491888, or mute the thread https://github.com/notifications/unsubscribe- auth/AEZfO1bIk1UxrYaCq-dta_YmTUUJXSfJks5sczS3gaJpZM4OtVXt

.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3# issuecomment-325834601, or mute the thread https://github.com/notifications/unsubscribe- auth/Aalp8kbUg8XvX8FJubTX9D-nteMKpZGwks5sdKBxgaJpZM4OtVXt .

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/dhteodoro/sus-openehr-builder/issues/3#issuecomment-325835612, or mute the thread https://github.com/notifications/unsubscribe-auth/AEZfO9rU4VqfEW69b-KmkiPr3vX0BcQ9ks5sdKHwgaJpZM4OtVXt .

[saurav12994]

What is minimum requirements of pc to run this project like RAM, Java version etc?