This article introduces the new features for CIVIL NX and MS Excel. MIDAS Connector is a tool that allows you to transfer data in CIVIL NX or MS Excel in an efficient way. In the beginning, MIDAS Connector has a data importer feature to bring results data from CIVIL NX to MS Excel.
Contents here,
Result Table
Overview
The Result Table feature imports table results from CIVIL NX into a cell. The feature provides two options to import data. You can make data sets and import them at once. If the table results change in CIVIL NX, the user needs only to click the update button to import new data without any changes to the data sets.
The basic procedure is
1) Generate a Dynamic Report Table item in CIVIL NX.
2) Select a cell where the data will be imported.
3) Select an Import Type.
4) Select an item on the list or enter the data.
5) Select a folder to make a dataset or create a new one.
6) Import the data to the Excel sheet.
7) If any changes occur in the model, click the import button to update.
Before getting started, you need to read the article "Getting Started". MIDAS Connector and CIVIL NX must be opened to follow the instructions below.
How to use it
Settings in a model file
The Result Table feature can import results data from CIVIL NX. You need to generate a Dynamic Report Table item before importing data. Follow the below steps.
1) Open a results table. e.g) Beam Forces/Moments Result Table
2) Right-click on the table.
3) Click the "Dynamic Report Table".
4) Check on components and click the OK button.
5) You can find the saved dynamic report table on the Report tab of the Tree Menu.
Fig. Dynamic Report Table
Using Result Table
Move onto the MIDAS Connector and open the Result Table feature. Follow the steps below to import data.
1) Select a cell as a reference position. MIDAS Connector displays the name of a selected sheet and cell.
Fig. Selecting a cell
2) Select the Select type for the Import Type.
Fig. Import Type
3) Click the blank in the box and enter the name. After that, click the plus button to add a folder. If there are existing folders, you can select one among them.
Fig. Folder
4) Click the "Add To Folder" button. The selected data will be added to the folder.
Fig. Add To Folder
5) To import data to the cell, click the "All Table Import & Update" button.
Fig. All Table Import & Update
Note
You can import data as a unit of data or a folder unit. Just click on the option button of an item. The option provides 3 features(Run, Modify, and Delete)
Fig. Run, Modify and Delete
Query Type in Import Type
The query type allows you to import data with JSON code. The manual for the JSON command is being prepared.
Fig. Query type