mibuso.com
Home› Download section

NAV Object Compare

AdministratorAdministrator Member, Moderator, Administrator Posts: 2,500
edited 2012-08-30 in Download section
NAV Object Compare
This tool will help you to compare and merge objects from different databases.

Before using the tool you need to open to Navision Clients and point them to the databases you want to compare.

After having filled the path of your preferred tool to compare txt files (compare software path), and pointed to the two databases press COMPARE and the software you selected will open up with the two objects already extracted as text files.
Now you can merge one into the other save and close the program, you can now import and compile the merged file back into the Database.
Enjoy!

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

Discuss this download here.
«1

Comments

  • AdministratorAdministrator Member, Moderator, Administrator Posts: 2,500
    NAV Object Compare
    This tool will help you to compare and merge objects from different databases.

    Before using the tool you need to open to Navision Clients and point them to the databases you want to compare.

    After having filled the path of your preferred tool to compare txt files (compare software path), and pointed to the two databases press COMPARE and the software you selected will open up with the two objects already extracted as text files.
    Now you can merge one into the other save and close the program, you can now import and compile the merged file back into the Database.
    Enjoy!

    New Functionality Added:
    - New Two Buttons to Import the Compared txt file only in the selected DB.
    - Added support for NAV 2009 Page Object.
    - Added ToolTip to every button to quicly understand what every button does.

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

    Discuss this download here.
  • PureHeartPureHeart Member Posts: 190
    Hello,

    If anyone has got any suggestion to make the tool better please let me know and I'll do my best to improve it!!!

    Thanks
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • bernajacbernajac Member Posts: 20
    Very use full tool to use. I have used it during my migration process of 7 countries and it saved me lots of time. Well done! :thumbsup:
  • HanenHanen Member Posts: 281
    Hi,


    I really need to use it but I don't know how, is there a help??? I need to merge some object but I'm afraid to affect the DB it will be a catastroph :oops:

    Thanks for help!!!!!
    Regards

    Hanen TALBI
  • PureHeartPureHeart Member Posts: 190
    Hi Hanen,

    I'm afraid I didn't write any help file but what you need to do is just to open the two NAV clients you want to compare then open my tool and read the tooltip that will appear on the buttons when you hover with the mouse...
    Just try on a CRONUS before so you understand how it works....also you need to input the path of the executable you want to use for the merging...as WinMerge for example....
    Let me know if I can help you more!

    Ciao!
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • tonypangtonypang Member Posts: 101
    hello can you guide me how to use it ?
    When i press Compare button it prompt me error message
    NAV
  • PureHeartPureHeart Member Posts: 190
    Hi,

    In the "Compare Software Path" field you have to insert the path of the executable software... for example you could install this free software http://winmerge.org/ and then insert the exe path...
    In database name just put the name of the db without the path...

    let me know if you have any problems...
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • kitikkitik Member Posts: 230
    I'm having some trouble using the tool.

    When I hit the compare button, I get an error that says
    "PUIGMAJOR NAVSQL01
    The system can not find the specified file"

    It is correct, PUIGMAJOR is my secondary DB Servername, and NAVSQL01 is the database name.
    In fact if I switch the primary and the secondary DB, I get the same error with TEIDE OHSJDNAVSQL.

    Am I doing something wrong or is it a bug?


    img1.png
    img2.png
    Laura Nicolàs
    Author of the book Implementing Dynamics NAV 2013
    Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.
  • PureHeartPureHeart Member Posts: 190
    Hi Laura,

    Have you opened both databases with a NAV client?
    You need two sessions open to the specified databases.

    Cheers
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • kitikkitik Member Posts: 230
    Thanks for the quick response.

    Yes, both databases where opened.

    Salut!
    Laura Nicolàs
    Author of the book Implementing Dynamics NAV 2013
    Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.
  • PureHeartPureHeart Member Posts: 190
    Hi Laura,

    I think there is a bug in my code the problem is the lowercase name of the database... I'll fix it when I've got a moment but in the meantime you could try to change the name of the database to NAVSQL01...and let me know if it works....

    Thanks for reporting the bug!

    Ciao
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • tonypangtonypang Member Posts: 101
    When i click the Compare button the error message prompt out ?
    But i checked the text file exactly same as old version object details.

    I don't know why system prompt property unknown?


    Thanks
    NAV
  • kitikkitik Member Posts: 230
    PureHeart wrote:
    you could try to change the name of the database to NAVSQL01...and let me know if it works....

    I tried with another server, with an uppercase DB name and it works just fine.

    Another question: Does it just works with DB running under SQL, or can I use your tool with a NAV Server? What about a DB with no server?

    You asked for suggestions to improve the tool: it would be great if you could compare more than one object at the same time. Be able to say Object ID=3..23 or any other filter. Even better if you could compare multiple objects from multiple objects type at the same time.

    Salut!
    Laura Nicolàs
    Author of the book Implementing Dynamics NAV 2013
    Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.
  • tonypangtonypang Member Posts: 101
    edited 2010-12-27
    -
    NAV
  • HanenHanen Member Posts: 281
    Yes: :wink:

    FORMAT(WORKDATE,0,'<day,2>/<month,2>/<year4>')
    Regards

    Hanen TALBI
  • AdministratorAdministrator Member, Moderator, Administrator Posts: 2,500
    NAV Object Compare
    This tool will help you to compare and merge objects from different databases.

    Before using the tool you need to open to Navision Clients and point them to the databases you want to compare.

    After having filled the path of your preferred tool to compare txt files (compare software path), and pointed to the two databases press COMPARE and the software you selected will open up with the two objects already extracted as text files.
    Now you can merge one into the other save and close the program, you can now import and compile the merged file back into the Database.
    Enjoy!

    Version 5/05/2011:
    Fixed the "Object Caption Problem", when extracting an object it was using the object caption name instead of the correct object name.

    Version 20/11/2009:
    New Functionality Added:
    - New Two Buttons to Import the Compared txt file only in the selected DB.
    - Added support for NAV 2009 Page Object.
    - Added ToolTip to every button to quicly understand what every button does.

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

    Discuss this download here.
  • avataravatar Member Posts: 5
    Hello,
    This is really a helpful tool! Thanks a lot for sharing it.
    But in me environment it is not working correctly. I have two Server and two DBs. The tool settings are:

    Primary DB
    Server Name: NTNAVI5
    Database Name: cw-nav5
    Secondary DB
    Server Name: NTNAVI5B
    Database Name: cw-nav5-test
    Object Type Codeunit
    Object ID 1

    For compare, the tool is exporting two text files:
    DB1_cw-nav5_Codeunit_1.txt
    DB1_cw-nav5-test _Codeunit_1.txt
    But with the same content! :( The content is definitely different in the corresponding DBs. The content comes from the Secondary DB!
    Any Idea what I’m doing wrong?

    In a previous version, I belive it was working correctly.

    Used Systems: NAV5 SP1, XP, SQL

    Regards
  • PureHeartPureHeart Member Posts: 190
    Ok so did you try to use it with the new version?
    Was it working with the old one?
    I'll have a look and try to correct the bug...
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • PureHeartPureHeart Member Posts: 190
    avatar wrote:
    Hello,
    This is really a helpful tool! Thanks a lot for sharing it.
    But in me environment it is not working correctly. I have two Server and two DBs. The tool settings are:

    Primary DB
    Server Name: NTNAVI5
    Database Name: cw-nav5
    Secondary DB
    Server Name: NTNAVI5B
    Database Name: cw-nav5-test
    Object Type Codeunit
    Object ID 1

    For compare, the tool is exporting two text files:
    DB1_cw-nav5_Codeunit_1.txt
    DB1_cw-nav5-test _Codeunit_1.txt
    But with the same content! :( The content is definitely different in the corresponding DBs. The content comes from the Secondary DB!
    Any Idea what I’m doing wrong?

    In a previous version, I belive it was working correctly.

    Used Systems: NAV5 SP1, XP, SQL

    Regards

    I've just uploaded a new version of the tool that should fix your problem :)...it should be available next week...let me know if that solves your problem!
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • AdministratorAdministrator Member, Moderator, Administrator Posts: 2,500
    NAV Object Compare
    This tool will help you to compare and merge objects from different databases.

    Before using the tool you need to open two Navision Clients and point them to the databases you want to compare.

    After having filled the path of your preferred tool to compare txt files (compare software path), and pointed to the two databases press COMPARE and the software you selected will open up with the two objects already extracted as text files.
    Now you can merge one into the other save and close the program, you can now import and compile the merged file back into the Database.
    Enjoy!

    Version 22/07/2011:
    Updated the logic to retrieve the correct session of NAV opened, this should solve the problems with the same database name on different servers...

    Version 5/05/2011:
    Fixed the "Object Caption Problem", when extracting an object it was using the object caption name instead of the correct object name.

    Version 20/11/2009:
    New Functionality Added:
    - New Two Buttons to Import the Compared txt file only in the selected DB.
    - Added support for NAV 2009 Page Object.
    - Added ToolTip to every button to quickly understand what every button does.

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

    Discuss this download here.
  • PureHeartPureHeart Member Posts: 190
    Administrator wrote:
    NAV Object Compare
    This tool will help you to compare and merge objects from different databases.

    Before using the tool you need to open two Navision Clients and point them to the databases you want to compare.

    After having filled the path of your preferred tool to compare txt files (compare software path), and pointed to the two databases press COMPARE and the software you selected will open up with the two objects already extracted as text files.
    Now you can merge one into the other save and close the program, you can now import and compile the merged file back into the Database.
    Enjoy!

    Version 22/07/2011:
    Updated the logic to retrieve the correct session of NAV opened, this should solve the problems with the same database name on different servers...

    Version 5/05/2011:
    Fixed the "Object Caption Problem", when extracting an object it was using the object caption name instead of the correct object name.

    Version 20/11/2009:
    New Functionality Added:
    - New Two Buttons to Import the Compared txt file only in the selected DB.
    - Added support for NAV 2009 Page Object.
    - Added ToolTip to every button to quickly understand what every button does.

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

    Discuss this download here.

    Thanks!!! That was super quick!!!
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • rainergaissrainergaiss Member Posts: 43
    Can you tell me if it is really necessary to start a server because all of my development is usually done locally. And if you use a server, has it to be the "classic" server or is SQL also possible? And, is it possible to compare to objects with different numbers, e.g. Database xy Codeunit 1 with Database yx Codeunit 50001 or even Database xy Codeunit 1 with Database xy Codeunit 50001..
  • PureHeartPureHeart Member Posts: 190
    Hi,

    The tool can be used even with local c/side clients so no need of sql...just type in the database name only (with the path or without)...
    No the tool can only compare the same object on the different databases....but if I've got time I may implement the functionality 8)

    Ciao
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • rainergaissrainergaiss Member Posts: 43
    What does "Could not find an active Microsoft Dynamics NAV Connection" mean?

    I set up a server, I opened a client using the server and I entered an object. What's wrong?
  • PureHeartPureHeart Member Posts: 190
    That means it can't find an opened NAV client...send me a screenshot of the values you are using...have you opened the NAV client?
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • rainergaissrainergaiss Member Posts: 43
    Here are the three screenshots. The two clients are opened.
  • PureHeartPureHeart Member Posts: 190
    have you tried to fill only the database name and leave the server name blank?

    Also which OS are you using 32bit or 64bit?
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • rainergaissrainergaiss Member Posts: 43
    have you tried to fill only the database name and leave the server name blank?

    Doesn't work either.
    Also which OS are you using 32bit or 64bit?

    Win7 x64
  • PureHeartPureHeart Member Posts: 190
    Ok that explains it...Sorry but the tool doesn't work in 64bit :cry: you can try to start the tool from XP Mode (if you don't have a 32 bit machine)?
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • rainergaissrainergaiss Member Posts: 43
    Trying in XP mode did not help and I don't want to work with it in a virtual XP machine so I terminate my efforts at this point. Thank you for your help.

    Rainer
Sign In or Register to comment.