Hi,
I am sure that some of members on this board are experts on this topic. I have a hard time to figure out the path to one of the database. I know the database name and the server name, but how do I know the entire path of that file? Where is that located?
Do you have any ideas/suggestions?
Thanks for your help.
DN
Subject: Full path to the db.
If you’re using formula language, then get the path using @LeftBack(@Subset(@DbName;-1);“\”).
If you’re using Lotusscript, then use the FilePath property of the Notesdatabase class - that includes the path and filename.
Subject: RE: Full path to the db.
Formula language - When I use @LeftBack(@Subset(@DbName;-1);“\”), but displayed the path to the file , for example, c:\testing\ on my machine (local), so in this case I know where it’s located since it’s on my machien, but I’d like to know the path to the production server. Is there anyway that I do that? Should I use Lotusscript for this?
Subject: RE: Full path to the db.
I don’t know if I understand your question. Using @LeftBack(@Subset(@DbName;-1);“\”) when the database is on the server will display the path if the database is in a subdirectory (under the domino\lotus\data directory). If the database is not in a subdirectory, the value will be blank.
Subject: RE: Full path to the db.
I still have trouble with this. Do you have email address where I can reach you? Or I can be reached at dhnguyen89821@yahoo.com
Thanks for your help.
DN
Subject: RE: Full path to the db.
Hi Rellim,
In this case, I currently have one form, Form1, on the database on my machine (local), and I am currently trying to retrieve the data from the Address book from the production server(I have server name, dbname how should I find out the path, for example, SERVER1\names.nsf) to display on Form1. So first, I need to know the full path to the server/databasename, then I can display it.
Thanks,
DN
Subject: Full path to the db.
I use 2 computed for display fields: DBPath & Server_Name.
DBPath: @ReplaceSubstring(@Subset(@DbName; -1); " " : “\”; “+” : “/”)
Server_Name: Server_Name
In the onClick of the button or $$Return: “[http://” + Server_Name + “/” + DBPath + “]”
HTH
Subject: RE: Full path to the db.
Charlotte,
Thanks for the information, but I am not able to achieve what I want. I have a link of the database. How can I find the entire path?
Thanks,
DN
Subject: What’s wrong with @WebDbName? Much cleaner (WAS: Full path to the db.)
Subject: Full path to the db.
In what context? In Notes you can user @DbName and that will work fine (read the help for examples of different ways to use this function)). If your application is on the web, then use @WebDbName – don’t bother mucking around with all that @Subset crap unless you have to be backwards-compatible.
–
Subject: Full path to the db.
What everyone is telling you WILL give you the path to your .nsf file. That path is relative to the data dirctory on your server. If you are trying to get the full path from the root of whatever drive your server is installed on, you’re out of luck. Maybe with some API work but I’m not sure about that.
@DbName will always return both the server name and the path to the application. Look in the help file for specifics on how the return value is formatted.
Subject: RE: Full path to the db.
James Sanders says: “If you are trying to get the full path from the root of whatever drive your server is installed on, you’re out of luck.”
Do you know if it is possible to get the full path on a client? I’ve tried session.GetEnvironmentValue(“Directory”) and session.GetEnvironmentString(“Directory”) Since the path seems to be located in the notes.ini file variable name “Directory” But this seems to return “”.
Thanks
Sam
Subject: You need: P1 = session.GetEnvironmentString(“Directory”, True)
Subject: RE: You need: P1 = session.GetEnvironmentString(“Directory”, True)
That works great! Thanks…