(API) Extraction of Loads into Excel

[Anonymous]

Hi All,

I need to extract the applied loads on each bar into an excel spreadsheet from a very complex model... I know that the load table displays this information but it unfortunately groups the bars which makes it very hard for me to extract infromation from discrete elements. Is there an API script or something for this?

i would ideally have something in the format shown below :

Load Case, Bar Number (not grouped) , Uniform Load, Px, Py, Pz, Mx, My, Mz 

Does something like this already exist?

Thanks 

Kyp 

[Rafal.Gaweda · Accepted solution]

Check it.

Note : you should get to know what is displayed in each column for different load record types to understand this table

[Anonymous]

Thanks Rafal, this works nicely

[Anonymous]

Hi @Rafal.Gaweda

Thank you for sharing this excel.

It would be really helpful if you can clarify more about the what is been displayed in each and every column.

Thanks

Saurav

[bos3UYUJ]

Hi Saurav,

I can't find any documentation, but from a trial and error process, I have determined what 13/15 of the columns in Rafal's spreadsheet are. Please see the photo below:

Kind regards,

[Stephane.kapetanovic]

hi @bos3UYUJ 

the column title depends on the type of load (IRobotLoadRecordType.___).

The code returns in each column different values corresponding to the enumeration of the type of load concerned from 0 and up to 15. If the index does not exist in the enumeration, the GetValue function returns probably an empty string.
Example values:
{IRobotBarUniformRecordValues.xxx, IRobotBarTrapezoidaleRecordValues.xxx,
IRobot ____ ______ RecordValues.xxx}

the name of the enumerations start with "IRobot" followed by the type of object (Node, Bar, etc), the description of the load and finish by "RecordValues"

You can view the correspondence in the RobotOM object library accessible from the Object Explorer (F2) of the VBA editor.

Best regards

[bos3UYUJ]

Hi @Stephane.kapetanovic ,

Thank you for the reply, I have now found the correspondence in the Robot OM and from that I have found the enumeration index values for each load type.

For each load type, they have an individual type number. I have found the majority of these in the Robot OM documentation, however, there are some type numbers which are available in Robot which I cannot find in the Robot OM object browser. These are records types: 75 (Loads due to beam prestress), 89 (Body forces), 90 (Centrifugal and angular acceleration forces), 120 ((FE) wind pressure).

I would also like to know the load type name which corresponds to the number type and can be input into the "Table edition" tab of the "Loads" tab. Do you know where to find these?

Many thanks,