[Dhis2-devs] Request User Table in DHIS2

2017-07-25 Thread Carlos Nyembwe 
Hi all

I have a problem about SQL request in DHIS2


When I request the table User in front end, I see this message, but for
now, I want to have some situation about User in my extence DHIS2
SQL query contains references to protected tables

How can help me?

Regards

Carlos

-- 
*Carlos Nyembwe*
*I'm just a Computer Scientist*

*Skype: carloscnk1*
*Cell: (+243)813166381*
*Find me in: | Google Plus  |
**Linkedin
 | Facebook
 | Twitter
 |*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Request User Table in DHIS2

2017-07-25 Thread Jason Pickering 
Hi Carlos,
This has been put into place as a measure to prevent the potential
accidental exposure of usernames and password hashes.

You can perform the query using a direct connection to the database, but
DHIS2 should block any SQL views with references to some protected tables.

Regards,
Jason Pickering

On Tue, Jul 25, 2017 at 11:13 AM, Carlos Nyembwe  wrote:

> Hi all
>
> I have a problem about SQL request in DHIS2
>
>
> When I request the table User in front end, I see this message, but for
> now, I want to have some situation about User in my extence DHIS2
> SQL query contains references to protected tables
>
> How can help me?
>
> Regards
>
> Carlos
>
> --
> *Carlos Nyembwe*
> *I'm just a Computer Scientist*
>
> *Skype: carloscnk1*
> *Cell: (+243)813166381 <+243%20813%20166%20381>*
> *Find me in: | Google Plus  | 
> **Linkedin
>  | Facebook
>  | Twitter
>  |*
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Request User Table in DHIS2

2017-07-25 Thread Carlos Nyembwe 
thanks Jason,

I understand you well but, I'm sorry for that because I don't have the
local database now, I have to download it



On Tue, Jul 25, 2017 at 10:22 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Carlos,
> This has been put into place as a measure to prevent the potential
> accidental exposure of usernames and password hashes.
>
> You can perform the query using a direct connection to the database, but
> DHIS2 should block any SQL views with references to some protected tables.
>
> Regards,
> Jason Pickering
>
> On Tue, Jul 25, 2017 at 11:13 AM, Carlos Nyembwe 
> wrote:
>
>> Hi all
>>
>> I have a problem about SQL request in DHIS2
>>
>>
>> When I request the table User in front end, I see this message, but for
>> now, I want to have some situation about User in my extence DHIS2
>> SQL query contains references to protected tables
>>
>> How can help me?
>>
>> Regards
>>
>> Carlos
>>
>> --
>> *Carlos Nyembwe*
>> *I'm just a Computer Scientist*
>>
>> *Skype: carloscnk1*
>> *Cell: (+243)813166381 <+243%20813%20166%20381>*
>> *Find me in: | Google Plus  | 
>> **Linkedin
>>  | Facebook
>>  | Twitter
>>  |*
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46%2076%20414%2070%2049>
>



-- 
*Carlos Nyembwe*
*I'm just a Computer Scientist*

*Skype: carloscnk1*
*Cell: (+243)813166381*
*Find me in: | Google Plus  |
**Linkedin
 | Facebook
 | Twitter
 |*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Request User Table in DHIS2

2017-07-25 Thread Jason Pickering 
The other alternative is to use the API of course. What exactly are you
trying to achieve?


On Tue, Jul 25, 2017 at 11:28 AM, Carlos Nyembwe  wrote:

> thanks Jason,
>
> I understand you well but, I'm sorry for that because I don't have the
> local database now, I have to download it
>
>
>
> On Tue, Jul 25, 2017 at 10:22 AM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Carlos,
>> This has been put into place as a measure to prevent the potential
>> accidental exposure of usernames and password hashes.
>>
>> You can perform the query using a direct connection to the database, but
>> DHIS2 should block any SQL views with references to some protected tables.
>>
>> Regards,
>> Jason Pickering
>>
>> On Tue, Jul 25, 2017 at 11:13 AM, Carlos Nyembwe 
>> wrote:
>>
>>> Hi all
>>>
>>> I have a problem about SQL request in DHIS2
>>>
>>>
>>> When I request the table User in front end, I see this message, but for
>>> now, I want to have some situation about User in my extence DHIS2
>>> SQL query contains references to protected tables
>>>
>>> How can help me?
>>>
>>> Regards
>>>
>>> Carlos
>>>
>>> --
>>> *Carlos Nyembwe*
>>> *I'm just a Computer Scientist*
>>>
>>> *Skype: carloscnk1*
>>> *Cell: (+243)813166381 <+243%20813%20166%20381>*
>>> *Find me in: | Google Plus  | 
>>> **Linkedin
>>>  | Facebook
>>>  | Twitter
>>>  |*
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049 <+46%2076%20414%2070%2049>
>>
>
>
>
> --
> *Carlos Nyembwe*
> *I'm just a Computer Scientist*
>
> *Skype: carloscnk1*
> *Cell: (+243)813166381 <+243%20813%20166%20381>*
> *Find me in: | Google Plus  | 
> **Linkedin
>  | Facebook
>  | Twitter
>  |*
>



-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Sharing Dataset in Two Separate DHIS2 Instances

2017-07-25 Thread vunda limbe 
Hi Dung,

I have the same problem with Derek, but I tried to creat a  list of all
organisation unit and call its here : in var rootOrgunit2 = rootOrgnitld +
listofOrgunit ;
and use that list in this line
""`${config.instanceABaseUrl}/api/dataValueSets?orgUnit=${config.rootOrgunit2
}&lastUpdatedDuration=${lastUpdatedDuration}&dataSet=${config.dataSetId}&children=true`,
{",

but I get no data in the orgunit listed. Could you help or explain more
your code.

Thanks.




On Tue, Jul 25, 2017 at 12:49 PM, Derek Kahongo Mukenge <
derek.eli...@gmail.com> wrote:

> Hi Dung,
>
> Thank you for the script. Before me go further, I need to know How this
> will deal Org Unit matching. Suppose that the instance B some Orgunit as
> part of instance A and I need to sync each Orgunit from A with its
> correspondant to B.
> What change is needed to be done in the config file and index.js to make
> its work?
> Or do I need to clone or have the same OrgUnit in the both instance?
>
> Thanks.
>
> On Tue, Jul 25, 2017 at 7:44 AM, Dung Nguyen Anh <
> nguyenanhdung...@gmail.com> wrote:
>
>> Hi Derek,
>>
>> Sorry for the late response, I've been chased by some other works. Here
>> is the script.
>>
>> 1. Go to this github address: https://github.com/hispvn/data-integration
>> 2. You will see a green button with label "Clone or download". click
>> "download zip"
>> 3. Extract the ZIP file you will get "data-integration-master" folder.
>> 4. Now go to that folder and follow the instructions in "readme.md" or
>> in github.
>> Please tell me if anything is unclear.
>>
>> Thanks,
>> Dzung
>>
>>
>> 2017-07-19 22:16 GMT+07:00 Derek Kahongo Mukenge 
>> :
>>
>>> Hi Dung,
>>>
>>> Just a remember,
>>>
>>> Thanks,
>>>
>>>
>>>
>>> On Mon, Jul 17, 2017 at 10:55 AM, Derek Kahongo Mukenge <
>>> derek.eli...@gmail.com> wrote:
>>>
 Hi Dung,

 Thanks for the explanation, I also have two instance and I can clone.
 Provide me the next steps then I'll trry to run.

 Thanks.

 2017-07-17 9:49 GMT+01:00 Dung Nguyen Anh :

> Hi Derek,
>
> Ok, let assume we have *instance A *(have the data set), and blank*
> instance B *(which need to be synced with *instance A). *What we're
> going to do first is to clone the data set in *instance A *into*
> instance B*.* "Clone" *here mean we will export the data set
> (including data element, option sets,  but not the values ) on 
> *instance
> A* to a file (json or xml) and then import to *instance B. *By this
> way, we will have the data set on* instance B *with the same "id" as
> in *instance A *in order to sync the values after. Next, we will
> create a script to get the values from *instance A* and put into *instance
> B, *this script can be run every day or month or year, it's up to you.
> You will have to understand these steps first for synchronization
> between 2 instances, then I can show you how to make it done.
>
> Regards,
> Dzung
>
>
>
> 2017-07-17 15:10 GMT+07:00 Derek Kahongo Mukenge <
> derek.eli...@gmail.com>:
>
>> Hi Em,
>>
>> Sorry for the delay for responding to your mail. I need to sync data
>> value. If Dzung can guide me It'll be fine.
>>
>> Thanks.
>>
>>
>>
>> 2017-07-10 10:45 GMT+01:00 Em Le Hong :
>>
>>> Hi Derek,
>>>
>>> To make sure that we are on the same page, I would like you to
>>> confirm that you want to sync metadata or sync data.
>>>
>>> If you only want to sync metadata, you can use DHIS2 feature, you
>>> can read on https://docs.dhis2.org/2.24/en/user/html/ch31s06.html and
>>> the instruction from Morten email.
>>>
>>> If you want to sync data value, this mean when user enter data in
>>> instance A, the value also be sync to instance B. I mark my team mate
>>> (Dzung) in this email, he will guide you some steps how to use script 
>>> and
>>> cronjob to sync data value, he did it for some projects.
>>>
>>> Thanks,
>>>
>>>
>>> On Sun, Jul 9, 2017 at 2:54 PM, Derek Kahongo Mukenge <
>>> derek.eli...@gmail.com> wrote:
>>>
 Hi Em,

 I was looking for longtime how to create script and cronjob to sync
 two dhis2 instance. could you have a example of script that sync
 dataelement from on server to the second?

 Thanks

 2017-07-05 0:17 GMT+01:00 Em Le Hong :

> Hi Stephen,
>
> As I know, you can't set up sharing between instances directly in
> DHIS2.
> But you can do it with DHIS2 API
> 
>  +
> script on custom form or script and cronjob
>  in background.
>
> Good luck!
>
>
>
>
> On Wed, Jul 5, 2017 at 3:50 AM, Stephen Gbanyan 
>

[Dhis2-devs] Recaptcha Support for Login

2017-07-25 Thread chathura widanage 
Hi devs,

Is there any native support for integrating recaptcha for login?

Thanks,
Chathura
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp