Appian Excel Tools plug-in not returning data

mikek0001 over 6 years ago

I'm using the Appian Excel Tools plug-in to extract information from a spreadsheet. I have the plug-in and have added a Parse Excel to CDT node. What I see when I run the process model is that the user interface passes a document to the Parse Excel to CDT node, which then returns an errorOccurred value of False, but never returns any data from the spreadsheet. Is there a way that I cab try to get some data from this node?

Discussion posts and replies are publicly visible

Top Replies

santoshd378 over 6 years ago +1 suggested

community.appian.com/.../Parse_5F00_Excel_5F00_Spreadsheet_5F00_to_5F00_CDT_5F00_Smart_5F00_Service_5B00_1_5D00_.docx Once go through the file..

Parents

0 Harsha over 6 years ago

In addition to having same field names in excel sheet as well as cdt verify these as well:
1. All the input parameters should have values even if they are not marked as required (because I have seen cases when I didn't receive data until I gave input to all the fields)
2. Cdt input requires only the type of cdt so in the input tab's cdt field provide the cdt as value and leave the save into field as blank. And in the output tab provide the cdt as target of returned CDT.
3. Recheck that the cdt is configured to hold multiple values.
Hope it helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Harsha over 6 years ago

In addition to having same field names in excel sheet as well as cdt verify these as well:
1. All the input parameters should have values even if they are not marked as required (because I have seen cases when I didn't receive data until I gave input to all the fields)
2. Cdt input requires only the type of cdt so in the input tab's cdt field provide the cdt as value and leave the save into field as blank. And in the output tab provide the cdt as target of returned CDT.
3. Recheck that the cdt is configured to hold multiple values.
Hope it helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 mikek0001 over 6 years ago in reply to Harsha

Carlos,
I think I'm missing how to do #2. Can you provide an example?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 santoshd378 over 6 years ago in reply to mikek0001

mike,
Under the data tab in CDT input you need to point your CDT as {type!excelData()}
where as excel Data(Example) is my CDT. And under output tab in the results you will have a ReturnCDT output in which you can point out your CDT
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mikek0001 over 6 years ago in reply to santoshd378

Okay, Thanks. I'll give it a shot.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mikek0001 over 6 years ago in reply to mikek0001

I have modified my spreadsheet so each column name is the same as the field names in my CDT, and used type on the CDT input and have hard coded the spreadsheet into the input values, and have pointed the ReturnCDT as my CDT in output, but still receive no data when I run the process model.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 santoshd378 over 6 years ago in reply to mikek0001

Can you post the screenshot of inputs under data tab of smart service
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mikek0001 over 6 years ago in reply to santoshd378

Where?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Harsha over 6 years ago in reply to mikek0001

Mike, I assume you have a cdt 'customer_cdt' of type 'Customer'. now I will create a pv 'customer_pv' of type 'customer_cdt' then in the cdt field of smart service in the value field provide 'customer_pv' and will leave saveinto as blank. In the output tab's return cdt will give 'customer_pv'. Hope it is clear now.
I didn't use type!cdt still its working for me.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mikek0001 over 6 years ago in reply to santoshd378

Can we make some progress on this today? Where would you like screenshots posted?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel