dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

We definitely need to be able to import both metadata and data from Excel
(.xlsx) templates, a kind of user friendly data loading mechanism. It's
something that has been talked about for years, but never prioritized.

The importing of data also requires functionality like HISP South Africa's
AntiPivot tool for normalization of matrices.

Knut

On Wed, Dec 5, 2012 at 3:00 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:

> OK found it.  This was actually working back in DHIS2.04 but I long since
> forgot about it (https://lists.launchpad.net/dhis2-devs/msg06490.html),
>
> Would need to change a few things to get this working again as quite a lot
> has changed between then and now.  But the attached is an example of how it
> looked then.
>
>
> On 5 December 2012 13:48, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:
>
>> I tend to use an approach similar to Morten but this does involve getting
>> data into an xml format which is not something that users will necessarily
>> have the background or tooling to easily do,
>>
>> Most of this data seems to be available in spreadsheet format most
>> typically Excel.  Unfortunately that's where the similarity ends.
>>  Everywhere has a different spreadsheet layout.  I did develop what I
>> thought might be a "standard" excel layout some time back which I could
>> import into dhis.  I would need to try and find it again.  Assuming users
>> would find it easier to transform data within excel (using techniques of
>> cut and paste and rearrange) to get the data into some sort of standard
>> sheet then this would be a feasible general approach.
>>
>>
>> On 5 December 2012 13:29, Ola Hodne Titlestad <olati@xxxxxxxxxx> wrote:
>>
>>> Hi,
>>>
>>> Populating the organisationunit table directly in the database is an OK
>>> approach when starting from scratch yes, at least on alternative approach
>>> to the web-api approach Morten suggested.
>>>
>>> The UID field you can leave blank and then DHIS will automatically
>>> populate missing UIDs on next DHIS startup as part of the startup routines.
>>>
>>> It can be a bit of a challenge to populate the parentid field. You need
>>> to make sure those parentids actually make up your hierarchy, so that the
>>> correct orgunits are linked.
>>>
>>> The internal id, organisationunitid should be populated using the
>>> nextval('hibernate_sequence') function in postgres to avoid duplicates.
>>>
>>> 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<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16>
>>>
>>>
>>> On 5 December 2012 14:20, ChangJames <jamesbjchang@xxxxxxxxxxx> wrote:
>>>
>>>>   Hi,
>>>>
>>>> Is there any easy way(/preferred way) to import Organization Units (New
>>>> ones) on blank DHIS2 system?
>>>> I have a list of organization units I like to add to the system, but
>>>> like to know if there is an alternative to the individual manual add using
>>>> DHIS UI.
>>>>
>>>> It seems there isn’t import function for this on DHIS, so I took a look
>>>> at datatable for inserting straight to DB.
>>>> But, the ‘OrganizationUnit’ table has ‘UID’ field.  How do I generate
>>>> that?  One of my data ‘jII07NoHiO5’ does seem like normal Uniquie
>>>> Identifier number format.
>>>> And is this, adding rows straight to datatable, a OK way of mass
>>>> importing the Organization Units on DHIS?
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> 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