The “Layer” customization dialog works well for checking layer settings and making minor adjustments. It can be cumbersome if you need to make lots of changes to your layers. We have two buttons, “Import Layers from Excel” and “Export Layers from Excel”, that you can use in this situation. These buttons can be found in the “DM->Customization->Layers” command.
First, use the “Export Layers to Excel” button. This will create the file you can modify in Excel. You can either modify the layer system you want to modify if you want to make changes to it, or you can export a different layer system that you want to use as the starting point for the layers in a different layer system.
After you run this command, the file will automatically be opened in Excel. Make the necessary changes to the layers.
The first three lines are file headers that should not be modified. The first column is the “Layer Key”, which corresponds with the “Layer Key” grid on the top-right side of the “Layers” dialog. This column should not be modified. The last column is labeled “DO NOT EDIT” and should not be edited. It is used by Design Master to during the import process to transfer layer settings correctly.
When you are finished editing the file, save it. Excel will display a number of warnings, asking if you really want to save the file. Say “Yes” to all of these prompts.
Then, use the “Import Layers from Excel” button. This button will import the selected file to the currently selected layer system. You can either overwrite the layer system that was originally used to create the file, or you can overwrite a different layer system.