eRoom from Excel VBA (2007)???

Topic

New Reply

Wow! It’s been a a while since I was here. Great new look!
I would like to extract the folder structure from a Documentum eRoom into an Excel sheet complete with the names of all the contents. I tried importing from the URL but it only extracts what is on the first page (the highest level of the hierarchy). I found in the help that there is a com API that can be accessed from VB (SAAPI). That got me to thinking (always a dangerous thing), perhaps my friends at the Lounge have done something like this in a macro. But I can’t find anything using the search. Any suggestions on where to get started? The search within eRoom is useless and having the names of the files and their folders in a sheet would be a great help. I have been expanding and copying from the map manually which works well because everything comes over as links. But it is horribly tedious and impractical since it would take several days to complete and by that time a lot of new stuff would be added. Any help you can offer would be greatly appreciated.
Thanks

Reply | Quote

Replies

two questions
What is eRoom? I am not familiar with this.
Have you tried this question in the Web Development forum? Is it essential that it is done within Excel? (ok 3 questions)

Reply | Quote

Thanks for your reply. eRoom is supposed to be an online project team collaboration solution from EMC Documentum but the only way I’ve seen it used is as a repository for documentation. It is being replaced by SharePoint in several sites that I am aware of. I am interested in extracting the names of the documents and the structure of the hierarchy they are stored under from the eRoom and placing them into an Excel spreadsheet (if I can bring the link to the document with it, all the better). I am hoping there is a way to do this through VBA with the API they provide. I have not posted this anywhere else but was wondering if there was a better place for it. Perhaps the VBA forum?
Thanks

Reply | Quote

Oops! Forgot to reply to the third question: I’m open to other solutions but I don’t have much recent experience with anything other than VBA (I guess I’m that guy with a hammer to whom everything looks like a nail!) I believe there is an HTML interface and I have worked with HTML but that looked pretty complicated and huge. I wouldn’t know where to start.
Thanks

Reply | Quote

I’m thinking that in the web development forum you should be able to find help with script to list folders and contents.
After all, developers frequently do this so that they can create sitemaps and breadcrumbs.

One might run into a problem with user rights.

That being said, if you can access the website by using the \ prefix (not an URL)
you can use the FILES function from the xl4 macro language.
try this link for an explanation.

Reply | Quote

Thanks Catharine. I’ll try the web development forum. You are right about user rights… there are features I’d like to use but have been blocked from them. I’m hoping the API can get around that. I like the \ idea and the link you gave is much easier than the code I’ve used in the past to walk through folders. Any clue how I can get the \ (by which I think you mean the direct server address such as I’d use to map a drive to a server location) when all I know at this point is the URL?

Reply | Quote

\ (by which I think you mean the direct server address such as I’d use to map a drive to a server location) when all I know at this point is the URL?

Not a clue. If the server isn’t inside your network you can’t use the \ (which I know there is a proper term for and I can’t remember it for the life of me).

Reply | Quote

OK, thanks anyway. I’m asking around here to see if anyone knows it. If I can get that this gets real easy.

Reply | Quote