← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Changed CSV-Format for OrgUnits

 

Hi,

1.
The header row is optional - it will automatically be discarded if it's
there. CSV import follows a pre-defined list of columns - you can drop
anything at the end, but must include extra commas if you have blank
columns in between relevant columns.

2. All UIDs must be 11 characters, and starting with a letter (NOT a digit).

Regards
Calle

On 17 December 2015 at 08:06, Knut Staring <knutst@xxxxxxxxx> wrote:

> I think header is completely optional (so docs should reflect that).
>
> On Thu, Dec 17, 2015 at 6:28 AM, Uwe Wahser <uwe@xxxxxxxxx> wrote:
>
>> update inline
>> > Uwe Wahser <uwe@xxxxxxxxx> hat am 17. Dezember 2015 um 06:23
>> geschrieben:
>> >
>> >
>> > Dear all,
>> >
>> > according to a previous post on the users list there have obviously been
>> > changes
>> > in the CSV-format for importing OrgUnits. Some have been documented,
>> others
>> > not
>> > (or might be bugs):
>> >
>> > - feature format seems to be mandatory now. I don't know whether that
>> makes
>> > sense, if it does, please indicate that in the docs, too.
>> > - If you decide to change the docs on that, please also add a column
>> with the
>> > technical names to be included in the header line of the csv - the
>> names in
>> > the
>> > example differ from the names in the format specification. (or indicate,
>> > whether
>> > the header line is optional)
>> > - the import summary records a funny error message. Don't know whether
>> it's
>> > new,
>> > but it seems to be wrong: Validation Violations:
>> > [ValidationViolation{property='id', message='Allowed range for length
>> [11,
>> > 11],
>> > length is 7', value=NAIROBI}]
>> UPDATE: only uid's >= 11char were imported - must be a bug
>> >
>> > I could have posted this as bug-report, but I wasn't sure, whether
>> those are
>> > bugs or features ...
>> >
>> > Regards,
>> >
>> > Uwe
>> >
>> > _______________________________________________
>> > 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
>>
>> _______________________________________________
>> 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
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> 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.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************

Follow ups

References