[Dhis2-users] Manual data import failure

2017-06-28 Thread Jesus Solano-Roman
Hello all.I am very new to DHIS2 and I've been reading tutorials and the user manual, but I can't seem to manually import a dataset (all my rows are ignored). I searched through the mailing list and couldn't find answers, so I hope this question hasn't been asked before.I am working with part of th

Re: [Dhis2-users] Manual data import failure

2017-06-28 Thread Jesus Solano-Roman
format > that DHIS2 accepts. > > https://youtu.be/CGSDuA-gOWk. > > Also check out the developers mannual on the recommended formats to import > data into DHIS2. Check out the chapter on importing. > > Kind regards > > Timothy > > On Wed, Jun 28, 2017 at 5:41 PM,

Re: [Dhis2-users] Manual data import failure

2017-06-29 Thread Jesus Solano-Roman
ps://docs.dhis2.org/master/en/user/html/dhis2_user_manual_en_full.html#data_dimensions (this one is a bit hidden down in the user guide)Best regards,DavidOn Wed, Jun 28, 2017 at 5:52 PM, Jesus Solano-Roman <asol...@broadinstitute.org> wrote:Hello Timothy.Thank you for your quick reply. I just

Re: [Dhis2-users] Manual data import failure

2017-06-29 Thread Jesus Solano-Roman
ating a program instead of an aggregate dataset.https://docs.dhis2.org/2.26/en/user/html/dhis2_user_manual_en_full.html#program_aboutBest,DavidOn Thu, Jun 29, 2017 at 5:06 PM, Jesus Solano-Roman <asol...@broadinstitute.org> wrote:Hey David.Thanks for your reply. This has been very helpful! I&#

[Dhis2-users] Data elements not showing in data set creation view

2017-06-29 Thread Jesus Solano-Roman
Hello. Hopefully someone can help me understand this behavior. I've attached pictures showing I've created a series of data elements, but when I try to create a dataset, they are not listed under the available datasets. I've made sure this user has power user clearance and the orgunit assigned to

Re: [Dhis2-users] Data elements not showing in data set creation view

2017-06-29 Thread Jesus Solano-Roman
r aggregate data, and you can therefore only add data elements with domain type aggregate. Regards Olav > 29. jun. 2017 kl. 20.16 skrev Jesus Solano-Roman : > > Hello. > > Hopefully someone can help me understand this behavior. I've attached pictures showing I've

Re: [Dhis2-users] HOW TO INPUT DATA FOR DATA ELEMENT OF TYPE Date/Time

2017-07-06 Thread Jesus Solano-Roman
Hello Mohamed, You should use the format -MM-dd , for instance 1994-05-27. Is this not working for you? Good luck, Antonio. On Thu, Jul 6, 2017 at 8:21 AM Mohamed Bangura wrote: > Dear all > > I am having problems inputting data for data element of type > Date/Time.Can you please assist

Re: [Dhis2-users] [Dhis2-devs] HOW TO INPUT DATA FOR DATA ELEMENT OF TYPE Date/Time

2017-07-06 Thread Jesus Solano-Roman
I guess a workaround wold be to have two additional data elements, one for hour and one for minutes. These could be numerical and with some scripting I imagine it would be possible to get analytics out of them.Eventually in version .28 you could create some script to programmatically create a prope

[Dhis2-users] Bulk removing DEs and Orgunits

2017-07-11 Thread Jesus Solano-Roman
Hello all. I'm trying to bulk remove all existing Orgunits from my database and I found this CLI API https://github.com/baosystems/dish2 that allows to exactly do that. However, it hasn't worked for me, perhaps due to my current system infrastructure. Is there another way to bulk remove metadata f

[Dhis2-users] Invalid column name on Event Capture (error 500)

2017-07-11 Thread Jesus Solano-Roman
Hello all.I am attempting to record events using Event Capture (web app). The event is not being saved into the browser. Right after clicking "save and go back", the browser console shows a 500 Error:GET http://10.252.76.99:8082/api/26/events/query.json?orgUnit=ImspTQPwCqd&progr…ment=dRliZ825YDk&or

