Vadim M. wrote

on Tuesday 18 April, 2017 at 20:03:31 UTC

You can try my free apps for IBM (Lotus) Notes/Domino. I work with they many years and think it could be useful for somebody else.

The app Reports Wizard allows you to create reports using data from documents of databases IBM Lotus Notes?

http://www.notesapps.org

Reply »

Ralph P French wrote

on Wednesday 08 March, 2017 at 16:17:37 UTC

Is it possible to limit a user or set of users from creating replicas from certain databases in Lotus Notus?

Reply »

Mike wrote

on Thursday 20 April, 2017 at 17:31:39 UTC

You can temporarily disable replication, or set replication settings that would send little to nothing down to a local replica.

use groups in the nab and add to the acl wrote

on Monday 01 May, 2017 at 18:49:11 UTC

in the acl, turn off copy or replicate documents

Maribus wrote

on Thursday 11 May, 2017 at 15:03:40 UTC

Yes, databases have permissions about creating replicas.
Disabling ?

Anthony wrote

on Thursday 02 March, 2017 at 15:13:43 UTC

We have 2 domino server v9 in a cluster. We need to ensure that any database created on one server is automatically created on the other server. I managed to achieve this when registering a user through Domino Policies but I would like to achieve the same results for all databases created on the server. Is this possible ?
Thanks in advance.

Reply »

Mike wrote

on Thursday 20 April, 2017 at 17:39:57 UTC

It's possible. But there would be some delay in detecting the database.

The Notes API allows you to scan through every database looking for new databases, then replicate the database to another server.

You'll probably want to exclude say, system databases and such.

I wouldn't advise running such a thing very often, because it'll scan through everything on the server. And that takes resources. Maybe overnight, or every 8 hours, or something like that.

That should be handled with care instead of automation wrote

on Monday 01 May, 2017 at 18:51:11 UTC

try one of the best practices in DDM to check for cluster replicas

Jon wrote

on Friday 10 February, 2017 at 15:37:33 UTC

Oh how I miss Lotus Notes. My company just moved to Office 365 / Outlook and everyone hates it. It's not a matter of getting used to it - it is just not as efficient and simplified.

Reply »

Mike wrote

on Tuesday 14 February, 2017 at 14:26:33 UTC

I feel the same way. After spending hours searching my email for info, I've given up. Anybody wants me to know something they'd better send it to me when I need to know it.

Rudi Knegt wrote

on Wednesday 01 March, 2017 at 07:17:34 UTC

don't forget the loss of functionality as well.
The MS environment simply can do less, and has less safety. I've not seen any virus outbreak through email on a Notes installation in 25 years. I've seen and heard (first hand) of oh so many on the MS front. Nobody cares when that happens, they simply blame something else.

John wrote

on Wednesday 01 February, 2017 at 15:06:46 UTC

I have auditors who are asking for a report showing any changes to a LotusNotes application during a certain time range. How can this be done

Reply »

steve wrote

on Wednesday 01 February, 2017 at 15:24:59 UTC

If you haven't kept a record of development changes then you won't have this.
If you need to know specifically whether a form etc behaved in a certain way at a certain time, then you would need to restore from backup and manually check the code.

Mike Woolsey wrote

on Thursday 02 February, 2017 at 14:28:45 UTC

If they're asking for the changes to documents, unless the app disables it you can report *which* documents changed in a certain time interval. The $Revisions field lists timedates when a document changed.

It's tougher to tease out *who*. The $UpdatedBy field is a condensed listing of who changed things, in turn. But if there're multiple changes by the same person they may've been uniqued-out.

This feature is enabled, standard, but it can be changed. If you limit the size of these fields, your ability to report from them will be limited.

Unless you're preserving deletions, they are not represented. This is why I normally enable soft deletions for a week or more -- or better yet, build my own deletion scheme.

Further afield: it's possible to track user activity and match that up with actions taken on the database. I normally track that on the *log.nsf*, not on the database itself, because you can program its retrieval from log.nsf.

Notes also offers the ability to handle *versioning*, which is a tremendous ability given the disk space. Your design will need to figure out how to display its versions, and that can complicate your life. But it's a terrific ability to hang onto every change. I wish it were in Xpages.

Patrick Sawyer wrote

on Monday 17 April, 2017 at 21:36:52 UTC

You can add a script to the form that would capture field changes, but this can only be done moving forward not backwards. Let me know if you are interested.

Taija wrote

on Friday 27 January, 2017 at 09:40:29 UTC

Hi,
I have Notes document application that uses categories and subcategories to organize the documents. I can use "select @all" to select all the docs, I can use "select categories = "category name"" to select one category - but then the subcategories are left out. The command "select categories = "category\subcategory"" doesn't work. What would be the syntax to include also the docs in the subcategories or even to select the docs in them only?

(Lovely site :)

Reply »

Thomas wrote

on Friday 27 January, 2017 at 13:42:10 UTC

You should do something like this:

select categories = "Categories name" | categories = "Categories sub name1" | categories = "Categories sub name 2"

Taija wrote

on Monday 30 January, 2017 at 12:18:27 UTC

Sorry,
select categories = "Top category" | categories = "sub category"
returns only the documents in top category.

Mike Woolsey wrote

on Thursday 02 February, 2017 at 14:30:45 UTC

Try

select categories = "category\\subcategory";

(The backslash is an escape character for @Formula)

Taija wrote

on Monday 13 February, 2017 at 13:24:30 UTC

Thanks!

This did it! :)

Rudi Knegt wrote

on Tuesday 28 February, 2017 at 09:11:04 UTC

you can also use
Select Categories *= "category" : "category\\subcategory1" : "category\\subcategory2" if you need more then one categroy to be selected.
The *= is a list operator in @formula

Mike wrote

on Monday 23 January, 2017 at 21:13:04 UTC

I've been working through SOA and Notes together. What strikes me is all the rigging it takes to set up an environment that'll just kinda run in SOA, while Notes' integrated environment makes the connections pretty straightforward.

With SOA you have to get so much connected & running before writing a line of code. But with Notes, the data you can access is just there to use.

Reply »

Mallik Ram wrote

on Monday 05 December, 2016 at 12:44:26 UTC

Hi,
We are facing issue with Submit button that works like a charm on Windows OS. The same does not respond on a Macbook Pro.

The Submit button has @Command([FileSave]) in the query save event we have lotus script code.

Does formula language and hide formulas work on a ma?

Reply »

Mike wrote

on Thursday 15 December, 2016 at 14:29:48 UTC

Uh -- it's the server that actually runs the Submit button's formula. All the client browser does is ... issue the Submit.

A lot more would need to be discussed, such as whether your app uses Javascript to issue this button, and whether the MacBook browser is enabled for Javascript, and so on.

With browsers, you get what you pay for. And they're worth every penny.

Mike wrote

on Thursday 22 December, 2016 at 14:24:40 UTC

(I think I responded earlier, but sometimes it doesn't get through the interweb.)

The Submit button code is being run by the server, so it's not specifically the problem. If the browser gets to the point of launching the Submit button, then it's run onserver.

More likely there is some Javascript upstream of your button. Maybe the Web page tries to run the Javascript on-page, and it fails to complete / generates an error on Safari.

There's a lot of browser-specific code out there. Frameworks support more browsers, but they're a learning task unto themselves, and there are a lot of choices.

I'm sorry this leaves you with some digging to find the issue, but I hope it points you in the right direction.

Marilyn wrote

on Friday 25 November, 2016 at 19:47:20 UTC

Hi... I am wondering if there is a way to trap incoming HTML emails and detect presence of a URL; i.e., <a href="www.test.com">ABC Inc</a>. I can see this raw HTML in the body of the message but when I try to access this programmatically via the NotesRichTextItem Class, it does cannot see the "www.test.com". The only thing i can search for is the text portion which is "ABC Inc". Please help.

Reply »

Mike wrote

on Thursday 08 December, 2016 at 13:37:39 UTC

I'm not sure of the nature of the issue.

Is the rich text MIME? An HTML MIMEPart can be inspected through some objects in the Domino Object Model. I normally use 'em to create a MIME email, but I'm pretty sure the reverse can also be done.

Sam Sirry wrote

on Tuesday 13 December, 2016 at 02:07:29 UTC

Use the MIMEEntry classes. They should help you achieve what you want. I haven't used them myself so I cannot provide more info....

CJ wrote

on Friday 25 November, 2016 at 13:21:41 UTC

We use a teamroom that we have been provided and I would like to know how the backup / recovery scenario works, and whether it is possible to take a copy of that Teamroom and hold it on a local client as a backup (as well as using a local replica on the same client)

Reply »

Mike wrote

on Thursday 08 December, 2016 at 13:39:56 UTC

Normally a client refuses to hang onto two replicas on one client (or server, btw). So in principle I'd say no, don't do this if they're both replicas.

That said -- it could be possible to launch a Notes client to point to two different data directories if you seriously needed to run both. They wouldn't run at the same time.

Karl wrote

on Monday 12 December, 2016 at 21:07:01 UTC

It depends on your setup of course. But most organizations do have some sort of backup that also gives you an easy restore option. This is a question for your IT department.

With that said, you also have the option to make a local copy of the (any) database as well as a local replica. Although to create a new copy is not an automated process and is needed to be done manually every time you want to make a new backup of the latest information.
To create a new copy - When in the Teamroom db - Click "File/Application/New Copy.." Give the db a name, select a folder on your hard drive to store the db. Done!
Note! This is the way you should copy a database, do NOT just copy the database from within the file system (windows explorer etc.) since that makes the database a local replica instead of a new copy since that gives the database the same replica ID.

Tomas wrote

on Friday 25 November, 2016 at 11:15:35 UTC

I've heard that IBM have now confirmed that the next release of Domino is going to be the last major version of the software to be released. Is this correct?

Reply »

Andreas wrote

on Wednesday 30 November, 2016 at 20:01:56 UTC

IBM is changing his product release publishing from a big main release manner to a more agile and faster way with feature packs. Feature packs includes fixes and new features. On the other hand there are template packs available - if a feature pack offers new functions wich affects a template.

Sam Sirry wrote

on Wednesday 07 December, 2016 at 14:18:06 UTC

There was an announcement that IBM will continue to support Domino & Notes until 2021 at least. But no more details about major releases or otherwise.

Thomas wrote

on Wednesday 08 February, 2017 at 08:53:22 UTC

It's correct - as Windows 10 is the last version of Windows. Or Google Mail, which never had "major" releases/release numbers.

As Andreas wrote: They are changing, how we get new functions in the software - fast feature packs instead of a new major release after 1 to 3 years.

Ivan wrote

on Friday 17 March, 2017 at 22:30:58 UTC

Haha, this I hear since time or so called RNext - Release 6 as far as I remember... dont worry, Notes will live another decade, so many companies still using it.

Tom Hamilton wrote

on Wednesday 09 November, 2016 at 17:05:49 UTC

Hi all - I've been asked to put an automation together to save attachments from our email system. I'm looking for resources for programming Lotus Notes 8.5.3
Scenario: several hundred (>500) emails arrive each month via a secure process (Accellion). I need to detect the arrival, extract the attached files which can be zip or xls/csv format.
I appreciate any direction or resources - thank you

Reply »

Mike Woolsey wrote

on Thursday 10 November, 2016 at 18:25:49 UTC

The Domino Object Model is where you want to go.

There are useful ways to retrieve documents that arrive in an inbox: a collection of unprocessed docs can be handed to either LotusScript (read: BASIC) or Java using the (Notes)Database.UnprocessedDocuments method. Once there, you can process document by document and get a list of (Notes)Document.EmbeddedObjects.

This is the recommended method -- if the attachments appear in the email as embedded objects ("above the horizontal line").

It's possible your email does not embed the attachments. In that case the strategy changes, and I would recommend you stick with LotusScript to try this next attempt. LotusScript can hand you the attachment names when you ask for the value of each "$File" item (e.g., using NotesItem.GetValues(0) ). From there you can use NotesDocument.GetAttachment("filename") and extract each file. The docs lead me to believe this is not available in Java.

If you need help scanning through a folder or a database the Help documentation has a short tutorial on how most LotusScript agents scan views, search collections, & etc. It's short, it's very practical, and highly recommended.

Inotes new them wrote

on Monday 07 November, 2016 at 07:54:03 UTC

Hi,

Is there any other template for inotes to use or to buy from a third party. I am using Domino 9.

Reply »

Mike Woolsey wrote

on Thursday 10 November, 2016 at 18:32:33 UTC

I've seen other templates for Notes, but I haven't looked for iNotes in particular.

I've also seen descriptions on how to customize iNotes. Some are in openntf.org.

Karl wrote

on Monday 12 December, 2016 at 21:12:06 UTC

This might not be what you are asking for and you only want iNotes specific info, but there is a new Webmail theme for Notes Domino called Verse. Verse is available today for cloud users but it's in late beta stage today for on-prem installations and will be released soon.

http://www-03.ibm.com/software/products/en/ibm-verse

Frank wrote

on Monday 07 November, 2016 at 02:16:16 UTC

Is there a Lotus Notes API to determine if a document contains an embedded object? For example, an email document where the user used copy and paste to paste a spreadsheet. This typically shows as a gif file in the Louts Notes document.

Reply »

Tom wrote

on Thursday 10 November, 2016 at 15:29:34 UTC

Yes there is. In the Domino DLL, object NotesDocument Boolean property HasEmbedded.

'Check if the document has an attachment or not.
If oDoc.HasEmbedded = True Then

Set vaItem = oNextDoc.GetFirstItem("Body")
If vaItem.Type = RICHTEXT Then

For Each vaAttachment In vaItem.EmbeddedObjects
If vaAttachment.Type = EMBED_ATTACHMENT Then

'Save the attached file into the new folder.
Debug.Print CStr(vaAttachment.Name)
Dim sFile As String
sFile = CStr(vaAttachment.Name)
'If Dir(sFile) = 0 Then ' Check for existing file
vaAttachment.ExtractFile csPath & vaAttachment.Name
'Else
' Dim tdStamp As String
' tdStamp = Format(Now(), "yyyymmdd_hhnnss_")
' vaAttachment.ExtractFile csPath & tdStamp & vaAttachment.Name
'End If
Debug.Print "Extracting " & vaAttachment.Name & " to " & csPath
'Set the e-mail object which will be deleted.
'Set oRemoveDoc = oDoc
End If
Next vaAttachment

End If
End If

Ian Pal wrote

on Thursday 03 November, 2016 at 00:25:36 UTC

Hi,

Specs:

- Creating Private View inside notes designer
- Action Click
- OLE Classes not installed locally on the machine but are installed on the server machine

Question 1
I am wondering if anyone knows how to reference OLE classes via view inside an action i can see the classes in the reference tab under OLE Classes that i want to use problem is i cant seem to reference them? Eg Acro and HTML classes
using create object i assume?

Question 2.
Could the create object not work because i do not have the OLE class libraries installed locally and if i do need them locally then how would one make it link to the notes designer?

Reply »

Mike Woolsey wrote

on Thursday 03 November, 2016 at 22:07:15 UTC

CreateObject() is normally what I use. Then you don't have compile-time success that later crashes when you're on a machine that doesn't have the classes installed, you can check for runtime errors or null handles.

I always used locally-available COM objects, so if that's your situation, yes, that could be an issue.

I remember there was once DCOM ... I don't know, I never got it to work very well.

Tim wrote

on Friday 28 October, 2016 at 21:47:31 UTC

Whats the easiest way to fix a corrupt $inbox?

Reply »

Mike Woolsey wrote

on Thursday 03 November, 2016 at 13:38:23 UTC

It depends on the corruption, but the easiest, first attempt is to open it & press Shift-F9. This'll rebuild the collection if the collection is corrupted.

If the folder design itself is corrupted, it's more involved. Make a backup copy of your current DB, no docs, to a template (when copying, give the empty copy a .ntf extension not a .nsf). Go back to the DB itself. Create a new folder & drag out as much of the contents as you can. Then design the folder, delete it, and replace design from the standard template (not your backup) back into the DB to restore the folder.

Sam Sirry wrote

on Friday 28 October, 2016 at 18:13:40 UTC

I love Lotus Notes, and I love to use the "Lotus" brand name despite IBM's attempts to wipe it out.

Notes is my personal favorite database storage system. My personal tools & utilities are built with Notes. Seriously, I cannot imagine using any other system with the same versatility.

One thing that makes me sad about Notes is that it is made in a country where the law there considers me a bad inhabitant of the planet just because I carry a passport from a certain country, and I am no longer allowed to purchase licenses, but still I know that the people of Lotus who originally created Notes did it for the good of the whole humanity.

Notes will last forever.

Reply »

Sam Sirry wrote

on Tuesday 18 October, 2016 at 08:22:18 UTC

Hello..
I can't seem to find statistics showing the operating systems on which Domino Servers are installed.
I mean, the general IBM customer base, how many use Windows, Linux, other? Any idea?
I'm only looking for data regarding the Domino server.

Thanks

Reply »

Mike Woolsey wrote

on Monday 07 November, 2016 at 15:26:35 UTC

I don't know that IBM produces stats. From the significance of the bugs & speed they're found, I'd say Windows is overwhelmingly primary, then Linux, then one of IBM's Unix series (mq? i? not sure of the terminology). Just based on the sophistication of the issues I've heard under discussion.

Mark Crosby wrote

on Friday 14 October, 2016 at 21:24:31 UTC

For some reason I can't reply to "Create lotus notes email but don't send" dated 25-SEP-2016. Perhaps that "name" is too long.

Anyway, if Notes is you default email client, but create a link with a URL like this:

mailto:foo@bar.com&subject=whassup%20yo&body=this%20is%20the%20body

You need to make the replace spaces and other special characters.

Reply »

Edward Perrier wrote

on Friday 14 October, 2016 at 21:21:39 UTC

Hello,

I need alittle help. I have Lotus Smartsuite 9.1 and I need to convert it to excel or to sharepoint.

Please contact me at eperrier@crystaldataservices.com

Reply »

Mike Woolsey wrote

on Monday 03 October, 2016 at 19:53:34 UTC

Opening Mail in Notes (Fradiocey) --

There's a variety of ways of opening a mail doc in Notes. Probably the most straightforward is to launch a "mailto:" link. This should allow you to set a subject line -- I don't remember if it's enhanced to also let you specify some body text, but I do remember it'll handle the subject.

If you really want to enhance it further, yes, Excel VBA will happily load Notes objects in COM. However, this requires more extensive coding than "Hey, pop up an email."

The Help documentation has a section, "Using OLE", that describes how to get the main objects. You'll actually need both NotesUIWorkspace (to display a doc in Notes) & NotesSession (to retrieve the mail DB path).

I know in earlier versions it was also possible to simply hand Notes an @Command; I don't see that in the documentation any more, but it may still work.

Reply »

Sam Sirry wrote

on Thursday 27 October, 2016 at 22:51:06 UTC

@Commands cannot be invoked thru VBA, but the simple answer still involves a bit of coding. Here are the general steps (for VBA):
1) Get a handle to the notes session. This involves authenticating with an ID.
2) Get a handle to the mail database, like this:
Dim maildb As New NotesDatabase("", "")
Call maildb.OpenMail
3) Create a new document object in the mail database. Set the form as "Memo" and any other fields as desired. You don't need to save the document.
4) Open the document using the notesuiworkspace. I didn't check, but this step is probably not be possible from VBA; in this case you might want to create your own interface for entering data in the fields...

Reportgunner wrote

on Monday 06 February, 2017 at 15:17:12 UTC

Sub mailsender(EmailRecipient as String, EmailSubject as String, AttachmentPath as Strin)

Dim Maildb As Object
Dim MailDoc As Object
Dim Body As Object
Dim Session As Object

'Start a session to notes
Set Session = CreateObject("Lotus.NotesSession")
'This line prompts for password of current ID noted in Notes.INI
'Call Session.Initialize
'or use below to supply password of the current ID
Call Session.Initialize("Pernikopotulnik9")
'Open the mail database in notes
Set Maildb = Session.GETDATABASE("", "C:/Notes/Data/archive\a_CZZ6197A.nsf")
If Not Maildb.IsOpen = True Then
Call Maildb.Open
End If
'Create the mail document
Set MailDoc = Maildb.CREATEDOCUMENT
Call MailDoc.ReplaceItemValue("Form", "Memo")
'Set the recipient
Call MailDoc.ReplaceItemValue("SendTo", EmailRecipient)
'Set subject
Call MailDoc.ReplaceItemValue("Subject", EmailSubject)
'Create and set the Body content
Set Body = MailDoc.CREATERICHTEXTITEM("Body")
Call Body.APPENDTEXT("Body text here")
'Example to create an attachment (optional)
Call Body.ADDNEWLINE(2)
Call Body.EMBEDOBJECT(1454, "", AttachmentPath, "Attachment")
'Example to save the message (optional)
MailDoc.SAVEMESSAGEONSEND = True
'Send the document
'Gets the mail to appear in the Sent items folder
Call MailDoc.ReplaceItemValue("PostedDate", Now())
Call MailDoc.SEND(False)
'Clean Up
Set Maildb = Nothing
Set MailDoc = Nothing
Set Body = Nothing
Set Session = Nothing

End Sub

Neill wrote

on Sunday 02 October, 2016 at 20:39:07 UTC

Hi -
I'm creating a system in c# using pmengal/MailSystem.NET to download emails from a domino server using IMAP. I'd prefer to not tie the system to LotusNotes (LN) too much so that is why I'm favouring IMAP.

So my system is going to download new emails via IMAP, but then I'd like a way for the user to click on a link which will take them directly back to their email within the LN client. I've debugged in Visual Studio to see if I can extract the key components that will allow me to build up the following url. This is the format of the URL which LN creates when you drag an email to your desktop:
notes://ServerName/PathIfNeeded/DatabaseName/ViewNameOptional/DocumentIDOptional

I can think of only one way of doing this and that is to create an pre-delivery agent that adds the link above to all emails that are received? Then my program then extracts that from the email. I'm reluctant to use the Domino SDK as there are few resources out there on it.

Any help would be appreciated.

Reply »

Mike Woolsey wrote

on Thursday 27 October, 2016 at 16:23:09 UTC

Um, there's quite a bit of resources on the Domino SDK if you need it.

I'm not sure exactly what you're looking for. Once you're limited to IMAP, I'm not aware of something in IMAP that can hand you back identifying information or even other metadata about the document. But that's IMAP, I would think. Is there such a thing? What can IMAP give you?

That seems to be the limitation. As for the URL format, you have more options, but if you can't get more metadata through the IMAP piping, I'm not sure it'll help.

If you can get the Document's UNID and the location of the database -- or just the server/DBID of the database, either one -- the view itself is optional -- it could simply be "0".

So for instance, you could also have a URL that opens the email like this:

notes://servername/DBID/0/DocumentUNID

TimC wrote

on Friday 30 September, 2016 at 18:38:28 UTC

Has anyone used Powershell or another scripting language to take a text file with group names and create the groups in the NAB? If so please share the code!

TIA

Reply »

Mark Crosby wrote

on Tuesday 04 October, 2016 at 18:03:43 UTC

Not exactly what you asked for, but a possible solution could be to create a .CSV file with the fields you want to import to the Group document. Names would be separated by semi-colons. Create a .COL file to define the mapping of .CSV values to Group form fields. Import the .CSV file as Tabular Text and specify the .COL file in the import dialog box and you're done!

https://www.ibm.com/support/knowledgecenter/SSVRGU_8.5.3/com.ibm.designer.domino.main.doc/H_ABOUT_WRITING_A_COL_FILE_FOR_A_TABULAR_TEXT_FILE.html

akil wrote

on Friday 30 September, 2016 at 10:26:38 UTC

is there any way to create dynamic fields and bind it using xpage lotus notes

Reply »

PetiAti wrote

on Wednesday 28 September, 2016 at 11:26:46 UTC

I'm using a LotusScript to export data from Notes to Excel. When I tried it on Mac it doesn't work because it cannot create the Excel object. How can I export data on Mac?

Reply »

Mike Woolsey wrote

on Thursday 29 September, 2016 at 14:49:50 UTC

I can't really tell you what Apple's letting applications do nowadays, because I just don't get much call for it. I've noticed a number of people having problems intercommunicating on a Mac. I'm inclined to view the issue in reverse.

If there's such a thing on Mac maybe it can be accomplished in reverse from what you're expecting Notes to do. Or maybe, learning what Excel can do with Notes objects, you might be able to apply the results back into LotusScript BASIC.

What facilities does Excel for Mac have to communicate? I too k a quick look around & I couldn't find a nice, quick way for Excel to talk to the Notes API. Is there one? Maybe. I just can't find one.

Is there an interoperation protocol Excel can use to call Notes objects? VBA can do this on Windows. I've actually done it over COM. And LotusScript being a "super-VB", it does this too.

Joe Brender wrote

on Friday 14 October, 2016 at 14:13:14 UTC

I have a similar experience doing this on an iSeries server, where you can't use Excel OLE. The answer is Java POI. It allows you to create, export, import and modify excel sheets without having excel installed.

https://poi.apache.org/

Create lotus notes email but don't send wrote

on Sunday 25 September, 2016 at 14:46:08 UTC

I'm really stumped with Lotus Notes and wondering if anyone has code that can be run from Excel or Word using VBA. I just want to create a blank email and populate the subject and body text and that's it. I don't want to send it but I need it to display on the screen so the user can complete it.

Reply »

Fradiocey wrote

on Friday 23 September, 2016 at 04:27:50 UTC

Hi, is it possible to get client mobile operating system & version information from lotus script? I tried using @Platform but no luck. Thanks

Reply »

Khader Quraishi wrote

on Tuesday 04 October, 2016 at 17:07:12 UTC

Please try @browserinfo("Platform") and see.

sidney wrote

on Thursday 22 September, 2016 at 15:54:12 UTC

Can someone tell me if its possible to vreate a user account and automaticly add db's to his or her workspace? im new to Notes but it is really time consuming to add 30 db's for each new user. and if so, is it also possible to create local replicas automaticly ? im looking for something like a user template. please let me know

Reply »

ilovelotusnotes wrote

on Thursday 22 September, 2016 at 16:07:34 UTC

yes that's possible. a number of ways to do this, but you'll need a Notes developer to get this right for you. you may also want to consider a single database used as an entry point to all those apps - like an intranet home page. I'm not sure of any specific templates for this - but you could create something that looks awesome and is specific to each user...

Sidney wrote

on Thursday 22 September, 2016 at 16:29:32 UTC

The rights some will give me and we aklready have something like a homepage with some links but i want to use the workspace for this, is there some documentation regarding this ?

Joe wrote

on Thursday 22 September, 2016 at 16:53:41 UTC

Try using a "Setup" policy. It lets you add databases to bookmarks automatically. If you google around the policy stuff, you can figure out how to do replication as well.

Mark Crosby wrote

on Wednesday 28 September, 2016 at 22:08:15 UTC

You can also use Policies to do this. Check out the Desktop Settings policy documentation

https://www.ibm.com/support/knowledgecenter/SSKTMJ_8.5.3/com.ibm.help.domino.admin85.doc/H_CREATING_A_DESKTOP_POLICY_STEPS.html

Lance Manion wrote

on Thursday 15 September, 2016 at 01:18:49 UTC

I have some very old Lotus Notes email files that I'd like to access, but I can't seem to find a solution. I don't know what Notes version they were created in, but the files are well over 12 years old.

All I want to do is load a version of Lotus Notes on my personal PC so I can read those files. I don't need database functionality. I don't need to send/receive email. I don't need any networking capabilities. Just the ability to open and read old lotus notes email files. I can't seem to find any solution. Do you have any idea how I can accomplish this?

Thanks!

Reply »

ilovelotusnotes wrote

on Thursday 22 September, 2016 at 16:08:45 UTC

You should be able to open the oldest mailbox in the latest version of Lotus Notes as far as I am aware (although not tested this to be honest).

Joe Brender wrote

on Tuesday 27 September, 2016 at 17:44:46 UTC

