← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] DHIS CSV import error

 

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