Lotus notes - Export attachments from database into a folder structure

Hi guys,

I'm quite new into Domino, so need you proff. help!

I need to export Data (word documentes, pdf etc. files) from an nsf. database, is this possible?

I would very much like it to copy down the structure locally into a folder structure, It has 3-2 headings hiearchy...

Kindly advise.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sjef BosmanGroupware ConsultantCommented:
Do you have Notes at your disposal, installed and operational?
Can you log in, i.e. do you have the necessary credentials to open the database?
Do you have a Domino Designer client?
Can you develop an agent in LotusScript, or can you modify an existing one if we supply some code?
HakumAuthor Commented:
I have Notes client 8.5, Domino designer 8.5 and domino admin 8.5 installed yes ( i am a local admin, so i can work locally but not in the production.

I have worked with Agents before, but never tried to create one, but with some help i might be able to modify the existing code, yes.
Sjef BosmanGroupware ConsultantCommented:
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

HakumAuthor Commented:
This is awesome! but i cant get it to work :(

I think there is a Module not working as it should, please view the SS.

i googled it abit but couldn't really figure it out...
HakumAuthor Commented:
I got it working :P sorry for that :) although this was not entirely what i was looking for, yes some of it! but i wanted to check a few files so it would autocreate the folder structure itself not just export the file... would this be possible?
Sjef BosmanGroupware ConsultantCommented:
Ah, you want to re-create the structure of the Notes folders, but then as disk folders? Hm, that's different indeed. Firstly, there is no "folder" structure in a Notes database, it only appears that way. A Notes folder is like a Notes view: it has a name and documents in it. If the name happens to have backslashes in it, those backslashes serve as separators between folder names like in a hierarchy.

So the idea would be to go through all objects in NotesDatabase.Views, check whether they are folders, get the folder names and reproduce the structure accordingly.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HakumAuthor Commented:
I solved the problem with exporting from LN and using powershell to create the folder structure and then using the agent you refered to and copied all the files into the correct folders. thank you!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.