CODEWITHSUNDEEP
lotus-noteslotus-dominolotuslotusscript
Hugo Suspiro
Hugo Suspiro

Reputation: 3

Which folder a document is in Lotus Domino

Is it possible export (@whichfolders) from Lotus to excel?

I created a view, with column "folder", with function @whichfolders.

On lotus view this configuration returns the correct info but, when i try export this view to excel, excel "print" a strange characters...

Lotus: "Inbox/resolved"

Excel: "c^_"

tks!

Upvotes: 0

Views: 1958

Answers (3)

user2715935
user2715935

Reputation: 46

I would think that you should be able to test to see if you have any documents in Folder X, then write the name of the Folder X, then write meta data of the message/document into a text file that could be imported to Excel. Then move on to the next Folder. If Folder = "" then end.

I am sure that this is available via LotusScript. You might be able to get what you need using NotesView objects. There is a property for Name. I have written code in the past that would access a View object when it is actually a Folder.

Upvotes: 0

Frantisek Kossuth
Frantisek Kossuth

Reputation: 3524

According to documentation of NotesDocument.FolderReferences you must provide special views: $FolderInfo and $FolderRefInfo - just by copying from mail template.

If it doesn't help, try to use hat LotusScript method in exporting code.

Upvotes: 1

Ken Pespisa
Ken Pespisa

Reputation: 22284

According to the docs, @WhichFolders is a very specialized formula intended only to be used in the mail template. It may not be built to support exporting properly from a view.

I would try, however, wrapping the formula in a call to @Text, just to see if that helps. 

@Text(@WhichFolders)

http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=%2Fcom.ibm.designer.domino.main.doc%2FH_WHICHFOLDERS_FUNCTION.html

Upvotes: 3

Related Questions