← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] DHIS CSV import error

 

Knut,

I agree with you. I think "Dry run” is more of a colloquial expression and would not be widely understood. Test run is probably more intuitive.

  
On 23 Dec 2013, at 14:52, Knut Staring <knutst@xxxxxxxxx> wrote:

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


References