Hi,
I need to link the property table with Excel to change conveyor properties. When I use a global table with Excel import, I cannot update the property table. Could you tell me how I can do it?
Thanks in advance,
Lucas Prata
Insert data into the property table through a global table with Excel Import
FlexSim 24.0.6
Hi @Lucas_Prata, was joaopedrostefani's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.
If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.
Hello Lucas, how are you?
There is more than one way to perform this import. One possible method is to import the data from Excel into a Global Table and update the Property Table using the “Update On Reset” option.
To do this, first, create an import of the data from Excel into FlexSim.
Next, in the properties of the Property Table, click on the “Update On Reset” option.
Ensure that the Excel data is in the desired format, either as numbers or text (for instance, conveyor speed should be a number).
After adding the fields to be updated in the Property Table, click on Generate in the Property Table properties to create the update query.
Finally, in the properties of the Property Table, in the Update Query field, replace the line:
From: ON Obj.Object = Src.Object
To: ON Obj.Object = Model.find(Src.Object)
This replacement will locate the reference objects imported from Excel.
Every time you click Reset, the settings will be updated. Examples of the model and the input spreadsheet are attached.
I hope this procedure meets your expectations. If you have any questions, we are at your disposal.
12 People are following this question.
