Expanding Display Columns under [Data element management]

Support - Assistance technique
1

Hi Devs

We have multiple users are working intensely on a new database and at times we are unsure of who has created or changed specific data elements. Is there a quick way to add data columns to the [Data element management] interface to easily see who created which data element and when it was last modified? At the moment we only have one display field: Name

Thanks,

Greg

···

Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

2

Hi Greg,

that is a good idea. We are actually rewriting all of the meta-data screens but in the short term I think we can add this to the “details” dialog? (Click on the row and then “show details”). Does that work?

Lars

···

On Mon, Jan 12, 2015 at 10:08 AM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Devs

We have multiple users are working intensely on a new database and at times we are unsure of who has created or changed specific data elements. Is there a quick way to add data columns to the [Data element management] interface to easily see who created which data element and when it was last modified? At the moment we only have one display field: Name

Thanks,

Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

Greg

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

3

Greg,

The data element table in DHIS2 contains three fields of relevance: created (date/time), lastupdated (date/time), and userid. Immediately after creation I would assume the first two are identical and the userid would belong to the person creating the data element. Subsequent updates would presumably update the lastupdated and userid fields with the date/time of the latest update and the user who did it. The created field is never again updated, presumably.

Which means that you cannot display the name of the person who created a data element - it’s relevant in terms of the data element design process, but not particularly relevant after that. If immediately required, then add the creator’s name to the description field - it can be deleted later.

Beyond that, in terms of the additional functionality being developed for the National Data Dictionary, it would make sense to store the creator’s name in the one of the additional NDD tables (just NOTE that the actual designer/creator of a data element or indicator - whether a person or a team - might not be the person who adds it to the system).

Regards

Calle

···

On 12 January 2015 at 11:08, Greg Rowles greg.rowles@gmail.com wrote:

Hi Devs

We have multiple users are working intensely on a new database and at times we are unsure of who has created or changed specific data elements. Is there a quick way to add data columns to the [Data element management] interface to easily see who created which data element and when it was last modified? At the moment we only have one display field: Name

Thanks,

Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

Greg

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19274

Email: calle.hedberg@gmail.com

Skype: calle_hedberg

4

Hi Lars

It’s a little tedious to cycle through each record without seeing who created it in a single overview/grid but hopefully that upgrade will make it easier!

Thanks,

Greg

···

On Mon, Jan 12, 2015 at 11:24 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Greg,

that is a good idea. We are actually rewriting all of the meta-data screens but in the short term I think we can add this to the “details” dialog? (Click on the row and then “show details”). Does that work?

Lars

–

On Mon, Jan 12, 2015 at 10:08 AM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Devs

We have multiple users are working intensely on a new database and at times we are unsure of who has created or changed specific data elements. Is there a quick way to add data columns to the [Data element management] interface to easily see who created which data element and when it was last modified? At the moment we only have one display field: Name

Thanks,

Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

Greg

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Health Information Systems Program

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

5

Hi Greg

The easy alternative/quick fix is a report, which an SQL View could feed. You could then easily control exactly what fields you want to appear.

Best regards,

Jason

···

On Mon, Jan 12, 2015 at 10:28 AM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Lars

It’s a little tedious to cycle through each record without seeing who created it in a single overview/grid but hopefully that upgrade will make it easier!

Thanks,

Greg

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–

On Mon, Jan 12, 2015 at 11:24 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Greg,

that is a good idea. We are actually rewriting all of the meta-data screens but in the short term I think we can add this to the “details” dialog? (Click on the row and then “show details”). Does that work?

Lars

–

Health Information Systems Program

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

On Mon, Jan 12, 2015 at 10:08 AM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Devs

We have multiple users are working intensely on a new database and at times we are unsure of who has created or changed specific data elements. Is there a quick way to add data columns to the [Data element management] interface to easily see who created which data element and when it was last modified? At the moment we only have one display field: Name

Thanks,

Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

Greg

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

6

Thanks Calle,

Its more for DHIS2 - I would assume more sophisticated security/audit data is available in the NDD…

Greg

···

On Mon, Jan 12, 2015 at 11:25 AM, Calle Hedberg calle.hedberg@gmail.com wrote:

Greg,

The data element table in DHIS2 contains three fields of relevance: created (date/time), lastupdated (date/time), and userid. Immediately after creation I would assume the first two are identical and the userid would belong to the person creating the data element. Subsequent updates would presumably update the lastupdated and userid fields with the date/time of the latest update and the user who did it. The created field is never again updated, presumably.

Which means that you cannot display the name of the person who created a data element - it’s relevant in terms of the data element design process, but not particularly relevant after that. If immediately required, then add the creator’s name to the description field - it can be deleted later.

Beyond that, in terms of the additional functionality being developed for the National Data Dictionary, it would make sense to store the creator’s name in the one of the additional NDD tables (just NOTE that the actual designer/creator of a data element or indicator - whether a person or a team - might not be the person who adds it to the system).

Regards

Calle

–

On 12 January 2015 at 11:08, Greg Rowles greg.rowles@gmail.com wrote:

Hi Devs

We have multiple users are working intensely on a new database and at times we are unsure of who has created or changed specific data elements. Is there a quick way to add data columns to the [Data element management] interface to easily see who created which data element and when it was last modified? At the moment we only have one display field: Name

Thanks,

Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

Greg

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19274

Email: calle.hedberg@gmail.com

Skype: calle_hedberg

Health Information Systems Program

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

7

Good idea! Thanks Jason!

···

On Mon, Jan 12, 2015 at 11:31 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Greg

The easy alternative/quick fix is a report, which an SQL View could feed. You could then easily control exactly what fields you want to appear.

Best regards,

Jason

–

On Mon, Jan 12, 2015 at 10:28 AM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Lars

It’s a little tedious to cycle through each record without seeing who created it in a single overview/grid but hopefully that upgrade will make it easier!

Thanks,

Greg

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Mon, Jan 12, 2015 at 11:24 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Greg,

that is a good idea. We are actually rewriting all of the meta-data screens but in the short term I think we can add this to the “details” dialog? (Click on the row and then “show details”). Does that work?

Lars

–

Health Information Systems Program

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

On Mon, Jan 12, 2015 at 10:08 AM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Devs

We have multiple users are working intensely on a new database and at times we are unsure of who has created or changed specific data elements. Is there a quick way to add data columns to the [Data element management] interface to easily see who created which data element and when it was last modified? At the moment we only have one display field: Name

Thanks,

Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

Greg

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Health Information Systems Program

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

8

Also, in terms of auditing of the data elements (which is not directly supported in DHIS2), you may want to consider implementing a trigger function directly in Postgresql, which could then be used to populate an audit table. If you really need to know who changed what and when, then this might be the only way at the moment. There is auditing done for datavalues at the moment, but there is no way to keep a history of changes to other objects,such as orgunits.

Regards,

Jason

···

On Mon, Jan 12, 2015 at 10:32 AM, Greg Rowles greg.rowles@gmail.com wrote:

Good idea! Thanks Jason!

–

On Mon, Jan 12, 2015 at 11:31 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Greg

The easy alternative/quick fix is a report, which an SQL View could feed. You could then easily control exactly what fields you want to appear.

Best regards,

Jason

–

Health Information Systems Program

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

On Mon, Jan 12, 2015 at 10:28 AM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Lars

It’s a little tedious to cycle through each record without seeing who created it in a single overview/grid but hopefully that upgrade will make it easier!

Thanks,

Greg

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Mon, Jan 12, 2015 at 11:24 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Greg,

that is a good idea. We are actually rewriting all of the meta-data screens but in the short term I think we can add this to the “details” dialog? (Click on the row and then “show details”). Does that work?

Lars

–

Health Information Systems Program

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

On Mon, Jan 12, 2015 at 10:08 AM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Devs

We have multiple users are working intensely on a new database and at times we are unsure of who has created or changed specific data elements. Is there a quick way to add data columns to the [Data element management] interface to easily see who created which data element and when it was last modified? At the moment we only have one display field: Name

Thanks,

Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

Greg

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049