← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] DHIS CSV import error

 

We should maybe consider a more self explanatory name, as not everyone is
familiar with the term dry run:
http://en.wikipedia.org/wiki/Dry_run_(testing)

Perhaps just "Test run" would be more intuitive.


On Mon, Dec 23, 2013 at 2:39 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:

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


-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org

Follow ups

References