Question #231664

Hello,

my DHIS is Version: 2.12 installed on UBUNTU 12.04 LTS (32bit).
I am going to import some data in the CSV format.

According to this document, I can use in the field «org unit» name or code.
http://www.dhis2.org/doc/snapshot/es/user/html/ch17s04.html

When I load CSV file with “name” in org unit field (SERVICES → IMPORT-EXPORT → CSV DATA IMPORT (DRY RUN – YES)), I receive the error “ignored” for this name.

The example of my CSV file:
“dataelement”,“period”,“orgunit”,“categoryoptioncombo”,“value”,“storedby”,“timestamp”,“comment”,“followup”
“AzIkeEEMnWD”,“201303”,“London”,“lDg7pKq4CDk”,“4343”,“admin”,“2013-05-30”,“false”

Can we use name or code in the field «org unit» in CSV file for import?

Hi,

yes you can use uid, code and name as identifier scheme (strategory for matching meta-data). A caveat, the name property of organisation unit is not unique after 2.11 and we consider removing that option.

In your import, did you click “more options” and selected name as org unit id scheme? Are you are there is an org unit in your db with name “London”?

regards,

Lars

···

On Thu, Jul 4, 2013 at 1:25 PM, zebra_st@ukr.net wrote:

Hello,

my DHIS is Version: 2.12 installed on UBUNTU 12.04 LTS (32bit).
I am going to import some data in the CSV format.

According to this document, I can use in the field «org unit» name or code.
http://www.dhis2.org/doc/snapshot/es/user/html/ch17s04.html

When I load CSV file with “name” in org unit field (SERVICES → IMPORT-EXPORT → CSV DATA IMPORT (DRY RUN – YES)), I receive the error “ignored” for this name.

The example of my CSV file:

“dataelement”,“period”,“orgunit”,“categoryoptioncombo”,“value”,“storedby”,“timestamp”,“comment”,“followup”

“AzIkeEEMnWD”,“201303”,“London”,“lDg7pKq4CDk”,“4343”,“admin”,“2013-05-30”,“false”

Can we use name or code in the field «org unit» in CSV file for import?


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,

yes you can use uid, code and name as identifier scheme (strategory for
matching meta-data). A caveat, the name property of organisation unit is
not unique after 2.11 and we consider removing that option.

I actually would recommend we keep that option even though uniqueness of
names is (thankfully) no longer enforced by DHIS2. In a lot of situations,
names is all you have to match on, so it would be a pity to remove this
option.

It then becomes the user's responsibility to ensure uniqueness - but
perhaps we could aid the user by checking for uniqueness and sending out an
alert in case of duplicates? I think that would be the best solution.

Knut

···

On Fri, Jul 5, 2013 at 11:20 AM, Lars Helge Øverland <larshelge@gmail.com>wrote:

In your import, did you click "more options" and selected name as org unit
id scheme? Are you are there is an org unit in your db with name "London"?

regards,

Lars

On Thu, Jul 4, 2013 at 1:25 PM, <zebra_st@ukr.net> wrote:

Hello,

my DHIS is Version: 2.12 installed on UBUNTU 12.04 LTS (32bit).
I am going to import some data in the CSV format.

According to this document, I can use in the field «org unit» name or
code.
http://www.dhis2.org/doc/snapshot/es/user/html/ch17s04.html

When I load CSV file with “name” in org unit field (SERVICES ->
IMPORT-EXPORT -> CSV DATA IMPORT (DRY RUN – YES)), I receive the error
“ignored” for this name.

The example of my CSV file:
"dataelement","period","orgunit","categoryoptioncombo","value","storedby"
,"timestamp","comment","followup"
"AzIkeEEMnWD","201303","London","lDg7pKq4CDk","4343","admin","2013-
05-30","false"

Can we use name or code in the field «org unit» in CSV file for import?

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522

Hi Knut

···

On 5 July 2013 11:32, Knut Staring knutst@gmail.com wrote:

