← Back to team overview

dhis2-users team mailing list archive

Re: inport meta data to option set

 

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<mailto: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<mailto:dhis2-users-bounces%2Bmartens>=sher.be@xxxxxxxxxxxxxxxxxxx<mailto:sher.be@xxxxxxxxxxxxxxxxxxx>] On Behalf Of Robin Martens
Sent: 28 April 2015 16:35
To: Simon Muyambo; 'Knut Staring'

Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto: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<mailto:dhis2-users-bounces%2Bmartens>=sher.be@xxxxxxxxxxxxxxxxxxx<mailto:sher.be@xxxxxxxxxxxxxxxxxxx>] On Behalf Of Simon Muyambo
Sent: 21 December 2014 02:17
To: 'Knut Staring'; 'Simon Muyambo'
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto: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<mailto:knutst@xxxxxxxxx>]
Sent: 19 December 2014 21:49
To: Simon Muyambo
Cc: Jason Pickering; dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto: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<mailto: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<mailto:knutst@xxxxxxxxx>]
Sent: 19 December 2014 07:03
To: Simon Muyambo
Cc: Jason Pickering; dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto: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<mailto: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<mailto: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<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@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Attachment: Test.csv
Description: Test.csv


Follow ups

References