Modify data for imported body temperature

Pernelle Marone-Hitz

I have created an Imported Load /Imported Body Temperature object in Mechanical:

I would like to modify the magnitude, analysis time, scale and offset value for this imported load, for all time steps:

The values I would like to use are placed in columns of an Excel file.

Pernelle Marone-Hitz

The following code can be adapted:

import os

import csv



# User inputs

csv_file = provide_path_to_csv

analysis = Model.Analyses[0] # change accordingly

# Columns to read in Excel file # change accordingly

magnitude_column = "J"

analysis_time_column = "A"

scale_column = "L"

offset_column = "M"


# Unique name of imported body temperature

imported_body_temp_object_name = "Imported Body Temperature" # change accordingly




# Function to convert column letter to index (A=0, B=1, etc.)

def column_letter_to_index(letter):

    return ord(letter.upper()) - ord('A')


# Convert column letters to indices

magnitude_idx = column_letter_to_index(magnitude_column)

analysis_time_idx = column_letter_to_index(analysis_time_column)

scale_idx = column_letter_to_index(scale_column)

offset_idx = column_letter_to_index(offset_column)


# Initialize the four lists

magnitude = []

analysis_time = []

scale = []

offset = []


# Read .csv file

# Check if CSV file exists

if os.path.exists(csv_file):

    # Open and read the CSV file

    with open(csv_file, 'r') as file:

        csv_reader = csv.reader(file)

        # Read each row and extract the specified columns

        for row in csv_reader:

            try:

                # Column A -> analysis_time

                if len(row) > analysis_time_idx:

                    analysis_time.append(row[analysis_time_idx])


                # Column J -> magnitude

                if len(row) > magnitude_idx:

                    magnitude.append(row[magnitude_idx])


                # Column L -> scale

                if len(row) > scale_idx:

                    scale.append(row[scale_idx])


                # Column M -> offset

                if len(row) > offset_idx:

                    offset.append(row[offset_idx])

            except IndexError:

                # Skip rows that don't have enough columns

                continue


    print("CSV file read successfully!")

    print("Number of rows processed: {0}".format(len(analysis_time)))

else:

    print("CSV file not found: {0}".format(csv_file))



# Modify imported body temperature

imported_body_temp = DataModel.GetObjectsByName(imported_body_temp_object_name)[0]

magnitude_col_idx = 0

analysis_time_col_idx = 1

scale_col_idx = 2

offset_col_idx=3

table=imported_body_temp.GetTableByName("")

table.Clear()


with Transaction():

    row_index=0

    for row_index in range(len(analysis_time)):

        table=imported_body_temp.GetTableByName("") # get the worksheet table. Must be done at every step to grab the full table

        row =table[row_index] # get row to be defined

        row[magnitude_col_idx] = magnitude[row_index]

        row[analysis_time_col_idx] = analysis_time[row_index]

        row[scale_col_idx] = scale[row_index]

        row[offset_col_idx] = offset[row_index]

        if row_index<len(analysis_time)-1:

            table.Add(None) # add a new row to the table

        row_index+=1

Tree.Refresh()

print("Finished modifying imported body temperature")