Exporting Persons and Programs

Support - Assistance technique
1

Hi Guys
I hope you are well.

As you probably know already, we are in the process of moving the data and programs of a few countries that have been working on the development server of PSI to the production server (v. 2.13), this task requires being able to export both persons with the corresponding enrollments to programs and multiple events/stages.

I tried to export events using the API and the systems always returns an empty response. Here’s an example of the request I’m using:

curl “http://localhost:8080/dhis/api/events?orgUnit=YypjoDjI7Zg&includeChildren=true&startDate=2013-10-01&endDate=2013-12-31&programStage=wxloTxBJMlq” -H “Content-Type:application/xml” -u [usr]:[pass] -v

No data is returned by the system and I also noticed that even though xml is specified, the empty response is in json { }

What is your recommendation to export and import persons and program enrollments?

By the way I see I can query the API for persons in one org Unit, that could take a while, it would be great if we could use “includeChildren”.

curl “http://localhost:8080/dhis/api/persons?orgUnit=YypjoDjI7Zg&includeChildren=true” -H “Content-Type:application/xml” -u [usr]:[pass] -v

The same as with events, api/persons returns the answer in json

Best regards,

JM

2

Hi,

includeChildren/includeDescendants is only available in 2.14 and newer. I will have a look and see if it can be backported to 2.13.

···

–
Morten

On Wed, Jan 22, 2014 at 6:23 AM, Juan Manuel Alcantara Acosta jmalcantara1@gmail.com wrote:

Hi Guys
I hope you are well.

As you probably know already, we are in the process of moving the data and programs of a few countries that have been working on the development server of PSI to the production server (v. 2.13), this task requires being able to export both persons with the corresponding enrollments to programs and multiple events/stages.

I tried to export events using the API and the systems always returns an empty response. Here’s an example of the request I’m using:

curl “http://localhost:8080/dhis/api/events?orgUnit=YypjoDjI7Zg&includeChildren=true&startDate=2013-10-01&endDate=2013-12-31&programStage=wxloTxBJMlq” -H “Content-Type:application/xml” -u [usr]:[pass] -v

No data is returned by the system and I also noticed that even though xml is specified, the empty response is in json { }

What is your recommendation to export and import persons and program enrollments?

By the way I see I can query the API for persons in one org Unit, that could take a while, it would be great if we could use “includeChildren”.

curl “http://localhost:8080/dhis/api/persons?orgUnit=YypjoDjI7Zg&includeChildren=true” -H “Content-Type:application/xml” -u [usr]:[pass] -v

The same as with events, api/persons returns the answer in json

Best regards,

JM

3

I have now backported this to 2.13. Please test it out. I did not backport the UI, so its only available in the web-api (/api/events).

If you are having issues getting the correct format, you can also use .xml/.json

includeChildren for persons might be good to have, but it would require a bit of work… maybe for 2.15

···

–
Morten

On Wed, Jan 22, 2014 at 4:39 PM, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi,

includeChildren/includeDescendants is only available in 2.14 and newer. I will have a look and see if it can be backported to 2.13.

–
Morten

On Wed, Jan 22, 2014 at 6:23 AM, Juan Manuel Alcantara Acosta jmalcantara1@gmail.com wrote:

Hi Guys
I hope you are well.

As you probably know already, we are in the process of moving the data and programs of a few countries that have been working on the development server of PSI to the production server (v. 2.13), this task requires being able to export both persons with the corresponding enrollments to programs and multiple events/stages.

I tried to export events using the API and the systems always returns an empty response. Here’s an example of the request I’m using:

curl “http://localhost:8080/dhis/api/events?orgUnit=YypjoDjI7Zg&includeChildren=true&startDate=2013-10-01&endDate=2013-12-31&programStage=wxloTxBJMlq” -H “Content-Type:application/xml” -u [usr]:[pass] -v

No data is returned by the system and I also noticed that even though xml is specified, the empty response is in json { }

What is your recommendation to export and import persons and program enrollments?

By the way I see I can query the API for persons in one org Unit, that could take a while, it would be great if we could use “includeChildren”.

