View the .ipynb file.

---

Add Date, Integer and Logical data

Work with date, integer, and logical attribute types.

Connect to MI

Get a database and table.

from datetime import datetime
from GRANTA_MIScriptingToolkit import granta as mpy

mi = mpy.connect('http://localhost/mi_servicelayer', autologon=True)
db = mi.get_db(db_key='MI_Training')
db.set_unit_system(unit_system='Metric', absolute_temperatures=False)
tab = db.get_table('AM Builds')

Create a new record and path

Define a path in the table from a starting folder (in this case the top level folder) using path_from(). If the path does not exist, the required folders will be created. Specify end_node to create a new Record object at the end of the path with that name.

now = datetime.now().strftime("%c")
record_name = 'STK Example 13:{}'.format(now)
record = tab.path_from(None, tree_path=['Blown Powder (Laser beam)', 'Ti-6Al-4V'], end_node=record_name)
record, record.parent

(<Record long name:STK Example 13:Tue Mar 23 16:19:23 2021>,
 <Record long name:Ti-6Al-4V>)

Edit the record’s attributes

Fetch date, integer and logical attributes for editing.

tab.bulk_fetch([record], attributes=['Date of Beam Profile Diagnostic',
                                     'Date of Build',
                                     'Maximum Number of Layers',
                                     'Built in Closed Chamber?'])
diagnostic_date = record.attributes['Date of Beam Profile Diagnostic']
build_date = record.attributes['Date of Build']
number_of_layers = record.attributes['Maximum Number of Layers']
closed_chamber = record.attributes['Built in Closed Chamber?']

Date attributes

Use the value property to set the date value of the attribute with either a datetime object or a properly formatted string.

diagnostic_date.value = '2020-07-12'
build_date.value = datetime.now()

Integer attributes

Use the value property to set the integer value of the attribute.

number_of_layers.value = 5

Logical attributes

Use the value property to set the logical value of the attribute.

closed_chamber.value = True

Write your changes to MI

First, specify the attributes on the record which you want to update on the server. Then write the changes to MI. The list of updated Record objects is returned.

record.set_attributes([diagnostic_date, build_date, number_of_layers, closed_chamber])
record = mi.update([record])[0]

Output the record’s attributes

Access the attribute values via the same properties you used to assign them.

datetime_format = "%b %d %Y"
diagnostic_date = record.attributes['Date of Beam Profile Diagnostic']
print("Date of Beam Profile Diagnostic: {0}".format(diagnostic_date.value.strftime(datetime_format)))

build_date = record.attributes['Date of Build']
print("Date of Build: {0}".format(build_date.value.strftime(datetime_format)))

number_of_layers = record.attributes['Maximum Number of Layers']
print("Maximum Number of Layers: {0}".format(number_of_layers.value))

closed_chamber = record.attributes['Built in Closed Chamber?']
print("Built in Closed Chamber?: {0}".format('Yes' if closed_chamber.value else 'No'))

Date of Beam Profile Diagnostic: Jul 12 2020
Date of Build: Mar 23 2021
Maximum Number of Layers: 5
Built in Closed Chamber?: Yes