MS Access to DHIS 2 Fwd: DHIS2

Hi Gabriel,

forwarding to users-list, I'm sure many have experiences with this.

Johan
···

-------- Original Message --------

Subject:
DHIS2
Date:
Thu, 21 Nov 2013 16:51:28 +0000
From:
Garcia, Mr. Gabriel (CAR)
To:
garciaga@CARPHA.ORGjohansa@ifi.uio.nojohansa@ifi.uio.no

Hi Johan

      Hope all is well, this is Gabriel  from

CARPHA. We have some databases that we need to convert from
Access to DHIS2. Can you put me on to someone who could assist
or guide us with this?

Regards,

Gabriel

Hi Gabriel,

are you converting only data, only metadata, or both?

Olav

···

-------- Original Message --------

Subject:
DHIS2
Date:
Thu, 21 Nov 2013 16:51:28 +0000
From:
Garcia, Mr. Gabriel (CAR)
To:
garciaga@CARPHA.ORGjohansa@ifi.uio.no johansa@ifi.uio.no

Hi Johan

Hope all is well, this is Gabriel from CARPHA. We have some databases that we need to convert from Access to DHIS2. Can you put me on to someone who could assist or guide us with this?

Regards,

Gabriel

https://launchpad.net/~dhis2-users
dhis2-users@lists.launchpad.net
https://launchpad.net/~dhis2-users
https://help.launchpad.net/ListHelp

Hi Gabriel,

There are of course many approaches to this. A few of the ones which I know about. The basic approach is going to be one of the following

  1. Injection of (meta)data with SQL directly into the database. This approach can be powerful, but demands precision and you must know the data model and application relatively well, as there are a lot of “gotchas” which are not always apparent directly from the model itself.

  2. Import of (meta)data with XML

  3. Import of data with CSV

There are many ways to get to this point of course. High-level programming languages (VB, Python, and R) are well suited to the task.

In terms of methods, here are a few ideas.

  1. I have heard to users somehow using Access itself to transform the data into something which can be used by DHIS2, such as the CSV import mechanism. I do now know about the details of this method, but others might be able to fill you in.

  2. It should be possible to bring the data in Excel and then transform it into either CSV or possible SQL statements, and then export this as a CSV or text file.

  3. My preferred mechanism is with the programming language R. I have included a number of trivial examples in the documentation, but the point here is that R can import data directly from Access databases, and allow you to manipulate/clean the data as needed, and eventually, transform it into CSV or XML for import into DHIS2.

This will often come down to what resources and capacities you have available to you. If you need more direct help, you can contact me directly for commercial support options.

Regards,

Jason

···

On Fri, Nov 22, 2013 at 2:30 PM, Olav Poppe olav.poppe@me.com wrote:

Hi Gabriel,
are you converting only data, only metadata, or both?

Olav

  1. nov. 2013 kl. 08:22 skrev Johan Ivar Sæbø johansa@ifi.uio.no:

Hi Gabriel,

forwarding to users-list, I’m sure many have experiences with this.

Johan

-------- Original Message --------
Subject:
DHIS2
Date:
Thu, 21 Nov 2013 16:51:28 +0000
From:
Garcia, Mr. Gabriel (CAR) garciaga@CARPHA.ORG
To:
johansa@ifi.uio.no johansa@ifi.uio.no

Hi Johan

Hope all is well, this is Gabriel from CARPHA. We have some databases that we need to convert from Access to DHIS2. Can you put me on to someone who could assist or guide us with this?

Regards,

Gabriel


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