dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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 <martens@xxxxxxx> 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:larshelge@xxxxxxxxx]
> *Sent:* 29 April 2015 22:36
> *To:* Robin Martens
> *Cc:* Simon Muyambo; Knut Staring; dhis2-users@xxxxxxxxxxxxxxxxxxx
>
> *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 <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
>
>
>



-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org