dhis2-devs team mailing list archive

Thread
Date
Re: Problem on CSV Data Element import - Version 2.25

To: calle.hedberg@xxxxxxxxx
From: Aanyo AHIAGNO <meloprod7@xxxxxxxxx>
Date: Sat, 26 Nov 2016 15:13:31 +0000
Cc: DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAPB4dVgYNREmGFHJvP6kuEZUtPPY+EdSsHRW7t7s-CUo5isboQ@mail.gmail.com>
IS Okay now.
Put categorycomboid = default and it will be fine.

Thanks

2016-11-26 14:28 GMT+00:00 Calle Hedberg <calle.hedberg@xxxxxxxxx>:

> Hi,
>
> I've tested this with the simplest CSV file imagineable - just two data
> element names:
> "Emergency headcount total"
> "OPD headcount not referred new"
> Error is the same
>
> The manual states very clearly that the ONLY compulsory field when
> importing Data Elements in CSV format is the first "Name" field.
>
> Bottom line - the import from CSV is broken in 2.25 and 2.26 Trunk. OR
> ELSE there is something missing from our installations, some library or
> something.
>
> Sigh - I hope this can be fixed asap, it's a real real pain to have to
> shift an instance back to e.g. 2.24 or earlier to make this type of basic
> functionality work
>
> Regards
> Calle
>
> On 26 November 2016 at 16:10, Calle Hedberg <calle.hedberg@xxxxxxxxx>
> wrote:
>
>> Hi,
>>
>> I've just tried the same in Trunk - importing a CSV file with data
>> elements, same format as what used to work in previous versions. My tomcat
>> log shows the following:
>>
>> * INFO  2016-11-26 16:04:24,017 (Calle_Hedberg) Import:Preheat[REFERENCE]
>> took 0.11 seconds (DefaultPreheatService.java [taskScheduler-8])
>> * ERROR 2016-11-26 16:04:24,027 Unexpected error occurred in scheduled
>> task. (TaskUtils.java [taskScheduler-8])
>> org.hibernate.LazyInitializationException: failed to lazily initialize a
>> collection of role: org.hisp.dhis.dataelement.Data
>> ElementCategoryCombo.translations, could not initialize p
>> roxy - no Session
>>         at org.hibernate.collection.internal.AbstractPersistentCollecti
>> on.throwLazyInitializationException(AbstractPersistentCollec
>> tion.java:579)
>>         at org.hibernate.collection.internal.AbstractPersistentCollecti
>> on.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:203)
>>         at org.hibernate.collection.internal.AbstractPersistentCollecti
>> on.initialize(AbstractPersistentCollection.java:558)
>>         at org.hibernate.collection.internal.AbstractPersistentCollecti
>> on.read(AbstractPersistentCollection.java:131)
>>         at org.hibernate.collection.internal.PersistentSet.iterator(
>> PersistentSet.java:163)
>>         at java.util.AbstractCollection.addAll(Unknown Source)
>>         at org.hisp.dhis.common.BaseIdentifiableObject.mergeWith(BaseId
>> entifiableObject.java:763)
>>         at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith
>> (DataElementCategoryCombo.java:327)
>>         at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith
>> (DataElementCategoryCombo.java:51)
>>         at org.hisp.dhis.preheat.DefaultPreheatService.lambda$collectOb
>> jectReferences$28(DefaultPreheatService.java:635)
>>         at java.util.ArrayList.forEach(Unknown Source)
>>         at org.hisp.dhis.preheat.DefaultPreheatService.collectObjectRef
>> erences(DefaultPreheatService.java:624)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
>> Source)
>>         at java.lang.reflect.Method.invoke(Unknown Source)
>>         at org.springframework.aop.support.AopUtils.invokeJoinpointUsin
>> gReflection(AopUtils.java:302)
>>         at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .invokeJoinpoint(ReflectiveMethodInvocation.java:190)
>>         at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:157)
>>         at org.springframework.transaction.interceptor.TransactionInter
>> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>>         at org.springframework.transaction.interceptor.TransactionAspec
>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
>>         at org.springframework.transaction.interceptor.TransactionInter
>> ceptor.invoke(TransactionInterceptor.java:96)
>>         at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:179)
>>         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
>> JdkDynamicAopProxy.java:208)
>>         at com.sun.proxy.$Proxy236.collectObjectReferences(Unknown
>> Source)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
>> Source)
>>         at java.lang.reflect.Method.invoke(Unknown Source)
>>         at org.springframework.aop.support.AopUtils.invokeJoinpointUsin
>> gReflection(AopUtils.java:302)
>>         at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .invokeJoinpoint(ReflectiveMethodInvocation.java:190)
>>         at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:157)
>>         at org.springframework.aop.support.DelegatingIntroductionInterc
>> eptor.doProceed(DelegatingIntroductionInterceptor.java:133)
>>         at org.springframework.aop.support.DelegatingIntroductionInterc
>> eptor.invoke(DelegatingIntroductionInterceptor.java:121)
>>         at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:179)
>>         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
>> JdkDynamicAopProxy.java:208)
>>         at com.sun.proxy.$Proxy165.collectObjectReferences(Unknown
>> Source)
>>         at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundle
>> Service.create(DefaultObjectBundleService.java:113)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
>> Source)
>>         at java.lang.reflect.Method.invoke(Unknown Source)
>>         at org.springframework.aop.support.AopUtils.invokeJoinpointUsin
>> gReflection(AopUtils.java:302)
>>         at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .invokeJoinpoint(ReflectiveMethodInvocation.java:190)
>>         at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:157)
>>         at org.springframework.transaction.interceptor.TransactionInter
>> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>>         at org.springframework.transaction.interceptor.TransactionAspec
>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
>>         at org.springframework.transaction.interceptor.TransactionInter
>> ceptor.invoke(TransactionInterceptor.java:96)
>>         at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:179)
>>         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
>> JdkDynamicAopProxy.java:208)
>>         at com.sun.proxy.$Proxy186.create(Unknown Source)
>>         at org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.imp
>> ortMetadata(DefaultMetadataImportService.java:107)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
>> Source)
>>         at java.lang.reflect.Method.invoke(Unknown Source)
>>         at org.springframework.aop.support.AopUtils.invokeJoinpointUsin
>> gReflection(AopUtils.java:302)
>>         at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .invokeJoinpoint(ReflectiveMethodInvocation.java:190)
>>         at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:157)
>>         at org.springframework.transaction.interceptor.TransactionInter
>> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>>         at org.springframework.transaction.interceptor.TransactionAspec
>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
>>         at org.springframework.transaction.interceptor.TransactionInter
>> ceptor.invoke(TransactionInterceptor.java:96)
>>         at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:179)
>>         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
>> JdkDynamicAopProxy.java:208)
>>         at com.sun.proxy.$Proxy188.importMetadata(Unknown Source)
>>         at org.hisp.dhis.importexport.action.util.ImportMetaDataCsvTask
>> .call(ImportMetaDataCsvTask.java:98)
>>         at org.hisp.dhis.security.SecurityContextRunnable.run(SecurityC
>> ontextRunnable.java:57)
>>         at org.springframework.scheduling.support.DelegatingErrorHandli
>> ngRunnable.run(DelegatingErrorHandlingRunnable.java:54)
>>         at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
>> Source)
>>         at java.util.concurrent.FutureTask.run(Unknown Source)
>>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
>> Source)
>>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
>> Source)
>>         at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
>> Source)
>>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
>> Source)
>>         at java.lang.Thread.run(Unknown Source)
>>
>>
>> Regards
>> Calle
>>
>> On 26 November 2016 at 12:34, Knut Staring <knutst@xxxxxxxxx> wrote:
>>
>>> Do you have access to the log from the server?
>>>
>>> On Nov 26, 2016 11:20 AM, "Aanyo AHIAGNO" <meloprod7@xxxxxxxxx> wrote:
>>>
>>>> Thanks,
>>>>
>>>> I making a test, so i try to import on my csv just 2 data element.
>>>> but it load too long. i'm not sure that is working.
>>>> i join my csv.
>>>> 2016-11-26 09:41:46 (admin) Import:Start
>>>>
>>>>
>>>>
>>>> [image: Images intégrées 1]
>>>>
>>>>
>>>> Thanks
>>>>
>>>> 2016-11-26 10:10 GMT+00:00 Knut Staring <knutst@xxxxxxxxx>:
>>>>
>>>>> Hi Aanyo,
>>>>>
>>>>> Could you describe what is happening? "Is not working" is not very
>>>>> helpful for understanding what the problem might be.
>>>>>
>>>>> Knut
>>>>>
>>>>> On Sat, Nov 26, 2016 at 11:06 AM, Aanyo AHIAGNO <meloprod7@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Hi all,
>>>>>>
>>>>>> The CSV data elemnt import does not work well on the 2.25. Does
>>>>>> someone have a good template CSV of Data Element for 2.25?
>>>>>>
>>>>>> *Is not working*
>>>>>>
>>>>>> [image: Images intégrées 1]
>>>>>>
>>>>>> *Is not working*
>>>>>>
>>>>>> name,uid,code,shortname,description,formname,domaintype,valu
>>>>>> etype,aggregationtype,categorycomboid,url,zeroissignificant,optionset
>>>>>> DS_Polio 1st dose given,,,DS_Polio 1st dose given,,DS_Polio 1st dose
>>>>>> given,AGGREGATE,TEXT,,GvTQH2bALqZ,,,beLZmBucDZa
>>>>>>
>>>>>> *Is not working*
>>>>>>
>>>>>> name,uid,code,shortname,description
>>>>>> "Women participated in skill development training",,"D0001","Women
>>>>>> participated
>>>>>> development training"
>>>>>> "Women participated in community organizations",,"D0002","Women
>>>>>> participated community
>>>>>> organizations"
>>>>>>
>>>>>>
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> --
>>>>>> AHIAGNO Aanyo
>>>>>> HISP West Africa
>>>>>> 0022890962285
>>>>>>
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Knut Staring
>>>>> Dept. of Informatics, University of Oslo
>>>>> Norway: +4791880522
>>>>> Skype: knutstar
>>>>> http://dhis2.org
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> AHIAGNO Aanyo
>>>> HISP West Africa
>>>> 0022890962285
>>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>>
>> *******************************************
>>
>> Calle Hedberg
>>
>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>
>> Tel/fax (home): +27-21-685-6472
>>
>> Cell: +27-82-853-5352
>>
>> Iridium SatPhone: +8816-315-19119
>>
>> Email: calle.hedberg@xxxxxxxxx
>>
>> Skype: calle_hedberg
>>
>> *******************************************
>>
>>
>
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>


-- 
AHIAGNO Aanyo
HISP West Africa
0022890962285
Follow ups

Re: Problem on CSV Data Element import - Version 2.25
From: Calle Hedberg, 2016-11-26
References

Problem on CSV Data Element import - Version 2.25
From: Aanyo AHIAGNO, 2016-11-26
Re: Problem on CSV Data Element import - Version 2.25
From: Knut Staring, 2016-11-26
Re: Problem on CSV Data Element import - Version 2.25
From: Aanyo AHIAGNO, 2016-11-26
Re: Problem on CSV Data Element import - Version 2.25
From: Knut Staring, 2016-11-26
Re: Problem on CSV Data Element import - Version 2.25
From: Calle Hedberg, 2016-11-26
Re: Problem on CSV Data Element import - Version 2.25
From: Calle Hedberg, 2016-11-26