Renaming an Object ID

tmnavisiontmnavision Member Posts: 2
Hi,

I would like to know how will I re-arrange the object id's in a safe and easy way. There are so many object id but how can i make sure that when I re-arrange the object id's the one calling them like in the menu won't be affected. 8-[

I hope somebody can help me. :P

Comments

  • bostjanlbostjanl Member Posts: 107
    tmnavision wrote:
    Hi,

    I would like to know how will I re-arrange the object id's in a safe and easy way. There are so many object id but how can i make sure that when I re-arrange the object id's the one calling them like in the menu won't be affected. 8-[

    I hope somebody can help me. :P

    Navision has Renumbering tool. I used it several times and it worked great.


    Bostjanl
  • bostjanlbostjanl Member Posts: 107
    bostjanl wrote:
    tmnavision wrote:
    Hi,

    I would like to know how will I re-arrange the object id's in a safe and easy way. There are so many object id but how can i make sure that when I re-arrange the object id's the one calling them like in the menu won't be affected. 8-[

    I hope somebody can help me. :P

    Navision has Renumbering tool. I used it several times and it worked great.


    Bostjanl

    And link to download it from Mibuso download section http://www.mibuso.com/dlinfo.asp?FileID=263

    BostjanL
  • JedrzejTJedrzejT Member Posts: 267
    You should use Compare&Renumbering tool for that
    http://www.mibuso.com/dlinfo.asp?FileID=263

    Unfortunately this tool not renumber menusuite. You have to do it yourself


    Regards
  • jreynoldsjreynolds Member Posts: 175
    Depending on what objects you are renumbering you may have to consider renumbering the data as well.

    For example, table 2000000005 (Permission) has an "Object ID" field containing the object number of objects with permissions assigned to the various roles. If you have assigned permissions to some of the objects that you are renumbering then you will have to renumber the data in this field as well.
  • DenSterDenSter Member Posts: 8,307
    I don't know if you are planning anything like this, but I just want to mention that the only area where you should even consider renumbering is the custom objet ranges. You should leave the numbering of the core Navision objects alone.
  • buchhotbuchhot Member Posts: 116
    Hi 'ya all!

    I have to renumber fields in a table (at the customer range > 50000, not a table of the basis).

    I know I have to do it manually: create a new column, copy vaues from the old column, delete old values and delete old column.

    The problem is, that I do not know every object where this field is referenced to (with the old fieldnumber). So I have to test and fix the errors as they come.

    Is there any possibility to get the objects which reference to a certain table-column?

    Many thanks in advance,
    have a nice day
    Thomas Buchholz
    ekey biometric systems GmbH
    4031 Linz
    Austria
    web: http://www.ekey.net
  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    There was a renumer tool once...

    I usualy export the whole database to one big textfile and do the renumbering.

    You can check the fields using the Development Toolkit
Sign In or Register to comment.