Get attachments out of eAttachment table

Jamie Francis

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

Brian Mellert

You can read the attachment list name from eAttachment for the current folder (eKey = "0TT" where T is a tab character or use a like).

From that you can do Mstm.GetAttachment(,,) to store on disk.

Jamie Francis

Hi Brian, Thanks for responding. Where do I run that function (Mstm.GetAttachment) is it a scripting call? If so, how would I run it for many folders at once? I am using MBPM V7, not 9

Brian Mellert

I believe we finished this discussion on the Auzie forum:
http://metastorm.processmapping.com.au/post/uuencoding-1496249?trail=30

Mary Johnson

the metastorm.processmapping.com.au site is no longer available. I have a similiar need. Could anyone please add the contents of that post? Thanks.

Mary Johnson

Could anyone give me some help on this? maryj@cityofws.org