On Fri, Jul 5, 2013 at 11:20 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Names might be all you have to match on when importing orgunits, bootstrapping. But after this is done, I think data import should always be able to work with codes or uids.

Bob


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,

yes you can use uid, code and name as identifier scheme (strategory for matching meta-data). A caveat, the name property of organisation unit is not unique after 2.11 and we consider removing that option.

I actually would recommend we keep that option even though uniqueness of names is (thankfully) no longer enforced by DHIS2. In a lot of situations, names is all you have to match on, so it would be a pity to remove this option.

It then becomes the user’s responsibility to ensure uniqueness - but perhaps we could aid the user by checking for uniqueness and sending out an alert in case of duplicates? I think that would be the best solution.

Knut

In your import, did you click “more options” and selected name as org unit id scheme? Are you are there is an org unit in your db with name “London”?

regards,

Lars


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

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Thu, Jul 4, 2013 at 1:25 PM, zebra_st@ukr.net wrote:

Hello,

my DHIS is Version: 2.12 installed on UBUNTU 12.04 LTS (32bit).
I am going to import some data in the CSV format.

According to this document, I can use in the field «org unit» name or code.
http://www.dhis2.org/doc/snapshot/es/user/html/ch17s04.html

When I load CSV file with “name” in org unit field (SERVICES → IMPORT-EXPORT → CSV DATA IMPORT (DRY RUN – YES)), I receive the error “ignored” for this name.

The example of my CSV file:

“dataelement”,“period”,“orgunit”,“categoryoptioncombo”,“value”,“storedby”,“timestamp”,“comment”,“followup”

“AzIkeEEMnWD”,“201303”,“London”,“lDg7pKq4CDk”,“4343”,“admin”,“2013-05-30”,“false”

Can we use name or code in the field «org unit» in CSV file for import?


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,

thanks for your help.

I clicked “more options” and
chose “name” -
the import was successful.

What does “categoryoptioncombo” mean?

— Исходное сообщение —
От кого: “Bob Jolliffe” bobjolliffe@gmail.com
Дата: 5 июля 2013, 14:45:03

···

Hi Knut

On 5 July 2013 11:32, Knut Staring knutst@gmail.com wrote:

On Fri, Jul 5, 2013 at 11:20 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi,

yes you can use uid, code and name as identifier scheme (strategory for matching meta-data). A caveat, the name property of organisation unit is not unique after 2.11 and we consider removing that option.

I actually would recommend we keep that option even though uniqueness of names is (thankfully) no longer enforced by DHIS2. In a lot of situations, names is all you have to match on, so it would be a pity to remove this option.

Names might be all you have to match on when importing orgunits, bootstrapping. But after this is done, I think data import should always be able to work with codes or uids.

Bob

It then becomes the user’s responsibility to ensure uniqueness - but perhaps we could aid the user by checking for uniqueness and sending out an alert in case of duplicates? I think that would be the best solution.

Knut

In your import, did you click “more options” and selected name as org unit id scheme? Are you are there is an org unit in your db with name “London”?

regards,

Lars

On Thu, Jul 4, 2013 at 1:25 PM, zebra_st@ukr.net wrote:

Hello,

my DHIS is Version: 2.12 installed on UBUNTU 12.04 LTS (32bit).
I am going to import some data in the CSV format.

According to this document, I can use in the field «org unit» name or code.
http://www.dhis2.org/doc/snapshot/es/user/html/ch17s04.html

When I load CSV file with “name” in org unit field (SERVICES → IMPORT-EXPORT → CSV DATA IMPORT (DRY RUN – YES)), I receive the error “ignored” for this name.

The example of my CSV file:

“dataelement”,“period”,“orgunit”,“categoryoptioncombo”,“value”,“storedby”,“timestamp”,“comment”,“followup”

“AzIkeEEMnWD”,“201303”,“London”,“lDg7pKq4CDk”,“4343”,“admin”,“2013-05-30”,“false”

Can we use name or code in the field «org unit» in CSV file for import?


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

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


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