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
+1
person also asked this
people also asked this
Replies
6 replies
Subscribers
9 subscribers
Views
4885 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Export excel to sql smart service
baghavathit
Certified Senior Developer
over 8 years ago
The DB table contains some data with CLOB datatype, while I export using the Export excel to sql smart service, the CLOB datatype data are not available in the excel sheet, the other values are there.
OriginalPostID-244377
Discussion posts and replies are publicly visible
0
sridevik7401
Certified Lead Developer
over 8 years ago
@baghavathis...May be appian doesnt work for CLOB. I haven't found CLOB datatype in documentation.
forum.appian.com/.../Custom_Data_Types_from_XSD.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
pavanik
Certified Senior Developer
over 8 years ago
@baghavathis, AFAIK appian does not support CLOB data type.Correct me if i am wrong.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 8 years ago
@baghavathis Appian does not support CLOB type directly but Stored procedure plugin of Appian supports the CLOB datatype, and this is well known plugin too. As per my understanding as Appian directly do not support CLOB that's why u might not be able to store in variables and hence while using Export Excel to SQL Smart Service you might be getting empty values, i recommend you use Stored procedure plugin to fetch the Data first and then perform the Operation on that, i hope it will work.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Alok Patro
over 8 years ago
Stored procedure plugin supports the CLOB datatype and BLOB as well. This is a well used plugin - recommended by Appian.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chandhinir
over 6 years ago
, Any updates on exporting clob data to excel?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harrisont606
over 6 years ago
in reply to
chandhinir
If you use a stored proc node to get the clob into process you can pass it to w/e nodes you are normally using to export to XL
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel