Hello Thomas!
I am glad you have solved your issue! I noticed a few gotchas so here are a couple of things to note when importing csv files in DHIS 2:
- The first row
dataelement Data element not found or not accessible
is a ** funny error**, because it is actually telling you something about a single row, found here in the documentation:
"dataelement","period","orgunit","catoptcombo","attroptcombo","value","storedby","lastupd","comment"
DHIS 2 is literally complaining about the fact that it cannot find a data element with the uid “dataelement”, which is what is assumes you are trying to load in that top row. You can try yourself by loading a file with only this top line, the error will be the same, 1 ignored row, data element not found or not accessible. It is safe to ignore this error, I’d be worried if there was a UID called dataelement, which is actually a valid UID! Just extremely unlikely to pop up from the random UID generator.
- Ignored
Unlike the metadata importer, the data importer will report that it ignored every row on a dry run. It can make testing difficult because you don’t know if it will actually import correctly or not as it reports back that every row was ignored. Two rules of thumb here:
-
The actual errored out row will be listed in the “Conflicts” section, even in a dry run
-
Sadly, some errors you can only find on a real run, so always upload your files with a comment, so you can find them later via the DB to delete them if something goes wrong and all else fails
-
File Type
UTF-8 works well and I use it for all my CSV uploads. Be wary of EXCEL’s CSV saving habits though, especially on a Mac. Your file should be UTF-8 without a BOM (a byte order marker, DHIS 2 doesn’t really care, as it will error out on row one anyway (see above)) AND it should be standard unix line feeds (LF). Excel for the Mac will default to saving it with circa 1990’s CRs only AND a BOM (unless you are editing a CSV, in which case it will keep the settings it found when it opened it). Easiest way to check is to grab a copy of Notepad++ (windows) or BBedit (mac).
BBedit:
and
Notepad++
and
Hope this helps!
···
On Wed, Jan 17, 2018 at 9:11 AM, Thomas Lavreys thomaslavreys@gmail.com wrote:
I found the issue. The file was saved as a csv utf-8, which is different to a normal csv (aparrently).
Thanks for the advice!
Kind regards,
Thomas
From: Adebusoye Anifalaje [mailto:busoye@baosystems.com]
Sent: Wednesday, January 17, 2018 12:31 PM
To: Thomas Lavreys thomaslavreys@gmail.com
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Data element not found or not accessible
Hi Thomas,
I aslo see that you are using version 2.23, it is possible that the csv column structure is different for this version. There might be someone on this forum who is currently working on this version and can provide input on that.
Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007
On 17 Jan 2018, at 12:23, Thomas Lavreys thomaslavreys@gmail.com wrote:
I tried it anyway, and it doesn’t recognize it:
Import summary
Import count
Type
Count
Imported
0
Updated
0
Deleted
0
Ignored
13
Conflicts
Element
Description
dataelement
Data element not found or not accessible
bjDvmb4bfuf
Category option combo not found or not accessible
So I’m guessing I need to find the catoptioncombo ID somewhere.
Regards,
Thomas
From: Adebusoye Anifalaje [mailto:busoye@baosystems.com]
Sent: Wednesday, January 17, 2018 12:11 PM
To: Thomas Lavreys thomaslavreys@gmail.com
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Data element not found or not accessible
Hi Thomas,
Can you try specifying the catoptioncombo even if it is default? This was an issue with one of the version builds a while ago.
Let’s know if that helps.
Cheers
**
<image001.png>**
Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007
On 17 Jan 2018, at 12:02, Thomas Lavreys thomaslavreys@gmail.com wrote:
Dear,
I get the message “Data element not found or not accessible” when trying to import a csv file. I looked at some old threads, but failed to find an answer.
The csv file is attached (with headers, but it gave the same answer without headers).
Attached also the API page of the data element, the sharing of the data element (I have superuser access), and the orgunit page to confirm the ID. Also a screenshot of the import summary and my DHIS2 instance info.
I guess I might be missing something but I can’t figure out what exactly.
Thank you in advance for your help.
Kind regards,
Thomas Lavreys
Thomas Lavreys, MSc, PgC Trop Med
Sustainability Department SOCFINCO
Maisha Consulting bvba
Bisschoppenhof 9
3150 Tildonk
Belgium
**
Tel Socfin: +32-25-080050
Tel Maisha: +32-16-850242
Cell phone: +32-474-717641
Fax: +32-16-850242
<TEST.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
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
Timothy Harding
Sr. Systems Analyst, BAO Systems
+1 202-536-1541 | tharding@baosystems.com | http://www.baosystems.com | Skype: hardingt@gmail.com | 2900 K Street, Suite 406, Washington D.C. 20007