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
Comments
-
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.
0 -
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
0 -
I believe we finished this discussion on the Auzie forum:
http://metastorm.processmapping.com.au/post/uuencoding-1496249?trail=300 -
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.
0 -
Could anyone give me some help on this? maryj@cityofws.org
0
Categories
- All Categories
- 122 Developer Announcements
- 53 Articles
- 149 General Questions
- 147 Thrust Services
- 56 OpenText Hackathon
- 35 Developer Tools
- 20.6K Analytics
- 4.2K AppWorks
- 9K Extended ECM
- 917 Cloud Fax and Notifications
- 84 Digital Asset Management
- 9.4K Documentum
- 31 eDOCS
- 181 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 8 XM Fax
- Follow Categories