← Back to team overview

dhis2-users team mailing list archive

Re: DHIS CSV import error

 

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

Follow ups

References