According to the manual, the categoryoptioncombi is optional. I however, put it back but still the system says data imported. I have figured out that the entries are not added in datavalue table.
Since I was tired of trying, I ended up doing it the hard and long way. I wrote a Visual Basic Program that puts the data in period and datavalue Postgres data tables directly ________________________________ From: jason.p.pickering <1222...@bugs.launchpad.net> To: muramb...@yahoo.com Sent: Thursday, September 12, 2013 2:05 AM Subject: Re: [Dhis2-devs] [Bug 1222904] [NEW] Import data fromExcel not showing in DHIS 2.0 Oops, that had a typo. Try this one. SELECT COUNT(*) FROM datavalue where categoryoptioncomboid IS NULL; On Thu, Sep 12, 2013 at 6:34 AM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > This file still looks funny to me, as the categoryoptioncombo is now > blank, which should not be possible. It must be something. In your previous > file, it was "A4FGlsaDTE0". Regardless, the process should not import these > values and tell you that they are no good. > > Can you run the following SQL > > SELECT COUNT(*) FROM datavalue where categoroptioncomboid IS NULL; > > and see if it returns anything? > > You can also try and see if the data is there with the data browser, > which may be a more effective way. There could potentially be issues with > your data entry form. > > Regards, > Jason > > > > On Wed, Sep 11, 2013 at 11:50 PM, Tawanda Clement Murambi < > muramb...@yahoo.com> wrote: > >> Hi Jason >> >> I have reformated by csv as follows >> >> >> "dataelelement","period","orgunit","categoryoptioncombo","value","storedby","timestamp","comment","followup" >> "CGuNN4USi1l","200301","DolU7qs41pG",,"205","admin","2013-09-09",,"false" >> "CGuNN4USi1l","200302","DolU7qs41pG",,"141","admin","2013-09-09",,"false" >> "CGuNN4USi1l","200303","DolU7qs41pG",,"118","admin","2013-09-09",,"false" >> "CGuNN4USi1l","200304","DolU7qs41pG",,"136","admin","2013-09-09",,"false" >> "CGuNN4USi1l","200305","DolU7qs41pG",,"132","admin","2013-09-09",,"false" >> "CGuNN4USi1l","200306","DolU7qs41pG",,"134","admin","2013-09-09",,"false" >> "CGuNN4USi1l","200307","DolU7qs41pG",,"104","admin","2013-09-09",,"false" >> "CGuNN4USi1l","200308","DolU7qs41pG",,"123","admin","2013-09-09",,"false" >> "CGuNN4USi1l","200309","DolU7qs41pG",,"147","admin","2013-09-09",,"false" >> "CGuNN4USi1l","200310","DolU7qs41pG",,"144","admin","2013-09-09",,"false" >> "CGuNN4USi1l","200311","DolU7qs41pG",,"121","admin","2013-09-09",,"false" >> "CGuNN4USi1l","200312","DolU7qs41pG",,"103","admin","2013-09-09",,"false" >> >> after clicking import , I get the following >> >> Import summary >> Import count >> Type >> Count >> Imported 12 >> Updated 0 >> Ignored 0 >> When I check the period table in Postgre then new periods have been added >> accordingly, but when I open the data entry form there is nothing. Tell me >> , I am supposed to see the values immediately suppose everything had done >> properly or I should wait for sometime or run something?? I need to import >> loads and loads of historically data which I have sourced from many data >> sources, but this is really disturbing my progress. >> >> Thanks in advance >> >> >> >> ________________________________ >> From: jason.p.pickering <1222...@bugs.launchpad.net> >> To: muramb...@yahoo.com >> Sent: Wednesday, September 11, 2013 5:20 PM >> Subject: Re: [Dhis2-devs] [Bug 1222904] [NEW] Import data fromExcel not >> showing in DHIS 2.0 >> >> >> Not sure. Hard to say without the full stack trace of the entire process >> whether this is a bug, but there are problems with the file I think. >> >> 1) All "NULLS" should be blanks instead. >> 2) Your timestamp is not in the correct format. You need dashes and not >> slashes (I think). >> 3) Everything should be double-quoted >> 4) "FALSE" should be lower case. >> >> e.g from the manual. >> >> "dataelelement","period","orgunit","categoryoptioncombo","value","storedby","timestamp","comment","followup" >> >> "DUSpd8Jq3M7","201202","gP6hn503KUX","Prlt0C1RF0s","7","bombali","2010-04-17",,"false"I >> would reformat the file, and try again. It looks like the error logging >> could be improved. >> >> Regards, >> >> Jason >> >> >> >> On Wed, Sep 11, 2013 at 9:05 PM, Tawanda Clement Murambi < >> muramb...@yahoo.com> wrote: >> >> > Hi jason >> > >> > I forgot to say that I have 3 levels of organisational units..facility , >> > district and national level. The form giving me trouble is attached to >> > the districts. >> > >> > >> > ________________________________ >> > From: jason.p.pickering <1222...@bugs.launchpad.net> >> > To: muramb...@yahoo.com >> > Sent: Tuesday, September 10, 2013 12:58 PM >> > Subject: Re: [Dhis2-devs] [Bug 1222904] [NEW] Import data fromExcel not >> > showing in DHIS 2.0 >> > >> > >> > Can you give a bit more clarity (perhaps with an example) of what you >> Excel >> > file looks like? >> > >> > In general, DHIS2 cannot import Excel directly but rather CSV files. The >> > format is described in detail here. >> > <http://www.dhis2.org/doc/snapshot/en/user/html/ch19s03.html> >> > >> > Regards, >> > Jason >> > >> > >> > On Mon, Sep 9, 2013 at 10:41 PM, Tawanda Clement Murambi < >> > muramb...@yahoo.com> wrote: >> > >> > > Public bug reported: >> > > >> > > I have lot of data in excel. I want to upload the data in dhis 2.0. I >> > > have defined organisation units as well as data elements and data >> sets. >> > > I have tried to use the import-export module in DHIS 2.0 to upload the >> > > data. The system says import complete and lists the number of records >> > > imported. But when I go to the dataset to view the data, there is >> > > nothing. >> > > >> > > What could be the problem. >> > > >> > > ** Affects: dhis2 >> > > Importance: Undecided >> > > Status: New >> > > >> > > -- >> > > You received this bug notification because you are a member of DHIS 2 >> > > developers, which is subscribed to DHIS. >> > > https://bugs.launchpad.net/bugs/1222904 >> > > >> > > Title: >> > > Import data fromExcel not showing in DHIS 2.0 >> > > >> > > Status in DHIS 2: >> > > New >> > > >> > > Bug description: >> > > I have lot of data in excel. I want to upload the data in dhis 2.0. >> I >> > > have defined organisation units as well as data elements and data >> > > sets. I have tried to use the import-export module in DHIS 2.0 to >> > > upload the data. The system says import complete and lists the >> number >> > > of records imported. But when I go to the dataset to view the data, >> > > there is nothing. >> > > >> > > What could be the problem. >> > > >> > > To manage notifications about this bug go to: >> > > https://bugs.launchpad.net/dhis2/+bug/1222904/+subscriptions >> > > >> > > _______________________________________________ >> > > 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 >> > > >> > >> > -- >> > You received this bug notification because you are subscribed to the bug >> > report. >> > https://bugs.launchpad.net/bugs/1222904 >> > >> > Title: >> > Import data fromExcel not showing in DHIS 2.0 >> > >> > Status in DHIS 2: >> > New >> > >> > Bug description: >> > I have lot of data in excel. I want to upload the data in dhis 2.0. I >> > have defined organisation units as well as data elements and data >> > sets. I have tried to use the import-export module in DHIS 2.0 to >> > upload the data. The system says import complete and lists the number >> > of records imported. But when I go to the dataset to view the data, >> > there is nothing. >> > >> > What could be the problem. >> > >> > To manage notifications about this bug go to: >> > https://bugs.launchpad.net/dhis2/+bug/1222904/+subscriptions >> > >> > -- >> > You received this bug notification because you are a member of DHIS 2 >> > developers, which is subscribed to DHIS. >> > https://bugs.launchpad.net/bugs/1222904 >> > >> > Title: >> > Import data fromExcel not showing in DHIS 2.0 >> > >> > Status in DHIS 2: >> > New >> > >> > Bug description: >> > I have lot of data in excel. I want to upload the data in dhis 2.0. I >> > have defined organisation units as well as data elements and data >> > sets. I have tried to use the import-export module in DHIS 2.0 to >> > upload the data. The system says import complete and lists the number >> > of records imported. But when I go to the dataset to view the data, >> > there is nothing. >> > >> > What could be the problem. >> > >> > To manage notifications about this bug go to: >> > https://bugs.launchpad.net/dhis2/+bug/1222904/+subscriptions >> > >> > _______________________________________________ >> > 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 >> > >> >> -- >> You received this bug notification because you are subscribed to the bug >> report. >> https://bugs.launchpad.net/bugs/1222904 >> >> Title: >> Import data fromExcel not showing in DHIS 2.0 >> >> Status in DHIS 2: >> New >> >> Bug description: >> I have lot of data in excel. I want to upload the data in dhis 2.0. I >> have defined organisation units as well as data elements and data >> sets. I have tried to use the import-export module in DHIS 2.0 to >> upload the data. The system says import complete and lists the number >> of records imported. But when I go to the dataset to view the data, >> there is nothing. >> >> What could be the problem. >> >> To manage notifications about this bug go to: >> https://bugs.launchpad.net/dhis2/+bug/1222904/+subscriptions >> >> -- >> You received this bug notification because you are a member of DHIS 2 >> developers, which is subscribed to DHIS. >> https://bugs.launchpad.net/bugs/1222904 >> >> Title: >> Import data fromExcel not showing in DHIS 2.0 >> >> Status in DHIS 2: >> New >> >> Bug description: >> I have lot of data in excel. I want to upload the data in dhis 2.0. I >> have defined organisation units as well as data elements and data >> sets. I have tried to use the import-export module in DHIS 2.0 to >> upload the data. The system says import complete and lists the number >> of records imported. But when I go to the dataset to view the data, >> there is nothing. >> >> What could be the problem. >> >> To manage notifications about this bug go to: >> https://bugs.launchpad.net/dhis2/+bug/1222904/+subscriptions >> >> _______________________________________________ >> 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 >> > > -- You received this bug notification because you are subscribed to the bug report. https://bugs.launchpad.net/bugs/1222904 Title: Import data fromExcel not showing in DHIS 2.0 Status in DHIS 2: New Bug description: I have lot of data in excel. I want to upload the data in dhis 2.0. I have defined organisation units as well as data elements and data sets. I have tried to use the import-export module in DHIS 2.0 to upload the data. The system says import complete and lists the number of records imported. But when I go to the dataset to view the data, there is nothing. What could be the problem. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1222904/+subscriptions -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1222904 Title: Import data fromExcel not showing in DHIS 2.0 Status in DHIS 2: New Bug description: I have lot of data in excel. I want to upload the data in dhis 2.0. I have defined organisation units as well as data elements and data sets. I have tried to use the import-export module in DHIS 2.0 to upload the data. The system says import complete and lists the number of records imported. But when I go to the dataset to view the data, there is nothing. What could be the problem. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1222904/+subscriptions _______________________________________________ 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
