<< Click to Display Table of Contents >> Navigation:  Supervisor utilities > Rename > Rename table codes

With this option in the Maintenance menu, table codes can be renamed.

 

The table and code are chosen from a list. Then enter the new code.

If the new code already exists, the system asks if the two codes should be merged. The old code is deleted from the system.

When a code is changed or deleted, the whole database needs to be gone through. This may take some time.

 

Table codes can also be imported from an excel file.

 

Please note! This function does not apply to encrypted data.

 

Process in batch

The rename-function can also be started from a batch file with:

Mill7 Maatwerk /Rename_Tab {administration directory} {table number} {old code} {new code} [{new description}]

If the new code already exists, codes will be merged. The last parameter is optional.

 

Example batch:

 

F:

CD \Mill7\Prog20

.\Maatwerk.exe /Rename_Tab B0003201 108 ENG GB

.\Maatwerk.exe /Rename_Tab B0003201 108 NED NL Netherlands

 

Country code ENG will be changed, everywhere in the database, to GB.

 

Renaming codes in batch has two extra possibilities:

1.Optional is to change the description. The description for the new table code will be changed to the value entered.

2.If the old and the new code are similar and do not exist, the code will be created with the given description:

3.\Maatwerk.exe /Rename_Tab B0003201 108 NL NL Netherlands*

 

The file Rename_Tablog.txt is created in the data directory. Check this file for errors that may have occurred.

 

Important: Always make a backup first before executing this batch file. Also check the data before releasing it.