Object renumbering tools...

radek.bbradek.bb Member Posts: 49
Hi,

I have found two tools to run renumbering objects:
- Compare/Renumbering Tool from 1996 placed in 102150-102165 object range - I think it is part of official Navision tools
- Renumber Objects & Fields - I have it in 99000 object range - so I am guessing that it is partner solution

But there are two issues:
- Neither of them is up-to-date (supporting Pages)
- Second tool is super-extra slow (I am renumbering TXT file of 175MB containing over 8,000 objects of which over 4,000 are changing ID) - it reached 25% after 20 hours (while first one finished same process in 10 min).

So the questions are:
Is there any never version of Compare/Renumbering Tool than W12.50 (report 102150)? (since this is much faster solution I would prefer to stick to this one)
Or maybe some partner updates/corrections?
Some other tools you can recommend?

Answers

  • lvanvugtlvanvugt Member Posts: 774
    * Merge Tool
    * Object Manager
    Luc van Vugt, fluxxus.nl
    Never stop learning
    Van Vugt's dynamiXs
    Dutch Dynamics Community
  • radek.bbradek.bb Member Posts: 49
    Something simple (less than 10 NAV objects)...
    I don't want to reinstall my whole PC just to runt this renumbering once 8)
  • cernstcernst Member Posts: 280
    _____________________
    NAV Freelance Consultant
  • radek.bbradek.bb Member Posts: 49
    Thanks... but once again - my renumbering is probably a bitt too much for this little one ;)
    Considering the fact that no output file has been created after over an hour of running it - I understand that it loads everything into memory and than do some replacements...
    Like I said earlier my TXT file is 175MB - so playing with this in memory is not very wise idea.
    Not mentioning the fact that in mapping file I had
    Table12345=67890000
    
    But in command prompt I saw something like:
    Table 12345 renumbered 12345000000000000000000000000
    
    Well - anyway - I think I will just improve old Navision solution as the code looks quite simple with an open architecture allowing to add new object types...
  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    radek.bb wrote:
    - Renumber Objects & Fields - I have it in 99000 object range - so I am guessing that it is partner solution ?

    This one in MINE :)

    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • radek.bbradek.bb Member Posts: 49
    so... 80h (eighty hours) to get the same results which the other tool gives within 4min (four minutes)...
    I would not be so eager to sign myself under this slower one 8) :lol: \:D/
  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    It has a hardcoded check for certain user names and adds some delays here and there.. Otherwise you woudn't appreciate it :)

    But seriously - sent me exported text version to my private email and I'll have a look.. I've used it many times for batches having 400+ objects (like Time Recording & Billing module + things using it for example) and it was never running longer than few minutes..
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
Sign In or Register to comment.