[Dhis2-devs] [Bug 1191698] [NEW] Analytics creation causes SQL syntax error

Public bug reported: The analytics tables use DHIS2 UIDs as fieldnames in a number of tables. However the rules for a table column's name are restricted by the rules for any identifiers in the SQL language. Namely: - Identifiers and key words must begin with a letter or an underscore.

Re: [Dhis2-devs] [Bug 1191698] [NEW] Analytics creation causes SQL syntax error

Hi Edward, thanks for reporting, we did actually think about this and a UID will always start with a letter [a-z][A-Z], due to SQL column and XML attribute constraints. regards, Lars On Mon, Jun 17, 2013 at 10:29 AM, Edward Ari Bichetero ebich...@yahoo.comwrote: Public bug reported: The

[Dhis2-devs] [Bug 1191698] Re: Analytics creation causes SQL syntax error

Hi Lars, Do you mean that the new code releaseses will always generate UIDs that start with alphabetic characters ? If so, does it correctly upgrade the hibernate_sequence that exists in the database ? I assume that is what is used to derive UIDs. And what happens to existing UIDs that start

Re: [Dhis2-devs] [Bug 1191698] Re: Analytics creation causes SQL syntax error

Hi, the UIDs are generated in Java code in the service layer and has nothing to do with the database sequence. If you have UIDs starting with numbers then they did not come from DHIS ;) On Mon, Jun 17, 2013 at 11:09 AM, Edward Ari Bichetero ebich...@yahoo.comwrote: Hi Lars, Do you mean

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 11217: Fixed bug, added missing struts action for adding maps to dashboard

revno: 11217 committer: Lars Helge Øverland larshe...@gmail.com branch nick: dhis2 timestamp: Mon 2013-06-17 13:19:14 +0200 message: Fixed bug, added missing struts action for adding maps to dashboard modified:

Re: [Dhis2-devs] Mobile Visualizer

Hi Yuriy, Why do you get a cross-domain issue?? Is it because you are developing on localhost and the server you are using is http://apps.dhis2.org/demo http://apps.dhis2.org/dev? All DHIS2 URLs support Basic Authentication... so all you have to do is pass the authorization headers. Thus, I dont

Re: [Dhis2-devs] Mobile Visualizer

Hi Yuriy, Thanks for asking this question. Since the coding period is about to start, it will be useful for all GSoC students to create their launchpad branches for the summer coding here - https://code.launchpad.net/dhis2 We expect that you create your branches here and be the owners of the

[Dhis2-devs] [Bug 1191698] Re: Analytics creation causes SQL syntax error

I beg to differ. If you look at the revision history for CodeGenerator.java you will see that the change to make UIDs start with a English alphabet character was made at the end of 2011 (Rev: 5104 on 2011-11-03 by Bob Jolliffe). I haven't tried to track down which was the first release that had

[Dhis2-devs] [Bug 1191698] Re: Analytics creation causes SQL syntax error

A quick look shows we have about 1000 orgunits and 150 dataelements with this problem (I've only checked orgunits, dataelements and datasets). The proper fix would be to wait until there was a new release (or WAR drop) with a UIDTableAlteror.java or UIDUpgrader.java that converted the UIDs

Re: [Dhis2-devs] Mobile Visualizer

Thanks see error message.  We need the Mobile component to work well; Launchpad.net Timeout error Sorry, something just went wrong in Launchpad. We’ve recorded what happened, and we’ll fix it as soon as possible. Apologies for the inconvenience. Trying again in a couple of minutes might work.

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 11218: Minor

revno: 11218 committer: Lars Helge Øverland larshe...@gmail.com branch nick: dhis2 timestamp: Mon 2013-06-17 17:51:12 +0200 message: Minor modified: dhis-2/dhis-web/dhis-web-api/src/main/resources/templates/html/dataValueSets.xsl

Re: [Dhis2-devs] [Bug 1191698] Re: Analytics creation causes SQL syntax error

Hi Edward, you got me there, you are right. If it was fixed on 2011-11-03 it means it was included as far back as DHIS 2.6. The problem now is that 1) data element UIDs are used in custom data entry forms, indicator formulas and validation rule formulas. E.g. in places which is not protected by

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 11219: Login page. Introduced configurable page footer. Allowed custom HTML in application intro, notifi...

revno: 11219 committer: Lars Helge Øverland larshe...@gmail.com branch nick: dhis2 timestamp: Mon 2013-06-17 19:39:32 +0200 message: Login page. Introduced configurable page footer. Allowed custom HTML in application intro,

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 11220: Minor fix

revno: 11220 committer: Lars Helge Øverland larshe...@gmail.com branch nick: dhis2 timestamp: Mon 2013-06-17 21:42:08 +0200 message: Minor fix modified:

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 11221: Fix bug - the result from case aggregate query builder is wrong with number dataelements.

revno: 11221 committer: Tran Chau tran.hispviet...@gmail.com branch nick: dhis2 timestamp: Tue 2013-06-18 09:41:49 +0700 message: Fix bug - the result from case aggregate query builder is wrong with number dataelements. modified:

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 11222: Small change the detail result from case aggregate query builder.

revno: 11222 committer: Tran Chau tran.hispviet...@gmail.com branch nick: dhis2 timestamp: Tue 2013-06-18 10:33:56 +0700 message: Small change the detail result from case aggregate query builder. modified:

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 11223: Retain the report-date when to click Complete-And-New button to register new single event without...

revno: 11223 committer: Tran Chau tran.hispviet...@gmail.com branch nick: dhis2 timestamp: Tue 2013-06-18 12:51:08 +0700 message: Retain the report-date when to click Complete-And-New button to register new single event without