Data values import

Hi all,

We are transferring data values from one DHIS2 instance to another and we are experiencing some troubles. Both instances have the same metadata, we exported the data from the source instance and run the import in the target instance.

The results from the import are correct and if we check the database the datavalues are there. Even more, if we query through the API for the data values for a specific data set, and orgunit and a period it gives us the same data values that the source instance give with the same query.

But then if we enter the data entry app or create a pivot table asking for this data, the data is not available.

DHIS2 2.25 build 8feec9a.

Has anyone experienced this? Hopefully we are missing something in the process.

Thank you very much in advance,

Marc

Hi Marc,

Have you already run an update of the data analytics (data mart) after importing data values in the new instance?

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

···

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Hi all,

We are transferring data values from one DHIS2 instance to another and we are experiencing some troubles. Both instances have the same metadata, we exported the data from the source instance and run the import in the target instance.

The results from the import are correct and if we check the database the datavalues are there. Even more, if we query through the API for the data values for a specific data set, and orgunit and a period it gives us the same data values that the source instance give with the same query.

But then if we enter the data entry app or create a pivot table asking for this data, the data is not available.

DHIS2 2.25 build 8feec9a.

Has anyone experienced this? Hopefully we are missing something in the process.

Thank you very much in advance,

Marc


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

https://docs.dhis2.org/master/en/user/html/ch30.html

···

On Mon, Jan 16, 2017 at 11:58 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hi Marc,

Have you already run an update of the data analytics (data mart) after importing data values in the new instance?

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Hi all,

We are transferring data values from one DHIS2 instance to another and we are experiencing some troubles. Both instances have the same metadata, we exported the data from the source instance and run the import in the target instance.

The results from the import are correct and if we check the database the datavalues are there. Even more, if we query through the API for the data values for a specific data set, and orgunit and a period it gives us the same data values that the source instance give with the same query.

But then if we enter the data entry app or create a pivot table asking for this data, the data is not available.

DHIS2 2.25 build 8feec9a.

Has anyone experienced this? Hopefully we are missing something in the process.

Thank you very much in advance,

Marc


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

I was assuming the daily run we have in the source instance but it’s true that we have not configured it yet in the target one. I will try it! Thanks

But also I thought that to visualise the data values at the data entry module it was not needed to update the data mart…

Thanks!

Marc

···

2017-01-16 11:58 GMT+01:00 Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org:

Hi Marc,

Have you already run an update of the data analytics (data mart) after importing data values in the new instance?

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Hi all,

We are transferring data values from one DHIS2 instance to another and we are experiencing some troubles. Both instances have the same metadata, we exported the data from the source instance and run the import in the target instance.

The results from the import are correct and if we check the database the datavalues are there. Even more, if we query through the API for the data values for a specific data set, and orgunit and a period it gives us the same data values that the source instance give with the same query.

But then if we enter the data entry app or create a pivot table asking for this data, the data is not available.

DHIS2 2.25 build 8feec9a.

Has anyone experienced this? Hopefully we are missing something in the process.

Thank you very much in advance,

Marc


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

Thanks Jason for the link, but I cannot event see the data values in the data entry form… Kind of weird right? I’m running the analytics now.

Regards,

Marc

···

2017-01-16 12:11 GMT+01:00 Jason Pickering jason.p.pickering@gmail.com:

https://docs.dhis2.org/master/en/user/html/ch30.html

On Mon, Jan 16, 2017 at 11:58 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hi Marc,

Have you already run an update of the data analytics (data mart) after importing data values in the new instance?

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Hi all,

We are transferring data values from one DHIS2 instance to another and we are experiencing some troubles. Both instances have the same metadata, we exported the data from the source instance and run the import in the target instance.

The results from the import are correct and if we check the database the datavalues are there. Even more, if we query through the API for the data values for a specific data set, and orgunit and a period it gives us the same data values that the source instance give with the same query.

But then if we enter the data entry app or create a pivot table asking for this data, the data is not available.

DHIS2 2.25 build 8feec9a.

Has anyone experienced this? Hopefully we are missing something in the process.

Thank you very much in advance,

Marc


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

Already run the analytics and the data values are not showing in the Data entry App, (neither in pivot tables). The query getDataValues.action does not return any of the data values. But we do have data values in the data base and we can query them through the API.

Marc

···

2017-01-16 12:12 GMT+01:00 Marc Garnica marcgarnica13@gmail.com:

