(API) Planar on contour - Text edition

[Anonymous]

Hi,

I would like to import a load table from Excel to Robot. This table is composed of  planar loads with contour.

However, in the Table Edition tab, contour definition can't be indicated automatically. We must define the coutour thanks to the user form:  

So I decided to create a database under Excel witch could be exported to the text edition tab, where the coutour can be directly indicated in the column load values:

The problem is that I don't know the correct syntax to adopt on Excel in order to import the table.

Sorry if this problem has already been resolved.

Thank you,

Erwann  

[Rafal.Gaweda]

I am afriad it can be done only by macro \ API

See attached example xlses

[Anonymous]

Well, i've used your examples to export my loads by macro.

However, in my case, Robot doesn't recognize these loads.

Indeed, for example, here are forces generated automatically when I create my planar load on Robot load table.

   

And here are the same forces generated automatically when I import them from Excel thantks to macro. The caracteristics of the two planar loads on the load table are the same... 

Do you know what the problem is due to?

[Rafal.Gaweda]

What is the problem? Scale of load symbol?
Check sum of reactions for these cases.

[Anonymous]

Reactions tabs of my two cases are different too.

Here is the sum of reactions when I create my  load directly on Robot (which matches with what it should be). 

Here is the sum of reactions when I import the same load from Excel (macro).

And I don't know at all what 429.90 refers to...

[Anonymous]

I've created an easier example: a 5mx5m planel with an unique load case.

I've imported a planar load on contour, and when I began the calculations, Autodesk sent me a warning... 

 

How can the contour load be incorrect? Here is the geometry of my planel and the geometry of my load...

[Rafal.Gaweda]

File please.

[Anonymous]

Do it this evening.

Computers at work are blocking that...

[Anonymous]

Here they are!!

[Anonymous]

Ok, I've understood where the problem came from:

In the macro you sent to me, I've added a line.

     Do While row <= Lastrow
       
        If (Cells(row, 1) <> "") Then
           
            ROSelection.FromText Str(Cells(row, 2))
            ROSelection.Exclude RBSelection
            ROSelection.Exclude RGSelection
           
            Set Simplecase = CaseServer.Get(CInt(Cells(row, 1)))
            Set rec_1 = Simplecase.Records.Create(I_LRT_IN_CONTOUR)
            rec_1.Objects.FromText Str(Cells(row, 2))
            rec_1.SetValue I_ICRV_PX1, CDbl(Cells(row, 3)) * 1000
            rec_1.SetValue I_ICRV_PY1, CDbl(Cells(row, 4)) * 1000
            rec_1.SetValue I_ICRV_PZ1, CDbl(Cells(row, 5)) * 1000
            rec_1.SetValue I_ICRV_NPOINTS, Int(Cells(row, 6))
            rec_1.SetVector 0, 0, 1
            rec_1.SetContourPoint 1, CDbl(Cells(row, 7)), CDbl(Cells(row, 8)), CDbl(Cells(row, 9))
            row = row + 1
        Else
            For K = 2 To rec_1.GetValue(I_ICRV_NPOINTS)
                rec_1.SetContourPoint K, CDbl(Cells(row, 7)), CDbl(Cells(row, 8)), CDbl(Cells(row, 9))
                row = row + 1
            Next K
        End If
    Loop
End Sub

And now, it works 😉

Thank you for your help.

Best regards,

Erwann

[Rafal.Gaweda]

Perfect 🙂

[Anonymous]

Same problem  [Incorrect definition of contour load for the load case 5.Panel no. 5 ]

Code :

'CHARGE SURFACIQUE contour
Set Charge_5 = RobApp.Project.Structure.Cases.CreateSimple(5, "Charge verticale surfacique sur contour", I_CN_PERMANENT, I_CAT_STATIC_LINEAR)
Su_TR = Charge_5.Records.New(I_LRT_IN_CONTOUR)

Set loadrecord = Charge_5.Records.Get(Su_TR)

loadrecord.Objects.FromText ("5")

loadrecord.SetValue I_ICRV_PX1, 0
loadrecord.SetValue I_ICRV_PY1, 0
loadrecord.SetValue I_ICRV_PZ1, -10000

loadrecord.SetValue I_ICRV_NPOINTS, 5

loadrecord.SetVector 0, 0, 1

loadrecord.SetContourPoint 1, -6.75, -9.3, 0
loadrecord.SetContourPoint 2, 6.75, -9.3, 0
loadrecord.SetContourPoint 3, 6.75, 9.3, 0
loadrecord.SetContourPoint 4, -6.75, 9.3, 0
loadrecord.SetContourPoint 5, -6.75, -9.3, 0

[Rafal.Gaweda]

Hi @Anonymous 

Compare Your code with my examples above

I guess You should use loadrecord.SetValue I_ICRV_NPOINTS, 4 and define 4 points only

[Anonymous]

Much thanks @Rafal.Gaweda