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 < ztolent...@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 > >
_______________________________________________ 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