Importing Data as a Force Load

Altair Forum User
Altair Forum User
Altair Employee
edited October 2020 in Community Q&A

Hi,

 

I had a question concerning the integration of an array from Excel (or for that matter, any type of data where it is a string of numbers) into a boundary condition loading in HyperMesh. I have two arrays of length 126; is there any way to apply them to each of my 126 selected nodes in my HyperMesh model (it is composed of 2-D shell elements)? I've attached a picture of a section of the arc if that helps. I am trying to divide up a normal load over an arc into horizontal and vertical forces efficiently and quickly. If anyone has any suggestions, that would be greatly appreciated. Thanks!

 

Dylan Stelzer

<?xml version="1.0" encoding="UTF-8"?>post-35838-0-92941000-1439217282_thumb.p

Tagged:

Answers

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited August 2015

    Maybe you need write a TCL script to read your Excel data and assign them to node group within Hypermesh.

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited August 2015

    I'll google 'how to' on the TCL script part, that doesn't sound too hard but where do I make the jump from reading Excel data to assigning them...I know there are only a few ways of assigning (specifically for me, I need it to be a force): components, vector, equation, linear interpolation, etc. etc.

     

    Thanks for replying though!

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited August 2015

    TCL has some library to read XLS/CSV files.

    Have a look at following functions:


    *loadcreate
    *loadcreateonentitywithvars
    *loadcreateonentity
    *loadcreateonentity_curve
    *loadcreatewithsystem
    *loadcreatewithsystemonentity
    *loadcreatewithsystemonentitywithvars

    Here's work flow:

    1. Read data from XLS or CSV file
    2. Create new load collector (with *createentity(loadcols,name=....))
    3. Select some nodes (with *createmark ....)
    4. Apply load on selected nodes by using one of above functions.

    HTH,

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited August 2015

    I'll give it my best shot. Hopefully I can figure it out because doing it one by one is driving me mad! Thanks again.

     

    Dylan Stelzer

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited August 2015

    I tried your method and did some research but still haven't had any luck for a few days now. I think I'll make a more detailed post and see if I can get any more specific information on where I'm running into problems. The tough part is that I've never even dealt with Tcl scripts before so I'm wondering in foreign land here. Thanks for your help though!

     

    Dylan Stelzer

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited March 2018

    I tried your method and did some research but still haven't had any luck for a few days now. I think I'll make a more detailed post and see if I can get any more specific information on where I'm running into problems. The tough part is that I've never even dealt with Tcl scripts before so I'm wondering in foreign land here. Thanks for your help though!

     

     

     

     

    Dylan Stelzer

     

    Hi @Dylan Stelzer,

     

    Sorry to reopen this forum after 3 years. but I'm wondering if you've figured out the TCL script for the task above, as I'm trying to do something similar with pressures.

    Cheers