cancel
Showing results for 
Search instead for 
Did you mean: 

Loading data to Planning enabled Model through Analytical application Scripting

rpsamy
Explorer
0 Kudos
328

We have Planning Model which required planning data from Excel received the data using Custom Widget table data http response, processing the data via Analytical application Button click Script below:

rpsamy_0-1718035633648.png

 

Table_1.getPlanning().setEnabled(true);

Table_1.getPlanning().setUserInput(lselection, rawVal );

Table_1.getPlanning().submitData();

Clicking the button – browser debugger shows an error.

rpsamy_1-1718035633651.png

 

Any help would be appreciated!

William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos
View Entire Topic
JefB
Active Contributor
0 Kudos

Please look at detailed documentation of the setUserInput() method, especially "The selection references a visible data cell in the rows or columns of the table. "
So, your Table should show the exact input-ready cells in 'unbooked' mode, as if you are able to do data-entry manually. Is that the case for you?

rpsamy
Explorer
0 Kudos
Hi JefB - Thank you for deep look at this issue. I have repost the case with input-ready cell and manually posted, same via script SetUserInput and submitData with error on debug window, Please check and let me know any missing part {<selection>}. not much reference {<selection>} format or field values.