Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
10 replies
Subscribers
8 subscribers
Views
3009 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
I am using "fn!readexcelspreadsheettocdt(ri!doc,1,ri!CDTArray)" expres
anilkumark
over 8 years ago
I am using "fn!readexcelspreadsheettocdt(ri!doc,1,ri!CDTArray)" expression in interface, but data is not fetching from spreadsheet.
doc: Document (Type)
CDTArray: TestTemplate (CDT)
XSD:
<xsd:schema
targetNamespace="
https://xyz.com/suite/types/"
xmlns:tns="
https://xyz.com/suite/types/"
xmlns:xsd="
www.w3.org/.../XMLSchema">
<xsd:complexType name="TestTemlate">
<xsd:sequence>
<xsd:element name="Name" nillable="true" type="xsd:string"/>
<xsd:element name="Number" nillable="true" type="xsd:int"/>
</xsd:sequence>
</xsd:complexType>
</xsd:schema>
Thanks in advance.
Test_Template.xlsx
OriginalPostID-169111
OriginalPostID-169111
Discussion posts and replies are publicly visible
Parents
0
Tom Ryan
Appian Employee
over 8 years ago
It looks like you have multiple issues here, but the first one to fix is that you are trying to upload the document and reference it on the same form. From the File Upload docs here
forum.appian.com/.../SAIL_Components.html
"When a file is uploaded, the component updates with a temporary Document representing the uploaded file. Between the upload and the form submission, the file on the server is an inactive temporary document and not accessible. When the form is submitted, a new file or version is created at the target. This file has a different document ID than the temporary file. Any Document variable submitted as part of the form will be automatically updated to the new document ID, but integer variables (including integer fields of CDTs) are not updated"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Tom Ryan
Appian Employee
over 8 years ago
It looks like you have multiple issues here, but the first one to fix is that you are trying to upload the document and reference it on the same form. From the File Upload docs here
forum.appian.com/.../SAIL_Components.html
"When a file is uploaded, the component updates with a temporary Document representing the uploaded file. Between the upload and the form submission, the file on the server is an inactive temporary document and not accessible. When the form is submitted, a new file or version is created at the target. This file has a different document ID than the temporary file. Any Document variable submitted as part of the form will be automatically updated to the new document ID, but integer variables (including integer fields of CDTs) are not updated"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data