In Lotus notes we have some problem when I create richtext field that have picture by backend. This sample code for solve it.
Dim wksp As New NotesUIWorkspace
Dim session As New NotesSession
Dim uidoc As NotesUIDocument, uidocNew As NotesUIDocument
Dim doc As NotesDocument
Dim rti As NotesRichTextItem
Dim strFieldname As String
Set uidoc = wksp.CurrentDocument
uidoc.Refresh True ' do this if the rich text field is editable, to get the current contents in case user has modified them.
Set doc = uidoc.Document �' get the back-end document for the document open on screen.
strFieldname = uidoc.CurrentField ' remember the current field if any
Set rti = doc.GetFirstItem("fieldname") ' insert your fieldname here, generally "Body"
' Make your rich text changes here, for instance:
Call rti.AddNewLine(1, True)
Call rti.AppendText(Now & ": log entry.")
If session.NotesBuildVersion >= 190 Then
rti.Update ' ND6 only
Else
Call doc.ComputeWithForm(True, False) ' caution, as this may erase some field values if you have @Db functions in formulas.
End If
doc.SaveOptions = "0" ' make it possible to close the document without a "do you want to save" prompt. If this is a mail-in doc you may need to set MailOptions="0" also to avoid being prompted.
Call uidoc.Close
Set uidocNew = wksp.EditDocument(True, doc, , , , True)
Delete uidoc
uidocNew.Document.RemoveItem("SaveOptions")
If strFieldname <> "" Then uidocNew.GotoField(strFieldname) ' return focus to field that was current before.
Note: this will cause Queryclose, Queryopen, Postopen (and so on) form events to trigger. Also, uidoc.Refresh will execute computed field formulas and input validations, so you should write the validation formulas to not return @Failure unless @IsDocBeingSaved | @IsDocBeingSent is true.
แสดงบทความที่มีป้ายกำกับ IBM Lotus แสดงบทความทั้งหมด
แสดงบทความที่มีป้ายกำกับ IBM Lotus แสดงบทความทั้งหมด
วันศุกร์ที่ 27 พฤศจิกายน พ.ศ. 2552
Lotus Notes Limitation
Lotus Notes Limitation
Limit R5 (LotusScript 4) R6
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) 64 GB (gigabyte) or the OS file system's limit (2 GB on some older UNIX platforms)
What is the maximum size of plain text fields?
(What is the maximum size of a group Members field?) 15KB per (summary) text field;
30KB of fields per document (storage); 15KB displayed in a view's column 15KB per (summary) text field;
30KB of fields per document (storage); 15KB displayed in a view's column
What is the maximum size of a computed text field? ?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)
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
How many sublevels in a hierarchical view; how many documents at each level? 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
How many characters are allowed in names for views, forms, and so on? Database Title: 32
Filename: limited by OS's file system
Field names: 32
View names: 64
Form names: 32
Macro names: 32 Database Title: 32
Filename: limited by OS's file system
Field names: 32
View names: 64
Form names: 32
Macro names: 32
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
What is the maximum size for Mail recipient names? 2MB of recipient names (based on fully qualified names, for example, Les Kaplan @ Marketing). 2MB of recipient names (based on fully qualified names, for example, Les Kaplan @ Marketing).
How many mail rules in a mail DB? 50 100
What's the maximum password length allowed on an ID? 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.
How many fields in a form? 10MB memory (6MB memory for OS/2) 10MB memory (6MB memory for OS/2)
columns in one table 64 64
rows in one table 255 255
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
forms in a database 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
How wide can a column be (# of inches)? ?15KB displayed in a view's column (5.0.3 release notes) ?15KB displayed in a view's column (5.0.3 release notes)
What's the largest view column title allowed? 50 characters 80 characters
What is the total size of computable simple text fields? 63K 63K
How many paragraphs in a document? 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
What is the maximum number of inserted page breaks? Unlimited Unlimited
How many documents can be imported into a view? ?(the original (col. 2) has something wrong, syntactically, maybe it's)
Individual documents: up to 350K;
from a spreadsheet, 8192 rows;
5000 separate documents ?(the original (col. 2) has something wrong, syntactically, maybe it's)
Individual documents: up to 350K;
from a spreadsheet, 8192 rows;
5000 separate documents
cascading views in a database 200 200
How many copies of a document can be printed at once? 65,535 65,535
What is the maximum value allowed in "Start page numbers at" field? 65,535 65,535
margin size (in inches) 46 46
page cropping size (in inches) 46 46
point size to select/print 250 250
maximum number of soft-deleted documents in a database 1000 32,768
documents in a view Maximum of 128 GB for a view index.
(16 Mpage 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 Mpage 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? 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
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
How many responses per parent document? (bug:15,796 responses per document in R5 to 5.0.10) ??
What is the maximum number of entries in an Access Control List? 950 names
(I don't know if this has changed at all) 950 names
(I don't know if this has changed at all)
What is the maximum number of roles in an access control list? 75 Roles 75 Roles
What is the maximum number of ACL groups a user can be member of? 4096 5.0.9 up (pre-5.0.9, a bug may crash server over 3000 groups) 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)
(in R4: 6 levels) ?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)
What is the maximum number of documents you can cut or copy to the clipboard? 2335 (Win32) 2335 (Win32)
What is the maximum number of users to have authorized passwords on a multiple password ID? 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.
What's the maximum length of an environment variable value? 255 characters 255 characters
What's the maximum length of a string constant in @function formulas? ~2k characters ~2k characters
What's the maximum number of results that can be returned from a full text search 4,999 4,999
What's the largest URL HTTP will accept? 1024 (2048 5.0.10 up) 2048 (?)
What's the largest richtext field HTTP will update? ~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.
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.
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)
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)
What's the maximum line length of a line written by LotusScript Write statement? 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.
How many items can be in a Print, Write, or Input statement? 255 255
What's the maximum recLen in Open statement? 32767 32767
How many symbols can LotusScript handle? 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.)
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
How many outline entries can an outline have? ~21,000 entries ~21,000 entries
How long can a remote-console command be, and still display properly in Administrator? 77 characters. Some commands may handle more; others don't. The command itself is neither displayed nor logged as more than 77 characters. More than 77 characters (documented as "addressed" in K-Base, but no new maximum value is documented).
Note Even though strings in LotusScript 4 (that's Notes and Domino 5) can be longer than 64K, there are still restrictions with the length of the string you can read or write using the GET and PUT statements. The only combination of filetypes that will work with long strings is with a binary file and a variable-length string. Fixed length strings, strings in variants, and random files will not work with strings greater than 64K in length because they have a two-byte header which contains the length of the string. Two bytes cannot represent more than 64K.
Reference : http://www.thenorth.com/northern.nsf/ac567d6535ab069785256a00004d66dc/4100857248b8b82185256d350058f7e4!OpenDocument
Limit R5 (LotusScript 4) R6
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) 64 GB (gigabyte) or the OS file system's limit (2 GB on some older UNIX platforms)
What is the maximum size of plain text fields?
(What is the maximum size of a group Members field?) 15KB per (summary) text field;
30KB of fields per document (storage); 15KB displayed in a view's column 15KB per (summary) text field;
30KB of fields per document (storage); 15KB displayed in a view's column
What is the maximum size of a computed text field? ?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)
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
How many sublevels in a hierarchical view; how many documents at each level? 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
How many characters are allowed in names for views, forms, and so on? Database Title: 32
Filename: limited by OS's file system
Field names: 32
View names: 64
Form names: 32
Macro names: 32 Database Title: 32
Filename: limited by OS's file system
Field names: 32
View names: 64
Form names: 32
Macro names: 32
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
What is the maximum size for Mail recipient names? 2MB of recipient names (based on fully qualified names, for example, Les Kaplan @ Marketing). 2MB of recipient names (based on fully qualified names, for example, Les Kaplan @ Marketing).
How many mail rules in a mail DB? 50 100
What's the maximum password length allowed on an ID? 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.
How many fields in a form? 10MB memory (6MB memory for OS/2) 10MB memory (6MB memory for OS/2)
columns in one table 64 64
rows in one table 255 255
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
forms in a database 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
How wide can a column be (# of inches)? ?15KB displayed in a view's column (5.0.3 release notes) ?15KB displayed in a view's column (5.0.3 release notes)
What's the largest view column title allowed? 50 characters 80 characters
What is the total size of computable simple text fields? 63K 63K
How many paragraphs in a document? 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
What is the maximum number of inserted page breaks? Unlimited Unlimited
How many documents can be imported into a view? ?(the original (col. 2) has something wrong, syntactically, maybe it's)
Individual documents: up to 350K;
from a spreadsheet, 8192 rows;
5000 separate documents ?(the original (col. 2) has something wrong, syntactically, maybe it's)
Individual documents: up to 350K;
from a spreadsheet, 8192 rows;
5000 separate documents
cascading views in a database 200 200
How many copies of a document can be printed at once? 65,535 65,535
What is the maximum value allowed in "Start page numbers at" field? 65,535 65,535
margin size (in inches) 46 46
page cropping size (in inches) 46 46
point size to select/print 250 250
maximum number of soft-deleted documents in a database 1000 32,768
documents in a view Maximum of 128 GB for a view index.
(16 Mpage 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 Mpage 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? 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
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
How many responses per parent document? (bug:15,796 responses per document in R5 to 5.0.10) ??
What is the maximum number of entries in an Access Control List? 950 names
(I don't know if this has changed at all) 950 names
(I don't know if this has changed at all)
What is the maximum number of roles in an access control list? 75 Roles 75 Roles
What is the maximum number of ACL groups a user can be member of? 4096 5.0.9 up (pre-5.0.9, a bug may crash server over 3000 groups) 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)
(in R4: 6 levels) ?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)
What is the maximum number of documents you can cut or copy to the clipboard? 2335 (Win32) 2335 (Win32)
What is the maximum number of users to have authorized passwords on a multiple password ID? 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.
What's the maximum length of an environment variable value? 255 characters 255 characters
What's the maximum length of a string constant in @function formulas? ~2k characters ~2k characters
What's the maximum number of results that can be returned from a full text search 4,999 4,999
What's the largest URL HTTP will accept? 1024 (2048 5.0.10 up) 2048 (?)
What's the largest richtext field HTTP will update? ~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.
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.
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)
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)
What's the maximum line length of a line written by LotusScript Write statement? 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.
How many items can be in a Print, Write, or Input statement? 255 255
What's the maximum recLen in Open statement? 32767 32767
How many symbols can LotusScript handle? 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.)
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
How many outline entries can an outline have? ~21,000 entries ~21,000 entries
How long can a remote-console command be, and still display properly in Administrator? 77 characters. Some commands may handle more; others don't. The command itself is neither displayed nor logged as more than 77 characters. More than 77 characters (documented as "addressed" in K-Base, but no new maximum value is documented).
Note Even though strings in LotusScript 4 (that's Notes and Domino 5) can be longer than 64K, there are still restrictions with the length of the string you can read or write using the GET and PUT statements. The only combination of filetypes that will work with long strings is with a binary file and a variable-length string. Fixed length strings, strings in variants, and random files will not work with strings greater than 64K in length because they have a two-byte header which contains the length of the string. Two bytes cannot represent more than 64K.
Reference : http://www.thenorth.com/northern.nsf/ac567d6535ab069785256a00004d66dc/4100857248b8b82185256d350058f7e4!OpenDocument
วันพฤหัสบดีที่ 26 พฤศจิกายน พ.ศ. 2552
$KeepPrivate generate when "Replicate or Copy Documents."
In Lotus notes 6.5.4, just discovered this problem on a database that we have been using for years. In our case, this was caused by the new ACL choice "Replicate or Copy Documents." Any documents created by people/groups that don't have this box checked will then be marked with $KeepPrivate.
We fixed this by checking the box and running a one-time script to fix the existing documents.
Refer : http://www-10.lotus.com/ldd/nd6forum.nsf/e5f5333619f2996885256a220009508f/8ba390c7021a902185256f0a007b92d9?OpenDocument
We fixed this by checking the box and running a one-time script to fix the existing documents.
Refer : http://www-10.lotus.com/ldd/nd6forum.nsf/e5f5333619f2996885256a220009508f/8ba390c7021a902185256f0a007b92d9?OpenDocument
New IBM Lotus Connections Software Brings Consumer Social Networking Features to the Office
Realizing the benefits of Web 2.0 and Enterprise 2.0, IBM is bringing a comprehensive social software platform to businesses with the debut of Lotus Connections 2.5. The new software is being announced at an IBM worldwide collaboration summit in Cambridge, Massachusetts attended by hundreds of customers, partners and IBM experts gathered to discuss future developments in enterprise collaboration.
Today's Lotus Connections news is also taking place in conjunction with IBM's Center for Social Software Symposium this week, marking the one-year anniversary of the launch of the Center for Social Software. Lotus Connections, which originated at IBM Research, is an example of the types of technologies that result from the Center for Social Software's incubator for innovative technologies.
The new release of Lotus Connections expands on IBM's commitment to bringing a business-grade social software platform to the market. With the extranet, Internet and intranet collaboration services provided by IBM and IBM customers, Lotus Connections enables tens of millions of users worldwide to connect and collaborate.
For Lotus Connections beta program participant Sogeti, a Capgemini subsidiary specializing in technology services, there was a great need to connect the firm's 20,000 people spread across 200 offices in 14 countries. Following an extensive analysis, where all available options were reviewed, Sogeti turned to Lotus Connections for its social networking and collaborative functionality.
"Our people are our only and most valuable asset. We needed a powerful tool to connect our people all over the world, providing them with a social platform that would allow them to share information and collaborate," said Michiel Boreel, CTO at Sogeti Group. "We chose Lotus Connections because it is a powerful collaboration platform that goes way beyond simple sharing of documents and furthermore, it is people centric instead of project or document centric. We believe that this is the future of collaboration and we want to position ourselves in the frontline of this new trend."
Lotus Connections 2.5 includes an enhanced Communities experience with new features and capabilities. Community owners can now customize the appearance of their community and move widgets around on the community home page. Community owners can add activities, blogs, wikis, and file sharing services to their communities in addition to bookmarks, feeds, and forum capabilities. This significantly enhances the options for community members to collaborate on projects and content.
Refer : http://www-03.ibm.com/press/us/en/pressrelease/28456.wss
สมัครสมาชิก:
บทความ (Atom)