Re: [Dhis2-devs] running 11 dhis2 webapps on one tomcat

[Knut Staring]

2009/4/14 Bob Jolliffe 

>   BTW if people are looking for
> MSAccess-like functionality, I've been fiddling with my h2 databases
> using OpenOffice Base and its pretty good.  Check
> http://www.h2database.com/html/tutorial.html#open_office for simple
> setup.
>

Trying to folllow this, but having trouble connecting - what should be the
URL for the DHIS lite database?

jdbc:h2:~/dhis2

And why does the wizard insist on creating a .odb file as well, when I just
want to connect to an existing base?

Knut
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Is Cache Statistics Working Correctly ??

[Saptarshi Purkayastha]

Today, I looked at the cache statistics feature. When we press the clear
cache button, the cache size seems to increase. The total query cache and
the secondary cache level also increases in size.

I thought this was something not working in the UI, but when I looked into
MySQL the values are the same. Infact, I changed the query cache variables
in MySQL
(show variables like 'query%';) and it didn't show any difference in the
Cache Statistics UI within DHIS. Is this functionality working as expected
or still a work-in-progress??

---
Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog:  http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Bazaar

[Murodullo Latifov]

Hi Lars,

In tajik bazaar is market. When you talk of bazaar outside of bazaar it means 
haos. When someone does things wrong, other may correct him: "hei, you are not 
in bazaar, behave as respected". Now I am in bazaar. Please suggest 
corrections. 
I got my code from repository as branch. I didn't commit since then i guess. I 
made changes on poms, created struts2 test modules, implemented 'easy help' and 
'datavalue history' functionalities. What to do now? commit all in one? where 
does it go? I could't find anywhere with my login on launchpad saying my 
branch. I also want to version my changes. I cannot continue with so many 
changes not versioned.
Easy help functionality is fine to go (simply action file and vm), but 
datavalue history brings many changes starting from new dependencies and 
existing code change to introduce @annotations for hibernate. DataValue entity, 
which has composite primary key refering to foreign key to other for entities 
(defined in hbm.xml) had been slightly changed (now annotated), services to it 
as well. Also one dependency is not on maven2 repo, it is not there as latest 
(olders are there though), needs to be manually set. This is enver library by 
jboss, to be part of hibernate 3.5 fairly soon as they promise.
For easy help we need also someone who is good in manual writing to place tags 
where necessary (other web modules menu.vm or anywhere control needs help) and 
provide en_GB.properties strings acordingly. These changes later should be 
placed into trunk and translated into other languages. General Help menu could 
also use the same strings. 

regards,
murod.



  

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Is Cache Statistics Working Correctly ??

[Lars Helge Øverland]

On Fri, Apr 17, 2009 at 10:20 AM, Saptarshi Purkayastha wrote:

> Today, I looked at the cache statistics feature. When we press the clear
> cache button, the cache size seems to increase. The total query cache and
> the secondary cache level also increases in size.
>
> I thought this was something not working in the UI, but when I looked into
> MySQL the values are the same. Infact, I changed the query cache variables
> in MySQL
> (show variables like 'query%';) and it didn't show any difference in the
> Cache Statistics UI within DHIS. Is this functionality working as expected
> or still a work-in-progress??
>


Hi,

MySQL caching has nothing to do with Hibernate caching.

The cache is cleared. As far as I know, Hibernate keeps track of the
hit/miss/put count which is what you see increasing.

You can verify this by turning sql logging on in hibernate. Select eg. all
data elements and see sql being produced, select it again and no output is
produced. Then clear the cache and sql is being produced again.


Lars
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] running 11 dhis2 webapps on one tomcat

[Bob Jolliffe]

2009/4/17 Knut Staring :
> 2009/4/14 Bob Jolliffe 
>>
>>   BTW if people are looking for
>> MSAccess-like functionality, I've been fiddling with my h2 databases
>> using OpenOffice Base and its pretty good.  Check
>> http://www.h2database.com/html/tutorial.html#open_office for simple
>> setup.
>
> Trying to folllow this, but having trouble connecting - what should be the
> URL for the DHIS lite database?
>
> jdbc:h2:~/dhis2

Yes thats the right form (if thats where your database is - mine is
jdbc:h2:~/dhis2/db).
Driver = org.h2.Driver

>
> And why does the wizard insist on creating a .odb file as well, when I just
> want to connect to an existing base?

The .odb file contains all the other goodies - forms, reports,
queries.  Kind of like access.

I find it quite useful - and pretty fast with h2.  Of course, given
our current setup with embedded mode, you can't connect at the same
time as the dhis2 app is running.  This may be a good thing.  If not
you could revert to Lars' suggestion of 'mixed mode'.

Cheers
Bob

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Bazaar

[Bob Jolliffe]

Hi Lars

I think Murod's point is a reflection of a wider problem we have
regarding project management.  At least I don't feel I have yet got
completely on top of all the issues around bazaar management of
series, branches etc.  I know I haven't dedicated as much time to it
as I might have.  Mostly these are not bazaar problems.  When you go
to a bazaar which you are familiar with it is a very productive
experience.  Wondering around a bazaar which is new to you, well, you
can easily get lost.

I think it would be a good idea to maybe set a date (like next Friday)
for a core developers conference call - maybe using skype or something
similar.  We can use the intervening week to study all the best
practices and discuss on list.

Meanwhile I guess Murod should commit his code into the sandbox.  We
should always be able to commit code somewhere - rather than not
committing.  Then you and others can look at it and decide whether
some or all of this goes into 2.02/2.03 etc.  I guess this involves:

bzr co lp:~dhis2-devs/dhis2/sandbox
add the code in a new folder here and add the folder to bzr
bzr commit

Does this sound right?

Regards
Bob


2009/4/17 Murodullo Latifov :
>
> Hi Lars,
>
> In tajik bazaar is market. When you talk of bazaar outside of bazaar it means 
> haos. When someone does things wrong, other may correct him: "hei, you are 
> not in bazaar, behave as respected". Now I am in bazaar. Please suggest 
> corrections.
> I got my code from repository as branch. I didn't commit since then i guess. 
> I made changes on poms, created struts2 test modules, implemented 'easy help' 
> and 'datavalue history' functionalities. What to do now? commit all in one? 
> where does it go? I could't find anywhere with my login on launchpad saying 
> my branch. I also want to version my changes. I cannot continue with so many 
> changes not versioned.
> Easy help functionality is fine to go (simply action file and vm), but 
> datavalue history brings many changes starting from new dependencies and 
> existing code change to introduce @annotations for hibernate. DataValue 
> entity, which has composite primary key refering to foreign key to other for 
> entities (defined in hbm.xml) had been slightly changed (now annotated), 
> services to it as well. Also one dependency is not on maven2 repo, it is not 
> there as latest (olders are there though), needs to be manually set. This is 
> enver library by jboss, to be part of hibernate 3.5 fairly soon as they 
> promise.
> For easy help we need also someone who is good in manual writing to place 
> tags where necessary (other web modules menu.vm or anywhere control needs 
> help) and provide en_GB.properties strings acordingly. These changes later 
> should be placed into trunk and translated into other languages. General Help 
> menu could also use the same strings.
>
> regards,
> murod.
>
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Bazaar

[Murodullo Latifov]

Hi people,

Yes, we should have skype conference regarding bazaar SCM with some online 
training. On blueprints I couldn't assign myself for implementing. Also both 
'easy access help' and 'datavalue history' show 'branch exists', I couldn't get 
hold of them. Maybe I have not enough access rights? Or admin should assign it 
to? I am afraid to do exesive job of copy/paste after all. :)
Can someone point me to proper documentation for bazaar users?

regards,
murod



- Original Message 
From: Bob Jolliffe 
To: Murodullo Latifov 
Cc: DHIS 2 developers 
Sent: Friday, April 17, 2009 11:57:45 AM
Subject: Re: [Dhis2-devs] Bazaar

