General downloads

No-permission-to-create-a-field-workaround: Table generator

Author
Waldo  
Category
General downloads
Date
20/03/2007
Size
14,7 KB
Downloads
1397
MD5 digest
C3C7E1C018E924A9D65BD46A807210F1
Rating
321501
Popularity
Downloaded 1 time in the last two weeks

You all know the problem:
You did some customisations on a table. You want to apply a new hotfix, which adds a new field in that table. You start merging, and want to import your txt. You have no permission to add that new field from that hotfix into a table.

Here is a workaround in case this happens a lot for one hotfix/localisation/add-on/whatever:
- You create a new default NAV db (without data) with the new objects imported (import the fob in it).
- import this tablegenerator
- start form 70020
- fill in the tablefilter for all NAV tables that were changed (by the hotfix/add-on/...)
- select an empty map and press OK ... the tool creates some txt-files
- start form 70022 to create one large file
- import this file into the same database
- compile
- export the fob
- import it into the database you should import it with "merge exsisting <- New" ... your fields have been created
- overwrite the objects with your merged txt file (which gave the error in the first place

This is a tool that has been written in spare time ... so as quick as possible ... so don't be too critical about it ;)