dhis2-devs team mailing list archive

[James Chang <jamesbchang@xxxxxxxxx>]

Thanks, Lars.

Just to clarify the Apps' rows and parameters:

Since this is Events(Single Event Without Registration) data entry
(spreadsheet style) table, the user will select an program (event) from
program list.
Just like '1. Selection.jgp' (attached image) - Single Event Without
Registration program selection in DHIS.

 Upon selection, data entry table's column number will be decided and
cell's data entry render type (textbox, dropdown, etc) will be decided.
Just like '2. Data Entry.jgp' in single row format.

'Mock.jgp' shows the Apps layout.

Have a good day~



On Fri, Aug 9, 2013 at 8:00 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:

> Hi James
>
> Thanks for the update.
>
> Yes I think that creating an SQL view for pulling out event that is a nice
> solution while waiting for the improved API. Note that you can query your
> SQL view from the URL like documented here:
>
> http://www.dhis2.org/doc/snapshot/en/user/html/ch25s18.html
>
> It is a little unclear to me what will appear on the rows in your app -
> ie. what parameters you select before arriving at the tabular grid.
>
> cheers
>
> Lars
>
>
> On Fri, Aug 9, 2013 at 6:22 AM, James Chang <jamesbchang@xxxxxxxxx> wrote:
>
>> Hi, Lars.
>>
>> Thank you for the info.
>>
>> And, Yes, we do need to query the events data in our DHIS Apps
>> requirement.
>>
>>
>> Below are our DHIS Apps requirements:
>>
>> - Build data entry grid (in excel sheet like) for 'Single Event Wtihout
>> Registration'.
>>
>> - List events ('Single Event Without Registration') on dropdown list for
>> selection.
>>
>> - Upon event dropdown selection, generate event data entry table in excel
>> speadsheet fashion.
>>
>> - On table generation:
>>     --> The columns will be populated with data elements belonging to the
>> event.
>>     --> The rows will be populated for the existing event data.
>>     --> The cells will be rendering Textbox, or Dropdown, or etc.
>> depending on the data element value type.
>>
>>  - New event data entry row will exist in the bottom row.  If that row is
>> filled, the data will be saved as event data in DHIS and the new row will
>> appear at the bottom for new entry.
>>
>>
>> I have tested the /api/events/--UID--.json and it is giving the data.
>> So, what I can do for now is
>> - Create sqlView to retrieve all the programStageInstance UID and add
>> filter parameter to retrieve the data for the programStage we want
>> - convert the .csv data into json, for easier access
>> - for each programStageInstance UID, call /api/events to retrieve data.
>>
>>
>>
>>
>>
>> On Thu, Aug 8, 2013 at 7:06 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:
>>
>>> Hi James,
>>>
>>> we have some limited support for retrieving events in trunk (latest
>>> development version). You can fetch events through their UIDs. Sorry but we
>>> don't have any querying capabilities yet, although we are planning to
>>> implement that too.
>>>
>>> In trunk, when you create an event, you will now get both a "reference"
>>> element and a "href" element which tell you the generated UID for the
>>> events you just created. See example at the end.
>>>
>>> You can then use this UID to retrieve the event with a GET request
>>>
>>> api/events/<uid>.json
>>>
>>> Documentation here:
>>> http://www.dhis2.org/doc/snapshot/en/user/html/ch25s07.html
>>>
>>> If you need to query the events please share with us your requirements
>>> so we can take it into account when designing the feature.
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>>
>>>
>>> ----
>>>
>>> <importSummaries
>>> xmlns="http://dhis2.org/schema/dxf/2.0";>
>>>     <importSummaryList>
>>>         <importSummary>
>>>             <status>SUCCESS</status>
>>>             <dataValueCount imported="2" updated="0" ignored="0" />
>>>             <reference>eLvaci7Lb9j</reference>
>>>             <href>http://apps.dhis2.org/dev/api/events/eLvaci7Lb9j
>>> </href>
>>>         </importSummary>
>>>         <importSummary>
>>>             <status>SUCCESS</status>
>>>             <dataValueCount imported="2" updated="0" ignored="0" />
>>>             <reference>JCZ4WBXMddc</reference>
>>>             <href>http://apps.dhis2.org/dev/api/events/JCZ4WBXMddc
>>> </href>
>>>         </importSummary>
>>>     </importSummaryList>
>>>     </importSummaries>
>>>
>>>
>>> On Thu, Aug 8, 2013 at 11:14 AM, James Chang <jamesbchang@xxxxxxxxx>wrote:
>>>
>>>> Hi.
>>>>
>>>> Now that DHIS 2.12 has Web API that we can insert(submit) 'Single Event
>>>> Without Registration' data, I am trying to build DHIS Apps for it.
>>>>
>>>> I am planning on creating a dynamic HTML table using jQuery for a
>>>> selected ProgramStage (Single Event Without Registration).  The columns
>>>> (data elements) will be populated depending on the ProgramStage selection.
>>>>
>>>> I found out that I can get the columns (Data Elements) by calling Web
>>>> API.
>>>>
>>>> http://localhost:8080/api/programStages/CBbrPwnG1gG.json?viewClass=detailed?link=false
>>>>
>>>>
>>>> However, do we have something in API or in Analytics that we can get
>>>> the entered data in DHIS?  Preferably in JSON?
>>>> This will be ProgramStageInstance data for 'Single Event Without
>>>> Registration'.
>>>>
>>>> Thanks.
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>
>

Attachment: 1. Selection.jpg
Description: JPEG image

Attachment: 2. Data Entry.jpg
Description: JPEG image

Attachment: Mock.jpg
Description: JPEG image