← Back to team overview

dhis2-users team mailing list archive

Re: CSV data import error

 

Hi Knut...
Thanks for the quick response.Am using 2.14.I realised it works when dry
run= no, Initially I was using dry run = Yes and this is where the probles
was starting.okie dokie


On Wed, Jul 30, 2014 at 7:43 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> Hi there,
>
> Which version and build number of DHIS2?
>
> It seems there is a problem with periods, as it says in your log excerpt:
> "At least one period must be specified"
>
> It might be easier to tell if you can share (some of) the file you are
> trying to import.
>
> Knut
>
>
> On Wed, Jul 30, 2014 at 6:39 PM, Isika Oliver <ioliver750@xxxxxxxxx>
> wrote:
>
>> Hi team,
>>
>> I am trying to import some .CSV data to DHIS2 .From the application
>> point of view , it indicated that the update was successful but when I
>> check the datavalues table there are no updates. Below is the Tomcat log
>> output.Kindly advice where I may be going wrong.
>>
>> * INFO  2014-07-30 17:26:16,693 [data element id scheme: UID, org unit
>> id scheme: UID, dry run: true, async: false, strategy: NEW_AND_UPDATES,
>> skip check: false] (ImportDataValueAction.java [http-bio-8080-exec-10])
>> * INFO  2014-07-30 17:26:16,694 [Level: INFO, category:
>> DATAVALUE_IMPORT, time: Wed Jul 30 17:26:16 EAT 2014, message: Process
>> started] (InMemoryNotifier.java [taskScheduler-2])
>> * INFO  2014-07-30 17:26:17,373 [Level: INFO, category:
>> DATAVALUE_IMPORT, time: Wed Jul 30 17:26:17 EAT 2014, message: Importing
>> data values] (InMemoryNotifier.java [taskScheduler-2])
>> * INFO  2014-07-30 17:26:17,373 importing data values
>> (DefaultDataValueSetService.
>>>
>>> java [taskScheduler-2])
>>> * INFO  2014-07-30 17:26:17,386 [Level: INFO, category:
>>> DATAVALUE_IMPORT, time: Wed Jul 30 17:26:17 EAT 2014, message: Import
>>> done] (InMemoryNotifier.java [taskScheduler-2])
>>> * INFO  2014-07-30 17:29:00,930 [data element id scheme: UID, org unit
>>> id scheme: UID, dry run: true, async: false, strategy: NEW_AND_UPDATES,
>>> skip check: false] (ImportDataValueAction.java [http-bio-8080-exec-6])
>>> * INFO  2014-07-30 17:29:00,931 [Level: INFO, category:
>>> DATAVALUE_IMPORT, time: Wed Jul 30 17:29:00 EAT 2014, message: Process
>>> started] (InMemoryNotifier.java [taskScheduler-1])
>>> * INFO  2014-07-30 17:29:01,704 [Level: INFO, category:
>>> DATAVALUE_IMPORT, time: Wed Jul 30 17:29:01 EAT 2014, message: Importing
>>> data values] (InMemoryNotifier.java [taskScheduler-1])
>>> * INFO  2014-07-30 17:29:01,705 importing data values
>>> (DefaultDataValueSetService.java [taskScheduler-1])
>>> * INFO  2014-07-30 17:29:01,714 [Level: INFO, category:
>>> DATAVALUE_IMPORT, time: Wed Jul 30 17:29:01 EAT 2014, message: Import
>>> done] (InMemoryNotifier.java [taskScheduler-1])
>>> * INFO  2014-07-30 17:29:17,873 [data element id scheme: UID, org unit
>>> id scheme: UID, dry run: true, async: false, strategy: NEW_AND_UPDATES,
>>> skip check: false] (ImportDataValueAction.java [http-bio-8080-exec-11])
>>> * INFO  2014-07-30 17:29:17,874 [Level: INFO, category:
>>> DATAVALUE_IMPORT, time: Wed Jul 30 17:29:17 EAT 2014, message: Process
>>> started] (InMemoryNotifier.java [taskScheduler-3])
>>> * INFO  2014-07-30 17:29:18,574 [Level: INFO, category:
>>> DATAVALUE_IMPORT, time: Wed Jul 30 17:29:18 EAT 2014, message: Importing
>>> data values] (InMemoryNotifier.java [taskScheduler-3])
>>> * INFO  2014-07-30 17:29:18,574 importing data values
>>> (DefaultDataValueSetService.java [taskScheduler-3])
>>> * INFO  2014-07-30 17:29:18,580 [Level: INFO, category:
>>> DATAVALUE_IMPORT, time: Wed Jul 30 17:29:18 EAT 2014, message: Import
>>> done] (InMemoryNotifier.java [taskScheduler-3])
>>> * ERROR 2014-07-30 17:33:38,064 Error while executing action
>>> (ExceptionInterceptor.java [http-bio-8080-exec-11])
>>> java.lang.IllegalArgumentException: At least one period must be
>>> specified
>>>         at
>>>
>>> org.hisp.dhis.dxf2.datavalueset.DefaultDataValueSetService.writeDataValueSetCsv(DefaultDataValueSetService.java:183)
>>>         at
>>>
>>> org.hisp.dhis.importexport.action.datavalue.ExportDataValueAction.execute(ExportDataValueAction.java:139)
>>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>         at
>>>
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>>
>>
>>
>> --
>> Yours Truly.
>> Munyao I. Oliver.
>> P.o Box 1134,
>> Kangundo,Kenya.
>>
>>
>> *When you say "I can", and expect success, you fill yourself with
>> confidence and happiness.*
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
>



-- 
Yours Truly.
Munyao I. Oliver.
P.o Box 1134,
Kangundo,Kenya.


*When you say "I can", and expect success, you fill yourself with
confidence and happiness.*

References