from:"channara rin"

Re: [Dhis2-devs] [Dhis2-users] Linking Power BI and DHIS2

2018-03-22 Thread channara rin

Hi Michael,
Do you have guide for option 2: connect through web API?
how can i find dhis1 api token key?

On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze  wrote:

> Hi Stanley,
>
> you basically have two options for this.
>
>1. download data from dhis2 as csv and upload it to PowerBI (you will
>have to create a dataset for that on PowerBI)
>2. make use of DHIS2 web api to pull data and push it to powerbi via
>its web api as well. To achieve this a number of things need to happen on
>the PowerBI side. You will need to create an app on the Azure platform,
>give it the right authentication permissions, then use the token created in
>your custom script of application to authenticate and update a particular
>dataset.
>
> If you are interested in code repository, I have a working example based
> on Symfony 3 a PHP frameweork in my git repository.
>
>
> https://github.com/mmwebaze/powerbi_Symfony
>
>
> I hope this helps.
>
> On 14 September 2017 at 11:46, Stanley Kalyati  wrote:
>
>> Anyone with experience linking Power BI and DHIS2 for further analysis .
>>
>> Anyone
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> 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-users] dhis version 2.29 is released

2018-03-07 Thread channara rin

Many helpful features,

thank you all teams...

best regards,
channara

On Thu, Mar 8, 2018 at 7:55 AM, Pamod Amarakoon  wrote:

> Thank you and great job !
>
> On Thu, Mar 8, 2018, 3:53 AM DJIBRIL Hakim  wrote:
>
>> Congratulations Guys!
>>
>> 2018-03-07 21:55 GMT+00:00 John Mukulu :
>>
>>> Great Job
>>>
>>> Congratulations for major milestones on this release.
>>>
>>> John Francis Mukulu
>>> Software Architect, HISPTZ
>>> http://hisptanzania.org/
>>>
>>> On Mar 8, 2018 00:40, "Lars Helge Øverland"  wrote:
>>>

 *Hi all,DHIS version 2.29 is out with many new features, apps and
 improvements.Login with admin/district on the demo
  system to try it out.ANALYTICS
 FEATURES---Dashboard app: A new dashboard app is now available which lets
 you arrange the dashboard items in a completely flexible way. It features
 better dashboard search, allows you to create shortcuts by marking
 dashboards as favorites, switch between visualization types such as pivot,
 chart and map and insert free-text items. Dashboards can be shared,
 translated and filtered.Screenshot 1

 | 2

 | Demo  | Docs
 Maps app: A new
 maps app (previously GIS) is available, offering a new, intuitive and
 user-friendly interface for creating map layers. It lets you arrange the
 order of map layers in a simple way, and view the map data in a data table.
 Any number of map layers can be added to a map, even layers of the same
 type. The contents and order of map layers can be viewed in the left side
 menu.Screenshot 1

 | 2

 | Demo  | Docs
 Last value
 aggregation type: A new “last value” aggregation type is available for
 aggregate and event analytics for data elements and attributes. This
 aggregation type will use the last available value or event in the time
 dimension, and either sum or average across other dimensions. This is
 useful e.g. for facility surveys to analyse data based on the last
 observation, or for “patients currently on care” type of
 analysis.Screenshot

 | Demo Pivot table
 scalability: The pivot table rendering engine is now around 10x more
 scalable, and allows for very large pivot tables to be viewed in the web
 browser. This is accomplished through progressive rendering, i.e. the
 browser will only render what you currently see and not load the entire
 pivot table into the browser memory.Demo
 Event reports
 table layout download: You can now download event reports in Excel or CSV
 format in the same tabular format which was rendered in the web
 browser.Screenshot
 Configurable
 financial year in analytics: The starting month of the financial year to
 use in all analytics apps can now be configured in the settings app.
 Available options are April, July and October.Screenshot

 | Demo TRACKER
 FEATURES---Data capture and data view sharing levels: The sharing solution
 has been extended with two new levels for “data capture” and “data view”
 access for users and user groups. These levels apply to programs, program
 stages, data sets and category options, and replaces the link between user
 roles and data sets/programs. This offers a simplified and more

Re: [Dhis2-devs] Interoperability of ODK & DHIS2

2017-09-12 Thread channara rin

Hi All,
Do you know this link:https://github.com/hispindia/dhis-odk-integration , i
saw in forum. Could you guide a little bit how to use it?

thank you,
channara

On Fri, Sep 1, 2017 at 3:55 PM, Martin Van Aken 
wrote:

> Interesting, thanks!
>
> Martin
>
> On Fri, Sep 1, 2017 at 10:23 AM, Knut Staring  wrote:
>
>> Hi Carlos,
>>
>> You can also have a look here:
>> https://github.com/hispindia/dhis-odk-integration
>>
>> Knut
>>
>> On Wed, Aug 30, 2017 at 11:47 AM, Martin Van Aken <
>> mar...@joyouscoding.com> wrote:
>>
>>> Hi Carlos,
>>> We (bluesquarehub.com) have been doing this for several of our
>>> customers as part as a (commercial) product. While I can't share the code,
>>> I'll be happy to discuss about the lessons learned, and to better
>>> understand your needs to see if our cases are similar.
>>>
>>> Don't hesitate to contact me if interested.
>>>
>>> Regards,
>>>
>>> Martin
>>>
>>> On Tue, Aug 29, 2017 at 3:24 PM, Carlos Nyembwe 
>>> wrote:
>>>
 Hello All

 I'm starting to do that, now I need a help about the main points what I
 must set up before using this

 Regards

 --
 *Carlos Nyembwe*
 *I'm just a Computer Scientist*

 *Skype: carloscnk1*
 *Cell: (+243)813166381 <+243%20813%20166%20381>*
 *Find me in: | Google Plus  | 
 **Linkedin
  | Facebook
  | Twitter
  |*

 ___
 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


>>>
>>>
>>> --
>>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>>
>>> Mobile : +32 486 899 652
>>>
>>> Follow me on Twitter : @martinvanaken 
>>> Call me on Skype : vanakenm
>>> Hang out with me : mar...@joyouscoding.com
>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>>> Company website : www.joyouscoding.com
>>>
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522 <+47%20918%2080%20522>
>> Skype: knutstar
>> http://dhis2.org
>>
>
>
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken 
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.com
>
> ___
> 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] error when run maintenance

2017-08-06 Thread channara rin

Dear all
when i run maintenance  form DHIS2, i got this problem. please help.

* INFO  2017-08-07 08:45:17,889 Period table generated
(DefaultResourceTableService.java [taskScheduler-1])
* INFO  2017-08-07 08:45:17,891 Create data element category option combo
SQL: CREATE TABLE _dataelementcategoryoptioncombo (dataelementid INTEGER
NOT NULL, dataelementuid VARCHAR(11) NOT NULL, categoryoptioncomboid
INTEGER NOT NULL, categoryoptioncombouid VARCHAR(11) NOT NULL)
(JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2017-08-07 08:45:17,893 Insert data element category option combo
SQL: insert into _dataelementcategoryoptioncombo (dataelementid,
dataelementuid, categoryoptioncomboid, categoryoptioncombouid) select
de.dataelementid as dataelementid, de.uid as dataelementuid,
coc.categoryoptioncomboid as categoryoptioncomboid, coc.uid as
categoryoptioncombouid from dataelement de join categorycombos_optioncombos
cc on de.categorycomboid = cc.categorycomboid join categoryoptioncombo coc
on cc.categoryoptioncomboid = coc.categoryoptioncomboid
(JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2017-08-07 08:45:17,903 Create data element category option combo
index SQL: CREATE INDEX dataelement_categoryoptioncombo ON
_dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombouid)
(JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2017-08-07 08:45:17,961 Data element category option combo table
generated (DefaultResourceTableService.java [taskScheduler-1])
* WARN  2017-08-07 08:50:37,801 SQL Error: 0, SQLState: 22003
(SqlExceptionHelper.java [http-nio-8080-exec-6])
* ERROR 2017-08-07 08:50:37,802 Bad value for type int : WITH_REGISTRATION
(SqlExceptionHelper.java [http-nio-8080-exec-6])
* ERROR 2017-08-07 08:50:37,842 Error while executing action
(ExceptionInterceptor.java [http-nio-8080-exec-6])
org.hibernate.exception.DataException: could not load an entity:
[org.hisp.dhis.program.Program#15176]
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135)
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
at org.hibernate.loader.Loader.loadEntity(Loader.java:2149)
at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:82)
at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:72)
at
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3939)
at
org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:462)
at
org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:431)
at
org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:208)
at
org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:264)
at
org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at
org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1053)
at
org.hibernate.internal.SessionImpl.access$2000(SessionImpl.java:173)
at
org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2449)
at org.hibernate.internal.SessionImpl.get(SessionImpl.java:949)
at
org.hisp.dhis.hibernate.HibernateGenericStore.getNoAcl(HibernateGenericStore.java:438)
at
org.hisp.dhis.common.DefaultIdentifiableObjectManager.getNoAcl(DefaultIdentifiableObjectManager.java:900)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at

[Dhis2-devs] Automatic aggregation

2017-06-06 Thread channara rin

Dear All DHIS2,
I have one problem suggest to help.
Currently, i use DHIS2 V2.20 for small program, I didn't upgrade yet.
I use tracker Capture to input value and do aggregate with formula
automatic to each Data Elements in Data Entry Form every 3months
(Quarterly).

so next quarter, I input tracker Capture, but i need to update some status
of attributes, So Does the value in previous Quarter can affect or not? and
if affact, the DHIS2 latest version has prevent this function or not yet?

[image: Inline image 1]
thank you
channara
___
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-users] dhis version 2.27 is released

2017-06-05 Thread channara rin

thank you for sharing...

On Fri, Jun 2, 2017 at 7:21 PM, Calle Hedberg 
wrote:

> Hi
>
> Good to see the team managed to get it out on time (proving that moving to
> a 4-month cycle was the right decision).
>
> A number of urgently needed new features are included, even if a lot of
> stuff recently were pushed to 2.28 - I just hope the team had enough time
> to iron out all/most of the bugs we've seen in 2.27 trunk recently ;-).
>
> Well done - and enjoy a few "utepils" (= drinking in public for those
> speaking Trollish) over the weekend!
>
> Best regards from Cape Town
> Calle
>
> On 2 June 2017 at 13:44, Lars Helge Øverland  wrote:
>
>> Hi all,
>>
>>
>> DHIS version 2.27 is out with many new features, apps and improvements.
>>
>>
>>
>> Log in with admin/district on the demo 
>> system.
>>
>>
>>
>>
>> ANALYTICS FEATURES
>>
>> ---
>>
>>
>>
>> Period and organisation unit drill-down: The Pivot Table app now
>> supports drill-down (and up) for periods and organisation unit. This means
>> that you can, for example, drill down from yearly periods to quarters,
>> months and weeks inside the pivot table. You can also drill down from the
>> global organisation unit to countries, provinces and facilities.
>>
>>
>>
>> Demo  | 
>> Screenshot
>> 1
>> 
>> | 2
>> 
>> | Docs 
>>
>>
>>
>>
>>
>> Organisation unit levels as columns: When downloading a pivot table with
>> organisation units as rows and the “Show hierarchy” option enabled in the
>> options dialog, each organisation unit level is rendered as a separate
>> column. This is useful for example when you create Excel pivot tables on a
>> local computer.
>>
>>
>>
>> Demo 1
>> 
>> | 2  |
>> Screenshot
>> 
>> | Docs
>> 
>>
>>
>>
>>
>>
>> Hide empty columns: The Pivot Table app now lets you hide empty columns
>> in the table. You enable this in the Table options dialog.
>>
>>
>>
>> Demo  |
>> Screenshot
>> 
>> | Docs
>> 
>>
>>
>>
>>
>>
>> Legend by data element: In the Pivot Table app, you can now color the
>> table cells according to each data element or indicator individually. You
>> enable this in the Table options dialog by setting legend to “By data item”.
>>
>>
>>
>> Demo  |
>> Screenshot
>> 
>> | Docs
>> 
>>
>>
>>
>>
>>
>> Row and column % in pivots tables: In the Pivot Table app you can now
>> display values as percentages of row total or percentage of column total
>> (instead of the aggregated value). This is useful in order to see the
>> contribution of data elements, categories and organisation units to the
>> total value. You enable this in Table options dialog.
>>
>>
>>
>> Demo  |
>> Screenshot
>> 
>> | Docs
>> 
>>
>>
>>
>>
>>
>> 100% stacked column charts: In the Data Visualizer app you can now
>> display 100% stacked column charts. You enable this in the Chart options
>> dialog.
>>
>>
>>
>> Demo  |
>> Screenshot
>> 
>> | Docs
>> 
>>
>>
>>
>>
>>
>> Cumulative values in line charts: In the Data Visualizer app you can now
>> create line charts with cumulative values. You enable this in the Chart
>> options dialog.
>>
>>
>>
>> Demo  |
>> Screenshot
>>

[Dhis2-devs] Event importer

2017-01-24 Thread channara rin

Dear DHIS2 all,
any one successful using event importer function in DHIS2?
I try many time, but always this display error like below:
[image: Inline image 1]
Here is the sample csv file for import
[image: Inline image 2]

DHIS2 version 2.25
Build date:2017-01-16 06:37

thank you
channara
___
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] Formula for program indicator

2017-01-18 Thread channara rin

Dear all,
can you tell me has any problem with previous report of aggregated data
value if i changed formula in program indicator?

thank you
channara
___
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-users] how to set "scheduling automated aggregation"

2017-01-09 Thread channara rin

dear prosper,
is version 2.20.
i want to set task schedule for running every 15mn

On Mon, Jan 9, 2017 at 7:01 PM, Prosper BT <ptb3...@gmail.com> wrote:

> Dear Channara,
>
> Do you mean aggregation form the query builder?
>
> Which version of DHIS2 are you using?
>
> Regards
>
>
>
> Prosper Behumbiize, MPH
> DHIS2 Implementation| HISP Uganda
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org <ptb3...@gmail.com> | pros...@dhis2.org | Skype:
> prospertb
>
> On Sun, Jan 8, 2017 at 10:40 AM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> dear all,
>> do you know to to set schedule for run "scheduling automated aggregation"?
>>
>> thank you
>> channara
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> 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] how to set "scheduling automated aggregation"

2017-01-07 Thread channara rin

dear all,
do you know to to set schedule for run "scheduling automated aggregation"?

thank you
channara
___
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] blank value in pivot table, event report,....

2017-01-04 Thread channara rin

hi all,
what problem? i saw blank chart, table and pivotable, event report...? why
no value show it.
how can i fix it...
[image: Inline image 1]
___
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] Lost aggregate builder in DHIS2 v2.25

2016-12-20 Thread channara rin

dear all,
any one can help me?, usually, i use aggregate builder to create value with
formula for *data element*. and when i test with version 2.25, i can't find
aggregate builder function.

regards,
channara
___
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-users] delete existing data elements

2016-12-13 Thread channara rin

ohh! i see
But, can i remove in record in table of database by manual?

regards,
channara
___
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] delete existing data elements

2016-12-13 Thread channara rin

dear all,
i want to delete in data elements. but when i click remove, i got console
like below:
* INFO  2016-12-13 15:48:27,917 Delete was not allowed by
CaseAggregationConditionDeletionHandler: CaseAggregationCondition
(DefaultDeletionManager.java [http-nio-80-exec-8])

do you know this problem, how can i delete it?

thank you
channara
___
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-users] can't delete data element

2016-11-17 Thread channara rin

YES,
thank you for reminding...
___
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-users] can't delete data element

2016-11-17 Thread channara rin

Note thank you

On Fri, Nov 18, 2016 at 2:20 PM, Ant Snyman <a...@hisp.org> wrote:

> Yes you are right. Some sql scripts you can run from the UI (SQLVIEWS -
> data administration) but you cannot update or delete using SQLVIEW, so in
> this case you would have to do it in the "back-end". What you could do to
> make sure is use SQLVIEW to see if that dataelementid exists in the
> datavalueaudit table. Something like "select * from datavalueaudit where
> dataelementid = .. ".
>
> Regards
>
> Ant Snyman
>
> On 18 November 2016 at 09:10, channara rin <rin.chann...@gmail.com> wrote:
>
>> ohh,i see...
>> but sql script can only run on server? cannot from client side?
>>
>> On Fri, Nov 18, 2016 at 2:08 PM, Ant Snyman <a...@hisp.org> wrote:
>>
>>> Hi Channara,
>>> There is also a table called datavalueaudit which also contains a
>>> reference to the dataelementid. The record should also be deleted from this
>>> table, I normally do it through sql script, not sure if deleting a
>>> datavalue from the UI will also remove the datavalueaudit record.
>>> Regards
>>> Ant Snyman
>>>
>>>
>>> On 18 November 2016 at 06:38, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> yes,
>>>> my DE use cate-combo and group.
>>>> so after remove group, i can delete?
>>>>
>>>>
>>>> On Fri, Nov 18, 2016 at 11:30 AM, Prosper BT <ptb3...@gmail.com> wrote:
>>>>
>>>>> Hi Channara,
>>>>>
>>>>> Did you assign it an option set or cat-comb or grouped it in a group
>>>>> or even assigned it to a dataset or program,
>>>>>
>>>>> You have to check all these before deleting it.
>>>>>
>>>>> Regards
>>>>>
>>>>> Prosper Behumbiize, MPH
>>>>> DHIS2 Implementation| HISP Uganda/University Of Oslo
>>>>> +256 752 751 776 | +256 776 139 139
>>>>> pros...@hispuganda.org <ptb3...@gmail.com> | pros...@dhis2.org | Skype:
>>>>> prospertb
>>>>>
>>>>> On Fri, Nov 18, 2016 at 5:04 AM, channara rin <rin.chann...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> dear friend,
>>>>>> i created new dataset and put only data element want to delete and
>>>>>> then go through to delete data value already.
>>>>>> but i still see the message like below:
>>>>>> [image: Inline image 1]
>>>>>>
>>>>>> On Fri, Nov 18, 2016 at 9:02 AM, Shurajit Dutta <
>>>>>> shurajitdu...@gmail.com> wrote:
>>>>>>
>>>>>>> Hi Channara,
>>>>>>>
>>>>>>> You would have to delete all the values associated with that DE
>>>>>>> first.
>>>>>>>
>>>>>>> On Fri, Nov 18, 2016 at 9:43 AM, channara rin <
>>>>>>> rin.chann...@gmail.com> wrote:
>>>>>>>
>>>>>>>> dear all,
>>>>>>>> do you know how to delete data element that we already used input
>>>>>>>> data value?
>>>>>>>>
>>>>>>>> regards,
>>>>>>>> channara
>>>>>>>>
>>>>>>>> ___
>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>>> Post to : dhis2-us...@lists.launchpad.net
>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Shurajit Dutta
>>>>>>> Health Information Consultant
>>>>>>>
>>>>>>
>>>>>>
>>>>>> ___
>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>> Post to : dhis2-us...@lists.launchpad.net
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>

Re: [Dhis2-devs] [Dhis2-users] can't delete data element

2016-11-17 Thread channara rin

yes,
my DE use cate-combo and group.
so after remove group, i can delete?


On Fri, Nov 18, 2016 at 11:30 AM, Prosper BT <ptb3...@gmail.com> wrote:

> Hi Channara,
>
> Did you assign it an option set or cat-comb or grouped it in a group or
> even assigned it to a dataset or program,
>
> You have to check all these before deleting it.
>
> Regards
>
> Prosper Behumbiize, MPH
> DHIS2 Implementation| HISP Uganda/University Of Oslo
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org <ptb3...@gmail.com> | pros...@dhis2.org | Skype:
> prospertb
>
> On Fri, Nov 18, 2016 at 5:04 AM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> dear friend,
>> i created new dataset and put only data element want to delete and then
>> go through to delete data value already.
>> but i still see the message like below:
>> [image: Inline image 1]
>>
>> On Fri, Nov 18, 2016 at 9:02 AM, Shurajit Dutta <shurajitdu...@gmail.com>
>> wrote:
>>
>>> Hi Channara,
>>>
>>> You would have to delete all the values associated with that DE first.
>>>
>>> On Fri, Nov 18, 2016 at 9:43 AM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> dear all,
>>>> do you know how to delete data element that we already used input data
>>>> value?
>>>>
>>>> regards,
>>>> channara
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-us...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Shurajit Dutta
>>> Health Information Consultant
>>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> 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-users] can't delete data element

2016-11-17 Thread channara rin

dear friend,
i created new dataset and put only data element want to delete and then go
through to delete data value already.
but i still see the message like below:
[image: Inline image 1]

On Fri, Nov 18, 2016 at 9:02 AM, Shurajit Dutta <shurajitdu...@gmail.com>
wrote:

> Hi Channara,
>
> You would have to delete all the values associated with that DE first.
>
> On Fri, Nov 18, 2016 at 9:43 AM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> dear all,
>> do you know how to delete data element that we already used input data
>> value?
>>
>> regards,
>> channara
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Shurajit Dutta
> Health Information Consultant
>
___
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] can't delete data element

2016-11-17 Thread channara rin

dear all,
do you know how to delete data element that we already used input data
value?

regards,
channara
___
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] update tracker profile form

2016-11-03 Thread channara rin

dear all,
when i want to update some information of tracker profile. i got this below
error...
[image: Inline image 1]

how to fix this problem

best regards,
channara
___
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] Active Program in tracker capture

2016-11-03 Thread channara rin

Dear all,
i has problem with tracker capture.
when i open individual records, i can see program with tracker
But when i use tracker capture, i didn't see Active program like individual
records.
Any body know what is the problem? how to fix this problem?

[image: Inline image 1]

best regards,
channara
___
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-users] HOW TO DELETE AN ENTITY IN TRACKER CAPTURE

2016-11-03 Thread channara rin

has sql statement to delete?

On Thu, Nov 3, 2016 at 4:57 PM, Abyot Asalefew Gizaw 
wrote:

> I don't have ready made statements at hand.
>
> But here is what you need to do - FOR THE TRACKED ENTITY INSTANCE in
> question
>
>1. Delete event values from trackedentitydatavalue
>2. Delete events from programstageinstance
>3. Delete enrollments from programinstance
>4. Delete attribute values from trackedentityattributevalue
>5. Delete the instance from trackedentityinstance
>
> More on the associations:
>
> trackedentityinstance uid -> trackedentityinstance id -> programinstance
> id -> programstageinstance id
>
> --
> Abyot A. Gizaw.
> Senior Engineer, DHIS2
> University of Oslo
> http://www.dhis2.org
>
> On Thu, Nov 3, 2016 at 10:27 AM, Stanley Kalyati 
> wrote:
>
>> Abyot,
>>
>> Could you help with the sql statements?
>>
>> Thanks in advance.
>>
>> Stanley
>>
>> On Thu, Nov 3, 2016 at 11:22 AM, Abyot Asalefew Gizaw 
>> wrote:
>>
>>> Hi Stanley,
>>>
>>> It is only version 2.25 that has UI support for deleting Tracked Entity
>>> Instance. For the other versions, one has to do it manually using sql
>>> statements.
>>>
>>> --
>>> Abyot A. Gizaw.
>>> Senior Engineer, DHIS2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>> On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati 
>>> wrote:
>>>
 Colleagues,

 My colleague entered a tracked entity in a wrong OU and i want to
 delete that.Can someone tell me how to delete this entity? or move this
 entity to another OU.

 You usual support is always appreciated.

 Stanley


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


>>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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] find old version 2.20

2016-11-03 Thread channara rin

dear all,
how can i find the old version 2.20 in http://ci.dhis2.org/view?

thank you
channara
___
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] Tracker Capture's attributes

2016-10-14 Thread channara rin

hi chathura,
by the way, in tracker capture form has attributes like first name, last
name, sex, and also has unique ID attribute to identify. But i want unique
ID attribute can auto generate id by itself when create new tracker in
tracker capture form.

thank you
channara

On Sat, Oct 15, 2016 at 12:22 AM, chathura widanage <
chathurawidan...@gmail.com> wrote:

> Hi,
> I am not clear about your requirement. But, if you requirement is to
> generate a unique identifier, you can use /api/system/id endpoint of the
> web api.
>
> https://dhis2.github.io/dhis2-docs/master/en/developer/html/
> webapi_system_resource.html#d0e10401
>
> Cheers
>
> On Thu, Oct 13, 2016 at 11:57 AM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> Dear all,
>> by the way, can i create ID code attribute that auto increase number by
>> itself like auto generate ID code?
>>
>> if not, can i do manual script to make auto generate ID code?
>>
>>
>> thank you
>> channara
>>
>> ___
>> 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
>>
>>
>
>
> --
> Best Regards,
>
> *Chathura Widanage,*
> Undergraduate,
> Department of Computer Science and Engineering,
> University of Moratuwa,
> Sri Lanka
>
___
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] Tracker Capture's attributes

2016-10-13 Thread channara rin

Dear all,
by the way, can i create ID code attribute that auto increase number by
itself like auto generate ID code?

if not, can i do manual script to make auto generate ID code?


thank you
channara
___
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] custom form in Tracker Capture

2016-10-09 Thread channara rin

Dear alex,
thank you alot :-)
But could you give example one attribute for me? i don't know how to use
that script...

On Thu, Oct 6, 2016 at 5:36 PM, Alex Tumwesigye <atumwesi...@gmail.com>
wrote:

> Dear Channara,
>
> Use angular $watch to watch the models changes.
>
>
> Attribute model is $scope.selectedTei.uid
> event model is $scope.currentEvent.uid
>
> For Jquery,
> use $(selectedTei.uid).val("Your value").trigger('input');
>
> For angular,
> This $scope.selectedTei.uid will pick your value, however, you will need
> $watch to watch for changes.
>
>  Note uid is the dhis2 11 character identifier.
>
> Alex
>
> On Thu, Oct 6, 2016 at 12:47 PM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> Dear all,
>> do you know any jquery script for tracker capture custom form to catch
>> require attributes fields and unique attribute field?
>>
>> for example, when i edit client's profile in tracker capture. if i do
>> some things wrong format of attribute fields, when i click update/save. i
>> didn't see any popup message what i did wrong. but when i look console. i
>> saw error of jax to use "PUT" on 404 message.
>>
>> thank you
>> channara
>>
>> ___
>> 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
>>
>>
>
>
> --
> Alex Tumwesigye
>
> Technical Advisor - DHIS2 (Consultant),
> Ministry of Health/AFENET  | HISP Uganda
> Kampala
> Uganda
> +256 774149 775, + 256 759 800161
> Skype ID: talexie
>
> IT Consultant (Servers, Networks and Security, Health Information Systems
> - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant
>
>
> "I don't want to be anything other than what I have been - one tree hill "
>
___
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] custom form in Tracker Capture

2016-10-06 Thread channara rin

Dear all,
do you know any jquery script for tracker capture custom form to catch
require attributes fields and unique attribute field?

for example, when i edit client's profile in tracker capture. if i do some
things wrong format of attribute fields, when i click update/save. i didn't
see any popup message what i did wrong. but when i look console. i saw
error of jax to use "PUT" on 404 message.

thank you
channara
___
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] problem with tracker capture

2016-08-29 Thread channara rin

Hi all,
i don't know what problem with tracker capture. but if i use individual
record, i can enter new event..
here is screenshot of tracker capture:
[image: Inline image 1]
___
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 clear cache for app in app management

2016-08-06 Thread channara rin

thank you polak,
let me try it.. :-)

On Fri, Aug 5, 2016 at 4:28 PM, Mark Polak  wrote:

> Hey Channara,
>
> Clearing the browser cache should be sufficient for that.
>
> We have a small tutorial for that here https://www.dhis2.org/
> tutorials/how-to-really-clear-browser-cache
>
> On Fri, Aug 5, 2016 at 8:17 AM, rin.chann...@gmail.com <
> rin.chann...@gmail.com> wrote:
>
>> Hi all dev,
>> I am developing one app and upload this App to app management for
>> testing. But when I changed some code and upload again. The system always
>> remember the previous code like code console.log.
>> So do you know how to clear cache for testing app in the system or has
>> another for testing without upload.
>>
>> Thank you
>> Channara
>>
>>
>> From m2 note
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Regards,
>
>
> Mark Polak
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org 
> m...@dhis2.org
>
___
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 clear cache for app in app management

2016-08-05 Thread channara rin

Em, it work fine... :-) thank you

On Fri, Aug 5, 2016 at 2:17 PM, channara rin <rin.chann...@gmail.com> wrote:

> ohh, thank you Em
>
> On Fri, Aug 5, 2016 at 2:10 PM, Em Le Hong <em.hispviet...@gmail.com>
> wrote:
>
>> Hi Channara,
>>
>> Try to increase the version in manifest.webapp file and after you zip the
>> app, change the zip name also.
>>
>> Hope this can help.
>>
>>
>> On Fri, Aug 5, 2016 at 1:17 PM, rin.chann...@gmail.com <
>> rin.chann...@gmail.com> wrote:
>>
>>> Hi all dev,
>>> I am developing one app and upload this App to app management for
>>> testing. But when I changed some code and upload again. The system always
>>> remember the previous code like code console.log.
>>> So do you know how to clear cache for testing app in the system or has
>>> another for testing without upload.
>>>
>>> Thank you
>>> Channara
>>>
>>>
>>> From m2 note
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>> Le Hong Em
>>   +84 126 7171 650
>>
>
>
___
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 clear cache for app in app management

2016-08-05 Thread channara rin

ohh, thank you Em

On Fri, Aug 5, 2016 at 2:10 PM, Em Le Hong  wrote:

> Hi Channara,
>
> Try to increase the version in manifest.webapp file and after you zip the
> app, change the zip name also.
>
> Hope this can help.
>
>
> On Fri, Aug 5, 2016 at 1:17 PM, rin.chann...@gmail.com <
> rin.chann...@gmail.com> wrote:
>
>> Hi all dev,
>> I am developing one app and upload this App to app management for
>> testing. But when I changed some code and upload again. The system always
>> remember the previous code like code console.log.
>> So do you know how to clear cache for testing app in the system or has
>> another for testing without upload.
>>
>> Thank you
>> Channara
>>
>>
>> From m2 note
>> ___
>> 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
>>
>>
>
>
> --
> Le Hong Em
>   +84 126 7171 650
>
___
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] remove dataset report function from userrole?

2016-08-02 Thread channara rin

Dear all DHIS2 member,
Do you know how can i remove dataset report function from *user role*?

thank you
channara
___
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-users] WebAPI for register tracker instance

2016-07-07 Thread channara rin

Great! morten!

On Thu, Jul 7, 2016 at 2:36 PM, Morten Olav Hansen <mor...@dhis2.org> wrote:

> In 2.24 we have added the ability to create TEI and enroll at same time
> which might be interesting for you
>
>
> On Thursday, 7 July 2016, channara rin <rin.chann...@gmail.com> wrote:
>
>> i see, thank alot for supporting...
>>
>> On Thu, Jul 7, 2016 at 11:56 AM, Morten Olav Hansen <mor...@dhis2.org>
>> wrote:
>>
>>> Ah yes, I was assuming you were sending for an existing tracked entity.
>>>
>>> If not, you will need to create the TEI first
>>>
>>>
>>> On Thursday, 7 July 2016, channara rin <rin.chann...@gmail.com> wrote:
>>>
>>>> Hi morten.
>>>> you mean, i need run two commands through web api, first, create track
>>>> entity intance, then create program stage.?
>>>>
>>>> On Thu, Jul 7, 2016 at 10:14 AM, Morten Olav Hansen <mor...@dhis2.org>
>>>> wrote:
>>>>
>>>>> Hi Channara
>>>>>
>>>>> You can follow the guides at [1] and then just add the
>>>>> "trackedEntityInstance" field to it to say the TEI it will add events for,
>>>>> and then the "programStage" to say which stage to add data for.
>>>>>
>>>>> [1]
>>>>> http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s19.html
>>>>>
>>>>> --
>>>>> Morten Olav Hansen
>>>>> Senior Engineer, DHIS 2
>>>>> University of Oslo
>>>>> http://www.dhis2.org
>>>>>
>>>>> On Thu, Jul 7, 2016 at 9:44 AM, channara rin <rin.chann...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Hi all DHIS2,
>>>>>> do you know how can i use webAPI for register new tracker instance
>>>>>> with multiple event?
>>>>>>
>>>>>> regards,
>>>>>> channara
>>>>>>
>>>>>> ___
>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>> Post to : dhis2-us...@lists.launchpad.net
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>> --
>>> --
>>> Morten Olav Hansen
>>> Senior Engineer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>>
>>
>
> --
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
>
___
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-users] WebAPI for register tracker instance

2016-07-07 Thread channara rin

i see, thank alot for supporting...

On Thu, Jul 7, 2016 at 11:56 AM, Morten Olav Hansen <mor...@dhis2.org>
wrote:

> Ah yes, I was assuming you were sending for an existing tracked entity.
>
> If not, you will need to create the TEI first
>
>
> On Thursday, 7 July 2016, channara rin <rin.chann...@gmail.com> wrote:
>
>> Hi morten.
>> you mean, i need run two commands through web api, first, create track
>> entity intance, then create program stage.?
>>
>> On Thu, Jul 7, 2016 at 10:14 AM, Morten Olav Hansen <mor...@dhis2.org>
>> wrote:
>>
>>> Hi Channara
>>>
>>> You can follow the guides at [1] and then just add the
>>> "trackedEntityInstance" field to it to say the TEI it will add events for,
>>> and then the "programStage" to say which stage to add data for.
>>>
>>> [1]
>>> http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s19.html
>>>
>>> --
>>> Morten Olav Hansen
>>> Senior Engineer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>> On Thu, Jul 7, 2016 at 9:44 AM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> Hi all DHIS2,
>>>> do you know how can i use webAPI for register new tracker instance with
>>>> multiple event?
>>>>
>>>> regards,
>>>> channara
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-us...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>
>
> --
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
>
___
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-users] WebAPI for register tracker instance

2016-07-06 Thread channara rin

Hi morten.
you mean, i need run two commands through web api, first, create track
entity intance, then create program stage.?

On Thu, Jul 7, 2016 at 10:14 AM, Morten Olav Hansen <mor...@dhis2.org>
wrote:

> Hi Channara
>
> You can follow the guides at [1] and then just add the
> "trackedEntityInstance" field to it to say the TEI it will add events for,
> and then the "programStage" to say which stage to add data for.
>
> [1]
> http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s19.html
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Thu, Jul 7, 2016 at 9:44 AM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> Hi all DHIS2,
>> do you know how can i use webAPI for register new tracker instance with
>> multiple event?
>>
>> regards,
>> channara
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> 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] WebAPI for register tracker instance

2016-07-06 Thread channara rin

Hi all DHIS2,
do you know how can i use webAPI for register new tracker instance with
multiple event?

regards,
channara
___
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-users] DHIS2 SQL View - practical examples

2016-07-06 Thread channara rin

Hi all,
do you have some explaination relate to table schema?
when i open, it alot of table.

thank you
channara

On Tue, Jul 5, 2016 at 8:19 PM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Thank you Michael.
>
> Regards,
>
> Tantely.
>
> On Tue, Jul 5, 2016 at 3:35 PM, Michael Mwebaze  > wrote:
>
>> Hi Tantely,
>>
>> Standard ANSI SQL can be executed easily with-in Sqlviews sub-module in
>> DHIS2. The link below should be helpful.
>>
>> http://dhis2.github.io/dhis2-docs/2.22/en/user/html/ch22s06.html
>>
>> Regards,
>>
>> Michael
>>
>> On 5 July 2016 at 04:45, Raminosoa Rabemanantsoa, Tantely <
>> tramino...@mikolo.org> wrote:
>>
>>> Thank you Knut for your suggestion.
>>>
>>> Regards,
>>>
>>> Tantely.
>>>
>>> On Tue, Jul 5, 2016 at 10:53 AM, Knut Staring  wrote:
>>>
 Hi Raminosa,

 I think you should try to install Postgres locally on your laptop,
 which would allow you to easily query the database using PgAdmin.

 Regards,
 Knut

 On Tue, Jul 5, 2016 at 9:13 AM, Raminosoa Rabemanantsoa, Tantely <
 tramino...@mikolo.org> wrote:

> Hi All,
>
>
> I am looking for a documentation of the use of the SQL syntax to run
> in SQL View  (table names, field names specific to DHIS2 ). I have seen 
> for
> example to query organization unit, we have to select from “ou” or to use
> “dv” to select the datavalues. I am planning to list all the uid, code and
> names of all organization units at all levels (1 to 6) in one single query
> result.
>
>
> Thank you for your support.
>
>
> Tantely.
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
> ___
> 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
>
>


 --
 Knut Staring
 Dept. of Informatics, University of Oslo
 Norway: +4791880522
 Skype: knutstar
 http://dhis2.org

>>>
>>>
>>>
>>>
>>>
>>>
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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] Do Aggregate Query builder with null value

2016-04-21 Thread channara rin

Dear All,
Can you tell me the aggregate Query builder can count case/individuals with
condition attribute equal null?

thank you
channara
___
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-users] Resource Table error

2016-04-07 Thread channara rin

dear alex,
how can i do for remove duplicate period?
Yes, right knut.
by the way, if i upgrade to v2.20, that version doesn't have individual
record function, so my problem is i don't want to run aggregate data
automatic.

On Thu, Apr 7, 2016 at 11:29 PM, Knut Staring <knu...@gmail.com> wrote:

> Agree with Alex that you should really try to do an upgrade - just please
> make sure to back up everything first!
>
> However, I notice you had the same problem in October? Was it solve then
> and now it has come back - or have you had the problem now for 6 months?
>
> https://lists.launchpad.net/dhis2-users/msg08287.html
>
> On Thu, Apr 7, 2016 at 6:11 PM, Alex Tumwesigye <atumwesi...@gmail.com>
> wrote:
>
>> Channara,
>>
>> The issue is related to timezone and was fixed. Upgrade to at least 2.20
>> or 2.21 but you have to first remove the duplicate period.
>>
>> Alex
>>
>> On Thu, Apr 7, 2016 at 7:08 PM, Knut Staring <knu...@gmail.com> wrote:
>>
>>> Hi Channara,
>>>
>>> It seems to me that the problem is that the _dateperiodstructure table
>>> has not been dropped (not sure why).
>>>
>>> Then when you try to regenerate it, it tries to insert the same values,
>>> starting from 1975-01-01 (which is the first row in the table)
>>>
>>> On Thu, Apr 7, 2016 at 6:01 PM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> dear Alex,
>>>> what you mean was fixed? i currently using:
>>>> Version:2.19Build revision:19251Build date:2015-07-01 02:04
>>>>
>>>> On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye <atumwesi...@gmail.com
>>>> > wrote:
>>>>
>>>>> Dear Channara,
>>>>>
>>>>> I think this bug was fixed.
>>>>> The date "1975-01-01" is duplicated.
>>>>> check your period table for any anomaly for that date.
>>>>>
>>>>> Alex
>>>>>
>>>>> On Thu, Apr 7, 2016 at 6:02 PM, channara rin <rin.chann...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Dear friend,
>>>>>> when i run analytic, i always got error like below. how to fix this
>>>>>> problem?
>>>>>>
>>>>>> ==
>>>>>> Resource table process failed
>>>>>> Resource table process failed, please check the logs. Time:
>>>>>> 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL
>>>>>> [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; 
>>>>>> ERROR:
>>>>>> duplicate key value violates unique constraint 
>>>>>> "_dateperiodstructure_pkey"
>>>>>> Detail: Key (dateperiod)=(1975-01-01) already exists.; nested
>>>>>> exception is org.postgresql.util.PSQLException: ERROR: duplicate key 
>>>>>> value
>>>>>> violates unique constraint "_dateperiodstructure_pkey"
>>>>>> Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
>>>>>> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>>>>>> unique constraint "_dateperiodstructure_pkey"
>>>>>> Detail: Key (dateperiod)=(1975-01-01) already exists.
>>>>>>
>>>>>> at
>>>>>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
>>>>>>
>>>>>> at
>>>>>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
>>>>>>
>>>>>> at
>>>>>> org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)
>>>>>>
>>>>>> at
>>>>>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)
>>>>>>
>>>>>> at
>>>>>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)
>>>>>>
>>>>>> at
>>>>>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
>>>>>>
>>>>>> at
>>>>>> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)
>>>>>>
>>>>>> at
>>>>>> org.springfr

Re: [Dhis2-devs] [Dhis2-users] Resource Table error

2016-04-07 Thread channara rin

dear Alex,
what you mean was fixed? i currently using:
Version:2.19Build revision:19251Build date:2015-07-01 02:04

On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye <atumwesi...@gmail.com>
wrote:

> Dear Channara,
>
> I think this bug was fixed.
> The date "1975-01-01" is duplicated.
> check your period table for any anomaly for that date.
>
> Alex
>
> On Thu, Apr 7, 2016 at 6:02 PM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> Dear friend,
>> when i run analytic, i always got error like below. how to fix this
>> problem?
>>
>> ==
>> Resource table process failed
>> Resource table process failed, please check the logs. Time:
>> 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL
>> [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR:
>> duplicate key value violates unique constraint "_dateperiodstructure_pkey"
>> Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception
>> is org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>> unique constraint "_dateperiodstructure_pkey"
>> Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
>> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>> unique constraint "_dateperiodstructure_pkey"
>> Detail: Key (dateperiod)=(1975-01-01) already exists.
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)
>>
>> at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)
>>
>> at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)
>>
>> at
>> org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)
>>
>> at
>> org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)
>>
>> at
>> org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)
>>
>> at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)
>>
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>
>> at java.lang.reflect.Method.invoke(Unknown Source)
>>
>> at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>>
>> at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
>>
>> at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)
>>
>> at
>> org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
>>
>> at
>> org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)
>>
>> at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
>>
>> at
>> org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
>>
>> at
>> org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
>>
>> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
>>
>> at java.util.concurrent.FutureTask.run(Unknown Source)
>>
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
>> Source)
>>
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unkn

[Dhis2-devs] Resource Table error

2016-04-07 Thread channara rin

Dear friend,
when i run analytic, i always got error like below. how to fix this problem?

==
Resource table process failed
Resource table process failed, please check the logs. Time:
2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL
[insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR:
duplicate key value violates unique constraint "_dateperiodstructure_pkey"
Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception is
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "_dateperiodstructure_pkey"
Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "_dateperiodstructure_pkey"
Detail: Key (dateperiod)=(1975-01-01) already exists.

at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

at
org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)

at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)

at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

at
org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)

at
org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)

at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)

at
org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)

at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)

at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)

at
org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)

at
org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)

at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)

at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)

at
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

at
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)

at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)

at
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)

at
org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
Source)

at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)
___
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-users] resource table process failed

2016-03-31 Thread channara rin

Dear Alex,
i tried my best to find the same date of  startdate and enddate, but didn't
see any record.

On Wed, Mar 30, 2016 at 4:21 PM, channara rin <rin.chann...@gmail.com>
wrote:

> Ohh,
> let me check. so you mean the startdate and enddate is the same date? and
> periodType=3?
>
>
>
___
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-users] resource table process failed

2016-03-30 Thread channara rin

Ohh,
let me check. so you mean the startdate and enddate is the same date? and
periodType=3?
___
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] resource table process failed

2016-03-30 Thread channara rin

Dear all,
I got this error in console. Could you help me how to fix this problem?

Thank you
Channara

::Console
> Resource table process failed, please check the logs. Time:
2016-03-30T07:30:17.405+07:00. Message: PreparedStatementCallback; SQL
[insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR:
duplicate key value violates unique constraint "_dateperiodstructure_pkey"
> Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception
is org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "_dateperiodstructure_pkey"
> Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "_dateperiodstructure_pkey"
> Detail: Key (dateperiod)=(1975-01-01) already exists.
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
QueryExecutorImpl.java:2198)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(
QueryExecutorImpl.java:1927)
> at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(
QueryExecutorImpl.java:1130)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(
QueryExecutorImpl.java:396)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(
AbstractJdbc2Statement.java:2892)
> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(
NewProxyPreparedStatement.java:1723)
> at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(
JdbcTemplate.java:1005)
> at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(
JdbcTemplate.java:989)
> at org.springframework.jdbc.core.JdbcTemplate.execute(
JdbcTemplate.java:644)
> at org.springframework.jdbc.core.JdbcTemplate.execute(
JdbcTemplate.java:673)
> at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(
JdbcTemplate.java:989)
> at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(
BatchUpdateUtils.java:32)
> at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(
JdbcTemplate.java:1039)
> at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(
JdbcTemplate.java:1034)
> at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(
JdbcResourceTableStore.java:101)
> at org.hisp.dhis.resourcetable.DefaultResourceTableService.
generateDatePeriodTable(DefaultResourceTableService.java:456)
> at sun.reflect.GeneratedMethodAccessor903.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection
(AopUtils.java:317)
> at org.springframework.aop.framework.JdkDynamicAopProxy.
invoke(JdkDynamicAopProxy.java:201)
> at com.sun.proxy.$Proxy104.generateDatePeriodTable(Unknown Source)
> at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.
generateAll(ResourceTableTask.java:121)
> at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.
run(ResourceTableTask.java:85)
> at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
> at org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl
e.run(DelegatingErrorHandlingRunnable.java:54)
> at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(
ReschedulingRunnable.java:81)
> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
> at java.util.concurrent.FutureTask.run(Unknown Source)
> at java.util.concurrent.ScheduledThreadPoolExecutor$
ScheduledFutureTask.access$201(Unknown Source)
> at java.util.concurrent.ScheduledThreadPoolExecutor$
ScheduledFutureTask.run(Unknown Source)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
> at java.lang.Thread.run(Unknown Source)
>
>
>
___
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: [Data Hub • Flagship] Resource table process failed

2016-03-29 Thread channara rin

Dear all,

I got this error in console. could you help me how to fix it?


the error console like below:

> Resource table process failed, please check the logs. Time:
2016-03-30T07:30:17.405+07:00. Message: PreparedStatementCallback; SQL
[insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR:
duplicate key value violates unique constraint "_dateperiodstructure_pkey"
> Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception
is org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "_dateperiodstructure_pkey"
> Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "_dateperiodstructure_pkey"
> Detail: Key (dateperiod)=(1975-01-01) already exists.
> at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
> at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
> at
org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)
> at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)
> at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)
> at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
> at
org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)
> at
org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)
> at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
> at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)
> at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)
> at
org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)
> at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)
> at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)
> at
org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)
> at
org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)
> at sun.reflect.GeneratedMethodAccessor903.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
> at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
> at com.sun.proxy.$Proxy104.generateDatePeriodTable(Unknown Source)
> at
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
> at
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)
> at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
> at
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
> at
org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
> at java.util.concurrent.FutureTask.run(Unknown Source)
> at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
Source)
> at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
Source)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
> at java.lang.Thread.run(Unknown Source)
>
>
>
___
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-users] restore database out of memory

2016-03-19 Thread channara rin

here in java_opts=-Djava.awt.headless=true -Dfile.encoding=UTF-8 -server
-Xms128m -Xmx1024m -XX:NewSize=2048m -XXMaxNewSize=2048m -XX:PermSize=256m
-XX:MaxPermSize=1024m -XX:+DisableExplicitGC -xx:+UseConcMarkSweepGC
-XX:+DisableExplicitGC

On Fri, Mar 18, 2016 at 7:39 PM, Knut Staring <knu...@gmail.com> wrote:

> Hi Channara,
>
> What values do you have for JAVA_OPTS?
>
> On Fri, Mar 18, 2016 at 1:10 PM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> hi all,
>> do you hav any experience with postgresql database?
>> i use command psql/pg_restore into new system. i got out of memory.
>> my system server is 4GB memory and file backup size is around 100MB
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
___
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-users] restore database out of memory

2016-03-19 Thread channara rin

No from hard drive. it has free disk space 100GB for C: and D: is 45GB

On Fri, Mar 18, 2016 at 10:31 PM, Knut Staring <knu...@gmail.com> wrote:

> Sorry Channara, I didn't read your question properly, this has nothing to
> do with JAVA_OPTS.
>
> Unfortunately, I have no experience with getting Postgres out of memory
> errors, though google tells me a lot of people do.
>
> Could it perhaps be that your hard drive is filling up?
>
> On Fri, Mar 18, 2016 at 3:38 PM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> here in java_opts=-Djava.awt.headless=true -Dfile.encoding=UTF-8 -server
>> -Xms128m -Xmx1024m -XX:NewSize=2048m -XXMaxNewSize=2048m -XX:PermSize=256m
>> -XX:MaxPermSize=1024m -XX:+DisableExplicitGC -xx:+UseConcMarkSweepGC
>> -XX:+DisableExplicitGC
>>
>> On Fri, Mar 18, 2016 at 7:39 PM, Knut Staring <knu...@gmail.com> wrote:
>>
>>> Hi Channara,
>>>
>>> What values do you have for JAVA_OPTS?
>>>
>>> On Fri, Mar 18, 2016 at 1:10 PM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> hi all,
>>>> do you hav any experience with postgresql database?
>>>> i use command psql/pg_restore into new system. i got out of memory.
>>>> my system server is 4GB memory and file backup size is around 100MB
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-us...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> Norway: +4791880522
>>> Skype: knutstar
>>> http://dhis2.org
>>>
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
___
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-users] restore database out of memory

2016-03-19 Thread channara rin

thank you :-)

On Sat, Mar 19, 2016 at 1:32 PM, gerald thomas <gerald17...@gmail.com>
wrote:

> Dear Channara,
> I think Dcocos solution should be a break through and it will minimize the
> database size.
>
> Regards,
> Gerald
> On Mar 19, 2016 05:03, "channara rin" <rin.chann...@gmail.com> wrote:
>
>> Thank you,
>> let me try testing...
>> and by the way, i configured and can run DHIS2 on localhost already. but
>> when i plug data into existing DHIS2. it is out of memory.
>>
>> On Sat, Mar 19, 2016 at 10:08 AM, dcocos <dco...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> If you dump with (where dbname is your rename)
>>> pg_dump dbname -O -T _* -T aggregated* -T analytics* -T completeness*
>>>
>>> This will dump without the generated tables which you can recreate by
>>> running analytics this reduces the size of the import often by an order of
>>> magnitude.
>>>
>>> On Mar 18, 2016, at 10:14 PM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>> Hi bob,
>>> when i backup, i use command pg_dumpall.
>>> i can restore on my personal laptop with 4GB Memory. but for desktop
>>> seem out of memory.
>>> i will re-check again on task manager what is still processing.
>>>
>>> On Fri, Mar 18, 2016 at 11:14 PM, Bob Jolliffe <bobjolli...@gmail.com>
>>> wrote:
>>>
>>>> One other quick thought that is easy to test and eliminate.  Postgres
>>>> out of memory errors on restore can also result from a corrupted dump
>>>> file.  It might be worthwhile to check on another system that your
>>>> dump is good.
>>>>
>>>> On 18 March 2016 at 17:08, Bob Jolliffe <bobjolli...@gmail.com> wrote:
>>>> > Ah you are on Windoze.  I also don't have much real experience of
>>>> > running dhis2 other than on linux, but it strikes me that
>>>> > (i) 4G machine is small but should still "work"
>>>> > (ii) the databse size you are talking about 100m is quite small and
>>>> > the restore operation should not be consuming vast amounts of memory
>>>> > (iii) postgres will run, albeit not very efficiently, with quite small
>>>> > amounts of memory.
>>>> >
>>>> > So ...
>>>> >
>>>> > I think you need to look at what else you have running on that machine
>>>> > which could be consuming the bulk of memory.  I think windoze system
>>>> > tools like task manager and perfmon.exe might show you useful
>>>> > information.
>>>> >
>>>> > Have you modified postgres config or is it default setting?  Default
>>>> > settings would be very conservative but should work.  If you have
>>>> > modified, you might have given postgres the impression it has more
>>>> > memory available than actually exists.
>>>> >
>>>> > On 18 March 2016 at 16:53, channara rin <rin.chann...@gmail.com>
>>>> wrote:
>>>> >> No from hard drive. it has free disk space 100GB for C: and D: is
>>>> 45GB
>>>> >>
>>>> >> On Fri, Mar 18, 2016 at 10:31 PM, Knut Staring <knu...@gmail.com>
>>>> wrote:
>>>> >>>
>>>> >>> Sorry Channara, I didn't read your question properly, this has
>>>> nothing to
>>>> >>> do with JAVA_OPTS.
>>>> >>>
>>>> >>> Unfortunately, I have no experience with getting Postgres out of
>>>> memory
>>>> >>> errors, though google tells me a lot of people do.
>>>> >>>
>>>> >>> Could it perhaps be that your hard drive is filling up?
>>>> >>>
>>>> >>> On Fri, Mar 18, 2016 at 3:38 PM, channara rin <
>>>> rin.chann...@gmail.com>
>>>> >>> wrote:
>>>> >>>>
>>>> >>>> here in java_opts=-Djava.awt.headless=true -Dfile.encoding=UTF-8
>>>> -server
>>>> >>>> -Xms128m -Xmx1024m -XX:NewSize=2048m -XXMaxNewSize=2048m
>>>> -XX:PermSize=256m
>>>> >>>> -XX:MaxPermSize=1024m -XX:+DisableExplicitGC
>>>> -xx:+UseConcMarkSweepGC
>>>> >>>> -XX:+DisableExplicitGC
>>>> >>>>
>>>> >>>> On Fri, Mar 18, 2016 at

Re: [Dhis2-devs] [Dhis2-users] restore database out of memory

2016-03-18 Thread channara rin

Thank you,
let me try testing...
and by the way, i configured and can run DHIS2 on localhost already. but
when i plug data into existing DHIS2. it is out of memory.

On Sat, Mar 19, 2016 at 10:08 AM, dcocos <dco...@gmail.com> wrote:

> Hi,
>
> If you dump with (where dbname is your rename)
> pg_dump dbname -O -T _* -T aggregated* -T analytics* -T completeness*
>
> This will dump without the generated tables which you can recreate by
> running analytics this reduces the size of the import often by an order of
> magnitude.
>
> On Mar 18, 2016, at 10:14 PM, channara rin <rin.chann...@gmail.com> wrote:
>
> Hi bob,
> when i backup, i use command pg_dumpall.
> i can restore on my personal laptop with 4GB Memory. but for desktop seem
> out of memory.
> i will re-check again on task manager what is still processing.
>
> On Fri, Mar 18, 2016 at 11:14 PM, Bob Jolliffe <bobjolli...@gmail.com>
> wrote:
>
>> One other quick thought that is easy to test and eliminate.  Postgres
>> out of memory errors on restore can also result from a corrupted dump
>> file.  It might be worthwhile to check on another system that your
>> dump is good.
>>
>> On 18 March 2016 at 17:08, Bob Jolliffe <bobjolli...@gmail.com> wrote:
>> > Ah you are on Windoze.  I also don't have much real experience of
>> > running dhis2 other than on linux, but it strikes me that
>> > (i) 4G machine is small but should still "work"
>> > (ii) the databse size you are talking about 100m is quite small and
>> > the restore operation should not be consuming vast amounts of memory
>> > (iii) postgres will run, albeit not very efficiently, with quite small
>> > amounts of memory.
>> >
>> > So ...
>> >
>> > I think you need to look at what else you have running on that machine
>> > which could be consuming the bulk of memory.  I think windoze system
>> > tools like task manager and perfmon.exe might show you useful
>> > information.
>> >
>> > Have you modified postgres config or is it default setting?  Default
>> > settings would be very conservative but should work.  If you have
>> > modified, you might have given postgres the impression it has more
>> > memory available than actually exists.
>> >
>> > On 18 March 2016 at 16:53, channara rin <rin.chann...@gmail.com> wrote:
>> >> No from hard drive. it has free disk space 100GB for C: and D: is 45GB
>> >>
>> >> On Fri, Mar 18, 2016 at 10:31 PM, Knut Staring <knu...@gmail.com>
>> wrote:
>> >>>
>> >>> Sorry Channara, I didn't read your question properly, this has
>> nothing to
>> >>> do with JAVA_OPTS.
>> >>>
>> >>> Unfortunately, I have no experience with getting Postgres out of
>> memory
>> >>> errors, though google tells me a lot of people do.
>> >>>
>> >>> Could it perhaps be that your hard drive is filling up?
>> >>>
>> >>> On Fri, Mar 18, 2016 at 3:38 PM, channara rin <rin.chann...@gmail.com
>> >
>> >>> wrote:
>> >>>>
>> >>>> here in java_opts=-Djava.awt.headless=true -Dfile.encoding=UTF-8
>> -server
>> >>>> -Xms128m -Xmx1024m -XX:NewSize=2048m -XXMaxNewSize=2048m
>> -XX:PermSize=256m
>> >>>> -XX:MaxPermSize=1024m -XX:+DisableExplicitGC -xx:+UseConcMarkSweepGC
>> >>>> -XX:+DisableExplicitGC
>> >>>>
>> >>>> On Fri, Mar 18, 2016 at 7:39 PM, Knut Staring <knu...@gmail.com>
>> wrote:
>> >>>>>
>> >>>>> Hi Channara,
>> >>>>>
>> >>>>> What values do you have for JAVA_OPTS?
>> >>>>>
>> >>>>> On Fri, Mar 18, 2016 at 1:10 PM, channara rin <
>> rin.chann...@gmail.com>
>> >>>>> wrote:
>> >>>>>>
>> >>>>>> hi all,
>> >>>>>> do you hav any experience with postgresql database?
>> >>>>>> i use command psql/pg_restore into new system. i got out of memory.
>> >>>>>> my system server is 4GB memory and file backup size is around 100MB
>> >>>>>>
>> >>>>>> ___
>> >>>>>> Mailing list: https://launchpad.net/~dhis2-users
>> >>>>>> Post to : dhis2-us...@lists.launchpad.net
>> >>>>>> Unsubscri

Re: [Dhis2-devs] [Dhis2-users] restore database out of memory

2016-03-18 Thread channara rin

Hi bob,
when i backup, i use command pg_dumpall.
i can restore on my personal laptop with 4GB Memory. but for desktop seem
out of memory.
i will re-check again on task manager what is still processing.

On Fri, Mar 18, 2016 at 11:14 PM, Bob Jolliffe <bobjolli...@gmail.com>
wrote:

> One other quick thought that is easy to test and eliminate.  Postgres
> out of memory errors on restore can also result from a corrupted dump
> file.  It might be worthwhile to check on another system that your
> dump is good.
>
> On 18 March 2016 at 17:08, Bob Jolliffe <bobjolli...@gmail.com> wrote:
> > Ah you are on Windoze.  I also don't have much real experience of
> > running dhis2 other than on linux, but it strikes me that
> > (i) 4G machine is small but should still "work"
> > (ii) the databse size you are talking about 100m is quite small and
> > the restore operation should not be consuming vast amounts of memory
> > (iii) postgres will run, albeit not very efficiently, with quite small
> > amounts of memory.
> >
> > So ...
> >
> > I think you need to look at what else you have running on that machine
> > which could be consuming the bulk of memory.  I think windoze system
> > tools like task manager and perfmon.exe might show you useful
> > information.
> >
> > Have you modified postgres config or is it default setting?  Default
> > settings would be very conservative but should work.  If you have
> > modified, you might have given postgres the impression it has more
> > memory available than actually exists.
> >
> > On 18 March 2016 at 16:53, channara rin <rin.chann...@gmail.com> wrote:
> >> No from hard drive. it has free disk space 100GB for C: and D: is 45GB
> >>
> >> On Fri, Mar 18, 2016 at 10:31 PM, Knut Staring <knu...@gmail.com>
> wrote:
> >>>
> >>> Sorry Channara, I didn't read your question properly, this has nothing
> to
> >>> do with JAVA_OPTS.
> >>>
> >>> Unfortunately, I have no experience with getting Postgres out of memory
> >>> errors, though google tells me a lot of people do.
> >>>
> >>> Could it perhaps be that your hard drive is filling up?
> >>>
> >>> On Fri, Mar 18, 2016 at 3:38 PM, channara rin <rin.chann...@gmail.com>
> >>> wrote:
> >>>>
> >>>> here in java_opts=-Djava.awt.headless=true -Dfile.encoding=UTF-8
> -server
> >>>> -Xms128m -Xmx1024m -XX:NewSize=2048m -XXMaxNewSize=2048m
> -XX:PermSize=256m
> >>>> -XX:MaxPermSize=1024m -XX:+DisableExplicitGC -xx:+UseConcMarkSweepGC
> >>>> -XX:+DisableExplicitGC
> >>>>
> >>>> On Fri, Mar 18, 2016 at 7:39 PM, Knut Staring <knu...@gmail.com>
> wrote:
> >>>>>
> >>>>> Hi Channara,
> >>>>>
> >>>>> What values do you have for JAVA_OPTS?
> >>>>>
> >>>>> On Fri, Mar 18, 2016 at 1:10 PM, channara rin <
> rin.chann...@gmail.com>
> >>>>> wrote:
> >>>>>>
> >>>>>> hi all,
> >>>>>> do you hav any experience with postgresql database?
> >>>>>> i use command psql/pg_restore into new system. i got out of memory.
> >>>>>> my system server is 4GB memory and file backup size is around 100MB
> >>>>>>
> >>>>>> ___
> >>>>>> Mailing list: https://launchpad.net/~dhis2-users
> >>>>>> Post to : dhis2-us...@lists.launchpad.net
> >>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
> >>>>>> More help   : https://help.launchpad.net/ListHelp
> >>>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>> --
> >>>>> Knut Staring
> >>>>> Dept. of Informatics, University of Oslo
> >>>>> Norway: +4791880522
> >>>>> Skype: knutstar
> >>>>> http://dhis2.org
> >>>>
> >>>>
> >>>
> >>>
> >>>
> >>> --
> >>> Knut Staring
> >>> Dept. of Informatics, University of Oslo
> >>> Norway: +4791880522
> >>> Skype: knutstar
> >>> http://dhis2.org
> >>
> >>
> >>
> >> ___
> >> Mailing list: https://launchpad.net/~dhis2-users
> >> Post to : dhis2-us...@lists.launchpad.net
> >> Unsubscribe : https://launchpad.net/~dhis2-users
> >> 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] restore database out of memory

2016-03-18 Thread channara rin

hi all,
do you hav any experience with postgresql database?
i use command psql/pg_restore into new system. i got out of memory.
my system server is 4GB memory and file backup size is around 100MB
___
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] Long text type didn't disable after approve

2016-02-24 Thread channara rin

Hi DHIS2,
I used DHIS2 v2.19
my problem is if i approved on data entry, all numeric fields are disable
to prevent changing. but the long text type for comment didn't disable

[image: Inline image 1]
___
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] How to get unique ID individuals in tracker capture

2016-01-18 Thread channara rin

Dear all,
I justed imported profile of individuals into Tracker Capture throught API
access. and then i want to update profile of individuals around 100records.
so API need unique ID of individuals in tracker capture. so how can i get
all unique ID that i just imported and match with existing list of
individuals?

thank you
CHANNARA
___
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] javascript Code

2016-01-11 Thread channara rin

Dear all,
I wrote code javascript "dhis2.de.currentOrganisationUnited;" to display
OrgUnit in Custom Form in Data Entry. It work fine.
But when i go to "Data Approval" for making approve value in custom Form.
the error occured was undefined "currentOrganisationUnited"

DO YOU KNOW HOW TO SOLVE IT?

thank you
CHANNARA
___
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] How to build a form with tracker

2016-01-07 Thread channara rin

Dear All
Has anyone tell me how should i design tracker form(individual
records/tracker capture) to capture data daily that can answer this
questions below?

Every month,quarterly, and six months, manager need data elements report
from DHIS2 to answer on:

1.How many people(individual case) get ART in this month?
3.How many people(individual case) get ART regular every months(From
January to June)?

*NOTE:* usually, individual can get ART only once per month.

Thank you
CHANNARA
___
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] Data Elements in Custom Form

2015-12-31 Thread channara rin

Hi friends,

DO you know what wrong to dataelements?
Usually, if we put cursor in textbox of data element for input value, and
leave cursor. the textbox always display background color like green color,
yellow or red color. But some data elements didn't display background
color.. so the result is doesn't save value in data elements.

could you help me what is problem?

thank you
CHANNARA
___
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 elements for tracker

2015-11-12 Thread channara rin

OK, i see

On Thu, Nov 12, 2015 at 5:52 PM, Lars Helge Øverland <larshe...@gmail.com>
wrote:

> Hi Channara,
>
> that is not possible right now. You could instead create multiple data
> elements of type "Yes only", group them together in the form and check the
> ones you want. That will make analysis easier later as well.
>
> regards,
>
> Lars
>
>
> On Thu, Nov 12, 2015 at 3:47 AM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> Hi all members,
>> do you know data elements  for tracker can set option set for user entry
>> individual records can choose multi-value?
>>
>> thank you
>>
>>
>> ___
>> 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
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org <https://www.dhis2.org>
>
>
___
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] data elements for tracker

2015-11-11 Thread channara rin

Hi all members,
do you know data elements  for tracker can set option set for user entry
individual records can choose multi-value?

thank you
___
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] openID

2015-11-05 Thread channara rin

Thank you Morten,
but i saw only Gmail can use, can use yahoo mail, outlook domain?

On Fri, Nov 6, 2015 at 11:35 AM, channara rin <rin.chann...@gmail.com>
wrote:

> Oh, i didn't read. :-)
>
> On Fri, Nov 6, 2015 at 11:32 AM, Morten Olav Hansen <morte...@gmail.com>
> wrote:
>
>> Hi
>>
>> What have you tried so far, and what is not working? (I assume you have
>> read the chapter about openid in our user manual)
>>
>> https://www.dhis2.org/doc/snapshot/en/user/html/ch07.html#d5e1573
>>
>> --
>> Morten
>>
>> On Fri, Nov 6, 2015 at 11:13 AM, channara rin <rin.chann...@gmail.com>
>> wrote:
>>
>>> Hi all friend DHIS2,
>>> could you guide how to put OpenID in DHIS2 to make working?
>>>
>>> thank you
>>>
>>>
>>> ___
>>> 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] openID

2015-11-05 Thread channara rin

hi morten,
i did like below, is it right?
[image: Inline image 1]


On Fri, Nov 6, 2015 at 1:32 PM, channara rin <rin.chann...@gmail.com> wrote:

> Thank you Morten,
> but i saw only Gmail can use, can use yahoo mail, outlook domain?
>
> On Fri, Nov 6, 2015 at 11:35 AM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> Oh, i didn't read. :-)
>>
>> On Fri, Nov 6, 2015 at 11:32 AM, Morten Olav Hansen <morte...@gmail.com>
>> wrote:
>>
>>> Hi
>>>
>>> What have you tried so far, and what is not working? (I assume you have
>>> read the chapter about openid in our user manual)
>>>
>>> https://www.dhis2.org/doc/snapshot/en/user/html/ch07.html#d5e1573
>>>
>>> --
>>> Morten
>>>
>>> On Fri, Nov 6, 2015 at 11:13 AM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> Hi all friend DHIS2,
>>>> could you guide how to put OpenID in DHIS2 to make working?
>>>>
>>>> thank you
>>>>
>>>>
>>>> ___
>>>> 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-users] Condition on Attribute of tracked Entity

2015-11-05 Thread channara rin

i am using V2.20

On Fri, Nov 6, 2015 at 11:27 AM, Prosper BT <ptb3...@gmail.com> wrote:

> Dear Channara,
>
> Which version are you using,
>
> This was implemented in version 2.21 see blue print
>
> https://blueprints.launchpad.net/dhis2/+spec/program-rules-during-registration-enrollment
>
> Regards
>
>
> On Fri, Nov 6, 2015 at 7:05 AM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> Hi all,
>> can i put condition to hide or show some attribute of tracked entity?
>> Example when user create new tracked entity, user need to fill some
>> attribute like ID, Name, Sex.
>> If Sex is Female, should show Pregnant Attribute.
>>
>> So how should i do in DHIS2?
>>
>> thank you
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Global HISP| University Of Oslo/HISP Uganda
> +256 752 751 776 | +256 776 139 139
> ptb3...@gmail.com | pros...@dhis2.org | Skype: prospertb
>
>
___
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] openID

2015-11-05 Thread channara rin

Hi all friend DHIS2,
could you guide how to put OpenID in DHIS2 to make working?

thank you
___
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] Condition on Attribute of tracked Entity

2015-11-05 Thread channara rin

Hi all,
can i put condition to hide or show some attribute of tracked entity?
Example when user create new tracked entity, user need to fill some
attribute like ID, Name, Sex.
If Sex is Female, should show Pregnant Attribute.

So how should i do in DHIS2?

thank you
___
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-users] Condition on Attribute of tracked Entity

2015-11-05 Thread channara rin

OHH, I see. but has rule that i asked above?

On Fri, Nov 6, 2015 at 11:32 AM, Prosper BT <ptb3...@gmail.com> wrote:

> Sorry its only available in 2.21
>
> There are more features on rules in 2.21
>
> Regards
>
> On Fri, Nov 6, 2015 at 7:28 AM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> i am using V2.20
>>
>> On Fri, Nov 6, 2015 at 11:27 AM, Prosper BT <ptb3...@gmail.com> wrote:
>>
>>> Dear Channara,
>>>
>>> Which version are you using,
>>>
>>> This was implemented in version 2.21 see blue print
>>>
>>> https://blueprints.launchpad.net/dhis2/+spec/program-rules-during-registration-enrollment
>>>
>>> Regards
>>>
>>>
>>> On Fri, Nov 6, 2015 at 7:05 AM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> Hi all,
>>>> can i put condition to hide or show some attribute of tracked entity?
>>>> Example when user create new tracked entity, user need to fill some
>>>> attribute like ID, Name, Sex.
>>>> If Sex is Female, should show Pregnant Attribute.
>>>>
>>>> So how should i do in DHIS2?
>>>>
>>>> thank you
>>>>
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-us...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Prosper Behumbiize, MPH
>>> Global HISP| University Of Oslo/HISP Uganda
>>> +256 752 751 776 | +256 776 139 139
>>> ptb3...@gmail.com | pros...@dhis2.org | Skype: prospertb
>>>
>>>
>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Global HISP| University Of Oslo/HISP Uganda
> +256 752 751 776 | +256 776 139 139
> ptb3...@gmail.com | pros...@dhis2.org | Skype: prospertb
>
>
___
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] openID

2015-11-05 Thread channara rin

I added username openid already. but i don't know what i put openid
provider URL?

On Fri, Nov 6, 2015 at 1:51 PM, Morten Olav Hansen <morte...@gmail.com>
wrote:

> No, the openid provider is the server you are connecting to.. the actual
> openid username etc must be added to your dhis2 user.. if you go edit user,
> you will see there is a field called openid
>
> --
> Morten
>
> On Fri, Nov 6, 2015 at 1:46 PM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> hi morten,
>> i did like below, is it right?
>> [image: Inline image 1]
>>
>>
>> On Fri, Nov 6, 2015 at 1:32 PM, channara rin <rin.chann...@gmail.com>
>> wrote:
>>
>>> Thank you Morten,
>>> but i saw only Gmail can use, can use yahoo mail, outlook domain?
>>>
>>> On Fri, Nov 6, 2015 at 11:35 AM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> Oh, i didn't read. :-)
>>>>
>>>> On Fri, Nov 6, 2015 at 11:32 AM, Morten Olav Hansen <morte...@gmail.com
>>>> > wrote:
>>>>
>>>>> Hi
>>>>>
>>>>> What have you tried so far, and what is not working? (I assume you
>>>>> have read the chapter about openid in our user manual)
>>>>>
>>>>> https://www.dhis2.org/doc/snapshot/en/user/html/ch07.html#d5e1573
>>>>>
>>>>> --
>>>>> Morten
>>>>>
>>>>> On Fri, Nov 6, 2015 at 11:13 AM, channara rin <rin.chann...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Hi all friend DHIS2,
>>>>>> could you guide how to put OpenID in DHIS2 to make working?
>>>>>>
>>>>>> thank you
>>>>>>
>>>>>>
>>>>>> ___
>>>>>> 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] openID

2015-11-05 Thread channara rin

I mean i host DHIS2 server in my organisation and can access from outside
internet. my problem is can't login with OpenID, after i added OpenID
Provider is:https://www.google.com/accounts/o8/id and added gmailID into
user management in field: OpenID already.

by the way, if new version support LDAP server, it is great. :-)

On Fri, Nov 6, 2015 at 2:24 PM, Morten Olav Hansen <morte...@gmail.com>
wrote:

> You mean your own DHIS2 server? or OpenID server? I'm not sure if GMail
> supports openid 2 anymore, I think maybe they just support openid connect
> (which we don't support)
>
> You need to find a new page with information, there is a lot of outdated
> info out there..
>
> Btw, for 2.22 we are also adding LDAP authentication support.. so that
> might be something to also look into (this will also require that you have
> your own LDAP server of course)
>
> --
> Morten
>
> On Fri, Nov 6, 2015 at 2:20 PM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> Hi Morten,
>> i hosted by own server. so can i do Openid Provider of gmail account URL
>> like this: https://www.google.com/accounts/o8/id?
>>
>>
>> On Fri, Nov 6, 2015 at 2:09 PM, Morten Olav Hansen <morte...@gmail.com>
>> wrote:
>>
>>> Well.. that depends on what provider you are using.. every provider
>>> should have a URL that you can connect to (it could be your own server, or
>>> a third party openid provider)
>>>
>>> --
>>> Morten
>>>
>>> On Fri, Nov 6, 2015 at 1:59 PM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> I added username openid already. but i don't know what i put openid
>>>> provider URL?
>>>>
>>>> On Fri, Nov 6, 2015 at 1:51 PM, Morten Olav Hansen <morte...@gmail.com>
>>>> wrote:
>>>>
>>>>> No, the openid provider is the server you are connecting to.. the
>>>>> actual openid username etc must be added to your dhis2 user.. if you go
>>>>> edit user, you will see there is a field called openid
>>>>>
>>>>> --
>>>>> Morten
>>>>>
>>>>> On Fri, Nov 6, 2015 at 1:46 PM, channara rin <rin.chann...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> hi morten,
>>>>>> i did like below, is it right?
>>>>>> [image: Inline image 1]
>>>>>>
>>>>>>
>>>>>> On Fri, Nov 6, 2015 at 1:32 PM, channara rin <rin.chann...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Thank you Morten,
>>>>>>> but i saw only Gmail can use, can use yahoo mail, outlook domain?
>>>>>>>
>>>>>>> On Fri, Nov 6, 2015 at 11:35 AM, channara rin <
>>>>>>> rin.chann...@gmail.com> wrote:
>>>>>>>
>>>>>>>> Oh, i didn't read. :-)
>>>>>>>>
>>>>>>>> On Fri, Nov 6, 2015 at 11:32 AM, Morten Olav Hansen <
>>>>>>>> morte...@gmail.com> wrote:
>>>>>>>>
>>>>>>>>> Hi
>>>>>>>>>
>>>>>>>>> What have you tried so far, and what is not working? (I assume you
>>>>>>>>> have read the chapter about openid in our user manual)
>>>>>>>>>
>>>>>>>>> https://www.dhis2.org/doc/snapshot/en/user/html/ch07.html#d5e1573
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Morten
>>>>>>>>>
>>>>>>>>> On Fri, Nov 6, 2015 at 11:13 AM, channara rin <
>>>>>>>>> rin.chann...@gmail.com> wrote:
>>>>>>>>>
>>>>>>>>>> Hi all friend DHIS2,
>>>>>>>>>> could you guide how to put OpenID in DHIS2 to make working?
>>>>>>>>>>
>>>>>>>>>> thank you
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> ___
>>>>>>>>>> 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] openID

2015-11-05 Thread channara rin

Hi Morten,
i hosted by own server. so can i do Openid Provider of gmail account URL
like this: https://www.google.com/accounts/o8/id?


On Fri, Nov 6, 2015 at 2:09 PM, Morten Olav Hansen <morte...@gmail.com>
wrote:

> Well.. that depends on what provider you are using.. every provider should
> have a URL that you can connect to (it could be your own server, or a third
> party openid provider)
>
> --
> Morten
>
> On Fri, Nov 6, 2015 at 1:59 PM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> I added username openid already. but i don't know what i put openid
>> provider URL?
>>
>> On Fri, Nov 6, 2015 at 1:51 PM, Morten Olav Hansen <morte...@gmail.com>
>> wrote:
>>
>>> No, the openid provider is the server you are connecting to.. the actual
>>> openid username etc must be added to your dhis2 user.. if you go edit user,
>>> you will see there is a field called openid
>>>
>>> --
>>> Morten
>>>
>>> On Fri, Nov 6, 2015 at 1:46 PM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> hi morten,
>>>> i did like below, is it right?
>>>> [image: Inline image 1]
>>>>
>>>>
>>>> On Fri, Nov 6, 2015 at 1:32 PM, channara rin <rin.chann...@gmail.com>
>>>> wrote:
>>>>
>>>>> Thank you Morten,
>>>>> but i saw only Gmail can use, can use yahoo mail, outlook domain?
>>>>>
>>>>> On Fri, Nov 6, 2015 at 11:35 AM, channara rin <rin.chann...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Oh, i didn't read. :-)
>>>>>>
>>>>>> On Fri, Nov 6, 2015 at 11:32 AM, Morten Olav Hansen <
>>>>>> morte...@gmail.com> wrote:
>>>>>>
>>>>>>> Hi
>>>>>>>
>>>>>>> What have you tried so far, and what is not working? (I assume you
>>>>>>> have read the chapter about openid in our user manual)
>>>>>>>
>>>>>>> https://www.dhis2.org/doc/snapshot/en/user/html/ch07.html#d5e1573
>>>>>>>
>>>>>>> --
>>>>>>> Morten
>>>>>>>
>>>>>>> On Fri, Nov 6, 2015 at 11:13 AM, channara rin <
>>>>>>> rin.chann...@gmail.com> wrote:
>>>>>>>
>>>>>>>> Hi all friend DHIS2,
>>>>>>>> could you guide how to put OpenID in DHIS2 to make working?
>>>>>>>>
>>>>>>>> thank you
>>>>>>>>
>>>>>>>>
>>>>>>>> ___
>>>>>>>> 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] openID

2015-11-05 Thread channara rin

I see
thank you for finding for me

On Fri, Nov 6, 2015 at 2:50 PM, Morten Olav Hansen <morte...@gmail.com>
wrote:

> Yes, my point was that info out there is a bit outdated.. if you read [1]
> you will see that openid 2 is not supported by google anymore, so you need
> to find another openid provider.. I'm not sure what is available for free,
> and what is available as self hosted.. but I'm sure there are multiple
> providers out there
>
> [1]
> https://developers.google.com/identity/protocols/OpenID2Migration?hl=en
>
> --
> Morten
>
> On Fri, Nov 6, 2015 at 2:34 PM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> I mean i host DHIS2 server in my organisation and can access from outside
>> internet. my problem is can't login with OpenID, after i added OpenID
>> Provider is:https://www.google.com/accounts/o8/id and added gmailID into
>> user management in field: OpenID already.
>>
>> by the way, if new version support LDAP server, it is great. :-)
>>
>> On Fri, Nov 6, 2015 at 2:24 PM, Morten Olav Hansen <morte...@gmail.com>
>> wrote:
>>
>>> You mean your own DHIS2 server? or OpenID server? I'm not sure if GMail
>>> supports openid 2 anymore, I think maybe they just support openid connect
>>> (which we don't support)
>>>
>>> You need to find a new page with information, there is a lot of outdated
>>> info out there..
>>>
>>> Btw, for 2.22 we are also adding LDAP authentication support.. so that
>>> might be something to also look into (this will also require that you have
>>> your own LDAP server of course)
>>>
>>> --
>>> Morten
>>>
>>> On Fri, Nov 6, 2015 at 2:20 PM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> Hi Morten,
>>>> i hosted by own server. so can i do Openid Provider of gmail account
>>>> URL like this: https://www.google.com/accounts/o8/id?
>>>>
>>>>
>>>> On Fri, Nov 6, 2015 at 2:09 PM, Morten Olav Hansen <morte...@gmail.com>
>>>> wrote:
>>>>
>>>>> Well.. that depends on what provider you are using.. every provider
>>>>> should have a URL that you can connect to (it could be your own server, or
>>>>> a third party openid provider)
>>>>>
>>>>> --
>>>>> Morten
>>>>>
>>>>> On Fri, Nov 6, 2015 at 1:59 PM, channara rin <rin.chann...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> I added username openid already. but i don't know what i put openid
>>>>>> provider URL?
>>>>>>
>>>>>> On Fri, Nov 6, 2015 at 1:51 PM, Morten Olav Hansen <
>>>>>> morte...@gmail.com> wrote:
>>>>>>
>>>>>>> No, the openid provider is the server you are connecting to.. the
>>>>>>> actual openid username etc must be added to your dhis2 user.. if you go
>>>>>>> edit user, you will see there is a field called openid
>>>>>>>
>>>>>>> --
>>>>>>> Morten
>>>>>>>
>>>>>>> On Fri, Nov 6, 2015 at 1:46 PM, channara rin <rin.chann...@gmail.com
>>>>>>> > wrote:
>>>>>>>
>>>>>>>> hi morten,
>>>>>>>> i did like below, is it right?
>>>>>>>> [image: Inline image 1]
>>>>>>>>
>>>>>>>>
>>>>>>>> On Fri, Nov 6, 2015 at 1:32 PM, channara rin <
>>>>>>>> rin.chann...@gmail.com> wrote:
>>>>>>>>
>>>>>>>>> Thank you Morten,
>>>>>>>>> but i saw only Gmail can use, can use yahoo mail, outlook domain?
>>>>>>>>>
>>>>>>>>> On Fri, Nov 6, 2015 at 11:35 AM, channara rin <
>>>>>>>>> rin.chann...@gmail.com> wrote:
>>>>>>>>>
>>>>>>>>>> Oh, i didn't read. :-)
>>>>>>>>>>
>>>>>>>>>> On Fri, Nov 6, 2015 at 11:32 AM, Morten Olav Hansen <
>>>>>>>>>> morte...@gmail.com> wrote:
>>>>>>>>>>
>>>>>>>>>>> Hi
>>>>>>>>>>>
>>>>>>>>>>> What have you tried so far, and what is not working? (I assume
>>>>>>>>>>> you have read the chapter about openid in our user manual)
>>>>>>>>>>>
>>>>>>>>>>> https://www.dhis2.org/doc/snapshot/en/user/html/ch07.html#d5e1573
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> Morten
>>>>>>>>>>>
>>>>>>>>>>> On Fri, Nov 6, 2015 at 11:13 AM, channara rin <
>>>>>>>>>>> rin.chann...@gmail.com> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Hi all friend DHIS2,
>>>>>>>>>>>> could you guide how to put OpenID in DHIS2 to make working?
>>>>>>>>>>>>
>>>>>>>>>>>> thank you
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> ___
>>>>>>>>>>>> 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-users] dhis version 2.21 is released

2015-10-26 Thread channara rin

thank you alot with greate features. :-)

On Mon, Oct 26, 2015 at 4:17 PM, Shurajit Dutta 
wrote:

> Hi Harivola,
>
> When using 2.21 are you also using java 8 and tomcat 7?
>
> Nick
>
> On Mon, Oct 26, 2015 at 4:55 PM, Harivola RANDRIANJAFY 
> wrote:
>
>> Hi Lars,
>>
>>
>>
>> Thank you for this great work, I am using now 2.20 (build 19960) in test
>> server. Upgrading this into 2.21, I am facing with blank screen (no login
>> action). Downgrading into 2.20, the tracked entity instance in
>> Individual records could not be accessed -  likewise in Tracker Capture,
>> all tracked entity already registered could not be accessed in dashboard
>> Tracker.
>>
>>
>>
>> Please, could you help on this ?
>>
>>
>>
>> Sincerely,
>>
>>
>>
>> Harivola
>>
>>
>>
>> *De :* Dhis2-users [
>> mailto:dhis2-users-bounces+harivolar=psi...@lists.launchpad.net
>> ] *De la part
>> de* Lars Helge Øverland
>> *Envoyé :* mercredi 21 octobre 2015 23:03
>> *À :* DHIS 2 Users list ; DHIS 2
>> Developers list 
>> *Objet :* [Dhis2-users] dhis version 2.21 is released
>>
>>
>>
>> Hi all,
>>
>>
>>
>> DHIS version 2.21 is out with a lot of great new features and
>> improvements.
>>
>>
>>
>> Log in with admin/district on the demo 
>> system.
>>
>>
>>
>> *File cloud storage:* You can now upload and store large files directly
>> from data entry forms. Data elements can have a file value type and render
>> as file upload widgets in forms. Files can be stored either on the Web
>> server or sent directly to AWS S3  cloud
>> storage, which in practice provides unlimited storage capacity. This
>> capability allows you to use DHIS 2 as a general document repository which
>> can be utilized for project management, documentation, CMS and many other
>> purposes.
>>
>>
>>
>> File storage currently works for aggregate data entry forms - tracker
>> coming up. Have a look at the “Project management” data set in data entry
>> on the demo:
>>
>>
>>
>> Demo  | Docs
>> 
>> | Screenshot 
>>
>>
>>
>> *Settings app:* The settings front-end has been re-written as a true
>> app. It features real-time saving, search for settings and a fresh new look.
>>
>>
>>
>> Demo  | Docs
>>  | Screenshot
>> 
>>
>>
>>
>> *Data import constraints:* Several optional constraints for data import
>> can be enabled to provide stricter control of the data being imported.
>> These include require period to be of same type as data set, data element
>> to be assigned to data set through org units, and more. The import
>> constraints can be enabled in settings app under “data import”.
>>
>>
>>
>> Docs 
>>
>>
>>
>> ANALYTICS FEATURES
>>
>> ---
>>
>>
>>
>> *Functions and variables in program indicators:* Program indicators
>> support a range of functions and variables. Functions allows for
>> conditional statements, calculation of number of days between dates and
>> more. Variables allows you to insert e.g. event date, enrollment date and
>> value count into expressions. This is useful for example to calculate
>> “inpatient bed days” and complex scores.
>>
>>
>>
>> Docs  | Demo
>> 1 
>> | 2 
>> | Screenshot 1
>>  | 2
>> 
>> | 3 
>> | 4
>> 
>> |
>>
>>
>>
>> *Custom aggregation types:* A program indicator now has an aggregation
>> type property with the standard options such as sum, avg, count, std dev
>> min, max. When set to *custom*, the indicator expression can contain
>> inline aggregation types, allowing for greater control over aggregation.
>>
>>
>>
>> Docs  |
>> Screenshot
>> 
>>
>>
>>
>> *Program indicators and data elements in GIS:* The GIS app lets you
>> analyse program indicators, attributes and data elements on maps.
>>
>>
>>
>> Demo
>> 
>> | Screenshot 1
>>

Re: [Dhis2-devs] [Dhis2-users] question on individual section

2015-10-08 Thread channara rin

thank you so much for sharing... it is helpful for idea starting it

On Thu, Oct 8, 2015 at 8:06 PM, Pépé Ken Mvulu <pepeken...@gmail.com> wrote:

> Hi Channara,
>
> I wanted to contribute to your first question. If these two programs are
> in the tracker capture, the following procedure:
>
> -  Either Program1 = "child program" and program2 = "Pregnant
> woman"
>
> -  Go Program Attributes,
>
> -  In "Relationship Type" defines the relationship  “A to B” =
> Program1 and “B to A” = program2 in “description” put : Program1-program2
>
> -  Modify the "Program1", in the "* Shortcut link to add a
> relative * "
>
> oDescription of the relationship, choose "Program1-program2"
>
> oShortcut link label (eg Add child), wrote: Add program2
>
> oWho is the new relative to the Existing tracked entity instance:
> select "program2"
>
> oProgram for new relative to be Enrolled in * choose : program2 "
>
> -  Modify the "program2", in the "Shortcut to add a link on"
>
> oDescription of the relationship, choose "Program1-programme2"
>
> oShortcut link label (eg Add child), leave empty
>
> oWho is the new relative to the Existing tracked entity instance:
> select "program2"
>
> oProgram for new relative to be Enrolled in * "choose" Program1 "
>
> In the dashboard of the tracker, when a child finishes his program1
> process, clic on the "Complete" button in "Enrollment" and then you see to
> the right of the dashboard block "Relationships" with the link to Added
> "Add programme2". Do not forget to assign the two programs that OU
>
> I hope this will help you in your reflections
>
> Regards !
>
> Pepe Ken Mvulu
>
> M Officer
>
> Programme Village Assaini
>
> Direction de l’Hygiène
>
> Ministère de la Santé/ RDC
>
>
>
>
>
>
>
> *De :* Dhis2-users [
> mailto:dhis2-users-bounces+pepekento1=gmail@lists.launchpad.net
> <dhis2-users-bounces+pepekento1=gmail@lists.launchpad.net>] *De la
> part de* channara rin
> *Envoyé :* mercredi 7 octobre 2015 11:51
> *À :* DHIS 2 Developers list; DHIS 2 Users list
> *Objet :* [Dhis2-users] question on individual section
>
>
>
> HI DHIS2 family,
>
> i have one question relate to individual trackers.
>
> 1.Example: if we track all information about Children's profile and
> receive health services. and then those children is grow up and get
> married. and then get pregnant. so we have another program relate to
> pregnant women program. so how can we move to new program? or we need to
> create profile again to new program?
>
>
>
> 2.i have one data element is need to know the remaining of trackers that
> didn't come to get ART/Pre-ART service every quaterly. so to do aggregate
> function to that Data Element?
>
>
>
>
>
> thank you
>
> CHANNARA
>
___
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] question on individual section

2015-10-07 Thread channara rin

HI DHIS2 family,
i have one question relate to individual trackers.
1.Example: if we track all information about Children's profile and receive
health services. and then those children is grow up and get married. and
then get pregnant. so we have another program relate to pregnant women
program. so how can we move to new program? or we need to create profile
again to new program?

2.i have one data element is need to know the remaining of trackers that
didn't come to get ART/Pre-ART service every quaterly. so to do aggregate
function to that Data Element?


thank you
CHANNARA
___
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 Trackers (Android App)

2015-10-06 Thread channara rin

YES, NOW IT WORK FINE, after assign specific organisation unit

On Tue, Oct 6, 2015 at 5:53 PM, Simen Skogly Russnes <
simen.s.russ...@gmail.com> wrote:

> Yes it's unfortunate, and it is something we're working one because it
> seems this is confusing for our users.
>
> You have to assign the user (or user group) to each particular
> organisation unit you want to have available in the app, and the same for
> the programs.
>
> On Tue, Oct 6, 2015 at 6:10 AM, Pamod Amarakoon <pam...@gmail.com> wrote:
>
>> Dear Channara,
>>
>> I also had a similar issue on 2.20 and Simen suggested a solution few
>> hours back. I couldn't really check it. But I'm attaching his reply below.
>> May be that might work for the issue you mentioned
>>
>> " You need to have programs and organisation units directly assigned to
>> the user. What that means is that hierarchical child assignments won't be
>> listed in the app. For example if you have a super user and you are
>> assigned to the top level org unit, then child organisation units aren't
>> listed."
>>
>>
>>
>> On Tue, Oct 6, 2015 at 8:34 AM, channara rin <rin.chann...@gmail.com>
>> wrote:
>>
>>> HI DHIS2 family,
>>> I downloaded DHIS2 Trackers Android App to test. i can log-in success,
>>> but i didn't see any things with organisation Units.
>>>
>>> DHIS2 V2.19
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Regards,
>> Pamod Amarakoon
>>
>> Confidentiality Notice: the information contained in this email and any
>> attachments may be legally privileged and confidential. If you are not an
>> intended recipient, you are hereby notified that any dissemination,
>> distribution, or copying of this e-mail is strictly prohibited. If you have
>> received this e-mail in error, please notify the sender and permanently
>> delete the e-mail and any attachments immediately. You should not retain,
>> copy or use this e-mail or any attachments for any purpose, nor disclose
>> all or any part of the contents to any other person.
>>
>> [image: http://ehealthasia.org] <http://ehealthasia.org>
>>
>>
>> ___
>> 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] Indicators in data entry

2015-10-05 Thread channara rin

Hi DHIS2 member,
do you know how to make indicators that aggregate formular from Data
elements can show value in data entry section?

thank you
___
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] error after run analystic

2015-10-05 Thread channara rin

Hi DHIS2 member,
i got the message from DHIS2 system like below. can you help me how to fix
this problem?

=
Resource table process failed, please check the logs. Time:
2015-10-05T00:00:08.388+07:00. Message: PreparedStatementCallback; SQL
[insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR:
duplicate key value violates unique constraint "_dateperiodstructure_pkey"
Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception is
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "_dateperiodstructure_pkey"
Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "_dateperiodstructure_pkey"
Detail: Key (dateperiod)=(1975-01-01) already exists.
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at
org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at
org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)
at
org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)
at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)
at
org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)
at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)
at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)
at
org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)
at
org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)
at sun.reflect.GeneratedMethodAccessor2260.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
at com.sun.proxy.$Proxy104.generateDatePeriodTable(Unknown Source)
at
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
at
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)
at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
at
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at
org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
Source)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
___
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] Indicators in data entry

2015-10-05 Thread channara rin

can you guide me where i can check this option?

On Mon, Oct 5, 2015 at 4:15 PM, Markus Bekken <markus.bek...@gmail.com>
wrote:

> Hi Channara.
> If you make Program Indicators, and check the "Show in form" option, they
> will be shown in a designated place in data entry.
>
> Markus
>
> > 5. okt. 2015 kl. 11.12 skrev channara rin <rin.chann...@gmail.com>:
> >
> > Hi DHIS2 member,
> > do you know how to make indicators that aggregate formular from Data
> elements can show value in data entry section?
> >
> > thank you
> > ___
> > 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] error after run analystic

2015-10-05 Thread channara rin

so you mean, i can delete row from table? which table should i can delete
that row?

On Mon, Oct 5, 2015 at 4:20 PM, Alex Tumwesigye <atumwesi...@gmail.com>
wrote:

> Dear Channara,
>
> Which version are you running? This bug was fixed. It is related to
> timezone I f I remember very well.
> If you check your period table, there are invalid ranges for 1975-01-01.
> Just delete the invalid ranges and you will be fine.
>
>
> Alex
>
> On Mon, Oct 5, 2015 at 12:14 PM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> Hi DHIS2 member,
>> i got the message from DHIS2 system like below. can you help me how to
>> fix this problem?
>>
>> =
>> Resource table process failed, please check the logs. Time:
>> 2015-10-05T00:00:08.388+07:00. Message: PreparedStatementCallback; SQL
>> [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR:
>> duplicate key value violates unique constraint "_dateperiodstructure_pkey"
>> Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception
>> is org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>> unique constraint "_dateperiodstructure_pkey"
>> Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
>> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>> unique constraint "_dateperiodstructure_pkey"
>> Detail: Key (dateperiod)=(1975-01-01) already exists.
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)
>> at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)
>> at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
>> at
>> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)
>> at
>> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)
>> at
>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
>> at
>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)
>> at
>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)
>> at
>> org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)
>> at
>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)
>> at
>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)
>> at
>> org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)
>> at
>> org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)
>> at sun.reflect.GeneratedMethodAccessor2260.invoke(Unknown Source)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>> at java.lang.reflect.Method.invoke(Unknown Source)
>> at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>> at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
>> at com.sun.proxy.$Proxy104.generateDatePeriodTable(Unknown Source)
>> at
>> org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
>> at
>> org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)
>> at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
>> at
>> org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
>> at
>> org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
>> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
>> at java.util.concurrent.FutureTask.run(Unknown Source)
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
>> Source)
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
>> Source)
>> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
>> at java.lang.Thread.

[Dhis2-devs] DHIS2 Trackers (Android App)

2015-10-05 Thread channara rin

HI DHIS2 family,
I downloaded DHIS2 Trackers Android App to test. i can log-in success, but
i didn't see any things with organisation Units.

DHIS2 V2.19
___
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] custom report in dataset

2015-10-05 Thread channara rin

Hi DHIS2 family,
can i write code javascript to get organisation Unit ID like below?

*var orgID = dhis2.de.currentOrganisationUnitId;*

but when i check console in grome browser. it shows like below:
[image: Inline image 1]
___
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 after run analystic

2015-10-05 Thread channara rin

thank you jason
by the way, i run already. but didn't see any record show up

On Mon, Oct 5, 2015 at 4:41 PM, Jason Pickering <jason.p.picker...@gmail.com
> wrote:

> And you may want to be careful about deleting anything as there may be
> data attached to one of those periods. You should of course make a backup
> before you attempt to delete anything, and then find any data which is
> referencing the duplicate period. There are quite a few tables which
> reference "period", so you may need to check these.
>
> However, if you get back a period which does not actually correspond to
> the correct period type (for instance, a year with a period type as a
> week), that is the one you should focus on trying to get rid of.
>
> Regards
> Jason
>
>
>
>
> On Mon, Oct 5, 2015 at 11:36 AM, Knut Staring <knu...@gmail.com> wrote:
>
>> The table is called period.
>>
>> But please first run this query:
>>
>> SELECT * FROM period WHERE startdata, enddate IN
>> (SELECT startdate, endedate FROM period HAVING count(*) >1 GROUP BY
>> startdate, enddate)
>>
>> On Mon, Oct 5, 2015 at 11:33 AM, channara rin <rin.chann...@gmail.com>
>> wrote:
>>
>>> so you mean, i can delete row from table? which table should i can
>>> delete that row?
>>>
>>> On Mon, Oct 5, 2015 at 4:20 PM, Alex Tumwesigye <atumwesi...@gmail.com>
>>> wrote:
>>>
>>>> Dear Channara,
>>>>
>>>> Which version are you running? This bug was fixed. It is related to
>>>> timezone I f I remember very well.
>>>> If you check your period table, there are invalid ranges for 1975-01-01.
>>>> Just delete the invalid ranges and you will be fine.
>>>>
>>>>
>>>> Alex
>>>>
>>>> On Mon, Oct 5, 2015 at 12:14 PM, channara rin <rin.chann...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi DHIS2 member,
>>>>> i got the message from DHIS2 system like below. can you help me how to
>>>>> fix this problem?
>>>>>
>>>>> =
>>>>> Resource table process failed, please check the logs. Time:
>>>>> 2015-10-05T00:00:08.388+07:00. Message: PreparedStatementCallback; SQL
>>>>> [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; 
>>>>> ERROR:
>>>>> duplicate key value violates unique constraint "_dateperiodstructure_pkey"
>>>>> Detail: Key (dateperiod)=(1975-01-01) already exists.; nested
>>>>> exception is org.postgresql.util.PSQLException: ERROR: duplicate key value
>>>>> violates unique constraint "_dateperiodstructure_pkey"
>>>>> Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
>>>>> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>>>>> unique constraint "_dateperiodstructure_pkey"
>>>>> Detail: Key (dateperiod)=(1975-01-01) already exists.
>>>>> at
>>>>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
>>>>> at
>>>>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
>>>>> at
>>>>> org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)
>>>>> at
>>>>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)
>>>>> at
>>>>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)
>>>>> at
>>>>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
>>>>> at
>>>>> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)
>>>>> at
>>>>> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)
>>>>> at
>>>>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
>>>>> at
>>>>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)
>>>>> at
>>>>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)
>>>>> at
>>>>> org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)
>>>&g

Re: [Dhis2-devs] error after run analystic

2015-10-05 Thread channara rin

Hi Jason,
I am using version 2.20 and Time zone: GMT+7:00

On Mon, Oct 5, 2015 at 5:24 PM, Jason Pickering <jason.p.picker...@gmail.com
> wrote:

> What time zone are you on and which version are you using?
>
>
> On Mon, Oct 5, 2015 at 12:02 PM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> thank you jason
>> by the way, i run already. but didn't see any record show up
>>
>> On Mon, Oct 5, 2015 at 4:41 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> And you may want to be careful about deleting anything as there may be
>>> data attached to one of those periods. You should of course make a backup
>>> before you attempt to delete anything, and then find any data which is
>>> referencing the duplicate period. There are quite a few tables which
>>> reference "period", so you may need to check these.
>>>
>>> However, if you get back a period which does not actually correspond to
>>> the correct period type (for instance, a year with a period type as a
>>> week), that is the one you should focus on trying to get rid of.
>>>
>>> Regards
>>> Jason
>>>
>>>
>>>
>>>
>>> On Mon, Oct 5, 2015 at 11:36 AM, Knut Staring <knu...@gmail.com> wrote:
>>>
>>>> The table is called period.
>>>>
>>>> But please first run this query:
>>>>
>>>> SELECT * FROM period WHERE startdata, enddate IN
>>>> (SELECT startdate, endedate FROM period HAVING count(*) >1 GROUP BY
>>>> startdate, enddate)
>>>>
>>>> On Mon, Oct 5, 2015 at 11:33 AM, channara rin <rin.chann...@gmail.com>
>>>> wrote:
>>>>
>>>>> so you mean, i can delete row from table? which table should i can
>>>>> delete that row?
>>>>>
>>>>> On Mon, Oct 5, 2015 at 4:20 PM, Alex Tumwesigye <atumwesi...@gmail.com
>>>>> > wrote:
>>>>>
>>>>>> Dear Channara,
>>>>>>
>>>>>> Which version are you running? This bug was fixed. It is related to
>>>>>> timezone I f I remember very well.
>>>>>> If you check your period table, there are invalid ranges for 1975-01-01.
>>>>>> Just delete the invalid ranges and you will be fine.
>>>>>>
>>>>>>
>>>>>> Alex
>>>>>>
>>>>>> On Mon, Oct 5, 2015 at 12:14 PM, channara rin <rin.chann...@gmail.com
>>>>>> > wrote:
>>>>>>
>>>>>>> Hi DHIS2 member,
>>>>>>> i got the message from DHIS2 system like below. can you help me how
>>>>>>> to fix this problem?
>>>>>>>
>>>>>>> =
>>>>>>> Resource table process failed, please check the logs. Time:
>>>>>>> 2015-10-05T00:00:08.388+07:00. Message: PreparedStatementCallback; SQL
>>>>>>> [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; 
>>>>>>> ERROR:
>>>>>>> duplicate key value violates unique constraint 
>>>>>>> "_dateperiodstructure_pkey"
>>>>>>> Detail: Key (dateperiod)=(1975-01-01) already exists.; nested
>>>>>>> exception is org.postgresql.util.PSQLException: ERROR: duplicate key 
>>>>>>> value
>>>>>>> violates unique constraint "_dateperiodstructure_pkey"
>>>>>>> Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
>>>>>>> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>>>>>>> unique constraint "_dateperiodstructure_pkey"
>>>>>>> Detail: Key (dateperiod)=(1975-01-01) already exists.
>>>>>>> at
>>>>>>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
>>>>>>> at
>>>>>>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
>>>>>>> at
>>>>>>> org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)
>>>>>>> at
>>>>>>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)
>>>>>>> at
>>>>>>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute

Re: [Dhis2-devs] error after run analystic

2015-10-05 Thread channara rin

[image: Inline image 1]

RUN
[image: Inline image 2]


On Mon, Oct 5, 2015 at 6:36 PM, channara rin <rin.chann...@gmail.com> wrote:

> No record found...
>
> On Mon, Oct 5, 2015 at 6:21 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> What about
>>
>> SELECT * FROM period where startdate = '1975-01-01'::date
>>
>>
>>
>> On Mon, Oct 5, 2015 at 12:30 PM, channara rin <rin.chann...@gmail.com>
>> wrote:
>>
>>> Hi Jason,
>>> I am using version 2.20 and Time zone: GMT+7:00
>>>
>>> On Mon, Oct 5, 2015 at 5:24 PM, Jason Pickering <
>>> jason.p.picker...@gmail.com> wrote:
>>>
>>>> What time zone are you on and which version are you using?
>>>>
>>>>
>>>> On Mon, Oct 5, 2015 at 12:02 PM, channara rin <rin.chann...@gmail.com>
>>>> wrote:
>>>>
>>>>> thank you jason
>>>>> by the way, i run already. but didn't see any record show up
>>>>>
>>>>> On Mon, Oct 5, 2015 at 4:41 PM, Jason Pickering <
>>>>> jason.p.picker...@gmail.com> wrote:
>>>>>
>>>>>> And you may want to be careful about deleting anything as there may
>>>>>> be data attached to one of those periods. You should of course make a
>>>>>> backup before you attempt to delete anything, and then find any data 
>>>>>> which
>>>>>> is referencing the duplicate period. There are quite a few tables which
>>>>>> reference "period", so you may need to check these.
>>>>>>
>>>>>> However, if you get back a period which does not actually correspond
>>>>>> to the correct period type (for instance, a year with a period type as a
>>>>>> week), that is the one you should focus on trying to get rid of.
>>>>>>
>>>>>> Regards
>>>>>> Jason
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Mon, Oct 5, 2015 at 11:36 AM, Knut Staring <knu...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> The table is called period.
>>>>>>>
>>>>>>> But please first run this query:
>>>>>>>
>>>>>>> SELECT * FROM period WHERE startdata, enddate IN
>>>>>>> (SELECT startdate, endedate FROM period HAVING count(*) >1 GROUP BY
>>>>>>> startdate, enddate)
>>>>>>>
>>>>>>> On Mon, Oct 5, 2015 at 11:33 AM, channara rin <
>>>>>>> rin.chann...@gmail.com> wrote:
>>>>>>>
>>>>>>>> so you mean, i can delete row from table? which table should i can
>>>>>>>> delete that row?
>>>>>>>>
>>>>>>>> On Mon, Oct 5, 2015 at 4:20 PM, Alex Tumwesigye <
>>>>>>>> atumwesi...@gmail.com> wrote:
>>>>>>>>
>>>>>>>>> Dear Channara,
>>>>>>>>>
>>>>>>>>> Which version are you running? This bug was fixed. It is related
>>>>>>>>> to timezone I f I remember very well.
>>>>>>>>> If you check your period table, there are invalid ranges for 
>>>>>>>>> 1975-01-01.
>>>>>>>>> Just delete the invalid ranges and you will be fine.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Alex
>>>>>>>>>
>>>>>>>>> On Mon, Oct 5, 2015 at 12:14 PM, channara rin <
>>>>>>>>> rin.chann...@gmail.com> wrote:
>>>>>>>>>
>>>>>>>>>> Hi DHIS2 member,
>>>>>>>>>> i got the message from DHIS2 system like below. can you help me
>>>>>>>>>> how to fix this problem?
>>>>>>>>>>
>>>>>>>>>> =
>>>>>>>>>> Resource table process failed, please check the logs. Time:
>>>>>>>>>> 2015-10-05T00:00:08.388+07:00. Message: PreparedStatementCallback; 
>>>>>>>>>> SQL
>>>>>>>>>> [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; 
&g

Re: [Dhis2-devs] error after run analystic

2015-10-05 Thread channara rin

No record found...

On Mon, Oct 5, 2015 at 6:21 PM, Jason Pickering <jason.p.picker...@gmail.com
> wrote:

> What about
>
> SELECT * FROM period where startdate = '1975-01-01'::date
>
>
>
> On Mon, Oct 5, 2015 at 12:30 PM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> Hi Jason,
>> I am using version 2.20 and Time zone: GMT+7:00
>>
>> On Mon, Oct 5, 2015 at 5:24 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> What time zone are you on and which version are you using?
>>>
>>>
>>> On Mon, Oct 5, 2015 at 12:02 PM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> thank you jason
>>>> by the way, i run already. but didn't see any record show up
>>>>
>>>> On Mon, Oct 5, 2015 at 4:41 PM, Jason Pickering <
>>>> jason.p.picker...@gmail.com> wrote:
>>>>
>>>>> And you may want to be careful about deleting anything as there may be
>>>>> data attached to one of those periods. You should of course make a backup
>>>>> before you attempt to delete anything, and then find any data which is
>>>>> referencing the duplicate period. There are quite a few tables which
>>>>> reference "period", so you may need to check these.
>>>>>
>>>>> However, if you get back a period which does not actually correspond
>>>>> to the correct period type (for instance, a year with a period type as a
>>>>> week), that is the one you should focus on trying to get rid of.
>>>>>
>>>>> Regards
>>>>> Jason
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Mon, Oct 5, 2015 at 11:36 AM, Knut Staring <knu...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> The table is called period.
>>>>>>
>>>>>> But please first run this query:
>>>>>>
>>>>>> SELECT * FROM period WHERE startdata, enddate IN
>>>>>> (SELECT startdate, endedate FROM period HAVING count(*) >1 GROUP BY
>>>>>> startdate, enddate)
>>>>>>
>>>>>> On Mon, Oct 5, 2015 at 11:33 AM, channara rin <rin.chann...@gmail.com
>>>>>> > wrote:
>>>>>>
>>>>>>> so you mean, i can delete row from table? which table should i can
>>>>>>> delete that row?
>>>>>>>
>>>>>>> On Mon, Oct 5, 2015 at 4:20 PM, Alex Tumwesigye <
>>>>>>> atumwesi...@gmail.com> wrote:
>>>>>>>
>>>>>>>> Dear Channara,
>>>>>>>>
>>>>>>>> Which version are you running? This bug was fixed. It is related to
>>>>>>>> timezone I f I remember very well.
>>>>>>>> If you check your period table, there are invalid ranges for 
>>>>>>>> 1975-01-01.
>>>>>>>> Just delete the invalid ranges and you will be fine.
>>>>>>>>
>>>>>>>>
>>>>>>>> Alex
>>>>>>>>
>>>>>>>> On Mon, Oct 5, 2015 at 12:14 PM, channara rin <
>>>>>>>> rin.chann...@gmail.com> wrote:
>>>>>>>>
>>>>>>>>> Hi DHIS2 member,
>>>>>>>>> i got the message from DHIS2 system like below. can you help me
>>>>>>>>> how to fix this problem?
>>>>>>>>>
>>>>>>>>> =
>>>>>>>>> Resource table process failed, please check the logs. Time:
>>>>>>>>> 2015-10-05T00:00:08.388+07:00. Message: PreparedStatementCallback; SQL
>>>>>>>>> [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; 
>>>>>>>>> ERROR:
>>>>>>>>> duplicate key value violates unique constraint 
>>>>>>>>> "_dateperiodstructure_pkey"
>>>>>>>>> Detail: Key (dateperiod)=(1975-01-01) already exists.; nested
>>>>>>>>> exception is org.postgresql.util.PSQLException: ERROR: duplicate key 
>>>>>>>>> value
>>>>>>>>> violates unique constraint "_dateperiodstructure_pkey"
>>>>>>

[Dhis2-devs] individual record list error and tracker capture error

2015-09-08 Thread channara rin

Hi all DHIS2,
my tracker list has more then 50 records, but individual records and
tracker capture didn't show number list page, and can't press next link too.

[image: Inline image 1]

thank you
channara
___
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 using curl command

2015-09-07 Thread channara rin

hi morten,
if i coding with PHP use CURL command. i still get the following error. and
my json in attached file.
By the way, i use apache v8 and DHIS2 v2.20
[image: Inline image 1]


On Fri, Sep 4, 2015 at 3:58 PM, channara rin <rin.chann...@gmail.com> wrote:

> If i tried use test with -u ... that is work fine. but if i add more
> function like -X POST -d -v it doesn't work
>
> On Fri, Sep 4, 2015 at 3:55 PM, Bob Jolliffe <bobjolli...@gmail.com>
> wrote:
>
>> Hi Channara
>>
>> I just had a look at your original mail and I see that the user admin was
>> recognized so it means the curl option was ok but some issue with the
>> password.  My guess is that you have some strange characters in the
>> password which are being expanded/interpreted by the shell.
>>
>> Try quoting like:
>> -u "admin:x"
>> or
>> -u 'admin:x'
>>
>>
>> On 4 September 2015 at 09:46, channara rin <rin.chann...@gmail.com>
>> wrote:
>>
>>> Hi Morten,
>>> Hi tried test with user:password first. but still error.
>>>
>>> On Thu, Sep 3, 2015 at 11:43 PM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> yes, it work too.
>>>>
>>>>
>>>> On Thu, Sep 3, 2015 at 6:45 PM, Morten Olav Hansen <morte...@gmail.com>
>>>> wrote:
>>>>
>>>>> Try to test with something simpler
>>>>>
>>>>> curl -u user:pass http://server/api/dataElements
>>>>>
>>>>> And see if it works
>>>>>
>>>>> --
>>>>> Morten
>>>>>
>>>>> On Thu, Sep 3, 2015 at 5:23 PM, Knut Staring <knu...@gmail.com> wrote:
>>>>>
>>>>>> Channara, are you using GOW?
>>>>>>
>>>>>> https://github.com/bmatzelle/gow
>>>>>>
>>>>>> On Thu, Sep 3, 2015 at 12:08 PM, Morten Olav Hansen <
>>>>>> morte...@gmail.com> wrote:
>>>>>>
>>>>>>> I have also seen weird issues on window versions of cURL where -u
>>>>>>> user:pass is required to be FIRST (mac/linux should be fine)
>>>>>>>
>>>>>>> --
>>>>>>> Morten
>>>>>>>
>>>>>>> On Thu, Sep 3, 2015 at 5:07 PM, Bob Jolliffe <bobjolli...@gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hi Channara
>>>>>>>>
>>>>>>>> The man page for curl indicates that the format of the command is:
>>>>>>>>
>>>>>>>> curl  
>>>>>>>>
>>>>>>>> Try moving your url to the end of the line, after the options.
>>>>>>>> Also you might want to add "http://localhost...;
>>>>>>>>
>>>>>>>> On 3 September 2015 at 11:01, channara rin <rin.chann...@gmail.com>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Hi DHIS2 friends,
>>>>>>>>> i tried use curl command to import tracker, but i got error.
>>>>>>>>> can you help me what is problem?
>>>>>>>>> ***THIS IS COMMAND RUNNING:
>>>>>>>>> [image: Inline image 1]
>>>>>>>>>
>>>>>>>>> ***THIS IS CONSOLE in APACHE
>>>>>>>>> [image: Inline image 2]
>>>>>>>>>
>>>>>>>>> ___
>>>>>>>>> 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
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Knut Staring
>>>>>> Dept. of Informatics, University of Oslo
>>>>>> Norway: +4791880522
>>>>>> Skype: knutstar
>>>>>> http://dhis2.org
>>>>>>
>>>>>
>>>>>
>>>>> ___
>>>>> 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
>>>
>>>
>>
>


1.json
Description: application/json
___
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 using curl command

2015-09-04 Thread channara rin

If i tried use test with -u ... that is work fine. but if i add more
function like -X POST -d -v it doesn't work

On Fri, Sep 4, 2015 at 3:55 PM, Bob Jolliffe <bobjolli...@gmail.com> wrote:

> Hi Channara
>
> I just had a look at your original mail and I see that the user admin was
> recognized so it means the curl option was ok but some issue with the
> password.  My guess is that you have some strange characters in the
> password which are being expanded/interpreted by the shell.
>
> Try quoting like:
> -u "admin:x"
> or
> -u 'admin:xxxxx'
>
>
> On 4 September 2015 at 09:46, channara rin <rin.chann...@gmail.com> wrote:
>
>> Hi Morten,
>> Hi tried test with user:password first. but still error.
>>
>> On Thu, Sep 3, 2015 at 11:43 PM, channara rin <rin.chann...@gmail.com>
>> wrote:
>>
>>> yes, it work too.
>>>
>>>
>>> On Thu, Sep 3, 2015 at 6:45 PM, Morten Olav Hansen <morte...@gmail.com>
>>> wrote:
>>>
>>>> Try to test with something simpler
>>>>
>>>> curl -u user:pass http://server/api/dataElements
>>>>
>>>> And see if it works
>>>>
>>>> --
>>>> Morten
>>>>
>>>> On Thu, Sep 3, 2015 at 5:23 PM, Knut Staring <knu...@gmail.com> wrote:
>>>>
>>>>> Channara, are you using GOW?
>>>>>
>>>>> https://github.com/bmatzelle/gow
>>>>>
>>>>> On Thu, Sep 3, 2015 at 12:08 PM, Morten Olav Hansen <
>>>>> morte...@gmail.com> wrote:
>>>>>
>>>>>> I have also seen weird issues on window versions of cURL where -u
>>>>>> user:pass is required to be FIRST (mac/linux should be fine)
>>>>>>
>>>>>> --
>>>>>> Morten
>>>>>>
>>>>>> On Thu, Sep 3, 2015 at 5:07 PM, Bob Jolliffe <bobjolli...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi Channara
>>>>>>>
>>>>>>> The man page for curl indicates that the format of the command is:
>>>>>>>
>>>>>>> curl  
>>>>>>>
>>>>>>> Try moving your url to the end of the line, after the options.  Also
>>>>>>> you might want to add "http://localhost...;
>>>>>>>
>>>>>>> On 3 September 2015 at 11:01, channara rin <rin.chann...@gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hi DHIS2 friends,
>>>>>>>> i tried use curl command to import tracker, but i got error.
>>>>>>>> can you help me what is problem?
>>>>>>>> ***THIS IS COMMAND RUNNING:
>>>>>>>> [image: Inline image 1]
>>>>>>>>
>>>>>>>> ***THIS IS CONSOLE in APACHE
>>>>>>>> [image: Inline image 2]
>>>>>>>>
>>>>>>>> ___
>>>>>>>> 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
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Knut Staring
>>>>> Dept. of Informatics, University of Oslo
>>>>> Norway: +4791880522
>>>>> Skype: knutstar
>>>>> http://dhis2.org
>>>>>
>>>>
>>>>
>>>> ___
>>>> 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] error using curl command

2015-09-03 Thread channara rin

yes, it work too.


On Thu, Sep 3, 2015 at 6:45 PM, Morten Olav Hansen <morte...@gmail.com>
wrote:

> Try to test with something simpler
>
> curl -u user:pass http://server/api/dataElements
>
> And see if it works
>
> --
> Morten
>
> On Thu, Sep 3, 2015 at 5:23 PM, Knut Staring <knu...@gmail.com> wrote:
>
>> Channara, are you using GOW?
>>
>> https://github.com/bmatzelle/gow
>>
>> On Thu, Sep 3, 2015 at 12:08 PM, Morten Olav Hansen <morte...@gmail.com>
>> wrote:
>>
>>> I have also seen weird issues on window versions of cURL where -u
>>> user:pass is required to be FIRST (mac/linux should be fine)
>>>
>>> --
>>> Morten
>>>
>>> On Thu, Sep 3, 2015 at 5:07 PM, Bob Jolliffe <bobjolli...@gmail.com>
>>> wrote:
>>>
>>>> Hi Channara
>>>>
>>>> The man page for curl indicates that the format of the command is:
>>>>
>>>> curl  
>>>>
>>>> Try moving your url to the end of the line, after the options.  Also
>>>> you might want to add "http://localhost...;
>>>>
>>>> On 3 September 2015 at 11:01, channara rin <rin.chann...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi DHIS2 friends,
>>>>> i tried use curl command to import tracker, but i got error.
>>>>> can you help me what is problem?
>>>>> ***THIS IS COMMAND RUNNING:
>>>>> [image: Inline image 1]
>>>>>
>>>>> ***THIS IS CONSOLE in APACHE
>>>>> [image: Inline image 2]
>>>>>
>>>>> ___
>>>>> 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
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>>
>
>
> ___
> 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] error using curl command

2015-09-03 Thread channara rin

Hi DHIS2 friends,
i tried use curl command to import tracker, but i got error.
can you help me what is problem?
***THIS IS COMMAND RUNNING:
[image: Inline image 1]

***THIS IS CONSOLE in APACHE
[image: Inline image 2]
___
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 using curl command

2015-09-03 Thread channara rin

not working

On Thu, Sep 3, 2015 at 5:08 PM, Morten Olav Hansen <morte...@gmail.com>
wrote:

> I have also seen weird issues on window versions of cURL where -u
> user:pass is required to be FIRST (mac/linux should be fine)
>
> --
> Morten
>
> On Thu, Sep 3, 2015 at 5:07 PM, Bob Jolliffe <bobjolli...@gmail.com>
> wrote:
>
>> Hi Channara
>>
>> The man page for curl indicates that the format of the command is:
>>
>> curl  
>>
>> Try moving your url to the end of the line, after the options.  Also you
>> might want to add "http://localhost...;
>>
>> On 3 September 2015 at 11:01, channara rin <rin.chann...@gmail.com>
>> wrote:
>>
>>> Hi DHIS2 friends,
>>> i tried use curl command to import tracker, but i got error.
>>> can you help me what is problem?
>>> ***THIS IS COMMAND RUNNING:
>>> [image: Inline image 1]
>>>
>>> ***THIS IS CONSOLE in APACHE
>>> [image: Inline image 2]
>>>
>>> ___
>>> 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

[Dhis2-devs] Problem log-in

2015-09-01 Thread channara rin

Hi all dhis2,
Can you help me what is problem login page, i can't log in with admin
account. What should i do?
[image: Inline image 1]
___
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] Convert Excel to xml and to json

2015-09-01 Thread channara rin

Hi all DHIS2,
Do you know how to convert Excel tracker list to xml and to json that
enable import into DHIS2 system?

[image: Inline image 1]

thank you
CHANNARA
___
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] Problem log-in

2015-09-01 Thread channara rin

Yes, now it work fine

thank Lars, Morten

On Tue, Sep 1, 2015 at 3:23 PM, Lars Helge Øverland <larshe...@gmail.com>
wrote:

> Hi Channara,
>
> do this to set password to district for user admin:
>
> update users set
> password='$2a$10$wjLPViry3bkYEcjwGRqnYO1bT2Kl.ZY0kO.fwFDfMX53hitfx5.3C'
> where username='admin';
>
> Then restart tomcat to make sure the application cache is cleared.
>
> Then log in with admin/district.
>
> regards,
>
> Lars
>
>
>
> On Tue, Sep 1, 2015 at 10:17 AM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> No! i don't have any account more.
>>
>> On Tue, Sep 1, 2015 at 3:13 PM, channara rin <rin.chann...@gmail.com>
>> wrote:
>>
>>> But it still display log-in page.
>>>
>>> On Tue, Sep 1, 2015 at 3:13 PM, channara rin <rin.chann...@gmail.com>
>>> wrote:
>>>
>>>> Hi Morten,
>>>> I go to database schema and change value of attribute: "Password" to
>>>> value:"*$2a$10$iig96L.lNFPYgt9Go0bJGuJ2A5Sdqid17wV/xwEHlq.cCDYXdGFG2*
>>>> "="district"
>>>>
>>>>
>>>> On Tue, Sep 1, 2015 at 2:55 PM, Morten Olav Hansen <morte...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi
>>>>>
>>>>> That error message just means wrong password.. bad credentials
>>>>>
>>>>> --
>>>>> Morten
>>>>>
>>>>> On Tue, Sep 1, 2015 at 2:51 PM, channara rin <rin.chann...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Hi all dhis2,
>>>>>> Can you help me what is problem login page, i can't log in with admin
>>>>>> account. What should i do?
>>>>>> [image: Inline image 1]
>>>>>>
>>>>>>
>>>>>> ___
>>>>>> 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
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org <https://www.dhis2.org>
>
>
___
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] Problem log-in

2015-09-01 Thread channara rin

But it still display log-in page.

On Tue, Sep 1, 2015 at 3:13 PM, channara rin <rin.chann...@gmail.com> wrote:

> Hi Morten,
> I go to database schema and change value of attribute: "Password" to
> value:"*$2a$10$iig96L.lNFPYgt9Go0bJGuJ2A5Sdqid17wV/xwEHlq.cCDYXdGFG2*
> "="district"
>
>
> On Tue, Sep 1, 2015 at 2:55 PM, Morten Olav Hansen <morte...@gmail.com>
> wrote:
>
>> Hi
>>
>> That error message just means wrong password.. bad credentials
>>
>> --
>> Morten
>>
>> On Tue, Sep 1, 2015 at 2:51 PM, channara rin <rin.chann...@gmail.com>
>> wrote:
>>
>>> Hi all dhis2,
>>> Can you help me what is problem login page, i can't log in with admin
>>> account. What should i do?
>>> [image: Inline image 1]
>>>
>>>
>>> ___
>>> 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] Problem log-in

2015-09-01 Thread channara rin

Hi Morten,
I go to database schema and change value of attribute: "Password" to value:"
*$2a$10$iig96L.lNFPYgt9Go0bJGuJ2A5Sdqid17wV/xwEHlq.cCDYXdGFG2*"="district"


On Tue, Sep 1, 2015 at 2:55 PM, Morten Olav Hansen <morte...@gmail.com>
wrote:

> Hi
>
> That error message just means wrong password.. bad credentials
>
> --
> Morten
>
> On Tue, Sep 1, 2015 at 2:51 PM, channara rin <rin.chann...@gmail.com>
> wrote:
>
>> Hi all dhis2,
>> Can you help me what is problem login page, i can't log in with admin
>> account. What should i do?
>> [image: Inline image 1]
>>
>>
>> ___
>> 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] How import Tracker information into DHIS2 System

2015-08-19 Thread channara rin

Hi all DHIS2,
can i use import/export for importing tracker's information like ID, name,
sex, date of birth,...?
how to do that?

thank you
CHANNARA
___
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 import Tracker information into DHIS2 System

2015-08-19 Thread channara rin

Note thanks

On Wed, Aug 19, 2015 at 4:02 PM, Jason Pickering 
jason.p.picker...@gmail.com wrote:

 Hi there.

 Did you have a look at the documentation?
 https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s13.html

 Regards,
 Jason


 On Wed, Aug 19, 2015 at 10:58 AM, channara rin rin.chann...@gmail.com
 wrote:

 Hi all DHIS2,
 can i use import/export for importing tracker's information like ID,
 name, sex, date of birth,...?
 how to do that?

 thank you
 CHANNARA

 ___
 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:+46764147049

___
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-users] make entry faster

2015-08-19 Thread channara rin

so if i create MM and YY. so it is effect of calculate of Aggregation query
builder?

On Wed, Aug 19, 2015 at 4:24 PM, Prosper BT ptb3...@gmail.com wrote:

 Hi Channara,

 Different formats of dates are not yet all supported in DHIS2, in the
 meantime you may have to use two different data elements or attributes to
 enter MM alone and YY alone and manipulate later in analysis.

 Or better still you can allow entrants to enter the same day like 01 for
 all the records (2015/08/01) 1st for all the records in August.

 Regards


 On Thu, Aug 6, 2015 at 5:13 AM, channara rin rin.chann...@gmail.com
 wrote:

 Hi DHIS2 developer, users,
 Currently i am using DHIS2 with Tracker Capture Function(Individual with
 registration).
 But the problem, every create event, i need to put reporting
 date:dd-mm- and due date:dd-mm-. So do you have any idea, to
 create event only put reportind date:month-year only?

 thank you


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




 --
 Prosper Behumbiize, MPH
 Global HISP| University Of Oslo/HISP Uganda
 +256 752 751 776 | +256 776 139 139
 ptb3...@gmail.com | pros...@dhis2.org | Skype: prospertb


___
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] make entry faster

2015-08-05 Thread channara rin

Hi DHIS2 developer, users,
Currently i am using DHIS2 with Tracker Capture Function(Individual with
registration).
But the problem, every create event, i need to put reporting
date:dd-mm- and due date:dd-mm-. So do you have any idea, to
create event only put reportind date:month-year only?

thank you
___
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-users] Aggregate Query Builder

2015-08-04 Thread channara rin

Hi Prosper,
I am using
Version:2.19Build revision:19251Build date:2015-07-01 02:04

On Tue, Aug 4, 2015 at 11:17 AM, Prosper BT ptb3...@gmail.com wrote:

 Dear Channara,

 Which version of dhis2 are you using? 2.20 has tracker data analysis
 integrated into the usual analytics (pivot tables and visualiser) and you
 can choose any period you want.

 Even in Events reports, once you have selected the data elements or
 attributes, you can choose a yearly period for aggregation and line listing.

 Regards

 On Fri, Jul 31, 2015 at 6:28 AM, channara rin rin.chann...@gmail.com
 wrote:

 Hi all DHIS2,
 Can we aggregate trackers' attributes/data elements in a whole year?

 thank you
 channara

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




 --
 Prosper Behumbiize, MPH
 Global HISP| University Of Oslo/HISP Uganda
 +256 752 751 776 | +256 776 139 139
 ptb3...@gmail.com | pros...@dhis2.org | Skype: prospertb


___
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] Aggregate Query Builder

2015-07-30 Thread channara rin

Hi all DHIS2,
Can we aggregate trackers' attributes/data elements in a whole year?

thank you
channara
___
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] aggregation builder

2015-07-15 Thread channara rin

Hi all,
My problem are What should to do? if want to build aggregation builder with
If-Condition? and another one is DateDiff in aggregation Builder seem not
working.

Thank you
CHANANRA
___
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

1 2 >

1 - 100 of 185 matches

Mail list logo