Skip to main content
Excel Connector Online Manual Created Edited

[M-Connector V2] Baisc FAQ & TIP

FAQ

Q1. Do I need to know about API? When do I use M-Connector?

A: “No”. If you know, you can use it more comfortably, but this is not an essential requirement. I highly recommend importing your MIDAS NX file into Excel; I believe it won’t take long to understand the table format.

 

Q2. I receive an "Invalid MAPI-Key" error. How can I fix this?

A: The MAPI-Key is uniquely generated for each session or project. Go to MIDAS CIVIL NX > Apps > API > API Setting, verify that the API is active, refresh and copy the key again. Ensure the key in Excel matches the one currently displayed in MIDAS CIVIL NX.

Issue a new MAPI-Key from MIDAS NX

 

Q3. I clicked "Export All," but no data appears in MIDAS CIVIL NX.

A: Please check two things:

  1. Check the M-Connector Status on the panel; it should be green.
  2. Ensure MIDAS CIVIL NX is open and ready to receive data (not busy with a calculation).
  3. Verify that you haven't modified the Header names or structure in the Excel sheet. The API relies on specific header strings to correctly map the data.

 

Q4. What happens to existing data when I export from Excel?

A: The M-Connector uses ID-based synchronization. If an ID (Node ID, Element ID, etc.) already exists in the model, the software will overwrite/update the existing data. If the ID is new, it will create a new entity.

Q5. The Result Table is imported as blank cells. What is wrong?

A: Result extraction requires the model to be in Post-Processing Mode. Ensure the analysis is complete and that the result files are present in the project folder.


Pro-Tips for Power Users

 

1. The "Logic of Order" (Node First!)

When building a model from scratch via Export, always follow the structural hierarchy: Node > Material > Section > Element > Boundary/Load.
An Element cannot be created without its reference Nodes already existing in the MIDAS model.

 

2. Standardization via "Create Table"

To avoid formatting errors, always use the [Create Table] button rather than manually typing headers. This ensures the unit systems and data types match the API requirements perfectly, and it provides helpful Header Notes for guidance.

 

3. Seamless Report Automation

Link your "Result Table" sheets to your final calculation or report template using Excel cell references. Once linked, a single click of the Update button in M-Connector will refresh all numbers, charts, and tables in your report simultaneously after a model change.

0
Was this article helpful?