dhis2-devs team mailing list archive

[Tawanda Clement Murambi <murambitc@xxxxxxxxx>]

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 <1222904@xxxxxxxxxxxxxxxxxx>
To: murambitc@xxxxxxxxx 
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 <
murambitc@xxxxxxxxx> 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 <1222904@xxxxxxxxxxxxxxxxxx>
> To: murambitc@xxxxxxxxx
> 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 <
> murambitc@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> > 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@xxxxxxxxxxxxxxxxxxx
> 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