[M-Connector V2] Result Table Guide

Introduction

This guide explains how to extract analysis results from MIDAS CIVIL NX directly into Excel. The Result Table feature is a powerful tool for automating structural calculation reports and post-processing tasks.

1. Prerequisites for Result Extraction

Before starting, ensure the following conditions are met:

• Analysis Completed: The MIDAS CIVIL NX model must have a finished analysis (Post-Processing Mode) to generate results.
• API Connection: Ensure your MAPI-Key is active and the connection between Excel and MIDAS CIVIL NX is established (Refer to Quick Start Guide 1).

• Analysis Results: To extract analysis results (Displacements, Forces, etc.), the analysis must be completed in MIDAS CIVIL NX first. Use the specific "Result Table" menu for these tasks.

• Advanced JSON Input: For flexible API usage or complex filtering, users can either directly enter the JSON body or convert table settings to JSON format via the UI.

Please refer to this example:

Import Result Table from MIDAS NX

Quickly retrieve modeling information from MIDAS CIVIL NX into Excel for review or bulk editing.

• Import example tables: Beam Force, Displacement

Step-by-Step:

1. Access the DB Manager via the M-Connector ribbon menu.

   

2. Complete the login and MAPI-Key authentication.

3. Create a Folder: Create a new folder and rename it (e.g., "BeamForce").

   

4. Add a result table: Select Result type and specific type. The table name will be created automatically; however, if you want to create the same type with a different header table, you need to change the name manually.

   

5. Add a result table: the user can extract only the needed data by sorting. The data sorting items will be changed based on the result tables.

   

6. Designate the table start cell and folder. Once you set it up and save it, you can update all tables with one click (Import all).

   

   

Data Import & JSON Integration

Once your configuration is saved:

1. Import All: Click the "Import All" button. The data will be retrieved from MIDAS CIVIL NX and automatically entered into your designated Excel cells.
2. JSON Body (Advanced):
   • The UI settings are automatically converted into a JSON body.

   • Advanced users can directly edit the JSON code to apply complex Query options or filters for more flexible data management.