dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Zayd,

There is no automatic way to upload an Excel table containing codes into
DHIS2. The simplest way would  (I think in your case) be to transform the
Excel sheet to a series of update statements, and then execute this
directly in the DHIS2 database. You can probably use the "code" field of
the "organisationunit" table for this purpose.

I do not think it is possible for the user to type a code and begin to
enter data. The would need to select the organisation unit from the orgunit
tree on the left side of the data entry screen and then either the data.

I am not really sure about your second question. I suppose this is some
data for a particular organisational unit and period? If so, again, there
is no way to upload an Excel file with this type of data. You would need to
transform the data either to DXF (the XML format used by DHIS2) or inject
the data directly into the database.

Best regards,
Jason


On Wed, Jan 11, 2012 at 5:20 AM, Zayd Edrylson Tolentino <
ztolentino@xxxxxxxxxx> wrote:

> Hello!
>
> I would like to verify if it is possible for us to upload an entire table
> (in excel) to the database as a reference table. The table I will be
> uploading would contain the codes for each areas. This will be used as
> reference table so that in the system, when the user types the code, the
> area will be shown and vice versa.
>
> Or on a simpler note, I'd like to upload a table to be used as reference
> data for the whole system's data entry.
>
> Is this possible?
>
> Helpful response would be highly appreciated.
> Thank you very much!
>
> --
> Zayd Edrylson S. Tolentino
> Systems Administrator
> Information Systems Department
> Nutrition Center of the Philippines / Philippine Nutri-Foods Corp. / NCP
> Publishing Corp.
> 2332 Chino Roces Avenue Extension
> Fort Bonifacio, Taguig City 1630
> Tel No: 818-7397
>
> _______________________________________________
> 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
>
>