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:
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?
Please does anyone have suggestions for getting data from dhis 2.0 into dhis 1.4?
Off the top of my head:
If 1.4 can import from IXF, you can do an export to IXF from DHIS 2.
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.
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.
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:
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.