You can export schema data from Schema Editor to Microsoft Excel to make changes. You can import the edited schema from Excel to Schema Editor.
The following data can be exported to Excel:
-
Any schema displayed in a tabular view
-
Pseudo file configuration (CMF)
-
Schema container (XML file or CMF active configuration)
Schema Editor does not support exporting tool map schema to Microsoft Excel for modifications and importing back.
File Generated by Export Commands
For every container, pseudo file configuration, or view that is exported, two files will be generated:
-
.xlsm file – Excel file containing the exported objects
-
.UIDs file – Text file containing the UID for every object and relationship that is exported