Thanks Ant for your input! So in debugging this further using the mapping from the Java source file (see below snippet from organisationUnitsFromCsv method in https://github.com/dhis2/dhis2-core/blob/fb50a8c3c34ba5a27f30c9268bab9241aef3f15d/dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/csv/DefaultCsvImportService.java), it turns out that UUID is not a valid column (as stated in the Developer Guide) and was causing the out of order problem.
I have attached a sample of a working file including Feature Type and
Coordinates as I am sure someone else will encounter this problem.
if ( values != null && values.length > 0 )
{
OrganisationUnit object = new OrganisationUnit();
setIdentifiableObject( object, values );
String parentUid = getSafe( values, 3, null, 230 ); // Could be
UID, code, name
object.setShortName( getSafe( values, 4, object.getName(), 50 )
);
object.setDescription( getSafe( values, 5, null, null ) );
object.setOpeningDate( getMediumDate( getSafe( values, 6,
"1970-01-01", null ) ) );
object.setClosedDate( getMediumDate( getSafe( values, 7, null,
null ) ) );
object.setComment( getSafe( values, 8, null, null ) );
object.setFeatureType( FeatureType.valueOf( getSafe( values, 9,
"NONE", 50 ) ) );
object.setCoordinates( getSafe( values, 10, null, null ) );
object.setUrl( getSafe( values, 11, null, 255 ) );
object.setContactPerson( getSafe( values, 12, null, 255 ) );
object.setAddress( getSafe( values, 13, null, 255 ) );
object.setEmail( getSafe( values, 14, null, 150 ) );
object.setPhoneNumber( getSafe( values, 15, null, 150 ) );
object.setAutoFields();
-Stephen
From: Ant Snyman [mailto:[email protected]]
Sent: Monday, February 13, 2017 12:37 AM
To: Stephen Macauley <[email protected]>
Cc: [email protected]; [email protected]
Subject: Re: [Dhis2-users] Import of Organisation Units using CSV / working
example with Features Type and Coordinates?
Hi Stephen,
The one thing that caught my attention was that another column "Closed Date"
should come after "Opening Date". Since you do not have an extra "," after
1970-01-01, the subsequent columns might be misaligned with the coordinates
actually trying to import into the url column.
The GIS experts out there might comment on the format of the co-ordinates, but
I would expect it to be in the format "[7.495005,9.074908]"
Good luck
Regards
Ant
On 13 February 2017 at 06:07, Stephen Macauley
<[email protected]<mailto:[email protected]>>
wrote:
Greetings All,
Does anyone have a working example, that includes Features Type and
Coordinates, for the import of Organisation Units using CSV for 2.2.5
(currently using Build Revision 8dd81e6)?
I have tried numerous approaches using the available documentation, but always
encounter a challenge when the import files contains Features Type and
Coordinates (as defined here
https://docs.dhis2.org/2.25/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_org_units).
Sample excerpt from my import file:
Name,UID,Code,Parent UID,Short name,Description,UUID,Opening
date,Comment,Feature type,Coordinates,URL,Contact person,Address,Email,Phone
number
Bacta One,thzLERyqmDe,thzLERyqmDe,YtReWq54321,Bacta One,Bacta
One,,1970-01-01,test,Point,"7.495005,9.074908",,,,,
Bacta Two,ms1BoduOt0I,ms1BoduOt0I,YtReWq54321,Bacta Two,Bacta
Two,,1970-01-01,test,Point,"7.476555,9.04081",,,,,
I have tried various combinations of the Feature Type (Point, POINT, POLYGON,
leaving it blank) and have also tried putting the Coordinates in brackets
([7.495005,9.074908]).
A common response I get back during dry run is the below, which makes me
believe I have fields out of position or something else is happening with the
Feature type field based on a few different “enum” exceptions in the dhis.log
file.
OrganisationUnit
String
Property `url` requires a valid URL, was given `7.02149,4.76539`.
Many Thanks in Advance,
-Stephen
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to :
[email protected]<mailto:[email protected]>
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
--
Ant Snyman
Cell: 0824910449
Landline: 028 2713242
[https://mail.google.com/mail/u/0/?ui=2&ik=724514e697&view=fimg&th=14edf55be996df4f&attid=0.2&disp=emb&attbid=ANGjdJ8CzBKffrjicH_BFL-_4mldZs70m0LEVp4SHaxTINfbWOD7FLDYj3cHBAcAJkW2CMpxLzv_OGzop7SUZ3Q8dc-RrdfHxOn7MZfW-R4yP1Vo-pdoCdVL9q2VJjo&sz=w154-h152&ats=1438663624662&rm=14edf55be996df4f&zw&atsh=1]
Health Information Systems Program - SA
This message and any attachments are subject to a disclaimer published at
http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer
before opening any attachment or taking any other action in terms of this
electronic transmission. If you cannot access the disclaimer, kindly send an
email to [email protected]<mailto:[email protected]> and a copy will be
provided to you. By replying to this e-mail or opening any attachment you agree
to be bound by the provisions of the disclaimer.
Book16.csv
Description: Book16.csv
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
