dhis2-devs team mailing list archive

[busoye@xxxxxxxx]

Hi Jason and Juan,

Thanks for your replies. The import was just meta data, so no data  
values. The issue I am having is that I can't assign the data elements  
to a data set which I need to be able to run my aggregate queries  
which feed into those elements.

I have attached a sample of the csv I imported.

Cheers.

Busoye



Quoting Jason Pickering <jason.p.pickering@xxxxxxxxx>:

> If Busoye restarted the server, there would be no need to clear the cache,
> so it must be something else.
>
> It would be good to get a snippet of the CSV which you imported.
>
> Also, can you confirm that the data values for the data elements in
> question are actually not present in the database?
>
> Regards,
> Jason
>
>
>
> On Sun, Mar 30, 2014 at 10:33 PM, Juan Manuel Alcantara Acosta <
> jmalcantara1@xxxxxxxxx> wrote:
>
> > Oh I see you didn't miss the restart to create the missing UIDs, did you
> > clear the server cache?
> > JM
> >
> > El 30/03/2014, a las 04:55, Adebusoye Anifalaje <busoye@xxxxxxxx>
> > escribió:
> >
> > Hi Juan,
> > Thanks for the reply.
> > Not sure how this might be the problem since the UIDs were populated when
> > I restarted by servlet and all the UID fields are complete in my
> > dataelement table.
> >
> > Cheers,
> >
> > Busoye
> >
> > On 30 Mar 2014, at 03:23, Juan Manuel Alcantara <jmalcantara@xxxxxxxxxxxxx>
> > wrote:
> >
> > Sounds like your imported data elements are missing the UID, when you edit
> > and save each data element, if it's missing the UID the system creates one
> > to complete the record.
> > Best regards,
> > JM
> > El 29/03/2014, a las 05:08, Adebusoye Anifalaje <busoye@xxxxxxxx>
> > escribió:
> >
> > Public bug reported:
> >
> > Imported data elements directly into the database in Pgadmin through a
> > csv import. These data elements are not filtered on either Patient or
> > Aggregate. Also cannot assign them to a data set because they don't
> > appear in the options available. I was able to add them to data element
> > groups. If I go into each data element and save, then it's fine. Cleared
> > browser and application cache, tried incognito mode but all to no avail.
> > So think this might be a bug.
> >
> > 2.15-SNAPSHOT
> > Build revision:
> > 14523
> >
> > ** Affects: dhis2
> >   Importance: Undecided
> >       Status: New
> >
> > ** Description changed:
> >
> > Imported data elements directly into the database in Pgadmin through a
> > csv import. These data elements are not filtered on either Patient or
> > Aggregate. Also cannot assign them to a data set because they don't
> > appear in the options available. I was able to add them to data element
> > - groups. Cleared browser and application cache, tried incognito mode but
> > - all to no avail. So think this might be a bug.
> > + groups. If I go into each data element and save, then it's fine. Cleared
> > + browser and application cache, tried incognito mode but all to no avail.
> > + So think this might be a bug.
> >
> > 2.15-SNAPSHOT
> > Build revision:
> > 14523
> >
> > --
> > You received this bug notification because you are subscribed to DHIS.
> > Matching subscriptions: DHIS2 Bug Mail
> > https://bugs.launchpad.net/bugs/1299420
> >
> > Title:
> > trunk 2.15 imported aggregate data elements not available in data set
> > or aggregate domain filter in data elements
> >
> > Status in DHIS 2:
> > New
> >
> > Bug description:
> > Imported data elements directly into the database in Pgadmin through a
> > csv import. These data elements are not filtered on either Patient or
> > Aggregate. Also cannot assign them to a data set because they don't
> > appear in the options available. I was able to add them to data
> > element groups. If I go into each data element and save, then it's
> > fine. Cleared browser and application cache, tried incognito mode but
> > all to no avail. So think this might be a bug.
> >
> > 2.15-SNAPSHOT
> > Build revision:
> > 14523
> >
> > To manage notifications about this bug go to:
> > https://bugs.launchpad.net/dhis2/+bug/1299420/+subscriptions
> >
> >
> > --
> > You received this bug notification because you are subscribed to the bug
> > report.
> > https://bugs.launchpad.net/bugs/1299420
> >
> > Title:
> > trunk 2.15 imported aggregate data elements not available in data set
> > or aggregate domain filter in data elements
> >
> > Status in DHIS 2:
> > New
> >
> > Bug description:
> > Imported data elements directly into the database in Pgadmin through a
> > csv import. These data elements are not filtered on either Patient or
> > Aggregate. Also cannot assign them to a data set because they don't
> > appear in the options available. I was able to add them to data
> > element groups. If I go into each data element and save, then it's
> > fine. Cleared browser and application cache, tried incognito mode but
> > all to no avail. So think this might be a bug.
> >
> > 2.15-SNAPSHOT
> > Build revision:
> > 14523
> >
> > To manage notifications about this bug go to:
> > https://bugs.launchpad.net/dhis2/+bug/1299420/+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/1299420
> >
> > Title:
> >  trunk 2.15 imported aggregate data elements not available in data set
> >  or aggregate domain filter in data elements
> >
> > Status in DHIS 2:
> >  New
> >
> > Bug description:
> >  Imported data elements directly into the database in Pgadmin through a
> >  csv import. These data elements are not filtered on either Patient or
> >  Aggregate. Also cannot assign them to a data set because they don't
> >  appear in the options available. I was able to add them to data
> >  element groups. If I go into each data element and save, then it's
> >  fine. Cleared browser and application cache, tried incognito mode but
> >  all to no avail. So think this might be a bug.
> >
> >  2.15-SNAPSHOT
> >  Build revision:
> >  14523
> >
> > To manage notifications about this bug go to:
> > https://bugs.launchpad.net/dhis2/+bug/1299420/+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
> >
> >
> >
> > _______________________________________________
> > 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

ID,Agg_Name,Agg_Shortname,Active,valuetype,numbertype,texttype,Domain,aggregationtype,Zerosig
32737,Pas2 En cuisant bien la nourriture/En lavant bien les aliments _Agg,Pas2 En cuisant bien la nourriture/En lavant bien ,TRUE,int,number,,Aggregate,sum,FALSE
32771,Pas2 Observez si recipient de stockage est propre et bien ferme_Agg,Pas2 Observez si recipient de stockage est propre ,TRUE,int,zeroPositiveInt,,Aggregate,sum,FALSE
32853,Pas7 En cuisant bien la nourriture/En lavant bien les aliments _Agg,Pas7 En cuisant bien la nourriture/En lavant bien ,TRUE,int,number,,Aggregate,sum,FALSE
32873,Pas7 Observez si recipient de stockage est propre et bien ferme_Agg,Pas7 Observez si recipient de stockage est propre ,TRUE,int,zeroPositiveInt,,Aggregate,sum,FALSE