Ah yes, of course. Thanks!
For me, I have individual codes for these data elements (population by age and sex), but previously I had them stored as individual variables rather than dimensions of the population variable. This time around I’m trying to store them in the “right” way as dimensions, which seems more logical. (I hope I don’t get bit down the road for this…) For my use so far, this is a one-off data import exercise, but I could imagine scenarios where one would like to import more frequently from a database that stores them as individual variables as mine did. However, seeing as how these data would probably come from different systems that use different coding schemes, perhaps a mapping exercise would be necessary anyway. I’ll let you know if I run into that hurdle.
···
From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: 01 May 2012 19:48
To: Hiatt, Mr Tom (WPRO)
Cc:
dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] [Dhis2-devs] DHIS version 2.8 released
Another good question. The list of category option combos can be viewed from the web api, e.g. here:
http://apps.dhis2.org/demo/api/categoryOptionCombos
(It is linked from the entry point like the rest of the resources here: http://apps.dhis2.org/demo/api)
We have not implemented configurable id scheme for category option combo since it is a DHIS construct and it is likely no other system will have a notion of it. Check if using the DHIS ids will be sufficient for you. If not we can implement custom id scheme here too.
Lars
On Tue, May 1, 2012 at 1:16 PM, Hiatt, Mr Tom (WPRO) hiattt@wpro.who.int wrote:
Thanks, Lars. That’s clear, I’ll give it a try again.
Just out of curiosity, I noted that there isn’t a place to use my own codes for category combinations (tell me if I’m missing something). I grabbed the UIDs for these by entering some dummy data, exporting to CSV and then back-mapping the UIDs using the dummy data as ‘codes’. Is there a better way to see the UIDs for category combinations? Or would I need access to back end tables for that?
Thanks again,
Tom
From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: 01 May 2012 05:24
To: Hiatt, Mr Tom (WPRO)
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] [Dhis2-devs] DHIS version 2.8 released
Hi Tom,
good question. The id scheme feature was only implemented in the Web API and not in the import user interface at the time of release due to time pressure.
I have now implemented those features and back-ported to 2.8. You can view the demo or download the WAR file again at dhis2.org/downloads.
In the XML/CSV data import you can now click “More options” and then select which id scheme to use for data elements and org units. For instance, if you select “code” as org unit id scheme, the orgUnit property in the XML data records will be matched on the code property of the org units in the target database.
After the import is complete you can click “view import summary” to get information about the outcome of the process.
best regards,
Lars
On Mon, Apr 30, 2012 at 11:02 AM, Hiatt, Mr Tom (WPRO) hiattt@wpro.who.int wrote:
Congratulations from me as well for the new release and I’m also welcoming the timely addition of CSV import!
I’ve just been trying to import population data, and although it said the import was successful the updated values don’t appear. I think it is because I have used the custom codes of units and data elements rather than the “uid”. In the documentation it says “Refers to uid by default, can also be name and code based on selected id scheme”. Is there a way I can change the id scheme to be code based (using my codes)? If not, how can I look up the codes DHIS uses (as in the example in the documentation)?
Thanks,
Tom
From: dhis2-users-bounces+hiattt=wpro.who.int@lists.launchpad.net
[mailto:dhis2-users-bounces+hiattt=wpro.who.int@lists.launchpad.net] On Behalf Of Shinichi Suzuki
Sent: 29 April 2012 16:42
To: ‘wanjala pepela’; ‘Lars Helge Øverland’; ‘DHIS 2 developers’; dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] [Dhis2-devs] DHIS version 2.8 released
Congratulations for all.
I am very happy to hear the “CSV data value import-export” capability on this.
It will encourage/expand new DHIS users as well as existing users who want import/export from/to other system.
Shinichi Suzuki
From: dhis2-devs-bounces+shin461=gmail.com@lists.launchpad.net
[mailto:dhis2-devs-bounces+shin461=gmail.com@lists.launchpad.net] On Behalf Of wanjala pepela
Sent: Sunday, April 29, 2012 3:55 AM
To: Lars Helge Øverland; DHIS 2 developers; dhis2-users@lists.launchpad.net
Cc: Calle Hedberg; Karisa, Juma; Jim Setzer; Jackie Patrick; Gilbert Kanjama; Maitha Manyala; Arthur Heywood; James Grace; Jeff Takle
Subject: Re: [Dhis2-devs] [Dhis2-users] DHIS version 2.8 released
Congratulations for the team. We also expected an Inpatient patient level.
PEPELA WANJALA
MINISTRY OF HEALTH HEADQUARTERS
HEALTH INFORMATION SYSTEM
AFYA HOUSE, HIS LG 37
P.OBOX 30016, NAIROBI, KENYA
TEL: +254 (020) 2717077 EXT 45097
CELL: +254 (0) 722375633 or 0202033363
EMAIL: wanjala2p@yahoo.com
** hmis@health.go.ke**
***![]()
***"HealthInformation Management - Making a World of Difference”
From: Lars Helge Øverland larshelge@gmail.com
To: DHIS 2 developers dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net
Cc: Calle Hedberg calle.hedberg@gmail.com; Arthur Heywood arthur@hisp.org; Jim Setzer Jim_Setzer@afyainfo.org; “Karisa, Juma” jkarisa@futuresgroup.com; Jackie Patrick Jacqueline.patrick@clintonfoundation.org; Gilbert Kanjama gilbert@knowing.co.ke; Maitha Manyala Maitha_Manyala@afyainfo.org; Jeff Takle Jeff_Takle@abtassoc.com; James Grace james@graces.com; Greg Rowles greg.rowles@gmail.com
Sent: Saturday, April 28, 2012 1:12 PM
Subject: [Dhis2-users] DHIS version 2.8 released
Hi all,
DHIS version 2.8 is release. The news this time is:
- Data visualizer plugin: Plugin for embedding the dynamic charts you see in Data Visualizer module directly in Web pages. Data is loaded from the DHIS back-end server. Example here:
http://apps.dhis2.org/portal/plugin.html
Documentation here:
http://dhis2.org/doc/snapshot/en/user/html/ch24s07.html
- Tracker tabular report: Interactive analysis tool for all types of tracker data. Can display data element values and beneficiary attributes and identifiers. Lets you filter on any of the columns in a table and download the data to Excel and PDF. Follows the same user interface principles as Data Visualizer module. Check it out here, for instance by selecting the “Delivery returns” program, selecting org unit and data elements and clicking “Update”:
http://apps.dhis2.org/demo/dhis-web-caseentry/app/index.html
(Demo login is admin/district)
- Search and browse beneficiary history: See the complete history of a beneficiary from programs and single events by clicking on the blue info icon in the list of beneficiaries. See it here by going straight down in the org unit tree and selecting the first facility:
http://apps.dhis2.org/demo/dhis-web-caseentry/patient.action
- Dedicated import-export function for data values: You no longer risk messing up your meta-data when doing data value import. Data values are now matched on the stable identifiers of the meta-data (like data elements and org units).
This means that you can safely import data as records will either be imported if they match your meta-data or ignored if not. It also means that remote systems can change the names of data elements and org units and still be able to exchange data values with the central system - records are matched on the stable identifiers which cannot be changed in the user interface. See the demo:
http://apps.dhis2.org/demo/dhis-web-importexport/displayImportDataValueForm.action?importFormat=xml
- CSV data value import-export: Data can be imported and exported using the CSV format (as well as the DHIS XML format called DXF). This provides an easy way to bootstrap DHIS systems from external sources and achieve interoperability with legacy systems as CSV is very widespread and is easy to contstruct manually. Check it out here:
http://apps.dhis2.org/demo/dhis-web-importexport/displayDataValueExportForm.action
http://apps.dhis2.org/demo/dhis-web-importexport/displayImportDataValueForm.action?importFormat=csv
Documentation here:
http://dhis2.org/doc/snapshot/en/user/html/ch18s04.html
- Cumulative values in report tables: For each column you can include a cumulative value column by ticking “Include cumulative” in the add report table screen. This enabled you to make nice progress reports like this:
http://apps.dhis2.org/demo/api/reports/Kvg1AhYHM8Q/data.pdf?ou=ImspTQPwCqd
- Reporting rates aggregation over time: The data mart process is now producing aggregate reporting rates over time. This means for instance that you can get quarterly and yearly reporting rates for monthly data sets in reports, such as the one below. Reporting rates are also aggregated in parallel processes which means performance scales almost linearly with the available processor cores on your server.
http://apps.dhis2.org/demo/dhis-web-reporting/exportTable.action?uid=xqGIgjysoc6&pe=2012-01-01&ou=ImspTQPwCqd
- Org unit group set analysis in Data Visualizer: You can now do analysis on groups and create charts based for instance on facility type and ownership. In the organisation unit tab select a group set (e.g. Type) from the group set list and then the parent organisation unit. An example is here:
http://apps.dhis2.org/demo/dhis-web-visualizer/app/index.html?id=wLPFpNTTLE5
-Reporting rates in Data Visualizer: You can now create charts with reporting rates for all data sets by using the reporting rates tab in the left side menu. They can also be combined with indicators and data elements as you prefer:
http://apps.dhis2.org/demo/dhis-web-visualizer/app/index.html?id=MhZZglImm3o
- Baseline in Data Visualizer: New chart option for including a baseline in charts. Similar to the target line option.
http://apps.dhis2.org/demo/dhis-web-visualizer/app/index.html?id=aYRnuCBirzk
- Data on chart columns in Data Visualizer: New chart option for including corresponding data value figures next to each bar or column in charts.
http://apps.dhis2.org/demo/dhis-web-visualizer/app/index.html?id=YlSs2snF32u
-
Notifications in Data Visualizer: User feedback has been greatly improved. When trying to create a chart with show-stopping errors, like forgetting to select org units, a descriptive popup is displayed. For non-critical errors, like selecting many org units when the org unit dimension acts as filter, a descriptive message is displayed at the bottom bar.
-
Cache strategy: The analytic resources in the Web API, like report, report table, map, chart and document, can be cached on the client side according to a “cache strategy” system setting. Available options are no cache, cache until 6 AM next morning and cache for 2 weeks. Typically DHIS is set up to refresh the data mart nightly - this knowledge can be used to cache resources in the browsers of the users and thus improve latency, bandwith usage and reduce server load. It also enables you to include a HTTP proxy/cache in front of your server which will meet the demand of Web scale performance when using DHIS as a back-end for Web portals.
See the load time improvements by opening the dashboard module and clicking a few times on the “Dashboard” link in the left side menu, and by opening the GIS module and load the favorite “ANC 1 visit facility 2011” a few times:
http://apps.dhis2.org/demo/dhis-web-dashboard-integration/index.action
http://apps.dhis2.org/demo/dhis-web-mapping/mapping/index.html?id=LGLRaweu91m&base=googlehybrid
- Internationalization: The user interface is now completely translated to Portuguese and Vietnamese. You can change the user interface language here:
http://apps.dhis2.org/demo/dhis-web-maintenance-settings/userGeneralSettings.action
- SQL View download to Excel and CSV: Sql views are handy for producing custom reports and views of the database. They can now also be exported to Excel and CSV format and saved to your local computer. Check it out by clicking on the table icon next to “Facility overview”:
http://apps.dhis2.org/demo/dhis-web-maintenance-dataadmin/showSqlViewListForm.action
- Web API support for messages: Developers of third-party applications can now create new message conversations and reply to existing ones by interacting with the messageConversations resource in the Web API. The documentation has been generally improved and we encourage you to read it to see the new possibilities:
http://dhis2.org/doc/snapshot/en/user/html/ch24s05.html
http://dhis2.org/doc/snapshot/en/user/html/ch24.html
- System overview page: A page listing all available modules in the system can be accessed by clicking on the DHIS 2 icon in the top left corner. This page can also be set as start page in system settings:
http://apps.dhis2.org/demo/dhis-web-commons-about/modules.action
- We did not manage to finalize the full meta-data import-export function, this has been pushed to the next release. However the Web API is now fairly complete - all resources can be browsed here:
http://apps.dhis2.org/demo/api/resources
WAR file, Live package and demo database can be downloaded here:
http://dhis2.org/downloads
Documentation and Javadocs here:
http://dhis2.org/documentation
Source code branch available for checkout here:
https://code.launchpad.net/~dhis2-devs-core/dhis2/2.8
Portal demo can be found here:
http://apps.dhis2.org/portal/
best regards,
the DHIS 2 development team
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
This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.
Disclaimer:
This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.
If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.
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
This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.
Disclaimer:
This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.
If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.
This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.
Disclaimer:
This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.
If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.
*"HealthInformation Management - Making a World of Difference”