← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] DHIS CSV import error

 

Thanks Knut.

So after trying different patterns it appears that problem occurs when
selected option is dryrun=yes. Whatever data is, whatever combination is,
it always flags successful import, which, in actual, is not.
However, when I tried dryrun=no it successfully imported data, which was
available in datavalue table too.

I tried the version here http://apps.dhis2.org/ci/job/dhis-trunk/ . But in
this version there is minor bug that is on exporting (CSV) any data it
shows FALSE in comments column  (that must be of followup column) .

Many thanks,
Maimoona.


On Thu, Dec 19, 2013 at 1:43 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> This has indeed been changed lately. You can check your build number under
> About DHIS2 and get the latest builds from here:
> http://apps.dhis2.org/ci/
>
>
> On Thu, Dec 19, 2013 at 9:00 AM, Maimoona Kausar <
> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>
>> I tried exporting CSV from demo app as you explained in email above. The
>> column for datetime of row is different in both CSVs. i.e. Column is
>> 'timestamp' in CSV exported from my instance of DHIS, but the column name
>> is 'lastupdated' in CSV exported from Demo app. Seems that there s some
>> version difference. From where I can get the same app as one deployed on
>> demo server.
>>
>>
>> On Thu, Dec 19, 2013 at 12:34 PM, Maimoona Kausar <
>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>
>>> I tried importing CSV again with category undeleted, and changed the
>>> period, and values. it says 8 updated but new value is not reflected in
>>> tables.
>>>
>>>
>>> On Thu, Dec 19, 2013 at 12:26 PM, Maimoona Kausar <
>>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>>
>>>> I deleted it because it was mentioned as non-required option. And the
>>>> system from which we would get our CSV may not have category.
>>>>
>>>>
>>>> On Thu, Dec 19, 2013 at 12:19 PM, Lars Helge Øverland <
>>>> larshelge@xxxxxxxxx> wrote:
>>>>
>>>>> Okay. Any idea why categoryoptioncombos are not there?
>>>>>
>>>>>
>>>>> On Thu, Dec 19, 2013 at 8:17 AM, Maimoona Kausar <
>>>>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>>>>
>>>>>> The email above contains image for CSV data being imported.
>>>>>>
>>>>>>
>>>>>> On Thu, Dec 19, 2013 at 12:14 PM, Lars Helge Øverland <
>>>>>> larshelge@xxxxxxxxx> wrote:
>>>>>>
>>>>>>> Hello Maimoona,
>>>>>>>
>>>>>>> thanks for reporting. I have tried to reproduce your problem but
>>>>>>> could not. What I did on the demo was:
>>>>>>>
>>>>>>> - Export data in CSV format for Ngelehun 2013-02-01 -> 2013-04-01
>>>>>>> for PHUF 2 form
>>>>>>> - Removed the corresponding data by simply blanking out in the data
>>>>>>> entry form
>>>>>>> - Imported the CSV file
>>>>>>>
>>>>>>> This lead to data re-appearing in the form.
>>>>>>>
>>>>>>> Some things to check:
>>>>>>>
>>>>>>> - What does your CSV file look like, does it have values, can you
>>>>>>> please post it?
>>>>>>> - If you already have data in your database and do an export, then
>>>>>>> you must remove some of it for the import to have any effect on the same
>>>>>>> database.
>>>>>>> - The CSV file is using UIDs, not database ids, category option
>>>>>>> combo id to 15 will not work.
>>>>>>>
>>>>>>> Let us know.
>>>>>>>
>>>>>>> Lars
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>  On Thu, Dec 19, 2013 at 6:42 AM, Maimoona Kausar <
>>>>>>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>>>>>>
>>>>>>>>  Hi Team,
>>>>>>>>
>>>>>>>> I am working with CSV import module of DHIS 2.13 live. It doesnot
>>>>>>>> import any data into datavalue table. Neither does it show any row in
>>>>>>>> importdatavalue/importobject tables.
>>>>>>>>
>>>>>>>> The CSV I am trying to import was exported using DHIS CSV export
>>>>>>>> module to make sure that format is correct. Attached are images of import
>>>>>>>> activity.
>>>>>>>>
>>>>>>>> I also tried putting ID 15 (default catergorycombination) into CSV,
>>>>>>>> but it didnot help too.
>>>>>>>>
>>>>>>>> Please let me know if I am making some mistake in understanding the
>>>>>>>> import functionality and the way it works.
>>>>>>>>
>>>>>>>> Many thanks,
>>>>>>>> Maimoona
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> 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
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
>

Follow ups

References