IS Okay now. Put categorycomboid = default and it will be fine. Thanks
2016-11-26 14:28 GMT+00:00 Calle Hedberg <calle.hedb...@gmail.com>: > 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.hedb...@gmail.com> > 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 <knu...@gmail.com> wrote: >> >>> Do you have access to the log from the server? >>> >>> On Nov 26, 2016 11:20 AM, "Aanyo AHIAGNO" <melopr...@gmail.com> 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 <knu...@gmail.com>: >>>> >>>>> 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 <melopr...@gmail.com> >>>>> 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@lists.launchpad.net >>>>>> 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@lists.launchpad.net >>> 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.hedb...@gmail.com >> >> 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.hedb...@gmail.com > > Skype: calle_hedberg > > ******************************************* > > -- AHIAGNO Aanyo HISP West Africa 0022890962285
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp