Navision Object Checkout

Administrator

Navision Object Checkout
Navision Object Checkout is a utility meant to help Navision developers concurrently working on the same database.
It is a basic version control system, allowing to lock objects for development.
Additional features include a history of all object changes and a possibility to revert to a historical object version.

http://www.mibuso.com/dlinfo.asp?FileID=1102

Discuss this download here.

vytjak

Hello there,

this is the author of the utility writing.

A few more notes that haven't made it to the rather brief description:
1) included in the donwload file are: a FOB file, a SQL script and documentation;
2) this utility was only used internally so far, so I'd be grateful for any feedback, suggestions for improvements, bug reports or just general comments;
3) I am aware of the several similar tools available, what I think sets this apart is that it doesn't use any dlls/automation, just a couple of SQL triggers;
4) SQL: this was only tested on MS SQL 2005, but I think it should work on MS SQL 2000 as well. If anybody could confirm/deny that, that would be great, otherwise I'll get to testing it on SQL 2000 at some point.

henrikohm

Hi

This is a super nice tool and it works very good!!

A couple of questions:
1. Is it possible to get a warning when pressing "Design" on a object to avoid making a lot of changes?
2. If person A makes changes and checks in the object and person B thereafter designs the object. Is it possible to get a message "Your local object version is older than the server version, please restart client".?

Best regards
Henrik Ohm
Abakion A/S - Denmark

vytjak

henrikohm wrote:

Hi
A couple of questions:
1. Is it possible to get a warning when pressing "Design" on a object to avoid making a lot of changes?
2. If person A makes changes and checks in the object and person B thereafter designs the object. Is it possible to get a message "Your local object version is older than the server version, please restart client".?

Hi Henrik,

1) Unfortunately no , not with this tool at least. I guess your best bet here would be to save every few minutes, whenever you start to change the object - that way all that you'd lose is a few minutes of work.
I guess what you want would be possible in theory, but that would mean going beyond pure NAV/SQL trigger changes, and I wanted to avoid that.

2) To avoid this problem, I suggest to always set the Object Cache to 0 in the development environments. We've always done this in the project teams I've worked with - object caching always caused problems while developing and testing when the object versions changed rapidly.


And as mentioned before, if you are using and like the tool, I'd be grateful for any suggestions or comments .

androjdaz

vytjak wrote:

Hello there,

this is the author of the utility writing.

A few more notes that haven't made it to the rather brief description:
1) included in the donwload file are: a FOB file, a SQL script and documentation;
2) this utility was only used internally so far, so I'd be grateful for any feedback, suggestions for improvements, bug reports or just general comments;
3) I am aware of the several similar tools available, what I think sets this apart is that it doesn't use any dlls/automation, just a couple of SQL triggers;
4) SQL: this was only tested on MS SQL 2005, but I think it should work on MS SQL 2000 as well. If anybody could confirm/deny that, that would be great, otherwise I'll get to testing it on SQL 2000 at some point.

Hello, Vyteni,

Very nice tool. Unfortunately developers are too lazy to Check-Out objects manually It would be a perfect tool if it could manage to trigger an automatic Check-Out on entering object design mode and respectively Check-In on exiting object design mode. I guess it's not possible to create such SQL triggers. Anyways, good work.

Good luck,
Andrius

ara3n

here is a tool that allows automatic checkout.

http://mibuso.com/blogs/ara3n/page/3/

You still have to manually check in the object.

androjdaz

ara3n wrote:

here is a tool that allows automatic checkout.

http://mibuso.com/blogs/ara3n/page/3/

You still have to manually check in the object.

Thanks, I guess I have missed that blog entry

androjdaz

ara3n wrote:

here is a tool that allows automatic checkout.

http://mibuso.com/blogs/ara3n/page/3/

You still have to manually check in the object.

I've just tried it. It's working just as Navision Object Checkout - checks out only when saving object, not when opening it in designer mode.

DenSter

What's wrong with being able to look at the object design while someone else is working on it? That tool works great. You know you have to save it to check it out, so if you need to work on a certain object, the first thing you do is save it. It's like reserving the object. You'll know when someone else has it checked out.

It's not a waterproof source management tool, but it is VERY effective. I've used it (Rashed's tool, which was based on an earlier version that someone else at that company wrote) many times and it works great.