← Back to team overview

dhis2-users team mailing list archive

Re: DHIS CSV import error

 

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

Follow ups

References