Lotus notes view ReadViewEntries

I just tested an ajax function in notes and I thought of constructing a view based on the json in lotus notes native web/ Xpages.

I have passed the view?ReadViewEntries in the ajax call. But I got only 10 viewentries instead of 1000. After that I just walk around the blogs of notes expert, I found the nice article, I am sharing in below,

http://macguidera.blogspot.com/2006/08/readviewentries.html

Thanks for the above post...

Convert the NotesDocument into PDF

Here is the interesting stuff comes again, I need to convert all the documents into pdf file. I started my research on that, initially I thought it was easy because I have already worked on that but last time I did not handle/ convert Rich Text item. Creating table, designing the PDF template all are very easy. But getting the handle of inline images in Rich Text Item is very difficult, if you do not want to spend money.

 I have done my design using itext.jar, and created my own PDF template for document. Now I captured all the infos like Text, Text List, Date/Time, Names and etc., except RTF and RT lite field.

 I started to work on attach the file into pdf, started with hard but ended with very easy. I extracted file from RTF and saved in the local machine temp folder and attached into the PDF. Thanks a lot to iText.jar.

             RichTextItem rt = (RichTextItem)  doc.getFirstItem("Body");
              Vector ve = rt.getEmbeddedObjects();
              EmbeddedObject eo = null;
           Enumeration e = ve.elements();
           if(ve.size() > 0)
           {
            attachments = new String[ve.size()];
               while (e.hasMoreElements()) {
                eo = (EmbeddedObject)e.nextElement();
                eo.extractFile("C:\\Temp\\" +eo.getSource());
                attachments[count] = "C:\\Temp\\" +eo.getSource();
                  }
           }
Code for attaching the file into PDF file... The below is not from my knowledge it is taken from one blog, I forgot because long back I have taken this piece of code. Sorry and don't mind :D

public void addAttachments(
 String src, String dest, String[] attachments) throws IOException, DocumentException {
 PdfReader reader = new PdfReader(src);
 PdfStamper stamper = new PdfStamper(reader, new FileOutputStream(dest));
 for (int i = 0; i < attachments.length; i++) {
   addAttachment(stamper.getWriter(), new File(attachments[i]));
 }
 
 stamper.close();
}

protected void addAttachment(PdfWriter writer, File src) throws IOException {
 PdfFileSpecification fs =
   PdfFileSpecification.fileEmbedded(writer, src.getAbsolutePath(), src.getName(), null);
 writer.addFileAttachment(src.getName().substring(0, src.getName().indexOf('.')), fs);
}
Once everything is set I have entered into the tough task, that is converting the inline image to attachment/ embed the same image in PDF file. Both are difficult.

1. I just gone through the PDF creator class and convert the document into pdf file like Prrint -> Save as PDF using PDF creator tool. But the result, I faced so many difficulties, somemachine adopt the code and close the PDF file, many machine can not close the PDF object so my notes gets crashed. So I do not want to go with PDF creator. For this PDF creator needs to be installed on your PC.
2. I just googled and found that midas is the lotus script library, it is good but it is not free software. 
3. I just found many automated tools like swing PDF converter, etc., but it is quite expensive. I do not want to spend money on that. 
4. I have gone through many blogs and discussion portals. I could not find the proper code for that.

Finally I just created webpage for my application, we have many easy tool for converting the HTML page to PDF. I just converted the Notes HTML document to PDF file, and extract the attachment and saved it in local folder. I embedded the attachment into the above pdf file. I have reached my goal, I do not think it is good and efficient.

