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
6 replies
Subscribers
8 subscribers
Views
3362 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi All I want to store document uploaded by the user in the relational data
shyamanandp
over 11 years ago
Hi All
I want to store document uploaded by the user in the relational database(not on appian side).
please let me know how to do this.
thanks ...
OriginalPostID-74161
OriginalPostID-74161
Discussion posts and replies are publicly visible
0
shelzle
over 11 years ago
You could convert it to base64 and save it in a text field. See function convertdocumenttobase64() in the plugin "Base64 Utilities Plug-in". This encoding is also used when you send an attachment in an email and nothing special.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 11 years ago
You need to make sure you store it in a CLOB. Text fields (VARCHAR or VARCHAR2) have a max limit of 4000 char and even a small file can easily be more than 4000 char long when converted to base64.
Also, take into account the additional overhead on the network to store/fetch such data. If your table is mapped to a CDT, this would have some impact - So the way you design the CDT should be modified to exclude this column (etc)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
shyamanandp
over 11 years ago
@sathya.. i m gettting the same pblm what u have explained in previous comment...after converting the Image or File to base64 ..the length of text field is increasing more than 4000..so can u tell me what is the way to do this..
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Myles Weber
Appian Employee
over 11 years ago
If you are passing binary files through process, but not via document management, be sure to plan appropriately for system resource requirements.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
shyamanandp
over 11 years ago
thanks to All
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ravindranv
over 11 years ago
base64 encoded data is usually 30% higher in size than the actual data. So you need to plan appropriately. You should also thing about the aspect around how you would retrieve the document to be displayed in the form. In case if some of them are images and need to be displayed inline you would need to handle appropriately.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel