Hi,

I've created a number of table/forms/procedures in my test application. I'd now like to port these over to my Main application. Is there an easy way of doing this? RDK upgrade/Module doesn't seem to actually install anything if I try to install to a different application. I'm using OI7.2.0

Thanks for you time,

Andrew

Possibly the easiest method for all program bits is to create an rdk 'UPGRADE' file then simply rename all the bits with the appropriate app name.

DSig,

Your solution sounds like it would be easy if you have a CopyColumn utility, but…. Aren't all the RDK bits stored together in essentially one file? The application id is usually first in the id, except with Sysporcs and Sysobj. If the RDK data is all stored together, changing the application could be a mess.

However, a data CopyColumn utility would be very handy for this task. Andrew could try this approach on a COPY of the application, changing the Repository entries and application ids in associated SysRepos tables. Then an RDK could be built with the correct application, and applied back to the original system.

Gerald

]]Aren't all the RDK bits stored together in essentially one file? The application id is usually first in the id, except with Sysporcs and Sysobj. If the RDK data is all stored together, changing the application could be a mess.

Guess i was wrong again even though i have used this several times.

And yes .. SYSUPGRADE does contain all items in 1 location .. guess making the same changes in a lot of tables would be much easier.

Guess this is another one i will leave to you

if you would like to email me i will give you a sample routine for converting the basic 'bits' in a sysupgrade table ..

it has served us well .. geraldsaysitsmessy@sigafoos.org

DSig,

Actually, I do not use the RDK process myself, so I am just asking questions for my own information. I am guessing you would use a copyrow utility to change the record keys in SYSUPGRADE, but you would have to change each key by hand? If there are not too many records, this would be fine. (This would not be an option in an application with 3000+ records, hence my batch copycolumns approach.) I learn a whole lot from your responses DSig, but I have just one question – how should I interpret ".."?

Gerald

DSig,

Thanks for the plug. I have been told, "Some programmers are directory oriented, and others are database oriented." Similarly, some programmers write compiled routines, and others write batch command files. I am in the batch commands camp, while your response shows you are in the compiled program group. This explains why I didn't get your response right away – I didn't see how to do it your way without writing a program.

Gerald

I didn't see how to do it your way without writing a program.

Which is exactly what we did. For FrameWorks we designed a utility that renames RDKs. While it was intended for a relatively static RDK deployment, we've helped other developers rename their applications quite successfully.

dbakke@srpcs.com

SRP Computer Solutions, Inc.

Using my CopyColumns utility with my batch Process window, I would do the equivalent with a batch script. But since OI lacks the CopyColumns and batch scripting in general, the user is left with needing the program you describe. I have two words for those who disagree with the batch command approach: VOC, and PROC.

Thanks for all the replies.

I'm surprised that the RDK isn't capable of sorting this out itself. There is a Target Application in the "Path, Settings & Options" tab, but the help says that you can change it - would be nice if you could ;)

Andrew

FYI, there is a new SYSVOC file in OI 8.0, and the ability to create batch commands, check their syntax, save them and run them.

Mike Ruane

Andrew ..

send me your email off line for the routine ..

Mike:

OI 8.0 ?

When ?

Do you have a Beta ?

Enrique

Just to echo what I've already said privately….

Thank you, your script was very easy to follow and worked well.

best regs,

Andrew

8.0 is due out the end of this year.

No beta at this time.

However, I'll be showing progress to date (including the new SYSVOC and TCL functionality) at the roadshows.

Mike

thanks man .. glad it worked for you ..

if you find any oddities let me know ..

dsig

And, I'll be showing what's up with Arev32, UD Heavy, and CTO.

All and any developers or users who have any comments or questions should feel free to come by and ask and talk- either during the open session or privately afterwards. I don't have a ton of time in each city, but I'll try and make sure I can see you.

Thanks-

Mike Ruane

And for us, a small part of "the rest of the world" out of the Roadshows ???

Enrique

Enrique,

We would welcome you to our Auckland, New Zealand RoadShow in July. RevSoft travels to the ends of the earth (almost) to look after our innovative developers from down under. And if you wanted to do something after the Roadshow you could enjoy our natural pure NZ landscape.

Richard Bright

BrightIdeas New Zealand

Enrique-

I'd love to come down to Argentina, or another central location in South America, but my spanish is not so good, and I believe that there are not that many developers in the area. We have to pick and choose our trips.

If I'm wrong about the number of developers let me know and we'll see what we can schedule.

Thanks!

Mike Ruane

Mike,

I appreciate your effort in seeing everyone. However, I guess that we will miss you this time around.

Would you ever consider in the near future doing an abreviated Web conference to share RTI's new development on OI8, etc? It could be a convenient and economical way to share with developers (from Argentine to Tennessee) who don't have the opportunity to participate in the current roadshow for the practical reasons that you mentioned.

All those who would participate in such a web conference, please click your mouse NOW.

RTI wouldn't have to rent a room, provide coffee or donuts, etc.

Thanks again for OI32 and all the good stuff that you guys/gals have worked on.

Ray Chan

Spectrum has been doing "webinars" for a little while now. We've attended a few of those and I found them to be fairly helpful. One drawback (as far as I can tell) are that live demos are not possible. These are web-based slideshows with a conference call. Plus, if you use a service provider to facilitate this it costs money for each connection. However, that might be much cheaper than the cost of airfare and other related expenses.

dbakke@srpcs.com

SRP Computer Solutions, Inc.

You could always setup your own webinar with window net meeting. This provides the ability to share your desktop, in addition to voice.

We have condirered it, and do have WebEx already in house. Once this round is over we'll look at it for the next time.

But, gee, I'll miss all that quality airplane time…

We use Live meeting for web demos etc.

The cost of which can be relatively expensive:

https://main.livemeeting.com/ordering/lmbuy_it/buy_it.cfm

http://www.microsoft.com/office/livemeeting/howtobuy/default.mspx

However they have a deal that is not well publicized, if you only need 5 people at a time this is a steal. Unlimited usage $199/year. It used to be $99/year which is the deal I still have.

Buy the Personal Edition and instantly schedule and conduct meetings with up to 5 participants.

At: https://main.placeware.com/ordering/lmbuy_it/buy_it.cfm?promocode=2744

Hope this is of some use to someone.

Mike: I don't expect you to travel to our country (although it is a very beautiful one), neither that you learn our language. ¿Alguna vez desde 1987, cuando compramos RevG, nos comunicamos en español? (Did we ever communicate in Spanish since 1987, when we bought RevG?). That wasn't the spirit of the post. What I was trying to say is that it would be very nice for those who live far away, to have more information about what is going on, what is being improved, and if some bugs are or aren't being corrected, without the need to take a trip to the nearest Roadshow. In my case, there is no "nearest" Roadshow, all of them are almost equally far. But I would like to be able to download a PDF resuming the improvements and new features that exposed in the roadshows from the website, when the roadshows are over.

Regards,

Enrique

Point taken- and as I believe I've said somewhere in this thread, we'll see what we can do after the trips have all settled down.

I have developed an improved and more powerfull deployment kit, that does some things that the built-in RDK doesn't:

1. Work on different changes grouping entities modified in a table of changes, similar to RDK Repository View, but also has an author, a date,a description and the list of entities changed, and can be searched. (This is usefull later to answer to questions as "When was the last time this window was modified?", "Who did it?".)

1. The list of entities changed may include the same entities as the RDK, but:

1. If you change a window, you just need to record the window as a change, not the events of the window.

1. You can include any record of any table of the database.

1. You can also include new tables as part of a change, and the table, the dict and the index, if present, are automatically added to the deploy, there is no need to edit the %PROCESS% record.

1. Build different updates including one or more records of changes. You can use automatic versioning for updates for different customers, and for updates built by different developers. You can select which changes to include by date, author, entities modified. The selection process also offers you to discard changes already included in a previous update.

1. The update can include procedures to run inmediately after updating the system.

1. You can build a cross-application deploy, indicating the name of the target application. This lets you copy a set of entities from

  one application to another one. The program that builds the update renames entities as needed.

1. You can choose whether the target system is a runtime or a developement system (whether to deploy sources or not)

1. In the target system, you can use either the RDKInstall process, or a window that lets you select the location of the update, and see the contents, author, date and version before applying it.

1. There is also another window that your customer can use to see the history of updates applied, showing the contents, date, author and date in which they were applied.

I have developed this alternative approach because the built-in RDK is insufficient when you start to make many changes to an application.

Let me know if you would be interested in a tool like this. Actually, it is not ready to be selled, and it is in Spanish, but I think it is a tool that helps a lot by making updates much easier to record, track and deploy than with the built-in tool.

My e-mail is qmurphy@infovia.com.ar

Enrique

Enrique,

This sounds like a delightful program. I have worked on a partial update procedure (a procedure, not a program) for applying updates outside of the RDK approach. Possibly your programming could be combined with my procedures to produce a complete update system.

My work is based on the ATLAS development framework (of course). While beta 1 of ATLAS was on the WORKS CD, a beta 2 with source code will be available for download in a couple weeks. This is a non-commercial, open source, open distribution approach to OpenInsight development. I would like to include a program like you describe, as this would fill practically the last remaining hole in the package.

If you are interested in this, write me directly:

glovel@atlaswares.com

View this thread on the Works forum...