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
