Re: [Dhis2-users] Patientdatavalue - value field is short
Hi - just to echo on Marko's comment: PSI is also considering the use of a large, free text field, for doctor/ nurse to write free text observations that we don't need to quantify, but we want to capture, so DHIS can work as a light electronic health record. We will try Knut's suggestion on the mean time. On Fri, Apr 26, 2013 at 8:48 AM, Lars Helge Øverland larshe...@gmail.comwrote: Hi Marko, we could consider it - the only problem is that we have chosen the approach of using one column for all types of values. Most values are short numbers and using text as column type over varchar with fixed length implies a performance penalty. I am not sure how significant that overhead is with latest versions of postgresql/mysql. We could check it out. I guess you could do like Knut suggests for now and change the column type manually. cheers Lars On Fri, Apr 26, 2013 at 5:29 AM, Marko David Garcia markodavi...@gmail.com wrote: Hi friends, in the table patientdatavalue the field value is varchar(255). Is possible change this field to a bigger type? We need insert long descriptions in this field. Thank you very much. -- Cordialmente, *Ing. Marko David Garcia M. * *Área de Sistemas integrados de Información Secretaría de Salud Departamental del Cauca * ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- *Rodolfo Meliá* *Principal* rme...@knowming.com www.knowming.com +1 708 872 7636 +44 777 576 4090 Skype: rod.melia Twitter: @RodolfoMelia https://twitter.com/RodolfoMelia Note: Please note my new email address, which I will be using for PSI related work: rme...@knowming.com ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Patientdatavalue - value field is short
Hi Marko and Rodolfo, We have a comment field available for the programinstance object. This is for general comments about a person in a program, a bit like a whiteboard that you can always see on top of the data entry form in Person Dashboard. This field is also limited to 255 characters, but we can extend it. We have a patientcomment object that is referenced in programinstance. Would this meet your needs or you need to have a comment per program stage instance (encounter/visit)? I guess we could link to a patientcomment from programstageinstance as well, and this way make comments available per stage instance? Ola -- Ola Hodne Titlestad (Mr) HISP Department of Informatics University of Oslo Mobile: +47 48069736 Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16 On 29 April 2013 21:02, Rodolfo Melia rme...@knowming.com wrote: Hi - just to echo on Marko's comment: PSI is also considering the use of a large, free text field, for doctor/ nurse to write free text observations that we don't need to quantify, but we want to capture, so DHIS can work as a light electronic health record. We will try Knut's suggestion on the mean time. On Fri, Apr 26, 2013 at 8:48 AM, Lars Helge Øverland larshe...@gmail.comwrote: Hi Marko, we could consider it - the only problem is that we have chosen the approach of using one column for all types of values. Most values are short numbers and using text as column type over varchar with fixed length implies a performance penalty. I am not sure how significant that overhead is with latest versions of postgresql/mysql. We could check it out. I guess you could do like Knut suggests for now and change the column type manually. cheers Lars On Fri, Apr 26, 2013 at 5:29 AM, Marko David Garcia markodavi...@gmail.com wrote: Hi friends, in the table patientdatavalue the field value is varchar(255). Is possible change this field to a bigger type? We need insert long descriptions in this field. Thank you very much. -- Cordialmente, *Ing. Marko David Garcia M. * *Área de Sistemas integrados de Información Secretaría de Salud Departamental del Cauca * ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- *Rodolfo Meliá* *Principal* rme...@knowming.com www.knowming.com +1 708 872 7636 +44 777 576 4090 Skype: rod.melia Twitter: @RodolfoMelia https://twitter.com/RodolfoMelia Note: Please note my new email address, which I will be using for PSI related work: rme...@knowming.com ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Patientdatavalue - value field is short
We are looking for a field at the encounter time - we wanted to create a massive entry space using a custom form, so the doctor/nurse can write whatever she/he wants, and limit structured information to 5-8 fields using option sets. On Mon, Apr 29, 2013 at 8:34 PM, Ola Hodne Titlestad ol...@ifi.uio.nowrote: Hi Marko and Rodolfo, We have a comment field available for the programinstance object. This is for general comments about a person in a program, a bit like a whiteboard that you can always see on top of the data entry form in Person Dashboard. This field is also limited to 255 characters, but we can extend it. We have a patientcomment object that is referenced in programinstance. Would this meet your needs or you need to have a comment per program stage instance (encounter/visit)? I guess we could link to a patientcomment from programstageinstance as well, and this way make comments available per stage instance? Ola -- Ola Hodne Titlestad (Mr) HISP Department of Informatics University of Oslo Mobile: +47 48069736 Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16 On 29 April 2013 21:02, Rodolfo Melia rme...@knowming.com wrote: Hi - just to echo on Marko's comment: PSI is also considering the use of a large, free text field, for doctor/ nurse to write free text observations that we don't need to quantify, but we want to capture, so DHIS can work as a light electronic health record. We will try Knut's suggestion on the mean time. On Fri, Apr 26, 2013 at 8:48 AM, Lars Helge Øverland larshe...@gmail.com wrote: Hi Marko, we could consider it - the only problem is that we have chosen the approach of using one column for all types of values. Most values are short numbers and using text as column type over varchar with fixed length implies a performance penalty. I am not sure how significant that overhead is with latest versions of postgresql/mysql. We could check it out. I guess you could do like Knut suggests for now and change the column type manually. cheers Lars On Fri, Apr 26, 2013 at 5:29 AM, Marko David Garcia markodavi...@gmail.com wrote: Hi friends, in the table patientdatavalue the field value is varchar(255). Is possible change this field to a bigger type? We need insert long descriptions in this field. Thank you very much. -- Cordialmente, *Ing. Marko David Garcia M. * *Área de Sistemas integrados de Información Secretaría de Salud Departamental del Cauca * ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- *Rodolfo Meliá* *Principal* rme...@knowming.com www.knowming.com +1 708 872 7636 +44 777 576 4090 Skype: rod.melia Twitter: @RodolfoMelia https://twitter.com/RodolfoMelia Note: Please note my new email address, which I will be using for PSI related work: rme...@knowming.com ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- *Rodolfo Meliá* *Principal* rme...@knowming.com www.knowming.com +1 708 872 7636 +44 777 576 4090 Skype: rod.melia Twitter: @RodolfoMelia https://twitter.com/RodolfoMelia Note: Please note my new email address, which I will be using for PSI related work: rme...@knowming.com ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Patientdatavalue - value field is short
Such a fielt could be used to create an event with a SOAP structure. JM El 29/04/2013, a las 14:42, Rodolfo Melia rme...@knowming.com escribió: We are looking for a field at the encounter time - we wanted to create a massive entry space using a custom form, so the doctor/nurse can write whatever she/he wants, and limit structured information to 5-8 fields using option sets. On Mon, Apr 29, 2013 at 8:34 PM, Ola Hodne Titlestad ol...@ifi.uio.no wrote: Hi Marko and Rodolfo, We have a comment field available for the programinstance object. This is for general comments about a person in a program, a bit like a whiteboard that you can always see on top of the data entry form in Person Dashboard. This field is also limited to 255 characters, but we can extend it. We have a patientcomment object that is referenced in programinstance. Would this meet your needs or you need to have a comment per program stage instance (encounter/visit)? I guess we could link to a patientcomment from programstageinstance as well, and this way make comments available per stage instance? Ola -- Ola Hodne Titlestad (Mr) HISP Department of Informatics University of Oslo Mobile: +47 48069736 Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link On 29 April 2013 21:02, Rodolfo Melia rme...@knowming.com wrote: Hi - just to echo on Marko's comment: PSI is also considering the use of a large, free text field, for doctor/ nurse to write free text observations that we don't need to quantify, but we want to capture, so DHIS can work as a light electronic health record. We will try Knut's suggestion on the mean time. On Fri, Apr 26, 2013 at 8:48 AM, Lars Helge Øverland larshe...@gmail.com wrote: Hi Marko, we could consider it - the only problem is that we have chosen the approach of using one column for all types of values. Most values are short numbers and using text as column type over varchar with fixed length implies a performance penalty. I am not sure how significant that overhead is with latest versions of postgresql/mysql. We could check it out. I guess you could do like Knut suggests for now and change the column type manually. cheers Lars On Fri, Apr 26, 2013 at 5:29 AM, Marko David Garcia markodavi...@gmail.com wrote: Hi friends, in the table patientdatavalue the field value is varchar(255). Is possible change this field to a bigger type? We need insert long descriptions in this field. Thank you very much. -- Cordialmente, Ing. Marko David Garcia M. Área de Sistemas integrados de Información Secretaría de Salud Departamental del Cauca ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- Rodolfo Meliá Principal rme...@knowming.com www.knowming.com +1 708 872 7636 +44 777 576 4090 Skype: rod.melia Twitter: @RodolfoMelia Note: Please note my new email address, which I will be using for PSI related work: rme...@knowming.com ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- Rodolfo Meliá Principal rme...@knowming.com www.knowming.com +1 708 872 7636 +44 777 576 4090 Skype: rod.melia Twitter: @RodolfoMelia Note: Please note my new email address, which I will be using for PSI related work: rme...@knowming.com ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Patientdatavalue - value field is short
Hi Marko, we could consider it - the only problem is that we have chosen the approach of using one column for all types of values. Most values are short numbers and using text as column type over varchar with fixed length implies a performance penalty. I am not sure how significant that overhead is with latest versions of postgresql/mysql. We could check it out. I guess you could do like Knut suggests for now and change the column type manually. cheers Lars On Fri, Apr 26, 2013 at 5:29 AM, Marko David Garcia markodavi...@gmail.comwrote: Hi friends, in the table patientdatavalue the field value is varchar(255). Is possible change this field to a bigger type? We need insert long descriptions in this field. Thank you very much. -- Cordialmente, *Ing. Marko David Garcia M. * *Área de Sistemas integrados de Información Secretaría de Salud Departamental del Cauca * ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] Patientdatavalue - value field is short
Hi friends, in the table patientdatavalue the field value is varchar(255). Is possible change this field to a bigger type? We need insert long descriptions in this field. Thank you very much. -- Cordialmente, *Ing. Marko David Garcia M. * *Área de Sistemas integrados de Información Secretaría de Salud Departamental del Cauca * ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Patientdatavalue - value field is short
Hi Marko, as a quick and very local fix, I suppose you could try and just increase the size directly in your own db Den 26. apr. 2013 05:29 skrev Marko David Garcia markodavi...@gmail.com følgende: Hi friends, in the table patientdatavalue the field value is varchar(255). Is possible change this field to a bigger type? We need insert long descriptions in this field. Thank you very much. -- Cordialmente, *Ing. Marko David Garcia M. * *Área de Sistemas integrados de Información Secretaría de Salud Departamental del Cauca * ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp