← Back to team overview

dhis2-users team mailing list archive

Re: Manual data import failure

 

Dear Antonio,

Check out this video on importing data into DHIS2 using CSV. Its very easy.
However, you will need to ensure you have your data in the format that
DHIS2 accepts.

https://youtu.be/CGSDuA-gOWk.

Also check out the developers mannual on the recommended formats to import
data into DHIS2. Check out the chapter on importing.

Kind regards

Timothy

On Wed, Jun 28, 2017 at 5:41 PM, Jesus Solano-Roman <
asolano@xxxxxxxxxxxxxxxxxx> wrote:

> Hello all.
>
> I am very new to DHIS2 and I've been reading tutorials and the user
> manual, but I can't seem to manually import a dataset (all my rows are
> ignored). I searched through the mailing list and couldn't find answers, so
> I hope this question hasn't been asked before.
>
> I am working with part of the Ebola Kenema dataset: https://dataverse.
> harvard.edu/dataverse/ebola?q=&types=files&sort=dateSort&order=desc&page=1
>
> The file called: MasterDataListandEBOVResults.csv has the following
> structure:
>
> OriginalGnum,GID,AKA,Series,EBOVPCRResults,EbolaRunDate,
> IDFromMetadata,SAMPLEID,EBOVCopies_mL_plasma,EbolaResult,Group
> EM-095-1,EM-095,,1,Positive,2014-05-27,EM095,EM-095,
> 149693.057143,Positive,Epos
> EM-95B,EM-95B,,1,,,,EM-095B,1332008.74286,Positive,Epos
> ...
>
> When I import it, all my rows are ignored and I get the following message
> after the dry run: *Data element not found or not accessible.*
>
> I am aware that the file structure does not comply to the structure
> expected by DHIS, but I am very confused as to how to fix it. Am I supposed
> to create Orgunits and parent groups-before importing-?, or do I need to
> change the headers of my csv to comply with some predefined structure? I
> think I just need guidance on the steps to make a manual import successful,
> as I haven't been able to find any online.
>
>
> Thanks in advance,
>
>
> *Antonio Solano-Roman*
>
> Data Visualization & User Experience Design
> Sabeti Lab - Broad Institute
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References