Code in pivot table

Hi all,

Is it possible to include code associated with orgunit in a pivot table report? For instance nhabamba/02132 (where nhabamba it is orgunit´s name and 02132 its code). If it is possible how do I perform it in dhis2?

Kind regards

image

Hi Joao,

It’s not possible to include the code in pivot tables at the moment, and for this reason we (PSI) decided to systematically add the org unit’s code in parenthesis in the full name of the org unit. The short name only contains the actual name. So in your example, nhabamba would show up as “Nhabamba (02132)”

Bram

image

···

On 25 March 2015 at 10:10, Joao Mazuze Joao_Mazuze@chasssmt.com wrote:

Hi all,

Is it possible to include code associated with orgunit in a pivot table report? For instance nhabamba/02132 (where nhabamba it is orgunit´s name and 02132 its code). If it is possible how do I perform it in dhis2?

Kind regards


João Gabriel Mazuze

National Database Manager

Projecto CHASS-SMT

Abt Associates Inc.

Av. Marginal, 4067

Cidade de Maputo, Moçambique

Fax: (+ 258) 21486767

Tel: (+ 258) 21493525/6/8

Cell: (+258) 82 4236279

www.chasssmt.com

  • Somos um projecto financiado pelo PEPFAR-II, através da USAID, para reforçar o Sistema de Saúde das Provincias de Sofala, Manica e Tete. Pretendemos melhorar a ligação e integração do HIV com os Cuidados Primários de Saúde e outros a ele relacionados em coordenação com as Direcções Provinciais de Saúde e outros parceiros. Através do projecto CHASS-SMT, o Governo Americano apoia o Governo Moçambicano na melhoria da qualidade dos Serviços de Saúde no país.*

This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


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

Thank you very much, I will try to use the short name, so is it easy to concatenate name and short name in a pivot table?

Kind regards

image

···

Hi Joao,

It’s not possible to include the code in pivot tables at the moment, and for this reason we (PSI) decided to systematically add the org unit’s code in parenthesis in the full name of the org unit. The short name only contains the actual name. So in your example, nhabamba would show up as “Nhabamba (02132)”

Bram

On 25 March 2015 at 10:10, Joao Mazuze Joao_Mazuze@chasssmt.com wrote:

Hi all,

Is it possible to include code associated with orgunit in a pivot table report? For instance nhabamba/02132 (where nhabamba it is orgunit´s name and 02132 its code). If it is possible how do I perform it in dhis2?

Kind regards


João Gabriel Mazuze

National Database Manager

Projecto CHASS-SMT

Abt Associates Inc.

Av. Marginal, 4067

Cidade de Maputo, Moçambique

Fax: (+ 258) 21486767

Tel: (+ 258) 21493525/6/8

Cell: (+258) 82 4236279

www.chasssmt.com

  • Somos um projecto financiado pelo PEPFAR-II, através da USAID, para reforçar o Sistema de Saúde das Provincias de Sofala, Manica e Tete. Pretendemos melhorar a ligação e integração do HIV com os Cuidados Primários de Saúde e outros a ele relacionados em coordenação com as Direcções Provinciais de Saúde e outros parceiros. Através do projecto CHASS-SMT, o Governo Americano apoia o Governo Moçambicano na melhoria da qualidade dos Serviços de Saúde no país.*

This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


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

Hi Joao,
Why concatenate the two?I think in the new versions of DHIS2 the shortname appears automatically pivot table unless they are not defined.

image

···

2015-03-25 9:52 GMT+01:00 Joao Mazuze Joao_Mazuze@chasssmt.com:

Thank you very much, I will try to use the short name, so is it easy to concatenate name and short name in a pivot table?

Kind regards

From: Bram Piot [mailto:bram.piot@gmail.com]

Sent: 25 March 2015 10:34

To: Joao Mazuze

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Code in pivot table

Hi Joao,

It’s not possible to include the code in pivot tables at the moment, and for this reason we (PSI) decided to systematically add the org unit’s code in parenthesis in the full name of the org unit. The short name only contains the actual name. So in your example, nhabamba would show up as “Nhabamba (02132)”

Bram

On 25 March 2015 at 10:10, Joao Mazuze Joao_Mazuze@chasssmt.com wrote:

Hi all,

Is it possible to include code associated with orgunit in a pivot table report? For instance nhabamba/02132 (where nhabamba it is orgunit´s name and 02132 its code). If it is possible how do I perform it in dhis2?

Kind regards


João Gabriel Mazuze

National Database Manager

Projecto CHASS-SMT

Abt Associates Inc.

Av. Marginal, 4067

Cidade de Maputo, Moçambique

Fax: (+ 258) 21486767

Tel: (+ 258) 21493525/6/8

Cell: (+258) 82 4236279

www.chasssmt.com

  • Somos um projecto financiado pelo PEPFAR-II, através da USAID, para reforçar o Sistema de Saúde das Provincias de Sofala, Manica e Tete. Pretendemos melhorar a ligação e integração do HIV com os Cuidados Primários de Saúde e outros a ele relacionados em coordenação com as Direcções Provinciais de Saúde e outros parceiros. Através do projecto CHASS-SMT, o Governo Americano apoia o Governo Moçambicano na melhoria da qualidade dos Serviços de Saúde no país.*

This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


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


This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


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

Riddy NDOMA

Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/
Vous servir est mon désire (Serving you is my desire)

Okay, I will check. I am using 2.18 version, i´ll try to check whether this version does.

Kind regards

image

···

Hi Joao,

Why concatenate the two?I think in the new versions of DHIS2 the shortname appears automatically pivot table unless they are not defined.

2015-03-25 9:52 GMT+01:00 Joao Mazuze Joao_Mazuze@chasssmt.com:

Thank you very much, I will try to use the short name, so is it easy to concatenate name and short name in a pivot table?

Kind regards

From: Bram Piot [mailto:bram.piot@gmail.com]

Sent: 25 March 2015 10:34

To: Joao Mazuze

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Code in pivot table

Hi Joao,

It’s not possible to include the code in pivot tables at the moment, and for this reason we (PSI) decided to systematically add the org unit’s code in parenthesis in the full name of the org unit. The short name only contains the actual name. So in your example, nhabamba would show up as “Nhabamba (02132)”

Bram

On 25 March 2015 at 10:10, Joao Mazuze Joao_Mazuze@chasssmt.com wrote:

Hi all,

Is it possible to include code associated with orgunit in a pivot table report? For instance nhabamba/02132 (where nhabamba it is orgunit´s name and 02132 its code). If it is possible how do I perform it in dhis2?

Kind regards


João Gabriel Mazuze

National Database Manager

Projecto CHASS-SMT

Abt Associates Inc.

Av. Marginal, 4067

Cidade de Maputo, Moçambique

Fax: (+ 258) 21486767

Tel: (+ 258) 21493525/6/8

Cell: (+258) 82 4236279

www.chasssmt.com

  • Somos um projecto financiado pelo PEPFAR-II, através da USAID, para reforçar o Sistema de Saúde das Provincias de Sofala, Manica e Tete. Pretendemos melhorar a ligação e integração do HIV com os Cuidados Primários de Saúde e outros a ele relacionados em coordenação com as Direcções Provinciais de Saúde e outros parceiros. Através do projecto CHASS-SMT, o Governo Americano apoia o Governo Moçambicano na melhoria da qualidade dos Serviços de Saúde no país.*

This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


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


This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


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

Riddy NDOMA

Software Developer

Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma

Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)

Hi all

If you download to excel in csv format you get the codes.

Check it out

image

···

On 25 Mar 2015 12:19, “Joao Mazuze” Joao_Mazuze@chasssmt.com wrote:

Okay, I will check. I am using 2.18 version, i´ll try to check whether this version does.

Kind regards

From: riddy ndoma [mailto:riddyndoma@gmail.com]

Sent: 25 March 2015 11:03

To: Joao Mazuze

Cc: Bram Piot; dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Code in pivot table

Hi Joao,

Why concatenate the two?I think in the new versions of DHIS2 the shortname appears automatically pivot table unless they are not defined.

2015-03-25 9:52 GMT+01:00 Joao Mazuze Joao_Mazuze@chasssmt.com:

Thank you very much, I will try to use the short name, so is it easy to concatenate name and short name in a pivot table?

Kind regards

From: Bram Piot [mailto:bram.piot@gmail.com]

Sent: 25 March 2015 10:34

