Okay thanks James, looks good. Lars
On Fri, Aug 9, 2013 at 5:14 PM, James Chang <jamesbch...@gmail.com> wrote: > 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 > <larshe...@gmail.com>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 <jamesbch...@gmail.com>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 <larshe...@gmail.com >>> > 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 <jamesbch...@gmail.com>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@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
