Re: [Dhis2-users] Data values import

2017-01-17 Thread Marc Garnica
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 so

Re: [Dhis2-users] Data values import

2017-01-16 Thread Marc Garnica
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' attribut

Re: [Dhis2-users] Data values import

2017-01-16 Thread Jason Pickering
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. Messi

Re: [Dhis2-users] Data values import

2017-01-16 Thread Marc Garnica
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 d

Re: [Dhis2-users] Data values import

2017-01-16 Thread Lars Helge Ă˜verland
On Mon, Jan 16, 2017 at 12:11 PM, Marc Garnica 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 wa

Re: [Dhis2-users] Data values import

2017-01-16 Thread Jason Pickering
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 chec

Re: [Dhis2-users] Data values import

2017-01-16 Thread Marc Garnica
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 m

Re: [Dhis2-users] Data values import

2017-01-16 Thread Jason Pickering
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 combinatio

Re: [Dhis2-users] Data values import

2017-01-16 Thread Marc Garnica
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

Re: [Dhis2-users] Data values import

2017-01-16 Thread Marc Garnica
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 : > https://docs.dhis2.org/master/en/user/html/ch30.html > > On Mon, Jan 16, 2017 at 11:58 AM, R

Re: [Dhis2-users] Data values import

2017-01-16 Thread Marc Garnica
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

Re: [Dhis2-users] Data values import

2017-01-16 Thread Jason Pickering
https://docs.dhis2.org/master/en/user/html/ch30.html On Mon, Jan 16, 2017 at 11:58 AM, Raminosoa Rabemanantsoa, Tantely < tramino...@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, >

[Dhis2-users] Data values import

2017-01-16 Thread Marc Garnica
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

Re: [Dhis2-users] Data values import

2017-01-16 Thread Raminosoa Rabemanantsoa, Tantely
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 wrote: > Hi all, > > We are transferring data values from one DHIS2 instance to another and we > are experi