Event importer

Channara · 24 January 2017 10:54

Dear DHIS2 all,
any one successful using event importer function in DHIS2?

I try many time, but always this display error like below:

Here is the sample csv file for import

DHIS2 version 2.25

Build date:2017-01-16 06:37

thank you

channara

Furqonuddin_Ramdhani · 24 February 2017 00:37

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

events.csv (2.63 KB)

···

On Tue, Jan 24, 2017 at 5:54 PM, channara rin rin.channara@gmail.com wrote:

Dear DHIS2 all,
any one successful using event importer function in DHIS2?

I try many time, but always this display error like below:

Here is the sample csv file for import

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

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

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

–

Salam
Furqonuddin Ramdhani

jason · 24 February 2017 09:16

Hi there.
Looks like a problem parsing the date.

Could you change

2016-11-13T17:00:00.000+0000

to

2016-11-13

And see if that helps?

Regards,

Jason

···

On Fri, Feb 24, 2017 at 1:37 AM, Furqonuddin Ramdhani furqon17@gmail.com wrote:

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

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

–

On Tue, Jan 24, 2017 at 5:54 PM, channara rin rin.channara@gmail.com wrote:

Dear DHIS2 all,
any one successful using event importer function in DHIS2?

I try many time, but always this display error like below:

Here is the sample csv file for import

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

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

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

Salam
Furqonuddin Ramdhani

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049