Excel file for copying list settings
Product line
Standard
|Expert
Operating mode
CLOUD ABO
|ON-PREMISES
Modules
Services & CRM
Budget & Phases
Purchases
Resource Planning
Business Intelligence
This Excel file allows you to:
Note: It is very important to be very careful about what is transferred. If list settings are transferred to folders where they are not suitable, Vertec can crash.
Vertec version |
Special features of version | Excel file |
---|---|---|
Versions before Vertec 6.2 | Listeneinstellungen_kopieren.xlt | |
From Vertec 6.2 | The following attributes no longer exist: FontName, FontSize, FontStyle, Representation, TitleColor, TitleFontColor, TitleFontColor, TitleFontName, TitleFontSize. The control XML is applied. | Listeneinstellungen_kopieren_62.xltm |
From Vertec 6.4 | Also takes into account the native language of the title, see article MLStrings . | Listeneinstellungen_kopieren_64.xltm |
In Vertec, select the container (folder or link container such as owned projects), from which you want to copy the list settings.
Double-click the Excel file and click on the button Scan in list settings???. A new worksheet is created with the name of the Vertec container. The values are scanned into the list settings list.
Note: If the message No list settings exist appears???, the container was previously reset in Vertec (List settings > Reset). In this case, open the list settings in Vertec once via the List settings button and close them again. After that, scanning should work.
In Vertec, select the container (folder or link container such as owned projects), to which you want to transfer the list settings, or the folder to whose subfolder you want to transfer the list settings.
In Excel, select the appropriate worksheet. Make sure that the settings match (for example, that you don’t transfer list settings for addresses to projects).
If necessary, individual parameters can be changed in Excel before you transfer them.
If everything is as desired, click on one of the following buttons:
The list settings of the current worksheet are transferred to the current container in Vertec.
The list settings of the current worksheet are transferred to all subfolders of the current folder in Vertec.
In Vertec, you need to re-select the container/folder after the transfer for the customization to be visible.
When transferring the list settings, there is no validation check to see if the list settings match the current container/folder. If you accidentally copy the wrong list settings, you can reset the list to its default settings. You can also execute this function if Vertec is showing error messages. Just click on this button and restart Vertec.
This allows you to show/hide / turn on and off??? the row with the asterisk to enter new entries. Please note that it is not possible to enter new entries in all lists. In such cases, you should turn off/hide??? the entry row.
Note: If the message No list settings exist appears, the container was previously reset in Vertec (List settings > Reset). In this case, open the list settings in Vertec once via the List settings button and close them again. After that, scanning should work.
This allows you to define whether the displayed list can be edited in principle. In the list settings, it is then manually defined which individual fields can be edited and which are read-only.
Note: If the message No list settings exist appears, the container was previously reset in Vertec (List settings > Reset). In this case, open the list settings in Vertec once via the List settings button and close them again. After that, scanning should work.