dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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 <
murambitc@xxxxxxxxx> 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 <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
>
> _______________________________________________
> 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
>