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:larshe...@gmail.com] Sent: 29 April 2015 22:36 To: Robin Martens Cc: Simon Muyambo; Knut Staring; dhis2-users@lists.launchpad.net 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 <mart...@sher.be<mailto:mart...@sher.be>> 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>=sher...@lists.launchpad.net<mailto:sher...@lists.launchpad.net>] On Behalf Of Robin Martens Sent: 28 April 2015 16:35 To: Simon Muyambo; 'Knut Staring' Cc: dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> 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>=sher...@lists.launchpad.net<mailto:sher...@lists.launchpad.net>] On Behalf Of Simon Muyambo Sent: 21 December 2014 02:17 To: 'Knut Staring'; 'Simon Muyambo' Cc: dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> 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:knu...@gmail.com<mailto:knu...@gmail.com>] Sent: 19 December 2014 21:49 To: Simon Muyambo Cc: Jason Pickering; dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> 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 <smmuya...@gmail.com<mailto:smmuya...@gmail.com>> 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:knu...@gmail.com<mailto:knu...@gmail.com>] Sent: 19 December 2014 07:03 To: Simon Muyambo Cc: Jason Pickering; dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> 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" <smmuya...@gmail.com<mailto:smmuya...@gmail.com>> 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@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> 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 : dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Test.csv
Description: Test.csv
_______________________________________________ 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