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
3 replies
Subscribers
7 subscribers
Views
1952 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
"Parse Excel Spreadsheet to CDT" smart service is behaving differently
piyusha
over 8 years ago
"Parse Excel Spreadsheet to CDT" smart service is behaving differently for Excels-:
Steps to create
1-> I have one attached Excel which I send to SFTP drive via Send File Over SFTP smart service
2-> Then Used receive same Excel from SFTP via Receive File Over SFTP and
3-> Try to parse the data by using Parse Excel Spreadsheet to CDT smart service.
It is not parsing the Data.
Now I used different approach-
1-> At the step 2 of above process I saved the excel in Appian folder.
2-> Download this excel into desktop and uploaded into different folder
3-> Now used same excel in parsing process.
4-> It has parsed the data.
Can any one suggest.
CDTForExcel.xlsx
OriginalPostID-160608
OriginalPostID-160608
Discussion posts and replies are publicly visible
0
piyusha
over 8 years ago
Adding more Info-:
Both Excel is showing exactly same properties and also I have tried by using the excel from Appian folder after receiving from SFTP drive to Appian folder.
It is parsing only Excels which are uploaded from Desktop to Form or to Appian Folder.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mpontius
over 8 years ago
Are you sure the file is coming over from SFTP correctly?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
piyusha
over 8 years ago
Yes... I can see the correct file type i.e. "xlsx" and also data in that excel.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel