How to copy more than 9000 documents from a view?

HCL Domino Domino Forum
1

There is a limit how many documents are allowed, if I am not mistaken, less than 9000 documents at one time, I wonder other than going for less documents selected, any other method? (other than copying database and delete other documents).

2

Subject: How to copy more than 9000 documents from a view?

If you copy manually, I think the limit is 3200. But with an agent, you can copy them all with a simple action agent or with a lotus script agent.

3

Subject: RE: How to copy more than 9000 documents from a view?

You mean I can create an agent and it will copy more than 2335 documents into clipboard, and than I can paste it to other database? tq.

4

Subject: RE: How to copy more than 9000 documents from a view?

they will be copied one by one.

Create an agent in the destination database similar to this one:

Sub Initialize

  Dim session As New NotesSession
  Dim coll As NotesDocumentCollection
  Dim doc As NotesDocument
  Dim archiveDb As New NotesDatabase( "", "" )
  Dim Db As New NotesDatabase( "", "" )
 
  Set archiveDb = session.currentdatabase

  Set db =session.GetDatabase(SourceServer,SourceDb )
  Set coll = db.AllDocuments
  Set doc = coll.GetFirstDocument


  Do While Not doc Is Nothing
        Call doc.CopyToDatabase( archiveDb )
        Set doc = coll.GetNextDocument(doc)
  Loop


  Exit Sub

End Sub

JYR

5

Subject: RE: How to copy more than 9000 documents from a view?

Tqvm, JYR. Luckily I was able to copy your codes, it appear dim and small fonts in my browser. Really appreciates that.

6

Subject: RE: How to copy more than 9000 documents from a view?

sorry, i have edited to font,

JYR

7

Subject: How to copy more than 9000 documents from a view?

Hi,

Write an agent ?

++

8

Subject: RE: How to copy more than 9000 documents from a view?

Look at CopyToDatabase method

Connect to source db, connect to view, getfirstdocument, copyto Destination

JYR

For faster answers, be C R I S P Y

9

Subject: RE: How to copy more than 9000 documents from a view?

But I want to copy document, even printscreen, if there is any, not just the data. So, I guest, going for more than 2335 documents (sorry this is maximum I got, not 9000), compared to write an agent, going for lesser selection will be better option isn’t it? Hoped Hannover will incorporate this feature in their release.

Regards

Tqvm.