As a short background of our project needs, currently we are doing an
approach migration strategy on Lotus Notes database to Microsoft
conversion. Our project has a Lotus Notes mail-in databases use to
receive emails with attachments from client. These emails are being
accessed by our special program in production to detach the attachments
(.txt, doc, xls, etc.) and save them in the file server. Since our
clients are only using the mail-in to send files we thought of replacing
the mail-in database with STS. The new management process will be for
the client to upload files to STS instead of sending it through email.
Now my questions are:
1.) Can we programmatically detach uploaded files from STS using
external program (i.e. VB.Net)?
2.) If it is possible, can you provide us procedures on how to
accomplish this?
3.) Can you provide us the database structure use in STS and the
tables where we can find the stored data of our site?
4.) Also for Tables and fields used for storing the uploaded files.