Creating Sync between Linode(External Server) and Local Server

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@gmail.com]

Sent: 19 December 2014 21:49

To: Simon Muyambo

Cc: Jason Pickering; 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 smmuyambo@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

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@gmail.com]

Sent: 19 December 2014 07:03

To: Simon Muyambo

Cc: Jason Pickering;
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” smmuyambo@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.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10900 (20141218) __________

The message was checked by ESET NOD32 Antivirus.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10905 (20141219) __________

The message was checked by ESET NOD32 Antivirus.

–

Knut Staring

Dept. of Informatics, University of Oslo

Liberia: +231 770 496 123 or +231 886 146 381

Norway: +4791880522

Skype: knutstar

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10905 (20141219) __________

The message was checked by ESET NOD32 Antivirus.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10909 (20141220) __________

The message was checked by ESET NOD32 Antivirus.

Robin_Martens · 29 April 2015 17:22

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@lists.launchpad.net] On Behalf Of Robin Martens

Sent: 28 April 2015 16:35

To: Simon Muyambo; ‘Knut Staring’

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@lists.launchpad.net] On Behalf Of Simon Muyambo

Sent: 21 December 2014 02:17

To: ‘Knut Staring’; ‘Simon Muyambo’

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@gmail.com]

Sent: 19 December 2014 21:49

To: Simon Muyambo

Cc: Jason Pickering; 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 smmuyambo@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

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@gmail.com]

Sent: 19 December 2014 07:03

To: Simon Muyambo

Cc: Jason Pickering;
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” smmuyambo@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.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10900 (20141218) __________

The message was checked by ESET NOD32 Antivirus.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10905 (20141219) __________

The message was checked by ESET NOD32 Antivirus.

–

Knut Staring

Dept. of Informatics, University of Oslo

Liberia: +231 770 496 123 or +231 886 146 381

Norway: +4791880522

Skype: knutstar

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10905 (20141219) __________

The message was checked by ESET NOD32 Antivirus.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10909 (20141220) __________

The message was checked by ESET NOD32 Antivirus.

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

Lars · 29 April 2015 20:35

Hi there,

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

best regards,

Lars

···

On Wed, Apr 29, 2015 at 7:22 PM, Robin Martens martens@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=sher.be@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

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@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

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@gmail.com]

Sent: 19 December 2014 21:49

To: Simon Muyambo

Cc: Jason Pickering; 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 smmuyambo@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

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@gmail.com]

Sent: 19 December 2014 07:03

To: Simon Muyambo

Cc: Jason Pickering;
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” smmuyambo@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

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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Robin_Martens · 7 May 2015 12:57

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

Test.csv (113 Bytes)

···

From: Lars Helge Øverland [mailto:larshelge@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 martens@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=sher.be@lists.launchpad.net] On Behalf Of Robin Martens

Sent: 28 April 2015 16:35

To: Simon Muyambo; ‘Knut Staring’

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@lists.launchpad.net] On Behalf Of Simon Muyambo

Sent: 21 December 2014 02:17

To: ‘Knut Staring’; ‘Simon Muyambo’

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@gmail.com]

Sent: 19 December 2014 21:49

To: Simon Muyambo

Cc: Jason Pickering;
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 smmuyambo@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

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@gmail.com]

Sent: 19 December 2014 07:03

To: Simon Muyambo

Cc: Jason Pickering;
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” smmuyambo@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.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10900 (20141218) __________

The message was checked by ESET NOD32 Antivirus.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10905 (20141219) __________

The message was checked by ESET NOD32 Antivirus.

–

Knut Staring

Dept. of Informatics, University of Oslo

Liberia: +231 770 496 123 or +231 886 146 381

Norway: +4791880522

Skype: knutstar

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10905 (20141219) __________

The message was checked by ESET NOD32 Antivirus.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10909 (20141220) __________

The message was checked by ESET NOD32 Antivirus.

Knut_Staring · 7 May 2015 13:13

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@sher.be 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@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 martens@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=sher.be@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

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@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

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@gmail.com]

Sent: 19 December 2014 21:49

To: Simon Muyambo

Cc: Jason Pickering;
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 smmuyambo@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

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@gmail.com]