Hi Lars

I think Murod's point is a reflection of a wider problem we have
regarding project management.  At least I don't feel I have yet got
completely on top of all the issues around bazaar management of
series, branches etc.  I know I haven't dedicated as much time to it
as I might have.  Mostly these are not bazaar problems.  When you go
to a bazaar which you are familiar with it is a very productive
experience.  Wondering around a bazaar which is new to you, well, you
can easily get lost.

I think it would be a good idea to maybe set a date (like next Friday)
for a core developers conference call - maybe using skype or something
similar.  We can use the intervening week to study all the best
practices and discuss on list.

Meanwhile I guess Murod should commit his code into the sandbox.  We
should always be able to commit code somewhere - rather than not
committing.  Then you and others can look at it and decide whether
some or all of this goes into 2.02/2.03 etc.  I guess this involves:

bzr co lp:~dhis2-devs/dhis2/sandbox
add the code in a new folder here and add the folder to bzr
bzr commit

Does this sound right?

Regards
Bob


2009/4/17 Murodullo Latifov :
>
> Hi Lars,
>
> In tajik bazaar is market. When you talk of bazaar outside of bazaar it means 
> haos. When someone does things wrong, other may correct him: "hei, you are 
> not in bazaar, behave as respected". Now I am in bazaar. Please suggest 
> corrections.
> I got my code from repository as branch. I didn't commit since then i guess. 
> I made changes on poms, created struts2 test modules, implemented 'easy help' 
> and 'datavalue history' functionalities. What to do now? commit all in one? 
> where does it go? I could't find anywhere with my login on launchpad saying 
> my branch. I also want to version my changes. I cannot continue with so many 
> changes not versioned.
> Easy help functionality is fine to go (simply action file and vm), but 
> datavalue history brings many changes starting from new dependencies and 
> existing code change to introduce @annotations for hibernate. DataValue 
> entity, which has composite primary key refering to foreign key to other for 
> entities (defined in hbm.xml) had been slightly changed (now annotated), 
> services to it as well. Also one dependency is not on maven2 repo, it is not 
> there as latest (olders are there though), needs to be manually set. This is 
> enver library by jboss, to be part of hibernate 3.5 fairly soon as they 
> promise.
> For easy help we need also someone who is good in manual writing to place 
> tags where necessary (other web modules menu.vm or anywhere control needs 
> help) and provide en_GB.properties strings acordingly. These changes later 
> should be placed into trunk and translated into other languages. General Help 
> menu could also use the same strings.
>
> regards,
> murod.
>
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>



  

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Bazaar

[Saptarshi Purkayastha]

http://doc.bazaar-vcs.org/bzr.dev/en/user-guide/index.html
and
http://doc.bazaar-vcs.org/bzr.dev/en/user-reference/bzr_man.html

are probably all the docs you should need... But the things you point out
regrading blueprints has more to do with launchpad than bazaar. I have spent
considerable amount of time  studying distributed VCS including mercurial,
bazaar, git and the rest... and have been raising this point from the dev
conference.

All we need for Murod's work is a branch of his features like a centralized
VCS way... the core devs can then pull only those changes from murod's
branch, merge as local commits to trunk branch and then commit it back to
the trunk. Managing conflicts shouldn't be much issue, but understanding and
testing the changes will surely be some effort.

---
Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog:  http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE


2009/4/17 Murodullo Latifov 

>
> Hi people,
>
> Yes, we should have skype conference regarding bazaar SCM with some online
> training. On blueprints I couldn't assign myself for implementing. Also both
> 'easy access help' and 'datavalue history' show 'branch exists', I couldn't
> get hold of them. Maybe I have not enough access rights? Or admin should
> assign it to? I am afraid to do exesive job of copy/paste after all. :)
> Can someone point me to proper documentation for bazaar users?
>
> regards,
> murod
>
>
>
> - Original Message 
> From: Bob Jolliffe 
> To: Murodullo Latifov 
> Cc: DHIS 2 developers 
> Sent: Friday, April 17, 2009 11:57:45 AM
> Subject: Re: [Dhis2-devs] Bazaar
>
> Hi Lars
>
> I think Murod's point is a reflection of a wider problem we have
> regarding project management.  At least I don't feel I have yet got
> completely on top of all the issues around bazaar management of
> series, branches etc.  I know I haven't dedicated as much time to it
> as I might have.  Mostly these are not bazaar problems.  When you go
> to a bazaar which you are familiar with it is a very productive
> experience.  Wondering around a bazaar which is new to you, well, you
> can easily get lost.
>
> I think it would be a good idea to maybe set a date (like next Friday)
> for a core developers conference call - maybe using skype or something
> similar.  We can use the intervening week to study all the best
> practices and discuss on list.
>
> Meanwhile I guess Murod should commit his code into the sandbox.  We
> should always be able to commit code somewhere - rather than not
> committing.  Then you and others can look at it and decide whether
> some or all of this goes into 2.02/2.03 etc.  I guess this involves:
>
> bzr co lp:~dhis2-devs/dhis2/sandbox
> add the code in a new folder here and add the folder to bzr
> bzr commit
>
> Does this sound right?
>
> Regards
> Bob
>
>
> 2009/4/17 Murodullo Latifov :
> >
> > Hi Lars,
> >
> > In tajik bazaar is market. When you talk of bazaar outside of bazaar it
> means haos. When someone does things wrong, other may correct him: "hei, you
> are not in bazaar, behave as respected". Now I am in bazaar. Please suggest
> corrections.
> > I got my code from repository as branch. I didn't commit since then i
> guess. I made changes on poms, created struts2 test modules, implemented
> 'easy help' and 'datavalue history' functionalities. What to do now? commit
> all in one? where does it go? I could't find anywhere with my login on
> launchpad saying my branch. I also want to version my changes. I cannot
> continue with so many changes not versioned.
> > Easy help functionality is fine to go (simply action file and vm), but
> datavalue history brings many changes starting from new dependencies and
> existing code change to introduce @annotations for hibernate. DataValue
> entity, which has composite primary key refering to foreign key to other for
> entities (defined in hbm.xml) had been slightly changed (now annotated),
> services to it as well. Also one dependency is not on maven2 repo, it is not
> there as latest (olders are there though), needs to be manually set. This is
> enver library by jboss, to be part of hibernate 3.5 fairly soon as they
> promise.
> > For easy help we need also someone who is good in manual writing to place
> tags where necessary (other web modules menu.vm or anywhere control needs
> help) and provide en_GB.properties strings acordingly. These changes later
> should be placed into trunk and translated into other languages. General
> Help menu could also use the same strings.
> >
> > regards,
> > murod.
> >
> >
> >
> >
> >
> > ___
> > Mailing list: 
> > https://launchpad.net/~dhis2-devs
> > Post to : dhis2-devs@lists.launchpad.net
> > Unsubscribe : 
> > https://launchpad.net/~dhis2-devs
> > More help   : https://help.launchpad.net/ListHelp
> >
>
>
>
>
>
> __

Re: [Dhis2-devs] DHIS 2 Lite Beta

[Knut Staring]

Sunny and Bharath,
Can you describe exactly what the dependencies on Mysql in India are? I
remember this was discussed during the workshop, but cannot recall the
details.

Knut

2009/4/16 Lars Helge Øverland 

>
>
> 2009/4/16 Saptarshi Purkayastha 
>
>> We were just discussing this yesterday that it would be good to give these
>> to the states... but then since Indian modules are directly using MySQL, it
>> will be sometime until we can use this.
>>
>
>
> OK I see.
>
> Is the Indian modules very much depending on MySQL specific functions, or
> could we rewrite this code to use standard SQL only? If so, the
> org.hisp.dhis.jdbc.StatementBuilder interface (which gives you SQL
> statements) could be extended and used here. We have a
> StatementBuilderFactory in the service-jdbc project which will give you an
> implementation based on which database you are running. I am happy to help
> out here if you like.
>
>
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Cheers,
Knut Staring
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Bazaar

