Assign flexscript data type on import

Create a simple method (or self-recognition) to import data as FlexScript type on import. I am running several scenarios where the distributions are updated outside of FlexSim and imported through Excel interface. Every time I import, I have to update the fields as FlexScript before running the scenario.

· 5

Phil BoBo ♦♦ commented · Feb 27 2018 at 10:17 PM

You can use the executeCell() command to execute a string datatype cell as FlexScript:

Table("GlobalTable1").executeCell(1,1);

You can also edit the Post Import Code to automatically toggle the cells in a certain column to be FlexScript rather than doing it manually:

Table table = Table("GlobalTable1");
int col = 2;
for (int row = 1; row <= table.numRows; row++) {
	switch_flexscript(table.cell(row, col), 1);
}
buildnodeflexscript(table);

3 ·

post-import-code.png (60.5 KiB)

Kari Payton Phil BoBo ♦♦ commented · Aug 01 2018 at 7:56 PM

Can you explain how to do this for switching to numerical and text? I looked up "switch_numerical" or "switch_text" in the command helper but didn't find these functions. @phil.bobo

0 ·

Phil BoBo ♦♦ Kari Payton commented · Aug 01 2018 at 8:01 PM

table.cell(1,1).dataType = DATATYPE_NUMBER;
table.cell(1,1).dataType = DATATYPE_STRING;

3 ·

Show more comments

Idea

Assign flexscript data type on import

No Comments

Things to know…

Your Opinion Counts

IDEA DETAILS

Related Ideas