Get attachments out of eAttachment table

Hi

Is there a way to extract all of the attachments in the eAttachment table and put them in a folder or network share?

It would also be extremely helpful to be able to put each attachment in a folder made up of the metastorm foldername or some other information from the procedure so that the documents can be easily identified/sorted.

For example I'd like the attachments to go into folders like this:

ClientName\MI000031\Attachment1.doc
ClientName\MI000031\Attachment2.jpg
ClientName\XC000101\Attachment.docx
ClientName\DC003133\Picture.jpg

Where ClientName comes from the procedure, the next part is the Metastorm folder number and the last bit is the attachment name.

I assume I'd need to write some sort of application to take care of this? Can I interact with Metastorm using C#?

As the database is about 10 years old, I'd likely need to do it in batches. To be honest I'd probably copy the database somewhere else before even attempting it so as not to put any load on the Metastorm instance.

If it makes a difference, this is Metastorm version 7.4.6.9

Thanks

Tagged:

Comments