[Bob Jolliffe]

2009/4/17 Saptarshi Purkayastha :
> http://doc.bazaar-vcs.org/bzr.dev/en/user-guide/index.html
> and
> http://doc.bazaar-vcs.org/bzr.dev/en/user-reference/bzr_man.html
>
> are probably all the docs you should need... But the things you point out
> regrading blueprints has more to do with launchpad than bazaar. I have spent
> considerable amount of time  studying distributed VCS including mercurial,
> bazaar, git and the rest... and have been raising this point from the dev
> conference.
>
> All we need for Murod's work is a branch of his features like a centralized
> VCS way... the core devs can then pull only those changes from murod's
> branch, merge as local commits to trunk branch and then commit it back to
> the trunk. Managing conflicts shouldn't be much issue, but understanding and
> testing the changes will surely be some effort.

Yes but the point is that it is no good if he just creates a personal
local branch which is what is mostly described in the documentation.
His branch must also be on launchpad.  Which is why I suggested
perhaps putting it in (or next to) the sandbox which is owned by
dhis2-devs.

I guess alternatively you just make your own branch by going to
https://code.launchpad.net/~miri and creating the branch there.  Then
the core devs decide how, when and what to merge with trunk.

Cheers
Bob

> ---
> Regards,
> Saptarshi PURKAYASTHA
> Director R & D, HISP India
> Health Information Systems Programme
>
> My Tech Blog:  http://sunnytalkstech.blogspot.com
> You Live by CHOICE, Not by CHANCE
>
>
> 2009/4/17 Murodullo Latifov 
>>
>> Hi people,
>>
>> Yes, we should have skype conference regarding bazaar SCM with some online
>> training. On blueprints I couldn't assign myself for implementing. Also both
>> 'easy access help' and 'datavalue history' show 'branch exists', I couldn't
>> get hold of them. Maybe I have not enough access rights? Or admin should
>> assign it to? I am afraid to do exesive job of copy/paste after all. :)
>> Can someone point me to proper documentation for bazaar users?
>>
>> regards,
>> murod
>>
>>
>>
>> - Original Message 
>> From: Bob Jolliffe 
>> To: Murodullo Latifov 
>> Cc: DHIS 2 developers 
>> Sent: Friday, April 17, 2009 11:57:45 AM
>> Subject: Re: [Dhis2-devs] Bazaar
>>
>> Hi Lars
>>
>> I think Murod's point is a reflection of a wider problem we have
>> regarding project management.  At least I don't feel I have yet got
>> completely on top of all the issues around bazaar management of
>> series, branches etc.  I know I haven't dedicated as much time to it
>> as I might have.  Mostly these are not bazaar problems.  When you go
>> to a bazaar which you are familiar with it is a very productive
>> experience.  Wondering around a bazaar which is new to you, well, you
>> can easily get lost.
>>
>> I think it would be a good idea to maybe set a date (like next Friday)
>> for a core developers conference call - maybe using skype or something
>> similar.  We can use the intervening week to study all the best
>> practices and discuss on list.
>>
>> Meanwhile I guess Murod should commit his code into the sandbox.  We
>> should always be able to commit code somewhere - rather than not
>> committing.  Then you and others can look at it and decide whether
>> some or all of this goes into 2.02/2.03 etc.  I guess this involves:
>>
>> bzr co lp:~dhis2-devs/dhis2/sandbox
>> add the code in a new folder here and add the folder to bzr
>> bzr commit
>>
>> Does this sound right?
>>
>> Regards
>> Bob
>>
>>
>> 2009/4/17 Murodullo Latifov :
>> >
>> > Hi Lars,
>> >
>> > In tajik bazaar is market. When you talk of bazaar outside of bazaar it
>> > means haos. When someone does things wrong, other may correct him: "hei, 
>> > you
>> > are not in bazaar, behave as respected". Now I am in bazaar. Please suggest
>> > corrections.
>> > I got my code from repository as branch. I didn't commit since then i
>> > guess. I made changes on poms, created struts2 test modules, implemented
>> > 'easy help' and 'datavalue history' functionalities. What to do now? commit
>> > all in one? where does it go? I could't find anywhere with my login on
>> > launchpad saying my branch. I also want to version my changes. I cannot
>> > continue with so many changes not versioned.
>> > Easy help functionality is fine to go (simply action file and vm), but
>> > datavalue history brings many changes starting from new dependencies and
>> > existing code change to introduce @annotations for hibernate. DataValue
>> > entity, which has composite primary key refering to foreign key to other 
>> > for
>> > entities (defined in hbm.xml) had been slightly changed (now annotated),
>> > services to it as well. Also one dependency is not on maven2 repo, it is 
>> > not
>> > there as latest (olders are there though), needs to be manually set. This 
>> > is
>> > enver library by jboss, to be part of hibernate 3.5 fairly soon as they
>> > promise.
>> > For easy help we need also someone who is good in manual writi

Re: [Dhis2-devs] DHIS 2 Lite Beta

[Bob Jolliffe]

It doesn't look too daunting.

I've attached output of:
grep -r mysql local/in/ >~/mysql.txt

I guess most of the work will be in the various DBConnection.java
files.  And of course the mysqldump.

I'm off till Wednesday though ...

Cheers
Bob

2009/4/17 Knut Staring :
> Sunny and Bharath,
> Can you describe exactly what the dependencies on Mysql in India are? I
> remember this was discussed during the workshop, but cannot recall the
> details.
> Knut
>
> 2009/4/16 Lars Helge Øverland 
>>
>>
>> 2009/4/16 Saptarshi Purkayastha 
>>>
>>> We were just discussing this yesterday that it would be good to give
>>> these to the states... but then since Indian modules are directly using
>>> MySQL, it will be sometime until we can use this.
>>
>>
>> OK I see.
>>
>> Is the Indian modules very much depending on MySQL specific functions, or
>> could we rewrite this code to use standard SQL only? If so, the
>> org.hisp.dhis.jdbc.StatementBuilder interface (which gives you SQL
>> statements) could be extended and used here. We have a
>> StatementBuilderFactory in the service-jdbc project which will give you an
>> implementation based on which database you are running. I am happy to help
>> out here if you like.
>>
>>
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Cheers,
> Knut Staring
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
local/in/dhis-web-reports-national/src/main/java/org/hisp/dhis/reports/util/DBConnection.java:
if ( s.contains( "jdbc:mysql:" ) )
local/in/dhis-web-reports-national/src/main/java/org/hisp/dhis/reports/util/DBConnection.java:
 * 
