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 <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 <bhan...@baosystems.com> > Sent: Thursday, November 1, 2018 7:17 PM > To: Kristiyan Panayotov <kristi...@logicaloutcomes.net> > Cc: calle.hedb...@gmail.com; DHIS 2 Users list > <dhis2-us...@lists.launchpad.net>; Georgi Chakarov > <geo...@logicaloutcomes.net>; dhis2-devs <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. > > <image001.png> > > 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 > > > -- > > > <image002.png> > > 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: > > > <image003.png> > > > 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 <kristi...@logicaloutcomes.net> > Cc: bhan...@baosystems.com; DHIS 2 Users list > <dhis2-us...@lists.launchpad.net>; Georgi Chakarov > <geo...@logicaloutcomes.net>; dhis2-devs <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 is anywhere near > the correct openingdates). > > Regards > Calle > > On Thu, 1 Nov 2018 at 16:43, Kristiyan Panayotov > <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 > > > > > > > > > From: Blake Hansen [mailto:bhan...@baosystems.com] > Sent: Thursday, November 1, 2018 4:23 PM > To: Kristiyan Panayotov <kristi...@logicaloutcomes.net> > Cc: dhis2-devs@lists.launchpad.net; dhis2-us...@lists.launchpad.net; Georgi > Chakarov <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 > > > -- > > > > > 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 <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 > <image002.jpg> > > > > > SCREENSHOT 2 > > > <image004.jpg> > > > _______________________________________________ > 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 > > _______________________________________________ > 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 > > > -- > ******************************************* > 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-devs > Post to : dhis2-devs@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-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp