Re: [Dhis2-devs] Global ranges
Hi, Most likely this is pg security restriction. Open PGadmin and navigate to minmaxdataelement table, right click and select properties. Make sure if owner is the same as other tables. This should solve the issue. regards, murod - Original Message From: "joha...@ifi.uio.no" To: Knut Staring Cc: dhis2-devs@lists.launchpad.net Sent: Monday, June 8, 2009 10:51:06 PM Subject: Re: [Dhis2-devs] Global ranges After running the below statement and trying to access Data Entry, we get this error. Any ideas about what causes the "ERROR: permission denied for relation minmaxdataelement"? [+] Exception (org.hibernate.exception.SQLGrammarException): could not execute query * org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) * org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) * org.hibernate.loader.Loader.doList(Loader.java:2216) * org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) * org.hibernate.loader.Loader.list(Loader.java:2099) * org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) * org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569) * org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) * org.hisp.dhis.minmax.hibernate.HibernateMinMaxDataElementStore.getMinMaxDataElements(HibernateMinMaxDataElementStore.java:134) * sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2) * sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) * sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) * java.lang.reflect.Method.invoke(Method.java:597) * org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) * org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) * org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) * org.hisp.dhis.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:75) * org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) * org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) * $Proxy31.getMinMaxDataElements(Unknown source) * org.hisp.dhis.de.action.multidimensional.FormAction.execute(FormAction.java:476) * sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2) * sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) * sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) * java.lang.reflect.Method.invoke(Method.java:597) * com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358) * com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:192) * org.hisp.dhis.webwork.interceptor.AbstractPreResultListener.intercept(AbstractPreResultListener.java:71) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * org.hisp.dhis.webwork.interceptor.WebWorkTransactionInterceptor.intercept(WebWorkTransactionInterceptor.java:79) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * org.hisp.dhis.webwork.interceptor.WebWorkDisplayPropertyInterceptor.intercept(WebWorkDisplayPropertyInterceptor.java:90) * com.opensymphony.xwork.
[Dhis2-devs] Struts2 port branch
Hi all, Just created Struts2 port branch in launchpad. Project: DHIS Status:Development Get this branch:bzr branch lp:~dhis2-devs/dhis2/dhis2-struts2-port Update this branch:bzr push lp:~dhis2-devs/dhis2/dhis2-struts2-port Branch format:Branch format 6 Repository format:Packs containing knits without subtree support Code is the same as was with 4 new modules added with webwork framework to struts2 port, also other code outside dhis and docs folders are missing in this branch. 3 new modules are support modules and only import-export module was ported to testing if struts framework works. This way we can shift modules one after another to struts and with small refactoring port code to use struts2. Ideas, comments, additions are welcome. 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] Global ranges
hi, That means you are supplying "null" somewhere in your hibernate object creation. Try to find out, otherwise create bug. Because if "null" is allowed primitive data type should be changed to Object, e.g. int should be Integer. regards, murod - Original Message From: "joha...@ifi.uio.no" To: Murodullo Latifov Cc: Knut Staring ; dhis2-devs@lists.launchpad.net Sent: Tuesday, June 9, 2009 3:55:37 PM Subject: Re: [Dhis2-devs] Global ranges > > Hi, > > Most likely this is pg security restriction. Open PGadmin and navigate to > minmaxdataelement table, right click and select properties. Make sure if > owner is the same as other tables. This should solve the issue. Ok, changed the owner, but I get another error now. [-] Exception (org.hibernate.PropertyAccessException): Null value was assigned to a property of primitive type setter of org.hisp.dhis.minmax.MinMaxDataElement.generated * org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:85) * org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:337) * org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:200) * org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3571) * org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:133) * org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854) * org.hibernate.loader.Loader.doQuery(Loader.java:729) * org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) * org.hibernate.loader.Loader.doList(Loader.java:2213) * org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) * org.hibernate.loader.Loader.list(Loader.java:2099) * org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) * org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569) * org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) * org.hisp.dhis.minmax.hibernate.HibernateMinMaxDataElementStore.getMinMaxDataElements(HibernateMinMaxDataElementStore.java:134) * sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2) * sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) * sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) * java.lang.reflect.Method.invoke(Method.java:597) * org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) * org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) * org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) * org.hisp.dhis.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:75) * org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) * org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) * $Proxy31.getMinMaxDataElements(Unknown source) * org.hisp.dhis.de.action.multidimensional.FormAction.execute(FormAction.java:476) * sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2) * sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) * sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) * java.lang.reflect.Method.invoke(Method.java:597) * com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358) * com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:192) * org.hisp.dhis.webwork.interceptor.AbstractPreResultListener.intercept(AbstractPreResultListener.java:71) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * org.hisp.dhis.webwork.interceptor.WebWorkTransactionInterceptor.intercept(WebWorkTransactionInterceptor.java:79) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) * com.opensymphony.xwork.interceptor.Aroun
Re: [Dhis2-devs] Needed for support with jxl package
Hi, From: Hieu Dang Duy To: dhis2-devs@lists.launchpad.net Sent: Tuesday, June 16, 2009 12:31:04 PM Subject: [Dhis2-devs] Needed for support with jxl package Dear all, I'm using the package as jxl (2.6). By using this one i've got the workbook of the identified excel file. My excel file has some of formulas in its content as following example: Ex: (Columns) A B C D (Rows)110 8 0 =SUM(A1:C1) 2 - - - - These formulas were set-up and written into the excel file by Java. The issue was happened when i were reading this excel file and printing out value of each formula in each Cell as D1, it always return as 4. By the way, if i opened this file and had some of changing into its content then saving again. After that, re-checking is it return the correct value which is should be as 18. Any idea or suggestion on this entry ? Expecting for your all comments ! p.s: I don't think the error at excel version or by the tool for designing it as MS Office, Open Office, ... Thanks ! Try to place formulae first, e.g. before you add data for cells used by that formulae. From my experience with POI (similar java library for excel) this should help. regards, murod. -- Hieu.HISPVietnam Good Health ! ___ 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] calling datavalueservice
Hi Ime,
You should look at dhis-api module for definition of datavalue service at that
is dhis-api/src/main/java/org/hisp/dhis/datavalue and and hibernate mapping and
service implementation in
dhis-service-core/src/main/java/org/hisp/dhis/datavalue and
dhis-service-core/src/main/resources/org/hisp/dhis/datavalue/hibernate.
These two define full cycle of datavalue access API.
External access example could be seen in
dhis-web-dataentry/src/main/java/org/hisp/dhis/de/action/multidimentional/:
Injected service (see bean definition at
dhis-web-dataentry/src/main/resources/META-INF/dhis/beans.xml):
...
private DataValueService dataValueService;
public void setDataValueService( DataValueService dataValueService )
{
this.dataValueService = dataValueService;
}
...
Usage:
// -
// Get the DataValues and create a map
// -
Collection dataValues = dataValueService.getDataValues(
organisationUnit, period, dataElements,
orderdCategoryOptionCombos );
and
...
// -
// Add/Update datavalue
// -
DataValue dataValue = dataValueService.getDataValue( organisationUnit,
dataElement, period,optionCombo );
if ( dataValue == null )
{
if ( value != null )
{
LOG.debug( "Adding DataValue, value added" );
dataValue = new DataValue( dataElement, period,
organisationUnit, value, storedBy, new Date(), null, optionCombo );
dataValueService.addDataValue( dataValue );
}
}
else
{
LOG.debug( "Updating DataValue, value added/changed" );
dataValue.setValue( value );
dataValue.setTimestamp( new Date() );
dataValue.setStoredBy( storedBy );
dataValueService.updateDataValue( dataValue );
}
...
Hope this helps. This is general structure to call any service in dhis2. For
hibernate and spring mapping please refer to respective manuals from their
sites.
regards,
murod
- Original Message
From: Ime Asangansi
To: Dhis2
Sent: Tuesday, June 16, 2009 7:12:02 PM
Subject: [Dhis2-devs] calling datavalueservice
Hi guys,
Please can someone kindly show me code that calls the datavalueservice?
(Link in launchpad).
Particularly interested in any available code (in an external module) that
handles the import of datavalues into the database (e.g. from import).
Also, any possiblities with adding datavalues through a webservice???
TIA!
Cheers,
Ime
___
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] Needed for support with jxl package
Hi, From: Hieu Dang Duy To: bobjolli...@gmail.com; Murodullo Latifov Cc: dhis2-devs@lists.launchpad.net Sent: Wednesday, June 17, 2009 6:22:23 AM Subject: Re: [Dhis2-devs] Needed for support with jxl package Thank you for your ardour, Bob. Hi Murodullo, You said that "Placed the formulas first" ... but by hands or by coding ? What's even else, though I'd tried to place the formulas before adding the data on each cell with both of the above manners (handing or coding). That issue's still existed. Did I forget something else ? On the other hands, that problem which is only happening if I read the excel's workbook by jxl package. P.S: Actually that, we (HISP-VN) have being developed the report module generating the excel report file like the HISP-India team's idea. Everything is ok up-to-now, we have making a functionality which is known as "Preview Report". I've done it about 90%. But very very unfortunately, if using this functionality to preview the report as an excel file. We will meet a trouble at the problem that was presented on previously mail - the formulas in each excel file. Hopless and waiting your all best ideas. Thank you all so much ! -- Hieu.HISPVietnam Good Health ! Of course by coding, when you build excel document objects. I know from POI either this way or in reverse (placing formulae last) I managed it to show correct result without opening and refreshing excel file. Are you using existing template for excel or you creating from scratch? Is formulae pretyped in template or you place it programmatically? 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] Needed for support with jxl package
Hi, Can you post minimal related files (java code, excel template, call to database or so) so we could look at? regards, murod From: Hieu Dang Duy To: Murodullo Latifov Cc: bobjolli...@gmail.com; dhis2-devs@lists.launchpad.net Sent: Wednesday, June 17, 2009 11:17:56 AM Subject: Re: [Dhis2-devs] Needed for support with jxl package Hi Murodullo, Nice to see your replying ! Ooh, we are using a template excel file for reporting not from scratch. Some of template files have got the pre-typed formulas (by hands), but Some of clone files which were written the formulas in their content (coding). As presented before, we've used both of the above ways. The issue's still a trouble of us. Did you all get any breaking idea ?! On Wed, Jun 17, 2009 at 3:09 PM, Murodullo Latifov wrote: Hi, Of course by coding, when you build excel document objects. I know from POI either this way or in reverse (placing formulae last) I managed it to show correct result without opening and refreshing excel file. Are you using existing template for excel or you creating from scratch? Is formulae pretyped in template or you place it programmatically? regards, murod. -- Hieu.HISPVietnam Good Health ! ___ 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] Needed for support with jxl package
Hi, >From code as I see you are placing formula before writing values. Did you try >both options? Is ExcelUtils created by you guys? Why don't you use POI, i >think it is much easier and straightforward. 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] How to get the calculated value from an input formula string ?
in POI place formula like this: A1 + B1 . Note no need for equal = sign. murod From: Hieu Dang Duy To: dhis2-devs@lists.launchpad.net Sent: Monday, June 29, 2009 11:23:35 AM Subject: [Dhis2-devs] How to get the calculated value from an input formula string ? That's a question to resolve the problem as example below : I've got three cells as A1, B1 and C1 A1 contains value as 8 (A1 = 8) B1 contains value as 10 (B1 = 10) and: C1 = A1 + B1 So, how can i get the calculated value as 18 from input formula string "A1 + B1" byjxl or POI p.s: I could not get directly the pre-calculated value from cell C1 by jxl. Please giving me your experiences about the jxl or POI API ! -- Hieu.HISPVietnam Good Health ! ___ 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] How to get the calculated value from an input formula string ?
Hi, Have you looked at this part of sample code I sent you earlier: String celFormula1 = "C30+C31+C35+C36+C37+C38+C39+C40+C41+C42"; r = s.getRow(42); c = r.createCell((short)2); c.setCellFormula(celFormula1); This will do all, no need to refresh anything to see formula value calculated. I thought you have noticed this earlier. Yes Bob, POI and JXL are wrappers as any other XML parser or technology, but mostly simplified for excel manipulation. If you don't use these two than you have to use some parser for sure if you want to change things programatically (they all are XMLs). Why "A1+B1" or "B1+A1" are too bad? They are simplest addition mathematical formula, same way in excel and openoffice or lotus notes. If you want to read value of that formulae before it have been opened by Excel or OpenOffice, than it is not wise. You better to give another formula from the root for new column value, otherwise you will get something terrible as Bob explained. regards, murod - Original Message From: Bob Jolliffe To: Hieu Dang Duy Cc: Murodullo Latifov ; dhis2-devs@lists.launchpad.net Sent: Monday, June 29, 2009 1:09:18 PM Subject: Re: [Dhis2-devs] How to get the calculated value from an input formula string ? Hi I don't know if I have the right understanding of this, but please do remember that POI and JXL are only wrappers around the file format - they do not replace the formula engine in the spreadsheet application. So if you create a spreadsheet using your application (in combination with the JXL or POI library) which has a formula in cell C1, then the simple act of reading the cell value will not automatically calculate it for you. You would have to open the file in a spreadsheet application (excel, openoffice, gnumeric or something similar) in order to trigger the evaluation of formulae. When you save again the calculated values will be saved. Or build your own formula engine which would be a pretty big undertaking. Though I suppose A1+B1 wouldn't be too bad ... Regards Bob 2009/6/29 Hieu Dang Duy : > Oh, (so supsire) hi Murod ! > > I mean which method in which class either POI or JXL using for input formula > string ? > > Can u give an sample ? > > Thank a lot ! > > On Mon, Jun 29, 2009 at 5:26 PM, Murodullo Latifov > wrote: >> >> in POI place formula like this: A1 + B1 . Note no need for equal = sign. >> >> murod >> >> >> From: Hieu Dang Duy >> To: dhis2-devs@lists.launchpad.net >> Sent: Monday, June 29, 2009 11:23:35 AM >> Subject: [Dhis2-devs] How to get the calculated value from an input >> formula string ? >> >> >> That's a question to resolve the problem as example below : >> >> I've got three cells as A1, B1 and C1 >> >> A1 contains value as 8 (A1 = 8) >> B1 contains value as 10 (B1 = 10) >> >> and: >> >> C1 = A1 + B1 >> >> So, how can i get the calculated value as 18 from input formula string "A1 >> + B1" by jxl or POI >> >> p.s: I could not get directly the pre-calculated value from cell C1 by >> jxl. >> >> Please giving me your experiences about the jxl or POI API ! >> >> -- >> Hieu.HISPVietnam >> Good Health ! >> > > > > -- > Hieu.HISPVietnam > Good Health ! > > ___ > 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] How to get the calculated value from an input formula string ?
In POI you can do it by: String celFormula1 = "SUM( ROUND( DIV(RAND(WHATEVER) ) ) )"; String celFormula1 = "DAYS360(NOW(),C1, FALSE)"; String celFormula1 = "ANY SUPPORTED EXCEL FORMULA"; depending which version of excel document you are using. r = s.getRow(42); c = r.createCell((short)2); c.setCellFormula(celFormula1); No need to go crazy, keep things simple, that's why POI and JXL are there taking care of this issues. When you open excel you will see the result without refreshing, if you point to it not opening excel file again, it maybe problematic, similar to pointer to NULL pointer in c++. Bob, yes earlier excel format was binary, but my point is in any way you will need some tool to work with material (binary, text, xml, html), modern tools, not stone but hammer. Why I give preference to POI for reporting compared to BIRT is its lightwiegthness, no need to maintain another server application, no need to run openoffice headless. Hieu I recommend you to look at sites I earlier pointed you: http://poi.apache.org/spreadsheet/formula.html. and http://sc.openoffice.org/excelfileformat.pdf. if you want more information. murod - Original Message From: Bob Jolliffe To: Hieu Dang Duy Cc: Murodullo Latifov ; dhis2-devs@lists.launchpad.net Sent: Monday, June 29, 2009 2:26:06 PM Subject: Re: [Dhis2-devs] How to get the calculated value from an input formula string ? 2009/6/29 Hieu Dang Duy : > Oh, Nice to see both of you (Murod and Bob) again at this issue. > > [Hehe, I'm so fun] > > Thanks for your breaking idea, Bob. > I understood your opinion about this. > > "When you save again the calculated values > will be saved" - Bob said right, the calculated values which is saved after > re-open the generated excel file one more time (with a bit of modification > or we can say that is a ruse). > > Btw, It's so difficult to understand what is happened inside it (the excel > file) ... > > Another one, If have any report which just only has got the simple SUM > formula that will be not a big problem now. Don't you think about the > combination formulas as C1 = SUM( ROUND( DIV( ) ) ) ? Yes this is my point. It can be done but you wouldn't really want to. I know what you can do (if you are just a little bit crazy) is to run openoffice as a background process with no user interface. A so-called "headless" openoffice. You can then use this to process your excel formulae. But maybe it will be using more RAM than it is worth. This is the approach used by the alfresco document management system to do conversion between file formats, creating pdfs etc. Regards Bob > Thank you, thank you so much. > > On Mon, Jun 29, 2009 at 6:09 PM, Bob Jolliffe wrote: >> >> Hi >> >> I don't know if I have the right understanding of this, but please do >> remember that POI and JXL are only wrappers around the file format - >> they do not replace the formula engine in the spreadsheet application. >> So if you create a spreadsheet using your application (in combination >> with the JXL or POI library) which has a formula in cell C1, then the >> simple act of reading the cell value will not automatically calculate >> it for you. >> >> You would have to open the file in a spreadsheet application (excel, >> openoffice, gnumeric or something similar) in order to trigger the >> evaluation of formulae. When you save again the calculated values >> will be saved. Or build your own formula engine which would be a >> pretty big undertaking. Though I suppose A1+B1 wouldn't be too bad >> ... >> >> Regards >> Bob >> >> ___ >> >> From: Hieu Dang Duy >> >> To: dhis2-devs@lists.launchpad.net >> >> Sent: Monday, June 29, 2009 11:23:35 AM >> >> Subject: [Dhis2-devs] How to get the calculated value from an input >> >> formula string ? >> >> >> >> >> >> That's a question to resolve the problem as example below : >> >> >> >> I've got three cells as A1, B1 and C1 >> >> >> >> A1 contains value as 8 (A1 = 8) >> >> B1 contains value as 10 (B1 = 10) >> >> >> >> and: >> >> >> >> C1 = A1 + B1 >> >> >> >> So, how can i get the calculated value as 18 from input formula string >> >> "A1 >> >> + B1" by jxl or POI >> >> >> >> p.s: I could not get directly the pre-calculated value from cell C1 by >> >> jxl. >> >> >> >> Please giving me your experiences about the jxl or POI API ! >> >> >> >> -- >> >> Hieu.HISPVietnam >> >> Good Health ! >> >> >> > > -- > Hieu.HISPVietnam > Good Health ! > ___ 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] Fwd: How to get the calculated value from an input formula string ?
Hi Hieu, Yes, that was answer to your question. If you had chance to look here http://poi.apache.org/spreadsheet/eval.html you could get some helpful tips. When you clarified what you really want, answer was to use formula from its source, not the reference (e.g. if you had somewhere "A1+B1" placed in C3, to reuse it you have to do "sum(V1/(A1+B1))", not "sum(V1/C3)"). If its hard or impossible to do this type of formula, JAVA is there for calculating values. What I mean by JAVA is you do calculations in plain java and only place values where necessary, in this case there won't be a formula in excel but only value. regards, murod ____ From: Hieu Dang Duy To: Murodullo Latifov Cc: bobjolli...@gmail.com; dhis2-devs@lists.launchpad.net Sent: Tuesday, June 30, 2009 5:58:01 AM Subject: Fwd: [Dhis2-devs] How to get the calculated value from an input formula string ? Dear Murod and Bob, Murod, do you remember this mail ? -- Forwarded message -- From: Hieu Dang Duy Date: Mon, Jun 22, 2009 at 5:47 PM Subject: Re: [Dhis2-devs] Needed for support with jxl package To: Murodullo Latifov Cc: bobjolli...@gmail.com, dhis2-devs@lists.launchpad.net Hi Murod, After using your project to generate a random excel file from my template, "tx_bieu_2.xls". I've got a new file, for example: "Form - tx_bieu_2.xls1245381039109.xls". Your code is running very stable. By the way, I've tried to write a new java file for checking this new one's structure. And ,,, just only magic can change everything (It means using POI checking the generated excel file's structure as same as JXL ... nothing was new) You can get more reference with my attached files as below. Place the template file at the location "C:\" >From the POI or JXL Excel API technique, I think the reason why we couldn't >get the real values from the formula cells is that these values which is only >calculated by itself tool (MS Office: .xls or Open Office: .odt). I mean we >must open the generated file to see the correct answers at that time. p.s: Did you know how to get the data (value) by input as an string formula with POI ??? Thank you very much for all your ardour ! On Thu, Jun 18, 2009 at 5:19 PM, Murodullo Latifov wrote: > > > >Hi Hieu, > >See attached as sample implementation of POI. Its Eclipse java project, simply >unrar and import to Eclipse, place this template in c:\, run Runner, see new >files created in c:\. It uses your template and fills in some random data from >list of list of integers. And finally places two formula and styles it. Should >help a lot. Also number of stylings are available, some are used as example. >For the rest consult http://poi.apache.org/spreadsheet/quick-guide.html. > >regards, >murod. > -- Hieu.HISPVietnam Good Health ! I've read your code very carefully, Murod. And I assure that your coding which is running ok. The setCellFormula() method had done very well as its own duty. No matters how is here. After that, I sent to you all these two attached files: One is a java file which was written with POI. "TestExcelReportPOI.java" And the other one is an excel file which was generated by your coding "Form - tx_bieu_2.xls1245381039109.xls" In this java file, I used POI to test the structure of the excel file above. Then, the result is that I always receive all of the value as zero (0) at the each cell formulae. The same as when using JXL for testing. Did you remember about our previewing report module that I'd said before ? It had been done about 90%. And 10% is the formulae in the excel file. It's too worth. So, that why I posted this mail to ask you guys that "Which method in which class, can be used to get the re-calculated value (please attending to re-calculated value) of each formula cell by POI or JXL ?" - That's the last way which I can do with the formulae cells up-to-now. Because, if using POI or JXL to get those real values directly is impossible. Don't you ? Anything is clearly now ? Thanks for your linked pdf file. P.S: The real values that is the calculated value which can be seen when opening its self tool (OpenOffice or MS Office Excel) -- Hieu.HISPVietnam Good Health ! ___ 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] DHIS1.3 to 1.4 conversion error!
Hi, I have a task to convert DHIS1.3 databse to 1.4. Using upgrade option provided by 1.4 gives the following error and deletes any created files and exits: "The Microsoft Office Access database engine could not find the object 'survey'. Make sure the object exists and that you spelled its name and path name correctly" Any ideas? 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] struts or webwork
Hi, From: Abyot Gizaw To: dhis2-devs Sent: Tuesday, July 7, 2009 2:38:47 PM Subject: [Dhis2-devs] struts or webwork Hi All, I am almost done with the model and services and now planning to move into the presentation layer of the CHIS coding. So for which one do we settle - webwork or struts? I heard that murod is working on struts. Murod - have you committed anything? I couldn't find about struts from your branch - lp:~dhis2-devs/dhis2/d2s2ss2. Thank you. Abyot. Yes, the brunch is here https://code.launchpad.net/~dhis2-devs/dhis2/d2s2ss2 . All changes are committed. You should find three main modules for struts2 integration: dhis-support.struts2, dhis-web-commons-struts2 and dhis-web-commons-resources-struts2. All other web modules are using sturts2 now and also acegy security have been changed to spring security 2 and there are some security issues (restrictions) on menu options, working on it. 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] struts or webwork
Hi Lars, >Hi All, > >I am almost done with the model and services and now planning to move into the >presentation layer of the CHIS coding. So for which one do we settle - webwork >or struts? I heard that murod is working on struts. Murod - have you committed >anything? I couldn't find about struts from your branch - >lp:~dhis2-devs/dhis2/d2s2ss2. > OK. But it seems there will be some time before this is merged into trunk. Abyot I think the best would be to just go ahead using the existing webwork stuff, the migration to struts is quite easy and Murod can help you later. If you are making interceptors, keep extending Interceptor and not AroundInterceptor. Lars Abyot is right, all my commits are stored somehow locally, not sent to launchpad repo. I am working on it to commit to launchpad soon. What is there is not updated at all from initial branch creation. 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] struts or webwork
Hi, From: Abyot Gizaw To: dhis2-devs Sent: Tuesday, July 7, 2009 2:38:47 PM Subject: [Dhis2-devs] struts or webwork Hi All, I am almost done with the model and services and now planning to move into the presentation layer of the CHIS coding. So for which one do we settle - webwork or struts? I heard that murod is working on struts. Murod - have you committed anything? I couldn't find about struts from your branch - lp:~dhis2-devs/dhis2/d2s2ss2. Thank you. Abyot. I "push"ed my code and it is on launchpad branch d2s2ss2 now. Please check and comment. 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] Fwd: JXL with POI
Hi Hieu, Look at "Busy developer 's guide" here http://poi.apache.org/spreadsheet/quick-guide.html#NewWorkbook. Using inheritance or abstract classes/interface I would say is the right way instead of utility class. Why? Because every time you create an excel file, modify and save it, thus follow OO way. regards, murod From: Hieu Dang Duy To: Murodullo Latifov ; Dhis2 Sent: Friday, July 17, 2009 8:16:56 PM Subject: Fwd: JXL with POI Dear Murod, It is joyful when received your reply mail. So behind in this mail, I've got some wonders to worry to ask you: How can we do if none of using a template instead-of a scratch file ? By the way, I shall focus on your suggestion about the inheritance. It's really helpful for me to get a next important step to working on POI. But, I'm still misunderstanding or can say that it's a vague thing of mine about this. Why should be have done as an Interface or Abstract class ? Is that right your meaning ? Why not as a utilizable class file which I sent to you before ? Thank you ! p.s: Also forward to the mailing list. -- Forwarded message -- From: Murodullo Latifov Date: Fri, Jul 17, 2009 at 3:35 PM Subject: Re: JXL with POI To: Hieu Dang Duy Hi Hieu, Good to hear you managed to solve your problems. You can place or remove format stuff as you wish. The idea behind having formats is to have ability to create excel from scratch, that means not having any template, creating new excel file, adding formats, sizing you columns, etc. Main point is to unify most and frequent used methods in a separate file and inherit from it and not to type it all the time, which is general in object oriented programming. I suggest you to have a java class with all formats and common methods, like your writeValue() and create other specific implementations inheriting from it, this way you will have clear code, and overwrite when needed. It would be good if you use mailing list, so others may sometimes use solution, and find out how did it work. Good luck, murod ____ From: Hieu Dang Duy To: Murodullo Latifov Sent: Wednesday, July 15, 2009 3:05:30 PM Subject: JXL with POI Dear Murod, Finally, I've solved the issue of recalculating value by POI's Formula Evaluation (JXL combines with POI - so excited) So, really thanks to your help ! Until now, a quite small problem is that I wanna replace the way of writing on Excel file from JXL to POI. But I'm not good at POI technique. So, can I ask you some questions such as: What should I have done if using POI to replace JXL to write on excel file, for example: - Any important formats (Font, Number, String, Formula, etc...) ? - Any main points which must be pay attention to ? In your project POI that you sent to me. I see that you'd declared so many formats : HSSFFont csf = hssfworkbook.createFont(); HSSFFont csfBold = hssfworkbook.createFont(); HSSFDataFormat df = hssfworkbook.createDataFormat(); HSSFCellStyle cs = hssfworkbook.createCellStyle(); HSSFCellStyle csHeader = hssfworkbook.createCellStyle(); HSSFCellStyle csSize = hssfworkbook.createCellStyle(); HSSFCellStyle csCurrency = hssfworkbook.createCellStyle(); HSSFCellStyle csSizeBold = hssfworkbook.createCellStyle(); HSSFCellStyle csCurrencyBold = hssfworkbook.createCellStyle(); HSSFCellStyle csPercentage = hssfworkbook.createCellStyle(); HSSFCellStyle csNormal = hssfworkbook.createCellStyle(); HSSFCellStyle csNormalOdd = hssfworkbook.createCellStyle(); HSSFCellStyle csCurrencyOdd = hssfworkbook.createCellStyle(); HSSFCellStyle csPercentageOdd = hssfworkbook.createCellStyle(); HSSFCellStyle csSizeOdd = hssfworkbook.createCellStyle(); HSSFCellStyle csCountOdd = hssfworkbook.createCellStyle(); HSSFCellStyle csCount = hssfworkbook.createCellStyle(); If I leave these formats above in my source code so what will be happened ? I shall send to you a file "ExcelUtil.java". Can you take a look at this one. And please give me some of suggestions. THANK SO MUCH ! -- Hieu.HISPVietnam Good Health ! -- Hieu.HISPVietnam Good Health ! ___ 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] DHIS OpenMRS integration
Hi people, I have initiated creation of DHIS - OpenHealth data exchange module. The initial idea is to submit to OpenMRS DHIS metadat, OpenMRS will store these data into a table, there would be facility in OpenMRS module to map DHIS data into OpenMRS data and produce export data for DHIS in XML format. The entire module will be build for OpenMRS. Currently I have selected the following to be needed by OpenMRS to provide accurate data: data element id category combo id period type aggregation type Any aditions suggestions are welcome. We have Paul from OpenMRS team here and he is eager to work on this approach. Also I am planning to build some DHIS modules for Joomla CMS. Joomla is very popular open source content management system, used in many sites. Having these modules any site running on Joomla could easily fetch data from DHIS. This is very early ideas. Now we need to deside on what level to connect Joomla modules and DHIS: data base or web services (REST)? 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] Error Message Help
hi Paul, I don't know if I can help you much,but two quck possible reasons: You hibernate.properties is not set up properly, but maign be not, as you are getting this error. Second and most possible reason is that some tables in your database does not have privileges for your user name in hibernate.properties. Make sure that all tables are being assigned to your username you used in hibernate.properties. Hope this will help, otherwise lety us know. Regards, murod P.S. I am in a location with limited internet and may reply late, sorry for this. From: Paul Amendola To: Bob Jolliffe ; Murodullo Latifov Cc: Jørn Braa ; DHIS 2 developers Sent: Wednesday, July 29, 2009 5:37:25 PM Subject: Error Message Help Error Message Help In an offline instance, I keep getting this error message when trying to create a new org or period chart An exception occurred Sorry! The system failed to execute the operation. Usually, no data is lost and you can continue working by going back to the previous page. If you wish to report the incident, please save this page by choosing "File -> Save (page as)" in your browser and include the saved page in the report. The problem details are listed below. [+] Exception (org.hibernate.InstantiationException): Cannot instantiate abstract class or interface: org.hisp.dhis.source.Source Thanks Paul ___ 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 OpenMRS integration
Hi, - Original Message From: Jo Størset To: DHIS 2 developers Sent: Friday, July 31, 2009 3:30:41 PM Subject: Re: [Dhis2-devs] DHIS OpenMRS integration Hi, Den 28. juli. 2009 kl. 14.51 skrev Saptarshi Purkayastha: > But mayb like Bob said, 2morrow's discussions may give some clearer idea!! How did the discussions go? Personally I cannot contribute much yet, but in a months time hopefully I will have some more time on my hands. It would be nice to try to keep the work in the open, so I, for one, can try to keep up-to-date. Jo Discussion was mainly around IXF/DXF standards for representing data, which I ignored on my initial implementation, and likely will do so for now. I am concentrated to make systems talk, after we can think of standards. This was agreement with OpenMRS people, who insisted on standards, but after long debates I made them agree to go my way. I am actually using XML for data exchange, which is standard in a sense. Will come back to discussions while progress is made. 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 OpenMRS integration
Hi Knut, I agree, only if SDMX-HD is more than just another Java Parser for XML. I am looking for code list for data elements defined in SDMX-HD. If this is place we could map DHIS data elements into it easily and be within standard definitions. Validating content under some standard is an issue, not parsing XML file for being well formed. So far I managed to get sample SDMX, which has few lines of codes only. Again, if this in place I am ready to go SDMX-HD. regards, murod From: Knut Staring To: Murodullo Latifov Cc: Jo Størset ; DHIS 2 developers Sent: Saturday, August 1, 2009 1:48:35 PM Subject: Re: [Dhis2-devs] DHIS OpenMRS integration On Sat, Aug 1, 2009 at 7:10 AM, Murodullo Latifov wrote: >>Hi, > > > > >>- Original Message >>From: Jo Størset >>To: DHIS 2 developers >>Sent: Friday, July 31, 2009 3:30:41 PM >>Subject: Re: [Dhis2-devs] DHIS OpenMRS integration > >>Hi, > >>Den 28. juli. 2009 kl. 14.51 skrev Saptarshi Purkayastha: > >>> But mayb like Bob said, 2morrow's discussions may give some clearer idea!! > >>How did the discussions go? > >>Personally I cannot contribute much yet, but in a months time hopefully I >>will have some more time on my hands. It would be nice to try to keep the >>work in the open, so I, for one, can try to keep up-to-date. > >>Jo > >Discussion was mainly around IXF/DXF standards for representing data, which I >ignored on my initial implementation, and likely will do so for now. I am >concentrated to make systems talk, after we can think of standards. This was >agreement with OpenMRS people, who insisted on standards, but after long >debates I made them agree to go my way. I am actually using XML for data >exchange, which is standard in a sense. Will come back to discussions while >progress is made. > Of course, using a standard (beyond just XML) for data exchange enables exchange data with many systems, not just two. See the message below on SDMX-HD -- Forwarded message -- From: Carl Fourie Date: Wed, Jul 22, 2009 at 3:25 PM Subject: Re: SDMX-HD Connectathon To: sdmx...@googlegroups.com Hi Patrick, This looks really great! Will definitely investigate the opportunity to attend. We have been working on a SDMX-HD parser for a particular project (OpenMRS and TracNET integration). Ryan Crichton has developed the beginnings (and first through) parser which is able to read an SDMX-HD message identify the indicators and dimensions as well as write to it and persist to file. We are developing this code in an effort to create a Java Library for SDMX-HD much like HL7 has the HAPI library. I have included the following links detailing more about our work (aiming to present a beta version at OpenMRS meeting in September) * http://wiki.jembi.org/index.php/TRACnet_Integration * http://openmrs.org/wiki/OpenMRS_TRACNet_integrationAnyone interested in talking more about this please feel free to mail me c...@jembi.org or start a new thread (as not to steal this one) Regards, Carl Fourie Jembi.org Whitaker, Patrick wrote: Dear all, >We are planning a 'Connectathon' for the SDMX-HD for November. We hope that >you can come. See additional details below and on the Google Group: >http://groups.google.com/group/sdmx_hd?lnk=iggc >Best regards, >Patrick > ><> >Patrick Whitaker >Technical Officer >Health Care Informatics Unit >Health Statistics and Informatics Department >World Health Organization >Tel. direct: +41 22 791 1372 >E-mail: whitak...@who.int > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "SDMX-HD (Health Domain)" group. To post to this group, send email to sdmx...@googlegroups.com To unsubscribe from this group, send email to sdmx_hd+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sdmx_hd?hl=en -~--~~~~--~~--~--~--- -- Cheers, Knut Staring >>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 > -- 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] DHIS OpenMRS integration
Hi, >Discussion was mainly around IXF/DXF standards for representing data, which I >ignored on my initial implementation, and likely will do so for now. I am >concentrated to make systems talk, after we can think of standards. This was >agreement with OpenMRS people, who insisted on standards, but after long >debates I made them agree to go my way. I am actually using XML for data >exchange, which is standard in a sense. Will come back to discussions while >progress is made. This was not really my impression. There was a breakout discussion of me, Ola, Murod and Paul (from OpenMRS). Maybe there were long debates afterwards which I missed. Anyway the prevailing view was that before we look at a new ad hoc way of doing things we need to be sure that there is not an existing standard way which is adequate. There was nobody who thought creating a new xml representation just for this openmrs-dhis integration is a good idea. Unfortunately Ola and I also had not seen Murod's work in advance so it was difficult to present a comon dhis view. Murod can you share more of what you have done to the wider group? Main issue was and is to map DHIS data to OMRS data. None of listed standards currently provide it. There should be a medium to dictate standard and uniform keys, names, and other attributes for both systems, from all available standards only SDMX-HD has some sample data and is good candidate to provide such service. Parsing is not an issue, validity of content is. That is where systems talk. This standardization is multy step and long process. omrs should follow ICD10 and dhis - SDMX-HD, there should be mapping between SDMX-HD and ICD10. This is my view of standards and might not be correct. Project I created is intended to link two systems in closest possible way, not to build standards or discuss standards. Taking this into account the rest of messages from this line onward are void. When there is proper standard and implementation instructions we can easily shift. In terms of discussion, the following options were considered regrading data format: 1. SDMX_HD - Paul had not been aware of the deficiencies which I had pointed out. He was also at pains to insist that OpenMRS was not committed to this format yet, but like us, felt that it is better to align with a WHO effort if is feasible. If its not, he's happy not to go that way. I asked him to get a second opinion on some of the concerns I had raised from the OpenMRS team. 2. IXF - Paul said that IXFv2 did not have the problem which SDMX has - that is that new codes and codelists translate to new attributes in the data exchange schema. Given that we have both already implemented IXF parsers this might still be the basis of future interoperability. Ola mentioned that Lars had implemented IXF parser in DHIS but that he cursed it often :-) Lars you would know best whether this is a good idea or not. 3. DXF - we didn't discuss much. A pity, but time was short. This, or an enhanced version, will be a fallback if 1 and 2 above are not workable. 4. Merger of 2 and 3 - this was quite an interesting thought. One of the problems with SDMX HD is that it is based on an ISO standard. Meaning that there is only a certain amount of scope to change things for the health domain - much of the rest is fixed by the ISO parent SDMX. IXF on the other hand can be taken and fixed, developed and improved by its stakeholders. It might be possible to take DXF and new ideas which have been suggested for DXF2 including elements of Murod's schema for example and develop these as IXFv4. Paul felt we need to create some sort of grid showing the pros and cons of these approaches and discuss on that basis. There was some possibility of making this interoperability problem a topic of the September OpenMRS implementors meeting in Cape Town. Of course all of the above is only formats - there is more to it than that. Murod did identify the minimum information set that would need to form part of an exchange to get data from OpenMRS into DHIS. That is useful. And the idea of writing an OpenMRS module to do the job - rather than waiting for OpenMRS folk to do it - makes standards less critical, but an expensive way to consider interop in general. Though Paul had some suggestions around how the OpenMRS inference engine should be used which was a bit beyond "beginner" OpenMRS. And Saptarshi had some thoughts around using the OpenMRS cohort builder to assist with aggregation which I didn't fully understand, but it sounded convincing :-). We are all agreed that aggregation happens on the OpenMRS side. Its a pity we didn't get much to web services and REST. I guess we used Murod's work as the catalyst for discussion and ended up having lengthy debates on standard vs ad hoc xml instead. Regards Bob > >>murod > > > > > >>___ >>Mailing list: https://launchpa
Re: [Dhis2-devs] DHIS OpenMRS integration
Hi Bob, Here is my XML file. I have ids on it, and its problematic as ids differ from implementation to implementation. regards, murod From: Bob Jolliffe To: Murodullo Latifov Cc: Jo Størset ; DHIS 2 developers Sent: Tuesday, August 4, 2009 5:31:29 PM Subject: Re: [Dhis2-devs] DHIS OpenMRS integration Hi Murod Do you have an example of the XML you are using? I want to see how far it might be from the DXF we are already using, should it be incorporated or what ... I remember seeing a small snippet but would be good to share a file or two. Regards Bob 2009/8/3 Murodullo Latifov Hi, > > > > >>Discussion was mainly around IXF/DXF standards for representing data, which I >>ignored on my initial implementation, and likely will do so for now. I am >>concentrated to make systems talk, after we can think of standards. This was >>agreement with OpenMRS people, who insisted on standards, but after long >>debates I made them agree to go my way. I am actually using XML for data >>exchange, which is standard in a sense. Will come back to discussions while >>progress is made. > >This was not really my impression. There was a breakout discussion of me, >Ola, Murod and Paul (from OpenMRS). Maybe there were long debates afterwards >which I missed. Anyway the prevailing view was that before we look at a new >ad hoc way of doing things we need to be sure that there is not an existing >standard way which is adequate. There was nobody who thought creating a new >xml representation just for this openmrs-dhis integration is a good idea. >Unfortunately Ola and I also had not seen Murod's work in advance so it was >difficult to present a comon dhis view. Murod can you share more of what you >have done to the wider group? > >Main issue was and is to map DHIS data to OMRS data. None of listed standards >currently provide it. There should be a medium to dictate standard and uniform >keys, names, and other attributes for both systems, from all available >standards only SDMX-HD has some sample data and is good candidate to provide >such service. Parsing is not an issue, validity of content is. That is where >systems talk. This standardization is multy step and long process. omrs should >follow ICD10 and dhis - SDMX-HD, there should be mapping between SDMX-HD and >ICD10. This is my view of standards and might not be correct. Project I >created is intended to link two systems in closest possible way, not to build >standards or discuss standards. Taking this into account the rest of messages >from this line onward are void. When there is proper standard and >implementation instructions we can easily shift. > > >In terms of discussion, the following options were considered regrading > data format: > >1. SDMX_HD - Paul had not been aware of the deficiencies which I had pointed >out. He was also at pains to insist that OpenMRS was not committed to this >format yet, but like us, felt that it is better to align with a WHO effort if >is feasible. If its not, he's happy not to go that way. I asked him to get a >second opinion on some of the concerns I had raised from the OpenMRS team. > >2. IXF - Paul said that IXFv2 did not have the problem which SDMX has - that >is that new codes and codelists translate to new attributes in the data >exchange schema. Given that we have both already implemented IXF parsers this >might still be the basis of future interoperability. Ola mentioned that Lars >had implemented IXF parser in DHIS but that he cursed it often :-) Lars you >would know best whether this is a good idea or not. > >3. DXF - we didn't discuss much. A pity, but time was short. This, or an >enhanced version, will be a fallback if 1 and 2 above are not workable. > >4. Merger of 2 and 3 - this was quite an interesting thought. One of the >problems with SDMX HD is that it is based on an ISO standard. Meaning that >there is only a certain amount of scope to change things for the health domain >- much of the rest is fixed by the ISO parent SDMX. IXF on the other hand can >be taken and fixed, developed and improved by its stakeholders. It might be >possible to take DXF and new ideas which have been suggested for DXF2 >including elements of Murod's schema for example and develop these as IXFv4. > >Paul felt we need to create some sort of grid showing the pros and cons of >these approaches and discuss on that basis. There was some possibility of >making this interoperability problem a topic of the September OpenMRS >implementors meeting in Cape Town. > >Of course all of the above is only formats - there is more to it than that. >Murod did identify the minimum information set that w
Re: [Dhis2-devs] DHIS OpenMRS integration
Hi Bob, Output of module would be what we are using for import into DHIS now, so no need to create it in DHIS again. Yes, it would be same ids coming back with value assigned. Changing XML to look like IXF/DXF or SDMX-HD is not a big issue, we can do it in many levels before output. regards, murod From: Bob Jolliffe To: Murodullo Latifov Cc: Jo Størset ; DHIS 2 developers Sent: Tuesday, August 4, 2009 6:40:11 PM Subject: Re: [Dhis2-devs] DHIS OpenMRS integration Thanks. It is very similar to existing dxf (which has the same problematic use of IDs). What about the data going the other way? Is it also like DXF? Regards Bob 2009/8/4 Murodullo Latifov Hi Bob, > >Here is my XML file. I have ids on it, and its problematic as ids differ from >implementation to implementation. > >regards, >murod > > > > From: Bob Jolliffe >To: Murodullo Latifov >Cc: Jo Størset ; DHIS 2 developers > >Sent: Tuesday, August 4, 2009 > 5:31:29 PM > >Subject: Re: [Dhis2-devs] DHIS OpenMRS integration > > >>Hi Murod > >Do you have an example of the XML you are using? I want to see how far it >might be from the DXF we are already using, should it be incorporated or what >... I remember seeing a small snippet but would be good to share a file or two. > >Regards >Bob > > >2009/8/3 Murodullo Latifov > >Hi, >> >> >> >> >>>Discussion was mainly around IXF/DXF standards for representing data, which >>>I ignored on my initial implementation, and likely will do so for now. I am >>>concentrated to make systems talk, after we can think of standards. This was >>>agreement with OpenMRS people, who insisted on standards, but after long >>>debates I made them agree to go my way. I am actually using XML for data >>>exchange, which is standard in a sense. Will come back to discussions while >>>progress is made. >> >>This was not really my impression. There was a breakout discussion of me, >>Ola, Murod and Paul (from OpenMRS). Maybe there were long debates afterwards >>which I missed. Anyway the prevailing view was that before we look at a new >>ad hoc way of doing things we need to be sure that there is not an existing >>standard way which is adequate. There was nobody who thought creating a new >>xml representation just for this openmrs-dhis integration is a good idea. >>Unfortunately Ola and I also had not seen Murod's work in advance so it was >>difficult to present a comon dhis view. Murod can you share more of what you >>have done to the wider group? >> >>Main issue was and is to map DHIS data to OMRS data. None of listed standards >>currently provide it. There should be a medium to dictate standard and >>uniform keys, names, and other attributes for both systems, from all >>available standards only SDMX-HD has some sample data and is good candidate >>to provide such service. Parsing is not an issue, validity of content is. >>That is where systems talk. This standardization is multy step and long >>process. omrs should follow ICD10 and dhis - SDMX-HD, there should be mapping >>between SDMX-HD and ICD10. This is my view of standards and might not be >>correct. Project I created is intended to link two systems in closest >>possible way, not to build standards or discuss standards. Taking this into >>account the rest of messages from this line onward are void. When there is >>proper standard and implementation instructions we can easily shift. >> >> >>In terms of discussion, the following options were considered regrading >> data format: >> >>1. SDMX_HD - Paul had not been aware of the deficiencies which I had pointed >>out. He was also at pains to insist that OpenMRS was not committed to this >>format yet, but like us, felt that it is better to align with a WHO effort if >>is feasible. If its not, he's happy not to go that way. I asked him to get >>a second opinion on some of the concerns I had raised from the OpenMRS team. >> >>2. IXF - Paul said that IXFv2 did not have the problem which SDMX has - that >>is that new codes and codelists translate to new attributes in the data >>exchange schema. Given that we have both already implemented IXF parsers >>this might still be the basis of future interoperability. Ola mentioned that >>Lars had implemented IXF parser in DHIS but that he cursed it often :-) Lars >>you would know best whether this is a good idea or not. >> >>3. DXF - we didn't discuss much. A pity, but time was short. This, or an >>enhanc
Re: [Dhis2-devs] DHIS OpenMRS integration
Hi Than, Thanks, this is what I wanted to discuss with OpemMRS, not IXF/DXF a la standards. But the way I am doing is quite different. OpenMRS has Cohort builder, using it we can create aggregated values. But it is not what we want, we need to change behaviour of Cohort Builder to match DHIS periods, and finally map these values to DHIS analog - data elements. This way we reuse existing code and functionality. Comments are welcome. regards, murod From: Ngoc Thanh Nguyen To: Murodullo Latifov Cc: Bob Jolliffe ; DHIS 2 developers ; Sundeep Sahay ; Jørn Braa Sent: Wednesday, August 5, 2009 10:10:20 AM Subject: Re: [Dhis2-devs] DHIS OpenMRS integration Hi all, I have been following all the discussions. The key issue is how to make OpenMRS and DHIS2 talk to each other. This is not about what standards should be used but THE DESIGN of AN interpreter (translator). I think we could discuss on how to design this mapping. The key element in DHIS2 is the Dataelement and Value (often a number). In OpenMRS, Concept is something similar to Dataelement. The answer for concept (Value) is other concept. The Period in DHIS2 shares similarity with Encounter date time. The Orgunit in DHIS2 is similar with Patient and location in OpenMRS. Here are some examples of mapping: 1. Simple mapping with only encounter In OpenMRS, for outpatient department, every day many patients come to a clinic (hospital) to have check up. This check up event will be stored as an encounter with date, time. For DHIS2, one of the data element could be: "Number of patients come to the clinic this month?" So how to map? "select count(*) from encounter where encounter.date between FirstDateOfThisMonth and LastDateOfThisMonth" 2. Mapping with Observation and concept Ok, after the patient is registered, he come to see doctor in a check up room. The doctor will give diagnosis saying that he is infected by tuberculosis or malaria or any kinds of disease. In OpenMRS, the diagnosis is stored as an observation with the Concept name is Diagnosis. The answer for this concept is also a list of concepts (ICD 10). For DHIS2, many data element could be come from this scenario: - How many [TB] patient in a month? - How many [Malaria] patient in a month? - Up to some hundreds of data elements. . So how to map? "select count(*) from obs where answer_concept is [TB] and date between FirstDateOfThisMonth and LastDateOfThisMonth" 3. Break out by [sex] and [age]: The query is the same but with a little modification "select count(*) from encounter where encounter.date between FirstDateOfThisMonth and LastDateOfThisMonth" --> "select count(*) from encounter inner join patient on encounter.patientid = patient.id where encounter.date between FirstDateOfThisMonth and LastDateOfThisMonth AND patient.age between [startage] and [endage] and patient.sex = [sex] 4. Other queries: Statistical reports require more than just clinical data. This requirements range from human resources, number of medical lab machines, financial management etc. And if there are no such things in OpenMRS, DHIS2 must pull data from other sources. Regards, Thanh On Mon, Aug 3, 2009 at 8:02 PM, Murodullo Latifov wrote: Hi, > > > > >>Discussion was mainly around IXF/DXF standards for representing data, which I >>ignored on my initial implementation, and likely will do so for now. I am >>concentrated to make systems talk, after we can think of standards. This was >>agreement with OpenMRS people, who insisted on standards, but after long >>debates I made them agree to go my way. I am actually using XML for data >>exchange, which is standard in a sense. Will come back to discussions while >>progress is made. > >This was not really my impression. There was a breakout discussion of me, >Ola, Murod and Paul (from OpenMRS). Maybe there were long debates afterwards >which I missed. Anyway the prevailing view was that before we look at a new >ad hoc way of doing things we need to be sure that there is not an existing >standard way which is adequate. There was nobody who thought creating a new >xml representation just for this openmrs-dhis integration is a good idea. >Unfortunately Ola and I also had not seen Murod's work in advance so it was >difficult to present a comon dhis view. Murod can you share more of what you >have done to the wider group? > >Main issue was and is to map DHIS data to OMRS data. None of listed standards >currently provide it. There should be a medium to dictate standard and uniform >keys, names, and other attributes for both systems, from all available >standards only SDMX-HD has some sample data and is good candidate to provide >such service. Parsing is not an issue, validity of content is. That is where >
Re: [Dhis2-devs] DHIS OpenMRS integration
Thanks Bob, I know this, so what it adds to new module? Does it do what it is supposed to do?If it does, what it does? From: Bob Jolliffe To: Murodullo Latifov Cc: Jo Størset ; DHIS 2 developers Sent: Tuesday, August 4, 2009 10:04:10 PM Subject: Re: [Dhis2-devs] DHIS OpenMRS integration 2009/8/4 Murodullo Latifov Hi Bob, > >Output of module would be what we are using for import into DHIS now, so no >need to create it in DHIS again. This is what is being called DXF. Cheers Bob Yes, it would be same ids coming back with value assigned. Changing XML to look like IXF/DXF or SDMX-HD is not a big issue, we can do it in many levels before output. > > >regards, >murod > > > From: Bob Jolliffe >To: Murodullo Latifov >Cc: Jo Størset > ; DHIS 2 developers >Sent: Tuesday, August 4, 2009 6:40:11 PM > >Subject: Re: [Dhis2-devs] DHIS OpenMRS integration > > >>Thanks. It is very similar to existing dxf (which has the same problematic >>use of IDs). What about the data going the other way? Is it also like DXF? > >Regards >Bob > > >2009/8/4 Murodullo Latifov > >>>Hi Bob, >> >>Here is my XML file. I have ids on it, and its problematic as ids differ from >>implementation to implementation. >> >>regards, >>murod >> >> >> >> From: Bob Jolliffe >>To: Murodullo Latifov >>Cc: Jo Størset ; DHIS 2 developers >> >>Sent: Tuesday, August 4, 2009 >> 5:31:29 PM >> >>Subject: Re: [Dhis2-devs] DHIS OpenMRS integration >> >> >>>>Hi Murod >> >>Do you have an example of the XML you are using? I want to see how far it >>might be from the DXF we are already using, should it be incorporated or what >>... I remember seeing a small snippet but would be good to share a file or >>two. >> >>Regards >>Bob >> >> >>2009/8/3 Murodullo Latifov >> >>Hi, >>> >>> >>> >>> >>>>Discussion was mainly around IXF/DXF standards for representing data, which >>>>I ignored on my initial implementation, and likely will do so for now. I am >>>>concentrated to make systems talk, after we can think of standards. This >>>>was agreement with OpenMRS people, who insisted on standards, but after >>>>long debates I made them agree to go my way. I am actually using XML for >>>>data exchange, which is standard in a sense. Will come back to discussions >>>>while progress is made. >>> >>>This was not really my impression. There was a breakout discussion of me, >>>Ola, Murod and Paul (from OpenMRS). Maybe there were long debates >>>afterwards which I missed. Anyway the prevailing view was that before we >>>look at a new ad hoc way of doing things we need to be sure that there is >>>not an existing standard way which is adequate. There was nobody who >>>thought creating a new xml representation just for this openmrs-dhis >>>integration is a good idea. Unfortunately Ola and I also had not seen >>>Murod's work in advance so it was difficult to present a comon dhis view. >>>Murod can you share more of what you have done to the wider group? >>> >>>Main issue was and is to map DHIS data to OMRS data. None of listed >>>standards currently provide it. There should be a medium to dictate standard >>>and uniform keys, names, and other attributes for both systems, from all >>>available standards only SDMX-HD has some sample data and is good candidate >>>to provide such service. Parsing is not an issue, validity of content is. >>>That is where systems talk. This standardization is multy step and long >>>process. omrs should follow ICD10 and dhis - SDMX-HD, there should be >>>mapping between SDMX-HD and ICD10. This is my view of standards and might >>>not be correct. Project I created is intended to link two systems in closest >>>possible way, not to build standards or discuss standards. Taking this into >>>account the rest of messages from this line onward are void. When there is >>>proper standard and implementation instructions we can easily shift. >>> >>> >>>In terms of discussion, the following options were considered regrading >>> data format: >>> >>>1. SDMX_HD - Paul had not been aware of the deficiencies which I had pointed >>>out. He was also at pains to insist that OpenMRS was not committed to this >>>format yet,
[Dhis2-devs] DHIS2 - Struts2 - Spring Security2
Hi people, This is to announce alpha release of DHIS2 + Struts2 (s2) + Spring Security2 (ss2) integration. As s2 and ss2 are major and system wide change, they need intensive testing. Code is available at URL: https://code.launchpad.net/~dhis2-devs/dhis2/d2s2ss2 . S2 is most resent upgrade for webwork and ss2 is for acegy security, especially ss2 is used as is, without customization, each URL can have its own security credentials. From this standpoint we are free to define ROLES and set of roles (most common use cases into one role). All security concerns are now in one single XML file and easy to understand and exists independent of other frameworks in DHIS2. We can also use method level security, if method namings are appropriate using AOP. Please share your experiences, type of user roles you have, so we can adjust system to host that functionality. 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] DHIS2 - Struts2 - Spring Security2
Hi Knut, Good point. There is no automatic assignment in security, one must be authenticated before accessing resources, but if you mean by assigning top org unit hierarchy to give access to subs, its possible (not implemented). Current implementation gives lots of possibilities to do that easily. Add blueprint please, nice comment. murod From: Knut Staring To: Murodullo Latifov Cc: DHIS 2 developers ; Sundeep Sahay ; Jørn Braa Sent: Friday, August 14, 2009 2:28:00 PM Subject: Re: [Dhis2-devs] DHIS2 - Struts2 - Spring Security2 Delighted to see progress on this. One thing that I've encountered (and which should become a blueprint), is that you would like to automatically generate users who only have access to subtrees (at a certain level). The concrete example is that you have all the countries in the world (grouped into regions), and would like to have a user for each country who should not have access to data for any other contry. With 200 countries, you don't want to do this manually... Knut On Fri, Aug 14, 2009 at 10:51 AM, Murodullo Latifov wrote: Hi people, > >>This is to announce alpha release of DHIS2 + Struts2 (s2) + Spring Security2 >>(ss2) integration. As s2 and ss2 are major and system wide change, they need >>intensive testing. Code is available at URL: >>https://code.launchpad.net/~dhis2-devs/dhis2/d2s2ss2 . S2 is most resent >>upgrade for webwork and ss2 is for acegy security, especially ss2 is used as >>is, without customization, each URL can have its own security credentials. >>From this standpoint we are free to define ROLES and set of roles (most >>common use cases into one role). All security concerns are now in one single >>XML file and easy to understand and exists independent of other frameworks in >>DHIS2. We can also use method level security, if method namings are >>appropriate using AOP. Please share your experiences, type of user roles you >>have, so we can adjust system to host that functionality. > >>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 > -- 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] DHIS2 - Struts2 - Spring Security2
Hi Bob, Don't agree, I don't think LDAP gives something special, though it is there, we can activate it. Its useful when lazy guy does not want to login again, because he already logged into his windows machine and mostly have no time for this. In this case he can tick "remember me" once, actually new functionality on security, and every next time from that machine he will be authenticated automatically. murod From: Bob Jolliffe To: Knut Staring Cc: Murodullo Latifov ; Sundeep Sahay ; Jørn Braa ; DHIS 2 developers Sent: Friday, August 14, 2009 2:36:53 PM Subject: Re: [Dhis2-devs] DHIS2 - Struts2 - Spring Security2 2009/8/14 Knut Staring >Delighted to see progress on this. > > >One thing that I've encountered (and which should become a blueprint), is that >you would like to automatically generate users who only have access to >subtrees (at a certain level). > > >The concrete example is that you have all the countries in the world (grouped >into regions), and would like to have a user for each country who should not >have access to data for any other contry. With 200 countries, you don't want >to do this manually... I think if you have 200 users it is maybe a good use case for using something like ldap to manage them. For example you guys at WHO are probably all already maintained in an ActiveDirectory server for login to the network etc. Would be nice to be able to use the same usernames and passwords in dhis. I gather with the spring security 2 this would be quite easy to do. Good to see progress on this. Cheers Bob > >Knut > > >On Fri, Aug 14, 2009 at 10:51 AM, Murodullo Latifov >wrote: > >Hi people, >> >>>>This is to announce alpha release of DHIS2 + Struts2 (s2) + Spring >>>>Security2 (ss2) integration. As s2 and ss2 are major and system wide >>>>change, they need intensive testing. Code is available at URL: >>>>https://code.launchpad.net/~dhis2-devs/dhis2/d2s2ss2 . S2 is most resent >>>>upgrade for webwork and ss2 is for acegy security, especially ss2 is used >>>>as is, without customization, each URL can have its own security >>>>credentials. From this standpoint we are free to define ROLES and set of >>>>roles (most common use cases into one role). All security concerns are now >>>>in one single XML file and easy to understand and exists independent of >>>>other frameworks in DHIS2. We can also use method level security, if method >>>>namings are appropriate using AOP. Please share your experiences, type of >>>>user roles you have, so we can adjust system to host that functionality. >> >>>>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 >> > > >-- >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] DHIS2 - Struts2 - Spring Security2
Hi Jo, The call is to tell us what kind of users you want to see and what access levels they have. For ordinary user to have access to change its password itself, you have to assign him role ROLE_dhis-web-maintenance-user, but its initial set, we are calling for more options ans intensive tests. You can assign user role as before through user settings menu option. Sorry links are not i18nized for now. murod - Original Message From: Jo Størset To: Murodullo Latifov Cc: Bob Jolliffe ; Knut Staring ; Sundeep Sahay ; Jørn Braa ; DHIS 2 developers Sent: Friday, August 14, 2009 3:27:06 PM Subject: Re: [Dhis2-devs] DHIS2 - Struts2 - Spring Security2 Sorry for top-posting, in the middle of a research proposal here :) If we have concrete plans for this kind of user scale, I definately think we should evaluate the user/authn/authz architecture in more detail. I'm not immediately convinced there are quick wins to be gained here, without having a really relaxed security scheme (And then, what's the value?). A quick question; how would we know the correct user group get a hold of their username and password? Jo Den 14. aug.. 2009 kl. 11.25 skrev Murodullo Latifov: > Hi Bob, > > Don't agree, I don't think LDAP gives something special, though it is there, > we can activate it. Its useful when lazy guy does not want to login again, > because he already logged into his windows machine and mostly have no time > for this. In this case he can tick "remember me" once, actually new > functionality on security, and every next time from that machine he will be > authenticated automatically. > > murod > > From: Bob Jolliffe > To: Knut Staring > Cc: Murodullo Latifov ; Sundeep Sahay > ; Jørn Braa ; DHIS 2 developers > > Sent: Friday, August 14, 2009 2:36:53 PM > Subject: Re: [Dhis2-devs] DHIS2 - Struts2 - Spring Security2 > > 2009/8/14 Knut Staring > Delighted to see progress on this. > > One thing that I've encountered (and which should become a blueprint), is > that you would like to automatically generate users who only have access to > subtrees (at a certain level). > > The concrete example is that you have all the countries in the world (grouped > into regions), and would like to have a user for each country who should not > have access to data for any other contry. With 200 countries, you don't want > to do this manually... > > I think if you have 200 users it is maybe a good use case for using something > like ldap to manage them. For example you guys at WHO are probably all > already maintained in an ActiveDirectory server for login to the network etc. > Would be nice to be able to use the same usernames and passwords in dhis. I > gather with the spring security 2 this would be quite easy to do. > > Good to see progress on this. > > Cheers > Bob > > > Knut > > On Fri, Aug 14, 2009 at 10:51 AM, Murodullo Latifov > wrote: > Hi people, > > This is to announce alpha release of DHIS2 + Struts2 (s2) + Spring Security2 > (ss2) integration. As s2 and ss2 are major and system wide change, they need > intensive testing. Code is available at URL: > https://code.launchpad.net/~dhis2-devs/dhis2/d2s2ss2 . S2 is most resent > upgrade for webwork and ss2 is for acegy security, especially ss2 is used as > is, without customization, each URL can have its own security credentials. > From this standpoint we are free to define ROLES and set of roles (most > common use cases into one role). All security concerns are now in one single > XML file and easy to understand and exists independent of other frameworks in > DHIS2. We can also use method level security, if method namings are > appropriate using AOP. Please share your experiences, type of user roles you > have, so we can adjust system to host that functionality. > > 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 > > > > --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 ___ 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] DHIS2 - Struts2 - Spring Security2
Hi Jo, I might got Knut point incorrectly. If this is the case, Bob's suggestion is quite appropriate. If there is existing authentication mechanism like Active Directory (e.g microsoft LDAP implementation), system could be adjusted to use LDAP, but not provided out of the box. The reason is that not every installation has AD or LDAP ready for use (e.g. Windows XP), and we have many single machine use cases. In case of already existing LDAP server, its the metter of changing authentication provider to one of LDAP. In this case user roles also should be managed by LDAP server. murod - Original Message From: Jo Størset To: Murodullo Latifov Cc: Bob Jolliffe ; Knut Staring ; Sundeep Sahay ; Jørn Braa ; DHIS 2 developers Sent: Friday, August 14, 2009 5:06:17 PM Subject: Re: [Dhis2-devs] DHIS2 - Struts2 - Spring Security2 Den 14. aug.. 2009 kl. 12.12 skrev Murodullo Latifov: > Hi Jo, > > The call is to tell us what kind of users you want to see and what access > levels they have. For ordinary user to have access to change its password > itself, you have to assign him role ROLE_dhis-web-maintenance-user, but its > initial set, we are calling for more options ans intensive tests. You can > assign user role as before through user settings menu option. Sorry links are > not i18nized for now. My comment was probably not very good. I was trying to understand the example Knut had, probably not understanding what it means to "generate users". I´ll keep away until I actually have time to look at these things myself :) Jo ___ 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] DHIS2 - Struts2 - Spring Security2
Hi, From: Saptarshi Purkayastha To: Murodullo Latifov Cc: Jo Størset ; Sundeep Sahay ; Jørn Braa ; DHIS 2 developers Sent: Monday, August 17, 2009 4:17:46 PM Subject: Re: [Dhis2-devs] DHIS2 - Struts2 - Spring Security2 I've been playing around with this branch for the last 2 days... and congratulations with the move to Struts2... Interesting part of spring-security is where all url security is managed through a single xml. Not sure how we will use the UI to define these roles?? Roles are created as before, through maintenance-user module. We need to create some most used cases (e.g. admin, user, data entry) as well as individual operation authorities. Each available URL can be assigned to role (or group of URLs using expression). From UI one can select predefined role such as admin or user, or create another role with custom selection of available authorities plus predefined roles if needed. But most of the old code is still existing and places where the access denied error comes, is where I see the new spring security being used. Im not quite sure still how the modules will be moving to use these changes. I believe its going to be some effort from now on... Old code is there but muted, it has no use in current settings, none of them are populated as spring beans.xml. If you see Access denied in blank white page, that means new security is doing that. As for modular design, spring security XML config is used by all, individually or in a set of selected modules. Each module canhave its security authorities and roles in that xml, while module is not in use, these authorities remian unused. Once I think we can move fully to these changes (which IMO will be a long effort), I hope we will see some performance improvements because we don't scan through the module xmls any more... This branch at the moment is very much like our trunk and hopefully you are removing the old code out. I'll remove old code as obsolete or deprecated. Now and before on each iteration user credentials are rechecked, because all processes go through struts interceptors and they are called each time new URL comes in. This might be overhead, looking for ways to reduce it more. murod --- 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/8/14 Jo Størset >>Den 14. aug.. 2009 kl. 12.12 skrev Murodullo Latifov: > > > >>>Hi Jo, >> >>>>The call is to tell us what kind of users you want to see and what access >>>>levels they have. For ordinary user to have access to change its password >>>>itself, you have to assign him role ROLE_dhis-web-maintenance-user, but its >>>>initial set, we are calling for more options ans intensive tests. You can >>>>assign user role as before through user settings menu option. Sorry links >>>>are not i18nized for now. >> > >My comment was probably not very good. I was trying to understand the example >Knut had, probably not understanding what it means to "generate users". I´ll >keep away until I actually have time to look at these things myself :) > >>Jo > >>___ >>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] DHIS2 - Struts2 - Spring Security2
Hi Lars, New database does not create admin/dis if one does not exists, working on it to do by startup routine check. I was discussing this issue with you earlier, it is not spring security responsibility to create user pass. For existing database you should have ROLE_ALL in your role list. murod From: Saptarshi Purkayastha To: Lars Helge Øverland Cc: Murodullo Latifov ; Sundeep Sahay ; Jørn Braa ; DHIS 2 developers Sent: Wednesday, August 19, 2009 8:05:37 PM Subject: Re: [Dhis2-devs] DHIS2 - Struts2 - Spring Security2 I was using an existing database and used the same user/pass I had in that database and was able to login... Does the login "please wait" go on forever?? If thats the case, then it is another bug that I encountered once on our trunk, which can be solved by restarting tomcat. --- 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/8/19 Lars Helge Øverland > >Hi, > >>I am not able to log in on existing or new databases. Admin/district >>does not work, how does one log in? > > >>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] DHIS2 - Struts2 - Spring Security2
Hi Lars, - Original Message From: Lars Helge Øverland To: Saptarshi Purkayastha Cc: Murodullo Latifov ; DHIS 2 developers Sent: Wednesday, August 19, 2009 8:17:29 PM Subject: Re: [Dhis2-devs] DHIS2 - Struts2 - Spring Security2 On Wed, Aug 19, 2009 at 4:35 PM, Saptarshi Purkayastha wrote: > I was using an existing database and used the same user/pass I had in that > database and was able to login... > Does the login "please wait" go on forever?? If thats the case, then it is > another bug that I encountered once on our trunk, which can be solved by > restarting tomcat. Sorry it works with existing databases. It does not work on new databases. But I am not getting to see any modules in the top menu, even if logging in with an admin user? Maybe the user authorities must be set up again, but I am not able to get to the user module. When I enter the URL manually i get "access denied!". Did you have any successs here? If user has ROLE_ALL it is provided all menu options, otherwise that user has to be granted module menu, that is to select role with module name on it. Prefix ROLE_ was added for all roles, M_, F_ and "" are obsolete now (We can activate them, if needed, but i think this one is better). Tough, but secure, maybe not right decision to do so, but each single URL can have it's role. User can have access to menu, but left menu will be access denied, unless user has that authority. To see all in work create new user role and see. Look at security-beans.xml. We should think of getting existing roles into new counterparts, when people decide to upgrade. 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] DHIS2 - Struts2 - Spring Security2
Hi Lars, There is only one way - to add new roles and URLs into signle xml file. I think there is a way to spread security into many bean xmls (one could be using "parent" directive, not sure), but to have all in one point is better. If module is not used, its roles and URLs still can be there - with no effect. murod - Original Message From: Lars Helge Øverland To: Murodullo Latifov Cc: DHIS 2 developers Sent: Friday, August 21, 2009 2:30:19 PM Subject: Re: [Dhis2-devs] DHIS2 - Struts2 - Spring Security2 On Fri, Aug 14, 2009 at 10:51 AM, Murodullo Latifov wrote: > Hi people, > > This is to announce alpha release of DHIS2 + Struts2 (s2) + Spring Security2 > (ss2) integration. As s2 and ss2 are major and system wide change, they need > intensive testing. Code is available at URL: > https://code.launchpad.net/~dhis2-devs/dhis2/d2s2ss2 . S2 is most resent > upgrade for webwork and ss2 is for acegy security, especially ss2 is used as > is, without customization, each URL can have its own security credentials. > From this standpoint we are free to define ROLES and set of roles (most > common use cases into one role). All security concerns are now in one single > XML file and easy to understand and exists independent of other frameworks in > DHIS2. We can also use method level security, if method namings are > appropriate using AOP. Please share your experiences, type of user roles you > have, so we can adjust system to host that functionality. > > regards, > murod > > > A comment: One problem with having all security concerns in one single XML file is modularization and local modules. How should the local indian/vietnamese modules deal with this? How can we easily swap modules in and out with this setup? 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] Should we remove the Source object?
Hi, - Original Message From: Lars Helge Øverland To: DHIS 2 developers Sent: Wednesday, August 26, 2009 6:56:46 PM Subject: [Dhis2-devs] Should we remove the Source object? Hi, I have been thinking about removing the Source object from the API. The abstract Source class was introduced in the model in order to allow for multiple implementations of Sources in the system. Currently we only have the OrganisationUnit object extending Source. We now see eg. with Abyot's CHIS module that even if we need a new kind of Source; the Patient, we still need the OrganisationUnit reference in DataValue. The downsides of keeping Source are that it - Increases complexity. - Makes JDBC/Hibernate operations slower, since the Source table must be updated first, then the orgunit table. - Entails problems when people manually modifies the database (which they really should not) as they always forget to update the source table when adding/removing from the organisationunit table. The only database update this would require is to set the "organisationunitid" field in the "organisationunit" table to auto-increment. I believe Hibernate will take care of this. Based on this I opt for removing the Source object and moving the OrganisationUnit object into the core. Are there other aspects regarding this that should be mentioned? Any objections? regards Lars Just looked at Source class, it has some commonly used attributes for hibernated objects (needed by hibernated objects, not any business logic at all), it does not give any value to organisationunit class. Moreover its ID attribute and its storage to database is excessive. Useful object to me for example could be relation to resolve hierarchy, if say source class had attributes parent and childs, and other implementing classes could use it reducing code lines and maintenance, bringing all into interface: private Object parent; private List children; gettersetters. This could be good for implementations with hierarchy on their business logic. I agree with removal as it does nothing, but one precaution - if it was used by modules as object via hibernate, those need fixing too. Look at datavalue class, it has Source class as attribute, maybe this is due to lightweightness of Source compared to Organisationunit? We have more load on datavalue object read and manipulation. 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] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 522: - Fixed bug related to DHIS 1.4 import of datavalues. - Codestyle fix.
Hi, - Original Message From: Saptarshi Purkayastha To: DHIS 2 developers Sent: Monday, August 31, 2009 9:36:01 PM Subject: Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 522: - Fixed bug related to DHIS 1.4 import of datavalues. - Codestyle fix. Are we sure want to continue this non-standard code formatting? Any specific historic reason that we use this code style? On 8/31/09, nore...@launchpad.net wrote: > > revno: 522 > committer: Lars Helge Oeverland larshe...@gmail.com > branch nick: trunk > timestamp: Mon 2009-08-31 17:37:16 +0200 > message: > - Fixed bug related to DHIS 1.4 import of datavalues. - Codestyle fix. > modified: Why not to create code style template for Eclipse and use it with one click to style code, control new class creation. 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] Getting problem while building a local module
Hi, Error message clearly says one dependency is missing and it is transitive dependency of com.lowagie:itext:jar:1.4.8. Look at jasperreport and itext dependencies. murod From: Brajesh Murari To: DHIS 2 developers Sent: Tuesday, September 1, 2009 12:21:58 PM Subject: [Dhis2-devs] Getting problem while building a local module Hi, I need a help. i am trying to build "dhis-web-reports-national", a local copy on my PC, and i am getting following message on my console window, --Message detail --- D:\scm\dhis2svn\local\in\dhis-web-reports-national>mvn clean install Listening for transport dt_socket at address: 8000 [INFO] Scanning for projects... [INFO] [INFO] Building DHIS National Reports [INFO]task-segment: [clean, install] [INFO] [INFO] Ignoring available plugin update: 2.3 as it requires Maven version 2.0.6 [INFO] Ignoring available plugin update: 2.4.3 as it requires Maven version 2.0.6 [INFO] [clean:clean] [INFO] [resources:resources] [INFO] Using encoding: 'UTF-8' to copy filtered resources. Downloading: http://repo1.maven.org/maven2/bouncycastle/bctsp-jdk14/138/bctsp-jdk14-138.pom [WARNING] Unable to get resource 'bouncycastle:bctsp-jdk14:pom:138' from repository central (http://repo1.maven.org/maven2) Downloading: http://repo1.maven.org/maven2/bouncycastle/bctsp-jdk14/138/bctsp-jdk14-138.jar [WARNING] Unable to get resource 'bouncycastle:bctsp-jdk14:jar:138' from repository central (http://repo1.maven.org/maven2) [INFO] [ERROR] BUILD ERROR [INFO] [INFO] Failed to resolve artifact. Missing: -- 1) bouncycastle:bctsp-jdk14:jar:138 Try downloading the file manually from the project website. Then, install it using the command: mvn install:install-file -DgroupId=bouncycastle -DartifactId=bctsp-jdk14 \ -Dversion=138 -Dpackaging=jar -Dfile=/path/to/file Path to dependency: 1) org.hisp.dhis:dhis-web-reports-national:war:2.0.1-SNAPSHOT 2) jasperreports:jasperreports:jar:2.0.2 3) com.lowagie:itext:jar:1.4.8 4) bouncycastle:bctsp-jdk14:jar:138 -- 1 required artifact is missing. for artifact: org.hisp.dhis:dhis-web-reports-national:war:2.0.1-SNAPSHOT from the specified remote repositories: central (http://repo1.maven.org/maven2) [INFO] [INFO] For more information, run Maven with the -e switch [INFO] [INFO] Total time: 5 seconds [INFO] Finished at: Tue Sep 01 12:03:36 IST 2009 [INFO] Final Memory: 11M/20M [INFO] D:\scm\dhis2svn\local\in\dhis-web-reports-national> ---end of message on my console--- I need help, can any body tell me how to solve this problem, if really it exists.. -- Best Regards, Brajesh Murari ___ 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] Evaluation the formulae in POI
Hi Huie, File a bug into Apache POI site if this is the case, or maybe not, if you try first excluding zero value elements before evaluation, because evaluating zero is known beforehand. Second, most possibly that cell was not initiated? Try to find if that cell was created first, even if you are not going to place value, e.g. call create row, row create cell, cell set or do not set value. Same as if you declare Java variables and do not instantiate: public String str; is null, only declaration public String str = ""; is "", assigned value "" or str = ""; after is "", now assigned value "". regards, murod ________ From: Hieu Dang Duy To: Dhis2 ; Murodullo Latifov Sent: Wednesday, September 2, 2009 12:26:42 PM Subject: Evaluation the formulae in POI Dear Murod, May I disturb you about the old issue (recalculated value from excel formula by POI's Evaluation). I think it is fine until now but maybe not. The problem's happened while testing. For example, in excel file, I've got 5 cells (A, B, C, D, E) and 1, 2, 3, 4, 5 which is data value on each corresponding cell. If used POI's Evaluation you wouldn't see the problem at all. But one of them (cells) which is a empty or blank cell so the evaluation of POI will does not working. I meant the result that you could receive is zero. Do you have any opinion for this one? By the way, I think that I should update POI library to latest version. Thank you ! -- Hieu.HISPVietnam Good Health ! ___ 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 Documentation
Hi, One suggestion. Make sure there are free open source translation tools (OS independent) for DocBook, because DHIS docs should be translated into many other languages too. regards, murod From: Jason Pickering To: dhis2-devs Sent: Thursday, September 10, 2009 12:01:03 AM Subject: [Dhis2-devs] DHIS 2 Documentation Hi Everyone, I have been speaking with Jan and Old a bit about documentation and before I start committing anything, or making too many changes, I would like to get some feedback from everyone. Let me be quite honest. I find the documentation of DHIS2 to be quite appalling. It is scattered between different Wiki sites, Launchpad, mailing lists, and various documents here and there. We need to do better. Jan has started a document on the GIS portion of DHIS2 and I would like to suggest that we standardize all documentation by using the DocBook format.Visit www.docbook.org for more info. I will not repeat the various advantages of using this format over others, other than to say it is very common, it is structured, and is supported by a large number of editors and can be transformed into essentially any format . Since DocBook is pure XML it is much more suited to the sort of distributed development environment we are working in, as opposed to say proprietary, binary word documents or other formats. Any reactions here? I have started a bit of work on the conversion of the GIS manual to DocBook format, but wanted to get feedback from the community before I proceeded much further. Of course, documentation in a structure format like XML will be a bit more painful, but there are several tools out there (many of them OpenSource) that provide good editors for the format. Of course the ability to transform this XML info many different formats, such as HTML, Word, PDF, JavaHelp files (the list is very long) is a big advantage in my mind. What does everyone think? Best 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
Re: [Dhis2-devs] DHIS 2 Documentation
Hi, Seems lots of editors available out there. Vi or Vim, you should ask linguists, who make use of it. regards, murod From: Jason Pickering To: Murodullo Latifov Cc: dhis2-devs Sent: Thursday, September 10, 2009 12:40:26 AM Subject: Re: [Dhis2-devs] DHIS 2 Documentation Hi Murod, What's wrong with vi? :) No seriously, cross-platform and multilingual issues should not be a problem. There are many possibilities, including Eclipse for the devs. http://wiki.docbook.org/topic/DocBookAuthoringTools for a rather lengthy list of possible authoring tools. Best regards, Jason On Wed, Sep 9, 2009 at 8:50 PM, Murodullo Latifov wrote: Hi, > >One suggestion. Make sure there are free open source translation tools (OS >independent) for DocBook, because DHIS docs should be translated into many >other languages too. > >regards, >murod > > > > From: Jason Pickering >To: dhis2-devs >Sent: Thursday, September 10, 2009 12:01:03 AM >Subject: [Dhis2-devs] > DHIS 2 Documentation > > >>Hi Everyone, > >I have been speaking with Jan and Old a bit about documentation and before I >start committing anything, or making too many changes, I would like to get >some feedback from everyone. > >Let me be quite honest. I find the documentation of DHIS2 to be quite >appalling. It is scattered between different Wiki sites, Launchpad, mailing >lists, and various documents here and there. We need to do better. > >Jan has started a document on the GIS portion of DHIS2 and I would like to >suggest that we standardize all documentation by using the DocBook >format.Visit www.docbook.org for more info. I will not repeat the various >advantages of using this format over others, other than to say it is very >common, it is structured, and is supported by a large number of editors and >can be transformed into essentially any format . Since DocBook is pure XML it >is much more suited to the sort of distributed development environment we are >working in, as opposed to say proprietary, binary word documents or other >formats. > >Any reactions here? I have started a bit of work on the conversion of the GIS >manual to DocBook format, but wanted to get feedback from the community before >I proceeded much further. Of course, documentation in a structure format like >XML will be a bit more painful, but there are several tools out there (many of >them OpenSource) that provide good editors for the format. Of course the >ability to transform this XML info many different formats, such as HTML, Word, >PDF, JavaHelp files (the list is very long) is a big advantage in my mind. > >What does everyone think? > >Best 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
Re: [Dhis2-devs] interoperability and uuids
Hi Bob, Good point to make unique id for data element, org unit and so. This way in DHIS we could have uid for say same data element across different existing installations, just by updating uuid. But this could solve internal issue of DHIS, not interoperability with other systems like openmrs. At least maintaining uuids will be overhead. uuid is meant to create unique id in non controlled (non centralized) environment, and later merge data together without id conflict. Interoperability, especially when data at different levels should be linked, has to be based on atomic unit of data. In our case, this would be ICD10. OpenMRS uses ICD10 (should use) to uniquely identify each disease, so every concept in openmrs should have corresponding uuid (this would be one to one mapping 1 concept - 1 ICD10 code). In contrast DHIS as data warehouse will have one to many relation to ICD10 codes. This is where generalization occurs. Say we have TB data element to generally show TB status, it would include all TB related diseases ICD10 A15-A19 or subset of TB types: A15, A16, A17, A18 and A19, but not detailed one like shown in http://apps.who.int/classifications/apps/icd/icd10online/. This list should be used by openmrs and alike systems. Now when both systems confirm to ICD10 codes, it would be simple to map data at different levels because openmrs uses ICD10 at atomic level, and DHIS make generalization as it needs to form data element. Also we give freedom to implementers what to choose, what ICD10 codes form particular data element of particular country. So idea of uuid will not serve best for interoperability, it will be overhead and also lengthy. I think the only way is to map dhis data to icd10 and openmrs to icd10 and icd10 to icd10, giving freedom to dhis implementers what icd10 codes will form particular data element. DataSet, Category and Categorycombo are DHIS internal structure, they cannot be part of any standard. Tying this all into one as to solve interoperability issue, will not bring to success. As part of my PhD I am learning standards and standard making in healthcare and so far I didn't see two countries using the same form for data collection. there is explanation for this: each country has prioritized certain aspect of healthcare, like in Tajikistan it is TB and in African countries it may be HIV and child mortality. From this countries may haver different set of data elements, even at dhis level they want more detailed info on particular cases, say from example above Tajikistan uses all TB ICD10 in DHIS with little generalization and more details. It also can go down to level as http://apps.who.int/classifications/apps/icd/icd10online/. I tried to express my ideas on interoperability, hope it helps in some way. In general DHIS meta should be something like this: To: dhis2-devs Sent: Sunday, September 13, 2009 3:46:21 PM Subject: [Dhis2-devs] interoperability and uuids Greetings Looking at data exchange with openmrs using sdmx_hd (or anything else for that matter). Every metadata that is exchanged will require a uuid. Currently looking at what is required to share metadata regarding a metadata, means that the following are required to have uuids: DataElement - already have OrgUnit- already have DataSet Category CategoryCombo The DataSet is not strictly required, but probably useful. The category (Dimension) and CategoryCombo (DimensionSet) are. Any objections, suggestions or other comment? Regards 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
[Dhis2-devs] Multiple mails with same content
Hi, I am receiving two or three copies of the same message nowadays. Does some one else experience this? Who is managing mailing lists, please take actions. 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
[Dhis2-devs] Fw: Annual indicators and Datasets
Hi all, In Tajik dhis almost 80% of data elements have annual (yearly) periods. While calculating aggregate data for yearly period, it is not shown on pivot, charts, etc. Monthly datasets are fine. Can you please check and give quick fix? 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
[Dhis2-devs] Excel reports module
Hi, Just looked at Excel reports module, quite useful, very intuitive and easy to use. Excellent work. But couldn't find "weekly" and "daily" periods on the list of periods, also when generating reports, it only shows monthly period, though particular report is based on weekly period. There are no much information in this regards in manual I have. Manual also does not cover Excel Items option in Administration menu also, which has weekly and daily periods. Is this new feature? Please help. 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
[Dhis2-devs] DHIS booklet or poster
Dear all, Does anybody have posters or booklets on DHIS2? I need this for my presentation. 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
[Dhis2-devs] Organisation unit translation
Hi, I couldn't find translate button for Orgunit, "category" and "category option". Why these have been removed? How to translate Orgunits? Can someone provide a way for translating these 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] Organisation unit translation
Even translated Org unit names do not take effect, e.g. it always shows default name from orgunit object. - Original Message From: Murodullo Latifov To: DHIS 2 developers Sent: Mon, January 25, 2010 7:25:36 AM Subject: [Dhis2-devs] Organisation unit translation Hi, I couldn't find translate button for Orgunit, "category" and "category option". Why these have been removed? How to translate Orgunits? Can someone provide a way for translating these 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] Switch from Acegi to Spring Security
Hi, Yes, branch with Struts2 upgrade had Spring Security as well. All was fine, except all security rules were not modular, e.g. all rules for all modules had to be in one XML file. This was week point for my implementation, but I used ss API, not custom implementation like we see in Acegy implementation in DHIS - placing security rule in action definition. After student project started I stopped working further on that. regards, murod From: Saptarshi Purkayastha To: Lars Helge Øverland Cc: dlz...@ifi.uio.no; Anders Aarsæther ; DHIS 2 developers ; Aslak Eide ; m...@ifi.uio.no; Magnus Korvald Sent: Thu, January 28, 2010 10:40:16 PM Subject: Re: [Dhis2-devs] Switch from Acegi to Spring Security awesome... hadn't Murod done it on his branch as well?? --- 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 2010/1/28 Lars Helge Øverland > > >Hi, > > >I have just merged in work from a student group at inf5750 which did the >migration from Acegi to Spring Security. Thanks to Dlzar, Aslak, Anders, >Magnus, Mo for nice work. > > >This is good news as there are now no more out-dated frameworks inside DHIS 2. > > >Migrating web-modules only requires a minor change in WEB.XML (have a look in >any WEB.XML in trunk if in doubt) : > > > > > > >-SecurityFilterChain >-org.acegisecurity.util.FilterToBeanProxy >- >- targetBean >- org.acegisecurity.util.FilterChainProxy >- >+filterChainProxy >+ >org.springframework.web.filter.DelegatingFilterProxy > > >-SecurityFilterChain >+filterChainProxy > /* > > >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 > > ___ 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] Pagination
Hi all, I have developed client side pagination for one of modules we use here in Tajikistan (see attached screen-shot). Could be useful for patient modules, as many records would be added into the same table. I am using jquery plugin for this. Its quite easy task to add for other modules like list of data elements and so on. What do you think? Later we could move to server side pagination? 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] Regular expressions in data validation rules
Hi Jason,
Looks like single time task if I understood you correctly? If you want to clean
data already on database. like data integrity checking. Why not to make it
clean at the very beginning, when particular record being captured? For this
one could use regexp in javascript on client side too. As for leading and
trailing spaces String.trim(" string") should do before passing to database.
regards,
murod
- Original Message
From: Jason Pickering
To: Hieu Dang Duy
Cc: dhis2-devs
Sent: Mon, February 8, 2010 1:05:27 PM
Subject: Re: [Dhis2-devs] Regular expressions in data validation rules
Hi Hieu,
Yes, I am actively fishing for a developer to implement this, as it
will really save me a huge amount of work in trying to clean up data.
I have no idea really how it would be implemented, other than that
java.util.regex should be able to be used, but let me give it a try at
a better specification. I do not think it should be so difficult
either.
I am thinking of something like this
The user would create a regular expression for later assignment to a
database object. The user would select a database table (object) and
field for validation. For instance, lets say we want to validate that
there are no trailing spaces in an organization name.
So, we would create a rule called "Trailing spaces are not allowed"
We would create this rule, and assign a description and a regular
expression to it.
in this case, it would probably be something really simple like '\s+$'
Now, I have no idea how to do this in java, but I assume this would be
really simple, something like this query in Postgresql.
SELECT name from organisationunit where name ~*('\s+$')
Wow, I found 571 orgunits in my organisationunittable with trailing
spaces. Cool.
So, i think we need two objects.
1) A persistence object that stores the following files for the
RegexExpression
a) regexid
b) name
c) expression
d) description
e) resolution description (telling the user how to solve this problem)
2) A table to assign regular expressions to database objects.
a) regexid
b) table
c) field
We could maybe reuse this rule on the davavalue table, to determine if
any values have been stored with trailing spaces.
Yeah, its very easy I think. I would do it myself if I knew a lick of Java. :)
Best regards,
Jason
On Sun, Feb 7, 2010 at 7:36 PM, Hieu Dang Duy
wrote:
> Hi all,
>
> I've no idea about using RegEx for validating data in DHIS2. Just a small
> comment, I am also using this many times so my feeling on this is not easy
> but not too difficult when applying RegEx in your coding, ie, javascript and
> java also.
> With RegEx, we can easy controlling any thing that we want to force the user
> for entering data (text, number) or something else (a file name is an
> example).
> Let's try !
>
> Thanks !
>
> On Sun, Feb 7, 2010 at 10:24 PM, Jason Pickering
> wrote:
>>
>> https://blueprints.launchpad.net/dhis2/+spec/regex-validation
>>
>> I have updated the blueprint on regular expression use in data
>> validation rules. This would really make my life (and I suspect
>> others) lives a lot easier, as long as we are using naming
>> conventions, lets at least enforce them somehow.
>>
>> For discussion.
>>
>> 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
>
>
>
> --
> Hieu.HISPVietnam
> Good Health !
>
___
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] Regular expressions in data validation rules
Hi Jason,
Ok, I understood your point. If you are about import validation, than its good
to do that, as there is no proper XML validator for DHIS data exchange, I mean
content not validated against any dictionary or repository, when source is
other than DHIS itself. Kettle is one such tool for ETL with inbuilt regexp
support. You can use it for single task type of issues with transformation,
validation and such. http://kettle.pentaho.org/. Support many different input
formats as well as output.
Regards,
murod
- Original Message
From: Jason Pickering
To: Murodullo Latifov
Cc: Hieu Dang Duy ; dhis2-devs
Sent: Mon, February 8, 2010 2:27:13 PM
Subject: Re: [Dhis2-devs] Regular expressions in data validation rules
Hi Murod,
This, of course, is one particular trivial example and was provided
to illustrate a point.
I totally agree, this particular example could be solved through
JavaScript validation on the client, and it may already be there in
2.0. I have found this particular example by importing data from 1.4,
where organization units are allowed to have trailing spaces. I think
this is not really a one-off issue, as many people may need to import
data from external systems, which may or may not have this particular
validation enforced.
What I am trying to get at is that regular expressions could be used
to expand the scope of the current data integrity checks, by enforcing
certain patterns on the data (which in some cases could also be
enforced through JavaScript in through the UI). Of course, if we can
do it at the UI level great, but it may not work in all cases,
especially when receiving data from external system. This is why I
think that the data integrity checks come in place. For instance, as I
mentioned in the specs, I need to find all organizational units that
do not correspond to the naming conventions here in Zambia. I can do
this with this...
SELECT name from organisationunit where name !~ '^(ce|co|ea|ls|lu|no|nw|so|we) '
Well, I found 47, which do not correspond to the naming convention. I
have made my dislike of the supposed best practice naming conventions
in earlier threads, but with the implmenetation of regex for checking
of these conventions, at least we could enforce them, even if it is ex
post facto.
Again, these are all examples, and they are really impossible to
predict what they may be, thus the need for flexible rules, built by
administrators/users, and then applied during data integrity checks
(and/or during data entry).
Regards,
Jason
On Mon, Feb 8, 2010 at 9:55 AM, Murodullo Latifov
wrote:
> Hi Jason,
>
> Looks like single time task if I understood you correctly? If you want to
> clean data already on database. like data integrity checking. Why not to make
> it clean at the very beginning, when particular record being captured? For
> this one could use regexp in javascript on client side too. As for leading
> and trailing spaces String.trim(" string") should do before passing to
> database.
>
> regards,
> murod
>
>
>
> - Original Message
> From: Jason Pickering
> To: Hieu Dang Duy
> Cc: dhis2-devs
> Sent: Mon, February 8, 2010 1:05:27 PM
> Subject: Re: [Dhis2-devs] Regular expressions in data validation rules
>
> Hi Hieu,
> Yes, I am actively fishing for a developer to implement this, as it
> will really save me a huge amount of work in trying to clean up data.
>
> I have no idea really how it would be implemented, other than that
> java.util.regex should be able to be used, but let me give it a try at
> a better specification. I do not think it should be so difficult
> either.
>
> I am thinking of something like this
>
> The user would create a regular expression for later assignment to a
> database object. The user would select a database table (object) and
> field for validation. For instance, lets say we want to validate that
> there are no trailing spaces in an organization name.
>
> So, we would create a rule called "Trailing spaces are not allowed"
>
> We would create this rule, and assign a description and a regular
> expression to it.
>
> in this case, it would probably be something really simple like '\s+$'
>
> Now, I have no idea how to do this in java, but I assume this would be
> really simple, something like this query in Postgresql.
>
> SELECT name from organisationunit where name ~*('\s+$')
>
> Wow, I found 571 orgunits in my organisationunittable with trailing
> spaces. Cool.
>
> So, i think we need two objects.
>
> 1) A persistence object that stores the following files for the
> RegexExpression
>
> a) regexid
> b) name
> c) expression
> d) description
> e) resolution description (telling the user how to solve this problem)
>
> 2) A table to assign regular e
Re: [Dhis2-devs] New installer available: Testers wanted
Hi all, There are platform independent system variables that could be used by any Java installation in any environment, no need to spesify anything. Look here http://java.sun.com/docs/books/tutorial/essential/environment/sysprop.html and here http://www.mindspring.com/~mgrand/java-system-properties.htm. regards, murod - Original Message From: Jason Pickering To: Ola Hodne Titlestad Cc: dhis2-devs Sent: Tue, March 2, 2010 2:17:14 PM Subject: Re: [Dhis2-devs] New installer available: Testers wanted I am just chatting with Knut on this. I think the better solution would be in the Launch4j exe, where we can specify a path to the JRE with the directive. We could do the same for the launch.sh script on Linux. Jetty is called by the Launch4j wrapper, which accept these parameters. bundled JRE path x.x.x[_xx] x.x.x[_xx] jreOnly|preferJre|preferJdk|jdkOnly MB % MB % text ... So as long as we bundle the JRE (which sounds like what needs to be done) then everything should work just fine. It will just increase the size of the install by about 15 MB. Maybe Lars or Bob could comment, but this seems like the solution to me. Regards, JPP On Tue, Mar 2, 2010 at 10:37 AM, Ola Hodne Titlestad wrote: > On 2 March 2010 09:21, Knut Staring wrote: >> >> 2010/3/2 Jason Pickering >>> >>> > >>> > Lets not put BIRT in, we have Jasper, if people want BIRT they can >>> > download >>> > and install it separately, its quite big... >>> > >>> >>> Fine, but I need it here, and this was the original reason for the >>> installer, so I will have another version with BIRT. >>> >>> >>> >> >>> >> 2) A "lite install" allowing the user to download and manually >>> >> install, with H2. . Footprint is around 60 MB. >>> > >>> > This sounds good to me. I am envisioning this range of downloads: >>> > >>> > A. Cross-platform Live package >>> > (DHIS 2 Live with H2 as we have it today, no installer) >>> >>> Well, we can build multiple native installers for the Live Package. it >>> is just an extra line in the Pom. If we need a multiple platforms >>> (Mac, Linux, etc) we can build it during the installer build. Of >>> course, people can just grab the zip file if they want, but BitRock >>> can build for multiple platforms. >>> >>> > B. Windows on-line installer >>> > Similar to your 2. alternative. >>> > C. Windows off-line installer. >>> > Similar to your 1. alternative. A dedicated Java sounds like a good >>> > idea. >>> > Can we achieve this simply by setting JAVA_HOME "temporarily" while >>> > starting >>> > DHIS? I guess Bitrock allows for this..? >>> >>> BitRock can do this, but it may influence other programs. Could the >>> Launch4j wrapper be used for this, or maybe an alternative environment >>> variable? >>> >> >> Not sure JAVA_HOME is necessary - we are not compiling anything. I think >> it could be sufficient to modify the menu shortcut links that start DHIS. > > We set this environment variable (should perhaps think of JAVA_OPTS as well) > as a parameter temporarily on jetty startup, that way we are not interfering > with how other systems use it. Not sure how you start up jetty, but if its a > java -jar command we could just add JAVA_HOME=XX as a parameter to that > command like we could add JAVA_OPTS=XX as well. > >> >> >>> >>> > D. Linux debian package >>> > Bob's deb as we have it today. >>> > >>> >>> BitRock can also produce a RPM, Deb packages (somehow) but I have not >>> looked at the details. We might consider rolling all of this up into >>> BitRock at some point, but it is good to have the deb installer as >>> well. >>> >>> >>> Regards, >>> JPP >>> >>> -- >>> -- >>> Jason P. Pickering >>> email: jason.p.picker...@gmail.com >>> tel:+260968395190 >> >> >> >> -- >> 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 >> > > -- -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+260968395190 ___ 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
[Dhis2-devs] Revision history
Hi all,We started implementing DHIS2 in Tajikistan. There are a lot to do and we are in a phase of creatging data dictionary. Project manager wants to truck all changes made to data elements and indicators throuout their lifetime, or at least on each release of data dictionary. Are there such features currently in dhis? Another point is to have "retired" option for all maintenance objects. Having these keys we could hold or activate DE and indicators, like in OpenMRS. 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] Revision history
Hi Bob, Yes, also I think there should be some sort of Id independent of autogenerated Id for metadata objects (DE, indicator, category, period, OU). And these Ids should be used while importing and exporting from one location to other based on Metadata. Autogenerated Ids should be linked to Metadata Ids. This way we can guaranty uniqueness of metadata objects across implementation locations. For versioning hibernate audit will be fine, but it only works with annotated implementation of it. Should we put some blueprints for these? cheers, murod From: Bob Jolliffe To: Murodullo Latifov Cc: DHIS 2 developers Sent: Mon, January 10, 2011 10:42:41 AM Subject: Re: [Dhis2-devs] Revision history Hi Murod I've been raising discussion for some time about the need for better metadata governance. Currently we have a notion of metadata but no notion of whose metadata it is and which version it might be. Implementators effectively do their best to manage this manually. I think the latest flurry was here http://www.mail-archive.com/dhis2-devs@lists.launchpad.net/msg08466.html, from which I gather there is a commitment to address some of these issues in 2.0.7, so this might be a good time to articulate the Tajik requirements more fully. There are lots of ways to consider this problem, but I guess mostly it comes down to the level of granularity required. I'm guessing that at first pass we will implement a fairly coarse grained approach, as you describe in "at least on each release of data dictionary". I can't give too much thought to it right now, but I suggest we should schedule a fuller discussion for the end of Jan/beginning of Feb. There are quite a few implications for many aspects of dhis. Regards Bob PS. In the short term your best approach might simply be to commit Export_meta.xml files to a local svn (or git!), tagged on release of datadictionary events. On 10 January 2011 09:03, Murodullo Latifov wrote: > > > > >Hi all, > >We started implementing DHIS2 in Tajikistan. There are a lot to do and we are >in >a phase of creatging data dictionary. Project manager wants to truck all >changes >made to data elements and indicators throuout their lifetime, or at least on >each release of data dictionary. Are there such features currently in dhis? > >Another point is to have "retired" option for all maintenance objects. Having >these keys we could hold or activate DE and indicators, like in OpenMRS. > > >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] Revision history
There should be metadata dictionary, which generates DE, OU, period, indicator, category, giving each link to metadata id, the same metadata should be used for import/export purposes for validation, transfering new metadata objects to other hosts, etc. These could be achieved by slightly modifying current development. Any thoughts? From: Murodullo Latifov To: Bob Jolliffe Cc: DHIS 2 developers Sent: Mon, January 10, 2011 11:00:49 AM Subject: Re: [Dhis2-devs] Revision history Hi Bob, Yes, also I think there should be some sort of Id independent of autogenerated Id for metadata objects (DE, indicator, category, period, OU). And these Ids should be used while importing and exporting from one location to other based on Metadata. Autogenerated Ids should be linked to Metadata Ids. This way we can guaranty uniqueness of metadata objects across implementation locations. For versioning hibernate audit will be fine, but it only works with annotated implementation of it. Should we put some blueprints for these? cheers, murod From: Bob Jolliffe To: Murodullo Latifov Cc: DHIS 2 developers Sent: Mon, January 10, 2011 10:42:41 AM Subject: Re: [Dhis2-devs] Revision history Hi Murod I've been raising discussion for some time about the need for better metadata governance. Currently we have a notion of metadata but no notion of whose metadata it is and which version it might be. Implementators effectively do their best to manage this manually. I think the latest flurry was here http://www.mail-archive.com/dhis2-devs@lists.launchpad.net/msg08466.html, from which I gather there is a commitment to address some of these issues in 2.0.7, so this might be a good time to articulate the Tajik requirements more fully. There are lots of ways to consider this problem, but I guess mostly it comes down to the level of granularity required. I'm guessing that at first pass we will implement a fairly coarse grained approach, as you describe in "at least on each release of data dictionary". I can't give too much thought to it right now, but I suggest we should schedule a fuller discussion for the end of Jan/beginning of Feb. There are quite a few implications for many aspects of dhis. Regards Bob PS. In the short term your best approach might simply be to commit Export_meta.xml files to a local svn (or git!), tagged on release of datadictionary events. On 10 January 2011 09:03, Murodullo Latifov wrote: > > > > >Hi all, > >We started implementing DHIS2 in Tajikistan. There are a lot to do and we are >in >a phase of creatging data dictionary. Project manager wants to truck all >changes >made to data elements and indicators throuout their lifetime, or at least on >each release of data dictionary. Are there such features currently in dhis? > >Another point is to have "retired" option for all maintenance objects. Having >these keys we could hold or activate DE and indicators, like in OpenMRS. > > >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
[Dhis2-devs] Some thoughts on improvement of DHIS2 customization
Hi all,There are some issues I am facing with implementation. First OrgUnit is no more localized as was earlier. Maybe this is good for some implementation, but not to all, like we have multi language requirement here in Tajikistan. New implementation of categorycombos does not have translation functionality.Another issue is use of validation rules for data entry using regex. Existing regex for shortname does not validate cyrillyc letters (unicode), latin chars (ANSI) are ok. Looking at these two issues I suggest to create some sort of common service wich accesses key/value pairs and that is used to determine behaviour of the system or module. For above examples we could use global property of translate OrgUnit or not. Or we could easily adjust regex to match our needs.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] Some thoughts on improvement of DHIS2 customization
Hi Jason, Thanks for clarification. I understand importance of validation. We have trouble with duplicates, etc. We have few OrgUnits, and have mach more Data Elements say compared to India, so cases vary. Looking at all these I am thinking it would be better to have expandable System Settings, which would allow us to customize regex for each implementation providing default. This would allow to say translate or do not translate OrgUnits, validate or do not validate shortnames, etc instead of removing existing feature. regards, murod From: Jason Pickering To: Murodullo Latifov Cc: DHIS 2 developers Sent: Fri, January 14, 2011 5:19:26 AM Subject: Re: [Dhis2-devs] Some thoughts on improvement of DHIS2 customization Hi Murod, You can check out this blueprint regarding flexible regex validation. We have had a lot of discussion about this. https://blueprints.launchpad.net/dhis2/+spec/regex-validation I developed the blueprint in part from things that came up in Tajikistan while I was there, as well as from other places where the need for flexible in-field validation is required. It is a good point regarding the Cyrillic characters, where validation would likely need to happen on the server side, since Javascript is not well suited to validation of Unicode. Agree with the orgunit translation as well. See... https://blueprints.launchpad.net/dhis2/+spec/orgunit-translation https://bugs.launchpad.net/dhis2/+bug/519175 Please see Lars response here.. http://www.mail-archive.com/dhis2-devs@lists.launchpad.net/msg04512.html Regards, Jason On Thu, Jan 13, 2011 at 1:21 PM, Murodullo Latifov wrote: > > > > >Hi all, > >There are some issues I am facing with implementation. First OrgUnit is no >more >localized as was earlier. Maybe this is good for some implementation, but not >to >all, like we have multi language requirement here in Tajikistan. New >implementation of categorycombos does not have translation functionality. >Another issue is use of validation rules for data entry using regex. Existing >regex for shortname does not validate cyrillyc letters (unicode), latin chars >(ANSI) are ok. > >Looking at these two issues I suggest to create some sort of common service >wich >accesses key/value pairs and that is used to determine behaviour of the system >or module. For above examples we could use global property of translate >OrgUnit >or not. Or we could easily adjust regex to match our needs. > > >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 > > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+260968395190 ___ 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] Translation function - Stay at page after modified some thing
Hi all, In this connection I also implemented server side pagination for dhis. This could be used in Dataelement listing, patient records, etc. There is also search facility working with pagination to narrow down scope. It may need speed comparison with existing single listings and other pros and cons. regards, murod From: Hieu Dang Duy To: Dhis2 Sent: Mon, March 8, 2010 2:49:55 PM Subject: [Dhis2-devs] Translation function - Stay at page after modified some thing Dear all, May I give to devs a small suggestion like this: I think we should keep for non-redirecting page after we've got some of saving for the object's translated value (name, shortname, description, ect ...) In the original case, after pressed Save button system would redirect from the sub-page (dhis/dhis-web-commons/i18n.action) to the main page (dhis-web-maintenance-datadictionary/dataElement.action). But I realized that it would be very very inconvenient and waste of time if we have to add so many the other translated values of each object for each corresponding locale. For example: I've got a string as "Doctor" in English. And then, I want to add some of new translated values with "Bác sỹ" in Vietnamese or "醫生" in Chinese or "Доктор" in Ukrainian. So, in this case we must go to 3 times for doing the same page (dhis/dhis-web-commons/i18n.action). Thanks ! -- Hieu.HISPVietnam Good Health ! ___ 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] Translation function - Stay at page after modified some thing
Hi Viet,
Follow this steps to add pagination. I am listing those areas that
added/modified for this, for the rest look at corresponding files attached.
SearchText could be handled in a way during Add/Remove so user comes back to
the last search criteria hi left. If this works than user will be always
focused into set of data, rather going back to the whole set and researching
again.
Add these properties to GetDataElementListAction.java.
private String searchText ="";
public String getSearchText() {
return searchText;
}
public void setSearchText(String searchText) {
this.searchText = searchText;
}
private int pageSize = 10;
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
private int currentPage = 0;
public int getCurrentPage() {
return currentPage;
}
public void setCurrentPage(int currentPage) {
this.currentPage = currentPage;
}
Change //dataElements = new ArrayList(
dataElementService.getAllDataElements() ); to
dataElements = new ArrayList(
dataElementService.getDataElements(currentPage, pageSize, searchText) );
Create dataElementService.getDataElements(currentPage, pageSize, searchText)
as such:
// helper method for query based search, needed to add %% to search string
and test if it is not null
private String getSearchPattern(String criteria) {
if (StringUtils.hasText(criteria)) {
return "%" + criteria.toLowerCase().replace('*', '%') + "%";
} else {
return "%%";
}
}
@SuppressWarnings("unchecked")
@Override
public Collection getDataElements(int currentPage,
int pageSize, String searchText) {
String pattern = getSearchPattern(searchText);
Session session = sessionFactory.getCurrentSession();
Criteria criteria = session.createCriteria( DataElement.class );
criteria.add(Restrictions.sqlRestriction("lower({alias}.name) like
lower(?)", pattern, Hibernate.STRING)); //this is needed only if you want
search functionality
return criteria.setMaxResults(pageSize).setFirstResult(currentPage *
pageSize).list();
}
Add these to dataelement.vm
for search at the top:
#parse( "/dhis-web-maintenance-datadictionary/search.vm" )
for pagination (prev/next) at the ned of table:
#if($currentPage>0)
#set( $prevPage = $currentPage - 1 )
$i18n.getString(
"command.prev")
#end
#if($count==$pageSize)
#set( $nextPage = $currentPage + 1 )
$i18n.getString(
"command.more")
#end
From: Viet Nguyen
To: Murodullo Latifov
Cc: Hieu Dang Duy ; Dhis2
Sent: Mon, March 8, 2010 3:10:45 PM
Subject: Re: [Dhis2-devs] Translation function - Stay at page after modified
some thing
On Mon, Mar 8, 2010 at 3:04 PM, Murodullo Latifov
wrote:
>
>Hi all,
>
>In this connection I also implemented server side pagination for dhis. This
>could be used in Dataelement listing, patient records, etc. There is also
>search facility working with pagination to narrow down scope. It may need
>speed comparison with existing single listings and other pros and cons.
>
>
>
>regards,
>murod
>
>
>
Hi,
I'm also planing to implement a paging util for patient module.
May I see your code :-)
pagination.7z
Description: Binary data
___
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] Pagination patch
Hi all, I created patch for pagination for Dataelement listing for truck head (1586) and send it via: bzr send -o pagination.patch. It did go and I don't know where did it actually go. Please check if it is there. 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] Pagination patch
Hi Jason, Just one point, on my initial post of server side pagination I said there is search option result of which in turn is paginated too (replacement for client side hiding/filtering), after better implementation and colorizing by Vietnamese guys, I don't know what happened to search option, which could solve most of issues with search/filtering, and maybe sorting. regards, murod - Original Message From: Jason Pickering To: Bob Jolliffe ; Lars Helge Øverland Cc: DHIS 2 developers Sent: Thu, April 22, 2010 11:50:21 AM Subject: Re: [Dhis2-devs] Pagination patch I have written up a blueprint here. It seems a bit wishy-washy when I read it now. Comments? https://blueprints.launchpad.net/dhis2/+spec/server-side-pagination ___ 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] Discussion from OpenMRS list related to data loading, legacy systems, ETL
Hi, Good point. I was talking long before on using ETL as generic and flexible way to be used for import/export compared to DXP or similar initiatives going on. There is no one size to fit all, at least for me. Bob did you find any solution so far, as I know you are working on import/export module? regards, murod From: Ola Hodne Titlestad To: DHIS 2 developers Sent: Thu, April 22, 2010 3:42:09 PM Subject: [Dhis2-devs] Discussion from OpenMRS list related to data loading, legacy systems, ETL This might be useful input to our ongoing data loading work: http://openmrs-mailing-list-archives.1560443.n2.nabble.com/Re-Details-on-Data-Migration-ETL-Module-tt4867404.html#a4867404 ___ 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] [Bug 627250] [NEW] GIS does not handle UTF-8 characters
Hi Viet, All is well? Did u manage to run PALO? with and without new directory? - Original Message From: Knut Staring To: dhis2-devs@lists.launchpad.net Sent: Tue, August 31, 2010 11:28:04 AM Subject: [Dhis2-devs] [Bug 627250] [NEW] GIS does not handle UTF-8 characters Public bug reported: While translation to French, Spanish and even Vietnamese seems to work weel, the GIS module does not seem able to handle languages like Chines, Hindi and Arabic encoded as UTF-8. See e.g. the attached Chinese translation ** Affects: dhis2 Importance: Undecided Status: New -- GIS does not handle UTF-8 characters https://bugs.launchpad.net/bugs/627250 You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. Status in DHIS 2 - District Health Information Software: New Bug description: While translation to French, Spanish and even Vietnamese seems to work weel, the GIS module does not seem able to handle languages like Chines, Hindi and Arabic encoded as UTF-8. See e.g. the attached Chinese translation ___ 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] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 112: Spanish localization added
Hi Knut, This was test run, I managed my bazaar eclipse to work again. Regarding repetition I guess is the fault of translation tool. Maybe it duplicates entries. I will look on files before commit. There are more file for Spanish locale to be committed. regards, murod From: Knut Staring To: nore...@launchpad.net Cc: DHIS 2 developers Sent: Thursday, March 26, 2009 9:13:13 AM Subject: Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 112: Spanish localization added Thanks Murod. It seems we have captured a lot of repetition in this file (basically the same thing 6 times). We probably only need the last part of the file, starting from #Resource generated by I18n Resource Editor #Mon Mar 09 20:52:45 GMT-05:00 2009 I suppose many of the other files will have similar repetition - this may be an area of improvement for the resoruce editor. Knut On Thu, Mar 26, 2009 at 8:36 AM, wrote: revno: 112 committer: murodlatifov branch nick: trunk timestamp: Thu 2009-03-26 08:34:19 +0100 message: Spanish localization added added: dhis-2/dhis-web/dhis-web-dashboard-integration/src/main/resources/org/hisp/dhis/dashboard/i18n_module_es_ES.properties === added file 'dhis-2/dhis-web/dhis-web-dashboard-integration/src/main/resources/org/hisp/dhis/dashboard/i18n_module_es_ES.properties' --- dhis-2/dhis-web/dhis-web-dashboard-integration/src/main/resources/org/hisp/dhis/dashboard/i18n_module_es_ES.properties 1970-01-01 00:00:00 + +++ dhis-2/dhis-web/dhis-web-dashboard-integration/src/main/resources/org/hisp/dhis/dashboard/i18n_module_es_ES.properties 2009-03-26 07:34:19 + @@ -0,0 +1,120 @@ +#Resource generated by I18n Resource Editor +#Wed Mar 04 17:18:20 GMT-05:00 2009 +olap_url=enlace (url) del OLAP +rss_hiv_aids=rss HIV/SIDA +data_mart_export=Exportar DataMart +this_is_a_link_area=Area de Enlace +report=Informe +this_is_a_chart_area=Area de Gr\u00E1fico +remove=Eliminar +clear=Limpiar +dashboard=Tablero de Instrumentos +rss_health=rss salud +rss_pregnancy=rss maternidad +insert=Insertar +close=Cerrar +#Resource generated by I18n Resource Editor +#Wed Mar 04 17:18:35 GMT-05:00 2009 +olap_url=enlace (url) del OLAP +rss_hiv_aids=rss HIV/SIDA +data_mart_export=Exportar DataMart +this_is_a_link_area=Area de Enlace +report=Informe +this_is_a_chart_area=Area de Gr\u00E1fico +remove=Eliminar +clear=Limpiar +dashboard=Tablero de Instrumentos +rss_health=rss salud +rss_pregnancy=rss maternidad +insert=Insertar +close=Cerrar +#Resource generated by I18n Resource Editor +#Wed Mar 04 17:53:42 GMT-05:00 2009 +olap_url=enlace (url) del OLAP +rss_hiv_aids=rss HIV/SIDA +data_mart_export=Exportar DataMart +this_is_a_link_area=Area de Enlace +report=Informe +this_is_a_chart_area=Area de Gr\u00E1fico +remove=Eliminar +clear=Limpiar +dashboard=Tablero de Instrumentos +rss_health=rss salud +rss_pregnancy=rss maternidad +insert=Insertar +close=Cerrar +#Resource generated by I18n Resource Editor +#Wed Mar 04 18:26:21 GMT-05:00 2009 +olap_url=enlace (url) del OLAP +rss_hiv_aids=rss HIV/SIDA +data_mart_export=Exportar DataMart +this_is_a_link_area=Area de Enlace +report=Informe +this_is_a_chart_area=Area de Gr\u00E1fico +remove=Eliminar +clear=Limpiar +dashboard=Tablero de Instrumentos +rss_health=rss salud +rss_pregnancy=rss maternidad +insert=Insertar +close=Cerrar +#Resource generated by I18n Resource Editor +#Wed Mar 04 18:28:12 GMT-05:00 2009 +olap_url=enlace (url) del OLAP +rss_hiv_aids=rss HIV/SIDA +data_mart_export=Exportar DataMart +this_is_a_link_area=Area de Enlace +report=Informe +this_is_a_chart_area=Area de Gr\u00E1fico +remove=Eliminar +clear=Limpiar +dashboard=Tablero de Instrumentos +rss_health=rss salud +rss_pregnancy=rss maternidad +insert=Insertar +close=Cerrar +#Resource generated by I18n Resource Editor +#Sun Mar 08 18:29:41 GMT-05:00 2009 +olap_url=Enlace (URL) del OLAP +rss_hiv_aids=rss VIH/SIDA +data_mart_export=Exportar DataMart +this_is_a_link_area=Area de Enlace +report=Informe +this_is_a_chart_area=Area de Gr\u00E1fico +remove=Eliminar +clear=Limpiar +dashboard=Tablero de Instrumentos +rss_pregnancy=rss Maternidad +rss_health=rss Salud +insert=Insertar +close=Cerrar +#Resource generated by I18n Resource Editor +#Sun Mar 08 18:31:30 GMT-05:00 2009 +olap_url=Enlace (URL) del OLAP +rss_hiv_aids=rss VIH/SIDA +data_mart_export=Exportar DataMart +this_is_a_link_area=Area de Enlace +report=Informe +this_is_a_chart_area=Area de Gr\u00E1fico +remove=Eliminar +clear=Limpiar +dashboard=Tablero de Instrumentos +rss_pregnancy=rss Maternidad +rss_health=rss Salud +insert=Insertar +close=Cerrar +#Resource generated by I18n Resource Editor +#Mon Mar 09 20:52:45 GMT-05:00 2009 +olap_url=Enlace (URL) del OLAP +rss_hiv_aids=rss VIH/SIDA +data_mart_export=Exportar DataMart +this_is_a_link_area=Area de Enlace +report=Informe +this_is_a_chart_area=Area de Gr\u00E1fico +remove=Eliminar +clear=Limpiar +
[Dhis2-devs] Migrating to Struts2
Hi, It seems migrating from webwork to struts2 is quite possible with small efforts. I managed to run importexport module using services that deploy struts2 configuration and libraries. I think we should move to struts2 as webwork is not updated since june 2007. Any other ideas? 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] Checkout bazar dhis
Hi Lester, First you need to register with launchpad, after follow instructions in the following link: https://help.launchpad.net/YourAccount/CreatingAnSSHKeyPair Go by Putty way. murod - Original Message From: "lgutierr...@infomed.sld.cu" To: Murodullo Latifov Sent: Thursday, April 9, 2009 10:59:52 PM Subject: Re: [Dhis2-devs] Checkout bazar dhis Hi Murod! All is well here, just trying to update my code, seeing a lot of changes in there. I'm using windows installer but I haven't read anything about keys. Could you tell me about it or point me to where I can read about it? Thank you very much!! Regards Lester Quoting Murodullo Latifov : > > Hi Lester, > > Hope all is going well. Are you using cygwin or windows installer? Did you > create > public and private keys and placed them where they should be? > > regards, > murod > > > > - Original Message > From: "lgutierr...@infomed.sld.cu" > To: dhis2-devs > Sent: Thursday, April 9, 2009 9:58:24 PM > Subject: [Dhis2-devs] Checkout bazar dhis > > > > Hi! > > Could some one help me? I want to check out the dhis2 code and I follow the > directions > given in the page but all I get is socket error. Is there any place to > configure my > proxy > and where to go? Are there some instruction I should follow. Please don't > tell me to > read > the entire manual :-) > > saludos > Lester > > -- > Infomed - Red de Salud de Cuba > http://www.sld.cu/ > > > --- > Red Telematica de Salud - Cuba > CNICM - Infomed > > ___ > 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 > > > > > -- Infomed - Red de Salud de Cuba http://www.sld.cu/ --- Red Telematica de Salud - Cuba CNICM - Infomed ___ 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] Checkout bazar dhis
Hi Knut, Both links you provided are not working. Is that server running? I tried http://208.76.222.114/confluence still nothing happened. regards, murod. From: Knut Staring To: Murodullo Latifov Cc: lgutierr...@infomed.sld.cu; DHIS 2 developers Sent: Friday, April 10, 2009 10:32:29 AM Subject: Re: [Dhis2-devs] Checkout bazar dhis If you are not planning to commit code back to the repo, it is easier to just make a branch, as described here: http://208.76.222.114/confluence/display/DOC/Downloading+the+source+code For that, there is no need for SSH keys etc in order to just get an updated version of the code. Knut On Thu, Apr 9, 2009 at 11:16 PM, Murodullo Latifov wrote: Hi Lester, First you need to register with launchpad, after follow instructions in the following link: https://help.launchpad.net/YourAccount/CreatingAnSSHKeyPair Go by Putty way. murod - Original Message From: "lgutierr...@infomed.sld.cu" To: Murodullo Latifov Sent: Thursday, April 9, 2009 10:59:52 PM Subject: Re: [Dhis2-devs] Checkout bazar dhis Hi Murod! All is well here, just trying to update my code, seeing a lot of changes in there. I'm using windows installer but I haven't read anything about keys. Could you tell me about it or point me to where I can read about it? Thank you very much!! Regards Lester Quoting Murodullo Latifov : > > Hi Lester, > > Hope all is going well. Are you using cygwin or windows installer? Did you > create > public and private keys and placed them where they should be? > > regards, > murod > > > > - Original Message > From: "lgutierr...@infomed.sld.cu" > To: dhis2-devs > Sent: Thursday, April 9, 2009 9:58:24 PM > Subject: [Dhis2-devs] Checkout bazar dhis > > > > Hi! > > Could some one help me? I want to check out the dhis2 code and I follow the > directions > given in the page but all I get is socket error. Is there any place to > configure my > proxy > and where to go? Are there some instruction I should follow. Please don't > tell me to > read > the entire manual :-) > > saludos > Lester > > -- > Infomed - Red de Salud de Cuba > http://www.sld.cu/ > > > --- > Red Telematica de Salud - Cuba > CNICM - Infomed > > ___ > 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 > > > > > -- Infomed - Red de Salud de Cuba http://www.sld.cu/ --- Red Telematica de Salud - Cuba CNICM - Infomed ___ 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] pom files
- Original Message From: Bob Jolliffe To: Murodullo Latifov Cc: dhis2-devs Sent: Tuesday, April 14, 2009 3:04:05 PM Subject: pom files Hi Murod Hope this finds you well. I remember you were busy in Delhi rationilizing the pom files in the dhis2 project. Did you get this finished? It would be good to be able to build/debug/profile through a single project. Regards Bob Hi Bob, Yes, there changes to be made on poms to make dhis2 as single project. Also there are special requirements/plugins to get project into eclipse. I will write on mailing list soon on how to run/debug modules with WTP (develop as you deploy, maven-eclipse-tomcat), etc., but I need to discuss this with Lars before that. What I have done is on module level, projectwise it needs more work. Now I am working on webwork to struts2 migration as well as upgrading hibernate to latest release and use of annotations (JPA and Hibernate). These all should be discussed in mailing list before we take steps, because they are major changes and need surrow revision and testing. So, lets start on discussing these issues on WHYs, HOWs WHOs and WHENs scopes. 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] pom files
Hi Lars,
From: Lars Helge Øverland
To: Bob Jolliffe
Cc: Murodullo Latifov ; dhis2-devs
Sent: Tuesday, April 14, 2009 4:04:32 PM
Subject: Re: [Dhis2-devs] pom files
On Tue, Apr 14, 2009 at 3:41 PM, Bob Jolliffe wrote:
Hey Murod good to hear from you.
2009/4/14 Murodullo Latifov :
> Hi Bob,
>
> Yes, there changes to be made on poms to make dhis2 as single project. Also
> there are special requirements/plugins to get project into eclipse. I will
> write on mailing list soon on how to run/debug modules with WTP (develop as
> you deploy, maven-eclipse-tomcat), etc., but I need to discuss this with Lars
> before that. What I have done is on module level, projectwise it needs more
> work.
> Now I am working on webwork to struts2 migration as well as upgrading
> hibernate to latest release and use of annotations (JPA and Hibernate). These
> all should be discussed in mailing list before we take steps, because they
> are major changes and need surrow revision and testing.
>
> So, lets start on discussing these issues on WHYs, HOWs WHOs and WHENs scopes.
Murod,
- What do you mean by upgrading to the latest Hibernate release? We are already
running the latest one in the maven repo, 3.2.6.ga.
- What would be the reason for switching to Hibernate/JPA annotations?
- Why are you working with struts2 migration? Have we decided to switch? Is
this something we should prioritize right now as there are lots of pressing
requirements, like the list we put down a few weeks ago?
Lars
Yes, we have a list of pressing requirements, one is implementing
"easy-access-help" and the other is "datavalue-history". For implementing first
one I had small discussion with you, and we decided that I will look shortly if
migrating from webwork to struts2 is possible. I managed to migrate one module
to run on struts2, it is possible but takes some time and efforts. As all of us
know webwork is not updated since mid 2007. "easy access help" was implemented,
now I am working on second one. Hibernate has support for auditing persistent
objects ("datavalue history"), that is what we want. But it comes with
annotations only, so I decided to change hibernate libraries to host
annotations, this is the reason. I think using existing functionality is much
better than hand crafting history object for datavalue table. Latest Hibernate
Core is 3.3.1.GA and Hibernate Annotations is 3.4.0 GA.
Why I said to Bob I am wotrking on this and that is because I have all in my
branch and cannot split easily what he wants (poms). I cannot distribute pom
with new hibernate dependencies, struts2, etc. That's WHY I said lets discuss
these issues before we have made such a change. It is better to discuss how to
make these things happen, if they are useful. For hibernate I can say
transision is transparent, we can move one object to annotation, while others
are still in hbm.xml. For struts2 the same applies to some extend.
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] pom files
Hi Bob, < I think that it would be really useful to be able to fix the poms with < the existing dependencies rather than wait for the outcome of what < might be a long and uncertain process. If you can just send the poms < I'd love to have a look. I'm far from a maven expert, but I'm getting < better. < < On unix like systems (including probably cygwin): < find . -iname pom.xml |zip poms.zip -@ edit main pom and add dhis-web as module. edit dhis-web pom and add dhis-web-portal as module dhis dhis-api dhis-i18n dhis-options dhis-services dhis-support dhis-useradminandsecurity dhis-web dhis-web dhis-web-commons dhis-web-commons-resources dhis-web-maintenance dhis-web-dataentry dhis-web-importexport dhis-web-datamart dhis-web-validationrule dhis-web-reporting dhis-web-gis dhis-web-openhealth-integration dhis-web-dashboard-integration dhis-web-jforum-integration dhis-web-portal dhis-web-commons-struts2 dhis-web-commons-resources-struts2 dhis-web-importexport-struts2 don't run mvn eclipse:eclipse open eclipse install tomcat from menu window - preferences - server install maven multiproject import plugin http://eclipse-tools.sourceforge.net/updates/ install m2eclipse plugin http://m2eclipse.codehaus.org/update/ import dhis2 code using maven multiproject plugin (this should be under import - general - maven projects). You should see list of all projects in a hierarchy view. to compile web modules run… tick off resolve project artefacts checkbox (bug) to debug use debug - on server. goal - install to run single web module right click on it, select run on server. currently war overlaying is not supported by m2eclipse, so copy missing files in tomcat work directory from target/module name/ manually. I didn't configure any profiler, so no idea on that. I might missed something, feel free to ask. be careful, commit your code before these tasks. 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] pom files
no, that was my misconfiguration in eclipse. - Original Message From: Bob Jolliffe To: Murodullo Latifov Cc: Lars Helge Øverland ; dhis2-devs Sent: Tuesday, April 14, 2009 7:47:44 PM Subject: Re: [Dhis2-devs] pom files Thanks Murod. 2009/4/14 Murodullo Latifov : > > Hi Bob, > > > < I think that it would be really useful to be able to fix the poms with > < the existing dependencies rather than wait for the outcome of what > < might be a long and uncertain process. If you can just send the poms > < I'd love to have a look. I'm far from a maven expert, but I'm getting > < better. > < > < On unix like systems (including probably cygwin): > > < find . -iname pom.xml |zip poms.zip -@ > > > edit main pom and add dhis-web as module. edit dhis-web pom and add > dhis-web-portal as module > dhis That makes sense. I thought you had mentioned some circular references before? Regards Bob > >dhis-api >dhis-i18n >dhis-options >dhis-services >dhis-support >dhis-useradminandsecurity >dhis-web > > > dhis-web > > >dhis-web-commons >dhis-web-commons-resources >dhis-web-maintenance >dhis-web-dataentry >dhis-web-importexport >dhis-web-datamart >dhis-web-validationrule >dhis-web-reporting >dhis-web-gis >dhis-web-openhealth-integration >dhis-web-dashboard-integration >dhis-web-jforum-integration >dhis-web-portal >dhis-web-commons-struts2 >dhis-web-commons-resources-struts2 >dhis-web-importexport-struts2 > > > > don't run mvn eclipse:eclipse > > open eclipse > > install tomcat from menu window - preferences - server > > install maven multiproject import plugin > http://eclipse-tools.sourceforge.net/updates/ > > install m2eclipse plugin http://m2eclipse.codehaus.org/update/ > > import dhis2 code using maven multiproject plugin (this should be under > import - general - maven projects). You should see list of all projects in a > hierarchy view. > > to compile web modules > run… tick off resolve project artefacts checkbox (bug) > to debug use debug - on server. > goal - install > > to run single web module right click on it, select run on server. > > currently war overlaying is not supported by m2eclipse, so copy missing files > in tomcat work directory from target/module name/ manually. > > I didn't configure any profiler, so no idea on that. > > I might missed something, feel free to ask. be careful, commit your code > before these tasks. > > 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
[Dhis2-devs] Bazaar
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] Bazaar
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] Dynamic option list in data entry
Hi, I don't know much about the logic behind this, but talking on technical side of it. To have drop down on custom dataentry screen we do not need to persist any dataValueOption object and its collection. We can bind all possible values while binding dataelement combo to custom dataentry HTML, e.g. datavalue options are stored in HTML as "select bla bla bla" saved. As dataelement is related to dataset and values are available in dropdown there should not be a problem with dataset to dataelement relation. So, this means creating custom forms for such data entry is a must as datavalueoption is not persisted in database and there is no relation defined as such. This is simple solution to make set of value options mandatory for data entry. Any other crazy and cool ideas? regards, murod P.S: By the way this could be extended to persist this relation in database, but seems unnecessary. From: Calle Hedberg To: Lars Helge Øverland ; miri ; Calle Hedberg ; DHIS 2 developers Cc: vs...@hisp.org Sent: Saturday, April 18, 2009 1:10:49 PM Subject: Dynamic option list in data entry Lars, You definitely want to bind those values to a combination of data set and data element, because different data sets will have different scopes. This should be even more obvious when moving into survey data, where drop-downs are a must. Simple example: You have two data sets related to different types of disease notifications – let us say one is about haemorrhagic fevers (ebola, Marburg, etc) and the other about vaccination related diseases. Both data sets are using the data element “Diagnosis” or “Disease”, but the possible diagnoses for each will be different. You do not want “measles” to appear when capturing haemorrhagic fever data, and you do not want “Marburg” to appear when you capture vaccine-related diseases. Regards Calle From:Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 18 April 2009 12:54 PM To: miri; Calle Hedberg; Calle Hedberg; DHIS 2 developers Subject: Re: [Blueprint dynamic-option-list-in-data-entry] Dynamic option list in data entry On Sat, Apr 18, 2009 at 12:37 PM, miri wrote: Blueprint changed by miri: Whiteboard changed to: What this dynamic values used for? Is this dynamic value used in more than one dataset? If this is single time usage, we could implement it using dataset custom form edit functionality (creating drop down with custom values). By single I mean only one form uses this set of predefined data values. -- Dynamic option list in data entry https://blueprints.launchpad.net/dhis2/+spec/dynamic-option-list-in-data-entry This is a good question. Binding a set of dynamic values to one data element would be simple and nice. DHIS 1.4 is binding a set of dynamic values to a combination of data element and data set, making things even more flexible. There is probably a good reason for that. Will have to explore this further. ___ 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] Dynamic option list in data entry
Hi, i see your point in that this would be easy and it would probably work. But it sounds a little static to me. Wouldn't we want to have some pre-defined and re-usable comments? Also, we definitely should have this for regular and multidimensional data entry as well. I guess it is needed and otherwise we are making things inconsistent... Hi, regular and multidimentional data entry is already inconsistent with custom data entry. If custom data entry has dataset consisting two different set of dataelement comboid combinations it will show only the first dataelement comboid combination, not the rest. Maybe my installation does not this. Comments for my opinion should not be predefined, user should have freedom to fill in what he wants to comment. what if his desire is not listed on predefined options? ___ 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] My branch
Hi, I have committed my branch, it is somewhere in repository. This branch has two new functionalities and 3 struts2 modules and changes to poms, new dependencies, one of which is not in maven2 repo.I couldn't find it anywhere in launchpad. I am also not able to change any settings for blueprints assigned to me, it says i don't have enough privileges to perform this action. 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] My branch
Ok, I will copy/paste 'easy help' and 'dataelement history' into trunk. struts2 modules are independent of other modules, original modules are still there, its just a matter of removing them as name from poms to exclude from compilation, code could be there for reference. But still fine we can do that later. 'easy help access' needs further work by manual writers. First we need to test it and then manual writers should add tags and translation strings accordingly. 'dataelement history' also needs causion, it has dependency which is not in maven2 repository at this time. I will commit, you can revert in case, is this ok? regards, murod From: Lars Helge Øverland To: Murodullo Latifov Cc: DHIS 2 developers Sent: Saturday, April 18, 2009 2:38:54 PM Subject: Re: [Dhis2-devs] My branch On Sat, Apr 18, 2009 at 2:21 PM, Murodullo Latifov wrote: Hi, I have committed my branch, it is somewhere in repository. This branch has two new functionalities and 3 struts2 modules and changes to poms, new dependencies, one of which is not in maven2 repo.I couldn't find it anywhere in launchpad. I am also not able to change any settings for blueprints assigned to me, it says i don't have enough privileges to perform this action. regards, murod Hi Murod, it would be very nice if you could separate the struts upgrade code from the rest as we definitely don't want to have 3 of the web modules as struts and the rest with webwork. I know it's too late in this case, but it's good to develop different features in different branches. In this case I guess it must be done manually. Would be nice if you could do it, otherwise someone else will have to do it... I will have a look at how to push branches soon. cheers 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] My branch
'easy help access' needs further work by manual writers. First we need to test it and then manual writers should add tags and translation strings accordingly. 'dataelement history' also needs causion, it has dependency which is not in maven2 repository at this time. I will commit, you can revert in case, is this ok? Frankly I don't think we should add dependencies that are not in the central maven repo. It makes it harder for other developers. We could set up our own / use the one on hisp.info, but this server has not been stable at all lately andit feels better to only be dependent on the central one. Also, I have had some second thoughts about this solution... Isn't it a little overkill to change the persistence framework to accomplish this task? I agree that we should not reinvent the wheel and so on but in this case it seems just a matter of creating a DataValueModification object (or similar) and make add- and getall- functions. Also, this makes us dependent on Hibernate. We have seen talk of switching the persistence layer. In that case this function must be re-implemented. If we put it in the service layer it will remain. Not saying I have the answer, just a little sceptical, what do you think? Hi Lars, We have many threads talking on easy installation, maintenance, porting to different environments, etc. What is the rational to move out of hibernate? Hibernate provides complete control and maintenance of underlying database. Can you imagine if someone in the field installs DHIS2 or upgrades and there are database schema changes? I don't think he will succeed if we are not using hibernate. iBATIS does not this, JPA does not, moreover they are database dependent, especially iBATIs. If we decide to go iBATIS, it is not good idea, than it becomes type of javascript, kill bug for mySql, kill bug for Postgress, H2, H3, H365. Here is some research done: http://seasar.javaeye.com/blog/233951. Sorry that I am talking to much but to honest we should make decisions that give long term solutions. Spring (AOP, DI, Security), Hibernate, MySQL, Struts2 or Spring MVC are well integrated, tons of documwentations. I am SQL and SP guy, but still feel hibernate is perfect solution for DHIS2 context. We have very few experts in the field and maintenance becomes a bottleneck if we don't use hibernate. We should learn and improve hibernate, make its performance faster. Other thing I want to point here is use of @nnotations. If we manage to implement all this, we have to write POJOs, say @Entity, @Secured, @Audited and thats all. We have many blueprint marks, which fall into this category, type of general consideration, which IMHO should be discussed and decided in combination (Spring Hibernate, Spring Security...). I would call core developers to have skype discussion or actively participate into discussions before we come to make certain "general rules", which should be followed after and we don't face deadlocks (time spent for development, resources used). Like we have saying, make code Java1.5 compliant, this is known and all follow it. And if we decided to move out of hibernate for some reason, we should state that, by the same means as java1.5, remove such dependencies from pom and thats it. Its bad that I am sometimes on and off depending on my research needs, I might have missed some points made by others earlier, please correct me if I am wrong. 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] My branch
Other thing I want to point here is use of @nnotations. If we manage to implement all this, we have to write POJOs, say @Entity, @Secured, @Audited and thats all. We have many blueprint marks, which fall into this category, type of general consideration, which IMHO should be discussed and decided in combination (Spring Hibernate, Spring Security...). These are exiting features. These annotations are general for Java 5 right? In that case the code will stay unaware of which persistence framework is being used. My argument of being dependent of Hibernate is then invalid. No, these annotations are hibernate, spring, JPA dependent, they are java 5 compliant. If we don't deploy envers.jar we cannot use @Audited, as it is implemented there. ___ 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] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 193: Easy help implementation. This implementation will bring up popup with content related to particu...
Hi Lars, see comments in line. From: Lars Helge Øverland To: DHIS 2 developers Sent: Monday, April 20, 2009 10:54:26 AM Subject: Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 193: Easy help implementation. This implementation will bring up popup with content related to particu... Hi Murod, thanks for working on this. I have a few questions: - Where are the "localization lang properties files" supposed to be located? Those unde dhis-web-commons - How are these properties supposed to be loaded in the HelpService object? $i18n.getString( $helpService.getHeader() ) $i18n.getString( $helpService.getContent() ) - There is a typo in your reponseSuccess.vm file name. Yes, it is bare copy from Tri's work on GIS2 module, later I dicovered this too. - The view help action class defines a result for ERROR to be responseError.vm. This file does not exist and the action class does not have this result. Yes, it is missing as in Tri's module. Normally system provides its own error message in case. We can remove that from action declaration. - The HelpService looks to me more of a POJO as there is no logic in there. If it is we could rename it to HelpContent. If it is a service it should have an interface. Correct, it is simplest POJO passed as action result, but followed existing convention. HelpContnent is good name for it, even this class could exists next to Action itself or java.util.List of Strings could be used too. cheers Lars HelpContent content = new HelpConent( On Sat, Apr 18, 2009 at 4:44 PM, wrote: revno: 193 committer: Miri branch nick: trunk timestamp: Sat 2009-04-18 16:42:14 +0200 message: Easy help implementation. This implementation will bring up popup with content related to particular control. In order to add 'easy help' to any control or menu link the following tag should be placed next to it: 'datasetsecmanfilter' should be different for each tag inserted. 'datasetsecmanfilter' is short for 'data set section management filter'. When help icon clicked for this control (available on Maintenance Datasets) two localized strings will be displayed for user on popup: help.datasetsecmanfilter help.datasetsecmanfilter.content These two properties should be placed in localization lang.properties file and relative text provided. After adding these two strings you can see it in action by clicking help icon next to control again. added: dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/help/ dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/help/HelpService.java dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/help/reponseSuccess.vm dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/images/help_blue.gif dhis-2/dhis-web/dhis-web-commons/src/main/java/org/hisp/dhis/help/ dhis-2/dhis-web/dhis-web-commons/src/main/java/org/hisp/dhis/help/action/ dhis-2/dhis-web/dhis-web-commons/src/main/java/org/hisp/dhis/help/action/PopupHelpAction.java modified: dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/main.js dhis-2/dhis-web/dhis-web-commons/src/main/resources/META-INF/dhis/beans.xml dhis-2/dhis-web/dhis-web-commons/src/main/resources/dhis-web-commons.xml dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataset/src/main/webapp/dhis-web-maintenance-dataset/dataSetList.vm dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataset/src/main/webapp/dhis-web-maintenance-dataset/menu.vm === added directory 'dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/help' === added file 'dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/help/HelpService.java' --- dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/help/HelpService.java 1970-01-01 00:00:00 + +++ dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/help/HelpService.java 2009-04-18 14:42:14 + @@ -0,0 +1,52 @@ +package org.hisp.dhis.system.help; + +/* + * Copyright (c) 2004-2009, University of Oslo + * All rights reserved. + * + * Redistribution and use in source and binary forms, with or without + * modification, are permitted provided that the following conditions are met: + * * Redistributions of source code must retain the above copyright notice, this + * list of conditions and the following disclaimer. + * * Redistributions in binary form must reproduce the above copyright notice, + * this list of conditions and the following disclaimer in the documentation + * and/or other materials provided with the distribution. + * * Neither the name of the HISP project nor the names of its contributors may + * be used to endorse or promote products derived from this software without + * specific prior written permission. + * + * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS A
Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 193: Easy help implementation. This implementation will bring up popup with content related to particu...
Hi Lars, I have a few questions: - Where are the "localization lang properties files" supposed to be located? Those unde dhis-web-commons OK. Could you add them? And add some "sample" help properties so that people can see how it is done? Files are their - i18n_global_en_GB.properties. - How are these properties supposed to be loaded in the HelpService object? $i18n.getString( $helpService.getHeader() ) $i18n.getString( $helpService.getContent() ) Yes, but that is for displaying the content. I was wondering how the properties are loaded from the properties file and into the HelpService / HelpContent object...? Yes, the only thing we need is to display content, which is responsibility of i18n object, which we delegate to do so by passing string property names we need. $i18n.getString( $helpService.getHeader() ) converts to $i18n.getString( 'help.datasetmanmenu' ) and finally we get 'Dataset Management Menu'. 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] Roadmap issues
On Thu, Apr 23, 2009 at 9:46 PM, Saptarshi Purkayastha wrote: We could definitely do this by using the timeStamp property on DataValue and let the user specify a "since" date in the export GUI. But the user is already specifying which months to export data for, typically only the last month so I am not sure how much we would save on the file size... I was suggesting times when only few datavalues were changed in a given period. Say for the last year's data, we changed only a few values and the last month's data was not exported earlier. I would then need to export 13 month's of data, whereas we can just export those diff datavalues (changes from last year and this month's data) Sure. I think Lars by saying "sure" means it is possible using dataValue timeStamp field. If you modified some data for last year (don't know why? or this is allowed to do so after data have been reported?) in this month timeStamp will be the date of change ocured. So we need functionality which allows selecting certain date periods, like from this to that and so on. mesh4x proposed by Knut seems quite valuable tool, need time to look at. 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] About spanish translation v2.0.1
Hi Lester, When I got your translations, it had many copies of the same string . I deleted all except the last time stamp. Maybe some translations are lost in this connections, you can post another proper copy, also there are new changes that might not been translated to spanish, need update. Regarding help file, we have implemented easy help module and soon we will provide default translations and you can easily translate to spanish. General help is under review and soon we will update all about. regards, murod. - Original Message From: Lester Gutierrez Campo To: dhis2-devs Sent: Saturday, May 2, 2009 8:07:46 PM Subject: [Dhis2-devs] About spanish translation v2.0.1 Hi! I downloaded the 2.0.1 version and for my surprise saw spanish translation of the menu items was incomplete and some of them are in their first old form (machine translated). Could someone fix that, please? Other issue is the spanish help file. It doesn't exist so when you configured the programm in spanish and try to see the help it throws an exception. I know it's part my fault to haven't finished the spanish translation of the help file but I think there should be a file named "help_sp_SP.vm" as a help file though saying "La ayuda en español estara pronto disponible" (Help in spanish soon will be ready) :-) It would be more "elegante" I know I'm probably the only one to try dhis2 in spanish but I think this could be important in the future. Sorry if I sound bossy :-) Best regards Lester --- Red Telematica de Salud - Cuba CNICM - Infomed ___ 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] weeks calculation
Hi Caveman, - Original Message From: Orvalho Joaquim Augusto To: dhis2-devs Sent: Monday, May 11, 2009 2:57:42 AM Subject: [Dhis2-devs] weeks calculation I could not find on dhis2 docs so I am asking: How dhis2 calculate the weeks? The first week of a year for example. Weekly periods are calculated based on their start date. If start date of the given week is on the previous year, end date of that period is used. Also Saturday is used as first day of the week. Thank you Caveman ___ 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] Errors on Dataentry
Hi, The problem you are pointing is a bug, when you try to comment on dataelement, which has no value assigned, this error will be thrown. It seems you have no value assigned for that dataelement/combo for that org unit for that period. regards, murod - Original Message From: Orvalho Joaquim Augusto To: dhis2-devs Sent: Tuesday, May 12, 2009 1:29:44 AM Subject: [Dhis2-devs] Errors on Dataentry I have data on datavalue table tha is mannually filled - I have no way to avoid it. And I keep having this error on catalina log: May 12, 2009 1:27:24 AM org.apache.velocity.runtime.log.JdkLogChute log SEVERE: Right side ($encoder.htmlEncode( $dataValue.comment )) of '==' operation has null value. If a reference, it may not be in the context. Operation not possible. /dhis-web-dataentry/form.vm [line 132, column 120] And I can not see my data on the form. Can someone help? Caveman ___ 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] Errors on Dataentry
Hi, It also might be due to null values on datavalue table. If you have followed my suggestions on separate mail, it will result in 60,000 more records with null or empty values, which could be the cause. You can easily delete them as they have no value in all means. regards, murod. P.S. Did you import these data from other sources? - Original Message From: Orvalho Joaquim Augusto To: Murodullo Latifov Cc: dhis2-devs Sent: Tuesday, May 12, 2009 10:30:32 AM Subject: Re: [Dhis2-devs] Errors on Dataentry Thanks! :-o Caveman Murodullo Latifov wrote: > Hi, > > The problem you are pointing is a bug, when you try to comment on > dataelement, which has no value assigned, this error will be thrown. It seems > you have no value assigned for that dataelement/combo for that org unit for > that period. > regards, > murod > > > > - Original Message > From: Orvalho Joaquim Augusto > To: dhis2-devs > Sent: Tuesday, May 12, 2009 1:29:44 AM > Subject: [Dhis2-devs] Errors on Dataentry > > I have data on datavalue table tha is mannually filled - I have no way to > avoid it. > > And I keep having this error on catalina log: > May 12, 2009 1:27:24 AM org.apache.velocity.runtime.log.JdkLogChute log > SEVERE: Right side ($encoder.htmlEncode( $dataValue.comment )) of '==' > operation has null value. If a reference, it may not be in the context. > Operation not possible. /dhis-web-dataentry/form.vm [line 132, column 120] > > And I can not see my data on the form. > > Can someone help? > > Caveman > > > ___ > 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] Errors on Dataentry
Hi, - Original Message From: Orvalho Joaquim Augusto To: Murodullo Latifov Cc: dhis2-devs Sent: Tuesday, May 12, 2009 11:08:26 AM Subject: Re: [Dhis2-devs] Errors on Dataentry Yes we import from other sources. It is a non DHIS2 related source. In that private mail I reported that we had some stuff that check, after importation those null space on datavalue. We used to place an ''. That worked fine for months. But for weeks (actually the source has many holes on data) those error started. We will proceed as you suggest. You said it was a bug. Do we have a night build war with corections? Thanks Caveman No, that bug is not fixed yet. Why do you need " values? Why not to delete them? Can you explain more on nature of errors or steps you follow to lead to that errors? What means (actually the source has many holes on data)? 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] weeks calculation
Hi Bob, - Original Message From: Bob Jolliffe To: dhis2-devs Sent: Tuesday, May 12, 2009 12:52:58 PM Subject: Re: [Dhis2-devs] weeks calculation Hi cave persons 2009/5/11 Murodullo Latifov : > How dhis2 calculate the weeks? The first week of a year for example. > > Weekly periods are calculated based on their start date. If start date of the > given week is on the previous year, end date of that period is used. Also > Saturday is used as first day of the week. > It seem this business of Saturdays is a red herring and is not true. Weekly periods are defined by a start date being a Monday and an end date being a Sunday (though this doesn't seem to be enforced anywhere - it probably should be). We can see this in the list of periods which are calculated in generatePeriods in WeeklyPeriodType.java. The list are all all Monday-Sunday periods. It is however a bit buggy. What I can confirm from generating loads of period lists from various starting dates is 1. DHIS (using the java default) does indeed have an ISO8601 interpretation of week number. That is the first week of any given year is a the first week with a Thursday in it. It is good we stick with this. Makes it easy to answer the question "how does DHIS2 handle week numbers?". 2. Perhaps somebody who initially wrote this code seemed not quite to appreciate how this works, which means, for example, that when we generate the period list for the week of 29-12-2009 to 03-01-2010 we end up with a list starting with week 1 of 2010, which doesn't actually include the given week. The same thing happens in the end of 2005. I don't know if this is at the root of Orvalho's problem (I haven't yet seen his data), but it is clearly important when moving weekly data from one system to another. Meanwhile I can fix the generatePeriods method so that it will always generate the correct list of periods for any given period. Before I do so please confirm that it will not break any existing data, reports or what have you. The implication being that generatePeriods called on the week of 29-12-2009 to 03-01-2010 will generate the list of weeks for 2009, not 2010. And more obviously, the week of 26-12-2005 to 1-01-2006 generates the list of weeks for 2005, not 2006. Cheers Bob I think you can modify code to work correctly as long as it does not change start and end date generated in period table. DHIS weeks start at Sunday and end by Saturday, at least in Mozambique database, how did you come to Monday - Sunday? 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] weeks calculation
Hi Caveman, - Original Message From: Orvalho Joaquim Augusto To: Bob Jolliffe Cc: dhis2-devs Sent: Tuesday, May 12, 2009 2:08:43 PM Subject: Re: [Dhis2-devs] weeks calculation Well Yes this a problem for us. Because we expect to use correctly DHIS [reporting tools for now] and we need to map exactly the periods from the actual system to DHIS. But meanwhile there is a another problem with a lot of empty data on that system. Mine foucus has been on that and I forgot for a while these dateweeks troubles. Anyway, can you corect the DHIS2 code please to calculate weekdates? If it is buggy. Regards Caveman Are current periods in Mozambican database generated by DHIS or they are also imported from elsewhere? 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] Providing another source table for reports
Hi Cintia,
From: Cintia Marisa
To: dhis2-devs@lists.launchpad.net
Sent: Wednesday, May 13, 2009 9:22:14 AM
Subject: [Dhis2-devs] Providing another source table for reports
Hi all,
I'm trying to build the reports without using the Report Tables tools.
When i add new report on dhis it gives a chance to provide another data source
different from the report tables (" If selecting no report table, the user is
responsible for providing the data source table. ").
I just don't know how to tell DHSI that I want to use another data source.
Any help on how to accomplish this?
Thanks in advance
--
Cintia Marisa
You can use BIRT to include your dataset. Simply create dataset under
outline->DataSet. Simply choose "SQL select query" and make you sql statement
on next screen, like "select * from yourtable where ..."
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] weeks calculation
Hi, It worth looking if java uses DHIS locale or it uses system locale for Calendar. I think if java is not set to use any locale, it will turn to OS locale, if this is the case two machines running DHIS as server with different locales will end up with two different week calculations, if locales have different view of weeks. 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] Providing another source table for reports
e table to be created, and it
> doesn't seem to keep the keys to link the data elements, periods
> and organization units as I need.
>
> In the reports I'm making i need to have cross tabulated data
> with org units, data elements and periods.
>
> I know report tables are mean to make my work easier, but i
> can't get them to provide the data the way I need.
>
> Thanks for the support.
>
>
>
>
>
> On Wed, May 13, 2009 at 11:21 AM, Ola Hodne Titlestad
> mailto:ol...@ifi.uio.no>> wrote:
>
> Hi,
>
> When using standard reports (BIRT reports in DHIS 2) the
> only limitation is that you need to use the DHIS 2 database
> as your source, but within that database you can create BIRT
> datasets based on any table or view as you like. This is
> simply because DHIS replaces the database connection string
> in the BIRT design file when you upload the report. This is
> done to make sure that the data source is available.
>
> Still, I'm wondering why you do not want to use report
> tables? Report tables are generic and very flexible and can
> provide routine data sources for your reports that are
> automatically updated to e.g. the latest month, the last
> quarter, acculmulative values so far this year and more.You
> can also specify exactly which data elements or indicators
> to use. Furthermore, report tables also allow for report
> paremeters where you can specify which orgunit to show data
> for, or all children below a selected orgunit, and also
> which month to use, so that you can reuse your design for
> many purposes. Report tables are small and automatically
> generated datamarts that you can use out of the box while
> other data sources most liley will need some kind of manual
> update like an export to datamart or similar.
>
> You can read more about report tables here:
>https://answers.launchpad.net/dhis2/+question/61455
>https://answers.launchpad.net/dhis2/+faq/370
>
>
> What kind of report are you designing and what made you
> choose not to use report tables?
>
> best regards,
> Ola Hodne Titlestad
> HISP
> University of Oslo
>
>
> On Wed, May 13, 2009 at 10:40 AM, Murodullo Latifov
> mailto:murodlati...@yahoo.com>> wrote:
>
> Hi Cintia,
>
>
>
> *From:* Cintia Marisa <mailto:cintia.ba...@gmail.com>>
> *To:* dhis2-devs@lists.launchpad.net
> <mailto:dhis2-devs@lists.launchpad.net>
> *Sent:* Wednesday, May 13, 2009 9:22:14 AM
> *Subject:* [Dhis2-devs] Providing another source table
> for reports
>
> Hi all,
>
> I'm trying to build the reports without using the Report
> Tables tools.
>
> When i add new report on dhis it gives a chance to
> provide another data source different from the report
> tables (" If selecting no report table, the user is
> responsible for providing the data source table. ").
>
> I just don't know how to tell DHSI that I want to use
> another data source.
> Any help on how to accomplish this?
>
> Thanks in advance
>
> -- Cintia Marisa
>
> You can use BIRT to include your dataset. Simply create
> dataset under outline->DataSet. Simply choose "SQL
> select query" and make you sql statement on next screen,
> like "select * from yourtable where ..."
>
> murod
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> <https://launchpad.net/%7Edhis2-devs>
> Post to : dhis2-devs@lists.launchpad.net
> <mailto:dhis2-devs@lists.l
Re: [Dhis2-devs] Providing another source table for reports
Hi Cintia, This report does not have any Data Sorce and Data Set defined. Can you please send report with data set definitions please? regards, murod From: Cintia Marisa To: Murodullo Latifov ; DHIS 2 developers Sent: Monday, May 18, 2009 2:50:51 PM Subject: Re: [Dhis2-devs] Providing another source table for reports Sure, In attachment the design. On Mon, May 18, 2009 at 9:19 AM, Murodullo Latifov wrote: Hi Cintia, Could you please send me your report file? regards, murod From: Cintia Marisa To: Ola Hodne Titlestad Cc: DHIS 2 developers Sent: Friday, May 15, 2009 3:52:31 PM Subject: Re: [Dhis2-devs] Providing another source table for reports Hi, Sorry, about the reply thing. I keep forgetting. And no, that doesn't happen with report tables. The report work just fine, with a report table. the problem is when I use another source table. On Fri, May 15, 2009 at 12:55 PM, Ola Hodne Titlestad wrote: Hi Cintia, Remember to use Reply-all to make sure the list gets you reply as well. So it's not a BIRT viewer/designer incompatibility issue. Does BIRT work inside DHIS at all? I mean if you create a report in BIRT based on a report table in DHIS and then upload the design, link to report table, and run the report. Still the same problem then? best regards, Ola Hodne Titlestad HISP University of Oslo On Fri, May 15, 2009 at 12:19 PM, Cintia Marisa wrote: I've checked, and it's not a version incompatibility issue. It happens with my designs too. Both my BIRT designer and viewer are the same version. On Fri, May 15, 2009 at 12:14 PM, Ola Hodne Titlestad wrote: On Fri, May 15, 2009 at 10:26 AM, Cintia Marisa wrote: Hi all, 1st Thank u guys for the help. 2nd Murod, Thanks for the samples you sent, they were helpful. But still, even with the samples you sent to me, when I try to upload and view the report in DHIS I get "no report design available" error. Here's the log: * INFO 09:06:38,359 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-1]) * INFO 09:38:51,875 Upload file name: sample_params.rptdesign, content type: application/octet-stream (AddReportAction.java [http-8080-1]) * INFO 09:38:51,875 New file: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\birt-viewer\sample_params.rptdesign (AddReportAction.java [http-8080-1]) * INFO 09:38:51,890 Report connection URL: jdbc:mysql://localhost/dhis2_exp?useUnicode=true&characterEncoding=UTF-8 (AddReportAction.java [http-8080-1]) org.eclipse.birt.report.exception.ViewerException: There is no report design object available. at org.eclipse.birt.report.context.ViewerAttributeBean.__init(ViewerAttributeBean.java:233) at org.eclipse.birt.report.context.BaseAttributeBean.init(BaseAttributeBean.java:233) at org.eclipse.birt.report.context.ViewerAttributeBean.(ViewerAttributeBean.java:116) at org.eclipse.birt.report.context.BirtContext.__init(BirtContext.java:44) at org.eclipse.birt.report.context.BaseContext.(BaseContext.java:69) at org.eclipse.birt.report.context.BirtContext.(BirtContext.java:30) at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(ViewerServlet.java:150) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(BirtSoapMessageDispatcherServlet.java:151) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11P
Re: [Dhis2-devs] Providing another source table for reports
Hi Cintia, From: Cintia Marisa To: Murodullo Latifov Cc: DHIS 2 developers Sent: Wednesday, May 20, 2009 2:31:40 PM Subject: Re: [Dhis2-devs] Providing another source table for reports Hi, Thanx for the help! The report works just fine in BIRT, but i can't get it to work on DHIS. I still got "no report design available" error. And i'm using version 2.3.1 for both BIRT designer and viewer. It seems your birt viewer on your dhis server is configured incorrectly. I would recommend reconfiguring birt viewer for dhis. 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] Coding layout - Community-Based Health Information System (CBHIS)
Hi people, If you like I can commit my work on struts2 integration into bazaar. These are copy of modules from existing webwork implementations, we can have all in one and even exclude new modules from the rest via poms. Currently two main modules - support-struts2 and web-commons-resources-struts2 and one working module - web-importexport-struts2 are converted. regards, murod From: Lars Helge Øverland To: Bob Jolliffe Cc: Ola Hodne Titlestad ; Sundeep Sahay ; Ola Hodne Titlestad ; Kristin Braa ; Jørn Braa ; dhis2-devs Sent: Wednesday, May 27, 2009 11:01:21 AM Subject: Re: [Dhis2-devs] Coding layout - Community-Based Health Information System (CBHIS) Similarly there has been some talk of *possible* migration of DHIS2 towards struts 2 - at least there is a reasonably clear migration path and I know Murod has done some work with experimental module. Is this something to be considered? Lars what do you think? Regards Bob I actually gave it a try yesterday. Migrating action classes/interceptors is easy. I ran into some problems though: - I got some incomprehensible errors related to SAX xml parsing. - It's harder to get hold of the xwork ConfigurationManager (must be done trough a DispatcherListener) which is required for the portal. - Our old acegi security framework had some issues with xwork2. This should be upgraded to Spring security, but will require more work. Anyways I think this is the way to go if we are to upgrade the existing webwork code as this requires little modification to the hundreds of action classes and interceptors, in contrast to eg spring mvc. When it comes to technology stack for the houshold system my opinion is that using something completely new like j2ee 6 is unrealistic if we are gonna come up with something pretty soon as it requires all of us to learn new technologies and start from scratch. I believe that, if necessary, we could upgrade a few things in dhis2, like acegi and webwork, and then continue with the same technology / components as today. If we want to use more Spring out-of-the-box components later there is nothing stopping us. 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] Data and Organisationunit level
Hi Orvalho, - Original Message From: Orvalho Joaquim Augusto To: dhis2-devs Sent: Monday, June 1, 2009 5:15:36 AM Subject: [Dhis2-devs] Data and Organisationunit level We are recovering data from a system not related to dhis and we want to put such information on dhis. The problem is some part of that information has data from level 4, some on level 3 and other only from level 2. How do I place all these data on dhis2? On datavalue? Thanks Caveman Do you mean orgunits in different levels? It is possible, you have to define mapping from old data to new and transform old data to dhis2 datavalue records. If you post your old data and mapping file I can help with transformation. 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] Data and Organisationunit level
hi, - Original Message From: Orvalho Joaquim Augusto To: Murodullo Latifov Cc: dhis2-devs Sent: Monday, June 1, 2009 1:20:43 PM Subject: Re: [Dhis2-devs] Data and Organisationunit level Hi there! Murodullo Latifov wrote: > Hi Orvalho, > > > > - Original Message > From: Orvalho Joaquim Augusto > To: dhis2-devs > Sent: Monday, June 1, 2009 5:15:36 AM > Subject: [Dhis2-devs] Data and Organisationunit level > > We are recovering data from a system not related to dhis and we want to put > such information on dhis. > > The problem is some part of that information has data from level 4, some on > level 3 and other only from level 2. > > How do I place all these data on dhis2? On datavalue? > > Thanks > Caveman > > Do you mean orgunits in different levels? It is possible, you have to define > mapping from old data to new and transform old data to dhis2 datavalue > records. If you post your old data and mapping file I can help with > transformation. Yes. I have another table resulting from organisation modifications. I added the codes necessary to map; And I have the necessary SQL. Now I know that I can place any level on datavalue, isn't corect? > > regards, > murod > > > > Ate ja Caveman Yes, you can do that. 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] organisationunit tree in organisationunit group edit page is not showing previously selected group members ( ie. orgnisationunits ) in that group.
Hi Brajesh, From: Brajesh Murari To: dhis2-devs Sent: Thursday, June 4, 2009 11:04:45 AM Subject: [Dhis2-devs] organisationunit tree in organisationunit group edit page is not showing previously selected group members ( ie. orgnisationunits ) in that group. Hi , We need help. Problem description is given below.. Maintenance --> Organisation Units --> Organisation Unit Group --> Any Edit Button in Organisation unit group management page. Here problem is while editing any Organisationunit group in Organisation unit group management page, it did not show any organisationunit group member of that organisationunit group as "selected". But But it is saving properly the members selected while making any organisationunit group. So so problem is while editing any organisationunit group. Because we can't see the previously selected members of that particular organisationunit group, so it becomes difficult to edit it. And here in India, We are in the process of composing organisationunit group based reports. So it makes us difficult while editing organisationunit groups or adding any new organisationunit in selected organisationunit group. >> Serious Bug...need quick solution as soon as possible. :( -- Best Regards, Brajesh Murari I just tested bug you have reported. It works fine with The Gambia database, e.g. shows previously selected org units. I assume your previous group definition is violent. Did you try creating new group and try? 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