Sent: 19 December 2014 07:03

To: Simon Muyambo

Cc: Jason Pickering;
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” smmuyambo@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

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@lists.launchpad.net

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

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

Robin_Martens · 7 May 2015 15:50

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:knutst@gmail.com]

Sent: 07 May 2015 15:14

To: Robin Martens

Cc: Lars Helge Øverland; Simon Muyambo; dhis2-users@lists.launchpad.net

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 martens@sher.be 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@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:

best regards,

Lars

On Wed, Apr 29, 2015 at 7:22 PM, Robin Martens martens@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=sher.be@lists.launchpad.net] On Behalf Of Robin Martens

Sent: 28 April 2015 16:35

To: Simon Muyambo; ‘Knut Staring’

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@lists.launchpad.net] On Behalf Of Simon Muyambo

Sent: 21 December 2014 02:17

To: ‘Knut Staring’; ‘Simon Muyambo’

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@gmail.com]

Sent: 19 December 2014 21:49

To: Simon Muyambo

Cc: Jason Pickering;
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 smmuyambo@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

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@gmail.com]

Sent: 19 December 2014 07:03

To: Simon Muyambo

Cc: Jason Pickering;
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” smmuyambo@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.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10900 (20141218) __________

The message was checked by ESET NOD32 Antivirus.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10905 (20141219) __________

The message was checked by ESET NOD32 Antivirus.

–

Knut Staring

Dept. of Informatics, University of Oslo

Liberia: +231 770 496 123 or +231 886 146 381

Norway: +4791880522

Skype: knutstar

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10905 (20141219) __________

The message was checked by ESET NOD32 Antivirus.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10909 (20141220) __________

The message was checked by ESET NOD32 Antivirus.

–

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

Robin_Martens · 7 May 2015 15:57

A small update. I noticed the analytics module is also not working anymore so it’s probably not linked specifically to the import module. Here’s the catalina.out log from the analytics:

INFO 2015-05-07 15:07:18,046 [Level: INFO, category: DATAMART, time: Thu May 07 15:07:18 CAT 2015, message: Analytics table update process started] (InMemoryNotifier.java [taskScheduler-3])
INFO 2015-05-07 15:07:18,047 [Level: INFO, category: DATAMART, time: Thu May 07 15:07:18 CAT 2015, message: Updating resource tables] (InMemoryNotifier.java [taskScheduler-3])
WARN 2015-05-07 15:07:18,050 SQL Error: 0, SQLState: 42703 (SqlExceptionHelper.java [taskScheduler-3])
ERROR 2015-05-07 15:07:18,050 ERROR: column this_.query does not exist

Position: 275 (SqlExceptionHelper.java [taskScheduler-3])
INFO 2015-05-07 15:07:18,051 [Level: ERROR, category: DATAMART, time: Thu May 07 15:07:18 CAT 2015, message: Process failed: could not extract ResultSet] (InMemoryNotifier.java [taskScheduler-3])

I read in a previous post (see attached) this could be linked to the incorrect cleaning of the webapps folder when upgrading to 2.18 (which we recently did). Can this indeed be the issue and how to ensure it is properly cleaned when upgrading?

Regards,

Robin

···

From: Dhis2-users [mailto:dhis2-users-bounces+martens=sher.be@lists.launchpad.net] On Behalf Of Robin Martens

Sent: 07 May 2015 17:50

To: Knut Staring

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

Subject: Re: [Dhis2-users] inport meta data to option set

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:knutst@gmail.com]

Sent: 07 May 2015 15:14

To: Robin Martens

Cc: Lars Helge Øverland; Simon Muyambo; dhis2-users@lists.launchpad.net

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 martens@sher.be 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@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:

best regards,

Lars

On Wed, Apr 29, 2015 at 7:22 PM, Robin Martens martens@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=sher.be@lists.launchpad.net] On Behalf Of Robin Martens

Sent: 28 April 2015 16:35

To: Simon Muyambo; ‘Knut Staring’

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@lists.launchpad.net] On Behalf Of Simon Muyambo

Sent: 21 December 2014 02:17

To: ‘Knut Staring’; ‘Simon Muyambo’