OnGlobalInsert in CU 1 doesn't work for object table

Lyuchin

Hi nav community!

I need to track all changes within Nav objects. So I activated change log via Change Log Setup form for Object table and set Log Insertion, Log Modification and Log Deletion to All Fields. Then changed CU 1 adding MESSAGE in all OnGlobalXxx methods to test what will happen. Next I tried to test it. I created a new table, I expected message "Insert" b/c trigger OnGlobalInsert had to be caused. But nothing happend. After I tested all other actions (like renaming or deletion this table) and they work!
So my question is: why OnGlobalInsert trigger is not caused in the case of Object table, while it's working fine for all others tables provided that the change log is activated for these tables? And how to make to work it?

Thanks in advance! Will wait for your help.

Luc_VanDyck

It's probably because you are not modifying the Object table directly. It is done by NAV, when you create or modify a table.

Lyuchin

Implicitly, right. But why then delete, modify and rename work?

kine

If you try to insert the object by F3, it will work. But because you are using Wizard to create it, it will not work... this is my view on this...

Have you tried the rename/modify from within the designer itself or just by changing the field values in the object list?

Lyuchin

kine wrote:

If you try to insert the object by F3, it will work. But because you are using Wizard to create it, it will not work... this is my view on this...

Have you tried the rename/modify from within the designer itself or just by changing the field values in the object list?

No no, I don't use any wizards. To test functionality I''m just trying to create any object, let's say Table, in the object designer by clicking on New button. After structure definition is done and object is saved, OnGlobalInsert have to be triggered (because a new record was inserted into Object table), but actually it has not.

kine

But still, I am not sure if it will help you, because you can edit the objects even when you have no company selected, but Change log is set per company... :-)

ara3n

there are tools in download folder that allows you track changes using sql triggers.

If you are on sql 2008, you can use sql tools to track changes on object table.

Lyuchin

Ok, I found workaround without using of navision. It is not actual now. Thanks all who replied.

Now I have another complex question: how to catch import of objects (File > Import...) in Navision. There is no correspond method to track import in CU 1. In other words I need certain track that import is done.

Luc_VanDyck

Lyuchin wrote:

There is no correspond method to track import in CU 1. In other words I need certain track that import is done.

Don't think you can track down if a fob was imported.

You could create a dummy object (for example codeunit 90001) which you include with the other objects in the fob-file. Then you can check if this dummy object exists in the database, to know if the fob has been imported.
The 2nd fob will have codeunit 90002 as dummy object, which you can check to know if fob 2 has been imported. Etc.

I know this is not foolproof however.

kine

Best is to use trigger on Object table on SQL. On Native you do not have this possibility...

rdebath

Lyuchin wrote:

Now I have another complex question: how to catch import of objects (File > Import...) in Navision. There is no correspond method to track import in CU 1. In other words I need certain track that import is done.

If you're tracking from an SQL insert trigger all the objects in the import will be put into the database in the same transaction. If there's only one object you're kinda stuck, though you can catch some of them because the BLOB will be updated and the modified flag will be false. Maybe the modified time?

Just to be certain, there is NO way to make sure you can log everything from C/SIDE because changes to the object table can be made when you're not in a company and nothing will be called.

You can track every change from SQL but it's not always easy to interpret what triggered the change.
viewtopic.php?f=23&t=33344#p162604

David_Singleton

Lyuchin wrote:

Ok, I found workaround without using of navision. It is not actual now. Thanks all who replied.

What was the work around?

Lyuchin

David Singleton wrote:

Lyuchin wrote:

Ok, I found workaround without using of navision. It is not actual now. Thanks all who replied.

What was the work around?

Well, actually it is even not workarond but the solution with help another programming language, namely C#. Since it will be a tool with source control functionality, we use "bridge" written on C#, so that I used more wide possibilities of .net to solve this problem

About import, yes I agree that the only one possibility to track it is create trigger for Object table.
Thanks all again!