To: Joao Mazuze

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Code in pivot table

Hi Joao,

It’s not possible to include the code in pivot tables at the moment, and for this reason we (PSI) decided to systematically add the org unit’s code in parenthesis in the full name of the org unit. The short name only contains the actual name. So in your example, nhabamba would show up as “Nhabamba (02132)”

Bram

On 25 March 2015 at 10:10, Joao Mazuze Joao_Mazuze@chasssmt.com wrote:

Hi all,

Is it possible to include code associated with orgunit in a pivot table report? For instance nhabamba/02132 (where nhabamba it is orgunit´s name and 02132 its code). If it is possible how do I perform it in dhis2?

Kind regards


João Gabriel Mazuze

National Database Manager

Projecto CHASS-SMT

Abt Associates Inc.

Av. Marginal, 4067

Cidade de Maputo, Moçambique

Fax: (+ 258) 21486767

Tel: (+ 258) 21493525/6/8

Cell: (+258) 82 4236279

www.chasssmt.com

Description: Description: Description: Description: Description: Description: Description: Description: Description: Logotipo CHASS-SMT

  • Somos um projecto financiado pelo PEPFAR-II, através da USAID, para reforçar o Sistema de Saúde das Provincias de Sofala, Manica e Tete. Pretendemos melhorar a ligação e integração do HIV com os Cuidados Primários de Saúde e outros a ele relacionados em coordenação com as Direcções Provinciais de Saúde e outros parceiros. Através do projecto CHASS-SMT, o Governo Americano apoia o Governo Moçambicano na melhoria da qualidade dos Serviços de Saúde no país.*

This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


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


This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


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

Riddy NDOMA

Software Developer

Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma

Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)


This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


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

Thanks guys, it solved my problem.

Best regards

Joao

image

···

On 25 Mar 2015 12:19, “Joao Mazuze” Joao_Mazuze@chasssmt.com wrote:

Okay, I will check. I am using 2.18 version, i´ll try to check whether this version does.

Kind regards

From: riddy ndoma [mailto:riddyndoma@gmail.com]

Sent: 25 March 2015 11:03

To: Joao Mazuze

Cc: Bram Piot;
dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Code in pivot table

Hi Joao,

Why concatenate the two?I think in the new versions of DHIS2 the shortname appears automatically pivot table unless they are not defined.

2015-03-25 9:52 GMT+01:00 Joao Mazuze Joao_Mazuze@chasssmt.com:

Thank you very much, I will try to use the short name, so is it easy to concatenate name and short name in a pivot table?

Kind regards

From: Bram Piot [mailto:bram.piot@gmail.com]

Sent: 25 March 2015 10:34

To: Joao Mazuze

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Code in pivot table

Hi Joao,

It’s not possible to include the code in pivot tables at the moment, and for this reason we (PSI) decided to systematically add the org unit’s code in parenthesis in the full name of the org unit. The short name only contains the actual name. So in your example, nhabamba would show up as “Nhabamba (02132)”

Bram

On 25 March 2015 at 10:10, Joao Mazuze Joao_Mazuze@chasssmt.com wrote:

Hi all,

Is it possible to include code associated with orgunit in a pivot table report? For instance nhabamba/02132 (where nhabamba it is orgunit´s name and 02132 its code). If it is possible how do I perform it in dhis2?

Kind regards


João Gabriel Mazuze

National Database Manager

Projecto CHASS-SMT

Abt Associates Inc.

Av. Marginal, 4067

Cidade de Maputo, Moçambique

Fax: (+ 258) 21486767

Tel: (+ 258) 21493525/6/8

Cell: (+258) 82 4236279

www.chasssmt.com

  • Somos um projecto financiado pelo PEPFAR-II, através da USAID, para reforçar o Sistema de Saúde das Provincias de Sofala, Manica e Tete. Pretendemos melhorar a ligação e integração do HIV com os Cuidados Primários de Saúde e outros a ele relacionados em coordenação com as Direcções Provinciais de Saúde e outros parceiros. Através do projecto CHASS-SMT, o Governo Americano apoia o Governo Moçambicano na melhoria da qualidade dos Serviços de Saúde no país.*

This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


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


This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


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

Riddy NDOMA

Software Developer

Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma

Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)


This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


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