Re: [Dhis2-users] [Dhis2-devs] logging (for server administrators)

[Halvdan Grelland]

If the log4j config is overridable at launch we could always add a property
pointing to a development config in the maven dev profile. I'm not sure how
that would play with this though as it's being configured programmatically
at application startup.

Thoughts Lars?

2015-06-08 3:45 GMT+02:00 Morten Olav Hansen :

>
> On Sun, Jun 7, 2015 at 10:37 PM, Lars Helge Øverland 
> wrote:
>
>> No everything generated by DHIS 2 including exceptions go into the main
>> dhis.log file. We should of course aim at fixing the cause of these errors.
>>
>
> Is there an easy way to switch this off during development? Having to tail
> an extra log file every time doesn't sounds very convenient..
>
> --
> Morten
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
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

Re: [Dhis2-users] [Dhis2-devs] How to run DHIS2 & iHRIS on the same Server

[Halvdan Grelland]

I presume you've set up DHIS2 with nginx or Apache (as per usual with the
standard dhis2-tools setup).

What you need to do is configure nginx (presuming that's what you're using)
with a location for both, /dhis and /hris respectively. The /dhis location
should be configured already, evident by what you're saying, iHRIS i'm not
familiar with, but a quick googling tells me it uses apache, meaning you'd
probably want to set up nginx as a common front-end for both. I found this
link

but
cannot really vouch for its content (I only skimmed through it).

The details you should be able to find online as there are vast resources
on configuring both nginx and Apache. It's not really a DHIS2 or iHRIS
specific case.

Best of luck!

Halvdan,
DHIS2 developer

2015-07-02 23:13 GMT+02:00 gerald thomas :

> Dear All,
>
> My DHIS2 was running on the old installation method which means was
> accessing it using:
> http://localhost:8080/dhis.
>
> Now i had changed the method of installation using the dhis2-tool
> method and i can access it using:
> http://localhost/dhis
>
> Now my issues:
> This server was running Integrated Human Resource Information System
> (iHRIS) and was being access using
> http://localhost/hris/login
>
> Currently, when the instance of dhis2 is running iHRIS will goes down
> and when dhis2 goes down iHRIS will work fine.
>
> Please i need both to run in parallel can anyone help me how i can do it.
>
> Kindly note that
> iHRIS (Database is MySQL)
> DHIS2 (Database is PostgreSQL)
>
> --
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
___
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

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

[Halvdan Grelland]

In addition; please look at the startup log of dhis2 (specifically under
InitTableAlterator) and see if there's any queries failing.

2015-07-30 12:59 GMT+02:00 Abyot Gizaw :

>
>
> On Thu, Jul 30, 2015 at 11:30 AM Elmarie Claasen  wrote:
>
>> Hi Devs,
>>
>>
>>
>> I have an urgent database issue which I have to resolve as this project
>> is implementing by Monday and my database is not running on 2.20 stable
>> which I need for the tracker capture app to load. Can someone please assist.
>>
>>
>>
>> We have a database called ISHP which Erling has been helping us to set up
>> the Tracker capture app for implementation.
>>
>> Since the app could only connect to 2.20 we upgraded our training
>> database some time ago to 2.20 snapshot build revision 19527 and also
>> kept the program changes we made updated in 2.19 live version since we
>> couldn’t risk updating a live database when we did not know what the
>> implications would be.
>>
>>
>>
>> We now wanting to update the 2.19 Live database to 2.20 which we did on
>> our development instance but get the following errors which does not allow
>> us to
>>
>>
>>
>> 1.  access the program in the UI or via the tracker capture app (see
>> open program error log) The problem seems to be that the programtype in
>> our database is Integer while in other 2.20 instances it is char varying.
>> The update script from 2.19>2.20 does not contain anything changing this so
>> how do I deal with this please…
>>
>>
> This was supposed to be handled internally in the code.
>
> try to alter manually and see what happens
>
> ALTER TABLE program ALTER COLUMN "type" TYPE varchar(255);
>
>
>>
>>
>> 2.  analytics is failing due to fieldname error   (see detailed
>> analytics error log attached but here is a short version) The problem is
>> that the temp table has a fieldname called de instead of dx – again
>> something I don’t know how it happens or how to fix
>>
>>
>>
>> *Caused by: org.springframework.jdbc.BadSqlGrammarException:
>> StatementCallback; bad SQL grammar [update analytics_temp_2015 set
>> "uidlevel1" = null,"uidlevel2" = null,"uidlevel3" = null,"uidlevel4" =
>> null,"uidlevel5" = null where level > 5 and de in ('jx6lCxe8gYy',
>> 'cjA6JH0kC9B')]; nested exception is org.postgresql.util.PSQLException:
>> ERROR: column "de" does not exist*
>>
>> We checked our other 2.20 databases and the column name is dx but we
>> don’t know how to fix this – please help!
>>
>>
>>
>> The program we are accessing on 2.19, 2.20 stable and 2.20 snapshot Version:
>> Build revision: 19527 Build date: 2015-07-01 08:47 is all set up exactly
>> the same way and I don’t see why one would be able to open the program,
>> open tracker capture in the UI and log in on tracker capture app only on
>> the 2.20 snapshot version and not on 2.20 stable. Can you please assist us
>> with what is wrong?
>>
>>
>>
>>
>>
>> Regards,
>>
>>
>>
>> *Elmarie Claasen*
>>
>> [image: Hisp logo]
>>
>> Project Manager
>>
>> Health Information Systems Program
>>
>> Tel:  041-367 1027
>>
>> Cell: 082 374 2209
>>
>> E-mail: elma...@hisp.org
>>
>> Skype:  elmarie.claasen52
>>
>>
>>
>>
>>
>> This message and any attachments are subject to a disclaimer published at 
>> http://www.hisp.org/policies.html#comms_disclaimer
>> .   Please read the disclaimer before opening any attachment or taking
>> any other action in terms of this electronic transmission.
>> If you cannot access the disclaimer, kindly send an email to 
>> disclai...@hisp.org
>> and a copy will be provided to you. By replying to this e-mail or opening
>> any attachment you agree to be bound by the provisions of the disclaimer.
>>
>>
>>
>> *This message and any attachments are subject to a disclaimer published
>> at http://www.hisp.org/policies.html#comms_disclaimer
>> .  Please read the
>> disclaimer before opening any attachment or taking any other action in
>> terms of this electronic transmission.  If you cannot access the
>> disclaimer, kindly send an email to disclai...@hisp.org
>>  and a copy will be provided to you. By replying to
>> this e-mail or opening any attachment you agree to be bound by the
>> provisions of the disclaimer.*
>> ___
>> 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
>>
> --
> 
> Thank you,
> Abyot
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
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

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

[Halvdan Grelland]

