dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi there,

the CSV option set import format changed in 2.18. The option code is now
required. Have a look at the docs:

https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s09.html


best regards,

Lars



On Wed, Apr 29, 2015 at 7:22 PM, Robin Martens <martens@xxxxxxx> wrote:

>  Hi all,
>
>
>
> Did anyone encounter the same issue as the one described below? I.e.
> import conflicts when importing option sets (via CSV)?
>
>
>
> Thanks in advance,
>
>
>
> Robin
>
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+martens=
> sher.be@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Robin Martens
> *Sent:* 28 April 2015 16:35
> *To:* Simon Muyambo; 'Knut Staring'
>
> *Cc:* dhis2-users@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Dhis2-users] inport meta data to option set
>
>
>
> Hi Simon and Knut,
>
>
>
> I’m currently facing the same issue. Did you manage to solve it at the
> time and if so, how?
>
>
>
> Kind regards,
>
>
>
> Robin
>
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+martens=
> sher.be@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Simon Muyambo
> *Sent:* 21 December 2014 02:17
> *To:* 'Knut Staring'; 'Simon Muyambo'
> *Cc:* dhis2-users@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Dhis2-users] inport meta data to option set
>
>
>
> Dear Knut
>
>
>
> I have created option set and exported it in JSON. I then deleted the
> optionset and tried to import it. Below are the same errors I am getting
> with csv file. Never seems to be able to import members of the option set
>
>
>
> Current user:
>
> admin
>
> Version:
>
> 2.17
>
> Build revision:
>
> 17561
>
> Build date:
>
> 2014-11-21 12:21
>
>
>
>
>
>
> {"created":"2014-12-20T23:44:06.855+0000","optionSets":[{"id":"etvtSKUhoSZ","name":"prog","created":"2014-12-
>
>
>
>
> 20T23:42:20.447+0000","lastUpdated":"2014-12-20T23:43:21.551+0000","options":
>
>
>
>
> [{"id":"v0DNS4VKf40","code":"g1","name":"George","created":"2014-12-20T23:43:07.726+0000","lastUpdated":"2014-12-
>
>
>
>
> 20T23:43:07.726+0000"},{"id":"Ghi9DN5UYfu","code":"t1","name":"Tom","created":"2014-12-20T23:43:21.550+0000","lastUpdated":"2014-
>
>
>
> 12-20T23:43:21.550+0000"}],"version":1}]}
>
>
>
> Import summary
>
> Import count
>
> 1 Imported
>
> 0 Updated
>
> 0 Ignored
>
> Type Summary
>
> Type      Imported             Updated              Ignored
>
> OptionSet           1              0              0
>
> Conflicts
>
> Type      Element               Description
>
> OptionSet           prog       Unknown reference to
> IdentifiableObject{id=0, uid='v0DNS4VKf40', code='g1', name='George',
> created=Sun Dec 21 01:43:07 CAT 2014, lastUpdated=Sun Dec 21 01:43:07 CAT
> 2014} (Option) on object IdentifiableObject{id=3, uid='etvtSKUhoSZ',
> code='null', name='prog', created=Sun Dec 21 01:42:20 CAT 2014,
> lastUpdated=Sun Dec 21 02:09:50 CAT 2014} (OptionSet).
>
> OptionSet           prog       Unknown reference to
> IdentifiableObject{id=0, uid='Ghi9DN5UYfu', code='t1', name='Tom',
> created=Sun Dec 21 01:43:21 CAT 2014, lastUpdated=Sun Dec 21 01:43:21 CAT
> 2014} (Option) on object IdentifiableObject{id=3, uid='etvtSKUhoSZ',
> code='null', name='prog', created=Sun Dec 21 01:42:20 CAT 2014,
> lastUpdated=Sun Dec 21 02:09:50 CAT 2014} (OptionSet).
>
>
>
> *Regards*
>
> *Simon Muyambo*
>
>
>
>
>
> *From:* Knut Staring [mailto:knutst@xxxxxxxxx]
> *Sent:* 19 December 2014 21:49
> *To:* Simon Muyambo
> *Cc:* Jason Pickering; dhis2-users@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Dhis2-users] inport meta data to option set
>
>
>
> I think you need to have quotes aroudn any text strings, including the
> codes
>
>
>
> On Fri, Dec 19, 2014 at 8:40 PM, Simon Muyambo <smmuyambo@xxxxxxxxx>
> wrote:
>
> Dear Knut and Jason
>
>
>
> Thanks for the advice. I have run some tests with unique codes but not
> sure what the error means
>
>
>
> name,uid,code,option
>
> "Colorsm",,1b,"Blue1"
>
> "Colorsm",,2g,"Green1"
>
> "Gendersm",,3f,"Female1"
>
> "Gendersm",,4m,"Male1"
>
> *Import summary*
>
> *Import count*
>
> 2 Imported
> 2 Updated
> 0 Ignored
>
> *Type Summary*
>
> Type
>
> Imported
>
> Updated
>
> Ignored
>
> OptionSet
>
> 2
>
> 2
>
> 0
>
> *Conflicts*
>
> *Type*
>
> *Element*
>
> *Description*
>
> OptionSet
>
> Gendersm
>
> Unknown reference to IdentifiableObject{id=0, uid='Ja0hb0d1XGK',
> code='Female1', name='Female1', created=Fri Dec 19 21:34:19 CAT 2014,
> lastUpdated=Fri Dec 19 21:34:19 CAT 2014} (Option) on object
> IdentifiableObject{id=0, uid='qvy5Iof8De3', code='3f', name='Gendersm',
> created=null, lastUpdated=null} (OptionSet).
>
> OptionSet
>
> Colorsm
>
> Unknown reference to IdentifiableObject{id=0, uid='jPyLUhETxWH',
> code='Green1', name='Green1', created=Fri Dec 19 21:34:19 CAT 2014,
> lastUpdated=Fri Dec 19 21:34:19 CAT 2014} (Option) on object
> IdentifiableObject{id=0, uid='JGfUphTsLuk', code='2g', name='Colorsm',
> created=null, lastUpdated=null} (OptionSet).
>
> OptionSet
>
> Gendersm
>
> Unknown reference to IdentifiableObject{id=0, uid='mJsHyly4UoH',
> code='Male1', name='Male1', created=Fri Dec 19 21:34:19 CAT 2014,
> lastUpdated=Fri Dec 19 21:34:19 CAT 2014} (Option) on object
> IdentifiableObject{id=0, uid='IxdnSBPyo9y', code='4m', name='Gendersm',
> created=null, lastUpdated=null} (OptionSet).
>
> OptionSet
>
> Colorsm
>
> Unknown reference to IdentifiableObject{id=0, uid='pSmhTjz0yIS',
> code='Blue1', name='Blue1', created=Fri Dec 19 21:34:19 CAT 2014,
> lastUpdated=Fri Dec 19 21:34:19 CAT 2014} (Option) on object
> IdentifiableObject{id=0, uid='MVHPvOLojgd', code='1b', name='Colorsm',
> created=null, lastUpdated=null} (OptionSet).
>
>
>
>
>
> *Regards*
>
> *Simon Muyambo*
>
>
>
>
>
> *From:* Knut Staring [mailto:knutst@xxxxxxxxx]
> *Sent:* 19 December 2014 07:03
> *To:* Simon Muyambo
> *Cc:* Jason Pickering; dhis2-users@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Dhis2-users] inport meta data to option set
>
>
>
> I think maybe you have to have something in the code field
>
> On 19 Dec 2014 02:54, "Simon Muyambo" <smmuyambo@xxxxxxxxx> wrote:
>
> Dear Jason
>
>
>
> Please advise on the import of option set. I find option set is important
> but the members are not when I use CSV import. Any ideas? See example below
>
> name,uid,code,option
>
> Color,,,"Blue"
>
> Color,,,"Green"
>
> Gender,,,"Female"
>
> Gender,,,"Male"
>
>
>
>
>
> *Regards*
>
> *Simon Muyambo*
>
>
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 10900 (20141218) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.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
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 10900 (20141218) __________
>
>
>
> The message was checked by ESET NOD32 Antivirus.
>
>
>
> http://www.eset.com
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 10905 (20141219) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
>
>
> --
>
> Knut Staring
>
> Dept. of Informatics, University of Oslo
>
> Liberia: +231 770 496 123 or +231 886 146 381
>
> Norway: +4791880522
>
> Skype: knutstar
>
> http://dhis2.org
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 10905 (20141219) __________
>
>
>
> The message was checked by ESET NOD32 Antivirus.
>
>
>
> http://www.eset.com
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 10909 (20141220) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.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
>
>