Upgrade NAVISION 3.70 to 4.00 SP1

geosava
geosava Member Posts: 10
edited 2006-03-17 in NAV/Navision Classic Client
Hi to all of you.

I have read the upgrade toolkit manual and the Develepers Toolkit pdf (DevTool 2 + SP2).

I have followed the upgrade process till the step 7 of the upgrade quick reference.

I have used the developers toolkit to do the Compare and merge process i have succesfully manualy checked any conflict objects and exported all the objects into a txt.

The problem is that i can not import them into the database where i have run the update process and have delete all the objects except the tables.

It is a lisence problem. But i have already a developers license. What license i need to import all the objects into that database?? :?: :?:

:D:D

Comments

  • kriki
    kriki Member, Moderator Posts: 9,127
    Import first all standard Navision 4.0SP1 objects (except tables) and then import the textfile.
    When you import a textfile, Navision considers it an insert of the object and the objects in the standard Navision range can be changed and deleted but not inserted. If the object already exists, the import of an object in text-format is considered a modify and this is allowed.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • geosava
    geosava Member Posts: 10
    Hi again Kriki thanxs for the answer.

    I have already thought of that but if i import the txt file of the new version into the database it will also try to create fields in the tables which were not existed in the old version and again will not let me import the file with my current license. :(

    Any other suggestion?
    #-o
  • bobnavision
    bobnavision Member Posts: 159
    Have you run the process of deletion / transferring of data to temporary tables ?
  • geosava
    geosava Member Posts: 10
    Yes i have.... :!:
  • Kowa
    Kowa Member Posts: 926
    geosava wrote:
    I have already thought of that but if i import the txt file of the new version into the database it will also try to create fields in the tables which were not existed in the old version and again will not let me import the file with my current license. :(
    To add new fields in the standard range you have to import the new object as a *.fob file first, leaving the "merge existing -new" default option in the import worksheet, but remove all of the code before importing. Then export the table as text , and use a compare tool to merge the code wtih the new version and import the resulting textfile containing the merged code.
    Kai Kowalewski
  • jazzyjess
    jazzyjess Member Posts: 54
    if you have not found the solution to this yet. I think there's one missing step you did not do.
    When you get the final result of your text file from your Compare and Merge process (the result of your manual merge), you need to do this.

    Lets call your text file FinalResult.Txt

    1) Create a new blank database using 4.0 (or 4.0SP1 or whatever new client)
    2) Restore the backup of the Cronus database into it.
    3) Now you have created a new database with all the latest 4.0 new tables and fields that you do not have permission to because they belong to Navision)
    4) Import your FinalResult.Txt
    (you should not have license problem here because all the standard Navision tables and fields are already there)
    5) When you are done with your import, select all the objects and EXPORT them again. This time export them into one a fob file called OBJECT.FOB

    6) This OBJECT.FOB will contain both the new objects of 4.0 Standards and your customized objects from the old version.

    7) When you do the import following STEP 8 of the Quick Guide, this OBJECT.FOB file is the one you want to import. NOT the FinalResult.Txt directly from the C& M result of Developer Toolkit.

    Hope this help.

    JJ

Categories