help with DHIS2 (uploading table?)

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

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@ncp.org.ph 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@lists.launchpad.net

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

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