dhis2-users team mailing list archive

["Wilson,Randy" <rwilson@xxxxxxx>]

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@xxxxxxxxx]
Sent: Friday, January 24, 2014 2:44 PM
To: Wilson,Randy
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
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@xxxxxxx<mailto:rwilson@xxxxxxx>> 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@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp