Re: [Dhis2-devs] [Dhis2-users] DHIS2 2.30 IMPORT/EXPORT ISSUE

[Viet Nguyen]

Hi Peter,

Please help to report the issues you got on jira.dhis2.org so we could
check and fix the import/export app.

Thanks,

On Tue, Nov 6, 2018 at 10:24 AM Peter D Lubambi  wrote:

> I think the import function in dhis2 2.30 is not working completely, can
> someone confirm otherwise? I, as well tried importing in 2.30 several times
> it never worked, had to downgrade to 2.29 then I was able to import.
>
> Peter
>
> On Mon, Nov 5, 2018, 3:09 PM Kristiyan Panayotov <
> kristi...@logicaloutcomes.net wrote:
>
>> Hi all – thank for your support and suggestions.
>>
>>
>>
>> We managed to find a solution to our problem. We downgraded to version
>> 2.29 and found a good balance between using the new Android app together
>> with import functionalities.
>> For importing Org Units through a .csv file in version 2.30 – I will say
>> that it was not possible after all. We tried many different combinations
>> for creating the .csv files and none was successful. Together with the fact
>> that some of the Org Unit csv files have been successfully imported in
>> versions 2.25 – 2.29
>>
>>
>>
>> Regards and thank you all
>>
>> Kris
>>
>>
>>
>> *From:* Viet Nguyen [mailto:v...@dhis2.org]
>> *Sent:* Friday, November 2, 2018 10:24 AM
>> *To:* dco...@baosystems.com
>> *Cc:* Georgi Chakarov ; dhis2-users <
>> dhis2-us...@lists.launchpad.net>; Kristiyan Panayotov <
>> kristi...@logicaloutcomes.net>; dhis2-devs <
>> dhis2-devs@lists.launchpad.net>
>> *Subject:* Re: [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE
>>
>>
>>
>> Hi Georgi and Kristiyan,
>>
>>
>>
>> Could you try to change the file extension from ".CSV" to lowercase and
>> import again ? I think this is a bug, already reported to the app developer
>> and he's fixing it.
>>
>>
>>
>> We also have added the import summary which will show all the import
>> errors. It's on master and being backported to 2.30.
>>
>>
>>
>> Regards,
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Fri, Nov 2, 2018 at 5:04 AM Dan Cocos  wrote:
>>
>> Is it encoded as UTF-8? I noticed as few “special” charters and that
>> might cause problems.
>>
>>
>>
>> Dan Cocos
>>
>> *BAO Systems*
>>
>> On Nov 1, 2018, at 5:33 PM, Georgi Chakarov 
>> wrote:
>>
>> Hi Blake,
>>
>>
>>
>> Thanks for your response!
>>
>>
>>
>> I am a colleague of Kristiyan. We use csv format as we have always used
>> for DHIS2 versions 2.28 and below.
>>
>> So it seems that DHIS2 changed standards for csv for some reason. The
>> exact same csv that Kris sent you was used to import org units in 2.28
>> instance and now is not recognized. We compared the template layout in 2.30
>> and it matches a 100% our file. I have also tried a csv export software
>> with different options of csv files with no luck.
>>
>>
>>
>> Maybe you could advice on how you generate csv files?
>>
>>
>>
>> Regards,
>>
>> Georgi
>>
>>
>>
>> *From:* Blake Hansen 
>> *Sent:* Thursday, November 1, 2018 7:17 PM
>> *To:* Kristiyan Panayotov 
>> *Cc:* calle.hedb...@gmail.com; DHIS 2 Users list <
>> dhis2-us...@lists.launchpad.net>; Georgi Chakarov <
>> geo...@logicaloutcomes.net>; dhis2-devs 
>> *Subject:* Re: [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE
>>
>>
>>
>> Hi Kris,
>>
>>
>>
>> I haven’t looked at your .csv file, but from your screenshot it is clear
>> DHIS2 is not recognising it as a .csv file type. If it were, you would see
>> an extra menu appear and be able to select the object type you are
>> attempting to create (see my screenshot). This is not visible in your
>> screenshot.
>>
>>
>>
>> 
>>
>>
>>
>> Some things to check:
>>
>> Has your template *strictly *followed the csv template layout in the
>> documentation?
>> https://docs.dhis2.org/2.30/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_org_units
>>
>> Is your .csv format the correct .csv format for DHIS2? (Some .csv in
>> francophone countries struggle as they use semi-colon)
>>
>>
>>
>> Hopefully something there is helpful. If not, it may be a bug but let’s
>> test those things first.
>>
>> It is also worth checking whether your import strategies are doing what
>> you expect. The default on the new system is different to the old.
>> Strategies are also found in the documentation - section 1.11
>>
>>
>>
>> All best,
>>
>> Blake
>>
>>
>>
>>
>>
>> --
>>
>>
>>
>>
>> 
>>
>> *Blake Hansen*
>> Projects Implementation Manager, BAO Systems
>>
>> +1 202-536-1541 | bhan...@baosystems.com | http://www.baosystems.com |
>>
>> Skype: blake.a.hansen | 2900 K Street, Suite 507, Washington D.C. 20007
>>
>>
>>
>> Register for the 2019 DHIS 2 Symposium:
>>
>>
>>  
>>
>>
>>
>> On 1 Nov 2018, at 17:09, Kristiyan Panayotov <
>> kristi...@logicaloutcomes.net> wrote:
>>
>>
>>
>> Hi Calle,
>>
>>
>>
>> Thanks for looking into the .csv
>>
>> I tried your suggestions and still NO import. I added short names, codes,
>> opening date – import error hasn’t changed.
>>
>>
>>
>> Kris
>>
>>
>>
>> *From:* Calle Hedberg [mailto:calle.hedb...@gmail.com
>> ]
>> *Sent:* Thursday, November 1, 2018 6:07 PM

[Dhis2-devs] New Android Capture App for DHIS 2 (v1.0.3) - User permissions

[Kristiyan Panayotov]

Dear DHIS2 experts,

I came across one small issue with the new android app with DHIS2 version 2.29.

Unless you are a superuser, you cannot see your Programs (looking in the 
Tracker functionalities).
When I assign the "ALL", only then I can see my data inside. Otherwise, log in 
is successful and I can ses all Org Units.

Has anyone else, came across this issue? Is I a bug or a configuration problem?

Kind regards,
Kris
___
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 2.30 IMPORT/EXPORT ISSUE

[Kristiyan Panayotov]

Hi all – thank for your support and suggestions.

We managed to find a solution to our problem. We downgraded to version 2.29 and 
found a good balance between using the new Android app together with import 
functionalities.
For importing Org Units through a .csv file in version 2.30 – I will say that 
it was not possible after all. We tried many different combinations for 
creating the .csv files and none was successful. Together with the fact that 
some of the Org Unit csv files have been successfully imported in versions 2.25 
– 2.29

Regards and thank you all
Kris

From: Viet Nguyen [mailto:v...@dhis2.org]
Sent: Friday, November 2, 2018 10:24 AM
To: dco...@baosystems.com
Cc: Georgi Chakarov ; dhis2-users 
; Kristiyan Panayotov 
; dhis2-devs 
Subject: Re: [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE

Hi Georgi and Kristiyan,

Could you try to change the file extension from ".CSV" to lowercase and import 
again ? I think this is a bug, already reported to the app developer and he's 
fixing it.

We also have added the import summary which will show all the import errors. 
It's on master and being backported to 2.30.

Regards,





On Fri, Nov 2, 2018 at 5:04 AM Dan Cocos 
mailto:dco...@baosystems.com>> wrote:
Is it encoded as UTF-8? I noticed as few “special” charters and that might 
cause problems.

Dan Cocos
BAO Systems
On Nov 1, 2018, at 5:33 PM, Georgi Chakarov 
mailto:geo...@logicaloutcomes.net>> wrote:
Hi Blake,

Thanks for your response!

I am a colleague of Kristiyan. We use csv format as we have always used for 
DHIS2 versions 2.28 and below.
So it seems that DHIS2 changed standards for csv for some reason. The exact 
same csv that Kris sent you was used to import org units in 2.28 instance and 
now is not recognized. We compared the template layout in 2.30 and it matches a 
100% our file. I have also tried a csv export software with different options 
of csv files with no luck.

Maybe you could advice on how you generate csv files?

Regards,
Georgi

From: Blake Hansen mailto:bhan...@baosystems.com>>
Sent: Thursday, November 1, 2018 7:17 PM
To: Kristiyan Panayotov 
mailto:kristi...@logicaloutcomes.net>>
Cc: calle.hedb...@gmail.com; DHIS 2 Users list 
mailto:dhis2-us...@lists.launchpad.net>>; 
Georgi Chakarov 
mailto:geo...@logicaloutcomes.net>>; dhis2-devs 
mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE

Hi Kris,

I haven’t looked at your .csv file, but from your screenshot it is clear DHIS2 
is not recognising it as a .csv file type. If it were, you would see an extra 
menu appear and be able to select the object type you are attempting to create 
(see my screenshot). This is not visible in your screenshot.



Some things to check:
Has your template strictly followed the csv template layout in the 
documentation? 
https://docs.dhis2.org/2.30/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_org_units
Is your .csv format the correct .csv format for DHIS2? (Some .csv in 
francophone countries struggle as they use semi-colon)

Hopefully something there is helpful. If not, it may be a bug but let’s test 
those things first.
It is also worth checking whether your import strategies are doing what you 
expect. The default on the new system is different to the old. Strategies are 
also found in the documentation - section 1.11

All best,
Blake


--



Blake Hansen
Projects Implementation Manager, BAO Systems
+1 202-536-1541 | bhan...@baosystems.com | 
http://www.baosystems.com |
Skype: blake.a.hansen | 2900 K Street, Suite 507, Washington D.C. 20007

Register for the 2019 DHIS 2 Symposium:



On 1 Nov 2018, at 17:09, Kristiyan Panayotov 
mailto:kristi...@logicaloutcomes.net>> wrote:

Hi Calle,

Thanks for looking into the .csv
I tried your suggestions and still NO import. I added short names, codes, 
opening date – import error hasn’t changed.

Kris

From: Calle Hedberg [mailto:calle.hedb...@gmail.com]
Sent: Thursday, November 1, 2018 6:07 PM
To: Kristiyan Panayotov 
mailto:kristi...@logicaloutcomes.net>>
Cc: bhan...@baosystems.com; DHIS 2 Users list 
mailto:dhis2-us...@lists.launchpad.net>>; 
Georgi Chakarov 
mailto:geo...@logicaloutcomes.net>>; dhis2-devs 
mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE

Hi,

Your csv file might not import because at least two compulsory fields are blank:
- Shortname is compulsory (missing)
- Openingdate is compulsory (missing)

I have not tried to import orgunits with those fields missing for a looong 
time, but while i seem to recall a missing openingdate would be replaced by the 
default date 1970-01-01, I don't think the same happens for shortnames (note; I 
could be wrong).

in any case, it's a bad habit to import orgunits with such key fields blank 
(for instance, it's unlikely that opening dates from 1970 

Re: [Dhis2-devs] Program Rule conditions not evaluating

[Markus Bekken]

Hey Cha!
You are doing some pretty advanced expressions here, but it seems you got the 
syntax all correct. We are making better tools for syntax and integrity 
checking in the coming DHIS2 versions, I can imagine you had to do some 
counting to check that you got the right amount of parenthesis here :)

From the warning in the console it seems that the value not getting populated 
into the expression is the #{f6a_pr_edd_final}. How is this variable 
configured? Is it linked to one of the data elements? And is this data element 
filled in? Perhaps you could make one more condition to avoid triggering the 
rule at all if #{f6a_pr_edd_final} does not have a value?

Markus

P.S. it would be great if you can post this as a topic on community.dhis2.org 
 - and we can continue there.

> 2. nov. 2018 kl. 16:59 skrev Warancha Tumtaweetikul  >:
> 
> Hi Markus,
>  
> I’m having a problem getting a few program rules to work. 
>  
> We have a long condition where: 
> (40-d2:weeksBetween(V{event_date},#{f6a_pr_edd_final}))>=16 && 
> (40-d2:weeksBetween(V{event_date},#{f6a_pr_edd_final}))<=36 && 
> ((40-d2:weeksBetween(V{event_date},#{f6a_pr_edd_final}))-#{f6a_pr_as_sfh})<=2
>  
> However, the console (please see image below) keeps on showing that the 
> program rule variables are not getting evaluated even though those fields are 
> populated and assigned the values from the other variables.
> The second problem is we’re getting several “Could not perform background 
> update of…” errors even though it seems the data has been saved to the 
> database. We have several program rules to assign the value of one variable 
> to three other variables (ex. Changing the date of a data element would 
> change another data element with the new calculated date) in the order of its 
> priority. I’ve tried deleting the program rule conditions one at a time, and 
> the errors did disappear, and reappeared once I put the conditions back in. 
> For example, this UiD: IH7Nnis3UMd is a data element, that gets assigned a 
> value using program rule action by two program rules with different 
> priorities. We’re trying to troubleshoot, but still have yet to figure out 
> the solution.
>  
> Hope this makes sense!
>  
> Thank you.
>  
> Sincerely,
> Cha
>  
> 

___
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

[Dhis2-devs] 2.31 beta testing campaign - your help is needed!

[Lars Helge Øverland]

Dear all,

We will be running a DHIS 2 beta test campaign for 2.31 release from
November 12 to November 23, 2018.

The beta testing campaign is an opportunity for you to preview the very
latest features of DHIS 2 while helping us to catch existing features that
have been broken (regression) and check that new features are fit for
purpose. It's a big advantage to fix bugs and issues before release, so we
hope for your support in testing the release candidate as well as possible.


*Participation will be possible by either:*

   - Testing directly on our release candidate demo instance(s)
   - Downloading the release candidate war file, or building from the
   release candidate tag, and running your own instance


*Pro tip:* With 2.31, we have modified our build process to produce fully
deterministic builds. This means that if you build the war file yourself,
from the release candidate tag, you will get exactly the same war file that
we produce (regardless of when you build it).

The 2.31 final release will be available from *November 30* (assuming no
critical regression issues remain open at that time).


*Webinar: *Subject to demand, we will kick off the beta testing campaign by
holding a webinar with a brief demo of new features on November 12 at
around 14:00 CET. We welcome attendance from all of the DHIS2 Experts
community.

Please let p...@dhis2.org know if you are interested in the demo, and save
the date!

Note that we require a minimum of 10 participants for the webinar so your
support is critical!

Further details will be made available on our website at
www.dhis2.org/beta_testing in due course.


best regards,

Phil and Lars



Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
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