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

[Muhammad Adeel]

Hi Peter / Kris,

We fixed the bug related to importing CSV (file extension) in caps.
Can you guys send us the files to test so we can resolve the bugs.
Additionally you can file bugs in jira.dhis2.org and assign me to resolve
them.

Regards,
Adeel

On Tue, Nov 6, 2018 at 6:38 AM Viet Nguyen  wrote:

> 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-users@lists.launchpad.net>; Kristiyan Panayotov <
>>> kristi...@logicaloutcomes.net>; dhis2-devs <
>>> dhis2-d...@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-users@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 

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

[Peter D Lubambi]

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-users@lists.launchpad.net>; Kristiyan Panayotov <
> kristi...@logicaloutcomes.net>; 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  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-users@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
> *To:* Kristiyan Panayotov 
> *Cc:* bhan...@baosystems.com; DHIS 2 Users list <
> dhis2-users@lists.launchpad.net>; Georgi Chakarov <
> geo...@logicaloutcomes.net>; dhis2-devs 
> *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 

Re: [Dhis2-users] [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-users@lists.launchpad.net>>; 
Georgi Chakarov 
mailto:geo...@logicaloutcomes.net>>; dhis2-devs 
mailto:dhis2-d...@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-users@lists.launchpad.net>>; 
Georgi Chakarov 
mailto:geo...@logicaloutcomes.net>>; dhis2-devs 
mailto:dhis2-d...@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-users] [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE

[Dan Cocos]

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 
> ; Georgi Chakarov 
> ; 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  
> 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 
> Cc: bhan...@baosystems.com; DHIS 2 Users list 
> ; Georgi Chakarov 
> ; dhis2-devs 
> 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 is anywhere near 
> the correct openingdates).
>  
> Regards
> Calle
>  
> On Thu, 1 Nov 2018 at 16:43, Kristiyan Panayotov 
>  wrote:
> Dear Blake,
>  
> Thank you for approaching our issue.
>  
> I am afraid that the solution to the problem is not that simple. DHIS2 still 
> doesn’t recognize the Org Unit csv file, although that is a structure that 
> has been successfully imported in previous versions. I also got the parent 
> UID from DHIS2 directly. I have attached the csv in this email, if you want 
> to take a look.
>  
> I also send you the screenshot from the failed import (below).
>  
> Thanks,
> Kris
>  
>  
> 
>  
>  
>  
>  
>  
> From: Blake Hansen [mailto:bhan...@baosystems.com] 
> Sent: Thursday, November 1, 2018 4:23 PM
> To: Kristiyan Panayotov 
> Cc: dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net; Georgi 
> Chakarov 
> Subject: Re: [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE
>  
> Hi Kristiyan,
>  
> DHIS2 still support this in 2.30, which you will see in the documentation. 
> The only difference is that you no longer have to select the upload file 
> type. DHIS2 automatically detects that it is a .csv file. Then you will be 
> asked to choose the type of object you are creating. 
>  
> So the first step, is click on upload file, select your .csv file, and import 
> from there as usual.
>  
> 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 | 

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

[Kristiyan Panayotov]

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 
Cc: bhan...@baosystems.com; DHIS 2 Users list 
; Georgi Chakarov 
; dhis2-devs 
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 is anywhere near the 
correct openingdates).

Regards
Calle

On Thu, 1 Nov 2018 at 16:43, Kristiyan Panayotov 
mailto:kristi...@logicaloutcomes.net>> wrote:
Dear Blake,

Thank you for approaching our issue.

I am afraid that the solution to the problem is not that simple. DHIS2 still 
doesn’t recognize the Org Unit csv file, although that is a structure that has 
been successfully imported in previous versions. I also got the parent UID from 
DHIS2 directly. I have attached the csv in this email, if you want to take a 
look.

I also send you the screenshot from the failed import (below).

Thanks,
Kris


[cid:image003.jpg@01D4720A.4BE07E30]





From: Blake Hansen 
[mailto:bhan...@baosystems.com]
Sent: Thursday, November 1, 2018 4:23 PM
To: Kristiyan Panayotov 
mailto:kristi...@logicaloutcomes.net>>
Cc: dhis2-d...@lists.launchpad.net; 
dhis2-users@lists.launchpad.net; Georgi 
Chakarov mailto:geo...@logicaloutcomes.net>>
Subject: Re: [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE

Hi Kristiyan,

DHIS2 still support this in 2.30, which you will see in the documentation. The 
only difference is that you no longer have to select the upload file type. 
DHIS2 automatically detects that it is a .csv file. Then you will be asked to 
choose the type of object you are creating.

So the first step, is click on upload file, select your .csv file, and import 
from there as usual.

All best,
Blake


--


[cid:image001.png@01D47207.01FA37A0]
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:

[cid:image002.png@01D47207.01FA37A0]

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

Dear DHIS2 experts,

I am writing to you because I have the following issue with DHIS2 METADATA 
IMPORT:

I want to import (first) Organizational units and unfortunately I do not see 
the .csv import and object type in the IMPORT/EXPORT APP.

I see the DHIS2 2.30 guide on importing metadata has this functionalities (see 
below SCREENSHOT 1) that are not present in our DHIS2 instance (see below 
SCREENSHOT 2)


My questions, therefore is: How can I import Org Units (and other metadata) 
from a .csv format in DHIS2?


Reards,
Kris



SCREENSHOT 1





SCREENSHOT 2





___
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


--

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***

___
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] DHIS2 2.30 IMPORT/EXPORT ISSUE

[Warancha Tumtaweetikul]

Hi Kris,

I had the same issues with importing .csv file in 2.30, so I ended up 
converting it to JSON and imported that instead of .csv, which did not appear 
to work after many attempts.

Cheers,
Cha

From: Dhis2-users 
[mailto:dhis2-users-bounces+wtum=bcchr...@lists.launchpad.net] On Behalf Of 
Kristiyan Panayotov
Sent: November 1, 2018 10:09 AM
To: calle.hedb...@gmail.com
Cc: DHIS 2 Users list ; dhis2-devs 

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

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<mailto:bhan...@baosystems.com>; DHIS 2 Users list 
mailto:dhis2-users@lists.launchpad.net>>; 
Georgi Chakarov 
mailto:geo...@logicaloutcomes.net>>; dhis2-devs 
mailto:dhis2-d...@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 is anywhere near the 
correct openingdates).

Regards
Calle

On Thu, 1 Nov 2018 at 16:43, Kristiyan Panayotov 
mailto:kristi...@logicaloutcomes.net>> wrote:
Dear Blake,

Thank you for approaching our issue.

I am afraid that the solution to the problem is not that simple. DHIS2 still 
doesn’t recognize the Org Unit csv file, although that is a structure that has 
been successfully imported in previous versions. I also got the parent UID from 
DHIS2 directly. I have attached the csv in this email, if you want to take a 
look.

I also send you the screenshot from the failed import (below).

Thanks,
Kris


[cid:image003.jpg@01D4720A.4BE07E30]





From: Blake Hansen 
[mailto:bhan...@baosystems.com<mailto:bhan...@baosystems.com>]
Sent: Thursday, November 1, 2018 4:23 PM
To: Kristiyan Panayotov 
mailto:kristi...@logicaloutcomes.net>>
Cc: dhis2-d...@lists.launchpad.net<mailto:dhis2-d...@lists.launchpad.net>; 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>; Georgi 
Chakarov mailto:geo...@logicaloutcomes.net>>
Subject: Re: [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE

Hi Kristiyan,

DHIS2 still support this in 2.30, which you will see in the documentation. The 
only difference is that you no longer have to select the upload file type. 
DHIS2 automatically detects that it is a .csv file. Then you will be asked to 
choose the type of object you are creating.

So the first step, is click on upload file, select your .csv file, and import 
from there as usual.

All best,
Blake


--


[cid:image001.png@01D47207.01FA37A0]
Blake Hansen
Projects Implementation Manager, BAO Systems
+1 202-536-1541 | bhan...@baosystems.com<mailto:bhan...@baosystems.com> | 
http://www.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:

[cid:image002.png@01D47207.01FA37A0]<https://dhis2symposium.org/>

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

Dear DHIS2 experts,

I am writing to you because I have the following issue with DHIS2 METADATA 
IMPORT:

I want to import (first) Organizational units and unfortunately I do not see 
the .csv import and object type in the IMPORT/EXPORT APP.

I see the DHIS2 2.30 guide on importing metadata has this functionalities (see 
below SCREENSHOT 1) that are not present in our DHIS2 instance (see below 
SCREENSHOT 2)


My questions, therefore is: How can I import Org Units (and other metadata) 
from a .csv format in DHIS2?


Reards,
Kris



SCREENSHOT 1





SCREENSHOT 2





___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-d...@lists.launchpad.net<mailto: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<mailto:dhis2-d...@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


--

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

[Kristiyan Panayotov]

Hi Cha,

Thank you for your advice – I had the same feeling that .csv integration link 
is not as great as the json.

Cheers,
Kris

From: Warancha Tumtaweetikul [mailto:w...@bcchr.ca]
Sent: Thursday, November 1, 2018 7:13 PM
To: Kristiyan Panayotov 
Cc: 'DHIS 2 Users list' ; 'dhis2-devs' 

Subject: RE: [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE

Hi Kris,

I had the same issues with importing .csv file in 2.30, so I ended up 
converting it to JSON and imported that instead of .csv, which did not appear 
to work after many attempts.

Cheers,
Cha

From: Dhis2-users 
[mailto:dhis2-users-bounces+wtum=bcchr...@lists.launchpad.net] On Behalf Of 
Kristiyan Panayotov
Sent: November 1, 2018 10:09 AM
To: calle.hedb...@gmail.com<mailto:calle.hedb...@gmail.com>
Cc: DHIS 2 Users list 
mailto:dhis2-users@lists.launchpad.net>>; 
dhis2-devs 
mailto:dhis2-d...@lists.launchpad.net>>
Subject: Re: [Dhis2-users] [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE

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<mailto:bhan...@baosystems.com>; DHIS 2 Users list 
mailto:dhis2-users@lists.launchpad.net>>; 
Georgi Chakarov 
mailto:geo...@logicaloutcomes.net>>; dhis2-devs 
mailto:dhis2-d...@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 is anywhere near the 
correct openingdates).

Regards
Calle

On Thu, 1 Nov 2018 at 16:43, Kristiyan Panayotov 
mailto:kristi...@logicaloutcomes.net>> wrote:
Dear Blake,

Thank you for approaching our issue.

I am afraid that the solution to the problem is not that simple. DHIS2 still 
doesn’t recognize the Org Unit csv file, although that is a structure that has 
been successfully imported in previous versions. I also got the parent UID from 
DHIS2 directly. I have attached the csv in this email, if you want to take a 
look.

I also send you the screenshot from the failed import (below).

Thanks,
Kris


[cid:image003.jpg@01D4720A.4BE07E30]





From: Blake Hansen 
[mailto:bhan...@baosystems.com<mailto:bhan...@baosystems.com>]
Sent: Thursday, November 1, 2018 4:23 PM
To: Kristiyan Panayotov 
mailto:kristi...@logicaloutcomes.net>>
Cc: dhis2-d...@lists.launchpad.net<mailto:dhis2-d...@lists.launchpad.net>; 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>; Georgi 
Chakarov mailto:geo...@logicaloutcomes.net>>
Subject: Re: [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE

Hi Kristiyan,

DHIS2 still support this in 2.30, which you will see in the documentation. The 
only difference is that you no longer have to select the upload file type. 
DHIS2 automatically detects that it is a .csv file. Then you will be asked to 
choose the type of object you are creating.

So the first step, is click on upload file, select your .csv file, and import 
from there as usual.

All best,
Blake


--


[cid:image001.png@01D47207.01FA37A0]
Blake Hansen
Projects Implementation Manager, BAO Systems
+1 202-536-1541 | bhan...@baosystems.com<mailto:bhan...@baosystems.com> | 
http://www.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:

[cid:image002.png@01D47207.01FA37A0]<https://dhis2symposium.org/>

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

Dear DHIS2 experts,

I am writing to you because I have the following issue with DHIS2 METADATA 
IMPORT:

I want to import (first) Organizational units and unfortunately I do not see 
the .csv import and object type in the IMPORT/EXPORT APP.

I see the DHIS2 2.30 guide on importing metadata has this functionalities (see 
below SCREENSHOT 1) that are not present in our DHIS2 instance (see below 
SCREENSHOT 2)


My questions, therefore is: How can I import Org Units (and other metadata) 
from a .csv format in DHIS2?


Reards,
Kris



SCREENSHOT 1





SCREENSHOT 2





___
Mailing list: https://launchpad.net/~dhis2-d

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

[Kristiyan Panayotov]

Dear Blake,

Thank you for approaching our issue.

I am afraid that the solution to the problem is not that simple. DHIS2 still 
doesn't recognize the Org Unit csv file, although that is a structure that has 
been successfully imported in previous versions. I also got the parent UID from 
DHIS2 directly. I have attached the csv in this email, if you want to take a 
look.

I also send you the screenshot from the failed import (below).

Thanks,
Kris


[cid:image003.jpg@01D4720A.4BE07E30]





From: Blake Hansen [mailto:bhan...@baosystems.com]
Sent: Thursday, November 1, 2018 4:23 PM
To: Kristiyan Panayotov 
Cc: dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net; Georgi 
Chakarov 
Subject: Re: [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE

Hi Kristiyan,

DHIS2 still support this in 2.30, which you will see in the documentation. The 
only difference is that you no longer have to select the upload file type. 
DHIS2 automatically detects that it is a .csv file. Then you will be asked to 
choose the type of object you are creating.

So the first step, is click on upload file, select your .csv file, and import 
from there as usual.

All best,
Blake


--


[cid:image001.png@01D47207.01FA37A0]

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:


[cid:image002.png@01D47207.01FA37A0]


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

Dear DHIS2 experts,

I am writing to you because I have the following issue with DHIS2 METADATA 
IMPORT:

I want to import (first) Organizational units and unfortunately I do not see 
the .csv import and object type in the IMPORT/EXPORT APP.

I see the DHIS2 2.30 guide on importing metadata has this functionalities (see 
below SCREENSHOT 1) that are not present in our DHIS2 instance (see below 
SCREENSHOT 2)


My questions, therefore is: How can I import Org Units (and other metadata) 
from a .csv format in DHIS2?


Reards,
Kris



SCREENSHOT 1





SCREENSHOT 2





___
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



CSV_TNC_ORG.CSV
Description: CSV_TNC_ORG.CSV
___
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] DHIS2 2.30 IMPORT/EXPORT ISSUE

[Blake Hansen]

Hi Kristiyan,

DHIS2 still support this in 2.30, which you will see in the documentation. The 
only difference is that you no longer have to select the upload file type. 
DHIS2 automatically detects that it is a .csv file. Then you will be asked to 
choose the type of object you are creating. 

So the first step, is click on upload file, select your .csv file, and import 
from there as usual.

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 11:24, Kristiyan Panayotov  
> wrote:
> 
> Dear DHIS2 experts,
>  
> I am writing to you because I have the following issue with DHIS2 METADATA 
> IMPORT:
>  
> I want to import (first) Organizational units and unfortunately I do not see 
> the .csv import and object type in the IMPORT/EXPORT APP.
>  
> I see the DHIS2 2.30 guide on importing metadata has this functionalities 
> (see below SCREENSHOT 1) that are not present in our DHIS2 instance (see 
> below SCREENSHOT 2)
>  
>  
> My questions, therefore is: How can I import Org Units (and other metadata) 
> from a .csv format in DHIS2?
>  
>  
> Reards,
> Kris
>  
>  
> 
> SCREENSHOT 1
> 
>  
>  
>  
>  
> SCREENSHOT 2
>  
>  
> 
>  
>  
> ___
> 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