Upgrader.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,076 Update done, dropped table
> mapview_dataelements (FavoriteDataItemUpgrader.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,080 Update done, dropped table
> mapview_dataelementoperands (FavoriteDataItemUpgrader.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,083 Update done, dropped table
> mapview_datasets (FavoriteDataItemUpgrader.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,189 Executing startup routine [12 of 15,
> runlevel 7]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,191 Upgraded custom case entry form
> identifiers (DataEntryFormUpgrader.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,193 Executing startup routine [13 of 15,
> runlevel 8]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,214 Executing startup routine [14 of 15,
> runlevel 9]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,218 Executing startup routine [15 of 15,
> runlevel 9]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,228 All startup routines done
> (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
>
> Jul 29, 2015 8:32:12 AM org.apache.catalina.startup.HostConfig deployWAR
>
> INFO: Deployment of web application archive
> /home/hisp/tomcat8-dhis2-2/webapps/staging.war has finished in 53,298 ms
>
> Jul 29, 2015 8:32:12 AM org.apache.coyote.AbstractProtocol start
>
> INFO: Starting ProtocolHandler ["http-nio-8081"]
>
> Jul 29, 2015 8:32:12 AM org.apache.catalina.startup.Catalina start
>
> INFO: Server startup in 53351 ms
>
>
>
> Regards,
>
>
>
> *Elmarie Claasen*
>
> [image: Hisp logo]
>
> Project Manager
>
> Health Information Systems Program
>
> Tel:  041-367 1027
>
> Cell: 082 374 2209
>
> E-mail: elma...@hisp.org
>
> Skype:  elmarie.claasen52
>
>
>
>
>
> This message and any attachments are subject to a disclaimer published at 
> http://www.hisp.org/policies.html#comms_disclaimer
> .   Please read the disclaimer before opening any attachment or taking any
> other action in terms of this electronic transmission.
> If you cannot access the disclaimer, kindly send an email to 
> disclai...@hisp.org
> and a copy will be provided to you. By replying to this e-mail or opening
> any attachment you agree to be bound by the provisions of the disclaimer.
>
>
>
> *From:* Halvdan Grelland [mailto:halvda...@gmail.com]
> *Sent:* 30 July 2015 02:33 PM
> *To:* Abyot Gizaw
> *Cc:* Elmarie Claasen; DHIS 2 Developers list;
> dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-devs] [Dhis2-users] FW: Problem with Tracker
> program after updating to 2.20 stable
>
>
>
> In addition; please look at the startup log of dhis2 (specifically under
> InitTableAlterator) and see if there's any queries failing.
>
>
>
> 2015-07-30 12:59 GMT+02:00 Abyot Gizaw :
>
>
>
> On Thu, Jul 30, 2015 at 11:30 AM Elmarie Claasen  wrote:
>
> Hi Devs,
>
>
>
> I have an urgent database issue which I have to resolve as this project is
> implementing by Monday and my database is not running on 2.20 stable which
> I need for the tracker capture app to load. Can someone please assist.
>
>
>
> We have a database called ISHP which Erling has been helping us to set up
> the Tracker capture app for implementation.
>
> Since the app could only connect to 2.20 we upgraded our training database
> some time ago to 2.20 snapshot build revision 19527 and also kept the
> program changes we made updated in 2.19 live version since we couldn’t risk
> updating a live database when we did not know what the implications would
> be.
>
>
>
> We now wanting to update the 2.19 Live database to 2.20 which we did on
> our development instance but get the following errors which does not allow
> us to
>
>
>
> 1.  access the program in the UI or via the tracker capture app (see
> open program error log) The problem seems to be that the programtype in
> our database is Integer while in other 2.20 instances it is char varying.
> The update script from 2.19>2.20 does not contain anything changing this so
> how do I deal with this please…
>
>
>
> This was supposed to be handled internally in the code.
>
>
>
> try to alter manually and see what happens
>
>
>
> ALTER TABLE program ALTER COLUMN "type" TYPE var

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

[Halvdan Grelland]

Hmm, yeah something doesn't seem right here. Not really familiar with the
detailed workings of the analytics table creation process, though (Lars
would be the one to ask). What's the schema for the left over
analytics_temp_2015? Also, can you make sure to (manually) delete the temp
table and re-run?

2015-07-30 16:53 GMT+02:00 Elmarie Claasen :

> Hi Halvdan,
>
>
>
> No the analytics is still failing. Here is the log.
>
>
>
> I don’t quite understand what is wrong. What I can see in the database is
> because analytics is failing the table Analytics_2015_temp remains after
> the analytics fails.
>
>
>
> Regards,
>
>
>
> *Elmarie Claasen*
>
> [image: Hisp logo]
>
> Project Manager
>
> Health Information Systems Program
>
> Tel:  041-367 1027
>
> Cell: 082 374 2209
>
> E-mail: elma...@hisp.org
>
> Skype:  elmarie.claasen52
>
>
>
>
>
> This message and any attachments are subject to a disclaimer published at 
> http://www.hisp.org/policies.html#comms_disclaimer
> .   Please read the disclaimer before opening any attachment or taking any
> other action in terms of this electronic transmission.
> If you cannot access the disclaimer, kindly send an email to 
> disclai...@hisp.org
> and a copy will be provided to you. By replying to this e-mail or opening
> any attachment you agree to be bound by the provisions of the disclaimer.
>
>
>
> *From:* Halvdan Grelland [mailto:halvda...@gmail.com]
> *Sent:* 30 July 2015 03:32 PM
> *To:* Elmarie Claasen
> *Cc:* Abyot Gizaw; DHIS 2 Developers list; dhis2-users@lists.launchpad.net
>
> *Subject:* Re: [Dhis2-devs] [Dhis2-users] FW: Problem with Tracker
> program after updating to 2.20 stable
>
>
>
> Hi,
>
>
>
> Yes, the first issue seems to be fixed (and there is no indication of
> faults in the log as you say). Why it didn't run properly before I don't
> know.
>
>
>
> As for the analytics: yes, analytics tables (named analytics_2014,
> analytics_2015 etc) er generated tables. If they do not exist, you might
> experience expections like the one posted. Analytics can be scheduled
> (recommended) to run regularly or triggered manually at
> https://your-dhis-server/dhis-web-reporting/displayDataMartForm.action
> (the process will take a lot of time to finish, depending on the server and
> the DB contents).
>
>
>
> Try to run an analytics update and try again. It will probably solve the
> issue.
>
>
>
> 2015-07-30 15:17 GMT+02:00 Elmarie Claasen :
>
> Hi Halvdan,
>
>
>
> I don’t see anything failing in the startup routine – here is the log of
> the first startup after the replaced the war file. Maybe the log should
> give an error if the tables was not successfully updated?
>
>
>
> Can you assist in how we fix the problem with the analytics table which
> still has an incorrect fieldname – “de” instead of “dx”.  The issue with
> the Program was resolved after running the script Abyot suggested but the
> analytics table is a temp table created during the analytics process or
> something since our db does not contain that table?
>
>
>
> 015-07-29 08:31:56,705 Executing startup routine [1 of 15, runlevel 1]: 
> InitTableAlteror
> (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:31:56,906 Executing startup routine [2 of 15,
> runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:31:56,911 Executing startup routine [3 of 15,
> runlevel 2]: DataElementDefaultDimensionPopulator
> (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:31:56,961 Linked default category with default
> concept (DataElementDefaultDimensionPopulator.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:31:57,171 Executing startup routine [4 of 15,
> runlevel 3]: TableAlteror (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:01,337 Tables updated (TableAlteror.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:01,337 Executing startup routine [5 of 15,
> runlevel 3]: TrackerIdentityPopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:01,704 Executing startup routine [6 of 15,
> runlevel 3]: ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:01,798 Executing startup routine [7 of 15,
> runlevel 4]: TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:05,640 Executing startup routine [8 of 15,
> runlevel 

Re: [Dhis2-users] [Dhis2-devs] Old DHIS2 War Files

[Halvdan Grelland]

https://apps.dhis2.org/ci/

Go to the revision you need -> last build -> artifact.

2015-08-25 15:06 GMT+02:00 gerald thomas :

> Dear All,
> Where can i find the old DHIS2 war files?
>
> --
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
___
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

Re: [Dhis2-users] Trouble with XML meta-data import through UI

[Halvdan Grelland]

Also, please provide the stacktrace from the actual log files (where they
are depends on your servlet container). It should contain the root cause of
the error. It's also helpful to know which version of DHIS2 you're using.

2015-08-27 11:57 GMT+02:00 Jason Pickering :

> Hi. It would help to know what you are trying to import? Can you share the
> file?
>
> Looks like an XML formatting error to me.
>
> Regards,
> Jason
>
>
> On Thu, Aug 27, 2015 at 11:45 AM, Shurajit Dutta 
> wrote:
>
>> Hi everyone,
>>
>> I seem to be unable to import XML meta-data through the import-export app.
>>
>> I tried a couple times now with the ICD-10 option set available on
>> dhis2.org through the demo. There was no response in the chrome console
>> and no reply within DHIS2 either. Usually there is some message indicating
>> whats been completed.
>>
>> I tried it on my localhost as well and checked the log:
>>
>> [image: Inline image 1]
>>
>> Any help is appreciated.
>>
>> Thanks,
>> Nick
>>
>> --
>> Shurajit Dutta
>> Health Information Consultant
>>
>> ___
>> 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.picker...@gmail.com
> tel:+46764147049
>
> ___
> 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
>
>
___
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

Re: [Dhis2-users] [Dhis2-devs] stian sandvold joins as developer

[Halvdan Grelland]

Welcome!

2015-08-28 17:54 GMT+02:00 Lars Helge Øverland :

> Hi all,
>
> Stian Sandvold has joined the team today as DHIS 2 developer on a 50 %
> basis. Stian comes from a position as lead developer at Asio, a company
> which develops educational tools and games. He is doing his last year of
> master's at UiO. Stian will work on server-side / back-end development.
>
> Welcome!
>
>
> regards,
>
> Lars
>
>
>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
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

Re: [Dhis2-users] [Dhis2-devs] nicolay ramm joins as developer

[Halvdan Grelland]

Welcome to the team!

2015-08-28 17:49 GMT+02:00 Lars Helge Øverland :

> Hi all,
>
> Nicolay Ramm has joined the team today as a full-time DHIS 2 developer.
> Nicolay holds a master's degree and has extensive experience as a Web
> developer. He will be working on apps and front-end development.
>
> Welcome!
>
> regards,
>
> Lars
>
>
>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
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

Re: [Dhis2-users] [Dhis2-devs] Changing admin password to default

[Halvdan Grelland]

For the record: Starting in 2.21 we only accept bcrypt password hashes.
Anything else will fail.

Beginning in 2.17 we started hot-swapping every user logging in with the
old scheme (md5) to the new one (bcrypt) on login. Even though they work in
2.20 I strongly suggest using bcrypt hashes for this reason as well as the
obvious security improvement.

As it seems you've experienced, changing the password in the DB at runtime
will not work (application memory will hold the old one). If you need to
force a password swap you will need to change the password in the db before
you start the server.

2015-09-01 9:53 GMT+02:00 gerald thomas :

> Dear Alan,
> Thanks very much
>
> Regards,
> Gerald
> On Aug 31, 2015 9:22 PM, "Alan Ivey"  wrote:
>
>> Hi Gerald,
>>
>> You can create a password hash with Python and the Bcrypt library. Run
>> this single command in your terminal to get a hash for *passwordGoesHere*
>> :
>>
>> $ python -c 'import bcrypt; hash = bcrypt.hashpw("*passwordGoesHere*",
>> bcrypt.gensalt(rounds=10, prefix=b"2a")); print(hash);'
>>
>> You can insert the resulting hash directly into the database for the
>> admin user.
>>
>> Note: If you do not have the Bcrypt library in your Python installation,
>> you should add it with pip. The following will install all prerequisites on
>> a CentOS 6 system:
>>
>> $ yum install gcc libffi-devel python-devel python-pip
>> $ pip install --user bcrypt
>>
>> Before attempting to change the admin user password in the database,
>> visit the front page of a new installation to have DHIS2 generate data in
>> the database for the admin user (you can do something as simple as $
>> curl -sL http://localhost:8080/). Then, you can enter the following
>> query into the Postgres CLI with the DHIS2 database in use:
>>
>> UPDATE USERS SET password = '001122hashgoeshere221100' WHERE username =
>> 'admin';
>>
>> Restart the application server (Tomcat) and then you should be able to
>> log in with your new password *passwordGoesHere* or what you changed it
>> to.
>>
>> Regards,
>> Alan
>>
>> On Mon, Aug 31, 2015 at 11:02 AM, gerald thomas 
>> wrote:
>>
>>> Dear all,
>>> I am setting up a training server for staff and i am using dhis2 live
>>> to achieve the task but i am using one of our database rather than the
>>> default database. I had already used the following query to change the
>>> admin password:
>>>
>>> UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5'
>>> where username = 'admin';
>>>
>>> What am i doing which is wrong and why i can't login with username:
>>> admin password: district
>>>
>>> --
>>> Regards,
>>>
>>> Gerald
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-d...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
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

Re: [Dhis2-users] Nightly Batch-Jobs

[Halvdan Grelland]

Hi,

The (failed) job you are seeing in the logs is an internal (!) cleanup task
which is ran at 2AM every 24H. In short, the task is necessary maintenance
which removes orphaned files (FileResources) which have been posted to the
instance but are marked for deletion.

Normally this task would run at 2AM, check for any orphaned files and, if
any are found, delete them (and their DB references). In most realistic
cases we are talking about a very small number of deletions, and more often
than not none; not really a 'batch job' as such.

Unfortunately there seems to be a bug with the implementation which causes
the exception you're seeing. I'll have to look into that and get a fix out.

The good news, though, is that it's entirely unproblematic to leave this as
is for now. It is just a failed background task which consumes virtually no
resources and dies immediately after execution start. It should not affect
anything else, but if you are indeed using the file storage capabilities
(for data values/tracker) in your instance you might theoretically
experience orphaned files piling up in case of client side issues. These
are easy to remove once there is a fix released, though, not to worry.

As for configuring the time at which this task is ran (or if it is ran at
all) this is not in place yet but will be more flexible in future versions.
As said, though, it really should not affect your use case at all.

Hope that answers your question. Thanks for reporting!

Halvdan Grelland, DHIS 2 Core developer

2016-01-25 14:26 GMT+01:00 Uwe Wahser :

> Dear all,
>
> since we are doing nightly data-loads into DHIS2 with a 3rd party
> ETL-tool, we
> are obliged to control the DHIS2 background jobs as much as possible via
> api to
> avoid conflicts with the loading processes.
>
> Although I turned of all of the batch-functionalities in
> Maintenance-Scheduling,
> there is an error message every night at 2:00 in catalina.out: "Could not
> obtain
> transaction-synchronized Session for current thread" (more at the end of
> this
> mail)
>
> The error message appears at a time, when my jobs are already through, and
> I
> don't see any negative side aspects (getting a clean log would be nice,
> though).
> But I'd need to know what else is scheduled in the background
> out-of-the-box,
> how to stop it and how to trigger it via api, as I want to avoid locks,
> memory
> shortages etc. due to colliding batches.
>
> DHIS2, Version 22, Build 21765, Standard Ubuntu 14.04 & Oracle 8
>
> Any hint would be appreciated,
>
> Thanks a lot, Uwe
>
> --- catalina.out ---
> * ERROR 2016-01-25 02:00:00,015 Unexpected error occurred in scheduled
> task.
> (TaskUtils.java [taskScheduler-8])
> org.hibernate.HibernateException: Could not obtain transaction-synchronized
> Session for current thread
> at
>
> org.springframework.orm.hibernate4.SpringSessionContext.currentSession(SpringSessionContext.java:134)
> at
>
> org.hibernate.internal.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:993)
> at
>
> org.hisp.dhis.hibernate.HibernateGenericStore.getSharingCriteria(HibernateGenericStore.java:205)
> at
>
> org.hisp.dhis.hibernate.HibernateGenericStore.getSharingCriteria(HibernateGenericStore.java:200)
> at
>
> org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.getAllLeCreated(HibernateIdentifiableObjectStore.java:404)
> at
>
> org.hisp.dhis.fileresource.DefaultFileResourceService.getOrphanedFileResources(DefaultFileResourceService.java:138)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:497)
> at
>
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
> at
>
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
> at com.sun.proxy.$Proxy78.getOrphanedFileResources(Unknown Source)
> at
>
> org.hisp.dhis.fileresource.FileResourceCleanUpTask.run(FileResourceCleanUpTask.java:58)
> at
>
> org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
> at
>
> org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at
>
> java.

Re: [Dhis2-users] Nightly Batch-Jobs

[Halvdan Grelland]

No problem.

I believe it is the only one, but I wouldn't bet on it until Lars confirms
it.

If and when it is to be made configurable it would be available in the API,
yes, we are doing this for pretty much everything we do nowadays. The thing
is, though, that as this really is only a system-internal job there is not
real benefit to exposing the configuration completely, but I do see the use
case for being able to disable (or reschedule) it on demand.

Collision with current uploads is a non-issue as we're only dealing with
objects which are so-and-so old (current or recent uploads will not be
affected). We wouldn't attempt to clean up a file which has just been put
in staging.

2016-01-25 16:54 GMT+01:00 Uwe Wahser :

> Hi Halvdan,
>
> thanks for the quick response and thanks for looking at it, although it
> doesn't
> really sound dangerous to my setting.
>
> Between the lines I understand that this is the only internally scheduled
> job,
> or are any others to be aware of (cache deletion, index rebuilds etc.)?
>
> As you are planning to make it more flexible it might be worthwhile to
> make it
> available as an api-endpoint for external triggering and include a
> deselect into
> the scheduling options as there might be people who want to upload files
> via api
> - I would imagine that cleaning up while uploading might cause some
> problems ...
>
> Regards, Uwe
>
> > Halvdan Grelland  hat am 25. Januar 2016 um 18:23
> > geschrieben:
> >
> >
> > Hi,
> >
> > The (failed) job you are seeing in the logs is an internal (!) cleanup
> task
> > which is ran at 2AM every 24H. In short, the task is necessary
> maintenance
> > which removes orphaned files (FileResources) which have been posted to
> the
> > instance but are marked for deletion.
> >
> > Normally this task would run at 2AM, check for any orphaned files and, if
> > any are found, delete them (and their DB references). In most realistic
> > cases we are talking about a very small number of deletions, and more
> often
> > than not none; not really a 'batch job' as such.
> >
> > Unfortunately there seems to be a bug with the implementation which
> causes
> > the exception you're seeing. I'll have to look into that and get a fix
> out.
> >
> > The good news, though, is that it's entirely unproblematic to leave this
> as
> > is for now. It is just a failed background task which consumes virtually
> no
> > resources and dies immediately after execution start. It should not
> affect
> > anything else, but if you are indeed using the file storage capabilities
> > (for data values/tracker) in your instance you might theoretically
> > experience orphaned files piling up in case of client side issues. These
> > are easy to remove once there is a fix released, though, not to worry.
> >
> > As for configuring the time at which this task is ran (or if it is ran at
> > all) this is not in place yet but will be more flexible in future
> versions.
> > As said, though, it really should not affect your use case at all.
> >
> > Hope that answers your question. Thanks for reporting!
> >
> > Halvdan Grelland, DHIS 2 Core developer
> >
> > 2016-01-25 14:26 GMT+01:00 Uwe Wahser :
> >
> > > Dear all,
> > >
> > > since we are doing nightly data-loads into DHIS2 with a 3rd party
> > > ETL-tool, we
> > > are obliged to control the DHIS2 background jobs as much as possible
> via
> > > api to
> > > avoid conflicts with the loading processes.
> > >
> > > Although I turned of all of the batch-functionalities in
> > > Maintenance-Scheduling,
> > > there is an error message every night at 2:00 in catalina.out: "Could
> not
> > > obtain
> > > transaction-synchronized Session for current thread" (more at the end
> of
> > > this
> > > mail)
> > >
> > > The error message appears at a time, when my jobs are already through,
> and
> > > I
> > > don't see any negative side aspects (getting a clean log would be nice,
> > > though).
> > > But I'd need to know what else is scheduled in the background
> > > out-of-the-box,
> > > how to stop it and how to trigger it via api, as I want to avoid locks,
> > > memory
> > > shortages etc. due to colliding batches.
> > >
> > > DHIS2, Version 22, Build 21765, Standard Ubuntu 14.04 & Oracle 8
> > >
> > > Any hint would be appreciated,
> > >
> > > Thanks a lot, Uwe
&g

Re: [Dhis2-users] 2.23 Metadata importer rewrite and dryRuns

[Halvdan Grelland]

>From a dev perspective dryRun is pretty useful for debugging any features
built on top of it.

2016-02-02 9:15 GMT+01:00 Morten Olav Hansen :

> Hi everyone
>
> I'm currently in the process of re-writing our DXF2 metadata importer, and
> was wondering if anyone is actually using the dryRun option? its adds quite
> a bit of complexity to the code, so it will be added only to the new
> importer if people are actually using it for imports
>
> --
> Morten
>
> ___
> 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
>
>
___
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

Re: [Dhis2-users] Emails not being sent

[Halvdan Grelland]

Hi,

Does your SMTP server reject TLS requests, by chance? I see you've set TLS
off, however I fixed an issue in our development branch (2.16) recently
where the user setting was not being honored and TLS was forced on.

Regards,
Halvdan Hoem Grelland
DHIS2 Developer


2014-07-24 11:49 GMT+02:00 WILLIAMS, Ryan O'Neil :

>  Dear all,
>
>
>
> We are running  version 2.15 instance of dhis2 and we are having trouble
> getting the email functionality to work.
>
>
>
> The email server address and port have been provided using the email
> settings UI.
>
>
>
> We have tried to use the recover password  and send message functionality
> to no avail. Each time the functions are executed, the following entries
> can be found in the catalina.out log file respectively:
>
>
>
> * … Recovery message sent for user: xxx
>
>
>
> OR
>
>
>
> * …  Sending email to user: User{surname='xxx', …firstName= …
> (EmailMessageSender.java [SimpleAsyncTaskExecutor-664])
>
> * …Email sent using host: emailserver with TLS: false
> (EmailMessageSender.java [SimpleAsyncTaskExecutor-664])
>
>
>
> No entries can be found on the email server concerning these emails. No
> errors concerning emails can be found in the catalina log file.
>
> Other applications on the same server using the same settings can
> successfully send emails.
>
>
>
> Any ideas about what the problem could be or how we can debug this in more
> detail?
>
> Also, I don’t see a way to configure the FROM_ADDRESS, is this possible?
> What is the default sender?
>
>
>
> cheers
>
> *Ryan*
>
>
>
> ___
> 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
>
>
___
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

Re: [Dhis2-users] Emails not being sent

[Halvdan Grelland]

I have debugged this particular piece of code before and made a peculiar
discovery: Even though exceptions from the apache commons email library are
being handled (logged, that is), other exceptions in the same method are
swallowed. This is due to the task executor being used (spring
SimpleAsyncTaskExecutor) to execute the emailing routine. Therefore, as Bob
points out, it is likely the problem is happening elsewhere (of the email
library) and exceptions might not be logged at all (due to the task
executor).

The following link should provide a pretty good starting point for
implementing a task executor which logs any exceptions.
http://java.dzone.com/articles/spring-async-and-exception

I have actually done this before but sadly did not save the code as it was
used only for debugging a single case. Unfortunately I am on holiday at the
moment so I cannot help you further with the code. The guide at the link
I've provided should cover most aspects and be easy to implement for anyone
familiar with the general codebase, though.

Worth a try I'd say.

Halvdan


2014-07-29 12:51 GMT+01:00 Bob Jolliffe :

> Ah ok.  So I think there is no need to waste time doing the tcpdump thing.
>  If the log file is not saying that email has been sent then there will
> have been no comms with the mail server.
>
> So you are right - there seem not to be a problem with the lower level
> email sending code.  The issue is elsewhere.
>
> Somebody a bit closer to the messaging code should be able to help you
> debugging why the messages are not being sent.  I could work through the
> code but will take longer than someone more familiar with it.  I might get
> the chance later in the week but definitely not today :-(
>
>
> On 29 July 2014 12:29, WILLIAMS, Ryan O'Neil  wrote:
>
>>  Thanks Bob,
>>
>>
>>
>> There are two issues or “functions”.
>>
>>
>>
>> 1.   Password recovery (uses email function)
>>
>> a.   This now works since the installation of the lasted build of
>> 2.15
>>
>> 2.   Messages sent via email (when use enables this)
>>
>> a.   This does not work
>>
>> b.  No entire are in the log files pertaining to this
>>
>> c.   This is the reason for my questions, is there a scheduler (but
>> over 48hrs later, still nothing in log)
>>
>> Since item 1 works and not 2, leads me to believe that it is not only an
>> email issue.
>>
>>
>>
>> I will try to test for communications between the server and the email
>> server.
>>
>>
>>
>> Thanks
>>
>> ryan
>>
>>
>>
>> *From:* Bob Jolliffe [mailto:bobjolli...@gmail.com]
>> *Sent:* mardi 29 juillet 2014 13:08
>>
>> *To:* WILLIAMS, Ryan O'Neil
>> *Cc:* dhis2-users@lists.launchpad.net
>> *Subject:* Re: [Dhis2-users] Emails not being sent
>>
>>
>>
>> Hi Ryan
>>
>>
>>
>> I hope one of the authors of that module who will have been working and
>> testing the module will be able to answer this more authoritatively.  My
>> comments were based really on a reading of the source code and predicting
>> from that what it *should* be doing.
>>
>>
>>
>> What I can say is that there is no scheduler, or if there is it has
>> already been invoked for you to see the log messages that you do.  The code
>> which sends the email seems to do it there and then and should be throwing
>> some exception if it fails ie.  you shouldn't really see the "Email sent
>> using host" line in your log if the sending fails.  Rather you should
>> see "Could not send email: "
>>
>>
>>
>> Of course it is hard to know what the mailhost does with it but it seems
>> what you are saying is that the mail doesn't reach it.  As I indicated
>> earlier what I would do is to use something like tcpdump on the server to
>> verify whether there is comms with the mailserver or not.
>>
>>
>>
>> Regards
>>
>> Bob
>>
>>
>>
>> On 29 July 2014 10:49, WILLIAMS, Ryan O'Neil 
>> wrote:
>>
>> Hi Bob,
>>
>>
>>
>> I just installed 2.15 build 15196 and it managed to solve one aspect of
>> the problem. Email recovery now works.
>>
>> Two additional lines show up in the log after the “recovery message sent”
>> line
>>
>>
>>
>> * INFO  2014-07-28 18:33:08,739 Recovery message sent for user: xxx
>> (AccountController.java [TP-Processor8])
>>
>> * INFO  2014-07-28 18:33:08,851 Sending email to user: xxx with email
>> address: x...@bbb.com (EmailMessageSender.java
>> [SimpleAsyncTaskExecutor-76])
>>
>> * INFO  2014-07-28 18:33:08,931 Email sent using host: .bbb.com with
>> TLS: false (EmailMessageSender.java [SimpleAsyncTaskExecutor-76])
>>
>>
>>
>> However, email messages are still not being send via the message module,
>> even though the recipients all have “Enable message email notifications”
>> checked.
>>
>> No lines concerning messages appear in the log. Should message be sent
>> immediately or is there a scheduler for this?
>>
>>
>>
>> Ryan
>>
>>
>>
>> *From:* Bob Jolliffe [mailto:bobjolli...@gmail.com]
>>
>> *Sent:* vendredi 25 juillet 2014 13:29
>>
>> *To:* WILLIAMS, Ryan O'Neil
>> *Cc:* dhis2-users@lists.launchpad.net
>> *Su

Re: [Dhis2-users] [Dhis2-devs] Eivind Eriksen joins as developer

[Halvdan Grelland]

Welcome to the team!

2014-11-12 12:51 GMT+01:00 Lars Helge Øverland :

> Hi all,
>
> I have the pleasure to announce that Eivind Eriksen has joined the team as
> software developer. Eivind will work 40% this year, then full time from
> January.
>
> Eivind has 6 years of experience as Java software developer at Eniro,
> Visma, 3Media and has been working on search, monitoring and web portals.
> Eivind is 29 and originally from the northern city of Tromsø, Norway.
>
> We are excited to you get on the team. Welcome!
>
> regards,
>
> Lars
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
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

Re: [Dhis2-users] Upload Image on Data entry form

[Halvdan Grelland]

Hi Pamod.

This is unfortunately not supported at this time. It is, however, being
implemented and is expected to be introduced in version 2.18.

2014-11-17 15:22 GMT+01:00 Pamod Amarakoon :

> Hi All,
>
> I have a instance of DHIS 2.16 tracker data entry form, where the client
> needs to upload an image included as part of data entry form.
> eg: a photo of a tracked entity or patient etc.
>
> Is this possible, I couldn't find such tool in data entry design form.
>
> Thank you
>
> --
> Pamod
>
>
> ___
> 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
>
>
___
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

Re: [Dhis2-users] Upload Image on Data entry form

[Halvdan Grelland]

To be clear:
Support is first and foremost being implemented in the system and the data
entry module. I cannot speak for Tracker Capture, but I'd expect it to
adopt these changes somewhere down the line.

2014-11-18 11:32 GMT+01:00 Halvdan Grelland :

> Hi Pamod.
>
> This is unfortunately not supported at this time. It is, however, being
> implemented and is expected to be introduced in version 2.18.
>
> 2014-11-17 15:22 GMT+01:00 Pamod Amarakoon :
>
>> Hi All,
>>
>> I have a instance of DHIS 2.16 tracker data entry form, where the client
>> needs to upload an image included as part of data entry form.
>> eg: a photo of a tracked entity or patient etc.
>>
>> Is this possible, I couldn't find such tool in data entry design form.
>>
>> Thank you
>>
>> --
>> Pamod
>>
>>
>> ___
>> 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
>>
>>
>
___
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

Re: [Dhis2-users] [Dhis2-devs] About expired password in DHIS2

[Halvdan Grelland]

Hi Germine,

In order to diagnose the issue we're going to need some more information.

First and foremost: what browser are you using and what version of DHIS2
are you running?

Please do the following:
Try to log into DHIS2 so that the screen which you've attached a screenshot
of appears. Then open the javascript console (in Google Chrome go to View
-> Developer -> Javascript Console, you could also right click the page and
select 'inspect element', then go to the 'console' tab in Chrome or
Firefox).

Proceed to try and change the password. Are there errors or any other form
of feedback popping up in the console? If you go to the 'network' tab (in
the developer tools), are there any listings marked in red?

Also, if you have access to the server logs, please check if there is any
activity or errors reported when trying to log in.

Thanks,
Halvdan Grelland

2014-12-22 21:03 GMT+01:00 Seide, Germine :

>  Hello,
>
> I activated the option to reset password in 3 months and each time I log
> in to DHIS2, the system is asking to change my password. When I type my
> credentials nothing happens.
>
>
>
> *Can somebody help me fix that issue. *
>
>
>
>
>
>
>
> *Germine *
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
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

Re: [Dhis2-users] [Dhis2-devs] About expired password in DHIS2

[Halvdan Grelland]

Hi,

A fix was submitted for this very bug in September.
Please update your instance to the latest revision of 2.15. You could also
consider upgrading to a more recent major version, we are currently on 2.17.

You can download the latest version of DHIS2 here
<https://www.dhis2.org/downloads>

Let me know if you have any issues after upgrading.

Halvdan

2014-12-23 1:48 GMT+01:00 Seide, Germine :

>  Hello Halvdan,
>
> Thank you for your feedback.
>
> I am using Google chrome and DHIS 2.15. I am working on a test server. I
> attached to the email the errors that come up when I try to change the
> password
>
> Germine.
>
>
>
>
>
>
>
> *De :* Halvdan Grelland [mailto:halvda...@gmail.com]
> *Envoyé :* Monday, December 22, 2014 4:05 PM
> *À :* Seide, Germine
> *Cc :* DHIS 2 Developers list; DHIS 2 Users list
> *Objet :* Re: [Dhis2-devs] About expired password in DHIS2
>
>
>
> Hi Germine,
>
>
>
> In order to diagnose the issue we're going to need some more information.
>
>
>
> First and foremost: what browser are you using and what version of DHIS2
> are you running?
>
>
>
> Please do the following:
>
> Try to log into DHIS2 so that the screen which you've attached a
> screenshot of appears. Then open the javascript console (in Google Chrome
> go to View -> Developer -> Javascript Console, you could also right click
> the page and select 'inspect element', then go to the 'console' tab in
> Chrome or Firefox).
>
>
>
> Proceed to try and change the password. Are there errors or any other form
> of feedback popping up in the console? If you go to the 'network' tab (in
> the developer tools), are there any listings marked in red?
>
>
>
> Also, if you have access to the server logs, please check if there is any
> activity or errors reported when trying to log in.
>
>
>
> Thanks,
>
> Halvdan Grelland
>
>
>
> 2014-12-22 21:03 GMT+01:00 Seide, Germine :
>
> Hello,
>
> I activated the option to reset password in 3 months and each time I log
> in to DHIS2, the system is asking to change my password. When I type my
> credentials nothing happens.
>
>
>
> *Can somebody help me fix that issue. *
>
>
>
>
>
>
>
> *Germine *
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
___
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

Re: [Dhis2-users] Filter data elements by domain type

[Halvdan Grelland]

DomainType is an enum, which doesn't seem to be supported for field
filtering.
The supported types (as stated in the dev manual) are :
"string | boolean | integer | float | collection (checks for size) | date"

I'm pretty sure support would have to be added specifically for enums for
this to work. Morten could probably give some insight into this.

2015-01-07 12:44 GMT+01:00 Olav Poppe :

> Hi,
> I’m trying to filter data elements by domain type (through the API), but
> it does not seem to work. I’m using 2.17.
>
> I try this, but the result is empty:
> /api/dataElements.json?filter=domainType:eq:TRACKER
> /api/dataElements.json?filter=domainType:eq:AGGREGATE
>
> Any suggestions for what the problem might be?
>
> Olav
> ___
> 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
>
___
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

Re: [Dhis2-users] dhis 2.17 Password Algorithm

[Halvdan Grelland]

To further expand on this: bcrypt is a fully portable format which should
allow you to generate and authenticate valid credentials using any (sane)
implementation. Good implementations are available for most programming
languages.

Also, I might be misunderstanding you, but in reference to item #3 on your
list: if your design requires you to decrypt password hashes (which is, as
Jason P. suggests virtually impossible) it should probably be reconsidered.

If you for some reason need to work with pre 2.17 systems there is a
standalone implementation of the DHIS2 password hashing algo available at
https://github.com/dhis2/dhispassword

2015-01-12 9:18 GMT+01:00 Jason Pickering :

> Hi Jason,
>
> DHIS2 currently uses Bcrypt for encryption of the passwords.
>
> By far the easiest way achieve what you want is to create an XML (DXF2)
> payload of the user(s) you need to create and import that into DHIS2. The
> password in XML can be clear text,and will be encrypted by DHIS2 upon
> import.
>
> Yes, users can be assigned to orgunits in this process.
>
> Although it is possible to decrypt the password in the DHIS2 database, it
> could be a lengthy process requiring the password to be cracked. There is
> no known algorithm to  efficiently decrypt passwords which have been hashed
> with Bcrypt.
>
> Best regards,
> Jason Pickering
>
>
>
> On Mon, Jan 12, 2015 at 8:05 AM, Jason Phillips  wrote:
>
>> Hi all,
>>
>>
>>
>> A happy New Year to everyone, and may 2015 be a happy, healthy and
>> prosperous year for us all!
>>
>>
>>
>> I know related questions have been asked in the past, but I thought this
>> one worth asking anyway:
>>
>>
>>
>> We need to be able to add a user/password to an instance “externally” to
>> dhis 2.x – i.e. either through PostgreSQL or by injecting a line into an
>> .sql dump or something similar.  The instance need not be running at the
>> time.
>>
>> If I recall correctly, the algorithm used to encrypt the password in the
>> Db changed at some point (I may be wrong), so for the purposes of this
>> question assume that this applies only to versions 2.17 or higher.
>>
>> A couple of points come to mind:
>>
>>
>>
>> 1.   What would be the best way to achieve what we need, in Oslo’s
>> opinion?
>>
>> 2.   Can usernames be assigned to an OrgUnit at the same time?
>>
>> 3.   Can a password be decrypted from an .sql file using the same
>> algorithm?
>>
>>
>>
>> Many thanks and kind regards,
>>
>>
>>
>> Jason.
>>
>> ___
>> 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.picker...@gmail.com
> tel:+46764147049
>
> ___
> 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
>
>
___
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

Re: [Dhis2-users] Server Time in DHIS2?

[Halvdan Grelland]

HTTP origin servers will include a 'Date' field in a response (which gives
you the server time of the HTTP server itself on message generation).

2015-02-13 13:37 GMT+01:00 Lars Helge Øverland :

> The "created" and "lastUpdated" values for meta-data and data is saved
> using the server time.
>
> Lars
>
> ___
> 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
>
>
___
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

Re: [Dhis2-users] GML

[Halvdan Grelland]

More precisely: make sure there is a NAME property for each featureMember
which matches the corresponding orgunit name property (identical match).
You're welcome to send med a gml sample which you're having trouble with.
On 29 Mar 2015 19:29, "Nayeem Al Mifthah"  wrote:

> Dear Nami,
> Make sure thar Orgunit name is similar to the field name in shape file
> attribute table.
>
> And the coordinate system of shape file is similar to DHIS2 recommended
> one.
>
> Nayeem Al Mifthah
> HMIS Consultant
> Management Information System
> Directorate General of Health Services (DGHS), Bangladesh
> Supported by: UNICEF-Bangladesh
> Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
> Cell:+8801914030574
>
> On Sun, Mar 29, 2015 at 10:15 PM, Nami ghadri 
> wrote:
>
>> Hello All,
>>
>>
>>
>> I was able to covert shape file to GML file
>>
>>
>>
>> And export it to DHIS2
>>
>>
>>
>> Result are successful with no error and none is ignored
>>
>>
>>
>> But when I check data base on organisationunit table I can’t find the
>> coordinates and also featuretype filed is empty ( is should give me Polygon
>> )
>>
>>
>>
>> Any one faced that problem or any can give a guide line about it
>>
>>
>>
>> Thanks in advance
>>
>>
>>
>>
>> ___
>> 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
>>
>>
>
> ___
> 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
>
>
___
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

Re: [Dhis2-users] GML

[Halvdan Grelland]

Hi Nami,

I tried to import the file in question (syr_admin2.gml). Obviously I don't
have the required DB for it to successfully import so I created a few of
the orgunits named in the GML file. These import fine: reported as updated
by the importer as well as their respective DB fields being populated
correctly. Please make doubly sure you have the correct names set for the
orgunits in the database.

What query did you run to validate you DB contents? Please run the
following after import:

*select name from organisationunit where featuretype is null or coordinates
is null;*

Do you see the names of the orgunits in the GML file there? If so please
also check the server logs if possible.

Also make sure you have read and followed these steps:
https://www.dhis2.org/doc/snapshot/en/user/html/ch18s02.html

That being said your coordinate data seems to be completely off as the
districts (at least from the few coordinates I sampled) seem to be located
in the middle of the South Atlantic Ocean as well as covering incredibly
small areas (smaller than we support in DHIS2). This would also cause your
polygons to not render properly in GIS, of course. We do limit the import
data on import to 4 decimal digits (which should give a maximum accuracy of
~10m).

Regards,
Halvdan

2015-03-29 19:42 GMT+02:00 Nami ghadri :

> Dears,
>
>
>
> File nami.gml worked with me imported successfully and found it in database
>
>
>
> But file syr_admin2.gml was imported successfully but could not find it in
> database
>
>
>
>
>
> Thanks in advance
>
>
>
>
>
> *From:* Halvdan Grelland [mailto:halvda...@gmail.com]
> *Sent:* Sunday, March 29, 2015 8:33 PM
> *To:* Nayeem Al Mifthah
> *Cc:* dhis2-users@lists.launchpad.net; Nami ghadri
> *Subject:* Re: [Dhis2-users] GML
>
>
>
> More precisely: make sure there is a NAME property for each featureMember
> which matches the corresponding orgunit name property (identical match).
> You're welcome to send med a gml sample which you're having trouble with.
>
> On 29 Mar 2015 19:29, "Nayeem Al Mifthah"  wrote:
>
> Dear Nami,
>
> Make sure thar Orgunit name is similar to the field name in shape file
> attribute table.
>
>
>
> And the coordinate system of shape file is similar to DHIS2 recommended
> one.
>
>
> Nayeem Al Mifthah
> HMIS Consultant
> Management Information System
> Directorate General of Health Services (DGHS), Bangladesh
> Supported by: UNICEF-Bangladesh
> Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
> Cell:+8801914030574
>
>
>
> On Sun, Mar 29, 2015 at 10:15 PM, Nami ghadri 
> wrote:
>
> Hello All,
>
>
>
> I was able to covert shape file to GML file
>
>
>
> And export it to DHIS2
>
>
>
> Result are successful with no error and none is ignored
>
>
>
> But when I check data base on organisationunit table I can’t find the
> coordinates and also featuretype filed is empty ( is should give me Polygon
> )
>
>
>
> Any one faced that problem or any can give a guide line about it
>
>
>
> Thanks in advance
>
>
>
>
> ___
> 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
>
>
>
>
> ___
> 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
>
>
___
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

Re: [Dhis2-users] GML

[Halvdan Grelland]

Nami, please read the email i sent you two days ago: I'm suspecting your
input coordinate data is wrong. Try for example to plot any of the lat/long
pairs on a map.
On 1 Apr 2015 09:36, "Nami Ghadri"  wrote:

> Hello,
>
> I was able to do everything and import the GML with no errors
>
> But in the database in coordinates filed all values are (-31.4884,3.0E-4)
> for all org levels
>
> Please the attached txt file that contains a copy of one of the
> coordinates fields content
>
> Kindly advice
>
> Thanks in advance
>
>
>
>
>
>
>
> -Original Message-
> From: Dhis2-users [mailto:dhis2-users-bounces+nami_ghadri=
> hotmail@lists.launchpad.net] On Behalf Of Nami Ghadri
> Sent: Monday, March 30, 2015 3:34 PM
> To: 'Knut Staring'; 'Halvdan Grelland'
> Cc: dhis2-users@lists.launchpad.net
> Subject: Re: [Dhis2-users] GML
>
> Thanks a lot
>
>
>
> I will try it and give feed back
>
>
>
> Thanks a lot
>
>
>
>
>
>
>
>
>  <http://www.qrcs.org.qa/> Description: Description:
> cid:image001.jpg@01D02B6E.3FF14DC0
>
> نامي غادري
> مدير قسم تقنية المعلومات و الأنظمة
>
> بعثة تركيا
>
> Nami Ghadri
>
> Head Of Information technology and Systems Dept.
>
> Information Technoclogy & systems
>
> Turkey Mission
>
>
> Mob:+905317978228 |Skype: nami.ghadri |
>  Gaziantep – Turkey
>
>
>
>
>
>
>
> From: Knut Staring [mailto:knu...@gmail.com]
> Sent: Monday, March 30, 2015 3:31 PM
> To: Halvdan Grelland
> Cc: Nami ghadri; dhis2-users@lists.launchpad.net
> Subject: Re: [Dhis2-users] GML
>
>
>
> If the coordinates are off, you need to reproject the file, as described
> in the link that Halvdan just sent.
>
> For Syria, I'm guessing your shapefiles are in UTM 37N (see
> http://www.dmap.co.uk/utmworld.htm)
>
>
>
> This corresponds to EPSG:32637 (see
> http://spatialreference.org/ref/epsg/wgs-84-utm-zone-37n/ )
>
>
>
> In other words, you should install FWTools, open the FWTools console and
> run the following command:
>
> ogr2ogr -s_srs EPSG:32637 -t_srs EPSG:4326 -f GML filename.gml filename.shp
>
>
>
> On Mon, Mar 30, 2015 at 2:00 PM, Halvdan Grelland 
> wrote:
>
> Hi Nami,
>
>
>
> I tried to import the file in question (syr_admin2.gml). Obviously I don't
> have the required DB for it to successfully import so I created a few of
> the orgunits named in the GML file. These import fine: reported as updated
> by the importer as well as their respective DB fields being populated
> correctly. Please make doubly sure you have the correct names set for the
> orgunits in the database.
>
>
>
> What query did you run to validate you DB contents? Please run the
> following after import:
>
>
>
> select name from organisationunit where featuretype is null or coordinates
> is null;
>
>
>
> Do you see the names of the orgunits in the GML file there? If so please
> also check the server logs if possible.
>
>
>
> Also make sure you have read and followed these steps:
>
> https://www.dhis2.org/doc/snapshot/en/user/html/ch18s02.html
>
>
>
> That being said your coordinate data seems to be completely off as the
> districts (at least from the few coordinates I sampled) seem to be located
> in the middle of the South Atlantic Ocean as well as covering incredibly
> small areas (smaller than we support in DHIS2). This would also cause your
> polygons to not render properly in GIS, of course. We do limit the import
> data on import to 4 decimal digits (which should give a maximum accuracy of
> ~10m).
>
>
>
> Regards,
>
> Halvdan
>
>
>
> 2015-03-29 19:42 GMT+02:00 Nami ghadri :
>
> Dears,
>
>
>
> File nami.gml worked with me imported successfully and found it in database
>
>
>
> But file syr_admin2.gml was imported successfully but could not find it in
> database
>
>
>
>
>
> Thanks in advance
>
>
>
>
>
> From: Halvdan Grelland [mailto:halvda...@gmail.com]
> Sent: Sunday, March 29, 2015 8:33 PM
> To: Nayeem Al Mifthah
> Cc: dhis2-users@lists.launchpad.net; Nami ghadri
> Subject: Re: [Dhis2-users] GML
>
>
>
> More precisely: make sure there is a NAME property for each featureMember
> which matches the corresponding orgunit name property (identical match).
> You're welcome to send med a gml sample which you're having trouble with.
>
> On 29 Mar 2015 19:29, "Nayeem Al Mifthah"  wrote:
>
> Dear Nami,
>
> Make sure thar Orgunit name is similar to the field name in shape file
> att

Re: [Dhis2-users] GML

[Halvdan Grelland]

OK great!
On 1 Apr 2015 14:02, "Nami Ghadri"  wrote:

> Dears,
>
>
>
> Thanks for great effort  after few try’s and guidance from everyone who
> participate in helping me , I was able to do it
>
>
>
> I discovered that my shape file is already EPSG:4326 and I created gml
> file without transforming it and successful was the results
>
>
>
> The problem is that when I check the projection it gave me WGS_1984 and I
> did not know what does that mean in EPSG
>
>
>
> Now I am tuning the names for in gml file for districts and sub_districts
>
>
>
> Create thanks
>
>
>
>
>
>
>
> From: Halvdan Grelland [mailto:halvda...@gmail.com]
> Sent: Wednesday, April 1, 2015 2:55 PM
> To: Nami ghadri
> Cc: dhis2-users@lists.launchpad.net; Knut Staring
> Subject: RE: [Dhis2-users] GML
>
>
>
> Nami, please read the email i sent you two days ago: I'm suspecting your
> input coordinate data is wrong. Try for example to plot any of the lat/long
> pairs on a map.
>
> On 1 Apr 2015 09:36, "Nami Ghadri"  wrote:
>
> Hello,
>
> I was able to do everything and import the GML with no errors
>
> But in the database in coordinates filed all values are (-31.4884,3.0E-4)
> for all org levels
>
> Please the attached txt file that contains a copy of one of the
> coordinates fields content
>
> Kindly advice
>
> Thanks in advance
>
>
>
>
>
>
>
> -Original Message-----
> From: Dhis2-users [mailto:dhis2-users-bounces+nami_ghadri  dhis2-users-bounces%2Bnami_ghadri> =hotmail@lists.launchpad.net] On
> Behalf Of Nami Ghadri
> Sent: Monday, March 30, 2015 3:34 PM
> To: 'Knut Staring'; 'Halvdan Grelland'
> Cc: dhis2-users@lists.launchpad.net
> Subject: Re: [Dhis2-users] GML
>
> Thanks a lot
>
>
>
> I will try it and give feed back
>
>
>
> Thanks a lot
>
>
>
>
>
>
>
>
>  <http://www.qrcs.org.qa/> Description: Description:
> cid:image001.jpg@01D02B6E.3FF14DC0
>
> نامي غادري
> مدير قسم تقنية المعلومات و الأنظمة
>
> بعثة تركيا
>
> Nami Ghadri
>
> Head Of Information technology and Systems Dept.
>
> Information Technoclogy & systems
>
> Turkey Mission
>
>
> Mob:+905317978228   |Skype:
> nami.ghadri |   Gaziantep – Turkey
>
>
>
>
>
>
>
> From: Knut Staring [mailto:knu...@gmail.com]
> Sent: Monday, March 30, 2015 3:31 PM
> To: Halvdan Grelland
> Cc: Nami ghadri; dhis2-users@lists.launchpad.net
> Subject: Re: [Dhis2-users] GML
>
>
>
> If the coordinates are off, you need to reproject the file, as described
> in the link that Halvdan just sent.
>
> For Syria, I'm guessing your shapefiles are in UTM 37N (see
> http://www.dmap.co.uk/utmworld.htm)
>
>
>
> This corresponds to EPSG:32637 (see
> http://spatialreference.org/ref/epsg/wgs-84-utm-zone-37n/ )
>
>
>
> In other words, you should install FWTools, open the FWTools console and
> run the following command:
>
> ogr2ogr -s_srs EPSG:32637 -t_srs EPSG:4326 -f GML filename.gml filename.shp
>
>
>
> On Mon, Mar 30, 2015 at 2:00 PM, Halvdan Grelland 
> wrote:
>
> Hi Nami,
>
>
>
> I tried to import the file in question (syr_admin2.gml). Obviously I don't
> have the required DB for it to successfully import so I created a few of
> the orgunits named in the GML file. These import fine: reported as updated
> by the importer as well as their respective DB fields being populated
> correctly. Please make doubly sure you have the correct names set for the
> orgunits in the database.
>
>
>
> What query did you run to validate you DB contents? Please run the
> following after import:
>
>
>
> select name from organisationunit where featuretype is null or coordinates
> is null;
>
>
>
> Do you see the names of the orgunits in the GML file there? If so please
> also check the server logs if possible.
>
>
>
> Also make sure you have read and followed these steps:
>
> https://www.dhis2.org/doc/snapshot/en/user/html/ch18s02.html
>
>
>
> That being said your coordinate data seems to be completely off as the
> districts (at least from the few coordinates I sampled) seem to be located
> in the middle of the South Atlantic Ocean as well as covering incredibly
> small areas (smaller than we support in DHIS2). This would also cause your
> polygons to not render properly in GIS, of course. We do limit the import
> data on import to 4 decimal digits (which should give a maximum accuracy of
> ~10m).
>
>
>
> Regards,
>
> Halvdan
>
>
>
> 2015-03-29 19

Re: [Dhis2-users] GML

[Halvdan Grelland]

Oops. For some reason I didn't see the conversation you and Knut had for
the past høyre.

To further explain I'm pretty sure something is going very wrong in the
shp->gml step. The coordinates in the GML you've created are all in the
middle of the ocean and also seem to draw a very very tiny area (looking at
the coordinates for any orgunit will reveal that the difference between
most coordinate pairs lie after the fourth decimal plage, i.e. a resolution
higher than we support (or you need)).
On 1 Apr 2015 13:55, "Halvdan Grelland"  wrote:

> Nami, please read the email i sent you two days ago: I'm suspecting your
> input coordinate data is wrong. Try for example to plot any of the lat/long
> pairs on a map.
> On 1 Apr 2015 09:36, "Nami Ghadri"  wrote:
>
>> Hello,
>>
>> I was able to do everything and import the GML with no errors
>>
>> But in the database in coordinates filed all values are (-31.4884,3.0E-4)
>> for all org levels
>>
>> Please the attached txt file that contains a copy of one of the
>> coordinates fields content
>>
>> Kindly advice
>>
>> Thanks in advance
>>
>>
>>
>>
>>
>>
>>
>> -Original Message-
>> From: Dhis2-users [mailto:dhis2-users-bounces+nami_ghadri=
>> hotmail@lists.launchpad.net] On Behalf Of Nami Ghadri
>> Sent: Monday, March 30, 2015 3:34 PM
>> To: 'Knut Staring'; 'Halvdan Grelland'
>> Cc: dhis2-users@lists.launchpad.net
>> Subject: Re: [Dhis2-users] GML
>>
>> Thanks a lot
>>
>>
>>
>> I will try it and give feed back
>>
>>
>>
>> Thanks a lot
>>
>>
>>
>>
>>
>>
>>
>>
>>  <http://www.qrcs.org.qa/> Description: Description:
>> cid:image001.jpg@01D02B6E.3FF14DC0
>>
>> نامي غادري
>> مدير قسم تقنية المعلومات و الأنظمة
>>
>> بعثة تركيا
>>
>> Nami Ghadri
>>
>> Head Of Information technology and Systems Dept.
>>
>> Information Technoclogy & systems
>>
>> Turkey Mission
>>
>>
>> Mob:+905317978228 |Skype: nami.ghadri |
>>  Gaziantep – Turkey
>>
>>
>>
>>
>>
>>
>>
>> From: Knut Staring [mailto:knu...@gmail.com]
>> Sent: Monday, March 30, 2015 3:31 PM
>> To: Halvdan Grelland
>> Cc: Nami ghadri; dhis2-users@lists.launchpad.net
>> Subject: Re: [Dhis2-users] GML
>>
>>
>>
>> If the coordinates are off, you need to reproject the file, as described
>> in the link that Halvdan just sent.
>>
>> For Syria, I'm guessing your shapefiles are in UTM 37N (see
>> http://www.dmap.co.uk/utmworld.htm)
>>
>>
>>
>> This corresponds to EPSG:32637 (see
>> http://spatialreference.org/ref/epsg/wgs-84-utm-zone-37n/ )
>>
>>
>>
>> In other words, you should install FWTools, open the FWTools console and
>> run the following command:
>>
>> ogr2ogr -s_srs EPSG:32637 -t_srs EPSG:4326 -f GML filename.gml
>> filename.shp
>>
>>
>>
>> On Mon, Mar 30, 2015 at 2:00 PM, Halvdan Grelland 
>> wrote:
>>
>> Hi Nami,
>>
>>
>>
>> I tried to import the file in question (syr_admin2.gml). Obviously I
>> don't have the required DB for it to successfully import so I created a few
>> of the orgunits named in the GML file. These import fine: reported as
>> updated by the importer as well as their respective DB fields being
>> populated correctly. Please make doubly sure you have the correct names set
>> for the orgunits in the database.
>>
>>
>>
>> What query did you run to validate you DB contents? Please run the
>> following after import:
>>
>>
>>
>> select name from organisationunit where featuretype is null or
>> coordinates is null;
>>
>>
>>
>> Do you see the names of the orgunits in the GML file there? If so please
>> also check the server logs if possible.
>>
>>
>>
>> Also make sure you have read and followed these steps:
>>
>> https://www.dhis2.org/doc/snapshot/en/user/html/ch18s02.html
>>
>>
>>
>> That being said your coordinate data seems to be completely off as the
>> districts (at least from the few coordinates I sampled) seem to be located
>> in the middle of the South Atlantic Ocean as well as covering incredibly
>> small areas (smaller than we support in DHIS2). This would also cause your
>> polygons to not render properly in GIS, of course. We 

Re: [Dhis2-users] GIS issues

[Halvdan Grelland]

Hi Nami,

These things are hard to debug without any source data to look at. Could
you provide the GML files and possibly an SQL dump of your DB?
On 12 Apr 2015 15:03, "Nami ghadri"  wrote:

> Hello,
>
>
>
> I have three  issues in GIS
>
>
>
> I was able to import GML files and it went good after guidance from here
>
>
>
> I have governorate and district and sub district
>
>
>
> 1 - Whenever I want to float up from sub district to district It take me
> to governorate
>
>
>
> 2- although all data was imported from the same GML file but I have some
> of the boundaries exactly two of them that don’t not load
>
>
>
> 3- some times when I drill down or float up the web browser give
> “coordinates could not be loaded”
>
>
>
>
>
> Kindly advice
>
>
>
> Thanks in advance
>
> ___
> 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
>
>
___
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

Re: [Dhis2-users] GIS issues

[Halvdan Grelland]

So I had a look and was able to reproduce the (basic) issue. The input GIS
data seems fine. The issue I'm seeing is a 409 (conflict) beeing returned
when fetching the coordinates for the Al-Hasakeh orgunit. After some
debugging the root cause of this seems to stem from the uid of this
particular orgunit being invalid (it starts with a number while all valid
uids should start with a letter). The uid in question is 8a3yYkUvdIK, by
the way. Did you import these orgunits from somewhere (the orgunits
themselves and not the GIS data)? It might also be an issue with character
encoding of the DB (be aware that this is a wild guess, really).

Run the following query in your db to reveal all non-valid orgunit UIDs:
select name, uid from organisationunit where uid similar to '[0-9]%';

In any case, this is not a GIS issue. :)

Regards,
Halvdan

2015-04-13 8:15 GMT+02:00 Nami Ghadri :

> Yes Knut
>
>
>
> the data that you sent me is working fine
>
>
>
> but  mine is not
>
>
>
> I want to be able to add to it and there comes the problem
>
>
>
> regarding the MapLoader where can I get it ?
>
>
>
> thanks very much
>
>
>
>
>
>
>
> From: Knut Staring [mailto:knu...@gmail.com]
> Sent: Monday, April 13, 2015 1:54 AM
> To: Nami Ghadri
> Cc: dhis2-users@lists.launchpad.net; i...@qrcs-turkey.org
> Subject: Re: [Dhis2-users] GIS issues
>
>
>
> Have you tried the MapLoader app or the prepared files I sent you?
>
> On 12 Apr 2015 20:03, "Nami ghadri"  wrote:
>
> Hello,
>
>
>
> I have three  issues in GIS
>
>
>
> I was able to import GML files and it went good after guidance from here
>
>
>
> I have governorate and district and sub district
>
>
>
> 1 - Whenever I want to float up from sub district to district It take me
> to governorate
>
>
>
> 2- although all data was imported from the same GML file but I have some
> of the boundaries exactly two of them that don’t not load
>
>
>
> 3- some times when I drill down or float up the web browser give
> “coordinates could not be loaded”
>
>
>
>
>
> Kindly advice
>
>
>
> Thanks in advance
>
>
> ___
> 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
>
>
>
> ___
> 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
>
___
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

Re: [Dhis2-users] no organisation unit attached to current user

[Halvdan Grelland]

Nami,

Did you see the email i sent you regarding GIS issues the other day? In
that DB your orgunits had invalid UIDs attached to them, which will
obviously cause issues. I don't know what the issue you're currently having
is, but if you're on the same DB (or uids sourced from the same place) I'd
start by making sure no UIDs of the org units start with a number.
On 18 Apr 2015 18:15, "Nami Ghadri"  wrote:

> Hello,
>
>
>
> no organisation unit attached to current user
>
>
>
> how can I solve that
>
>
>
> best regards,
>
>
>
> ___
> 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
>
>
___
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