curl “http://localhost:8080/dhis/api/persons?orgUnit=YypjoDjI7Zg&includeChildren=true” -H “Content-Type:application/xml” -u [usr]:[pass] -v

The same as with events, api/persons returns the answer in json

Best regards,

JM

4

Hello Morten

I teste it with v. 2.13 build 12953 dated 2014-01-26 and it didn’t work.

Best regards,

JM

···

–
Morten

On Wed, Jan 22, 2014 at 4:39 PM, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi,

includeChildren/includeDescendants is only available in 2.14 and newer. I will have a look and see if it can be backported to 2.13.

–
Morten

On Wed, Jan 22, 2014 at 6:23 AM, Juan Manuel Alcantara Acosta jmalcantara1@gmail.com wrote:

Hi Guys
I hope you are well.

As you probably know already, we are in the process of moving the data and programs of a few countries that have been working on the development server of PSI to the production server (v. 2.13), this task requires being able to export both persons with the corresponding enrollments to programs and multiple events/stages.

I tried to export events using the API and the systems always returns an empty response. Here’s an example of the request I’m using:

curl “http://localhost:8080/dhis/api/events?orgUnit=YypjoDjI7Zg&includeChildren=true&startDate=2013-10-01&endDate=2013-12-31&programStage=wxloTxBJMlq” -H “Content-Type:application/xml” -u [usr]:[pass] -v

No data is returned by the system and I also noticed that even though xml is specified, the empty response is in json { }

What is your recommendation to export and import persons and program enrollments?

By the way I see I can query the API for persons in one org Unit, that could take a while, it would be great if we could use “includeChildren”.

curl “http://localhost:8080/dhis/api/persons?orgUnit=YypjoDjI7Zg&includeChildren=true” -H “Content-Type:application/xml” -u [usr]:[pass] -v

The same as with events, api/persons returns the answer in json

Best regards,

JM

5

Can you give me the complete URL you are using?

···

–
Morten

On Thu, Jan 30, 2014 at 3:18 AM, Juan Manuel Alcantara Acosta jmalcantara1@gmail.com wrote:

Hello Morten

I teste it with v. 2.13 build 12953 dated 2014-01-26 and it didn’t work.

Best regards,

JM

El 22/01/2014, a las 05:31, Morten Olav Hansen mortenoh@gmail.com escribió:

I have now backported this to 2.13. Please test it out. I did not backport the UI, so its only available in the web-api (/api/events).

If you are having issues getting the correct format, you can also use .xml/.json

includeChildren for persons might be good to have, but it would require a bit of work… maybe for 2.15

–
Morten

On Wed, Jan 22, 2014 at 4:39 PM, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi,

includeChildren/includeDescendants is only available in 2.14 and newer. I will have a look and see if it can be backported to 2.13.

–
Morten

On Wed, Jan 22, 2014 at 6:23 AM, Juan Manuel Alcantara Acosta jmalcantara1@gmail.com wrote:

Hi Guys
I hope you are well.

As you probably know already, we are in the process of moving the data and programs of a few countries that have been working on the development server of PSI to the production server (v. 2.13), this task requires being able to export both persons with the corresponding enrollments to programs and multiple events/stages.

I tried to export events using the API and the systems always returns an empty response. Here’s an example of the request I’m using:

curl “http://localhost:8080/dhis/api/events?orgUnit=YypjoDjI7Zg&includeChildren=true&startDate=2013-10-01&endDate=2013-12-31&programStage=wxloTxBJMlq” -H “Content-Type:application/xml” -u [usr]:[pass] -v

No data is returned by the system and I also noticed that even though xml is specified, the empty response is in json { }

What is your recommendation to export and import persons and program enrollments?

By the way I see I can query the API for persons in one org Unit, that could take a while, it would be great if we could use “includeChildren”.

curl “http://localhost:8080/dhis/api/persons?orgUnit=YypjoDjI7Zg&includeChildren=true” -H “Content-Type:application/xml” -u [usr]:[pass] -v

The same as with events, api/persons returns the answer in json

Best regards,

JM