Notes 9.0 is backwards compatible all the way back(they all are), so versioning is never a problem. Don't worry about "old files" not opening in a new client.

I think the biggest problem would be having an id file that has access to those 12 year old files. If they are your mail files, it shouldn't be a problem. Install Notes and use your id file to login to notes then open the files. If it was your work mail from Company A, and your work email from Company B, and the id expired on both, then you're not going to get those files open without a certifier ID.

Mark Crosby wrote

on Thursday 29 September, 2016 at 16:41:22 UTC

I think you "just" need to get a copy of the Lotus (IBM) Notes client installed on a PC and open the mail files locally. You can get the Designer client for free now, but the end user client isn't free. Notes has been pretty good about backwards compatibility, so any Notes client created since the one that created the mail files was released should work fine.

What Joe B. said is true, but only if the database was encrypted using the old ID. If you copied the mail files from a server at the OS level, then chances are they aren't encrypted. If they were local replicas on someone's PC, then they very well could be.

Joel wrote

on Friday 30 September, 2016 at 05:05:02 UTC

One issue I think you're likely to run into is encryption. Notes e-mail files typically have encryption keys in them to prevent exactly what you're trying to do (someone downloading the file and then opening it without having a Notes Id with access to the file.

If this is an issue, you'll probably need the certifier Id used to originally sign the e-mail database file in question. All of the administrative functions to resolve the problem of not having access to an old file require the certifier id (even to re-sign the database with another certifier) for security reasons (so someone can't simply copy the database to their local hard drive and then open it with no security check).

Teh Hong wrote

on Wednesday 14 September, 2016 at 11:16:28 UTC

I need some help and advice. We have a script that open an Excel file in Windows with its path stated e.g C:\excel.xls but this is not working for Mac. How can I open an excel file; THexcel.xls say in "\User\TH\" in Mac? Thank you.

Reply »

Matt Fitzner wrote

on Thursday 08 September, 2016 at 19:43:39 UTC

congrats to your site!

Do you know any Voip plugin solution that can use embedded Sametime Client and can be connected to Asterisk? Like ilink - but ilink does not Support or implement with Asterisk..

Thanks for joining ypur knowledge.

Reply »

Victor wrote

on Thursday 08 September, 2016 at 04:34:00 UTC

Can't find information regarding mail enabled workflow applications in lotus notes and sending to exchange 2013. There must be some setting? or would I need to modify my lotus script code? for doc.send or @MailSend functions?

Reply »

Mark Crosby wrote

on Thursday 29 September, 2016 at 16:56:17 UTC

Notes applications will send emails depending on how the Notes client is configured for mail. Typically the client would be configured to have a mail going through a Domino server. The Domino server can be configured to connect internally to an Exchange server. However if there is not Domino server involved, Notes clients can be configured to use non-Domino servers for POP3, IMAP and SMTP. These connections are configured in the Advanced settings views of the local Name & Address Book (names.nsf) on the Notes client

Neill wrote

on Wednesday 07 September, 2016 at 14:03:19 UTC

I'm looking to find out whether it is possible to create a To Do item using the SDK preferably in C#. Or even to create an agent to convert an email into a ToDo item automatically if the subject contains particular characters/codes.

Reply »

Joel wrote

on Friday 30 September, 2016 at 05:11:27 UTC

You can do it with COM as the example shows (it creates a calendar entry, but the process is the same). If you have code currently to create an e-mail, you're just going to be changing the Form field and a few others (easiest thing to do is open the To Do field in a calendar using the Domino Designer and check the fields that exist there. Some will be optional, but especially look over the hidden fields and understand what they do - which ones should be set for your ToDo item to work properly).

http://www.codeproject.com/Tips/130179/How-to-Add-a-Lotus-Notes-Calendar-Entry-with-C

Neill wrote

on Sunday 02 October, 2016 at 20:04:28 UTC

Thanks Joel

Rusty wrote

on Thursday 01 September, 2016 at 00:05:13 UTC

Is there a way to copy a custom view of a locally replicated database to another machine? We do not use any communication features in Lotus, only database management.

I have a killer custom view that others I work with would like to have, but cannot build it on their machines (field employees spread over the nation).

Can it be done?

Reply »

Steven Elwell wrote

on Wednesday 28 September, 2016 at 17:17:02 UTC

Depends on if the view is stored in the database or in your desktop.dsk

Mark Crosby wrote

on Thursday 29 September, 2016 at 17:04:58 UTC

When you said you "do not use any communication features in Lotus", does that include Replication?
Given the limited information provided I am going to speculate that you have an application that is being used by employees around the nation and that the data in the application is shared via replication.
You can (with the appropriate ACL rights) use the Domino Designer client to copy the view from your local db and paste it as a shared view in the server's replica copy. The replication task will distribute it for you, assuming the replica settings send design changes as well as data changes.

Joel wrote

on Friday 30 September, 2016 at 05:23:01 UTC

If the view is not a private view (if you created or can create it as a global view), you can add it to the server version of the database (or the template that database uses, and update the database from the template). The users will have to replicate from the server (I presume they're already doing this/know how to replicate data from the server?) to pick up the design change.

Another option is that you can create a database with a Page and a button that uses LotusScript to perform a design refresh on the other database. You would send that database to each user via E-mail. This method involves a bit of programming however, and is not trivial.

R.X.Britto wrote

on Wednesday 17 August, 2016 at 14:13:19 UTC

Is there a way to search this site?

Thanks

Reply »

Rusty wrote

on Thursday 01 September, 2016 at 00:02:57 UTC

I always use Ctrl+F and use the browser's search tool.

Neill wrote

on Wednesday 07 September, 2016 at 14:06:42 UTC

try.. putting this in a google search and it will search this website...

Domino run Wordpress site:ilovelotusnotes.net

AndrewK wrote

on Thursday 28 July, 2016 at 00:04:30 UTC

I have Excel VBA that creates and email in Lotus Notes from data in the spreadsheets, graphics and text and allows the user to view it before they send it.

I need a way of sending an email from Excel 2016 to Lotus Notes on a Mac. I am using COM on Windows.

I have seen Lotus Notes command line commands to open a new email but I can't populate the contents of the email.

I've looked at command line, AppleScript and LotusScript.

Any ideas please ?

Thanks

Reply »

Lance Z. wrote

on Friday 12 August, 2016 at 14:25:29 UTC

Did you try Command Line EMail Client for Lotus Notes (CLENotes)?

https://www.openntf.org/main.nsf/project.xsp?r=project/Command%20Line%20EMail%20Client/releases/6C2337C95ABF075786257F490026B730#dummy

Nubia Dear wrote

on Friday 22 July, 2016 at 15:38:50 UTC

Very nice and informative article here. Cool to read such a well-considered article! BTW, if anyone needs to merge PDF/PNG files online, I found a service here "http://goo.gl/WBPXN7".

Reply »

RobertMorgan wrote

on Wednesday 06 July, 2016 at 16:05:47 UTC

Is there any way, application, or plug in available to view saved .msg files in Notes?

Reply »

shane wrote

on Thursday 28 July, 2016 at 04:04:56 UTC

notepad, notepad++, import them in as txt?

BillyG wrote

on Wednesday 29 June, 2016 at 17:32:51 UTC

What happens to the Notes client trial after the 90-day period? Does it stop working or does it just nag?
If I'm trial-ing something out in the field, I don't want it to stop working in the middle of something important before I can get P.O. approved

Reply »

Mike Woolsey wrote

on Wednesday 13 July, 2016 at 14:34:45 UTC

It won't stop working.

Tom Hillebrand wrote

on Thursday 25 August, 2016 at 15:00:00 UTC

It's won't nag you either. It will perform the same.

Sozos wrote

on Sunday 26 June, 2016 at 10:07:17 UTC

Hi All

I have a very annoying issue with Lotus Notes private views. The selection formula I am using is @name([CN];staffName) = @name([CN];'username). So basically restrict the view to display only the specific user's document. However, for some reason every now and again a user will inform me that he cannot see his document. if I save and close his document the document appears in his view. Any advise?

Reply »

Mike Woolsey wrote

on Wednesday 13 July, 2016 at 14:33:12 UTC

Unfortunately, this could be due to the view refresh settings.

I say that's unfortunate because it's a private view. So it's pretty unpleasant to go through the process of re-creating all the private views for everyone everywhere.

I've taken to using single-category views. There's a @SetViewInfo() function that lets you restrict a particular view to one category. They y'just categorize by @Name([CN]; @UserName).

Still, there are drawbacks: the "alternate sorting" features don't work.

Also, one tradeoff is performance, but it's not a direct tradeoff. If your database is huge, @SetViewInfo will block everything while it tries to open the view the way you want the user to see it. OTOH, each activity keeps the view up to date for everyone. So it can be a trade to your advantage.

Akil wrote

on Tuesday 21 June, 2016 at 06:41:53 UTC

How dow pull attachments from SQL server to lotus notes and create a document with attachments

Reply »

Mike Woolsey wrote

on Wednesday 22 June, 2016 at 14:05:29 UTC

It's really a question for Microsoft side.

With Notes there's a NotesEmbeddedObject class that'll let you attach files into a document.

Mike Woolsey wrote

on Wednesday 29 June, 2016 at 14:05:01 UTC

There's an "EmbedObject" call for in the NotesRichTextItem class, and attachments are supported in a NotesEmbeddedObject class.

I think the issue is more, how do you pull the document out of Microsoft SQL Server. Check with Microsoft on that.

Mike Woolsey wrote

on Tuesday 12 July, 2016 at 14:05:57 UTC

Hm, maybe my original response got lost in the Web ether.

The NotesRichTextItem object has a nice "AttachFile" method, so ... not a problem for Lotus Notes.

I believe SQL Server stores things as binary objects, which means you have to convert anything stored there into an attachment & save it.

Polymorph Ltd wrote

on Wednesday 15 June, 2016 at 12:00:57 UTC

Here's a solution to a long standing issue with the Lotus Notes client and high DPI displays (e.g Microsoft Surface).
This should hopefully get your Notes apps back to looking great again, it has worked a treat here!

http://www.polymorph.co.uk/content/blog-posts/fix-for-lotus-notes-display-issues-on-surface-pro-high-dpi-1/

Reply »

Rohit Singh wrote

on Friday 10 June, 2016 at 20:37:39 UTC

Hi I have a table in a lotus notes document containing columns Item no., Item Description, Item Quantity.

I have to show this document 5 times in a view of the table has 5 rows with different item no.

And each item row should have the corresponding values from the column.

How do I Acheive this last option of showing only the corresponding value of each item. I am able to show 5 rows in the view if there are 5 rows in the table.

Please help with an example!!

Reply »

Mike Woolsey wrote

on Thursday 16 June, 2016 at 00:25:07 UTC

Try this:
Add a column with your Item Description, just to the right of your Item Number column.

Now **don't** sort or categorize the column.

Check the setting "show multiple values on separate rows".

Again, **don't** sort or categorize the column.

Try this on the simplest view, selecting only the docs you want to display, and with only this set of columns, first.

There are distinct limitations on this kind of view, so don't expect it to work with every other feature. Alternate sorts and sorted columns "in between" can cause tangles. So keep the view pretty straightforward.

Terry Comeau wrote

on Wednesday 08 June, 2016 at 19:38:13 UTC

We us laptops in the field to document claims using apps developed in IBM Notes. The data and forms are replicated back and forth between the server and the laptops. The adjustors can create a summary document to print off and get the client to sign. We'd like to get away from the printers in the field.

How can we create a summary report and get a signature from the client onto that document in the field? And back to the server.

Where would I start?

Reply »

shane wrote

on Thursday 28 July, 2016 at 04:08:10 UTC

COM / OLE to a MSPaint image, using a touch screen would allow them to draw their signature on the screen and it can be saved. Documents Library Database would let you do that.

Mark Crosby wrote

on Thursday 29 September, 2016 at 18:49:03 UTC

I worked with a signature pad from a company called Topaz 15 years ago. An extra piece of hardware is probably not what you want, but they (or someone else) might have a software 'signature pad' that could capture the signature image.
The image of the signature will be unique since no one signs *exactly* the same way each time. This unique value is used in conjunction with the values in the fields you want to secure to create an encrypted signature. Changing any of the values invalidates the signature.
Wow! They still have the code sample I provided to them 16 years ago. (http://www.topazsystems.com/lotus.html)
Looks like they have some software options, I'll include the link below.

http://www.topazsystems.com/downloads.html

DF wrote

on Tuesday 07 June, 2016 at 18:53:43 UTC

Hello, everyone.
Thank you all for responding to a previous question that I had, I greatly appreciate the help.
I do have another strange situation that I could use some assistance with.
One of the environments that I manage has a monitoring server that has an event generator set up that checks the connection to all of the servers (and to the DDM.nsf replica on each of the servers) in the network every 3 minutes. If that connection attempt times out, the event generator is configured to send out an alert email. I should mention that the servers are in different domains, but the monitoring server has valid connection documents to all of them.

The problem that I am noticing is that when I bring down one of the servers, the event generator does not send out the alert email. By watching the JConsole on the monitoring server, I can see that the event generator checks and notices the failed connection, but it doesn't follow up by sending out the message like it should.

Now, here is where it gets weird. If I forcibly restart the event monitor task on the monitoring server, it then sends out that alert about the failed connection....and this could be hours from when the actual event actually happened. It is as if the event generator and/or the event handler message is somehow getting stuck, and only when I restart the event monitor task, does it then release the message that it was supposed to send out when the event first happened.

Now, for some reason, this doesn't happen with every server that the generator is set up to watch. The event generator number is the same, we just added every server that it needs to check to that one event generator (it's only about 16 servers). And, the events4 and DDM databases are all replicas across the environment (which are all properly replicating), so I cannot figure out what is causing this message lockup to happen.

The other weird issue that I have noticed (and I'm not sure if it is related to the event monitor issue or not) is that the monitoring server is constantly showing a message in the logs that states "Suppression interval = 0", and it seems to throw 3-4 of them in a row right when it should be sending out one of those event notifications. I cannot find anything anywhere that references this specific message, and it does not point to any specific ini setting that is set up on the server. I say this because none of the settings on the monitoring server have anything to do with any type of suppression interval.

If anyone has any insights to this problem, or the console message, please let me know. I have tried contacting IBM's support about this, but that was a lesson in futility.

Thank you all very much.

Reply »

Mike Woolsey wrote

on Thursday 09 June, 2016 at 14:55:21 UTC

Well, to get more information, I believe there're two Notes.INI settings that'll log volumes of data about events:

debug_event=1
debug_event_log=3

You may have to sort through what it thinks is happening, and I'm not sure what other events are in progress so it could be a lot of info.

PEIDER wrote

on Tuesday 14 June, 2016 at 20:38:17 UTC

Hello DF,

maybe this info can help you ....
http://www-01.ibm.com/support/docview.wss?uid=swg21160041
It may be possible that here are to much Messages at the same time ...

Angelia wrote

on Friday 03 June, 2016 at 02:30:42 UTC

Microsoft Office Library template (StdR7DocLibMS) only supports old version of Microsoft office. Is there any way to get a template for Office 2010 and above

Reply »

Mike C wrote

on Thursday 02 June, 2016 at 16:53:37 UTC

Anyone know how to get acrobat working with Notes 9. The actions to convert message to PDF are no longer available.

Reply »

Mike Woolsey wrote

on Thursday 09 June, 2016 at 13:43:46 UTC

I remember this from a while back, maybe it'd help:

https://helpx.adobe.com/acrobat/kb/pdfmaker-unavailable-lotus-notes-acrobat.html

https://helpx.adobe.com/acrobat/kb/pdfmaker-unavailable-lotus-notes-acrobat.html

Brett wrote

on Tuesday 31 May, 2016 at 16:45:25 UTC

Hello, we use Domino to review documents here. We are experiencing an issue with Word 2016 where documents do not open properly (Domino works to the point where the file is downloaded, but Word 16 then says "Invalid Document ID")

Do you have any advice?

mailto:brett.bertles@gmail.com

Reply »

Mike Woolsey wrote

on Thursday 09 June, 2016 at 13:42:10 UTC

There's an outside chance you may need to add the following registry entry:

HKEY_LOCAL_MACHINE\Software\Microsoft\ODMA32\ANSIonNT

If it's specific to Microsoft Word 2016 and not earlier versions, it'd appear that it's ... specific to Microsoft Word 2016 and not Lotus Notes. You didn't change Lotus Notes, you changed Microsoft Word, and that introduced the issue.

Aside, I'm sure Microsoft will weigh in as doing something new & exciting so as to break this. Thousands of .rtf files were broken when they introduced Word 2010, and I've yet to see any substantial action to recover them. I still have Word 97 handy to read documents out of our archive.

Good luck!

MJ wrote

on Thursday 26 May, 2016 at 19:41:35 UTC

Help, please! I need a Lotus Notes expert. We recently launched a new team database in Lotus Notes. We're noticing some senders (specifically, other Lotus Notes team database IDs) email's are coming in flagged normal priority. The users of those other databases insist they are not flagging their emails to us. How do we remove the flag on specific users so future emails do not automatically get flagged?
Thanks!

Reply »

Bikswan wrote

on Tuesday 24 May, 2016 at 00:25:32 UTC

Hi, do you know if there is any third pary .Net API available to extract emails & attachments from Lotus notes database? is it required to have lotus notes installed on PC to use Lotus Notes C++ API.

Reply »

Polymorph Ltd wrote

on Tuesday 24 May, 2016 at 09:51:53 UTC

Absolutely, for pure email+attachments you have a number of non C++ / client choices (assuming you have a Domino server):

* Use a .Net IMAP / POP3 library
* Use REST ( http://infolib.lotus.com/resources/domino/8.5.3/doc/designer_up1/en_us/DominoDataService.html )
* Write your own domino SOAP web service & call from .Net

Ivan wrote

on Wednesday 11 May, 2016 at 20:06:38 UTC

I miss Domino and Notes client so much! After 12 years running numerous business applications in Notes I am trying to deploy similar business apps on Drupal and other MS platforms and it is incredible pain in the ass!!! What took hours in Domino takes days and weeks in php/Drupal.

Reply »

Sue H wrote

on Wednesday 06 April, 2016 at 04:42:08 UTC

We use Notes/FX in many of our databases and will soon be upgrading to Office 2016. When I tested field exchange with Excel 2016 it doesn't appear to work. Is it no longer supported or is there a work-around?
Thanks

Reply »

Polymorph Ltd wrote

on Wednesday 08 June, 2016 at 14:07:51 UTC

Hi Sue,
We tried here too and found very much the same. One thing to check might be if you're using a 64 bit version of Office as it may need to be 32 bit for it to work with Notes.
In nearly all cases we have replaced NotesFX with LotusScript/OLE agents to update/create Excel spreadsheets (and this works fine in Office 2016 as we use it daily).
Hope that's of some help!

Jaime Robertson wrote

on Tuesday 29 March, 2016 at 03:53:13 UTC

Interesting Blog! I use Follow Up flags extensively, with context tags in the Action field. In the standard Follow Up view, I can not sort or filter the Action field. Is there anyway to do this or to create a custom view specific to the Action tag (i.e. @Ryan 1:1). Thank you.

Reply »

AC wrote

on Wednesday 09 March, 2016 at 17:23:13 UTC

Hi there, are there any "free" tools out there to allow one to report on existing users versus numbers of mailboxes and/or unused mailboxes, etc?

Reply »

Ptr wrote

on Monday 22 February, 2016 at 20:11:26 UTC

How can I get a trial of Lotus Notes 8.5.3? I have registered and ID on IBM site but its just impossible to find a link to a sensible download. Any clues please?

Reply »

Mike Woolsey wrote

on Wednesday 24 February, 2016 at 14:59:23 UTC

I don't know if 8.5.3 is still available, but I had another thought. Are you looking at it for email, or for application development?

I believe it's Notes 9 that shows up as an evaluation, today: https://www.ibm.com/developerworks/downloads/ls/lsndad/

When I downloaded Domino Designer 9, it included a copy of Notes 9.

I don't remember whether the email template is included with Domino Designer. If it is, you could get an initial look at email as well. It's hard to get a complete picture, but you get a lot more than, say, Sharepoint without the server (...!!).

Now, granted, you don't have an ID license for Notes 9, that comes at a cost. And no, it's not a server. However, you can see a whole lot about Notes and really, Domino applications' interface to Notes, from Domino Designer.

Irene wrote

on Friday 19 February, 2016 at 10:32:47 UTC

I am so glad to hear someone loves Lotus Notes. If managed properly it is more stable and great to use.

Reply »

Thomas wrote

on Tuesday 20 September, 2016 at 08:59:19 UTC

I fully agree. I love Lotus Notes. It's very cool because its open. Even if almost everything is included, those few bits one might miss, can be added easily.

Too sad, that IBM does such a weak marketing for it.

Michael wrote

on Saturday 13 February, 2016 at 16:22:37 UTC

Looking to be fluid with using Lotus Notes and want to insure a replacement to the Lotus-Notes-Journal or IBM-Notes-Journal. I've been using Lotus Notes since Version 2 and like using Notes Journals for adhoc note taking with HTML or Screen clips of notes then being able to categorize and doclink notes. Using a full text search can search these databases and if needed to recall information (I have a lot), it can be found. So far I am looking at WordPress as a replacement, but it doesn't meet my immediate needs. I'd like to be able to export my Notes Journal to other systems and if I feel Notes is a viable long term solution maintain Notes. I'd like to be able to test my solution across multiple solutions. Has anyone tried to do things like this? I know what needs to be done, but as you may know this will take a lot of effort. I'd like to find others interested or use Notes this way looking for a solution.

Reply »

Michael wrote

on Wednesday 17 February, 2016 at 14:54:46 UTC

I just wanted to add that I ran across the following article which validates my desire to be more fluid with Lotus Notes. The IBM Analytics ?

Mike Woolsey wrote

on Tuesday 23 February, 2016 at 14:37:27 UTC

Since 2001 I've searched for something as versatile as Notes. It's not there.

I use Weebly for some blogging. I haven't looked for full text search in particular on Weebly, mostly because I've been dissatisfied with just about everything else I've looked at for search. It's remarkably quick, useful, and again versatile on Notes.

There're some Notes features that are useful to me that you haven't mentioned, though, so I suspect you may find what you're looking for. Keep an open mind about some things taking more time, and some things you simply can't do. It can be aggravating, but it's not always fatal.

The big problem I always ran into, though: I couldn't integrate with other data sources well, anywhere outside Notes. It required gobs of code that had to be learned, then manually entered. That's costly. And any learning only has a half-life of about 3 years with things outside Notes.

So choose where to spend your time. If you find a way to use it wisely, we're always interested!

Richard D wrote

on Thursday 04 February, 2016 at 16:16:08 UTC

Can you make a Lotus Notes Website mobile friendly ??

www.harlaco.co.uk

Reply »

Mike Woolsey wrote

on Thursday 04 February, 2016 at 17:32:13 UTC

Yep.

There are extensive discussions & descriptions of mobile interface frameworks at openntf.org for instance.

This is more into nuts & bolts additions to a Domino application, but those of us who've been doing this for over a decade have repeatedly redone the interfaces on Domino applications. It seems to be "the way" of many well-used applications: once a company has their internal business needs handled well in an application, the application itself can be presented out to numerous different browsers, mobile users, wireless apps, tablets ...

Mike Woolsey wrote

on Tuesday 09 February, 2016 at 14:31:49 UTC

Sure.

Here's a blog entry on the subject & how to get started.

http://www.matnewman.com/webs/personal/matblog.nsf/dx/one-of-the-best-reasons-to-upgrade-to-ibm-domino-9-mobile-apps-in-less-than-5-minutes?opendocument&comments

Mike Woolsey wrote

on Wednesday 10 February, 2016 at 18:55:42 UTC

I was getting some information on Bootstrap and ran across this as well.

Mobile interfacing is a very important piece of XPages work, but I hadn't run across what IBM & others were doing atop of Bootstrap 'til you asked about it. It looks interesting.

http://www.teamstudio.com/blog/xpages-controls-face-off-xcontrols-vs.-ibm-mobile-controls?hsFormKey=2fafd4d4d849f87c6e0fb93207963863&submissionGuid=9267f92d-4482-4dd5-bbbf-b8ecbdb19985#wizard_module_241502504795843454787513727325384870388

syed.jahanzaib wrote

on Tuesday 02 February, 2016 at 07:40:06 UTC

Greetings,
I have domino server 8.5.3 FP6 on W2008 Server. (64bit) and transnational logging is enabled.
I wanted to know that if I run compact -a , it archives the data, but it donot reduce the file size. To reduce file size, i have to execute compact -B which reduces the file size.

So can I run "compact -a -B" ? any issue ?

Reply »

Mike Woolsey wrote

on Wednesday 10 February, 2016 at 14:46:57 UTC

I can't think of a reason why not. Normally compact runs through switch settings in the order that they appear on the command line.

I'm not sure you want to take the time to run a compact with file space reduction every night on the server, though. I'd probably opt for something that occurs less frequently, like maybe once a week doing the full compact.

DF wrote

on Friday 15 January, 2016 at 15:15:40 UTC

Hello, everyone.
I have a question for any/all engineers regarding database size and indexing in Domino 8.5.
I have a situation where we have an application database that is showing 60gb in physical size. It has all of the size-reducing options on it except DAOS (only because there are less than 20 docs that daos will pull out of it). When I made a non-replica copy of it for testing, the database size shrunk down to less than 4gb. Then, when I ran a full updall on it, it blew it back up to 60gb again (so the size must be due to an index issue because the databse is almost fully compacted).
Now, I saw someone mention on a forum that they had a Domino database that was showing as being over 90gb in size and had a lot of indexes in it, but it was still functioning and didn't lock up.....so, my question is, do these indexes on a database actually count towards the 64gb physical hard cap, or is the true data size that low number that I saw when I made the copy of it for testing?
Thanks.

Reply »

Mike Woolsey wrote

on Tuesday 19 January, 2016 at 14:49:35 UTC

I'd go looking into why the view is so large.

Big views, like big forms, are often a merger of design choices that you can alleviate.

Sometimes it's just a space-saving switch isn't thrown on the view. Sometimes someone has thrown a space-using feature that you don't recognize just yet. On occasion the view itself has a lot of features, and there's little you can do to deal with it except move the space-using feature off to another view (and yes, often it'll cost you far less space to split out another view).

I'm not sure how I'd tell you to go about it, but here are a few pointers:

1. If you're not really displaying response docs, and you still have response docs in hierarchy -- shut them off.

2. If you have alternate sorting (it's a switch on the column) on most/all the columns, there's a switch you can throw in 8.5 so the alternate-sort isn't automatically created. You may never use that alternate sorting, so shutting it off can save you a lot of space.

3. This one is subtle. If you have a column that is not sorted; and that same column says "show multiple values as separate entries"; and you're not using the column-indexing feature (I'll describe it below); then you may want to shut off that checkmark. This checkmark is always enabled on categorized columns: there it's no prob'. It may be useful to you on plain, sorted columns -- no harm there if you really need it, but you may want to check whether the field even has multiple values. However: on non-sorted columns it's performing a very special feature: non-sorted columns index multiple values by the prior sorted, multivalue column. So it's great when it's needed, but when it's not, it can use up disk space for no apparent reason.

This last issue is hard to explain -- even the help doesn't do a good job of it ("Advanced Options for Columns" -- "Sorting Multiple Values" describes what you want to do -- but not how!). You may want to experiment with your view to see what happens. This stuff only impacts on multivalue columns. So I'd say if the columns don't have multiple values, you'd be safe turning off the "show multiple values" switch **on unsorted columns**, saving the added work & space for it.

Slawek wrote

on Tuesday 19 January, 2016 at 17:08:28 UTC

In Administrator of Files, when you select database, in Tools/Database you have a tool called "Manage Views" which will show you size of all indexes inside your database. You can check there which are so huge in your case.

lotus notes latest comments

older posts >


In reply to
Name
Message
Link


Name
Message
YouTube URL
Link


Email