Problems importing csv datavalues into 2.14

Support - Assistance technique
1

Hi all,

I’m trying to import a csv file in the following format:

“dataelement”,“period”,“orgunit”,“categoryoptioncombo”,“value”

“TN10”,“201311”,“1”,“Default”,“5”

“TN10”,“201312”,“1”,“Default”,“0”

“TN10”,“201311”,“2”,“Default”,“3”

“TN10”,“201312”,“2”,“Default”,“5”

Etc…….

I after uploading the file I get a message = ‘Process failed: Failed to add objects’

I have selected the options to match the dataelements and orgunits on the code field.

I’ve tried with and without the categoryoptioncombo field.

There are about 98,000 records.

We’re using versions 2.14 built
13726

The same file structure worked in earlier versions.

Can anyone figure out why it doesn’t work.

Randy Wilson

2

Hi Randy,

can you please post the relevant part of the tomcat log.

Internal data value duplicates in the CSV file is a usual suspect.

Lars

···

On Fri, Jan 24, 2014 at 2:40 PM, Wilson,Randy rwilson@msh.org wrote:

Hi all,

I’m trying to import a csv file in the following format:

“dataelement”,“period”,“orgunit”,“categoryoptioncombo”,“value”

“TN10”,“201311”,“1”,“Default”,“5”

“TN10”,“201312”,“1”,“Default”,“0”

“TN10”,“201311”,“2”,“Default”,“3”

“TN10”,“201312”,“2”,“Default”,“5”

Etc…….

I after uploading the file I get a message = ‘Process failed: Failed to add objects’

I have selected the options to match the dataelements and orgunits on the code field.

I’ve tried with and without the categoryoptioncombo field.

There are about 98,000 records.

We’re using versions 2.14 built
13726

The same file structure worked in earlier versions.

Can anyone figure out why it doesn’t work.

Randy Wilson

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

3

Thanks Lars.

Don’t have access to the log file for the moment, but I tried something else and figured it out: I had some null values in the value column.

When I deleted them the import worked fine.

Might want to add the restriction on null values to the documentation.

Randy

···

Hi Randy,

can you please post the relevant part of the tomcat log.

Internal data value duplicates in the CSV file is a usual suspect.

Lars

On Fri, Jan 24, 2014 at 2:40 PM, Wilson,Randy rwilson@msh.org wrote:

Hi all,

I’m trying to import a csv file in the following format:

“dataelement”,“period”,“orgunit”,“categoryoptioncombo”,“value”

“TN10”,“201311”,“1”,“Default”,“5”

“TN10”,“201312”,“1”,“Default”,“0”

“TN10”,“201311”,“2”,“Default”,“3”

“TN10”,“201312”,“2”,“Default”,“5”

Etc…….

I after uploading the file I get a message = ‘Process failed: Failed to add objects’

I have selected the options to match the dataelements and orgunits on the code field.

I’ve tried with and without the categoryoptioncombo field.

There are about 98,000 records.

We’re using versions 2.14 built 13726

The same file structure worked in earlier versions.

Can anyone figure out why it doesn’t work.

Randy Wilson

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

4

Okay good. You mean null in terms of the word null without quotes around it?

···

On Fri, Jan 24, 2014 at 3:18 PM, Wilson,Randy rwilson@msh.org wrote:

Thanks Lars.

Don’t have access to the log file for the moment, but I tried something else and figured it out: I had some null values in the value column.

When I deleted them the import worked fine.

Might want to add the restriction on null values to the documentation.

Randy

From: Lars Helge Øverland [mailto:larshelge@gmail.com]

Sent: Friday, January 24, 2014 2:44 PM

To: Wilson,Randy

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Problems importing csv datavalues into 2.14

Hi Randy,

can you please post the relevant part of the tomcat log.

Internal data value duplicates in the CSV file is a usual suspect.

Lars

On Fri, Jan 24, 2014 at 2:40 PM, Wilson,Randy rwilson@msh.org wrote:

Hi all,

I’m trying to import a csv file in the following format:

“dataelement”,“period”,“orgunit”,“categoryoptioncombo”,“value”

“TN10”,“201311”,“1”,“Default”,“5”

“TN10”,“201312”,“1”,“Default”,“0”

“TN10”,“201311”,“2”,“Default”,“3”

“TN10”,“201312”,“2”,“Default”,“5”

Etc…….

I after uploading the file I get a message = ‘Process failed: Failed to add objects’

I have selected the options to match the dataelements and orgunits on the code field.

I’ve tried with and without the categoryoptioncombo field.

There are about 98,000 records.

We’re using versions 2.14 built 13726

The same file structure worked in earlier versions.

Can anyone figure out why it doesn’t work.

Randy Wilson

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