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
11 subscribers
Views
2530 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
Hi all, We want to import attachments in SQL Server DB to Appian KC and sho
phanibabuk
over 8 years ago
Hi all,
We want to import attachments in SQL Server DB to Appian KC and show them under "Records".
The datatype used in the SQL table for attachments is "image" which is currently deprecated.
We tried casting/converting to base64binary but it didn't work.
Please let us know how can we import these attachments to Appian.
OriginalPostID-167878
OriginalPostID-167878
Discussion posts and replies are publicly visible
0
phanibabuk
over 8 years ago
Any inputs please...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
jamesw63
over 8 years ago
Well I learned something new today. I have never heard of an image type in SQL server. You want the image do display as the thumbnail in the record listing, correct?
Since the record listing only accepts documents and users for the thumbnail, I don't this will be possible as is.
If you really want to have these images in the thumbnail, you could use a process to convert them to documents and store them in the system and store the document ID in that table or a join table.
If you're looking to get the image into a record dashboard, then you may be able to work out some trick to get the actual bytes to display in the browser. You can read more on that here. (
en.wikipedia.org/.../Data_URI_scheme
) I suspect Appian will scrub the image source field, but maybe it's possible to sneak something through. Otherwise I think you'll need to convert these bytes into documents.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Umesh Patel
over 8 years ago
Its strange that even though Image data type is binary, its not treated as BLOB. Otherwise you might be able to leverage smart services to convert it to Base64. Can you try creating a DB view in which you convert image data type to BLOB and then pointing Appian to view?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
phanibabuk
over 8 years ago
Hi Umesh,
There is a base64binary type. Can this hold images? What size can it hold upto?
So, in the SQL server, We would create a db view that converts image datatype to Base64.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
jamesw63
over 8 years ago
The base64binary type should work for storing the bytes, but I'm not sure how Appian would treat it. I've used varchar(max) before to store PDFs without any trouble. This way Appian will recognize it as a string. Then you can convert back to an image file using the smart service mentioned above. As for size, you'd have to check what your database supports. If it's just a small image, then you should be fine.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
phanibabuk
over 8 years ago
Which smart service is used to convert the string back to an image.
I think the image size is low to high.
Does this approach work?
Please provide your inputs.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel