When trying to create a new timesheet in a time-tracking database, some, not all users will get a “Field: ‘TSManager’: Entry not found in index” error. In addition, if I create a new user and log in with the new user’s id, I am able to create a new timesheet. Does the fact that some users are able to create timesheets “at all” indicate that it has to be a rights issue? I have run compact, fixup, and updall tasks on the database with no improvement.
Here is the formula for the TSManager field…
@DbLookup(“”;“852562EB:00628D6E”;“People”;
@If(@Contains(TSEmployeeName;“III”);
@Right(TSEmployeeName;8) + " , " + @Left(TSEmployeeName;" ");
@Contains(TSEmployeeName;“Jr.”);
@Right(TSEmployeeName;8) + " , " + @Left(TSEmployeeName;" ");
@RightBack(TSEmployeeName;" “) + " , " + @Left(TSEmployeeName;” "));
“Manager”)
I am responsible for administration and my design experience is very limited. Any ideas or pointers?? Thanks.
Subject: Not really, Go into the Db (852562EB:00628D6E) and look for that particular persons document.
by whatever was used in the @DbLookup (it appears truncated) and see if the document is there. Probably has been a name change and adminp did not update that document.If you are not sure how to find a db by replica id, you can usually look it up in the database catalog.
Subject: RE: Not really, Go into the Db (852562EB:00628D6E) and look for that particular persons document.
Thanks Bill. I checked the replica id and it referenced the Domino directory db. I picked the name of a person I know is unable to create a timesheet and checked their person document… all looks ok. I should mention that we recently copied over some 4.6.7a databases to new hardware with 6.01 Domino installed. I upgraded the design of the Domino directory to 6. The time sheet application database is set to “not inherit design” as it has been since it was created several years and several upgrades ago. Does this information give you any more clues? Thanks. Mike
Subject: What is an example of the UserName that Fails?
Subject: RE: What is an example of the UserName that Fails?
Hi Bill… here is an example of a User Name that I cut and pasted from a person document:
Charles C. Sterling/Shaw Systems
Charles C. Sterling
Charles Sterling
Subject: Well thats your problem then. The code you wrote does not take the middle initial into account.
@DbLookup(“”;“852562EB:00628D6E”;“People”;@If(@Contains(TSEmployeeName;“III”); @Right(TSEmployeeName;8) + " , " + @Left(TSEmployeeName;" ");
@Contains(TSEmployeeName;“Jr.”); @Right(TSEmployeeName;8) + " , " + @Left(TSEmployeeName;" ");
@RightBack(TSEmployeeName;" “) + " , " + @Left(TSEmployeeName;” "));
“Manager”)
Would generate Sterling , Charles instead of Sterling , Charles C. which is what is in the address book view “People” You could perhaps replace the @Left above with @LeftBack, or use a different view to get your data from. I would suggest using @LowerCase(@Name([Abbreviate]; @UserName)) and lookup in the hidden ($Users) view
Subject: And while you’re at it… re: Well thats your problem then. The code you wrote does not take the middle initial into account.
…get rid of the lookup by Replica ID. That’s a sin against man and nature. 
(Seriously, it’s a bad practice and you’ll regret it if you ever try to scale/templatize the application.)
Subject: RE: And while you’re at it… re: Well thats your problem then. The code you wrote does not take the middle initial into account.
Thanks Nathan… I inherited the responsibility for supporting this app as the original designer is long gone. I appreciate the advice. Mike
Subject: RE: Well thats your problem then. The code you wrote does not take the middle initial into account.
Thanks Bill… I had just gotten a response from a 4th person that was able to successfully create a timesheet. In looking for something in common, I also found that none of those that “can” create a timesheet have a middle initial specified in the username field of their personal record. That jives exactly with what you are saying. This timesheet application was written 4 years ago under 4.6 and worked fine til we upgraded to Domino 6.0. Thanks for your help… I do appreciate it! Mike
Subject: The design of the address book changed from 4.6 to 6.0 The People view…
used to have the following formula@Trim(@Subset(LastName;1))+@If(Firstname !=“”;" , “+@Trim(@Subset(FirstName;1));”")
now has this one.
@Trim(@Subset(LastName;1))+@If(Firstname !=“”;" , “+@Trim(@Subset(FirstName;1));”“)+@If(MiddleInitial !=”“;” “+@Trim(@Subset(MiddleInitial;1));”")
That is why for programatic access of the NAB, you should stick to the ($whatever) views when possible. They usually leave those alone for backward compatibility.
Subject: RE: The design of the address book changed from 4.6 to 6.0 The People view…
Hi Bill… I implemented your suggestion and the application now works like it should. Thanks again for your help! Mike
Subject: You are welcome.
Subject: RE: The design of the address book changed from 4.6 to 6.0 The People view…
Thanks again for the info… much appreciated!
Subject: How to cast UserName from an email address?
Hi,
I select the name from address book (Lotus Notes version 6.02). It’s something like this:
Dinh Nguyen/ABC COMPANY
How can you cast (trim) the first and last name of this person. All I need is to display the first name and last name of the person (Just like this: Dinh Nguyen)
What formula I can use?
Thanks,
DN