Import the list of databases from a text file

HCL Domino Domino Forum
1

Can anyone tell me how can Import the list of databases from a text file

Regards

jyoti

2

Subject: Import the list of databases from a text file

Not sure what you mean by importing list of databases from text file!?!You can import “data” from a text file into a Notes database or you can EXPORT “data” from a Notes database to a text file!

Please elaborate a little so that someone can point you in the right direction.

3

Subject: RE: Import the list of databases from a text file

if you have access to the OS, open DOS, CD to the data directory and type …

dir *.nsf /b /s > c:\myDatabases.csv

c:\myDatabases.csv and be changed to where ever you want to store and name it. This is the easiest if you have access.

4

Subject: RE: Import the list of databases from a text file

<< let me correct mt bad spelling. >>

if you have access to the OS, open DOS, CD to the data directory and type …

dir *.nsf /b /s > c:\myDatabases.csv

“c:\myDatabases.csv” can be changed to where ever you want to store and name it. This is the easiest if you have access.

5

Subject: RE: Import the list of databases from a text file

<< let me correct mt bad spelling. >>

I want to go hume!!!

6

Subject: RE: Import the list of databases from a text file

Hum,

after playing with dir it seems that this will also display the full OS path as well. Not sure if that is needed and I don’t see a way off hand to just get the file names. Maybe code would be better. I would think unix ls would have more options than dos’ dir, but that’s unix

Sorry I couldn’t be more help.

7

Subject: Import the list of databases from a text file

Simran,

Where would you like to import them to?

Mike

8

Subject: RE: Import the list of databases from a text file

Mike

I want to import to excel file

9

Subject: RE: Import the list of databases from a text file

Aaaah…so you mean “export”!!!

To do this by code, you could loop through all the databases on the server, build a text file using the Print # command and then open in Excel

To loop through the database on the server using LotusScript, look in the Designer Help at the NotesDBDirectory and NotesDatabase classes

HTH

Mike

10

Subject: RE: Import the list of databases from a text file

Mike

I want to import to excel file

11

Subject: Import the list of databases from a text file

I am not sure what you mean with “import the list of databases”. Could you clarify this?