Thanks Jason for the link, but I cannot event see the data values in the data entry form… Kind of weird right? I’m running the analytics now.

Regards,

Marc

2017-01-16 12:11 GMT+01:00 Jason Pickering jason.p.pickering@gmail.com:

https://docs.dhis2.org/master/en/user/html/ch30.html

On Mon, Jan 16, 2017 at 11:58 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hi Marc,

Have you already run an update of the data analytics (data mart) after importing data values in the new instance?

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Hi all,

We are transferring data values from one DHIS2 instance to another and we are experiencing some troubles. Both instances have the same metadata, we exported the data from the source instance and run the import in the target instance.

The results from the import are correct and if we check the database the datavalues are there. Even more, if we query through the API for the data values for a specific data set, and orgunit and a period it gives us the same data values that the source instance give with the same query.

But then if we enter the data entry app or create a pivot table asking for this data, the data is not available.

DHIS2 2.25 build 8feec9a.

Has anyone experienced this? Hopefully we are missing something in the process.

Thank you very much in advance,

Marc


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

I suspect, but am not sure, that you category option combinations are not the same in the two instances. Are you sure that this is the case? Otherwise, you will see the data in the data values table, but it may not show up in the data entry form itselt. Be sure that your category option combination UIDs are exactly the same between the two instances.

Regards,

Jason

···

On Mon, Jan 16, 2017 at 12:12 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Thanks Jason for the link, but I cannot event see the data values in the data entry form… Kind of weird right? I’m running the analytics now.

Regards,

Marc

2017-01-16 12:11 GMT+01:00 Jason Pickering jason.p.pickering@gmail.com:

https://docs.dhis2.org/master/en/user/html/ch30.html

On Mon, Jan 16, 2017 at 11:58 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hi Marc,

Have you already run an update of the data analytics (data mart) after importing data values in the new instance?

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Hi all,

We are transferring data values from one DHIS2 instance to another and we are experiencing some troubles. Both instances have the same metadata, we exported the data from the source instance and run the import in the target instance.

The results from the import are correct and if we check the database the datavalues are there. Even more, if we query through the API for the data values for a specific data set, and orgunit and a period it gives us the same data values that the source instance give with the same query.

But then if we enter the data entry app or create a pivot table asking for this data, the data is not available.

DHIS2 2.25 build 8feec9a.

Has anyone experienced this? Hopefully we are missing something in the process.

Thank you very much in advance,

Marc


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

The categoryOptionCombos ids are the same in both instances, checking the file exported from the source instances, there’s also a field called attributeOptionCombo which we don’t know how to check if it’s the same between both instance. This might be the source of the problem i guess.

How can we manage that. A quick pathc can be to see which is the attributeOptionCombo of some mannually created datavalues in the target instances and edit the datavalues file replacing this id.

Any thoughts?

Thanks!

Marc

···

2017-01-16 12:16 GMT+01:00 Jason Pickering jason.p.pickering@gmail.com:

I suspect, but am not sure, that you category option combinations are not the same in the two instances. Are you sure that this is the case? Otherwise, you will see the data in the data values table, but it may not show up in the data entry form itselt. Be sure that your category option combination UIDs are exactly the same between the two instances.

Regards,

Jason

On Mon, Jan 16, 2017 at 12:12 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Thanks Jason for the link, but I cannot event see the data values in the data entry form… Kind of weird right? I’m running the analytics now.

Regards,

Marc


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

2017-01-16 12:11 GMT+01:00 Jason Pickering jason.p.pickering@gmail.com:

https://docs.dhis2.org/master/en/user/html/ch30.html

On Mon, Jan 16, 2017 at 11:58 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hi Marc,

Have you already run an update of the data analytics (data mart) after importing data values in the new instance?

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Hi all,

We are transferring data values from one DHIS2 instance to another and we are experiencing some troubles. Both instances have the same metadata, we exported the data from the source instance and run the import in the target instance.

The results from the import are correct and if we check the database the datavalues are there. Even more, if we query through the API for the data values for a specific data set, and orgunit and a period it gives us the same data values that the source instance give with the same query.

But then if we enter the data entry app or create a pivot table asking for this data, the data is not available.

DHIS2 2.25 build 8feec9a.

Has anyone experienced this? Hopefully we are missing something in the process.

Thank you very much in advance,

