[Kcm155]

Hello ;

currently , i have some projects with ANSA, and i am trying to automate some operations using python,
I wonder if you have some free script that I can use to fit my needs,
and I'll be grateful if you have a script which can read coordinate from an xlsx file and generates SPRING (im working with Deck>PAMCRASH)

you can find below the current script, till now i have succeeded to:
- read & create POINTS from (csv) file
- create NODES and SPRINGS from those nodes
but i can't find the link between the two parts ( i need to convert the POINTS from csv file to NODES or Create PRINGS from POINTS directly)

import ansa
from ansa import *

def main():
# import csv file and create POINTS
file = 'C:/Users/ejjed/Desktop/Scripting/Test.csv'
list_points = ansa.base.ImportCSVFileCreatePoints( file )

# create set-NODES
vals = {'Name':'new set'}
set = base.CreateEntity(constants.NASTRAN, "SET", vals)

# create NODES
nodes_list = []
for i in range(5):
vals = { "X": i*50, "Y": i*50, "Z": i*50 }
n = base.CreateEntity(constants.PAMCRASH, "NODE",vals)
base.AddToSet(set, nodes_list)

# create SPRING from NODES
vals_property = {"IDPRT":111, "Name": "new property"}
property =base.CreateEntity(constants.PAMCRASH,"PART_SPRING ",vals_property)
vals_element = {"M":1,"IPART":111,"N1":1,"N2":5,}
SpringEle = base.CreateEntity(constants.PAMCRASH, "SPRING",vals_element)

cordially

[Kcm155]

hello,
is anybody here!

[Monster20089]

can you show me form of your csv file, maybe i can help you

[Kcm155]

Originally Posted by Monster20089

can you show me form of your csv file, maybe i can help you

Hello Monster20089,
thank you for your reply
I have already found a solution for this problem

thanks