Import of descriptions with commas

Hi,

Hope all well.

Wondered if anyone had any experience importing data element descriptions that include commas.

Anticipating that might be a bit tricky with CSV import.

Any help would be greatly appreciated.

Cheers

Craig

Hi Craig,

you should generally double-quote those values.

E.g. “Collected daily, weekly”

regards,

Lars

···

On Wed, Jun 22, 2016 at 1:44 PM, Craig Hollingsworth craig.hollingsworth@nrc.no wrote:

Hi,

Hope all well.

Wondered if anyone had any experience importing data element descriptions that include commas.

Anticipating that might be a bit tricky with CSV import.

Any help would be greatly appreciated.

Cheers

Craig


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

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

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

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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Hi Craig,

Did you try with using quotation marks but still getting errors?

Knut

···

On Wed, Jun 22, 2016 at 1:44 PM, Craig Hollingsworth craig.hollingsworth@nrc.no wrote:

Hi,

Hope all well.

Wondered if anyone had any experience importing data element descriptions that include commas.

Anticipating that might be a bit tricky with CSV import.

Any help would be greatly appreciated.

Cheers

Craig


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

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

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

Hi,

Hope you’re well.

Thanks for the feedback. Had not tried, just wanted to check what best practice was.

The double quotes worked a treat!

Thanks for your help.

Cheers

Craig

···

From: Knut Staring [mailto:knutst@gmail.com]

Sent: 22 June 2016 12:57

To: Craig Hollingsworth

Cc: DHIS 2 Users list

Subject: Re: [Dhis2-users] Import of descriptions with commas

Hi Craig,

Did you try with using quotation marks but still getting errors?

Knut

On Wed, Jun 22, 2016 at 1:44 PM, Craig Hollingsworth craig.hollingsworth@nrc.no wrote:

Hi,

Hope all well.

Wondered if anyone had any experience importing data element descriptions that include commas.

Anticipating that might be a bit tricky with CSV import.

Any help would be greatly appreciated.

Cheers

Craig


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

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

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