dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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@xxxxxxx> 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@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> 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
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>