Object Manager Advanced v10.03 (trial till 15-11-2017)

2456712

Comments

  • nyambayarnyambayar Member Posts: 2
    Hi everybody,

    i have problem with the "renumber object" function. when i was trying to change a code unit id, it said:
    "importing the object in text-format failed".

    How to solve this problem.
    Thanks
  • reijermolenaarreijermolenaar Member Posts: 256
    Can you please try to export and import the object in text format in the Object Designer?
    Reijer Molenaar
    Object Manager
  • nyambayarnyambayar Member Posts: 2
    Hello Reijermolenaar, thank you for suggest.

    As you suggest, i tried to export and import the object, then i found what was the problem. The object used local file which not existed on my file system.

    Thank you again. :)
  • reijermolenaarreijermolenaar Member Posts: 256
    You're welcome!
    Reijer Molenaar
    Object Manager
  • ShedmanShedman Member Posts: 194
    I'm using the Renumber Fields functionality, but it throws me an error
    Field no. 1xxxx490 is not defined in the Vendor table.
    
    which is the first field I try to renumber ...

    I've tried adding the field no. manually, to rule out license issues, that works.

    When I skip the Vendor table, I get the same error on the next table.

    Any ideas?
  • reijermolenaarreijermolenaar Member Posts: 256
    Hi Shedman,

    Can you please send me your vendor table in textformat with the list of fields which you try to renumber.
    Then I will test it on my database.

    Regards,
    Reijer Molenaar
    Object Manager
  • nyambayarnyambayar Member Posts: 2
    Hello guys,

    I have an object which is already imoperted from a FOB file . i tried to renumber the object using the Object manager. But an error occured when importing/exporting the object in text file. The error was about a label's bitmap properties is set to not existing file(empty-> not in my pc). That's why i removed value of the properties. Then it is renumbered as fine. But its without the image.

    That object is developed somewhere and i don't have that image.
    Can i renumber the object using object manager without check import/export in text file?
    if can't, How to get the image from the fob file?

    Thanks,
  • reijermolenaarreijermolenaar Member Posts: 256
    No, then you can’t renumber the object with the Object Manager.

    The Object Manager recompiles the text-version of all involved objects so that will fail if you don’t have the bitmap available.

    As far as I know you can’t extract the bitmap out of the objects. But I don’t know for sure, I never have used this functionality. I always pick one of the bitmaps that are available.
    Reijer Molenaar
    Object Manager
  • lyotlyot Member Posts: 202
    Hi,

    I'm getting an error when I try to renumber the Payment Terms table:

    Microsoft Dynamics NAV Classic
    The C/AL History Line already exists.

    Identification fields and values:

    Entry No.='2863',Line No.='5334',Sub Line No.='1'

    OK
  • reijermolenaarreijermolenaar Member Posts: 256
    Hi Lyot,

    Are you using a sql or a native db?
    On which line of code do get the error?
    Reijer Molenaar
    Object Manager
  • lyotlyot Member Posts: 202
    SQL 2008
    MS Dynamics NAV 2009 SP1 W1

    Debugger halts on:

    Codeunit 91813
    RenumberObject(CALHistoryLine,ObjectToRenumber)
    
    IF CALHistoryLine.FINDSET THEN
      REPEAT
        CLEAR(CALLine);
        CurrentLineNo := CALHistoryLine."Line No.";
        CALHistoryLine.SETRANGE("Line No.", CurrentLineNo);
    
        REPEAT
          ArrayNumber := ROUND((CALHistoryLine."Sub Line No." - 1) / 4, 1, '<') + 1;
          CALLine[ArrayNumber] += CALHistoryLine.Code;
        UNTIL CALHistoryLine.NEXT = 0;
    
        FOR i := 1 TO ArrayNumber DO
          RenumberCALLine(CALLine[i], ObjectToRenumber);
    
        CALHistoryLine.DELETEALL;
        FOR i := 1 TO ArrayNumber DO BEGIN
          SubLineNo := 0;
          WHILE (CALLine[i] <> '') OR (SubLineNo = 0) DO BEGIN
            SubLineNo += 1;
            CALHistoryLine."Sub Line No." := SubLineNo;
            CALHistoryLine.Code := DELSTR(CALLine[i], 251);
    ===> CALHistoryLine.INSERT;   
            IF STRLEN(CALLine[i]) > 250 THEN
              CALLine[i] := COPYSTR(CALLine[i], 251)
            ELSE
              CALLine[i] := '';
          END;
        END;
    
        CALHistoryLine.SETFILTER("Line No.", '>%1', CurrentLineNo);
      UNTIL CALHistoryLine.NEXT = 0;
    
    CALHistoryLine.SETRANGE("Line No.");
    
  • reijermolenaarreijermolenaar Member Posts: 256
    Thanks Lyot,

    I can reproduce the error.
    I will fix it and upload a new version the weekend!
    Reijer Molenaar
    Object Manager
  • AdministratorAdministrator Member, Moderator, Administrator Posts: 2,495
    Object Manager Light v4.03
    The Object Manager is a tool for developers and consultants. You can keep track of the NAV objects you change and update the version list when you are ready. Combine all modifications in a transport and import them safely with a wizard in your customer database.

    What's New in v4.03
    - Bugfixes

    What's New in v4.02
    - Bugfix in SQL trigger

    What's New in v4.01
    - Renumber Fields! (video)
    - Save objects in old NAV formats (Downgrade to 5.0, 4.0, 3.6)!
    - Trace modifications with SQL trigger!
    - Analyse Table Relations!
    - Backup / Restore!
    - Compress C/AL History!
    - FOB for each NAV version!

    What's New in v3.01
    - Documentation!
    - Renumber Objects!
    - Delete Unused Variables!
    - Sort Variables!
    - Translation Tool!
    - Client Monitor Analyzer!
    - License Checker!
    - Bitmap Overview!

    What's New in v2.11
    - Bugfixes

    What's New in v2.01
    - Where-Used Functionality!
    - Automatic C/AL code saving when objects are changed!

    Trace Modifications
    Modifications on objects can be traced. You assign them to a project. Projects are combined in a transport and imported in your customer database.
    Demo Video: Trace Modifications in Popup Mode
    Demo Video: Trace Modifications in Save Mode

    Locking of Objects
    You can lock objects (checkout objects) so your colleague developers can see that you are working on a particular object.
    Demo Video: Object Locking

    Transport objects to your customer database
    A new generation FOB named FIB is used to transport objects to your customer database. It can include master data, actions for data manipulation, permissions and more. You import this FIB in your customer database with a wizard. Before importing the FIB you will be warned if your customer has changed one or more objects by itself.
    Demo Video: Create Transport
    Demo Video: Import Transport in Customer Database
    Demo Video: Transport With Action
    Demo Video: Import Transport With Action in Customer Database

    Action Worksheet
    90% of your conversion reports are becoming obsolete cause to the Action Worksheet. You can easily create actions like empty fields, copy data and even transfer data between databases. Other examples of actions are "Run report", "Run codeunit", etc. Actions can be included in your transport so they are also executed in your customer database.
    Demo Video: Action Worksheet

    Version and Source Control
    Your source code can be saved automatically every time you make a change. This makes it possible to do a rollback or compare your code to a previous version. Changes can be analysed in e.g. Beyond Compare.
    Demo Video: Source Control

    Record Permission Wizard
    It is possible to record permissions with a wizard. Simply start the wizard, do all the things your customer has to execute and the wizard creates a role. This permissions can be included in a transport and automatically imported in your customer database.
    Demo Video: Record Permission Wizard

    Where-Used Functionality
    Find out where objects, keys, triggers, fields, functions etc are used. Easily track down unused variables, keys and fields.
    Demo Video: Where Used Functionality

    Renumber Objects
    Renumber objects directly in your database. Exporting and importing a text file is no longer needed. All references to these objects will also be updated.
    Demo Video: Renumber Objects

    Renumber Fields
    Renumber fields directly in your database. Emptying your tables and ex- and importing a text file is no longer needed. All references to these fields will also be updated.
    Demo Video: Renumber Fields

    Update Variables
    Sort and delete unused variables. Objects will be updated directly in your database.
    Demo Video: Sort Variables
    Demo Video: Delete Unused Variables

    Translation Tool
    Change easily the names and captions that are used in your objects.
    Demo Video: Translation Tool

    Client Monitor Analyzer
    Show the client monitor data in a datagrid and zoom in to the executed code.
    Demo Video: Client Monitor Analyzer

    Edit Table Data
    Change your data without validation.
    Demo Video: Edit Table Data

    Get the advanced version at http://www.idyn.nl/objectmanager

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

    Discuss this download here.
  • lyotlyot Member Posts: 202
    Renumbering objects works like a charm now! =D>

    I stil got a general question:

    Supose Jeff modifies object 1 for and attaches this modification to project 1.
    The day after Steve modifies object 1 and attaches this modification to project 2.

    If Jeff at the end of the week makes a transport only for project 1.
    Will this transport include or exclude Steve's modification on object 1?
  • reijermolenaarreijermolenaar Member Posts: 256
    Hi Lyot,

    This is called “Overlapping Objects” in the Object Manager. You can read about it on page 48 in the manual:
    When transporting projects you sometimes have the problem of overlapping objects. For example: you used table Item as well in project 1 as in project 2 and you want to transport only project 1.
    The Object Manager checks if the transport has overlapping objects.

    You can check where these objects are used with the function “Show Overlapping Objects”.

    The bold lines in this form are in the transport.

    Now you have three options:
    1. Remove the modifications manually made in project 2 and delete the object from project 2
    2. Finish and include project 2 to the transport
    3. Enable “Ignore Overlap” on the “Transport Card” if you know for sure that it would not give any complications in the customer database
    Regards,
    Reijer
    Reijer Molenaar
    Object Manager
  • dgroeserdgroeser Member Posts: 39
    the object lines will not create automaticely with the SQL-Trigger???
  • reijermolenaarreijermolenaar Member Posts: 256
    Hi dgroeser,

    What do you mean with object lines?
    Reijer Molenaar
    Object Manager
  • dgroeserdgroeser Member Posts: 39
    Ok my failure, i must activate the trace!
  • dgroeserdgroeser Member Posts: 39
    There is a problem with variable Name at sample next,find etc.

    in the codeunit Where used management does exist a function "GetNextFilter" with a parameter "next", the where used codeunit run in the code
    
    
            'find', 'findfirst', 'findlast', 'findset', 'isempty', 'next' :
              BEGIN
                Parent := GetParentName(First, CoupleString, NameOfIndent, Indent, MiniIndent);
                Found := FALSE;
                IF Parent = '' THEN BEGIN
                  Variable.SETRANGE(Name, 'find');
                  Found := Variable.FINDFIRST;
                END ELSE BEGIN
                  Variable.SETRANGE(Name, Parent + '.' + 'find');
                  Found := Variable.FINDFIRST;
                END;
    
                IF Found THEN
                  AddVariableUsedInRecord(Variable, WhereUsedIn, CALLineNo, Validated);
              END;
    
    that´s a problem, there is no possibilty to findout, it´s that a parameter or a next???
  • reijermolenaarreijermolenaar Member Posts: 256
    Yes, you are right!

    Now the Object Manager sees the parameter as unused.
    I will correct it in the next version.

    Thanks for reporting it!
    Reijer Molenaar
    Object Manager
  • dgroeserdgroeser Member Posts: 39
    Would in the next version the where used management extendet to global variables?
  • reijermolenaarreijermolenaar Member Posts: 256
    You mean that you can see where global variables are used?

    Nope, I don't think I will add that functionality...
    The scope of a global variable is only in his own object so I do not see the real benefit of it.
    You can do a simple Ctrl+F to find where a global is used.

    It can find unused globals though...
    Reijer Molenaar
    Object Manager
  • lyotlyot Member Posts: 202
    Hi,

    I got a very annoying bug.
    Whenever I do a Run for a table and my trace modifications trigger (popup) is activated.
    I get the assign modifications screen for FORM 91870 OM - Show Table Data. (see bug1.png)

    When I try to do a run on the table Warehouse Entry I get the following error:
    ---------------------------
    Microsoft Dynamics NAV Classic
    ---------------------------
    You cannot apply the filter to the Entry No. field because the filter and the field are of different types.
    
    Table: Warehouse Entry
    
    ---------------------------
    OK   
    ---------------------------
    

    However after pressing Ok, the table will run.
  • reijermolenaarreijermolenaar Member Posts: 256
    Hi Lyot,

    Yes, That is really annoying indeed.
    I will fix it it and upload a new version this weekend!
    Reijer Molenaar
    Object Manager
  • AdministratorAdministrator Member, Moderator, Administrator Posts: 2,495
    Object Manager Light v4.04
    The Object Manager is a tool for developers and consultants. You can keep track of the NAV objects you change and update the version list when you are ready. Combine all modifications in a transport and import them safely with a wizard in your customer database.

    What's New in v4.04
    - Bugfixes

    What's New in v4.03
    - Bugfixes

    What's New in v4.02
    - Bugfix in SQL trigger

    What's New in v4.01
    - Renumber Fields! (video)
    - Save objects in old NAV formats (Downgrade to 5.0, 4.0, 3.6)!
    - Trace modifications with SQL trigger!
    - Analyse Table Relations!
    - Backup / Restore!
    - Compress C/AL History!
    - FOB for each NAV version!

    What's New in v3.01
    - Documentation!
    - Renumber Objects!
    - Delete Unused Variables!
    - Sort Variables!
    - Translation Tool!
    - Client Monitor Analyzer!
    - License Checker!
    - Bitmap Overview!

    What's New in v2.11
    - Bugfixes

    What's New in v2.01
    - Where-Used Functionality!
    - Automatic C/AL code saving when objects are changed!

    Trace Modifications
    Modifications on objects can be traced. You assign them to a project. Projects are combined in a transport and imported in your customer database.
    Demo Video: Trace Modifications in Popup Mode
    Demo Video: Trace Modifications in Save Mode

    Locking of Objects
    You can lock objects (checkout objects) so your colleague developers can see that you are working on a particular object.
    Demo Video: Object Locking

    Transport objects to your customer database
    A new generation FOB named FIB is used to transport objects to your customer database. It can include master data, actions for data manipulation, permissions and more. You import this FIB in your customer database with a wizard. Before importing the FIB you will be warned if your customer has changed one or more objects by itself.
    Demo Video: Create Transport
    Demo Video: Import Transport in Customer Database
    Demo Video: Transport With Action
    Demo Video: Import Transport With Action in Customer Database

    Action Worksheet
    90% of your conversion reports are becoming obsolete cause to the Action Worksheet. You can easily create actions like empty fields, copy data and even transfer data between databases. Other examples of actions are "Run report", "Run codeunit", etc. Actions can be included in your transport so they are also executed in your customer database.
    Demo Video: Action Worksheet

    Version and Source Control
    Your source code can be saved automatically every time you make a change. This makes it possible to do a rollback or compare your code to a previous version. Changes can be analysed in e.g. Beyond Compare.
    Demo Video: Source Control

    Record Permission Wizard
    It is possible to record permissions with a wizard. Simply start the wizard, do all the things your customer has to execute and the wizard creates a role. This permissions can be included in a transport and automatically imported in your customer database.
    Demo Video: Record Permission Wizard

    Where-Used Functionality
    Find out where objects, keys, triggers, fields, functions etc are used. Easily track down unused variables, keys and fields.
    Demo Video: Where Used Functionality

    Renumber Objects
    Renumber objects directly in your database. Exporting and importing a text file is no longer needed. All references to these objects will also be updated.
    Demo Video: Renumber Objects

    Renumber Fields
    Renumber fields directly in your database. Emptying your tables and ex- and importing a text file is no longer needed. All references to these fields will also be updated.
    Demo Video: Renumber Fields

    Update Variables
    Sort and delete unused variables. Objects will be updated directly in your database.
    Demo Video: Sort Variables
    Demo Video: Delete Unused Variables

    Translation Tool
    Change easily the names and captions that are used in your objects.
    Demo Video: Translation Tool

    Client Monitor Analyzer
    Show the client monitor data in a datagrid and zoom in to the executed code.
    Demo Video: Client Monitor Analyzer

    Edit Table Data
    Change your data without validation.
    Demo Video: Edit Table Data

    Get the advanced version at http://www.idyn.nl/objectmanager

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

    Discuss this download here.
  • nyambayarnyambayar Member Posts: 2
    Hello guys,
    I have a database. The database includes one company, and its size about 16 GB.
    some Database config are:
    collation: SQL collation,
    validate collation: yes
    and the database hase about 500 extra objects.

    i wanted to renumber that objects using OM Light v4.04. I imported part of the object list to "OM - Object to Renumber" table using a data port. i renumbered the objects and it was working fine. Then i closed the C/SIDE client and just then trying to reconnect to the db. But i encountered an nav application crash error. That crash window is dispayled when i'm trying to select the company. Not displayed when connecting to the db.


    does have anyone any idea? How can i solve the problem?

    thanks.
  • reijermolenaarreijermolenaar Member Posts: 256
    Hi Nyambayar,

    Can you still open the Object Designer?
    If so, can you please try to compile all objects?

    Regards,
    Reijer Molenaar
    Object Manager
  • nyambayarnyambayar Member Posts: 2
    hi reijermolenaar, thank you for your reply.

    Yes, I can open object designer. I compiled as you suggest then all objects is compiled fine expext the code unit "OM - Common dialog" (91824).But i still can't choose the company. :?:

    Crash window description is:
    Problem signature:
    Problem Event Name: APPCRASH
    Application Name: finsql.exe
    Application Version: 5.0.24199.0
    Application Timestamp: 45e564a3
    Fault Module Name: finsql.exe
    Fault Module Version: 5.0.24199.0
    Fault Module Timestamp: 45e564a3
    Exception Code: c0000005
    Exception Offset: 00120933
    OS Version: 6.0.6002.2.2.0.768.3
    Locale ID: 1033

    Additional information about the problem:
    LCID: 1033

    Regards,
  • lyotlyot Member Posts: 202
    Hi,

    I had some questions about the first tab pane in the setup card.

    Open Form at F12
    Here I filled in the number of the OM - Object Explorer form, but when I press F12 nothing happens.

    Main menu Form No
    Here I also filled in my OM - Object Explorer...

    Auto Open Main menu
    My main menu form is not opened autom. when I open the database.

    Are these bugs?
    Am I doing something wrong?
    Is this part of the advanced version?

    I've been using the 5 & 2009 objects.
  • reijermolenaarreijermolenaar Member Posts: 256
    Hi Lyot,

    You can read about it in the manual. Please look at chapter “6.2. Auto Open Object Explorer at F12”.

    The “Main Menu Form No.” is an old 3.7 option. I don’t think you will need this in a NAV5 database The form you enter here will open if you open the Object Explorer.
    Reijer Molenaar
    Object Manager
Sign In or Register to comment.