Hi,
I created a kind of ticketing system for our service department but the question is now if it is possible to drag and drop emails into a form and store this email in de database (blob field?).
The text part of the email can be copy pasted into a text field but it should be better to store the complete email (.msg file?) in the database.
For example a CRM application does more or less the same.
thx,
regards,
Patrick
Bump. Same question.
AFAIK you have to save the email from your email client to a local file and then you can drag and drop that file on a field of type document in a SC form app.
Documents fields can be set as “database”, the file is saved in the database table, or “file”, the file is saved on the server filesystem.
Hi Roby, thx for your answer but this a complicated workaround which I had also figured out. Unfortunately this is not sellable to the users …
In this day and age of swiping it should be possible to drag and drop the mail as a kind of “binary object” and store it in the DB (as bob?).
regards,
Patrick
This is something i have to tackle at somepoint in the near future, but storing the email file ( msg or eml ) in the database is just asking for trouble at a later date.
The way I do this currently is to up load the file to a fileserver or location on the server and save a link ( file name, location, subject, date etc) in the database.
The database doesn’t take a massive performance hit from storing blobs of data, but is only searchable by the specific fields that u store.
Of course dissecting a microsofts .msg file format is a whole other subject :eek: