← Back to team overview

dhis2-devs team mailing list archive

Re: Event importer

 

I'm also have problem using event import function.

*In the browser I got error :*
2017-02-24 00:29:38 Process failed: Invalid format: ""
2017-02-24 00:29:38 Importing events

*In the log file :*
* ERROR 2017-02-24 07:29:38,403 java.lang.IllegalArgumentException: Invalid
format: ""
        at
org.joda.time.format.DateTimeFormatter.parseDateTime(DateTimeFormatter.java:899)
        at org.hisp.dhis.system.util.DateUtils.parseDate(DateUtils.java:665)
        at
org.hisp.dhis.dxf2.events.event.AbstractEventService.saveEvent(AbstractEventService.java:1026)
        at
org.hisp.dhis.dxf2.events.event.AbstractEventService.addEvent(AbstractEventService.java:417)
        at
org.hisp.dhis.dxf2.events.event.AbstractEventService.addEvents(AbstractEventService.java:209)
        at
org.hisp.dhis.dxf2.events.event.AbstractEventService.addEvents(AbstractEventService.java:229)
        at sun.reflect.GeneratedMethodAccessor1254.invoke(Unknown Source)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
        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.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
        at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
        at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
        at com.sun.proxy.$Proxy375.addEvents(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor1254.invoke(Unknown Source)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
        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.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
        at
org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
        at com.sun.proxy.$Proxy343.addEvents(Unknown Source)
        at
org.hisp.dhis.dxf2.events.event.ImportEventsTask.call(ImportEventsTask.java:63)
        at
org.hisp.dhis.security.SecurityContextRunnable.run(SecurityContextRunnable.java:57)
        at
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
        at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
 (AbstractEventService.java [taskScheduler-3])
* INFO  2017-02-24 07:29:38,403 [Level: ERROR, category: EVENT_IMPORT,
time: Fri Feb 24 07:29:38 WIB 2017, message: Process failed: Invalid
format: ""] (InMemoryNotifier.java [taskScheduler-3])

I attached my sample data. any suggestion ?

Regards,
Dhani


On Tue, Jan 24, 2017 at 5:54 PM, channara rin <rin.channara@xxxxxxxxx>
wrote:

> Dear DHIS2 all,
> any one successful using event importer function in DHIS2?
> I try many time, but always this display error like below:
> [image: Inline image 1]
> Here is the sample csv file for import
> [image: Inline image 2]
>
> DHIS2 version 2.25
> Build date:2017-01-16 06:37
>
> thank you
> channara
>
> _______________________________________________
> 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
>
>


-- 
Salam
*Furqonuddin Ramdhani*

PNG image

PNG image

event,status,program,programStage,enrollment,orgUnit,eventDate,dueDate,latitude,longitude,dataElement,value,storedBy,providedElsewhere
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,WSgxCBozxdW,531800002,admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,twMQYfpYK2G,kampredos,admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,Cp2cHT336U9,leuwigajah,admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,DBwzWETiMyA,3,admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,eM8yoVQ4ZTq,53180001,admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,eq6Q7CA6lir,1,admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,pjJkSPTBtla,"5 / 71",admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,N3mOHozcJqX,Waikadada,admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,AzyWu2YL5np,"Kodi Bangedo",admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,mSBrP7c8li6,"Sumba Barat Daya",admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,knYEMPgdPnn,"Nusa Tenggara Timur",admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,x2kdQFPcoJT,4,admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,EGUGv8PsqON,2,admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,suFnKPQt16t,"Hekka Milla",admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,HMTQaZJXSYt,"pinang emas 6 blok uq",admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,qwhmvER1Moy,1234567890,admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,HPWIySnKrLy,87808131984,admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,O1UIrn5Fgnr,2015-01-01,admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,x9BFASr6QF1,2,admin,false
VlETOeYw4Ft,COMPLETED,QxauNvjcpBw,IQgRCcDe2Sh,,mVOklAKcRLf,"2016-11-13T17:00:00.000+0000",,,,hgRo1qiF4rQ,"Yohanes H. Ngara ",admin,false

Follow ups

References