Marc


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 should be set to the default UID. Be sure that this category option combo id is also the same in both target and source instances. In theory, this should not make a difference,but it might explain why there is data in the datavalue table, but nothing is showing up in data entry.

You can check to be sure they are the same in both instances with something like

https://play.dhis2.org/demo/api/categoryOptionCombos?filter=name:eq:default

In later versions of DHIS2, this is a constant, but in older versions, it may not be the same.

Regards,

Jason

···

On Mon, Jan 16, 2017 at 12:29 PM, Marc Garnica marcgarnica13@gmail.com wrote:

The categoryOptionCombos ids are the same in both instances, checking the file exported from the source instances, there’s also a field called attributeOptionCombo which we don’t know how to check if it’s the same between both instance. This might be the source of the problem i guess.

How can we manage that. A quick pathc can be to see which is the attributeOptionCombo of some mannually created datavalues in the target instances and edit the datavalues file replacing this id.

Any thoughts?

Thanks!

Marc

2017-01-16 12:16 GMT+01:00 Jason Pickering jason.p.pickering@gmail.com:

I suspect, but am not sure, that you category option combinations are not the same in the two instances. Are you sure that this is the case? Otherwise, you will see the data in the data values table, but it may not show up in the data entry form itselt. Be sure that your category option combination UIDs are exactly the same between the two instances.

Regards,

Jason

On Mon, Jan 16, 2017 at 12:12 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Thanks Jason for the link, but I cannot event see the data values in the data entry form… Kind of weird right? I’m running the analytics now.

Regards,

Marc


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

2017-01-16 12:11 GMT+01:00 Jason Pickering jason.p.pickering@gmail.com:

https://docs.dhis2.org/master/en/user/html/ch30.html

On Mon, Jan 16, 2017 at 11:58 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hi Marc,

Have you already run an update of the data analytics (data mart) after importing data values in the new instance?

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Hi all,

We are transferring data values from one DHIS2 instance to another and we are experiencing some troubles. Both instances have the same metadata, we exported the data from the source instance and run the import in the target instance.

The results from the import are correct and if we check the database the datavalues are there. Even more, if we query through the API for the data values for a specific data set, and orgunit and a period it gives us the same data values that the source instance give with the same query.

But then if we enter the data entry app or create a pivot table asking for this data, the data is not available.

DHIS2 2.25 build 8feec9a.

Has anyone experienced this? Hopefully we are missing something in the process.

Thank you very much in advance,

Marc


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

I was assuming the daily run we have in the source instance but it's true
that we have not configured it yet in the target one. I will try it! Thanks

But also I thought that to visualise the data values at the data entry
module it was not needed to update the data mart..

This is correct.

Then like Jason says, if you are using a non-default attribute option combo
in your source system, and the default/no attribute option combo in the
target system, this is a probably cause for data not appearing.

regards,

Lars

···

On Mon, Jan 16, 2017 at 12:11 PM, Marc Garnica <marcgarnica13@gmail.com> wrote:

Thanks!
Marc

2017-01-16 11:58 GMT+01:00 Raminosoa Rabemanantsoa, Tantely <
traminosoa@mikolo.org>:

Hi Marc,

Have you already run an update of the data analytics (data mart) after
importing data values in the new instance?

Thanks,

Tantely.

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica <marcgarnica13@gmail.com> >> wrote:

Hi all,

We are transferring data values from one DHIS2 instance to another and
we are experiencing some troubles. Both instances have the same metadata,
we exported the data from the source instance and run the import in the
target instance.

The results from the import are correct and if we check the database the
datavalues are there. Even more, if we query through the API for the data
values for a specific data set, and orgunit and a period it gives us the
same data values that the source instance give with the same query.

But then if we enter the data entry app or create a pivot table asking
for this data, the data is not available.

DHIS2 2.25 build 8feec9a.

Has anyone experienced this? Hopefully we are missing something in the
process.

Thank you very much in advance,

Marc

_______________________________________________
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 and its attachments are confidential and solely for the
intended recipients. If received in error, please delete them and notify
the sender via reply e-mail immediately.*

_______________________________________________
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

--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@dhis2.org
http://www.dhis2.org <https://www.dhis2.org/>

Close, but we cannot find the solution yet,

This is how it looks like a data value in the source instance:

“dataElement”:“IxbBQzytPgv”,“period”:“2014”,“orgUnit”:“oWNF4d3PK8C”,“categoryOptionCombo”:“psVSPLclyFj”,“attributeOptionCombo”:“Xr12mI7VPn3”,“value”:"1031

And this is how it looks like a data value mannually added in the target instance:

“dataElement”:“IxbBQzytPgv”,“period”:“2014”,“orgUnit”:“oWNF4d3PK8C”,“categoryOptionCombo”:“psVSPLclyFj”,“attributeOptionCombo”:“HoDiXsWulNy”,“value”:“3”

The only different value is the ATTRIBUTEOPTIONCOMBO, whichi entity does it referenciate? How can we force both instances to have the same id for attributeoptioncombo.

Thanks!

···

2017-01-16 12:55 GMT+01:00 Lars Helge Øverland lars@dhis2.org:

On Mon, Jan 16, 2017 at 12:11 PM, Marc Garnica marcgarnica13@gmail.com wrote:

I was assuming the daily run we have in the source instance but it’s true that we have not configured it yet in the target one. I will try it! Thanks

But also I thought that to visualise the data values at the data entry module it was not needed to update the data mart…

This is correct.

Then like Jason says, if you are using a non-default attribute option combo in your source system, and the default/no attribute option combo in the target system, this is a probably cause for data not appearing.

regards,

Lars

Thanks!

Marc


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

2017-01-16 11:58 GMT+01:00 Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org:

Hi Marc,

Have you already run an update of the data analytics (data mart) after importing data values in the new instance?

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Hi all,

We are transferring data values from one DHIS2 instance to another and we are experiencing some troubles. Both instances have the same metadata, we exported the data from the source instance and run the import in the target instance.

The results from the import are correct and if we check the database the datavalues are there. Even more, if we query through the API for the data values for a specific data set, and orgunit and a period it gives us the same data values that the source instance give with the same query.

But then if we enter the data entry app or create a pivot table asking for this data, the data is not available.

DHIS2 2.25 build 8feec9a.

Has anyone experienced this? Hopefully we are missing something in the process.

Thank you very much in advance,

Marc


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

You can try and reset the UID on the source system to the destination system, and see if that works.

I would only try this on a development server, and test everything very carefully.

UPDATE categoryoptioncombo set uid = ‘Xr12mI7VPn3’ where uid = ‘HoDiXsWulNy’;

After that, restart Tomcat.

Messing with the categorycombos is a really go way to mess up the system, so proceed carefully.

Regards,

Jason

···

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Close, but we cannot find the solution yet,

This is how it looks like a data value in the source instance:

“dataElement”:“IxbBQzytPgv”,“period”:“2014”,“orgUnit”:“oWNF4d3PK8C”,“categoryOptionCombo”:“psVSPLclyFj”,“attributeOptionCombo”:“Xr12mI7VPn3”,“value”:"1031

And this is how it looks like a data value mannually added in the target instance:

“dataElement”:“IxbBQzytPgv”,“period”:“2014”,“orgUnit”:“oWNF4d3PK8C”,“categoryOptionCombo”:“psVSPLclyFj”,“attributeOptionCombo”:“HoDiXsWulNy”,“value”:“3”

The only different value is the ATTRIBUTEOPTIONCOMBO, whichi entity does it referenciate? How can we force both instances to have the same id for attributeoptioncombo.

Thanks!


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

2017-01-16 12:55 GMT+01:00 Lars Helge Øverland lars@dhis2.org:

On Mon, Jan 16, 2017 at 12:11 PM, Marc Garnica marcgarnica13@gmail.com wrote:

I was assuming the daily run we have in the source instance but it’s true that we have not configured it yet in the target one. I will try it! Thanks

But also I thought that to visualise the data values at the data entry module it was not needed to update the data mart…

This is correct.

Then like Jason says, if you are using a non-default attribute option combo in your source system, and the default/no attribute option combo in the target system, this is a probably cause for data not appearing.

regards,

Lars

Thanks!

Marc


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

2017-01-16 11:58 GMT+01:00 Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org:

Hi Marc,

Have you already run an update of the data analytics (data mart) after importing data values in the new instance?

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Hi all,

We are transferring data values from one DHIS2 instance to another and we are experiencing some troubles. Both instances have the same metadata, we exported the data from the source instance and run the import in the target instance.

The results from the import are correct and if we check the database the datavalues are there. Even more, if we query through the API for the data values for a specific data set, and orgunit and a period it gives us the same data values that the source instance give with the same query.

But then if we enter the data entry app or create a pivot table asking for this data, the data is not available.

DHIS2 2.25 build 8feec9a.

Has anyone experienced this? Hopefully we are missing something in the process.

Thank you very much in advance,

Marc


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

I think we are still missing something, the data values added throught the import app from the source instance are linked to the ‘Xr12mI7VPn3’ category option combo which now is the default in the database. But somehow, the datavalues created mannually are still pointing to a ‘HoDiXsWulNy’ attributeOptionCombo.

What’s more, the system already has a ‘HoDiXsWulNy’ categoryOptionCombo which is not the default.

This attributeOptionCombo seems to be computed inside the query (what I can see from the console is that the getDataValues.action does not have any parameter called attributeOptionCombo).

Weird… thanks.

Marc

···

2017-01-16 13:58 GMT+01:00 Jason Pickering jason.p.pickering@gmail.com:

You can try and reset the UID on the source system to the destination system, and see if that works.

I would only try this on a development server, and test everything very carefully.

UPDATE categoryoptioncombo set uid = ‘Xr12mI7VPn3’ where uid = ‘HoDiXsWulNy’;

After that, restart Tomcat.

Messing with the categorycombos is a really go way to mess up the system, so proceed carefully.

Regards,

Jason

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Close, but we cannot find the solution yet,

This is how it looks like a data value in the source instance:

“dataElement”:“IxbBQzytPgv”,“period”:“2014”,“orgUnit”:“oWNF4d3PK8C”,“categoryOptionCombo”:“psVSPLclyFj”,“attributeOptionCombo”:“Xr12mI7VPn3”,“value”:"1031

And this is how it looks like a data value mannually added in the target instance:

“dataElement”:“IxbBQzytPgv”,“period”:“2014”,“orgUnit”:“oWNF4d3PK8C”,“categoryOptionCombo”:“psVSPLclyFj”,“attributeOptionCombo”:“HoDiXsWulNy”,“value”:“3”

The only different value is the ATTRIBUTEOPTIONCOMBO, whichi entity does it referenciate? How can we force both instances to have the same id for attributeoptioncombo.

Thanks!


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

2017-01-16 12:55 GMT+01:00 Lars Helge Øverland lars@dhis2.org:

On Mon, Jan 16, 2017 at 12:11 PM, Marc Garnica marcgarnica13@gmail.com wrote:

I was assuming the daily run we have in the source instance but it’s true that we have not configured it yet in the target one. I will try it! Thanks

But also I thought that to visualise the data values at the data entry module it was not needed to update the data mart…

This is correct.

Then like Jason says, if you are using a non-default attribute option combo in your source system, and the default/no attribute option combo in the target system, this is a probably cause for data not appearing.

regards,

Lars

Thanks!

Marc


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

2017-01-16 11:58 GMT+01:00 Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org:

Hi Marc,

Have you already run an update of the data analytics (data mart) after importing data values in the new instance?

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

On Mon, Jan 16, 2017 at 1:54 PM, Marc Garnica marcgarnica13@gmail.com wrote:

Hi all,

We are transferring data values from one DHIS2 instance to another and we are experiencing some troubles. Both instances have the same metadata, we exported the data from the source instance and run the import in the target instance.

The results from the import are correct and if we check the database the datavalues are there. Even more, if we query through the API for the data values for a specific data set, and orgunit and a period it gives us the same data values that the source instance give with the same query.

But then if we enter the data entry app or create a pivot table asking for this data, the data is not available.

DHIS2 2.25 build 8feec9a.

Has anyone experienced this? Hopefully we are missing something in the process.

Thank you very much in advance,

Marc


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

We are still having problems with the data import. Is there anyone who have managed to transfer data values from one instance to another? Its a key feature for us, not only to maintain two servers in our side (dev and www) but also to transfer/receive data from other instances.

I think that the source of the problem is that a DataSet export with dependencies does not include the Category Option Combinations, as we don’t have them in the target instance our custom data entry forms have undefined fields.

So to solve that we had to import the Category Option Combinations from one instance to other, but in the target instance we only have the categories and category options for the specified DataSet so all the categoryOptionCombos imported with no category combo associated are linked with the default one in the table Categorycombos_optioncombos. Then the attributeOptionCombo of any dataValue is one of this categoryOptionCombinations associated with the default (must see the code to find how the system computes it).

Deleting all this incorrect links in the table Categorycombos_optioncombos seems to be a practical solution but I think it will cause further problems in the future.

Thanks,

Marc