dhis2-devs team mailing list archive

["jason.p.pickering" <1222904@xxxxxxxxxxxxxxxxxx>]

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.pickering@xxxxxxxxx> 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 <
> 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
>>
>
>

-- 
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