Re: [Dhis2-users] Invalid column name on Event Capture (error 500)

2017-07-11 Thread Jesus Solano-Roman
t 12:30 PM Knut Staring wrote: > So you are running it in a terminal window, right? > > You should have some (server side) error messages in that window. > > Knut > > On Tue, Jul 11, 2017 at 12:07 PM, Jesus Solano-Roman < > asol...@broadinstitute.org> wrote: > &g

Re: [Dhis2-users] Invalid column name on Event Capture (error 500)

2017-07-11 Thread Jesus Solano-Roman
Knut Staring wrote: > You can start it from a terminal window by doing "java -jar > dhis2-live.jar", alternatively ./startup.sh > > On Jul 11, 2017 12:52 PM, "Jesus Solano-Roman" > wrote: > >> Hi Knut. >> >> Not really. Since I'm usin

Re: [Dhis2-users] Bulk removing DEs and Orgunits

2017-07-12 Thread Jesus Solano-Roman
ources/sql/delete_ > orgunittree_with_data.sql > > If you create this function, you can invoke it with > *select delete_orgunittree_with_data('');* > > Best regards, > Markus > > 11. jul. 2017 kl. 15.41 skrev Jesus Solano-Roman < > asol...@broadinstitute.or

Re: [Dhis2-users] OAuth token api status: 403 access denied.. urgent please!

2017-07-14 Thread Jesus Solano-Roman
Hello Andrei. I believe we have the same issue, also not luck with the demo server. I had sent an email to the dev listserv but I think that's not an active group anymore. I'm copying my original email down here, perhaps someone can help us both. It's good to know we're not the only ones with the

[Dhis2-users] API calls using Node.js examples

2017-07-27 Thread Jesus Solano-Roman
Hello all. I would like to know if someone could point out to examples or perhaps give an example of a typical Web API call done using Node.js The examples in the documentation are either using cURL or using the direct browser "endpoint", but usually do not take into account oAuth authentication

[Dhis2-users] Event analytics endpoint broken

2017-07-27 Thread Jesus Solano-Roman
Hello all. We've been trying to get the Event Analytics endpoint to work (e.g.:) *https://play.dhis2.org/dev/api/analytics/events * but we get a 404 error from the server. The same happens on our local installation of DHIS2. Is there a reason why

Re: [Dhis2-users] Event analytics endpoint broken

2017-07-27 Thread Jesus Solano-Roman
Zg33kd9taw&stage=Zj7UnCAulEk&displayProperty=SHORTNAME&outputType=EVENT&value=vV9UWAZohSf&aggregationType=AVERAGEHave a look at the docs here:https://docs.dhis2.org/master/en/developer/html/webapi_event_analytics.htmlregards,LarsOn Thu, Jul 27, 2017 at 6:07 PM, Jesus Sola

[Dhis2-users] CSV Event upload failed: "latitude" not a valid Double value

2017-08-04 Thread Jesus Solano-Roman
Hello all. I've constructed a csv file to bulk import Events to a local instance of DHIS2 as per guidelines from the documentation . My curl command to upload is the following: curl

Re: [Dhis2-users] CSV Event upload failed: "latitude" not a valid Double value

2017-08-04 Thread Jesus Solano-Roman
ill fails. Also If I upload manually using the import function inside DHIS2, the dry run shows the following conflicts: event Data element not found or not accessible tHF7qDZVeoT Data element not found or not accessible and all elements are ignored. Thanks again. On Fri, Aug 4, 2017 at 3:27 PM, Jesus

Re: [Dhis2-users] CSV Event upload failed: "latitude" not a valid Double value

2017-08-04 Thread Jesus Solano-Roman
apologies for the constant updates. On Fri, Aug 4, 2017 at 3:41 PM, Jesus Solano-Roman < asol...@broadinstitute.org> wrote: > UPDATE: I noticed that the csv file I downloaded from DHIS2 with a sample > of the Event data does not contain quotations so I did the same on the &

Re: [Dhis2-users] [Dhis2-devs] CSV Event upload failed: "latitude" not a valid Double value

2017-08-07 Thread Jesus Solano-Roman
senSenior Engineer, DHIS 2University of Oslohttp://www.dhis2.org On Fri, Aug 4, 2017 at 10:06 PM, Jesus Solano-Roman <asol...@broadinstitute.org> wrote:SECOND UPDATE: Sorry to keep updating this but I cannot edit the original post.I realized that the header had to be removed and also that

Re: [Dhis2-users] [Dhis2-devs] DHIS 2

2017-08-16 Thread Jesus Solano-Roman
Omer, please take a look at the documentation regarding UI customization:https://docs.dhis2.org/master/en/developer/html/dhis2_developer_manual_full.html#webapi_ui_customizationIn theory CSS would load on page load, if the CSS file is located in the right folder and the right format. Antonio Solano

Re: [Dhis2-users] Betr: Import of coordinates fails in v2.27(DHIS2)

2017-08-17 Thread Jesus Solano-Roman
Hello all. I have yet to submit an issue regarding this. In my case it was impossible to upload coordinates in CSV for event data. I tried with header, without header, using square brackets for the coordinates, using quotation marks, etc. If you have a comma without quotation marks the parser wil

Re: [Dhis2-users] Betr: Import of coordinates fails in v2.27(DHIS2)

2017-08-21 Thread Jesus Solano-Roman
>> Kris >> >> >> >> *From:* Terence Scott [mailto:terence.sc...@rabiesalliance.org] >> *Sent:* 21 August 2017 12:17 >> *To:* Kristiyan Panayotov >> *Cc:* Jesus Solano-Roman ; Gijsbert OOMS < >> gijsbert.o...@btcctb.org>; dhis2-users@lists.l

Re: [Dhis2-users] Betr: Import of coordinates fails in v2.27(DHIS2)

2017-08-21 Thread Jesus Solano-Roman
coordinates/ Will work around that before reporting it. > > > > *From:* Jesus Solano-Roman [mailto:asol...@broadinstitute.org] > *Sent:* 21 August 2017 15:30 > *To:* Kristiyan Panayotov ; Nghia Nguyen < > nghianguyentra...@gmail.com> > > > *Cc:* Solomon Kununga ; > dhis2-

Re: [Dhis2-users] [Dhis2-devs] Event Import in 2.26

2017-08-21 Thread Jesus Solano-Roman
Hi Pepe.I believe there's a couple of issues with your csv. I realize this is confusing because the CSV you obtain when you export the data has a format that -is not the same- as the one you need to import the data to DHIS2 (I was very confused by this as well).If you're using the UI to import a CS

Re: [Dhis2-users] [Dhis2-devs] Event Import in 2.26

2017-08-21 Thread Jesus Solano-Roman
for your quick reply.I wanted to know if you have used "Data Import" or "Event Import"?I tryRegards !Pepe Ken MvuluResponsable M&EProgramme Village AssainiDirection de l'HygièneMinistère de la Santé Publique/RDCTél: +243 811515878Skype: pepe.ken.mvulu 2017-08-21 16:32 G

Re: [Dhis2-users] User management

2017-09-06 Thread Jesus Solano-Roman
Hello Ramón. I don't know that there's an app that can do everything you want to do, but have you checked the User's API endpoints? https://docs.dhis2.org/master/en/developer/html/dhis2_developer_manual_full.html#webapi_users You could create a script that creates user accounts based on a datase

Re: [Dhis2-users] Interoperability - Export Tracker to JSON

2017-09-15 Thread Jesus Solano-Roman
Hi Chase.Are you talking about using the Web API or a feature within the interface? For the API solution, you can simply use an HTTP request with the corresponding required values (basically the ID of the tracker (event) program):http://{yourDHIS2Instance}/api/events.json?program=${qd.programid}Thi