Wednesday, March 10, 2010


Home

Blog

Projects

About

Contact

Stweams
       #owsfirtstry
Stweams   »   #owsfirtstry    

#OWSfirtstry

In this stweam from Twitter I used to document my first attempt at using Open Web Studio by r2i. When I first used Listx, also from r2i, I found that what seemed like it would be straightforward and easy always seemed to end up be difficult. I wanted to see if others might be able to help me see where I went wrong. I wanted to see if it was me or r2i.
brillnat (brillnat)
#owsfirtstry added the module to a page. hmmm now what?
2009-04-30T15:22:22Z From TweetDeck
WEBPC (Antony)
@brillnat Watch the DNNCreative videos? #owsfirtstry
2009-04-30T15:26:36Z From TweetDeck
brillnat (brillnat)
#owsfirtstry The interface is not too discoverable. I'll watch the dnncreative demo as I go
2009-04-30T15:34:36Z From TweetDeck
brillnat (brillnat)
#owsfirtstry all three video's downloaded
2009-04-30T15:35:19Z From TweetDeck
brillnat (brillnat)
#owsfirtstry note to r2i - name the download files so that I can tell what order I should watch them. I'll go by create date.
2009-04-30T15:36:54Z From TweetDeck
brillnat (brillnat)
#owsfirtstry ahh inside the zip files they are named appropriately
2009-04-30T15:37:32Z From TweetDeck
brillnat (brillnat)
@slhilbert #owsfirtstry we will see that is why I want to do a real test. I have done some with listx and it was very powerful
2009-04-30T15:40:37Z From TweetDeck
brillnat (brillnat)
#owsfirtstry I have a data table defined in the database
2009-04-30T15:41:50Z From TweetDeck
brillnat (brillnat)
#owsfirtstry I am interested to see how it compares to ironspeed designer
2009-04-30T15:42:49Z From TweetDeck
brillnat (brillnat)
#owsfirtstry first video down and I have setup the configuration and nothing too different from things i saw in listx.
2009-04-30T15:48:34Z From TweetDeck
brillnat (brillnat)
#owsfirtstry There are a lot of options on the general configuration that see useful some I have no clue
2009-04-30T15:50:04Z From TweetDeck
brillnat (brillnat)
#owsfirtstry tabs seem funny in the interface. It shows that I am on the general tab yet when I click the tab it send me to a diff page
2009-04-30T15:51:26Z From TweetDeck
brillnat (brillnat)
#owsfirtstry you start by selecting "template" to define the query to get your data from the table. It seems sort of misleading to me
2009-04-30T15:59:02Z From TweetDeck
brillnat (brillnat)
#owsfirtstry it creates a query template. I think calling it query in the menu would have been more helpful to me
2009-04-30T16:00:10Z From TweetDeck
brillnat (brillnat)
#owsfirtstry the configuration repository seems nice. It saves all version of published configurations I think. I have to try a rollback
2009-04-30T16:06:15Z From TweetDeck
brillnat (brillnat)
#owsfirtstry now I selected the config in the dnn page module settings. open the ows settings and it should show nothing for the config
2009-04-30T16:09:46Z From TweetDeck
brillnat (brillnat)
#owsfirtstry it shows the top item in the list but that has not been selected and saved. kind of confusing. a blank config would be better
2009-04-30T16:10:43Z From TweetDeck
brillnat (brillnat)
#owsfirtstry video 2 done.
2009-04-30T16:12:16Z From TweetDeck
brillnat (brillnat)
#owsfirtstry The tabs in the interface have some strange things. click on a tab and it leave the work area the way it was
2009-04-30T16:14:18Z From TweetDeck
brillnat (brillnat)
#owsfirtstry if I'm in the repository view and click the action tab it changes the menu area but the work area is the repository.
2009-04-30T16:15:49Z From TweetDeck
brillnat (brillnat)
#owsfirtstry might be because I have no actions defined yet
2009-04-30T16:16:12Z From TweetDeck
brillnat (brillnat)
#owsfirtstry I keep forgetting that you can run sql command against the dnn db in the host menu
2009-04-30T16:19:18Z From TweetDeck
brillnat (brillnat)
#owsfirtstry of course I almost never put data tables in the dnn DB. I like to have them in separate databases.
2009-04-30T16:20:25Z From TweetDeck
brillnat (brillnat)
#owsfirtstry added a query action but it doesn't say how to open it so you can define the query. ahhh you have to double click on it
2009-04-30T16:24:06Z From TweetDeck
brillnat (brillnat)
#owsfirtstry nice that they let you test the query in the definition screen, but all I get is "failed to complete query please try again".
2009-04-30T16:32:31Z From TweetDeck
brillnat (brillnat)
#owsfirtstry must be my connection string
2009-04-30T16:32:48Z From TweetDeck
brillnat (brillnat)
#owsfirtstry goto the wiki found a connstring page. examples... sql server should be straight forward. edit it with my info. same error
2009-04-30T16:37:50Z From TweetDeck
brillnat (brillnat)
#owsfirtstry tried several diff version of the conn string, by IP, by name hmmm try to query a diff table top make sure it's not priv .
2009-04-30T16:45:51Z From TweetDeck
brillnat (brillnat)
#owsfirtstry ERROR MESSAGE TOTALLY UN-HELPFUL
2009-04-30T16:46:18Z From TweetDeck
brillnat (brillnat)
#owsfirtstry OH!! I have a listx module functioning on this site I'll use it's connstring and query that I know works
2009-04-30T16:50:09Z From TweetDeck
brillnat (brillnat)
#owsfirtstry but it doesn't in OWS
2009-04-30T16:50:28Z From TweetDeck
brillnat (brillnat)
#owsfirtstry time to get a cup of coffee
2009-04-30T16:51:02Z From TweetDeck
brillnat (brillnat)
#owsfirtstry seem to remember that someplace listx or ows didn't use the conn string . I'll try to query the dnn db with my connstring
2009-04-30T16:58:54Z From TweetDeck
brillnat (brillnat)
#owsfirtstry yep!! select * from users returns a list of my dnn users and my conn string points to a db that has no users table
2009-04-30T17:00:52Z From TweetDeck
brillnat (brillnat)
#owsfirtstry just to make sure I'll change the PW on the conn string so it should fail. NOPE it still works. ....Thanks R2i
2009-04-30T17:02:20Z From TweetDeck
brillnat (brillnat)
@kevinmschreiner #dnn #ows Please follow #owsfirtstry
2009-04-30T17:08:36Z From TweetDeck
brillnat (brillnat)
#owsfirtstry okay, I'll put my conn string and query back to what I want and move forward and assume it will work.
2009-04-30T17:09:58Z From TweetDeck
brillnat (brillnat)
#owsfirtstry I don't get quickbuilder link unless I get a query that works.
2009-04-30T17:20:26Z From TweetDeck
brillnat (brillnat)
#owsfirtstry I'll create a table in the dnn db that matches mine. quickbuilder can do its stuff and maybe later it will use the conn string
2009-04-30T17:23:58Z From TweetDeck
brillnat (brillnat)
#owsfirtstry it built all the module info to show grid,edit,delete and view. But it pulls data from the dnn DB.
2009-04-30T17:36:14Z From TweetDeck
brillnat (brillnat)
#owsfirtstry went back changed each query and query template actions (i think that is what they are called) to use a custom conn string
2009-04-30T17:57:00Z From TweetDeck
brillnat (brillnat)
#owsfirtstry That seems to work. It brings up data from my remote table
2009-04-30T17:57:51Z From TweetDeck
brillnat (brillnat)
#owsfirtstry Clickl view it shows me info from the remote db but the cancel button appears to do nothing. How to get back the grid view???
2009-04-30T18:01:26Z From TweetDeck
brillnat (brillnat)
#owsfirtstry now how do i turn on the debugging maybe that will help to see why cancel doesn't take me back
2009-04-30T18:04:14Z From TweetDeck
brillnat (brillnat)
#owsfirtstry when I tried edit it brings up info from remote db. cancel takes me back to grid view.
2009-04-30T18:07:06Z From TweetDeck
brillnat (brillnat)
#owsfirtstry try to make a change and save and it takes me back to an empty grid view. Hmm refresh the page and the data appears unchanged
2009-04-30T18:08:09Z From TweetDeck
brillnat (brillnat)
#owsfirtstry checked both db's and neither has the new data change
2009-04-30T18:08:47Z From TweetDeck
brillnat (brillnat)
#owsfirtstry just noticed I have no way to add a new record. I wonder if I missed that part in quickbuilder
2009-04-30T18:10:04Z From TweetDeck
brillnat (brillnat)
#owsfirtstry well so far I know that I can get something useful out of ironspeed designer right off that bat and NOT with OWS.
2009-04-30T18:13:40Z From TweetDeck
brillnat (brillnat)
#owsfirtstry Lunchtime. Hey Rick ya wanna get some lunch?
2009-04-30T18:14:41Z From TweetDeck
brillnat (brillnat)
#owsfirtstry 2 chilidogs and a diet coke later I tried to add a "add" link to the grid view. The quickbuilder made an action but no link
2009-04-30T19:26:37Z From TweetDeck
brillnat (brillnat)
#owsfirtstry All I get is the query failed message when I try to publish
2009-04-30T19:27:07Z From TweetDeck
brillnat (brillnat)
#owsfirtstry hmm tried to take out what I did. now if I try to publish I get a failed to complete query please try again
2009-04-30T19:31:56Z From TweetDeck
brillnat (brillnat)
#owsfirtstry guess I'll try the rollback form the configuration repository
2009-04-30T19:32:25Z From TweetDeck
brillnat (brillnat)
#owsfirtstry nope that didn't work. I went to the tools tab where is shows the repository menu items. selected view and it shows nothing
2009-04-30T19:35:07Z From TweetDeck
brillnat (brillnat)
#owsfirtstry getting desperate now. close the browser that that the ows admin. and then I'll close teh dnn site browser as well
2009-04-30T19:36:34Z From TweetDeck
brillnat (brillnat)
#owsfirtstry got do some other work for a bit. brb
2009-04-30T19:40:39Z From TweetDeck
kevinmschreiner (kevinmschreiner)
#owsfirtstry if you get that message when publishing it is because you are no longer logged in as a host. Just log back in in another window
2009-04-30T19:42:31Z From TweetDeck
brillnat (brillnat)
@kevinmschreiner #owsfirtstry yeah that is what I figured I would try. it'd be nice if the message hinted that that might be the problem
2009-04-30T20:06:36Z From TweetDeck
brillnat (brillnat)
#owsfirtstry okay re log back in and try again
2009-04-30T20:08:08Z From TweetDeck
brillnat (brillnat)
#owsfirtstry logged back in, now trying to figure out where to add a "new" link. The way OWS is layed out I could really use a taller screen
2009-04-30T20:13:28Z From TweetDeck
kevinmschreiner (kevinmschreiner)
#owsfirtstry you can increase and decrease the size of the text editors with Shift+Ctrl+Up/Down or drag the splitter in mid screen too!
2009-04-30T20:32:07Z From TweetDeck
brillnat (brillnat)
#owsfirtstry looks like I cannot create a useful data table maintenance page for a table in a database that is not in the dnn db with ows
2009-04-30T21:17:21Z From TweetDeck
brillnat (brillnat)
#owsfirtstry using quickbuilder and is a timely fashion. I am assuming that you could build one without quickbuilder
2009-04-30T21:18:31Z From TweetDeck
brillnat (brillnat)
#owsfirtstry I really wanted to show them here that there are new tools around that can build database apps as easily as Clarion
2009-04-30T21:21:22Z From TweetDeck
brillnat (brillnat)
#owsfirtstry The only view that actually worked like I expected was the delete. Now I have deleted my only record :( funny
2009-04-30T21:27:17Z From TweetDeck
brillnat (brillnat)
@cchodnicki #owsfirtstry two words QUICKBUILDER CONNECTIONSTRING
2009-05-01T14:13:20Z From TweetDeck
cchodnicki (cchodnicki)
RT @brillnat: @cchodnicki #owsfirtstry DM and I can send email based instructions that will guide you further. SuggestOWS forum in future
2009-05-01T15:07:40Z From TweetDeck
brillnat (brillnat)
@cchodnicki #owsfirtstry I cannot DM unless you are following me
2009-05-01T15:57:27Z From TweetDeck
brillnat (brillnat)
@cchodnicki read - #owsfirtstry I thought it would be cool to use twitter to document my building a simple thing using ows
2009-05-01T15:59:21Z From TweetDeck
stavanja (Rick Stavanja)
@brillnat Holy cow! Your #owsfirtstry went south in a hurry!! OTOH, at least it makes me better about my failed first attempt with #ows
2009-05-01T17:08:13Z From Seesmic Desktop
stavanja (Rick Stavanja)
@brillnat I tried to use #ows to make an admin tool for a dept video library. After 2hrs of videos & slugging away, i gave up #owsfirtstry
2009-05-01T17:12:33Z From Seesmic Desktop
stavanja (Rick Stavanja)
@brillnat Ended up using ListX for paged grid, and MS Access project to edit data (15min). Thought I was too dumb for #ows #ows #owsfirtstry
2009-05-01T17:16:20Z From Seesmic Desktop
WEBPC (Antony)
@brillnat Just copy/paste #owsfirtstry
2009-05-01T17:35:36Z From TweetDeck
brillnat (brillnat)
@WEBPC #owsfirtstry I have some more to add. Do you think that whole stream should be in the post? I will have a link
2009-05-01T17:57:06Z From TweetDeck
WEBPC (Antony)
@brillnat It gives a good description of how you went about it, you could blog a summary in addition #owsfirtstry
2009-05-01T18:40:43Z From TweetDeck
Privacy Statement  |  Terms Of Use
Copyright 2009,2010 by Brillnat