lotus-notes,lotus-domino,lotus-formula
You should be able to set your formula to SiteNum + SiteName + State + "|" + SiteNum. That will tell the dialog lis to display SiteNum + SiteName + State but return the alias value SiteNum.
Add an client side event handler "onkeyup" to your inputText control: <xp:eventHandler event="onkeyup" submit="false"> <xp:this.script><![CDATA[ thisEvent.srcElement.value = thisEvent.srcElement.value.substring(0, 20) ]]></xp:this.script> </xp:eventHandler> It shortens the text to max length if necessary. You can show the message as alert var element = thisEvent.srcElement; if (element.value.length > 20) { element.value = element.value.substring(0, 20);...
lotus-notes,lotusscript,lotus-formula
Use a folder categorized by username. Add the current document in PostOpen event to folder with document.PutInFolder(folderName) and remove the oldest document from folder with document.RemoveFromFolder(folderName) This way you don't need to edit the documents and can show the last visited documents for a user in an embedded view. As...
lotus-notes,lotus-domino,lotusscript
You can use DXL. The DXL schema for view columns includes an attribute that represents the selected option for the totals. I.e. set up a NotesNoteCollection object that includes the view design note. Use NotesSession.CreateDXLExporter to get a NotesDXLExporter and process the NotesNoteCollection, parsing the XML to locate the column...
There is a DocumentContext property on the agent context object. On that document, there will be an item called "Request_Content" that will contain your post data. import lotus.domino.*; public class ExampleAgent1 extends AgentBase { public void NotesMain(){ try{ Session session = getSession(); AgentContext context = session.getAgentContext(); Document doc = agentContext.getDocumentContext();...
java,javascript,xpages,lotus-notes
The following SSJS function should do it function addContactID(contact, organisation) { contact.replaceItemValue("TmpIDString", organisation.getItemValueString("DocID")); session.evaluate('FIELD ContactOrganisationIDs := @Trim(@Unique(ContactOrganisationIDs:TmpIDString)); FIELD TmpIDString := @DeleteField; ""', contact); } Parameters contact and organisation have to be of type NotesDocument. Don't forget to save the contact document sometime after calling the function....
This solution works for me. hasselba.ch/blog/?p=1216
I can confirm I get exactly the same behavior out of this. I agree that I would expect the entire column to not render, but that's apparently not its behavior. I've always viewed the xp:dataTable control as a slightly dressed up xp:repeat, but not with as much window dressing as...
performance,lotus-notes,lotus-domino,notesview
Performance- wise it is a very bad idea to put @Today or @Now in a view selection formula. There are some alternatives to do what you want to do: Use @TextToTime( "Today" ) or similar. In that case, the view indexer does not "know" that something changed. You need to...
Put your code into a try-catch-block as you want the part only be visible if user is in view "(UserProfile)" and has a certain status: try { var userName=rowData.getColumnValue("userName") var status:NotesView = database.getView("(UserProfile)"); var doc:NotesDocument = status.getDocumentByKey(userName); var active = doc.getItemValueString("Status") if(active == "Enabled") { return true; } else {...
Can I Get the background doc of an open uidoc in another window? Yes. But let's clarify: when you open a document in the UI (like by double clicking or hitting Enter in a view), if it is already open in another window or frame, notes will try to...
vba,email,lotus-notes,attachment
You should convert your initialization of Body field to NotesRichTextItem initialization. Instead of: .body = "Text in email body" & vbNewLine & vbNewLine & _ "**PASTE EXCEL CELLS HERE**" & vbNewLine & vbNewLine & _ "Excel cells are shown above" Write this: Set notesRichTextItem = .CreateRichTextItem("Body") notesRichTextItem.AppendText("Text in email body")...
lotus-notes,lotus-domino,lotusscript,lotus,lotus-formula
You can test if date field "OUT" is from previous month this way: @Month(OUT) = @Month(@Adjust(@Today; 0; -1; 0; 0; 0; 0)) BUT, it is not recommended to use time-based functions (like @Today or @TextToTime("Today")) in view selections. Look here for more information....
There is nothing built-in that will let you detatch attachments and extract embedded images from rich text fields. You can write your own Lotusscript code if you like. To get the attachments is pretty easy, you use the EmbeddedObjects property to get an array of embedded attachments that you loop...
c#,email,lotus-notes,lotus-domino
0. MIME If you are using MIME then you don't need to create the Body field. But you need to use <br> instead of newline characters. //Remove this from your code: //NotesRichTextItem objMailRTF = ndoc.CreateRichTextItem("Body"); //ndoc.ReplaceItemValue("Body", body); objNotesSession.ConvertMIME = false; LNStream.WriteText(body.Replace(Environment.NewLine, "<br>")); LNBody.SetContentFromText(stream, "text/plain;charset=UTF-8", 1728); ndoc.SaveMessageOnSend = true; if (FileName...
xpages,lotus-notes,lotus-domino
I don't think you will be able to save them to the WebContent folder of the NSF and that would not be a good idea. It would save the images in the design, but the images should be data. You may be able to save them to a folder under...
powershell,single-sign-on,lotus-notes
You've already mostly answered your own question. Since the policy is preventing you from checking that option, no you cannot use the SSO option that Notes provides for you. That said, can you write your own SSO? Yes, you can. It requires writing C code using the Notes C API's...
xpages,lotus-notes,lotus-domino
Yes, XPages and Custom Controls are part of design refresh/replace mechanism. In general all design elements visible in Designer/Applications are part of it. You are right, those design elements are not listed in documentation (neither in version 9) but should be....
lotus-notes,lotusscript,lotus-formula
OK, so I tried using Formula language instead of Lotusscript in my DXL-created button in a rich text table in a rich text field in an unsaved uidoc. And it worked :-) @Setfield("deleteRow"; 1); @Command([ViewRefreshFields]) Obviously, the LotusScript that creates the DXL document subsitutes the approriate row number in each...
javascript,file-upload,lotus-notes
I have been able to achieve something similar using the JQuery Multifile plugin, found here : http://www.fyneworks.com/jquery/multiple-file-upload/ My Domino web application displays to the client a list of files that are pending upload when the form is submitted, and allows for removal of all or any of these files prior...
Add Notes.jar to your project and build path. You can find the file in directory ...\Notes\jvm\lib\ext. You get the session with import lotus.domino.NotesFactory; import lotus.domino.NotesThread; import lotus.domino.Session; ... NotesThread.sinitThread(); Session session = NotesFactory.createSession(); ...
Probably document's item $Revisions has one more entry. That means that the document was saved one more time. If the cause of this "copy thousands of documents" accident was replication then you might be lucky that documents contain an item $Conflict. This item contains the DocumentUniqueId of the original document...
The login process is a server based process and not based on the database directly. First of all the Domino- server you try to access has to be configured to use a session based login, otherwise you are not able to use a login page and might be asked for...
lotus-notes,lotus-formula,notesview
It can't be done in any reasonable way with just the capabilities of a view selection formula because those formulas work with one document at a time. They simply cannot compare one document to the others and decide "is this one in the top 10?" Not without help. You can...
Base64 embedded images don't work in Notes Client 8.5 HTML signature. Use an URL for img src. It doesn't matter if it's "file://..." or a "http://...". The picture will always be embedded in mail body....
In a view you can have a computed column. Any code you place into a dialog could be placed into a computed column. The getDocument() method of the XSPviewEntry gives you access to the document (recycle wisely). update To use a download control, use a repeat with the view as...
The XPages Toolkit project has an Language bean that gives the options to set a specific language to an application or let the user decide. http://www.openntf.org/main.nsf/project.xsp?r=project/XPages%20Toolkit If you can't use the extension OSGI plugin checkout the java source on github https://github.com/OpenNTF/XPagesToolkit An implement what you need...
Well…try this steps: Open the "Start" menu and click "Computer" or "My Computer" depending on your version of Windows. Navigate to the C drive. Open the "Notes" folder. Double-click on the "Notes.ini" file to open it in Notepad. Place a semicolon (;) in front of the following two lines to...
I recommend using the DXL export features and then walking the resulting XML to find the URLs. Try it, and if you have issues, come back and ask questions about the specific piece of code.
eclipse-plugin,lotus-notes,lotus-domino
Have you tried using the -NL parameter to set the language?
You should use quotes for form instead of square brackets. Here is example: formula$ = {SELECT (@Modified = [} & Left(doc1.LastModified,10) & {]) & form = "} & doc1.form(0) & {"} Which generate this string: SELECT (@Modified = [03/02/2015]) & form = "myform" ...
field,lotus-notes,numeric,decimalformat
Change your column formula to @ToNumber(YourField) This way old values gets converted to a number and will be shown with 3 decimal places too....
There is an issue with a Language setting that was applied to FormOne in your example database. I think the refresh is ignoring elements in the template that it does not think match your current language. When I looked at the fields tab in the FormOne design properties, I saw...
Use @Prompt([OkCancelListMult]; instead. User can select all relevant error message at a time then and there is no need for asking how many error messages user wants. Your code would look like this then: FIELD Errors := @Prompt([OkCancelListMult]; "Select Errors"; "Please select all relevant errors"; ""; "Duplicate Submission." : "Invalid...
lotus-notes,lotus-domino,lotus,lotus-formula
If you need both, the "visible" value and the "alias" then I usually do it like that: Field, Multivalue, Name "SelectionList", Hidden from User, Formula: @Unique(@DbColumn("" : "NoCache"; @DbName; "SiteLookupView"; 4)) Field: DialogList, Name "Selection" (or whatever fits best), "Use Formula", and as Formula simply: SelectionList Field: Text, Name: SelectionReadable,...
Open your Lotus Notes client. Select Preferences from the File menu. Select Locations in the pane on the left. A list box will come up with your current location setting preselected. Click on the Edit button. A tabbed dialog box will come up. Click on the Servers tab. Write...
sql,lotus-notes,lotus-domino,lotusscript,lotus
I tried it with the sql query UPDATE and it's working now : Option Public Option Declare UseLSX "*LSXODBC" Sub Initialize Dim session As New NotesSession Dim db As NotesDatabase Dim dbcontacts As NotesDatabase Dim doc As NotesDocument Dim DocContact As NotesDocument Dim CandidatView As NotesView Dim ContactView As NotesView...
view,lotus-notes,lotus-formula
Option "Show multiple values as separate entries" shows only unique values in column. Some of your values are several times in your list like "26" and "462". They show up in column only one time. Think of this option like a categorized column. Multiple identical values are connected to one....
I found this in the Domino Designer 8.5 help file: Dynamic HTML sections The Dynamic HTML (DHTML) used to render collapsable sections for display with Microsoft Internet Explorer has been enhanced and made available for use in other browsers which support DHTML. The enhancement consists of using the tag instead...
vba,ms-access,ms-access-2013,lotus-notes
To have multiple values in an item in a Document, you need to use an array. Try this: dim varCopyTo as Variant varCopyTo = Split( strCopyTo, "," ) call notesDoc.Replaceitemvalue( "CopyTo", varCopyTo ) You could also write notesDoc.CopyTo=varCopyTo, but it is better (more secure, slightly better performance) to use ReplaceItemValue....
Create a Java agent to export a DXL file for all selected documents: import lotus.domino.*; public class JavaAgent extends AgentBase { @Override public void NotesMain() { try { Session session = getSession(); AgentContext agentContext = session.getAgentContext(); DocumentCollection dc = agentContext.getUnprocessedDocuments(); String filename = "c:/temp/exportDocs.dxl"; Stream stream = session.createStream(); if (stream.open(filename))...
According to log entry, the agent runs but needs to long to accomplish the task. Maybe "Max. LotusScript/Java execution time" in Server document is too short or you don't have enough rights as 'Application Development/IT/***************'" signer on production server and the agent wastes time to try to access something again...
lotus-notes,lotus-domino,lotusscript
there are a few things to try Check the trigger property on the agent and set it to run on All documents or change it to None. Test both scenarios. There are some issues with this setting. When you run an agent manually from the notes client or designer you...
xpages,lotus-notes,lotus-domino
I believe that the solution here is to make sure that no threads are left running or hung that are tying up the server debugging port. It is very easy, especially if you are new to this debugger, to switch to the XPages perspective and continue working while the debugger...
Your RichText field has set the property "Hide Paragraph when document is ... Opened for reading" in form. That's why the content is only visible in edit mode. Remove this property in form and in RichText field in all documents created with this form. ...
In my experience this is because the xpage is signed by an ID that is not listed in the "Sign agents or XPages to run on behalf of the invoker" on the security tab of the server document, so might be worth checking there?
rest,xpages,lotus-notes,lotus-domino
Yes. Google "XAgents", there are plenty of resources about how to call an XPage and return non-XPage code. Also, make sure you set viewState property of the XPage to "nostate", because there's no point storing a component tree server-side for something that can't be partially refreshed....
The # sign breaks the URL. It is the separator between a location and a place inside that location. You need to encode it. Also xpages attachments follow a slightly different format. See: http://www.wissel.net/blog/d6plinks/SHWL-86QKNM
It's pretty easy to create a doclink using Lotusscript. Set body = New NotesRichTextItem(maildoc,"Body") Call body.AppendDocLink(doc, "Click me") And if you want to send an email, use the class in the link below, it even have built-in support for doclinks. :-) http://blog.texasswede.com/lotusscript-mail-notification-class/...
The universal ID uniquely identifies a document across all replicas of a database. The universal ID is a 32-character combination of hexadecimal digits (0-9, A-F). If two documents in replica databases share the same universal ID, the documents are replicas. If you modify the UNID of an existing document, it...
Unfortunately the NotesRegistration- class did not follow the development in admin- client. As for today there is no method to register a user without having an ID saved locally, as "filepath" is a mandatory parameter for registerNewUser method. The only property that comes close is the IsNoIDFile- property, but it...
lotus-notes,lotusscript,notesview
Change your condition to Do While doccount1 < 11 AND Not v2entry Is Nothing v2entry.isValid() can only be used if v2entry is a ViewEntry. It fails when v2entry is Nothing. This is the case when Set v2entry = vc.GetNextEntry(v2entry) was executed for last entry. You might use v2entry.isValid() though if...
java,logging,xpages,lotus-notes
I had have lot of compatibility problems between the log libraries like SLF4J, Log4J, java.util.logging, etc. and Lotus Notes. Without knowing what those issues were, it is difficult to advise you. There may have been a simple fix or work-around. Is it a bad idea to write a logger?...
Add an item ExcludeFromView with value "D". This prevents the appointment from showing up in Draft folder. calDoc.ReplaceItemValue("ExcludeFromView", "D"); ...
xpages,lotus-notes,lotus-domino,xpages-extlib
The last release for 8.5.3 is 853.20130315-0724 from Apr 4, 2013.
I don't really see the problem, as this is the default behaviour for a view column containing a multi value field. The only thing to change is the separator for display: Just enter multivaluefield as formula (or even easier: select the field name from the field list) for the column...
xpages,lotus-notes,xpages-ssjs
Try changing your repeat to return for instance the view entries directly using sessionAsSigner instead of going through a view data source. So in your case: <xp:repeat id="repeat1" rows="30" var="playerData"> <xp:this.value><![CDATA[#{javascript: sessionAsSigner.getDatabase(database.getServer(), "PrivDb.nsf").getView("PrivView").getAllEntries(); }]]></xp:this.value> ... </xp:repeat> ...
java,vector,arraylist,lotus-notes
You can convert the Vector into a more modern Collection. But You have to ensure, that you don't use Java 7 Features or classes. As far as I know, IBM Notes still uses an IBM Java 6 VM. And generics are a litte dangerous, because I am not sure, that...
Use the following code in your picklist data source. @Unique(@DbColumn("","view",1))
xpages,lotus-notes,xpages-ssjs,xpages-extlib
Both ways are possible, it depends on your requirements. Take a look at this OpenNTF project - Bildr: http://www.openntf.org/main.nsf/project.xsp?r=project/bildr...
Finally I found the solution. As @arnaudq pointed out I was not following the structure correctly. It had something to do with the naming structure of the organizer field specifically in Notes (since it worked well on google calendar and few other application I tried with). //Wrong Version ORGANIZER:CN=Chintan Jayesh...
lotus-notes,lotus-domino,lotusscript,lotus-formula
It is not possible directly. There are no formulas that would help you build a select statement to get documents that are only in the Inbox. However, you could have an agent run on a scheduled basis (maybe every 5-10 minutes) that would update documents and flag them if they...
The code below will give the "Last Accessed" date and time for every view in your database. Note that (according to the help file) this value is not accurate to more than 24 hours, as if a document is accessed more than once in a 24 hour period, the last...
Discovered the logic in the solution was working after all. It was bad feedback that was making us think the specific user could delete in one tab but not the other. After discovering the user could not dlete from any tab, we found they were a member of another lotus...
lotus-notes,lotus-domino,lotusscript,lotus,lotus-formula
Create a function which changes all non-digits to dots Function ToDigitsAndDots(orig As String) As String Dim i As Integer Dim char As String For i=1 To Len(orig) char = Mid(orig, i, 1) If Not char Like "#" Then char = "." JustDigitsAndDots = JustDigitsAndDots & char Next End Function and...
unique,lotus-notes,lotus-domino,lotus,lotus-formula
Set type of field "testid" to "Number" Change formula to _List:[email protected]("" : "NoCache"; ""; "testview"; 1); @If( @IsError(_List); 1; _List = ""; 1; @Subset(_List; 1) + 1 ) Set column sort to "Descending" ...
The Extension Lib is part of your Domino 9.0.1 (though it's not the latest as from OpenNTF). If you want to use Bootstrap 4 XPages and ODA you have to install them separately (you can do also for the latest Extlib from OpenNTF). There are several tutorials you may have...
The "compression" as you call it is simply the "absence" of view- indices. The database size consists of: Size of all documents Size of the design of the database Empty Space (if data was deleted, but the database not compacted) View indices A new copy (via client) has NO indices,...
lotus-notes,lotus-domino,lotus
I solved the my problem by making the lkpView not hidden, I don't know why its not working on hidden views though. Now it returns a multiple value as expected.
Considering that it's a repetitive task and you don't want to use that script to export the documents, I would suggest an outside-the-box solution: you can use a software like AutoHotkey to simulate the keystrokes and clicks. You will have to write the macro but it should work. I use...
lotus-notes,lotusscript,date-formatting,regional-settings
If you are using Windows you can use WinApi GetDateFormat function. For this function you need to create SYSTEMTIME structure. Also you need to use Language Identifier Constants and Strings and Day, Month, Year, and Era Format Pictures topics for setting language and format of date and time. Here is...
xpages,lotus-notes,lotus-domino
Ok, i found the issue... After 3 times copying the Database and rebuilding the index it now works... it seems that the index in the database was simply broken. I dont know why it didnt work the first times when i deleted and created a new index but now it...
lotus-notes,ibm,lotus-domino,lotus-formula,domino-designer-eclipse
Avoid the "would you like to save?" dialog box. Save your document after you changed all fields in your button. @Command([EditDocument]; 1); FIELD Counter := Counter + 1; @PostedCommand([FileSave]); @PostedCommand([EditDocument]; 0); ...
lotus-notes,lotus-domino,lotusscript,lotus,domino-designer-eclipse
1) Add Call doc.Save( False, False ) after doc.addrfield = myText. Only this will save the changes you made in document. 2) + 3) Create a form "Main Topic" in Domino Designer and add the fields you want to see when opening a document which has field Form = "Main...
excel,vba,excel-vba,lotus-notes,lotus
You mention that you are using Notes 9, so I looked at the online help for Notes 9.01 and the help page for the OpenMail method says Note: This method is supported in LotusScript® only. For COM, use OpenMailDatabase in NotesDbDirectory. Now, you're actually using the OLE automation classes (rooted...
The NotesFactory class has two createSessionWithFullAccess methods, but they don't allow you to specify a host. For remote Domino servers accessed via DIIOP, I think what you're trying to do isn't directly possible. There is a workaround that would require some development on the target Domino server. Someone could write...
java,eclipse,eclipse-plugin,lotus-notes
In case anyone is running into a similar situation, we solved the problem as follows: We Started the client in debug mode "C:\Program Files (x86)\Notes9\framework\rcp\rcplauncher.exe" -config notes -console The console log showed us that a dependency, the jUnit plugin, was not available on the client. We moved the jUnit tests...
You have to create this hidden field in your form, not in view. Use the formula @Abstract([TextOnly]; 1000; ""; "ProposedRes") After you added it to your form you have to recalculate all documents so that this hidden field gets filled. As an alternative you could write an agent which sets...
This example works for me: Action button "Test" in view (LotusScript) Sub Click(Source As Button) Dim session As New NotesSession Dim db As NotesDatabase Dim col As NotesDocumentCollection Dim doc As NotesDocument Set db = session.CurrentDatabase Set col = db.UnprocessedDocuments Set doc = col.GetFirstDocument While Not doc Is Nothing Print...
Do you want to change it for yourself? Or for all users of the app. For just your notes:// links, or for all? It's controlled by a registry setting: HKEY_CLASSES_ROOT\Notes\shell\open\command. If you have the rights, changing that setting will change it for all Notes links. The normal binding (without the...
For Lotus Notes dialogs and picklist there is nothing you can do - it is Windows application, so dialog windows inherit look&feel from operating system. You can alter look of content in dialog boxes by making your own layouts, though. I have removed xpages and css tatgs - as mentioned...
outlook,lotus-notes,attachment,lotusscript
Save the attachment using Attachment.SaveAsFile, then open the MSG file using Namespace.OpenSharedItem.
You are right: Both kind of documents have form Memo. Chat- Transcripts in addition have an item $IMTranscript that identifies them. I found out this fact, using the Icon- Column of the All Documents- view ($All), as Chat- transcripts have different icons in that view. Here is the relevant part...
xpages,lotus-notes,lotus-domino
You can add a Web Site Rule that sets the Expires header (and other HTTP headers). Here's an example of a web site rule that sets the Expires header to 14 days for all files of type jpg: ...
xpages,lotus-notes,acl,lotus-domino
Comment of 12/02/2015 seems to be the correct Answer: Check if the self-registrated user has TWO consecutives spaces in his name, (could be because trailling space too) In group domino do a FullTrim. So we have John<space><space>Smith that is not in group XXX because in the members it's: John<space>Smith. ...
This is not possible. This form is hardcoded in the client and cannot be modified.
NotesDateTime.DateOnly property returns a string value, so you need to convert this value to date value by using DateValue function: 'Your code. Set item2 = doc.ReplaceItemValue("TempoFechaRecordatorio01", DateValue(nuevoRecordatorio)) 'Your code. Also you can use date values directly: 'Your code. vDate = doc.GetItemValue("TempoFechaRecordatorio01")(0) vDate = vDate + 15 doc.ReplaceItemValue("TempoFechaRecordatorio01", Datenumber(Year(vDate), Month(vDate), Day(vDate))...
If you add a JAR to your project by importing it into /Code/JARs, it should be added so as to be accessible by your build path(2,3). The same is true of your /WebContent/WEB-INF/lib, but that may not be automatically defined in your version of DDE; for example, Domino Designer 9...
Use getResourceAsStream() instead of getResource(): import javax.swing.ImageIcon; import javax.imageio.ImageIO; ... InputStream stream = this.getClass().getResourceAsStream("/ntf.gif"); ImageIcon icon= new ImageIcon(ImageIO.read(stream)); Put the resource files in Java Agent into folder "Res" with button "Import / Resource": You'll see the files in Package Explorer like this then: ...
I am not a smart man. My problem was that I had not yet called NotesInit(). Once I did things started to run much better.
lotus-notes,ibm,lotus-domino,lotus-formula,domino-designer-eclipse
Add a field "Counter" of type "Number" with a Default Value formula 0 and a button "add 1" with formula FIELD Counter := Counter + 1 to your form....
One issue is that in your Print statement you are accessing the first index (i.e. index 0) of the array for tmpArray3 and tmpArray4. You need to put a variable in there instead. For example: Do While doccount1 < 11 AND Not v2entry Is Nothing ReDim Preserve tmpArray3(tmpcount3) ReDim Preserve...
lotus-notes,lotus-domino,domino-designer-eclipse
Mixed versions of domino server and clients can be used and actually have been used for a long time. Certainly only the intersection set of features of these versions can be used.