CSV import - specification of data type formats

Hi,

Two quick questions re CSV import - I cannot seem to find the relevant paragraphs in the documentation:

What are the exact formats to use in the value field for data types

  • yes/no (yes/no? Y/N? Yes/No? true/false? 1/0?)

  • yes

  • date

Secondly, when importing CSV data values for data elements defined as “username” - does it require all values (usernames) to be valid DHIS2 users?

Regards

Calle

···

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@gmail.com

Skype: calle_hedberg


Good questions, I suppose some could be gathered from doing an export to CSV (or maybe not)?

http://dhis2.github.io/dhis2-docs/master/en/user/html/ch21s03.html#d5e4002

···

On Thu, Feb 4, 2016 at 12:28 PM, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi,

Two quick questions re CSV import - I cannot seem to find the relevant paragraphs in the documentation:

What are the exact formats to use in the value field for data types

  • yes/no (yes/no? Y/N? Yes/No? true/false? 1/0?)
  • yes
  • date

Secondly, when importing CSV data values for data elements defined as “username” - does it require all values (usernames) to be valid DHIS2 users?

Regards

Calle


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@gmail.com

Skype: calle_hedberg



Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Hi Calle,

···

On Thu, Feb 4, 2016 at 12:28 PM, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi,

Two quick questions re CSV import - I cannot seem to find the relevant paragraphs in the documentation:

What are the exact formats to use in the value field for data types

  • yes/no (yes/no? Y/N? Yes/No? true/false? 1/0?)

true | false

  • yes

true

  • date

dd.mm.yyyy

Secondly, when importing CSV data values for data elements defined as “username” - does it require all values (usernames) to be valid DHIS2 users?

No.

regards,

Lars

Regards

Calle


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@gmail.com

Skype: calle_hedberg



Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Lars,

Thanks - true/false is noted for boolean.

But just to confirm re dates: WHY are you using dd.mm.yyyy for csv import when all other dates in DHIS tend to be yyyy-mm-dd?

Regards

Calle

···

On 4 February 2016 at 16:04, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Calle,

On Thu, Feb 4, 2016 at 12:28 PM, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi,

Two quick questions re CSV import - I cannot seem to find the relevant paragraphs in the documentation:

What are the exact formats to use in the value field for data types

  • yes/no (yes/no? Y/N? Yes/No? true/false? 1/0?)

true | false

  • yes

true

  • date

dd.mm.yyyy

Secondly, when importing CSV data values for data elements defined as “username” - does it require all values (usernames) to be valid DHIS2 users?

No.

regards,

Lars

Regards

Calle


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@gmail.com

Skype: calle_hedberg



Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org


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@gmail.com

Skype: calle_hedberg