← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] DHIS CSV import error

 

No problem.


On Mon, Dec 23, 2013 at 5:31 AM, Maimoona Kausar <
maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:

> OMG... Apologies for reporting wrong error .... Thanks alot for your
> cooperation :)
>
>
> On Fri, Dec 20, 2013 at 1:30 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>> Hi Maimoona,
>>
>> "Dryrun" means that you can check if your data are ok and what they are,
>> without actually importing. So when you select Dryrun=yes, nothing should
>> be imported.
>>
>> Thanks for reporting the other issue, sounds like something we need to
>> look into.
>>
>> Knut
>>
>>
>> On Fri, Dec 20, 2013 at 6:43 AM, Maimoona Kausar <
>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>
>>> 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
>>>>
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> +4791880522
>> http://dhis2.org
>>
>
>

Follow ups

References