"jdbc:mysql://localhost/"+tempS2[tempS2.length-1].substring(0,
local/in/dhis-web-reports-national/src/main/java/org/hisp/dhis/reports/util/DBConnection.java:
// String urlForConnection = "jdbc:mysql://localhost/jh_dhis2";
local/in/dhis-web-reports-national/src/main/java/org/hisp/dhis/reports/util/DBConnection.java:
Class.forName( "com.mysql.jdbc.Driver" ).newInstance();
local/in/dhis-web-mobile/pom.xml:  mysql
local/in/dhis-web-mobile/pom.xml:  
mysql-connector-java
local/in/dhis-web-dashboard/src/main/resources/xwork.xml:  /dhis-web-dashboard/mysqlPathConfuration.vm
local/in/dhis-web-dashboard/src/main/webapp/dhis-web-dashboard/mysqlPathConfuration.vm:
 
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DBConnection.java:
if ( s.contains( "jdbc:mysql:" ) )
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DBConnection.java:
 * 
"jdbc:mysql://localhost/"+tempS2[tempS2.length-1].substring(0,
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DBConnection.java:
// String urlForConnection = "jdbc:mysql://localhost/jh_dhis2";
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DBConnection.java:
Class.forName( "com.mysql.jdbc.Driver" ).newInstance();
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/MaintenanceIN.java:
public static final String KEY_MYSQLPATH = "mysqlpath";
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/MaintenanceIN.java:
public static final String MYSQL_DEFAULT_PATH = "C:/DHIS2/mysql/bin";
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
String mysqlPath = null;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlPath = rs1.getString( 1 );
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
return mysqlPath;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
String mysqlKey = null;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
String mysqlPath = null;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlKey = rs1.getString( 1 );
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlPath = rs1.getString( 2 );
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
if( mysqlKey == null ) 
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlKey = MaintenanceIN.KEY_MYSQLPATH;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/uti

[Dhis2-devs] Shortname too short

[Knut Staring]

Hi all,

When importing dataelements, it becomes a problem that shornames have to be
both unique AND max 25 characters. I think we should loosen the second
requirement in the db. It must be up to the users to make their shortnames
sufficiently short, not a db constraint.

Knut
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Bazaar

[Saptarshi Purkayastha]

>
> I guess alternatively you just make your own branch by going to
> https://code.launchpad.net/~miri  and
> creating the branch there.  Then
> the core devs decide how, when and what to merge with trunk.


The second part from you reply is exactly what I said... He should commit it
to his branch (on lp) and then the core devs do the merge

---
Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog:  http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE


>
> >
> > 2009/4/17 Murodullo Latifov 
> >>
> >> Hi people,
> >>
> >> Yes, we should have skype conference regarding bazaar SCM with some
> online
> >> training. On blueprints I couldn't assign myself for implementing. Also
> both
> >> 'easy access help' and 'datavalue history' show 'branch exists', I
> couldn't
> >> get hold of them. Maybe I have not enough access rights? Or admin should
> >> assign it to? I am afraid to do exesive job of copy/paste after all. :)
> >> Can someone point me to proper documentation for bazaar users?
> >>
> >> regards,
> >> murod
> >>
> >>
> >>
> >> - Original Message 
> >> From: Bob Jolliffe 
> >> To: Murodullo Latifov 
> >> Cc: DHIS 2 developers 
> >> Sent: Friday, April 17, 2009 11:57:45 AM
> >> Subject: Re: [Dhis2-devs] Bazaar
> >>
> >> Hi Lars
> >>
> >> I think Murod's point is a reflection of a wider problem we have
> >> regarding project management.  At least I don't feel I have yet got
> >> completely on top of all the issues around bazaar management of
> >> series, branches etc.  I know I haven't dedicated as much time to it
> >> as I might have.  Mostly these are not bazaar problems.  When you go
> >> to a bazaar which you are familiar with it is a very productive
> >> experience.  Wondering around a bazaar which is new to you, well, you
> >> can easily get lost.
> >>
> >> I think it would be a good idea to maybe set a date (like next Friday)
> >> for a core developers conference call - maybe using skype or something
> >> similar.  We can use the intervening week to study all the best
> >> practices and discuss on list.
> >>
> >> Meanwhile I guess Murod should commit his code into the sandbox.  We
> >> should always be able to commit code somewhere - rather than not
> >> committing.  Then you and others can look at it and decide whether
> >> some or all of this goes into 2.02/2.03 etc.  I guess this involves:
> >>
> >> bzr co lp:~dhis2-devs/dhis2/sandbox
> >> add the code in a new folder here and add the folder to bzr
> >> bzr commit
> >>
> >> Does this sound right?
> >>
> >> Regards
> >> Bob
> >>
> >>
> >> 2009/4/17 Murodullo Latifov :
> >> >
> >> > Hi Lars,
> >> >
> >> > In tajik bazaar is market. When you talk of bazaar outside of bazaar
> it
> >> > means haos. When someone does things wrong, other may correct him:
> "hei, you
> >> > are not in bazaar, behave as respected". Now I am in bazaar. Please
> suggest
> >> > corrections.
> >> > I got my code from repository as branch. I didn't commit since then i
> >> > guess. I made changes on poms, created struts2 test modules,
> implemented
> >> > 'easy help' and 'datavalue history' functionalities. What to do now?
> commit
> >> > all in one? where does it go? I could't find anywhere with my login on
> >> > launchpad saying my branch. I also want to version my changes. I
> cannot
> >> > continue with so many changes not versioned.
> >> > Easy help functionality is fine to go (simply action file and vm), but
> >> > datavalue history brings many changes starting from new dependencies
> and
> >> > existing code change to introduce @annotations for hibernate.
> DataValue
> >> > entity, which has composite primary key refering to foreign key to
> other for
> >> > entities (defined in hbm.xml) had been slightly changed (now
> annotated),
> >> > services to it as well. Also one dependency is not on maven2 repo, it
> is not
> >> > there as latest (olders are there though), needs to be manually set.
> This is
> >> > enver library by jboss, to be part of hibernate 3.5 fairly soon as
> they
> >> > promise.
> >> > For easy help we need also someone who is good in manual writing to
> >> > place tags where necessary (other web modules menu.vm or anywhere
> control
> >> > needs help) and provide en_GB.properties strings acordingly. These
> changes
> >> > later should be placed into trunk and translated into other languages.
> >> > General Help menu could also use the same strings.
> >> >
> >> > regards,
> >> > murod.
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > ___
> >> > Mailing list: 
> >> > https://launchpad.net/~dhis2-devs
> >> > Post to : dhis2-devs@lists.launchpad.net
> >> > Unsubscribe : 
> >> > https://launchpad.net/~dhis2-devs
> >> > More help   : https://help.launchpad.net/ListHelp
> >> >
> >>
> >>
> >>
> >>
> >>
> >> _

Re: [Dhis2-devs] Shortname too short

[Saptarshi Purkayastha]

>
> When importing dataelements, it becomes a problem that shornames have to be
> both unique AND max 25 characters. I think we should loosen the second
> requirement in the db. It must be up to the users to make their shortnames
> sufficiently short, not a db constraint.
>
I disagree, it makes more sense to keep it the way it is... a reason its
called short name ;-)
and building boundaries on the data model is a best practice of sorts.
Some other solution may just be able to solve the problem??

---
Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog:  http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE


> Knut
>
> ___
> Mailing list: 
> https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : 
> https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Shortname too short

[Knut Staring]

On Fri, Apr 17, 2009 at 5:09 PM, Saptarshi Purkayastha wrote:

> When importing dataelements, it becomes a problem that shornames have to be
>> both unique AND max 25 characters. I think we should loosen the second
>> requirement in the db. It must be up to the users to make their shortnames
>> sufficiently short, not a db constraint.
>>
> I disagree, it makes more sense to keep it the way it is... a reason its
> called short name ;-)
> and building boundaries on the data model is a best practice of sorts.
>

Yes, that is exactly why we made it the way it is.

Some other solution may just be able to solve the problem??
>

Let me describe the issue in some more detail: We want to import a database
which has 3000 data elements (survey questions), most of them considerably
longer than 25 characters, and many very similar, often differing mainly in
a few characters at the end. Shortname is restricted to be required, unique
and 25 characters. One possibility is to just use the dataelementid as
shortname, but that of course would mean it is completely useless, just a
filler to enable data to be imported.

We are now putting a high priority on import (of hierarchies, data elements,
and data) from a spreadsheet, and the import process could perhaps contain
intelligence suggesting possible shortnames, but it is quite hard to come up
with something generic that will make sense in most cases. One strategy is
to just take the 25 first characters of the name, and if the result exists
already, substitute a number for the last two characters (alternatively do
this for all). This is sort of workable, but it would in that case be
desirable to also mark the data element so that someone can go through
manually afterwards.

Another option would be to the uniquenesscheck in the spreadsheet first - or
go through all dataelements with length over 25 characters manually before
importing. It is actually easier to do it in the spreadsheet than in DHIS 2
- but we don't have that import functionality yet.

Knut




>
> ---
> Regards,
> Saptarshi PURKAYASTHA
> Director R & D, HISP India
> Health Information Systems Programme
>
> My Tech Blog:  http://sunnytalkstech.blogspot.com
> You Live by CHOICE, Not by CHANCE
>
>
>> Knut
>>
>> ___
>> Mailing list: 
>> https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : 
>> https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Cheers,
Knut Staring
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Shortname too short

[Bob Jolliffe]

2009/4/17 Knut Staring :
> On Fri, Apr 17, 2009 at 5:09 PM, Saptarshi Purkayastha 
> wrote:
>>>
>>> When importing dataelements, it becomes a problem that shornames have to
>>> be both unique AND max 25 characters. I think we should loosen the second
>>> requirement in the db. It must be up to the users to make their shortnames
>>> sufficiently short, not a db constraint.
>>
>> I disagree, it makes more sense to keep it the way it is... a reason its
>> called short name ;-)
>> and building boundaries on the data model is a best practice of sorts.
>
> Yes, that is exactly why we made it the way it is.
>>
>> Some other solution may just be able to solve the problem??
>
> Let me describe the issue in some more detail: We want to import a database
> which has 3000 data elements (survey questions), most of them considerably
> longer than 25 characters, and many very similar, often differing mainly in
> a few characters at the end. Shortname is restricted to be required, unique
> and 25 characters. One possibility is to just use the dataelementid as
> shortname, but that of course would mean it is completely useless, just a
> filler to enable data to be imported.
> We are now putting a high priority on import (of hierarchies, data elements,
> and data) from a spreadsheet, and the import process could perhaps contain
> intelligence suggesting possible shortnames, but it is quite hard to come up
> with something generic that will make sense in most cases. One strategy is
> to just take the 25 first characters of the name, and if the result exists
> already, substitute a number for the last two characters (alternatively do
> this for all). This is sort of workable, but it would in that case be
> desirable to also mark the data element so that someone can go through
> manually afterwards.
> Another option would be to the uniquenesscheck in the spreadsheet first - or
> go through all dataelements with length over 25 characters manually before
> importing. It is actually easier to do it in the spreadsheet than in DHIS 2
> - but we don't have that import functionality yet.
> Knut

>From fs/namei.c in linux kernel source:
/*
 * Given a valid longname, create a unique shortname.  Make sure the
 * shortname does not exist
 * Returns negative number on error, 0 for a normal
 * return, and 1 for valid shortname
 */
static int vfat_create_shortname(struct inode *dir, struct nls_table *nls,
 wchar_t *uname, int ulen,
 unsigned char *name_res, unsigned char *lcase)

The algorithm is pretty short and could probably be pretty easily
replicated in java or perhaps better still as a spreadsheet macro.
But beware of patents - ask TomTom :-)  I guess this is what you have
in mind for your first option.

Seriously though, I have to agree with Saptarshi here.  The point of a
short name is that it should be bounded.  (I'm not sure a survey
question is a suitable candidate as a data element name anyway but
thats another issue).

I presume you won't lose the full name on import?  We have
'description' which holds an arbitrary amount of text.  So I would opt
to import the full question in here and do some sort of fat truncation
trick for the short names which are too long.  How many of them go
over the limit?  3000 is a lot but if you are talking 200 over the
limit it might be doable to manually edit them after the fact and make
them more meaningful.

Bob

>
>>
>> ---
>> Regards,
>> Saptarshi PURKAYASTHA
>> Director R & D, HISP India
>> Health Information Systems Programme
>>
>> My Tech Blog:  http://sunnytalkstech.blogspot.com
>> You Live by CHOICE, Not by CHANCE
>>
>>>
>>> Knut
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Cheers,
> Knut Staring
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Shortname too short

[Knut Staring]

On Fri, Apr 17, 2009 at 6:10 PM, Bob Jolliffe  wrote:

> 2009/4/17 Knut Staring :
> > On Fri, Apr 17, 2009 at 5:09 PM, Saptarshi Purkayastha  >
> > wrote:
> >>>
> >>> When importing dataelements, it becomes a problem that shornames have
> to
> >>> be both unique AND max 25 characters. I think we should loosen the
> second
> >>> requirement in the db. It must be up to the users to make their
> shortnames
> >>> sufficiently short, not a db constraint.
> >>
> >> I disagree, it makes more sense to keep it the way it is... a reason its
> >> called short name ;-)
> >> and building boundaries on the data model is a best practice of sorts.
> >
> > Yes, that is exactly why we made it the way it is.
> >>
> >> Some other solution may just be able to solve the problem??
> >
> > Let me describe the issue in some more detail: We want to import a
> database
> > which has 3000 data elements (survey questions), most of them
> considerably
> > longer than 25 characters, and many very similar, often differing mainly
> in
> > a few characters at the end. Shortname is restricted to be required,
> unique
> > and 25 characters. One possibility is to just use the dataelementid as
> > shortname, but that of course would mean it is completely useless, just a
> > filler to enable data to be imported.
> > We are now putting a high priority on import (of hierarchies, data
> elements,
> > and data) from a spreadsheet, and the import process could perhaps
> contain
> > intelligence suggesting possible shortnames, but it is quite hard to come
> up
> > with something generic that will make sense in most cases. One strategy
> is
> > to just take the 25 first characters of the name, and if the result
> exists
> > already, substitute a number for the last two characters (alternatively
> do
> > this for all). This is sort of workable, but it would in that case be
> > desirable to also mark the data element so that someone can go through
> > manually afterwards.
> > Another option would be to the uniquenesscheck in the spreadsheet first -
> or
> > go through all dataelements with length over 25 characters manually
> before
> > importing. It is actually easier to do it in the spreadsheet than in DHIS
> 2
> > - but we don't have that import functionality yet.
> > Knut
>
> From fs/namei.c in linux kernel source:
> /*
>  * Given a valid longname, create a unique shortname.  Make sure the
>  * shortname does not exist
>  * Returns negative number on error, 0 for a normal
>  * return, and 1 for valid shortname
>  */
> static int vfat_create_shortname(struct inode *dir, struct nls_table *nls,
> wchar_t *uname, int ulen,
> unsigned char *name_res, unsigned char
> *lcase)
>
> The algorithm is pretty short and could probably be pretty easily
> replicated in java or perhaps better still as a spreadsheet macro.


A spreadsheet macro may be the best for coming up with plausible candidates,
though I have no idea what this particular one does.


> Seriously though, I have to agree with Saptarshi here.  The point of a
> short name is that it should be bounded.


There is no disagreement on that, the issue is what to do when importing
data from existing systems. From many perspectives, it does make sense to do
most of the required processing before importing, at least the simple.


> (I'm not sure a survey question is a suitable candidate as a data element
> name anyway but thats another issue).
>

Survey data is a very high priority for us, but you are right that the bulk
description will go in a different field. And one should probably take the
required time to change both shortnames and names when importing into DHIS,
but this has to be done by the owners of the data. After we have spreadsheet
import implemented, it will be easier to give people instructions as to how
to process their data in preparation for import. Probably, we have to create
some macros to assist in this.

I presume you won't lose the full name on import?


The full name is no problem, issue is only what to do with the shortname
field. But I do think you're right that the issue should be handled before
importing. Still, we may want to extend to 30


>  We have
> 'description' which holds an arbitrary amount of text.  So I would opt
> to import the full question in here and do some sort of fat truncation
> trick for the short names which are too long. How many of them go

over the limit?


2341

Knut

3000 is a lot but if you are talking 200 over the
> limit it might be doable to manually edit them after the fact and make
> them more meaningful.
>
> Bob
>
> >
> >>
> >> ---
> >> Regards,
> >> Saptarshi PURKAYASTHA
> >> Director R & D, HISP India
> >> Health Information Systems Programme
> >>
> >> My Tech Blog:  http://sunnytalkstech.blogspot.com
> >> You Live by CHOICE, Not by CHANCE
> >>
> >>>
> >>> Knut
> >>>
> >>> ___
> >>> Mailing list: https://launchpad.net/~dhis2-devs
> >>> Post

Re: [Dhis2-devs] Shortname too short

[Bob Jolliffe]

2009/4/17 Knut Staring :
> On Fri, Apr 17, 2009 at 6:10 PM, Bob Jolliffe  wrote:
>>
>> 2009/4/17 Knut Staring :
>> > On Fri, Apr 17, 2009 at 5:09 PM, Saptarshi Purkayastha
>> > 
>> > wrote:
>> >>>
>> >>> When importing dataelements, it becomes a problem that shornames have
>> >>> to
>> >>> be both unique AND max 25 characters. I think we should loosen the
>> >>> second
>> >>> requirement in the db. It must be up to the users to make their
>> >>> shortnames
>> >>> sufficiently short, not a db constraint.
>> >>
>> >> I disagree, it makes more sense to keep it the way it is... a reason
>> >> its
>> >> called short name ;-)
>> >> and building boundaries on the data model is a best practice of sorts.
>> >
>> > Yes, that is exactly why we made it the way it is.
>> >>
>> >> Some other solution may just be able to solve the problem??
>> >
>> > Let me describe the issue in some more detail: We want to import a
>> > database
>> > which has 3000 data elements (survey questions), most of them
>> > considerably
>> > longer than 25 characters, and many very similar, often differing mainly
>> > in
>> > a few characters at the end. Shortname is restricted to be required,
>> > unique
>> > and 25 characters. One possibility is to just use the dataelementid as
>> > shortname, but that of course would mean it is completely useless, just
>> > a
>> > filler to enable data to be imported.
>> > We are now putting a high priority on import (of hierarchies, data
>> > elements,
>> > and data) from a spreadsheet, and the import process could perhaps
>> > contain
>> > intelligence suggesting possible shortnames, but it is quite hard to
>> > come up
>> > with something generic that will make sense in most cases. One strategy
>> > is
>> > to just take the 25 first characters of the name, and if the result
>> > exists
>> > already, substitute a number for the last two characters (alternatively
>> > do
>> > this for all). This is sort of workable, but it would in that case be
>> > desirable to also mark the data element so that someone can go through
>> > manually afterwards.
>> > Another option would be to the uniquenesscheck in the spreadsheet first
>> > - or
>> > go through all dataelements with length over 25 characters manually
>> > before
>> > importing. It is actually easier to do it in the spreadsheet than in
>> > DHIS 2
>> > - but we don't have that import functionality yet.
>> > Knut
>>
>> From fs/namei.c in linux kernel source:
>> /*
>>  * Given a valid longname, create a unique shortname.  Make sure the
>>  * shortname does not exist
>>  * Returns negative number on error, 0 for a normal
>>  * return, and 1 for valid shortname
>>  */
>> static int vfat_create_shortname(struct inode *dir, struct nls_table *nls,
>>                                 wchar_t *uname, int ulen,
>>                                 unsigned char *name_res, unsigned char
>> *lcase)
>>
>> The algorithm is pretty short and could probably be pretty easily
>> replicated in java or perhaps better still as a spreadsheet macro.
>
> A spreadsheet macro may be the best for coming up with plausible candidates,
> though I have no idea what this particular one does.
>
>>
>> Seriously though, I have to agree with Saptarshi here.  The point of a
>> short name is that it should be bounded.
>
> There is no disagreement on that, the issue is what to do when importing
> data from existing systems. From many perspectives, it does make sense to do
> most of the required processing before importing, at least the simple.
>
>>
>> (I'm not sure a survey question is a suitable candidate as a data element
>> name anyway but thats another issue).
>
> Survey data is a very high priority for us, but you are right that the bulk
> description will go in a different field. And one should probably take the
> required time to change both shortnames and names when importing into DHIS,
> but this has to be done by the owners of the data. After we have spreadsheet
> import implemented, it will be easier to give people instructions as to how
> to process their data in preparation for import. Probably, we have to create
> some macros to assist in this.
>>
>> I presume you won't lose the full name on import?
>
>
> The full name is no problem, issue is only what to do with the shortname
> field. But I do think you're right that the issue should be handled before
> importing. Still, we may want to extend to 30
>
>>
>>  We have
>> 'description' which holds an arbitrary amount of text.  So I would opt
>> to import the full question in here and do some sort of fat truncation
>> trick for the short names which are too long. How many of them go
>>
>> over the limit?
>
> 2341


Thats a lot more than you want to do by hand!  Dunno.  Will think some more.

Bob

>
> Knut
>>
>> 3000 is a lot but if you are talking 200 over the
>> limit it might be doable to manually edit them after the fact and make
>> them more meaningful.
>>
>> Bob
>>
>> >
>> >>
>> >> ---
>> >> Regards,
>> >> Saptarshi PURKAYASTHA
>> >> 

Re: [Dhis2-devs] Shortname too short

[Knut Staring]

On Fri, Apr 17, 2009 at 8:26 PM, Bob Jolliffe  wrote:

> 2009/4/17 Knut Staring :
> > On Fri, Apr 17, 2009 at 6:10 PM, Bob Jolliffe 
> wrote:
> >>
> >>  We have
> >> 'description' which holds an arbitrary amount of text.  So I would opt
> >> to import the full question in here and do some sort of fat truncation
> >> trick for the short names which are too long. How many of them go
> >>
> >> over the limit?
> >
> > 2341
>
> Thats a lot more than you want to do by hand!  Dunno.  Will think some
> more.
>

For now, I will make do with truncated names + id. We just have to add the
full names to the report tables (which currently rely only on short names -
easy enough to do).

But it is an interesting question whether it is possible to generate
meaningful names (both full and short) from long survey questions (a handful
are over 150 characters), whereas the full question can go into the
description field or similar.

Knut
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Shortname too short

[Jason Pickering]

I will throw my two (probably worthless) cents in here. [?]

For the use case you describe Knut (surveys), it is incumbent upon the user
to create a unique AND short name, usually to pull into something like SAS,
SPSS, R or other statistical package (or possibly GIS) that can only deal
short names. Most survey packages (CSPRO, LimeSurvey, etc) require some sort
of unique and short name as a code for each question. So if the survey has
been properly implemented from the get-go, there should not be an issue
here. I would say that this import process should simply be *well documented
*, and that the current data model should not be messed with. It works well
for things like exporting to DBF (compatible with GIS) and releasing this
restriction could really create a lot of problems, potentially also with
importing data from DHIS 1.4 (although I have no idea what the actual
maximum length there is, but I assume it is 25 as well).


I say leave it as is. If people need this functionality, let them change the
DB at their own peril.

Regards,
Jason



On Fri, Apr 17, 2009 at 8:33 PM, Knut Staring  wrote:

> On Fri, Apr 17, 2009 at 8:26 PM, Bob Jolliffe wrote:
>
>> 2009/4/17 Knut Staring :
>> > On Fri, Apr 17, 2009 at 6:10 PM, Bob Jolliffe 
>> wrote:
>> >>
>> >>  We have
>> >> 'description' which holds an arbitrary amount of text.  So I would opt
>> >> to import the full question in here and do some sort of fat truncation
>> >> trick for the short names which are too long. How many of them go
>> >>
>> >> over the limit?
>> >
>> > 2341
>>
>> Thats a lot more than you want to do by hand!  Dunno.  Will think some
>> more.
>>
>
> For now, I will make do with truncated names + id. We just have to add the
> full names to the report tables (which currently rely only on short names -
> easy enough to do).
>
> But it is an interesting question whether it is possible to generate
> meaningful names (both full and short) from long survey questions (a handful
> are over 150 characters), whereas the full question can go into the
> description field or similar.
>
> Knut
>
> ___
> Mailing list: 
> https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : 
> https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
<<360.gif>>___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 188: Work on mapping web module

[noreply]

revno: 188
committer: Lars Helge Oeverland larshe...@gmail.com
branch nick: trunk
timestamp: Fri 2009-04-17 23:35:32 +0200
message:
  Work on mapping web module
added:
  
gis/dhis-web-mapping/src/main/java/org/hisp/dhis/mapping/action/AddOrUpdateMapAction.java
  
gis/dhis-web-mapping/src/main/java/org/hisp/dhis/mapping/action/AddOrUpdateMapOrganisationUnitRelationAction.java
  
gis/dhis-web-mapping/src/main/java/org/hisp/dhis/mapping/action/GetAllIndicatorGroupsAction.java
  
gis/dhis-web-mapping/src/main/java/org/hisp/dhis/mapping/action/GetAllMapsAction.java
  
gis/dhis-web-mapping/src/main/java/org/hisp/dhis/mapping/action/GetAllPeriodTypesAction.java
  
gis/dhis-web-mapping/src/main/java/org/hisp/dhis/mapping/action/GetAvailableMapOrganisationUnitRelationsAction.java
  
gis/dhis-web-mapping/src/main/java/org/hisp/dhis/mapping/action/GetIndicatorsByIndicatorGroupAction.java
  
gis/dhis-web-mapping/src/main/java/org/hisp/dhis/mapping/action/GetMapByMapLayerPathAction.java
  
gis/dhis-web-mapping/src/main/java/org/hisp/dhis/mapping/action/GetMapValuesAction.java
  
gis/dhis-web-mapping/src/main/java/org/hisp/dhis/mapping/action/GetOrganisationUnitsAtLevelAction.java
  
gis/dhis-web-mapping/src/main/java/org/hisp/dhis/mapping/action/GetPeriodsByPeriodTypeAction.java
  
gis/dhis-web-mapping/src/main/webapp/dhis-web-mapping/jsonAggregatedMapValues.vm
  gis/dhis-web-mapping/src/main/webapp/dhis-web-mapping/jsonIndicatorGroups.vm
  gis/dhis-web-mapping/src/main/webapp/dhis-web-mapping/jsonMap.vm
  
gis/dhis-web-mapping/src/main/webapp/dhis-web-mapping/jsonMapOrganisationUnitRelations.vm
  gis/dhis-web-mapping/src/main/webapp/dhis-web-mapping/jsonOrganisationUnits.vm
  gis/dhis-web-mapping/src/main/webapp/dhis-web-mapping/jsonPeriodTypes.vm
  gis/dhis-web-mapping/src/main/webapp/dhis-web-mapping/jsonPeriods.vm
  gis/dhis-web-mapping/src/main/webapp/dhis-web-mapping/jsonminIndicators.vm
  gis/dhis-web-mapping/src/main/webapp/dhis-web-mapping/jsonminMaps.vm
modified:
  gis/dhis-web-mapping/pom.xml
  gis/dhis-web-mapping/src/main/resources/META-INF/dhis/beans.xml
  gis/dhis-web-mapping/src/main/resources/xwork.xml

The size of the diff (1346 lines) is larger than your specified limit of 1000 
lines

--
Trunk
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to 
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 189: Work on mapping web module

[noreply]

revno: 189
committer: Lars Helge Oeverland larshe...@gmail.com
branch nick: trunk
timestamp: Sat 2009-04-18 00:18:50 +0200
message:
  Work on mapping web module
added:
  gis/dhis-web-mapping/src/main/webapp/dhis-web-mapping/void.vm
modified:
  dhis-2/dhis-web/dhis-web-commons/src/main/resources/i18n_global.properties
  gis/dhis-web-mapping/src/main/resources/META-INF/dhis/beans.xml
  gis/dhis-web-mapping/src/main/resources/xwork.xml

=== modified file 
'dhis-2/dhis-web/dhis-web-commons/src/main/resources/i18n_global.properties'
--- dhis-2/dhis-web/dhis-web-commons/src/main/resources/i18n_global.properties  
2009-03-13 11:51:35 +
+++ dhis-2/dhis-web/dhis-web-commons/src/main/resources/i18n_global.properties  
2009-04-17 22:18:50 +
@@ -54,6 +54,7 @@
 dhis-web-jforum-integration = Forum
 dhis-web-dataentry-national = Linelisting Data Entry
 dhis-web-validationrule-local-in = Validation Analysis
+dhis-web-mapping = Mapping
 
 #-- Common 
#
 

=== modified file 
'gis/dhis-web-mapping/src/main/resources/META-INF/dhis/beans.xml'
--- gis/dhis-web-mapping/src/main/resources/META-INF/dhis/beans.xml 
2009-04-17 21:35:32 +
+++ gis/dhis-web-mapping/src/main/resources/META-INF/dhis/beans.xml 
2009-04-17 22:18:50 +
@@ -91,15 +91,15 @@
   
+
+  
+  
+  
 
   
   
-  
-
-  
-  
 

=== modified file 'gis/dhis-web-mapping/src/main/resources/xwork.xml'
--- gis/dhis-web-mapping/src/main/resources/xwork.xml   2009-04-17 21:35:32 
+
+++ gis/dhis-web-mapping/src/main/resources/xwork.xml   2009-04-17 22:18:50 
+
@@ -7,6 +7,8 @@
   
 
+
+  
 
   /main.vm
   /dhis-web-mapping/index.vm
@@ -18,5 +20,55 @@
   /dhis-web-mapping/jsonOrganisationUnitLevels.vm
 
 
+
+  /dhis-web-mapping/jsonOrganisationUnits.vm
+
+
+
+
+
+  /dhis-web-mapping/void.vm
+
+
+
+  /dhis-web-mapping/jsonminMaps.vm
+
+
+
+  /dhis-web-mapping/jsonMap.vm
+
+
+
+  /dhis-web-mapping/jsonAggregatedMapValues.vm
+
+
+
+  /dhis-web-mapping/void.vm
+
+
+
+  /dhis-web-mapping/jsonMapOrganisationUnitRelations.vm
+
+
+
+
+
+  /dhis-web-mapping/jsonIndicatorGroups.vm
+
+
+
+  /dhis-web-mapping/jsonminIndicators.vm
+
+
+
+
+
+  /dhis-web-mapping/jsonPeriodTypes.vm
+
+
+
+  /dhis-web-mapping/jsonPeriods.vm
+
+  
   
 

=== added file 'gis/dhis-web-mapping/src/main/webapp/dhis-web-mapping/void.vm'


--
Trunk
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to 
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 191: blueprints:ie6-compliance, low-res. Other js fixes for all browsers... Author: Zafar, Bharath, Sei...

[noreply]

revno: 191
committer: sunbiz 
branch nick: trunk
timestamp: Sat 2009-04-18 04:43:07 +0530
message:
  blueprints:ie6-compliance,low-res. Other js fixes for all browsers... Author: 
Zafar, Bharath, Seid - new India theme part of v1 Indian deployment
added:
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/india/
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/india/dom.js
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/india/head.png
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/india/india.css
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/india/logo_background.png
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/india/logo_banner.png
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/india/logo_left.png
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/india/logo_right.png
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/india/logo_separator.png
modified:
  dhis-2/dhis-options/src/main/resources/META-INF/dhis/beans.xml
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/blue/blue.css
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/blue/logo_banner.png
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/blue/logo_right.png
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/security/logo_banner.png
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/util/lists.js
  dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/main.js
  dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/request.js
  
dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/webapp/dhis-web-maintenance-dataadmin/javascript/locking.js
  
dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/webapp/dhis-web-maintenance-dataadmin/lockingForm.vm
  
dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/webapp/dhis-web-maintenance-dataadmin/menu.vm
  
dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-datadictionary/src/main/webapp/dhis-web-maintenance-datadictionary/dataElementGroupEditor.vm
  
dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-datadictionary/src/main/webapp/dhis-web-maintenance-datadictionary/javascript/dataElementGroupEditor.js

The size of the diff (2263 lines) is larger than your specified limit of 1000 
lines

--
Trunk
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to 
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] DHIS 2 Lite Beta

[bharath kumar]

All India Modules is using both hibernate and mysql. But we are going to
start to refactor all modules.

2009/4/17 Knut Staring 

> Sunny and Bharath,
> Can you describe exactly what the dependencies on Mysql in India are? I
> remember this was discussed during the workshop, but cannot recall the
> details.
>
> Knut
>
> 2009/4/16 Lars Helge Øverland 
>
>>
>>
>> 2009/4/16 Saptarshi Purkayastha 
>>
>>> We were just discussing this yesterday that it would be good to give
>>> these to the states... but then since Indian modules are directly using
>>> MySQL, it will be sometime until we can use this.
>>>
>>
>>
>> OK I see.
>>
>> Is the Indian modules very much depending on MySQL specific functions, or
>> could we rewrite this code to use standard SQL only? If so, the
>> org.hisp.dhis.jdbc.StatementBuilder interface (which gives you SQL
>> statements) could be extended and used here. We have a
>> StatementBuilderFactory in the service-jdbc project which will give you an
>> implementation based on which database you are running. I am happy to help
>> out here if you like.
>>
>>
>>
>>
>>
>>
>> ___
>> Mailing list: 
>> https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : 
>> https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Cheers,
> Knut Staring
>
> ___
> Mailing list: 
> https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : 
> https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 

Regards,
Bharath Kumar. Ch
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Shortname too short

[johansa]

> I will throw my two (probably worthless) cents in here. [?]
>
> For the use case you describe Knut (surveys), it is incumbent upon the
> user
> to create a unique AND short name, usually to pull into something like
> SAS,
> SPSS, R or other statistical package (or possibly GIS) that can only deal
> short names. Most survey packages (CSPRO, LimeSurvey, etc) require some
> sort
> of unique and short name as a code for each question. So if the survey has
> been properly implemented from the get-go, there should not be an issue
> here. I would say that this import process should simply be *well
> documented
> *, and that the current data model should not be messed with. It works
> well
> for things like exporting to DBF (compatible with GIS) and releasing this
> restriction could really create a lot of problems, potentially also with
> importing data from DHIS 1.4 (although I have no idea what the actual
> maximum length there is, but I assume it is 25 as well).

Acutally, I thought it was only 20 in DHIS 1.4? What happens at import
then? btw, the maximum length is very useful, not only for the technical
reasons already mentioned, but also for making nice reports (without just
cutting away the often important last part of a DE name). That's the main
reason from a users perspective


> I say leave it as is. If people need this functionality, let them change
> the
> DB at their own peril.
>
> Regards,
> Jason
>
>
>
> On Fri, Apr 17, 2009 at 8:33 PM, Knut Staring  wrote:
>
>> On Fri, Apr 17, 2009 at 8:26 PM, Bob Jolliffe
>> wrote:
>>
>>> 2009/4/17 Knut Staring :
>>> > On Fri, Apr 17, 2009 at 6:10 PM, Bob Jolliffe 
>>> wrote:
>>> >>
>>> >>  We have
>>> >> 'description' which holds an arbitrary amount of text.  So I would
>>> opt
>>> >> to import the full question in here and do some sort of fat
>>> truncation
>>> >> trick for the short names which are too long. How many of them go
>>> >>
>>> >> over the limit?
>>> >
>>> > 2341
>>>
>>> Thats a lot more than you want to do by hand!  Dunno.  Will think some
>>> more.
>>>
>>
>> For now, I will make do with truncated names + id. We just have to add
>> the
>> full names to the report tables (which currently rely only on short
>> names -
>> easy enough to do).
>>
>> But it is an interesting question whether it is possible to generate
>> meaningful names (both full and short) from long survey questions (a
>> handful
>> are over 150 characters), whereas the full question can go into the
>> description field or similar.
>>
>> Knut
>>
>> ___
>> Mailing list:
>> https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe :
>> https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>



___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Shortname too short

[Knut Staring]

On Sat, Apr 18, 2009 at 8:19 AM,  wrote:

> > I will throw my two (probably worthless) cents in here. [?]
> >
> > For the use case you describe Knut (surveys), it is incumbent upon the
> > user
> > to create a unique AND short name, usually to pull into something like
> > SAS,
> > SPSS, R or other statistical package (or possibly GIS) that can only deal
> > short names. Most survey packages (CSPRO, LimeSurvey, etc) require some
> > sort
> > of unique and short name as a code for each question. So if the survey
> has
> > been properly implemented from the get-go, there should not be an issue
> > here. I would say that this import process should simply be *well
> > documented
> > *, and that the current data model should not be messed with. It works
> > well
> > for things like exporting to DBF (compatible with GIS) and releasing this
> > restriction could really create a lot of problems, potentially also with
> > importing data from DHIS 1.4 (although I have no idea what the actual
> > maximum length there is, but I assume it is 25 as well).
>
> Acutally, I thought it was only 20 in DHIS 1.4? What happens at import
> then? btw, the maximum length is very useful, not only for the technical
> reasons already mentioned, but also for making nice reports (without just
> cutting away the often important last part of a DE name). That's the main
> reason from a users perspective
>

Yes, we will keep things as they are, but will have to implement and
document a procedure for importing from Excel: People need guidelines and
 hopefully some automated assistance when importing preexisting data and
metadata. We would really appreciate help on the documentation.

Knut



>
>
> > I say leave it as is. If people need this functionality, let them change
> > the
> > DB at their own peril.
> >
> > Regards,
> > Jason
> >
> >
> >
> > On Fri, Apr 17, 2009 at 8:33 PM, Knut Staring  wrote:
> >
> >> On Fri, Apr 17, 2009 at 8:26 PM, Bob Jolliffe
> >> wrote:
> >>
> >>> 2009/4/17 Knut Staring :
> >>> > On Fri, Apr 17, 2009 at 6:10 PM, Bob Jolliffe  >
> >>> wrote:
> >>> >>
> >>> >>  We have
> >>> >> 'description' which holds an arbitrary amount of text.  So I would
> >>> opt
> >>> >> to import the full question in here and do some sort of fat
> >>> truncation
> >>> >> trick for the short names which are too long. How many of them go
> >>> >>
> >>> >> over the limit?
> >>> >
> >>> > 2341
> >>>
> >>> Thats a lot more than you want to do by hand!  Dunno.  Will think some
> >>> more.
> >>>
> >>
> >> For now, I will make do with truncated names + id. We just have to add
> >> the
> >> full names to the report tables (which currently rely only on short
> >> names -
> >> easy enough to do).
> >>
> >> But it is an interesting question whether it is possible to generate
> >> meaningful names (both full and short) from long survey questions (a
> >> handful
> >> are over 150 characters), whereas the full question can go into the
> >> description field or similar.
> >>
> >> Knut
> >>
> >> ___
> >> Mailing list:
> >> https://launchpad.net/~dhis2-devs
> >> Post to : dhis2-devs@lists.launchpad.net
> >> Unsubscribe :
> >> https://launchpad.net/~dhis2-devs
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >>
> > ___
> > Mailing list: https://launchpad.net/~dhis2-devs
> > Post to : dhis2-devs@lists.launchpad.net
> > Unsubscribe : https://launchpad.net/~dhis2-devs
> > More help   : https://help.launchpad.net/ListHelp
> >
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Cheers,
Knut Staring
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Shortname too short

[Jason Pickering]

Hi Johan,
Just a quick clarification.

>
>>
>> Acutally, I thought it was only 20 in DHIS 1.4? What happens at import
>> then? btw, the maximum length is very useful, not only for the technical
>> reasons already mentioned, but also for making nice reports (without just
>> cutting away the often important last part of a DE name). That's the main
>> reason from a users perspective.
>
>
It is in fact 25 (in DHIS 1.4 build 112), I just checked. The shorter DOS
name is limited to 8 characters for exports to things like DBF4.


Regards,
Jason
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp