DHIS CSV import error

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

image

image

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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

The email above contains image for CSV data being imported.

···

On Thu, Dec 19, 2013 at 12:14 PM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Okay. Any idea why categoryoptioncombos are not there?

···

On Thu, Dec 19, 2013 at 8:17 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

The email above contains image for CSV data being imported.

On Thu, Dec 19, 2013 at 12:14 PM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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@gmail.com wrote:

Okay. Any idea why categoryoptioncombos are not there?

On Thu, Dec 19, 2013 at 8:17 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

The email above contains image for CSV data being imported.

On Thu, Dec 19, 2013 at 12:14 PM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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@irdinformatics.org 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@gmail.com wrote:

Okay. Any idea why categoryoptioncombos are not there?

On Thu, Dec 19, 2013 at 8:17 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

The email above contains image for CSV data being imported.

On Thu, Dec 19, 2013 at 12:14 PM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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@irdinformatics.org 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@irdinformatics.org 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@gmail.com wrote:

Okay. Any idea why categoryoptioncombos are not there?

On Thu, Dec 19, 2013 at 8:17 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

The email above contains image for CSV data being imported.

On Thu, Dec 19, 2013 at 12:14 PM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

On Thu, Dec 19, 2013 at 12:34 PM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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@irdinformatics.org 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@gmail.com wrote:

Okay. Any idea why categoryoptioncombos are not there?

On Thu, Dec 19, 2013 at 8:17 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

The email above contains image for CSV data being imported.

On Thu, Dec 19, 2013 at 12:14 PM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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@gmail.com 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@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

On Thu, Dec 19, 2013 at 12:34 PM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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@irdinformatics.org 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@gmail.com wrote:

Okay. Any idea why categoryoptioncombos are not there?

On Thu, Dec 19, 2013 at 8:17 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

The email above contains image for CSV data being imported.

On Thu, Dec 19, 2013 at 12:14 PM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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@irdinformatics.org 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.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Thu, Dec 19, 2013 at 1:43 PM, Knut Staring knutst@gmail.com 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@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

On Thu, Dec 19, 2013 at 12:34 PM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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@irdinformatics.org 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@gmail.com wrote:

Okay. Any idea why categoryoptioncombos are not there?

On Thu, Dec 19, 2013 at 8:17 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

The email above contains image for CSV data being imported.

On Thu, Dec 19, 2013 at 12:14 PM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

OMG… Apologies for reporting wrong error … Thanks alot for your cooperation :slight_smile:

···

On Fri, Dec 20, 2013 at 1:30 PM, Knut Staring knutst@gmail.com 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@irdinformatics.org 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.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Thu, Dec 19, 2013 at 1:43 PM, Knut Staring knutst@gmail.com 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@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

On Thu, Dec 19, 2013 at 12:34 PM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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@irdinformatics.org 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@gmail.com wrote:

Okay. Any idea why categoryoptioncombos are not there?

On Thu, Dec 19, 2013 at 8:17 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

The email above contains image for CSV data being imported.

On Thu, Dec 19, 2013 at 12:14 PM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

No problem.

···

On Mon, Dec 23, 2013 at 5:31 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

OMG… Apologies for reporting wrong error … Thanks alot for your cooperation :slight_smile:

On Fri, Dec 20, 2013 at 1:30 PM, Knut Staring knutst@gmail.com 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@irdinformatics.org 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.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Thu, Dec 19, 2013 at 1:43 PM, Knut Staring knutst@gmail.com 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@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

On Thu, Dec 19, 2013 at 12:34 PM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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@irdinformatics.org 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@gmail.com wrote:

Okay. Any idea why categoryoptioncombos are not there?

On Thu, Dec 19, 2013 at 8:17 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

The email above contains image for CSV data being imported.

On Thu, Dec 19, 2013 at 12:14 PM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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@gmail.com wrote:

No problem.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Mon, Dec 23, 2013 at 5:31 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

OMG… Apologies for reporting wrong error … Thanks alot for your cooperation :slight_smile:

On Fri, Dec 20, 2013 at 1:30 PM, Knut Staring knutst@gmail.com 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@irdinformatics.org 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.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Thu, Dec 19, 2013 at 1:43 PM, Knut Staring knutst@gmail.com 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@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

On Thu, Dec 19, 2013 at 12:34 PM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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@irdinformatics.org 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@gmail.com wrote:

Okay. Any idea why categoryoptioncombos are not there?

On Thu, Dec 19, 2013 at 8:17 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

The email above contains image for CSV data being imported.

On Thu, Dec 19, 2013 at 12:14 PM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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 Mon, Dec 23, 2013 at 2:39 PM, Lars Helge Øverland larshelge@gmail.com wrote:

No problem.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Mon, Dec 23, 2013 at 5:31 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

OMG… Apologies for reporting wrong error … Thanks alot for your cooperation :slight_smile:

On Fri, Dec 20, 2013 at 1:30 PM, Knut Staring knutst@gmail.com 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@irdinformatics.org 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.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Thu, Dec 19, 2013 at 1:43 PM, Knut Staring knutst@gmail.com 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@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

On Thu, Dec 19, 2013 at 12:34 PM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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@irdinformatics.org 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@gmail.com wrote:

Okay. Any idea why categoryoptioncombos are not there?

On Thu, Dec 19, 2013 at 8:17 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

The email above contains image for CSV data being imported.

On Thu, Dec 19, 2013 at 12:14 PM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp