Different manual combination table

[Konrad.O]

WIP

A copy of the archived "Different manual combination table" topic:

https://forums.autodesk.com/t5/robot-structural-analysis-forum/editing-load-cases-in-excel-api/m-p/8... 

[Anonymous]

Yes, I can see the problem now. When I'm using load combinations as basic load cases as well as having 27+ basic load cases, the factors from load combinations get written to the same columns as the last basic load cases.

Maybe I'm asking for too much, but do you know any way to make the xls file adaptive to the number of basic load cases imported?

[Rafal.Gaweda]

Hi @Anonymous

This macro works for combinations made of simple cases only.

For example comb 1200 contains comb 1000 + simple case

[Rafal.Gaweda]

Hi @Anonymous

Finally I got your point.

Macro with no limits for simple cases and combinations (also embedded) attached.

[Anonymous]

Fantastic! This is so useful.

Thank you

[mgaafar]

Thanks, Rafal for your effort, I find this sheet very important and helpful.

If I may suggest also to make the sheet read Static-Seismic load cases in case a Seismic load case is created. it happened that I had one in a model and it didn't catch it in the import/export generation.

[danielroure2267]

Hello
It's a good macro, do you know if there is a statement to block redisplay in RSA to accelerate the transfer?
Kind regards

---

---

[Rafal.Gaweda]

Hi @danielroure2267 

Near the beginning of code add

RobApp.Interactive = 0

at the end

RobApp.Interactive = 1

[danielroure2267]

Thank you

[danielroure2267]

Hello

do you think it is possible to accelerate again?
the insert of a combination is done in 1 second; I have 80000
I found the link below but I do not know how to introduce it
is it necessary to limit the cache (ApplyCache) to a number of combinations?
is what BeginMultiOperation, (IRobotCombServer?) can be used

https://knowledge.autodesk.com/fr/support/robot-structural-analysis-products/troubleshooting/caas/sf...

thanks

[rokas_varanauskas]

This appears to have no effect on time it takes to transfer combinations from Excel to RSA. In one project we have just under 2000 combinations which is taking more than 60min to get transferred. It's a lot of time.

Any improvements would be greatly appreciated.

Rokas

[ALEXTHAINESE]

Adding label for load cases , is it poosible from excel to RSA using API?

[Rafal.Gaweda]

Hi @ALEXTHAINESE 

I am afraid it is not implemented in API.

[1234eddie]

I don't know if it's still relevant. 

But in this topic you will find a solution, thanks to rafal.

https://forums.autodesk.com/t5/robot-structural-analysis-forum/robot-load-case-labels-dynamo-api-pyt...

[JPNR87]

Hi,

does API "RMI_loadcomb_nested_with_subnatures" cooperate with RSA 2021. Im having a problem.

Thanks for answers!

[Rafal.Gaweda]

Hi @JPNR87 

Yes it does.

What is the problem?

[JPNR87]

[Rafal.Gaweda]

??????

[bos3UYUJ]

Hi @Rafal.Gaweda,

In response to your video showing you copying loads from an excel spreadsheet to the "Table edition" tab in RSA, is it possible to automate this step with a macro. At the moment I have to copy and paste the table from Excel to RSA (like you show in your video) and I would like to remove this manual process.

Many thanks

[Rafal.Gaweda]

Hi @bos3UYUJ 

I am afraid it is not possible. 

[bos3UYUJ]

No problem. Thank you for your quick reply.

Best wishes