CSV data import error

Support - Assistance technique
1

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.

2

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

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

3

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@gmail.com 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

–
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.

On Wed, Jul 30, 2014 at 6:39 PM, Isika Oliver ioliver750@gmail.com 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@lists.launchpad.net

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

–