← Back to team overview

dhis2-users team mailing list archive

Re: CSV-Import of Organisation unit

 

As the manual states, they have to be in GEO-Jason. You can get examples by
querying facilities from the demo-site via the api: 

http://dhis2.github.io/dhis2-docs/2.22/en/developer/html/dhis2_developer_manual_full.html#d4967e4513

A simple point feature could look like this: ... ,POINT,"[39.84992,-3.63045]" 

Regards, Uwe

> Diao Diallo <diao_diallo@xxxxxxxxxx> hat am 6. Juni 2016 um 19:06 geschrieben:
> 
> 
> Thanks for your help, but one more detail if i put longitude and latitude
> in one single field what will be their separator?
> 
> Thanks again.
> 
> Diao
> 
> On Mon, Jun 6, 2016 at 3:23 PM, Uwe Wahser <uwe@xxxxxxxxx> wrote:
> 
> > One more thing: latitude and longitude are a string in one single field
> > and have
> > to be accompanied by the feature type. Please compare the import
> > definition from
> > the manual:
> >
> >
> > http://dhis2.github.io/dhis2-docs/2.22/en/developer/html/dhis2_developer_manual_full.html#d4967e995
> >
> > Good luck!
> >
> > Uwe
> >
> > > Uwe Wahser <uwe@xxxxxxxxx> hat am 6. Juni 2016 um 18:02 geschrieben:
> > >
> > >
> > > Hi Diao,
> > >
> > > when importing csv, you have to specify all columns from the interface
> > up to
> > > the
> > > coordinates with empty fields(,,,):
> > >
> > name,uid,code,parentuid,shortname,description,uuid,openingdate,closeddate,comment,feature
> > > type,coordinates
> > >
> > > Your csv is being interpreted as longitude being the description and
> > latitude
> > > being the uuid (which has a shorter format). Please note that the names
> > in the
> > > first line are merely for decoration and is not read by the importer.
> > >
> > > Hope that helps - Greetings to Guineé
> > >
> > > Uwe
> > >
> > >
> > > > Diao Diallo <diao_diallo@xxxxxxxxxx> hat am 6. Juni 2016 um 17:35
> > > > geschrieben:
> > > >
> > > >
> > > > Please find attached a simple file.
> > > >
> > > > Regards.
> > > >
> > > > Diao
> > > >
> > > > On Mon, Jun 6, 2016 at 2:10 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
> > > >
> > > > > Hi Diao,
> > > > >
> > > > > Can you post this line in the CSV file also? Or perhaps the whole
> > file if
> > > > > it is not too big.
> > > > >
> > > > > Perhaps you have some trailing spaces or funny characters for this
> > OU?
> > > > >
> > > > > Knut
> > > > >
> > > > > On Mon, Jun 6, 2016 at 4:06 PM, Diao Diallo <diao_diallo@xxxxxxxxxx>
> > > > > wrote:
> > > > >
> > > > >> Dear all,
> > > > >>
> > > > >> When importing my facilies and their cordonates in my DHIS2, i
> > encounter
> > > > >> this error :
> > > > >>
> > > > >> *OrganisationUnit* *Infirmerie Militaire de Almamiya 1*
> > > > >> *Validation Violations: [ValidationViolation{property='uuid',
> > > > >> message='Allowed range for length [36, 36], length is 12',
> > > > >> value=-14.03008255}]*
> > > > >>
> > > > >> I need your ideas.
> > > > >>
> > > > >> I have *OS :* *Ubuntu DHIS2 version :* 2.22
> > > > >>
> > > > >> Best regards.
> > > > >>
> > > > >> Diao
> > > > >> --
> > > > >> *DIALLO MAMADOU DIAO CONSEILLER IT, SPECIALISTE DE DHIS 2 **(
> > District
> > > > >> Health Information Software )*
> > > > >> *MEASURE Evaluation | JSI*
> > > > >> *PHONE : 623909413 | 662256106*
> > > > >> *SKYPE : diawwdiallo*
> > > > >> www.jsi.com
> > > > >>
> > > > >> _______________________________________________
> > > > >> 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
> > > > >>
> > > > >>
> > > > >
> > > > >
> > > > > --
> > > > > Knut Staring
> > > > > Dept. of Informatics, University of Oslo
> > > > > Norway: +4791880522
> > > > > Skype: knutstar
> > > > > http://dhis2.org
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > *DIALLO MAMADOU DIAO CONSEILLER IT, SPECIALISTE DE DHIS 2 **( District
> > > > Health Information Software )*
> > > > *MEASURE Evaluation | JSI*
> > > > *PHONE : 623909413 | 662256106*
> > > > *SKYPE : diawwdiallo*
> > > > www.jsi.com
> > > > _______________________________________________
> > > > 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
> >
> 
> 
> 
> -- 
> *DIALLO MAMADOU DIAO CONSEILLER IT, SPECIALISTE DE DHIS 2 **( District
> Health Information Software )*
> *MEASURE Evaluation | JSI*
> *PHONE : 623909413 | 662256106*
> *SKYPE : diawwdiallo*
> www.jsi.com


Follow ups

References