Still my research on handling the inline image of RTI is going on, :( :( :(

Read the XML in Lotus Notes

Really very hard to understand the structure of the Notes XML parsing classes. Still I need to understand more. Actually I tried to read the xml file for some requirement.

Initially I thought it is an easy job but after an half of the day had gone, I realized it is difficult one.

If someone has nice trick please share to me...

    Dim session As New NotesSession
    Dim domparser As NotesDOMParser
    Dim domdoc As NotesDOMDocumentNode
    Dim domlist As NotesDOMNodeList
    Dim domlist1 As NotesDOMNodeList
    Dim domele As NotesDOMElementNode
    Dim stream As NotesStream
    Dim node As NotesDOMNode
    Dim node1 As NotesDOMNode
    Dim x As String   
    x= "D:\javap\Test.xml"
    Set stream = session.CreateStream()
    stream.open(x)
    Set domParser = session.CreateDOMParser(stream)
    domParser.Process
    Set domdoc = domparser.Document
    Set domele = domparser.Document.DocumentElement
    Set domlist = domele.GetElementsByTagName("TagName")
    Set node =  domlist.GetItem(1)
    Msgbox node.FirstChild.NodeValue
 

Windows Run Command

For lazy users like me, sometime our job will be get bored because we need to do the same job for as many time. Also we need to interact with the windows frequently. Probably we can create macro or agent for doing the particular job for as many times. However we can not do this for all cases. The below are the interesting stuff. These are the Run Commands in windows. I hope this will be very useful. I found this in the following site... -Useful-Run-Commands

To Access…	Run Command
Accessibility Controls	access.cpl
Accessibility Wizard	accwiz
Add Hardware Wizard	hdwwiz.cpl
Add/Remove Programs	appwiz.cpl
Administrative Tools	control admintools
Adobe Acrobat (if installed)	acrobat
Adobe Designer (if installed)	formdesigner
Adobe Distiller (if installed)	acrodist
Adobe ImageReady (if installed)	imageready
Adobe Photoshop (if installed)	photoshop
Automatic Updates	wuaucpl.cpl
Bluetooth Transfer Wizard	fsquirt
Calculator	calc
Certificate Manager	certmgr.msc
Character Map	charmap
Check Disk Utility	chkdsk
Clipboard Viewer	clipbrd
Command Prompt	cmd
Component Services	dcomcnfg
Computer Management	compmgmt.msc
Control Panel	control
Date and Time Properties	timedate.cpl
DDE Shares	ddeshare
Device Manager	devmgmt.msc
Direct X Control Panel (if installed)*	directx.cpl
Direct X Troubleshooter	dxdiag
Disk Cleanup Utility	cleanmgr
Disk Defragment	dfrg.msc
Disk Management	diskmgmt.msc
Disk Partition Manager	diskpart
Display Properties	control desktop
Display Properties	desk.cpl
Display Properties (w/Appearance Tab Preselected)	control color
Dr. Watson System Troubleshooting Utility	drwtsn32
Driver Verifier Utility	verifier
Event Viewer	eventvwr.msc
Files and Settings Transfer Tool	migwiz
File Signature Verification Tool	sigverif
Findfast	findfast.cpl
Firefox (if installed)	firefox
Folders Properties	folders
Fonts	control fonts
Fonts Folder	fonts
Free Cell Card Game	freecell
Game Controllers	joy.cpl
Group Policy Editor (XP Prof)	gpedit.msc
Hearts Card Game	mshearts
Help and Support	helpctr
HyperTerminal	hypertrm
Iexpress Wizard	iexpress
Indexing Service	ciadv.msc
Internet Connection Wizard	icwconn1
Internet Explorer	iexplore
Internet Properties	inetcpl.cpl
Internet Setup Wizard	inetwiz
IP Configuration (Display Connection Configuration)	ipconfig /all
IP Configuration (Display DNS Cache Contents)	ipconfig /displaydns
IP Configuration (Delete DNS Cache Contents)	ipconfig /flushdns
IP Configuration (Release All Connections)	ipconfig /release
IP Configuration (Renew All Connections)	ipconfig /renew
IP Configuration (Refreshes DHCP & Re-Registers DNS)	ipconfig /registerdns
IP Configuration (Display DHCP Class ID)	ipconfig /showclassid
IP Configuration (Modifies DHCP Class ID)	ipconfig /setclassid
Java Control Panel (if installed)	jpicpl32.cpl
Java Control Panel (if installed)	javaws
Keyboard Properties	control keyboard
Local Security Settings	secpol.msc
Local Users and Groups	lusrmgr.msc
Logs You Out Of Windows	logoff
Malicious Software Removal Tool	mrt
Microsoft Access (if installed)	msaccess
Microsoft Chat	winchat
Microsoft Excel (if installed)	excel
Microsoft Frontpage (if installed)	frontpg
Microsoft Movie Maker	moviemk
Microsoft Paint	mspaint
Microsoft Powerpoint (if installed)	powerpnt
Microsoft Word (if installed)	winword
Microsoft Syncronization Tool	mobsync
Minesweeper Game	winmine
Mouse Properties	control mouse
Mouse Properties	main.cpl
Nero (if installed)	nero
Netmeeting	conf
Network Connections	control netconnections
Network Connections	ncpa.cpl
Network Setup Wizard	netsetup.cpl
Notepad	notepad
Nview Desktop Manager (if installed)	nvtuicpl.cpl
Object Packager	packager
ODBC Data Source Administrator	odbccp32.cpl
On Screen Keyboard	osk
Opens AC3 Filter (if installed)	ac3filter.cpl
Outlook Express	msimn
Paint	pbrush
Password Properties	password.cpl
Performance Monitor	perfmon.msc
Performance Monitor	perfmon
Phone and Modem Options	telephon.cpl
Phone Dialer	dialer
Pinball Game	pinball
Power Configuration	powercfg.cpl
Printers and Faxes	control printers
Printers Folder	printers
Private Character Editor	eudcedit
Quicktime (If Installed)	QuickTime.cpl
Quicktime Player (if installed)	quicktimeplayer
Real Player (if installed)	realplay
Regional Settings	intl.cpl
Registry Editor	regedit
Registry Editor	regedit32
Remote Access Phonebook	rasphone
Remote Desktop	mstsc
Removable Storage	ntmsmgr.msc
Removable Storage Operator Requests	ntmsoprq.msc
Resultant Set of Policy (XP Prof)	rsop.msc
Scanners and Cameras	sticpl.cpl
Scheduled Tasks	control schedtasks
Security Center	wscui.cpl
Services	services.msc
Shared Folders	fsmgmt.msc
Shuts Down Windows	shutdown
Sounds and Audio	mmsys.cpl
Spider Solitare Card Game	spider
SQL Client Configuration	cliconfg
System Configuration Editor	sysedit
System Configuration Utility	msconfig
System File Checker Utility (Scan Immediately)	sfc /scannow
System File Checker Utility (Scan Once At The Next Boot)	sfc /scanonce
System File Checker Utility (Scan On Every Boot)	sfc /scanboot
System File Checker Utility (Return Scan Setting To Default)	sfc /revert
System File Checker Utility (Purge File Cache)	sfc /purgecache
System File Checker Utility (Sets Cache Size to size x)	sfc /cachesize=x
System Information	msinfo32
System Properties	sysdm.cpl
Task Manager	taskmgr
TCP Tester	tcptest
Telnet Client	telnet
Tweak UI (if installed)	tweakui
User Account Management	nusrmgr.cpl
Utility Manager	utilman
Windows Address Book	wab
Windows Address Book Import Utility	wabmig
Windows Backup Utility (if installed)	ntbackup
Windows Explorer	explorer
Windows Firewall	firewall.cpl
Windows Magnifier	magnify
Windows Management Infrastructure	wmimgmt.msc
Windows Media Player	wmplayer
Windows Messenger	msmsgs
Windows Picture Import Wizard (need camera connected)	wiaacmgr
Windows System Security Tool	syskey
Windows Update Launches	wupdmgr
Windows Version (to show which version of windows)	winver
Windows XP Tour Wizard	tourstart
Wordpad	write

How do we find the size of a rich text field in Lotus Notes?

I am facing an issue, Its peculiar but still IBM is not fixed this issue,

My database is very old. It is created on 1998. Now my database's version is 6.5.1. So my case everything has its own limit. After a long time, I seen like my db usage is 98% after the completion of compacting. So whenever my document exceeds 32K it can be old or new, the document became spam. Like we can not access the document. We can not open the document. We can not see the property of the document. I had some agents that will take all the documents one by one. Because of this issue, the agent stopped and thrown the error like "field is too large 32k or view's column & selection formulas are too large". I could not find the reason why it is happening.

eg:- If my already existing document has more than 32k of size. I have gone and edited the document. And saved it. The document size exceeds 32k, and it became spam what I mentioned above. If my new document exceeds 32k, I attained the same issue.

I was confused. I tried the following steps.

1. I changed the Text to Summary for all items. Nothing happened.
2. As of Notes constraints, document can have any number of size less than 64GB(about db size). But less than 6 It has some limitation. I guess. Sorry if it is wrong. Number of field should not exceed 3000. So I checked the document size. And tried to reduce that. I deleted contents of the fields and made the document to less than 64K. Same problem came.
3. I created a lot of field. The form had thousands of field. So I removed many field. I counted as a child and made it to 1000 exactly including reserve fields. Like $Revisions.  -  32K error. :(
4. I know that the limitation of RTF(Rich Text Field)  is 1gb. So I ignored.
5. I found the $UpdatedBy field is exceeding 32K of size. So I limited the number of entries for this.

Finally, I found that the issue from Rich text field. I deleted the attachments and reduced the document size less than 32k. and saved it. I got satisfied.

So I planned to restrict the document size to the user. I want to avoid the 32K error in future documents. Better I can stop the attachment size should not exceeds 15k. So I want to fetch the size of the RTF. I found the better solution for that. t refers NotesRichTextItem.

        Set t = doc.GetFirstItem("body")
Dim newdoc As NotesDocument
Set newdoc = db.CreateDocument()
Call t.Copyitemtodocument(newdoc, "reasonType")
Msgbox newdoc.Size

Also I can count the current document size. One funny thing is, our Notes rich text field contents like copy and pate images not an attachments can not be taken without saving the document.


Dim ws As New NotesUIWorkspace
Dim uidoc As NotesUIDocument
Set uidoc = ws.CurrentDocument
Dim session As New NotesSession
Dim db As NotesDatabase
Dim doc As NotesDocument
Dim t As Variant
Call uidoc.FieldSetText("SaveOptions","0")
Call uidoc.Save()
uidoc.Refresh
Set db = session.CurrentDatabase
Set doc = uidoc.Document
        msgbox doc.size

But my question to IBM, Why the hell this much big issue can not be solved?

Once the 32K error document has been created then we have to delete the replica copy and take a new replica copy from the source server. This is the only solution for deleting the 32K error documents. You can not delete these document manually.

Get Image from Excel- VB Script

I was trying to get the picture from excel and trying to save it in my local HD. But unfortunately I did not aware of some Excel Sheet methods. I googled. Whatever I tried finally I can put the picture into excel. But I did not find the way to take the picture. So  I copied and pasted the 100's of images from my Excel sheet.

After a day later, I have fresh mind. I tried to find a easy way. Finally I got the easiest way. I found the function.

Lotus Script:-

Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set xlwb=xlApp.Workbooks.Open("File Path")
Set xlsheet =xlwb.Worksheets(1)   Call xlSheet.Shapes(0).copy()

    VB Script :-

appExcel = New Excel.Application
xlsBook = appExcel.Workbooks.Open("File Path")
xlsSheet = xlsBook.Worksheets("Sheet1")
Call xlSheet.Shapes(0).copy()

You can get all the images by using for all or far each condition.

JSF in Xpages

We can handle the servlet objects in xpages very effectively.

In xpages, JSF's facesContext is having the capablity to do this action. Actually this is fetching the CGI variables from server.

Long back I had one assignment, that time I used php for getting the CGI variables from server. I was not aware of this facesConetext at that time. But now I came to know that Xpages have that capablity. Please follow the commands. It should useful for you.

facesContext.getExternalContext().getRequest().getAuthType();


facesContext.getExternalContext().getRequest().getContentLength();

facesContext.getExternalContext().getRequest().getContentType();

facesContext.getExternalContext().getRequest().getContextPath();

facesContext.getExternalContext().getRequest().isSecure() ? "ON" : "OFF";

facesContext.getExternalContext().getRequest().getPathInfo();

facesContext.getExternalContext().getRequest().getPathTranslated();

facesContext.getExternalContext().getRequest().getQueryString();

facesContext.getExternalContext().getRequest().getRemoteAddr();

facesContext.getExternalContext().getRequest().getRemoteHost();

facesContext.getExternalContext().getRequest().getRemoteUser();

facesContext.getExternalContext().getRequest().getMethod();

facesContext.getExternalContext().getRequest().getScheme();

facesContext.getExternalContext().getRequest().getRequestURI();

facesContext.getExternalContext().getRequest().getServletPath();

facesContext.getExternalContext().getRequest().getServerName();

facesContext.getExternalContext().getRequest().getServerPort();

facesContext.getExternalContext().getRequest().getProtocol();

facesContext.getExternalContext().getContext().getServerInfo();

facesContext.getExternalContext().getHeader("Cooike")
facesContext.getExternalContext().getHeader("Host")
facesContext.getExternalContext().getHeader("Referer")

We can find this in our discussion8.ntf.

you can only cut or copy a maximum of 2335 documents

I am very happy to come back again to maintain my blog.

Quick Solu :- IBM Defined Error. For W32, you can not copy more than 2335 documents.

Today morning I was wondering about this issue. I just wanted to copy and paste the 5000 documents from one server to my local database for checking one agent.

But while copying the documents, I was getting the mentioned error.

"you can only cut or copy a maximum of 2335 documents"

I thought that it is the user defined error. I checked all the design elements. But I did not get any solution. Finally I found a site that gives more good things and limitations about Lotus Notes.

This is the Limitation for W32 OS. if you are having 64 bit then you can copy or cut documents as much you want. Because the clip board size will become very large. So the IBM restricted this copying things.

Please visit this, Really It is coooolllll

This is not official documentation. It is what you can expect from ND6.5x/7.x/8.x/8.5x by way of limitations, if you don't know better. If you do know better, we'd like to! Some limits are still guesses or experienced but not proven. Known questionable entries have a question mark (?) beside them.

Limit	ND6/6.5	ND7	ND8/8.5
What is the maximum size of a database?	64 GB (gigabyte) or the OS file system's limit (2 GB on some older UNIX platforms).It was previously reported that this could exceed 64 GB on Windows systems, but technote 1093509states that this is not true, and readers have confirmed that 64 GB is a hard limit. According to technote1113005, there are some serious problems with >2GB size on Macintosh client.	64 GB (gigabyte) or the OS file system's limit (2 GB on some older UNIX platforms).It was previously reported that this could exceed 64 GB on Windows systems, but technote 1093509states that this is not true, and readers have confirmed that 64 GB is a hard limit. See note under ND6/6.5 about Macintosh limit of 2GB. Note sure if this is a problem for ND7 or not	64 GB (gigabyte) or the OS file system's limit (2 GB on some older UNIX platforms).It was previously reported that this could exceed 64 GB on Windows systems, but technote 1093509states that this is not true, and readers have confirmed that 64 GB is a hard limit. See note under ND6/6.5 about Macintosh limit of 2GB. Note sure if this is a problem for ND8/8.5 or not Ref: #1093509
What is the maximum size of plain text fields? (e.g., group Members field?)	15KB per (summary) text field; 64KB per (non-summary) text field; 30KB of fields per document (storage); 15KB displayed in a view's column	15KB per (summary) text field; 64KB per (non-summary) text field; 30KB of fields per document (storage); 15KB displayed in a view's column	15KB per (summary) text field; 64KB per (non-summary) text field; 30KB of fields per document (storage); 15KB displayed in a view's column
What is the maximum size of all summary fields in a document combined?	64KB of summary data per document	64KB of summary data per document	64KB of summary data per document
What is the maximum size of a computed text field?	64,363 characters	64,363 characters	64,363 characters
What is the maximum size of a single paragraph in a rich text field?	64KB (this is approximately 35k of text, though)	64KB (this is approximately 35k of text, though)	64KB (this is approximately 35k of text, though)
What is the maximum number of paragraph styles?	64,000 unique paragraph styles in a single document	64,000 unique paragraph styles in a single document	64,000 unique paragraph styles in a single document
How many sublevels in a hierarchical view; how many documents at each level?	31 levels; 300,000 documents	31 levels; 300,000 documents	31 levels; 300,000 documents
What is the maximum number of windows you can have open simultaneously?	limited by memory; 35(?) accessible from keyboard	limited by memory; 35(?) accessible from keyboard	limited by memory; 35(?) accessible from keyboard
How many characters are allowed in names for views, forms, and so on?	Database Title: 96 Filename: limited by OS's file system Field names: 32 View names: 64 Folder names: 64 Form names: 32 Macro names: 32 ACL entry: 255	Database Title: 96 Filename: limited by OS's file system Field names: 32 View names: 64 Folder names: 64 Form names: 32 Macro names: 32 ACL entry: 255	Database Title: 96 Filename: limited by OS's file system Field names: 32 View names: 64 Folder names: 64 Form names: 32 Macro names: 32 ACL entry: 255
How many characters are allowed in various administrative names?	Domain name: 31 Notes named network: 31 Organization (O) name: 3 (min) to 64 (max), or 2 (min) if you include Country code Organizational unit (OU) name: 32 Common name (CN): 80 Server name: 79 User name: 79 Group name: 62 Country code (C): 2 (or 0 since it is optional) Port: No maximum Source is "Table of Domino naming requirements" from ND6 Admin Help db	Domain name: 31 Notes named network: 31 Organization (O) name: 3 (min) to 64 (max), or 2 (min) if you include Country code Organizational unit (OU) name: 32 Common name (CN): 80 Server name: 79 User name: 79 Group name: 62 Country code (C): 2 (or 0 since it is optional) Port: No maximum Source is "Table of Domino naming requirements" from ND6 Admin Help db	Domain name: 31 Notes named network: 31 Organization (O) name: 3 (min) to 64 (max), or 2 (min) if you include Country code Organizational unit (OU) name: 32 Common name (CN): 80 Server name: 79 User name: 79 Group name: 62 Country code (C): 2 (or 0 since it is optional) Port: No maximum Source is "Table of Domino naming requirements" from ND6 Admin Help db
How many aliases are allowed for views?	Up to 130 characters for all view aliases per view, including vertical-bar separators ("|"), including the view name	Up to 130 characters for all view aliases per view, including vertical-bar separators ("|"), including the view name	Up to 130 characters for all view aliases per view, including vertical-bar separators ("|"), including the view name
What is the maximum size for Mail recipient names in a single mail message?	For individual names and private groups which expand locally, 15KB; for public groups which expand on a server, 2MB of recipient names (based on fully qualified names, for example, Les Kaplan @ Marketing).	For individual names and private groups which expand locally, 15KB; for public groups which expand on a server, 5MB of recipient names (based on fully qualified names, for example, Les Kaplan @ Marketing).	For individual names and private groups which expand locally, 15KB; for public groups which expand on a server, 5MB of recipient names (based on fully qualified names, for example, Les Kaplan @ Marketing).
How many mail rules in a mail DB?	100	100	100
What is the maximum number of individual reader names/group names in a single document?	2005 (This is a reported limit, not a documented limit, and it has not been verified. Supposedly, after this many, no matter the size of the field, the indexer will stop displaying the document in views, and the editor will not save)	2005 (This is a reported limit, not a documented limit, and it has not been verified. Supposedly, after this many, no matter the size of the field, the indexer will stop displaying the document in views, and the editor will not save)	2005 (This is a reported limit, not a documented limit, and it has not been verified. Supposedly, after this many, no matter the size of the field, the indexer will stop displaying the document in views, and the editor will not save)
What's the maximum password length allowed on an ID?	63 characters	63 characters	63 characters
fields in a database	~ 3000 (limited to ~ 64K total length for all field names). You can enable the database property "Allow more fields in database" to get up to 22,893 uniquely-named fields in the database.	~ 3000 (limited to ~ 64K total length for all field names). You can enable the database property "Allow more fields in database" to get up to 22,893 uniquely-named fields in the database.	~ 3000 (limited to ~ 64K total length for all field names). You can enable the database property "Allow more fields in database" to get up to 22,893 uniquely-named fields in the database.
How many fields in a form?	10MB memory (6MB memory for OS/2)	10MB memory (6MB memory for OS/2)	10MB memory (6MB memory for OS/2)
columns in one table	64	64	64
rows in one table	255	255	255
nested table depth	8 nestings	8 nestings	8 nestings
min/max width of a table cell set through Designer	0.125" (0.318cm) minimum 22.75" (57.785cm) maximum	0.125" (0.318cm) minimum 22.75" (57.785cm) maximum	0.125" (0.318cm) minimum 22.75" (57.785cm) maximum
min/max width of a table cell set through API	0.001" minimum, but less than 0.028 messes with borders 22.755" maximum	0.001" minimum, but less than 0.028 messes with borders 22.755" maximum	0.001" minimum, but less than 0.028 messes with borders 22.755" maximum
views in a database	No limit; however, as the number of views increases, the length of time to display other views also increases	No limit; however, as the number of views increases, the length of time to display other views also increases	No limit; however, as the number of views increases, the length of time to display other views also increases
forms in a database	Unlimited	Unlimited	Unlimited
columns in a view	289 ten-character columns; dependent upon # or characters per column	289 ten-character columns; dependent upon # or characters per column	289 ten-character columns; dependent upon # or characters per column
How wide can a column be (# of inches)?	15KB displayed in a view's column	15KB displayed in a view's column	15KB displayed in a view's column
What's the largest view column title allowed?	80 characters	80 characters	80 characters
What is the total size of computable simple text fields?	63K	63K	63K
How many paragraphs in a document?	21,509 (19,004 for OS/2)	21,509 (19,004 for OS/2)	21,509 (19,004 for OS/2)
What is the maximum size of a rich text field?	Limited only by available disk space up to 1GB	Limited only by available disk space up to 1GB	Limited only by available disk space up to 1GB
What is the maximum number of inserted page breaks?	Unlimited	Unlimited	Unlimited
How many documents can be imported into a view?	Individual documents: up to 350K; from a spreadsheet, 8192 rows; 5000 separate documents	Individual documents: up to 350K; from a spreadsheet, 8192 rows; 5000 separate documents	Individual documents: up to 350K; from a spreadsheet, 8192 rows; 5000 separate documents
cascading views in a database	200	200	200
How many copies of a document can be printed at once?	65,535	65,535	65,535
What is the maximum value allowed in "Start page numbers at" field?	65,535	65,535	65,535
margin size (in inches)	46	46	46
page cropping size (in inches)	46	46	46
point size to select/print	250	250	250
maximum number of soft-deleted documents in a database	32,768	32,768	32,768
documents in a view	Maximum of 128 GB for a view index. (16 M page of B-tree space, 8kB/page) Also limited by available disk space (2 GB on some UNIX platforms). View containers in R5 databases (ODS 3.1 up) do not have a container size limit. The view size limit is now determined by the maximum number of pages that can be created which is 16,777,214. A page holds 8 KB so that means the maximum size for a view is 137,438,937,088 bytes (128 GB).	Maximum of 128 GB for a view index. (16 M page of B-tree space, 8kB/page) Also limited by available disk space (2 GB on some UNIX platforms). View containers in R5 databases (ODS 3.1 up) do not have a container size limit. The view size limit is now determined by the maximum number of pages that can be created which is 16,777,214. A page holds 8 KB so that means the maximum size for a view is 137,438,937,088 bytes (128 GB).	Maximum of 128 GB for a view index. (16 M page of B-tree space, 8kB/page) Also limited by available disk space (2 GB on some UNIX platforms). View containers in R5 databases (ODS 3.1 up) do not have a container size limit. The view size limit is now determined by the maximum number of pages that can be created which is 16,777,214. A page holds 8 KB so that means the maximum size for a view is 137,438,937,088 bytes (128 GB).
What's the maximum number of profile documents allowed in a database?	around 6000-6100 per database: s/w limitation	around 6000-6100 per database: s/w limitation	around 6000-6100 per database: s/w limitation
What is the maximum number of documents that can be exported to Tabular Text?	Limited only by available disk space	Limited only by available disk space	Limited only by available disk space
How many levels of responses will display in a view?	31 levels of response to 1 main document	31 levels of response to 1 main document	31 levels of response to 1 main document
How many responses per parent document?	300,000 documents	300,000 documents	300,000 documents
What is the maximum number of entries in an Access Control List?	Approx: 950 names  (ACL size is limited to 32767 bytes)	Approx: 950 names  (ACL size is limited to 32767 bytes)	Approx: 950 names  (ACL size is limited to 32767 bytes)
What is the maximum number of roles in an access control list?	75 Roles	75 Roles	75 Roles
What is the maximum length of a role name in an ACL?	15 characters	15 characters	15 characters
What is the maximum number of ACL groups a user can be member of?	4096	4096	4096
What is the maximum number of groups that can be nested?	20 levels or up to 64k of group name and person name characters, whichever is lower (~30k of data using @UserNamesList or @UserRoles)	20 levels or up to 64k of group name and person name characters, whichever is lower (~30k of data using @UserNamesList or @UserRoles)	20 levels or up to 64k of group name and person name characters, whichever is lower (~30k of data using @UserNamesList or @UserRoles)
What is the maximum size of a single paragraph you can cut or copy to the Clipboard?	Unlimited (64K for UNIX)	Unlimited (64K for UNIX)	Unlimited (64K for UNIX)
What is the maximum number of documents you can cut or copy to the clipboard?	2335 (Win32)	2335 (Win32)	2335 (Win32)
What is the maximum number of users to have authorized passwords on a multiple password ID?	8 users	8 users	8 users
What's the maximum amount of storage that can be used for strings in a LotusScript module?	2 GB or available memory.	2 GB or available memory.	2 GB or available memory.
What's the maximum length of an environment variable value?	255 characters	255 characters	255 characters
What's the maximum length of a string constant in @function formulas?	2048 bytes (see note under ND7)	2048 bytes (Andre Guirard correctly pointed out that the previous shown value of 2048 characters was incorrect. Also note, these are LMBCS characters, and so could take as many as 4 bytes for a character, although usually they do not)	2048 bytes (Andre Guirard correctly pointed out that the previous shown value of 2048 characters was incorrect. Also note, these are LMBCS characters, and so could take as many as 4 bytes for a character, although usually they do not)
What's the maximum number of results that can be returned from a full text search	4,999	4,999	4,999
What's the largest URL HTTP will accept?	2048 (?)	2048 (?)	2048 (?)
What's the largest rich text field HTTP will update?	~64k?	~64k?	~64k?
What's the maximum size of variable-length strings in a LotusScript module?	2 GB (1 GB of characters) per module, or available memory.	2 GB (1 GB of characters) per module, or available memory.	2 GB (1 GB of characters) per module, or available memory.
How many variable-length strings can be defined in LotusScript?	Limited by available memory and module definitions. Can be limited by symbol table to 64k of symbol names per module.	Limited by available memory and module definitions. Can be limited by symbol table to 64k of symbol names per module.	Limited by available memory and module definitions. Can be limited by symbol table to 64k of symbol names per module.
What's the maximum size of fixed-length strings in LotusScript?	64k (this is a BASIC language limitation)	64k (this is a BASIC language limitation)	64k (this is a BASIC language limitation)
What's the maximum length of a string literal in LotusScript?	32k (16k characters) (this is a BASIC language limitation)	32k (16k characters) (this is a BASIC language limitation)	32k (16k characters) (this is a BASIC language limitation)
What's the maximum line length of a line written by LotusScript Write statement?	255 characters	255 characters	255 characters
How many characters can be in path in MkDir, RmDir, or ChDir statement?	128. This includes the drive specifier, if any.	128. This includes the drive specifier, if any.	128. This includes the drive specifier, if any.
How many items can be in a Print, Write, or Input statement?	255	255	255
What's the maximum recLen in Open statement?	32767	32767	32767
How many symbols can LotusScript handle?	64k of text in symbol names	64k of text in symbol names	64k of text in symbol names
How many data elements can be in a LotusScript array?	Determined by memory available for data, and by the storage size of each element of the array, which varies with the array data type. For example, a Long one-dimensional fixed array declared in type scope can have 16,128 elements. (The total storage size available for fixed-size data in module scope is 64K bytes, and a Long element requires 4 bytes for storage.)	Determined by memory available for data, and by the storage size of each element of the array, which varies with the array data type. For example, a Long one-dimensional fixed array declared in type scope can have 16,128 elements. (The total storage size available for fixed-size data in module scope is 64K bytes, and a Long element requires 4 bytes for storage.)	Determined by memory available for data, and by the storage size of each element of the array, which varies with the array data type. For example, a Long one-dimensional fixed array declared in type scope can have 16,128 elements. (The total storage size available for fixed-size data in module scope is 64K bytes, and a Long element requires 4 bytes for storage.)
What is the maximum size of a List in LotusScript?	Limited by available memory	Limited by available memory	Limited by available memory
What's the maximum size of a LotusScript executable module's code?	limited by available memory; 64k of source without LSS include files	limited by available memory; 64k of source without LSS include files	limited by available memory; 64k of source without LSS include files
How many outline entries can an outline have?	~21,000 entries	~21,000 entries	~21,000 entries
How long can a remote-console command be, and still display properly in Administrator?	More than 77 characters (documented as "addressed" in K-Base, but no new maximum value is documented).	More than 77 characters (documented as "addressed" in K-Base, but no new maximum value is documented).	More than 77 characters (documented as "addressed" in K-Base, but no new maximum value is documented).
What is the maximum number of documents that can be selected when using the 'Archive Selected Documents' option?	The limit appears to be 2047, according to this link.	The limit appears to be 2047, according to this link.	The limit appears to be 2047, according to this link.
Length limit for a macro language string literal	2048 bytes Note Strings in formula language are represented internally in the LMBCS character set, which uses one byte for an ASCII character, but may require up to 4 bytes for some non-ASCII characters.	2048 bytes Note Strings in formula language are represented internally in the LMBCS character set, which uses one byte for an ASCII character, but may require up to 4 bytes for some non-ASCII characters.	2048 bytes Note Strings in formula language are represented internally in the LMBCS character set, which uses one byte for an ASCII character, but may require up to 4 bytes for some non-ASCII characters.
Maximum Notes API objects when using Java		~104,800	~104,800
What is the maximum number of characters that can be in an @Prompt keyword list before it cannot be preselected?	The limit appears to be 127, according to anectdotal evidence in the BP forum.	The limit appears to be 127, according to anectdotal evidence in the BP forum.	The limit appears to be 127, according to anectdotal evidence in the BP forum.
Productivity Editors (ND8.x)	Lotus Documents	Lotus Presentations	Lotus Spreadsheets
What are the maximum numbers of rows and columns for tables?			65,536 rows and 256 columns. The limit on rows has been incorrectly reported as 32,000 in some documentation.
What is the maximum number of worksheets allowed in a spreadsheet?			256 separate worksheets.