There was another post that asked about the Excel tool, but i'd like to ask it again, but a little differently. I use the Excel tool to export and import mass changes from/to Mega, and it works well for attributes on a single MetaClass. However, I also have the need to export and import various MetaAssocations between two MetaClasses. Does anyone have a mechanism for doing this? Before I go off and write a script to do this, I wanted to find out how others are doing this. This would save us countless hours writing specialized import scripts or manually making connections. Yes, I have tried matrices, but they do not preserve the _HexaIDAbs and use Short Name, which makes the import difficult. My idea for doing this is to write an Excel script that is combination of the Excel tool and Matrices: 1) Manually put the _HexaIDAbs property of the MetaAssociation in cell A1. The script could prompt for the MetaAssociation. -- The rest of the steps could be handled by the script for all objects or a query to select the objects. -- 2) In A3:An, put the long name of objects on one end of the MetaAssociation. 3) In B3:Bn, put the objects' _HexaIDAbs property 4) In C1:xx1, put long name of objects on the other end of the MetaAssociation. 5) In C2:xx2, put the objects' _HexaIDAbs property 6) in each intersecting cell, put an 'X' if the MetaAssociation exists. On Export, it would value it from the respository. On Import, it would disconnect the blanks and connect the X's. Alternately, like in Matrices, the script could prompt for a MetaAttribute to put in the cell instead and store the _HexAIDAbs in B2. This Excel sheet could be exported from Mega, modified,and imported later. Thoughts?
... View more