dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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