Hi Kalpa, Sorry I didn't totally analyze the tree structure idea earlier. First, what we actually need is just a list of database tables, and I guess it's better to divide a panel left and right, where the left will have the list of tables, and when you click on a table, the columns will be listed in the right, and basically columns won't be selectable. So we won't need a tree structure for that. And thinking about the custom query option, here we are defining queries for the whole operation, so there are multiple queries, and this is basically a wizard to automatically create the data service, similar to the "Generate" functionality we have in the web console. So as I see, we should not give the option to create custom queries, because it will get very complicated and we would need to support all the features in the query page in our web based wizard. As I remember, you guys are going to create a separate wizard to resemble the web based wizard we have now for data services, for manually creating data services. So my feeling is lets just stick with the rapid (automatic) creation of data services in this wizard.
Please come and meet me tomorrow, so we can discuss about this more. Cheers, Anjana. On Wed, Dec 7, 2011 at 11:24 PM, Kalpa Senanayake <[email protected]> wrote: > Hi, > > We will remove the query text box if user select CRUD operation creation > and make other suggested UI changes. > > Few questions. > Since it is better to have a Tree based (Expandable) approach to deal > with large amount of tables. > > 1. Do we have to have column level selection in the table tree for > the multiple tables? > because if we creating CRUD operations for the selected tables > there is no meaning of selecting columns. > > 2. I think it is better if user select CRUD operation creation, we > enable the multiple selection in the table tree ,if it is > custom query based operation creation then disable the multiple > selection but insted of that we can show the coulmuns > in the selected table (single table) which helps user to > compose the query.WDYT ? > > Thanks all for suggestions and feedback. > > Thanks > Kalpa. > > > > On Wed, Dec 7, 2011 at 9:12 PM, Anjana Fernando <[email protected]> wrote: > >> On Wed, Dec 7, 2011 at 9:06 PM, Chathuri Wimalasena <[email protected]>wrote: >> >>> Ok.. So we will remove the Query text box if a user selects "CRUD >>> Operations" option. Thanks for the feedback.. >>> >> >> Great. >> >> >>> >>> Good work Kalpa. >>> >> >> +1 >> >> Cheers, >> Anjana. >> >> >>> >>> Regards, >>> Chathuri >>> >>> >>> On Wed, Dec 7, 2011 at 8:55 PM, Anjana Fernando <[email protected]> wrote: >>> >>>> Hi Chathuri, >>>> >>>> Yeah, I understood that it is for the custom query section. I was just >>>> thinking it is not needed for the automatic CRUD operation creation mode, I >>>> guess as you explained it now, you are expecting to display the created >>>> queries for the CRUD operations, which is I guess is not required, since >>>> it's an automatically created set of queries and the user most probably >>>> don't want to see those. >>>> >>>> Cheers, >>>> Anjana. >>>> >>>> >>>> On Wed, Dec 7, 2011 at 8:48 PM, Chathuri Wimalasena >>>> <[email protected]>wrote: >>>> >>>>> Hi Anjana, >>>>> >>>>> The reason we add SQL Query is to give user a way to add custom >>>>> queries. If a user selects, CRUD operations, we will generate the >>>>> necessary >>>>> SQL query and if a user selects "Custom Query Operation" he can write his >>>>> own custom query. I think Kalpa is still working on generating and display >>>>> SQL query for the CRUD operations. >>>>> >>>>> +1 for Harshana's suggestion. Another option would be, having a >>>>> multi-tab page for tables, queries with an expandable control as Harshana >>>>> suggested. >>>>> >>>>> Thanks and Regards, >>>>> Chathuri >>>>> >>>>> >>>>> On Wed, Dec 7, 2011 at 6:56 PM, Anjana Fernando <[email protected]>wrote: >>>>> >>>>>> Hi Kalpa, >>>>>> >>>>>> I'm sure the internal functionality would be correct, but the UI have >>>>>> to be a bit more polished. We should consult some UI experts to make this >>>>>> look good. The alignment, proper names, background images, and all should >>>>>> be there properly, or else it won't give a good first impression. Some >>>>>> questions: what does "Drivers" mean there in the 2'nd screen-shot, should >>>>>> it be "Driver"? .. And in the 3'rd page, it doesn't make sense to say >>>>>> "SQL >>>>>> Query" and under that have "CRUD Operation", if we are not giving a SQL >>>>>> Query, and also when we select that, there shouldn't be a text area at >>>>>> the >>>>>> bottom visible to enter anything. So there, it should basically be >>>>>> something like, the header be "Service Creation Mode", and under that, >>>>>> two >>>>>> radio buttons with "Automatically Create CRUD Operations" and "Manual >>>>>> Operation Creation". Where "Manual.." is selected, you should >>>>>> enable/show a >>>>>> text area for SQL. And +1 for Harshana's suggestion. >>>>>> >>>>>> Cheers, >>>>>> Anjana. >>>>>> >>>>>> >>>>>> On Wed, Dec 7, 2011 at 4:24 PM, Kalpa Senanayake <[email protected]>wrote: >>>>>> >>>>>>> Hi all, >>>>>>> >>>>>>> Data service creation wizard have below functions currently. >>>>>>> >>>>>>> - Identify and extract header fields of csv,Excel data sources >>>>>>> (local and web). >>>>>>> - Extract the tables and allow user to select those for service >>>>>>> generation from various RDBMS data sources. >>>>>>> - Open the tree based "Data Service" editor end of the process >>>>>>> as default editor for .dbs. >>>>>>> >>>>>>> According to milestone plan in the next step wizard will be >>>>>>> featured with >>>>>>> >>>>>>> - Allow user to add custom query for the selected tables. >>>>>>> - Extend operation creation for csv and excel sources. >>>>>>> >>>>>>> Attached screen shots of current component. >>>>>>> >>>>>>> Thanks >>>>>>> Kalpa. >>>>>>> >>>>>>> On Mon, Nov 21, 2011 at 12:26 PM, Kalpa Senanayake >>>>>>> <[email protected]>wrote: >>>>>>> >>>>>>>> Hi Saminda, >>>>>>>> >>>>>>>> The targeted use cases were. >>>>>>>> >>>>>>>> 1. Allow user to start the configuration with "Create New Data >>>>>>>> Sources" instead of getting information like "data services name" >>>>>>>> etc..in >>>>>>>> the beginning. Users should start from adding data sources, then >>>>>>>> operations >>>>>>>> and then other necessary information. >>>>>>>> >>>>>>>> 2. Enhance the wizard to level that user only needs to give minimum >>>>>>>> details for data source creation process. >>>>>>>> >>>>>>>> Thanks, >>>>>>>> Kalpa. >>>>>>>> >>>>>>>> >>>>>>>> On Sat, Nov 19, 2011 at 6:28 PM, Saminda Wijeratne < >>>>>>>> [email protected]> wrote: >>>>>>>> >>>>>>>>> Hi Kalpa, >>>>>>>>> >>>>>>>>> Any use cases that was targeted for M1? Sorry if I had missed any >>>>>>>>> mail regarding this. >>>>>>>>> >>>>>>>>> Regards, >>>>>>>>> Saminda >>>>>>>>> >>>>>>>>> >>>>>>>>> On Fri, Nov 18, 2011 at 1:42 AM, Kalpa Senanayake >>>>>>>>> <[email protected]>wrote: >>>>>>>>> >>>>>>>>>> Hi, >>>>>>>>>> >>>>>>>>>> Surely will do,This component still in the PoC stage.The UI will >>>>>>>>>> change a lot , components in the UI ,presentation layout likewise. >>>>>>>>>> Thanks for the feed back. >>>>>>>>>> >>>>>>>>>> Thanks, >>>>>>>>>> Kalpa. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Fri, Nov 18, 2011 at 9:41 AM, Sumedha Rubasinghe < >>>>>>>>>> [email protected]> wrote: >>>>>>>>>> >>>>>>>>>>> Kalpa, >>>>>>>>>>> These screens need lot of re-work. But looks fine for the first >>>>>>>>>>> milestone. >>>>>>>>>>> /sumedha >>>>>>>>>>> >>>>>>>>>>> On Fri, Nov 18, 2011 at 4:50 AM, Kalpa Senanayake < >>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>> >>>>>>>>>>>> Hi All, >>>>>>>>>>>> >>>>>>>>>>>> DS Editor Milestone 1 is available at [1]. >>>>>>>>>>>> >>>>>>>>>>>> For the new Data Service Creation wizard. >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> - Enable capability to identify the following data source >>>>>>>>>>>> types and extract the relevant configuration details from the >>>>>>>>>>>> data source. >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> 1. CSV >>>>>>>>>>>> 2. Excel >>>>>>>>>>>> 3. Google Spread Sheet >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> - Enable ability to extract the DS operation related >>>>>>>>>>>> information from existing database connections on the Eclipse >>>>>>>>>>>> platform. >>>>>>>>>>>> >>>>>>>>>>>> Thanks, >>>>>>>>>>>> Kalpa >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> [1] >>>>>>>>>>>> http://builder4.us1.wso2.org/~carbon-studio/releases/carbon-studio/2.0.0/DSTools/M1/ >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>> Carbon-dev mailing list >>>>>>>>>>>> [email protected] >>>>>>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> Carbon-dev mailing list >>>>>>>>>>> [email protected] >>>>>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> _______________________________________________ >>>>>>>>>> Carbon-dev mailing list >>>>>>>>>> [email protected] >>>>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Carbon-dev mailing list >>>>>>>>> [email protected] >>>>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Carbon-dev mailing list >>>>>>> [email protected] >>>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> *Anjana Fernando* >>>>>> Senior Software Engineer >>>>>> WSO2 Inc. | http://wso2.com >>>>>> lean . enterprise . middleware >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Carbon-dev mailing list >>>>>> [email protected] >>>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Carbon-dev mailing list >>>>> [email protected] >>>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> *Anjana Fernando* >>>> Senior Software Engineer >>>> WSO2 Inc. | http://wso2.com >>>> lean . enterprise . middleware >>>> >>>> _______________________________________________ >>>> Carbon-dev mailing list >>>> [email protected] >>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>>> >>>> >>> >>> _______________________________________________ >>> Carbon-dev mailing list >>> [email protected] >>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>> >>> >> >> >> -- >> *Anjana Fernando* >> Senior Software Engineer >> WSO2 Inc. | http://wso2.com >> lean . enterprise . middleware >> >> _______________________________________________ >> Carbon-dev mailing list >> [email protected] >> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >> >> > > _______________________________________________ > Carbon-dev mailing list > [email protected] > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > -- *Anjana Fernando* Senior Software Engineer WSO2 Inc. | http://wso2.com lean . enterprise . middleware
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
