Thanks Knut. However, I tried both with and without quotation marks. No difference. I also tried both adding an option to an existing option set and creating a new option set, also no difference…
From: Knut Staring [mailto:[email protected]] Sent: 07 May 2015 15:14 To: Robin Martens Cc: Lars Helge Øverland; Simon Muyambo; [email protected] Subject: Re: [Dhis2-users] inport meta data to option set I think all the headers have to be lower case, as in the manual? And everything else has to have quotation marks, including the optionsetname (Sector) On Thu, May 7, 2015 at 2:57 PM, Robin Martens <[email protected]<mailto:[email protected]>> wrote: Hi Lars, The changed format also doesn’t work, have the following error in Catalina. I wanted to see if I could recreate the error on the demo server but can’t access the import/export module. Is this temporarily (reset at midnight) or permanently? * INFO 2015-05-07 14:34:41,316 User 'admin' started import at Thu May 07 14:34:41 CAT 2015 (DefaultImportService.java [taskScheduler-7]) * INFO 2015-05-07 14:34:41,316 [Level: INFO, category: METADATA_IMPORT, time: Thu May 07 14:34:41 CAT 2015, message: Importing meta-data] (InMemoryNotifier.java [taskScheduler-7]) * INFO 2015-05-07 14:34:41,316 Building object-bridge maps (preheatCache: true). (DefaultObjectBridge.java [taskScheduler-7]) * WARN 2015-05-07 14:34:41,381 SQL Error: 0, SQLState: 42703 (SqlExceptionHelper.java [taskScheduler-7]) * ERROR 2015-05-07 14:34:41,382 ERROR: column this_.query does not exist Position: 275 (SqlExceptionHelper.java [taskScheduler-7]) My import settings were: • CSV • Dry run YES • Option set Attached the file I tried to import (just a single option for a single optionset). Regards, Robin From: Lars Helge Øverland [mailto:[email protected]<mailto:[email protected]>] Sent: 29 April 2015 22:36 To: Robin Martens Cc: Simon Muyambo; Knut Staring; [email protected]<mailto:[email protected]> Subject: Re: [Dhis2-users] inport meta data to option set 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 <[email protected]<mailto:[email protected]>> 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<mailto:dhis2-users-bounces%2Bmartens>[email protected]<mailto:[email protected]>] On Behalf Of Robin Martens Sent: 28 April 2015 16:35 To: Simon Muyambo; 'Knut Staring' Cc: [email protected]<mailto:[email protected]> 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<mailto:dhis2-users-bounces%2Bmartens>[email protected]<mailto:[email protected]>] On Behalf Of Simon Muyambo Sent: 21 December 2014 02:17 To: 'Knut Staring'; 'Simon Muyambo' Cc: [email protected]<mailto:[email protected]> 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:[email protected]<mailto:[email protected]>] Sent: 19 December 2014 21:49 To: Simon Muyambo Cc: Jason Pickering; [email protected]<mailto:[email protected]> 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 <[email protected]<mailto:[email protected]>> 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:[email protected]<mailto:[email protected]>] Sent: 19 December 2014 07:03 To: Simon Muyambo Cc: Jason Pickering; [email protected]<mailto:[email protected]> 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" <[email protected]<mailto:[email protected]>> 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 : [email protected]<mailto:[email protected]> 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<tel:%2B231%20770%20496%20123> or +231 886 146 381 Norway: +4791880522<tel:%2B4791880522> 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 : [email protected]<mailto:[email protected]> 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-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
