Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/nextgen_settings/module.nextgen_settings.php on line 26 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/mvc/module.mvc.php on line 14 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/mvc/module.mvc.php on line 30 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/ajax/module.ajax.php on line 30 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/dynamic_stylesheet/module.dynamic_stylesheet.php on line 24 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/datamapper/module.datamapper.php on line 23 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/ngglegacy/module.ngglegacy.php on line 31 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/dynamic_thumbnails/module.dynamic_thumbnails.php on line 22 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/nextgen_gallery_display/module.nextgen_gallery_display.php on line 29 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/attach_to_post/module.attach_to_post.php on line 33 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/lightbox/module.lightbox.php on line 29 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/nextgen_basic_imagebrowser/module.nextgen_basic_imagebrowser.php on line 28 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/nextgen_basic_tagcloud/module.nextgen_basic_tagcloud.php on line 26 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 870 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/product.photocrati_nextgen.php on line 69 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/ngglegacy/nggallery.php on line 249 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/ngglegacy/nggallery.php on line 255 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/ngglegacy/nggallery.php on line 256 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/ngglegacy/nggallery.php on line 257 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-settings.php on line 214 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/organize-series/orgSeries.php on line 91 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/organize-series/orgSeries.php on line 92 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/organize-series/orgSeries.php on line 93 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/organize-series/orgSeries.php on line 94 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/organize-series/orgSeries.php on line 95 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/organize-series/orgSeries.php on line 96 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/organize-series/orgSeries.php on line 97 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/organize-series/orgSeries.php on line 98 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/organize-series/orgSeries.php on line 99 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/organize-series/orgSeries.php on line 100 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/organize-series/orgSeries.php on line 101 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-settings.php on line 214 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-settings.php on line 214 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/redirection/redirection.php on line 22 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/redirection/redirection.php on line 23 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/redirection/redirection.php on line 24 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/redirection/redirection.php on line 25 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/redirection/redirection.php on line 26 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/redirection/redirection.php on line 27 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/redirection/redirection.php on line 28 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/redirection/redirection.php on line 29 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/redirection/redirection.php on line 30 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-settings.php on line 214 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-settings.php on line 214 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-settings.php on line 214 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/w3-total-cache/inc/define.php on line 1478 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/w3-total-cache/inc/define.php on line 1478 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/wordpress-seo/wp-seo-main.php on line 269 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-settings.php on line 314 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-settings.php on line 328 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-includes/script-loader.php on line 51 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-includes/script-loader.php on line 566 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-includes/script-loader.php on line 51 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/redirection/models/match.php on line 74 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/redirection/models/action.php on line 24 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-blog-header.php on line 16 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/wordpress-seo/wp-seo-main.php on line 94 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-includes/template-loader.php on line 74 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-includes/template.php on line 501 Warning: include(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/themes/sacha-v3/header.php on line 1 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/wordpress-seo/wp-seo-main.php on line 94 LotusScript: Checking another database for categories that do not contain a document of a particular type - sacha chua :: living an awesome life Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: include_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/nextgen-gallery/pope/lib/class.component_registry.php on line 939 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-content/plugins/wordpress-seo/wp-seo-main.php on line 94

LotusScript: Checking another database for categories that do not contain a document of a particular type

We want to scale up Innovation Discovery and share the insights/workshop methods with more people, so one of my tasks is to remove sensitive information from our workshop output documents, post the scrubbed output documents in our community, and update the relevant sector page in our wiki.

This would be easier if people notified me after engagements, but at least we’ve gotten people into the habit of adding files to the Teamroom. I decided that instead of asking people to remember one more step in our post-engagement process, I would just regularly get into the habit of checking the Teamroom for updated documents. The Teamroom date view is useful, but there are other documents mixed into this, and I don’t think I can get my team members to adopt a consistent naming scheme or document type. However, if I wrote an agent to tell me which client categories didn’t have a final output document entry yet, I could use that to find new entries and follow up on old ones. So I did.

I didn’t have access to create new agents in the Teamroom database. I worked around this by creating this agent in my own database and then connecting to the other database from there.

Sub Initialize
	'This script looks for all the client categories that do not have a final documents entry
	'Display the current document's Categories field
	
	Dim dbID As New NotesDatabase("","dbom1\global18.nsf")
	Dim doc As NotesDocument
	Dim catView As NotesView
	Set catView = dbID.getView("CategoryLookup")
	'Determine list of clients
	Set doc = catView.Getfirstdocument()
	Dim clients List As String
	Dim finished List As String
	Do Until(doc Is Nothing)
		Dim category As String
		category = doc.Getitemvalue("Categories")(0)
		If (InStr(category, "Clients") <> 0) Then
			'This belongs in the client category. Has it been found? Add it to the list
			category = Mid(category, 9)
			clients(category) = category 
			If (doc.GetItemValue("DocType")(0) = "Final output") Then
				finished(category) = category 	
			End If 
		End if
		Set doc = catView.Getnextdocument(doc)
	Loop
	'Remove completed items
	Dim s As String
	s = ""
	ForAll client In clients
		If (Not IsElement(finished(client))) then
			s = s + client + " "
		End if
	End ForAll
	MessageBox(s)
End Sub

I change entries to the “Final output” document type after I’ve processed them. So far, so good!

Warning: require(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-includes/comment-template.php on line 1150
Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-includes/template.php on line 501 Warning: require_once(): Unable to allocate memory for pool. in /var/www/sachachua.com/blog/wp-includes/template.php on line 501