2.0 to 1.4

Hi,

Thanks Knut.

I am not sure if DHIS1.4 imports IXF as it currently doesn't support pure xml - a feature to be implemented when support for Acess 2000 is dropped.
But I am not really sure - I have copied Calle here - Pls, is it supported?

The second (ODBC) option is something to consider really.
But there is a third option one may want to look into before that - importing data formatted in excel.
It would be nice...this two-way data interchange.

Thanks.

Best regards,
Ime

···

--- On Sun, 5/17/09, Knut Staring <knutst@gmail.com> wrote:

Hi,

Thanks Knut.

I am not sure if DHIS1.4 imports IXF as it currently doesn’t support pure xml - a feature to be implemented when support for Acess 2000 is dropped.

Not sure if this relates to pure xml - 1.4 exports to IXF.

But I am not really sure - I have copied Calle here - Pls, is it supported?

The second (ODBC) option is something to consider really.

But there is a third option one may want to look into before that - importing data formatted in excel.

Does 1.4 support import from Excel templates? I agree that is a highly desirable feature, which we are planning to implement in 2.0.

It would be nice…this two-way data interchange.

Indeed, many things would be nice to have… so there’s a need (for the 1.4 team in this case) to prioritize. I don’t think the need for this has arisen before…why do you need it?

Knut

···

On Sun, May 17, 2009 at 4:10 PM, Ime Asangansi asangansi@yahoo.com wrote:

Thanks.

Best regards,
Ime

— On Sun, 5/17/09, Knut Staring knutst@gmail.com wrote:

From: Knut Staring knutst@gmail.com
Subject: Re: [Dhis2-devs] 2.0 to 1.4
To: “Ime Asangansi” asangansi@yahoo.com

Cc: “Dhis2” dhis2-devs@lists.launchpad.net
Date: Sunday, May 17, 2009, 9:32 AM

On Sun, May 17, 2009 at 1:12 AM, Ime Asangansi <asangansi@yahoo.com> wrote:

Hi people,

Please does anyone have suggestions for getting data from dhis 2.0 into dhis 1.4?

Off the top of my head:

  1. If 1.4 can import from IXF, you can do an export to IXF from DHIS 2.
  1. Create an ODBC connection to DHIS 2 (for Postgres or Mysql), and link the handful of key tables into Access, then create some append queries to move the data.

Knut

Thanks, in anticipation.

Cheers,

Ime


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

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


Cheers,
Knut Staring


Cheers,
Knut Staring

You’re right, we can export many types of metadata to 1.4. And we can export data values to Excel

For metadata, go to the Import - Export module and have a look at the options for DHIS 1.4 export under “Export to other systems”…

For datavalues, go to Reports -> Report Table and select the data you want. Save your selection, then click on the Excel icon in the list of Report tables.

Knut

···

On Sun, May 17, 2009 at 8:35 PM, Calle Hedberg calle.hedberg@gmail.com wrote:

1.4 can import various types of Excel data.

Off the top of my head - 2.0 can export data in 1.4 format, right?

And it should be small job to modify report tables to also support data values to csv with internal IDs in stead of the names (like we have today).
Then we would have what you need for a standard 1.4 import, 1 XML file with metadata in 14 format, and 1 csv file with data and internal identifiers referencing metadata in the XML file.

If we zip these two together with 7zip we have a standard 1.4 export file.

Ola

···

On Sun, May 17, 2009 at 8:43 PM, Knut Staring knutst@gmail.com wrote:

On Sun, May 17, 2009 at 8:35 PM, Calle Hedberg calle.hedberg@gmail.com wrote:

1.4 can import various types of Excel data.

Off the top of my head - 2.0 can export data in 1.4 format, right?

You’re right, we can export many types of metadata to 1.4. And we can export data values to Excel

For metadata, go to the Import - Export module and have a look at the options for DHIS 1.4 export under “Export to other systems”…

For datavalues, go to Reports -> Report Table and select the data you want. Save your selection, then click on the Excel icon in the list of Report tables.


Knut


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

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

Sorry, a quick question. Is anyone familiar with a quick procedure to clear all of the organization units (I need to clear the sample data)?

Thanks

Paul

Hi Paul,

The easiest way to clear all sample data is to start afresh with an empty database. Let me know if you need assistance on that.

Knut

···

On Wed, Jul 15, 2009 at 12:19 AM, Paul Amendola Paul.Amendola@theirc.org wrote:

Sorry, a quick question. Is anyone familiar with a quick procedure to clear all of the organization units (I need to clear the sample data)?

Thanks

Paul


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

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


Cheers,
Knut Staring