Re: [Dhis2-users] Error duplicate key violates unique constraint after to import data to Database

2013-06-18 Thread Knut Staring
Hi again, Since you have been importing patients, you probably want to find the max like this: SELECT max(patientid)+1 AS id FROM patient On Wed, Jun 19, 2013 at 7:01 AM, Knut Staring wrote: > Hi Helder, > > Your problem is caused because you have not used the Postgres > hibernate_sequence to

Re: [Dhis2-users] Error duplicate key violates unique constraint after to import data to Database

2013-06-18 Thread Knut Staring
Hi Helder, Your problem is caused because you have not used the Postgres hibernate_sequence to generate IDs, but rather generated your own IDs. There are 3 answers: 1) This situation is avoided by using the DXF format, which takes a bit more work - then DHIS2 will add the IDs 2) If you are inste

[Dhis2-users] Error duplicate key violates unique constraint after to import data to Database

2013-06-18 Thread Helder Yesid Castrillon Cobo
Hi, We have needed to import data directly from Dhis Database(postgres), but we have found that when entering the application does not allow adding new records related to the imported information. example: If i import patient data, then after the application not allow adding new patients. when w

Re: [Dhis2-users] Problem with datamart in dhis 2.12

2013-06-18 Thread Bob Jolliffe
Ah sorry hang on with that. I didn't backport fix to 2.12. Earliest I can do now is tomorrow unless someone else cares to (2 lines). Cheers Bob On 18 June 2013 22:50, Jerry Aziawa wrote: > Ok thanx a lot for all your contribution. I will download the new > version of DHIS 2.12 > with the fi

Re: [Dhis2-users] Problem with datamart in dhis 2.12

2013-06-18 Thread Jerry Aziawa
Ok thanx a lot for all your contribution. I will download the new version of DHIS 2.12 with the fixed bug. On 6/18/13, Bob Jolliffe wrote: > OK it looks like a small javascript UI "bug" with a simple workaround for > now. The onClick() which toggles the dataMart enable is triggered by > clicki

Re: [Dhis2-users] Problem with datamart in dhis 2.12

2013-06-18 Thread Bob Jolliffe
OK it looks like a small javascript UI "bug" with a simple workaround for now. The onClick() which toggles the dataMart enable is triggered by clicking on the label NOT on the checkbox. So if your eyesight is not too sharp like mine (and worryingly it seems also Lars who is a good deal younger) t

Re: [Dhis2-users] Problem with datamart in dhis 2.12

2013-06-18 Thread Bob Jolliffe
Yes I have seen the same problem on the carec system (also 2.12 build 11183). Looks like a bug ... On 18 June 2013 19:42, Knut Staring wrote: > Hi Lars, > > Running 2.12 build 11183 the date fields remain grayed out even when > checking the > Data mart tables update box > > > On Tue, Jun 18, 2

Re: [Dhis2-users] Problem with datamart in dhis 2.12

2013-06-18 Thread Knut Staring
Hi Lars, Running 2.12 build 11183 the date fields remain grayed out even when checking the Data mart tables update box On Tue, Jun 18, 2013 at 7:28 PM, Lars Helge Øverland wrote: > Hi Jerry, > > did you tick the "data mart tables update" checkbox? The date fields are > only relevant to data mar

Re: [Dhis2-users] Dataset report error

2013-06-18 Thread Lars Helge Øverland
Hi Angela, can you please have a look in the Tomcat log and post errors related to this? regards, Lars http://www.dhis2.org/doc/snapshot/en/implementer/html/ch09s03.html On Tue, Jun 18, 2013 at 8:03 PM, Hinds, Ms. Angela (CAR) < hinds...@carpha.org> wrote: > Hello All > > ** ** > > Our

Re: [Dhis2-users] Problem with datamart in dhis 2.12

2013-06-18 Thread Lars Helge Øverland
Hi Jerry, did you tick the "data mart tables update" checkbox? The date fields are only relevant to data mart. I guess we need to make that clearer in the ui. regards, Lars On Mon, Jun 17, 2013 at 12:10 PM, Jerry Aziawa wrote: > Good morning, > > I am currently facing a problem when using d

[Dhis2-users] Dataset report error

2013-06-18 Thread Hinds, Ms. Angela (CAR)
Hello All Our system was recently upgraded to DHIS 2.12. All seems well except that when we try to run a dataset report. If the chosen period has no data, the report is displayed (with blanks as it should). If the period has data the following message is displayed:- Sorry The system failed

Re: [Dhis2-users] DHIS2.11 Saving Value Failed with Status Code 1

2013-06-18 Thread Lars Helge Øverland
Likely to be a caching issue. To force an update of all data sets you can do this SQL: update dataset set version = (version+1); regards, Lars On Mon, Jun 10, 2013 at 2:30 PM, Dayo Adeyomoye wrote: > Thanks Olav, > > I restarted the DHIS server and it works now. As you also mentioned, one >

Re: [Dhis2-users] User Security Question

2013-06-18 Thread Lars Helge Øverland
Hello Rajib, creating such a user role is perfectly possible. Make sure you give the "See data entry module", "Add data value", "Update data value" and "Delete data value" and not much else. If you do not give "See x module" authority for any maintenance modules, then the maintenance top menu lin

Re: [Dhis2-users] [Dhis2-devs] Need Calendar Object to display future dates

2013-06-18 Thread Lars Helge Øverland
Hi John, yes everything is possible, I have put up a blueprint for it here: https://blueprints.launchpad.net/dhis2/+spec/tracker-future-dates best regards, Lars On Sat, Jun 8, 2013 at 10:18 PM, John Ojo wrote: > Hi All, > > I am creating an information system based on the dhis2 Tracker mod

Re: [Dhis2-users] DHIS2 Road Map

2013-06-18 Thread Farai Mutero
Thanks Prosper! On Tue, Jun 18, 2013 at 3:59 PM, Prosper BT wrote: > Check out the series and milestone and click on the version to see the > features > > https://launchpad.net/dhis2 > > > > > On Tue, Jun 18, 2013 at 4:42 PM, Farai Mutero wrote: > >> Hi All >> >> Is there a publicly available

Re: [Dhis2-users] DHIS2 Road Map

2013-06-18 Thread Prosper BT
Check out the series and milestone and click on the version to see the features https://launchpad.net/dhis2 On Tue, Jun 18, 2013 at 4:42 PM, Farai Mutero wrote: > Hi All > > Is there a publicly available url for the DHIS2 Road Map which can give us > an idea of what to expect in the upcoming

[Dhis2-users] DHIS2 Road Map

2013-06-18 Thread Farai Mutero
Hi All Is there a publicly available url for the DHIS2 Road Map which can give us an idea of what to expect in the upcoming releases of DHIS2. I'm a aware though of the blueprints on Launchpad. Regards -- Farai Mutero ___ Mailing list: https://launchp

Re: [Dhis2-users] Fwd:

2013-06-18 Thread Lars Helge Øverland
This column is obsolete after 2.12 and should have been dropped by the startup routines. If not then simply drop that column "doindicators" from the table manually. Lars On Mon, Jun 3, 2013 at 2:53 PM, Knut Staring wrote: > We have "resolved" this issue by deleting all the reporttables in the

Re: [Dhis2-users] Problems with Large Aggregate queries

2013-06-18 Thread Tran Chau
Dear Jose, This was fixed for 2.12. The maximum number of characters is 1000 now. Best regards, Châu Thu Trân HISP Viet Nam Email: tran.hispviet...@gmail.com On Mon, May 27, 2013 at 11:34 PM, Jose Garcia Muñoz wrote: > > Dear all, > > it seems t