Mon, Dec 9th 2013 5:11a Paul Cable As I mentioned in a post last week, I have consulting at a client site that uses an Agile Project Management Methodology. As a Project Manager, I had thought that I have not used Agile before, however, I now understand that as a Project Manager / Developer for many years, I have previously been using an Agile methodology. In my very first job, after leaving university, I was coding a 4GL, and our Project Management Methodology was DSDM (Dynamic Systems Development Methodology). I went on a c [read] Keywords: consulting
Mon, Dec 9th 2013 5:11a Paul Cable Time is part of the Project Management Golden Triangle. I have blogged about the Golden Triangle before, but the concept is that you have Time, Scope and Quality, as three sides to a triangle and they all impact each other. If you extend one side of the triangle, one or both of the other two sides will be impacted. Time is an important aspect of Project Management. People who understand scheduling will understand how simple and how complicated time planning can be. On larger projects, t [read] Keywords: apple
Introduction to Change
Thu, Dec 5th 2013 8:12a Paul Cable Part of the overall project governance is the Change Control. This can refer to changes in the scope of the project, the budget, the Schedule, the services provided or the products the project produces. Change control needs to be in place to ensure that the project is delivered on time, to budget and delivers the required product. Change control ensure that any change introduced to the project is defined. Read more » [read] Keywords:
Excel - Add a Month
Fri, Sep 6th 2013 6:09a Paul Cable I use MS Excel extensively in my day to day role. Sometimes the simplest formula can stump me, but when I find a solution, I try to capture it and add it to this blog. This formula will take a date (say 1st Oct 2013) and then add one month to it. =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) Simple. [read] Keywords:
Can two Project Managers work on the same project?
Wed, Apr 3rd 2013 6:12a Paul Cable I think they can, as long as the relationship is clear and the roles and responsibilities are defined from day one. Management above the project must buy-in to the concept of having two project managers and must agree to the defined R&R. I am working on a large project. Within 6 months, working on the initial concepts, designs and plans in the initiation stage of the project, I realized that there was too much coordination, communication, vendor management, internal team management, user m [read] Keywords:
Fri, Feb 15th 2013 5:11a Paul Cable Wow - it is already the middle of February. 2013 seems to be going as fast as 2012 flew by. Before we know it, it will be Easter holiday time. This month has been a short month for me. I worked through Christmas, into the New Year and then took a week of holiday with my family to Centre Parcs. I have been back at work for three weeks and have not made time to write a blog. I have two poor excuses. The first is that I am trying to study for the PMI Risk Management exam. The second is that [read] Keywords:
Thu, Feb 14th 2013 5:08a Paul Cable I have been using iGoogle for many years and like the home page it have. I have, and use, only seven widgets on the home page, which I find very useful. The main use is the excellent bookmarks widget, which allows me to categorize my bookmarks and easily find (and add) bookmarks. Even my children know how to use this widget. Other widgets I use regularly are for Gmail and Google Calendar, to see my latest emails and diary entries. I do not have to open the individual apps, but can see the u [read] Keywords: google
Migration of BES from LN to Exchange
Thu, Nov 22nd 2012 3:10p Paul Cable I am currently running a project to migrate users from Lotus Domino to MS Exchange. One of the many migrations is to move our Blackberry users from Lotus Domino BES to the Exchange BES environment. We are currently running a Proof of Concept lab, where we have both the BES environments and I am looking for a tool to assist the migration of users from one to the other. We are using the Quest tool to migrate the nsf mail files, but I am wondering if anyone has had experience of migrating th [read] Keywords: domino
Mindmaps for web and Android
Sun, Nov 11th 2012 2:09p Paul Cable I am looking for a service to be able to create mindmaps on my Android tablet, as well as enable me to view and edit these on the web. The maps should sync with the tablet when I load it, or allow me to edit them offline. Does anyone know of such an app? [read] Keywords: blogger
Tue, Jul 24th 2012 2:12p Paul Cable I am looking for a quick solution to find some cheap lotus domino hosting. I have 3 databases which I share with three people. The total size of the databases are under 100mb. It does not have to be anything special and it could be a development solution. I have been looking around on the net, but nothing has taken my attention. Any tips, or insider information? [read] Keywords: domino
Why online backup?
Wed, Jul 18th 2012 8:12a Paul Cable Many people backup in one way or another. Some people on a regular basis create a CD or DVD of their important files, some people have a NAS drive stored away in a cupboard or in the garage and others save their files on multiple computers. There are many ways for the home user to back up.In recent times, it is not uncommon for insurance companies to send your certificates to you online, or to stop all of your paper bills from the utilities companies coming to you through the paper p [read] Keywords: blogger
Fri, Jul 13th 2012 6:11a Paul Cable As a mentor, I have often discussed with my team the fact that self development is important. I believe that every individual should take 30 minutes out of their working day to self learn. This would include reading relevant articles on the web, reading news sites and even technical manuals.30 minutes adds up to 2.5 hour per working week. This amount of time is small enough to not make an impact to your working productivity. However, the golden rule is that if you do not take 30 minutes today, y [read] Keywords: lotus
How many blogs should one have?
Wed, Jul 4th 2012 1:12p Paul Cable I am writing an open question to you all. How many blogs should one have?I am in the mind that one person should have a single blog. I write articles on several topics at the moment, one being Lotus Notes and the other being Project Management. Both of these blogs are under two different names, one being "Paul Cable" and the other being "The Secret Diary of a Project Manager".I 'think' I would like to copy my articles from the project management site into this site [read] Keywords: lotus
Thu, Apr 26th 2012 6:11a Paul Cable I wrote on a forum some advice to a permanent member of staff considering the option of contracting. The question was "How much experience do you need before you go contracting?". My answer was fairly short, but I thought it was interesting enough to make into an article to share with you, especially in a time when contractors are getting a bad press. I left university and after 18 months in two jobs, I went contracting. Not consulting, contracting. I was simply a developer assigned to a pr [read] Keywords: lotus
Is Android too risky for business?
Tue, Mar 27th 2012 6:13a Paul Cable I have both an Android phone and tablet. I actually have the new ASUS Transformer Prime, which is incredible. I like widget and the freedom to place anything on my phone. There are thousands of Apps available in the new Google Play store. However, I attended a Bring Your Own Device event last week which discussed the security implications. One main point that came across was how insecure Android is, for example there was recently an application for a touch (flash light for my friends in [read] Keywords: application
Do you backup?
Sun, Mar 25th 2012 3:11p Paul Cable I provide a solution to backup up to 5 computers automatically in the background. You can access these files from anywhere - via the web, or even on your smart phone. All your music, photos and files accessible anywhere, for just £25 per year. Empachal Backup is for personal and business use. It will allow 5 machines to be backed up for only £25 per year, which is under $40 USD.Imagine the heart ache of losing all your work, your family photos and your music collection. Data backup is ver [read] Keywords: blogger
Excel: Date to DOTW
Mon, Feb 20th 2012 5:13a Paul Cable Here is a quick tip / reference to how to calculate the day of the week from a date. =CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday") A handy tip ! [read] Keywords: blogger
Project Management newsfeed
Tue, Feb 14th 2012 5:13a Paul Cable I have used a site called Planet Lotus for many years, keeping up with all of the blog articles relating to Lotus Notes. This site is a valuable tool in today's busy world as it provides a collection, in date/time order, of all of the blog entries created by people in the Lotus Community. It is a fantastic resource. I am moving more into the Project Management world, I was looking for a similar resource. It does not exist. I am now trying (for free) to get a PM Community together and a col [read] Keywords: lotus
Visio Mind Map
Mon, Feb 13th 2012 12:10p Paul Cable Today I have been investigating how to communicate a mind full of notes to my project team. Previous companies have allowed the use of mind mapping software, either in house or on-line. My current client is a bank and limits the use of the internet and does not allow users to download software of use various web site, especially web applications. We are a heavy user of the Microsoft Office suite (with the exception of email) and I am limited. I am planning to present my current thoughts o [read] Keywords: notes
Thu, Dec 15th 2011 5:10a Paul Cable It is now time to pack up my desk for the second time in the same year. This is quite strange for me, even through I am a contractor. Usually I will stay with a company for a year or more, meaning that I never pack up my desk more than once. This contract was originally for three months, but has lasted six, with two additional extensions. Yesterday I handed in my notice and have managed to persuade my client to release me tomorrow. This means I can start my new contract on Monday, giving me [read] Keywords: blogger
Roaming and ID Vault problems
Wed, Nov 30th 2011 8:11a Paul Cable I have been working on a project for the last 5 months to upgrade users to Notes 8.5.2 FP2 from v7. In addition to this, we are moving people to the ID Vault and applying a Roaming policy. Since I have been here we have noticed that the design of the solution is not fit for purpose for this company, but was fit for purpose for the "other" joint head office. The solution was tested, but not tested enough and the scenarios of the varied working practices were not fully understood. Read mo [read] Keywords: id vault
Thu, Nov 24th 2011 6:09a Paul Cable Wow! I actually did some coding in Lotusscript yesterday. It was actually a pleasure, but not something I would like to do on a daily basis going forward. It is always nice to dust off some old skills and prove that you can still achieve something worth while and in a timely manner. My tasks was to simulate Planet Lotus. As far as I know, there is not a "Planet Project Management" and I would like to collect all of my PM blogs into a single webpage, updated hourly to see the latest blo [read] Keywords: lotus
Wed, Oct 5th 2011 6:11a Paul Cable Seeing as I have been a Senior Developer / Team Leader / Project Manager for the last 5-6 years, I thought I would try to get a qualification. In June 2011, I decided that I would set myself a four week target to get my Prince2 Foundation exam completed and then set a deadline of just three weeks after my summer holiday for the Practitioner exam. I decided that I would study Monday through Thursday evenings for 1-2 hours per night, once I was home from work. This worked well, as I could happi [read] Keywords: blogger
My new on-line backup service
Wed, Sep 14th 2011 6:09a Paul Cable Today our life is saved on a little electronic devise where we hold all our memories, favorite music and copies of all those important documents. Imagine the hard-drive failing and loosing it all... We have a solution for you that will give you peace of mind. We are launching an online back-up service. You will be able to backup all of your data daily and retrieve it anywhere in the world through our web portal, or even through your web enabled mobile phone. There is no need for additional ha [read] Keywords: apple
Teaching a new dog old tricks
Fri, Jul 29th 2011 6:10a Paul Cable We came across a new problem on my project last night. It seems that the "Preview in Web Browser" menu option is not available to users without the Designer client with version 8.5.2. We have a department who are using a Lotus Notes application for their Content Management System, which must allow the user to review their draft documents in a web browser. I do not recall this menu item missing with previous releases, however, after a little research I have discovered that this menu option [read] Keywords: lotus
An update on what I have been doing
Tue, Jul 5th 2011 6:08a Paul Cable I have finally left a company that I had the pleasure of work at for more than three years. As a contractor, that is a long time. It turned out to be 43 months in all, which I really enjoyed. I left at the end of May and moved straight into to a new contract for a large supermarket chain in England. The work is not what I expected. I am tasked with leading a small team to upgrade machines from Lotus Notes v7 to v8.5.1. This was sold to me as a development team leader role, but is in fact [read] Keywords: id vault
Sat, Apr 2nd 2011 4:21a Paul Cable I have a notes application as a replacement for MS Money 2008. Every month I import all of my account transactions into a notes database, via CSV import and it checks previous entries to categorize each transaction. This allows me to see where my wife spends all of my money each month! Occasionally I get lazy and do not download the transactions within the statement period and so the only way to import the transactions is to copy and paste the HTML table from the statement on the scree [read] Keywords: notes
XML - Part three - Import
Fri, Apr 1st 2011 10:51a Paul Cable This is the third XML article in this mini series. Please take a look at Part One, which talks about the Script Library and Part Two, which talks about the export agent, if you have not already seen these. The second agent I have written allows a user to import an XML file and replace all of the document fields with the values found in the XML document. My code takes the first "Document" from the "Documents" tree and finds the value, which is used as a key to find the document. With [read] Keywords: agent
XML - Part Two - The Export
Fri, Apr 1st 2011 10:43a Paul Cable This is the second XML article in this mini series. Once you have created the script library in your database (Part One), you can create the first of the two agents. The agent below allows a user to export the selected documents as XML. This creates an XML tree of "Documents", with each "Document" being a node. This code fixes the file destination to "C:TempDocument.xml", so you will have to change this to fit your requirements. I use a view to handle the field names to export, as [read] Keywords: agent
XML - Part One - The Script Library
Fri, Apr 1st 2011 10:39a Paul Cable I am going to write a three part post on how to handle the importing and exporting of XML files into Lotus Notes. Recently, I had a requirement to export a number of documents to XML. The file would then be read into a customers helpdesk, which was not Lotus Notes based. I have exported to XML before and have kept a Script Library in my "black box" for this very purpose. I did not write the script library, but I will share the code here. Read more » [read] Keywords: lotus
Google stop me embarrassing myself
Fri, Apr 1st 2011 5:28a Paul Cable I was just sending an important email, with a very important attachment... When I pressed the Send button, it stopped me and warned me that I have written "I have attached", and it then realised that I had forgotten to attach my document. Thank you Google for reminding me to attach my document. [read] Keywords: blogger
This blog is moving
Thu, Mar 10th 2011 9:09a Paul Cable I have decided to move this blog from using
the Lotus Notes based blog to using the Google Blogger application. Here
is the new link. http://paul-cable.blogspot.com/
Recently I have been moving more of
"my life" on Google using many of the other apps including Documents,
Calendar, Chrome, Picasa, Blogger, iGoogle and Gmail, all of which work
to some extent on my Google Android mobile phone.
I have sent a mail to "Planet Lotus",
so that my links can be updated.
See y [read] Keywords: lotus
Months as text
Thu, Mar 10th 2011 8:02a Paul Cable Below is some useful code I have used many times. This allows you to take a date field and display the month of the field. I have used this in categorised columns many times for many years. You have to make sure that if the month number is less than 10 that you prepend a "0", otherwise the month of 11 would become "JanuaryJanuary". Read more » [read] Keywords: apple
Thu, Mar 10th 2011 8:00a Paul Cable I have a number of templates where a rogue developer has locked the design and has lost the templates (or won't share them). There is a solution to unhide the design. 1. Make a local copy of the database 2. Ensure you have manager or designer rights. 3. Open up the .nsf file in a hexadecimal editor. 4. Change address 000000BC from the hexadecimal code 20 to 00. 5. Save the .nsf file. This does not seem to work with 8.5.1 [read] Keywords: apple
@DBColumn in LotusScript
Thu, Mar 10th 2011 7:46a Paul Cable Function DBColumn (strClass As String, strNoCache As String, strServer As String, strDatabase As String, strView As String, strKey As String) As Variant Dim strFormula As String,quotes As String quotes = Chr(34) strFormula = “@DbColumn(” & quotes & strClass & quotes & “:” & quotes & strNoCache & quotes & “;” & quotes & strServer & quotes & “:” & quotes & strDatabase & quotes & “;” & quotes & strView & [read] Keywords: lotusscript
Thu, Mar 10th 2011 7:42a Paul Cable I read this post on PlanetLotus today. It is a great four page list of Xpages code, which covers all of the common code used when developing. If you have not read this, please follow the link below for the article. I have also added this to my useful documents section. Link [read] Keywords: xpages apple
Fri, Jan 21st 2011 10:13a Paul Cable I read this post on PlanetLotus
today. It is a great four page list of Xpages code, which covers
all of the common code used when developing.
If you have not read this,
please follow the link below for the article. I have also added this
to my useful documents section.
Link [read] Keywords: xpages planetlotus
Tue, Dec 21st 2010 4:18a Paul Cable Today, thanks to this blog, I have discovered
a useful script function called "Split". I am sure I have
used it before, but it escaped my thoughts yesterday when coding the Excel
remember that it existed in LotusScript.
Thanks to a comment from Theo Heselmans,
my code is now updated and working better than before. This help
and advice is what I love about the Lotus Community. Thank you. [read] Keywords: lotus
A simple GetFormattedName function
Tue, Dec 21st 2010 4:18a Paul Cable A simple function I came across going through
some old code.
This code accepts a string and turns
it into a names field, from which you can send a parameter to get the different
types of name, such as Common, Canonical and Abbreviated.
"Canonicalize [read] Keywords: lotusscript
Export Field Revisions to Excel
Mon, Dec 20th 2010 1:13p Paul Cable At home today, due to being snowed in.
I like working from home as it keeps all the banter, telephone calls
and meetings to a minimum and when I am coding I like peace and quiet.
I know the developers I work with listen to music, but I don't really
like doing that.
Today I wrote a nice piece of script
to export document history to Excel. The document contains around
14 fields that are stamped when a history snap shot is taken. These
could be dates, text, names and number (no ric [read] Keywords: acl
Useful code snippets
Tue, Nov 23rd 2010 11:13a Paul Cable When I add some code the "Useful Code"
section of this blog, I never blog about it. I use it myself to collect
a number of useful functions and code snippets, ready for reuse anytime,
anywhere. So, I thought I would write this quick post to bring it
to your attention.
Today, I added some code given to me
a while ago, which I add into a button on a mail for users who need a connection
document created in their local name and address book. A useful piece
of code, but there are als [read] Keywords: lotusscript
Let the games begin
Sat, Nov 6th 2010 8:14p Paul Cable Today is the start of a four match series
for the England rugby team. I am a huge fan and have been a regular
player at Tring
Rugby Club for the last 6 seasons.
I have never played rugby before and only started playing at the
age of 29.
Today we are playing the world's number
one team - The All Blacks. They are consistently winning and playing
excellent, exciting, open, running rugby. Last week however, Australia
beat them in Hong Kong.
New Zealand are also famous for peak [read] Keywords:
Second in the World
Mon, Nov 1st 2010 8:25p Paul Cable I read in the news today that Google Android
is now ranked as the number two mobile operating system used globally with
a 17% share. Symbian is still the number one with 37%. This
surprised me, even though I am an Android advocate, I feel that I am under
constant bombardment from the iPhone users around me. Even my wife
has an iPhone.
I have never been a fan of the iPhone,
or the Apple brand for that matter. I have always seen it as being
a fashion accessory and felt that the spe [read] Keywords: ibm
Xpages Charting Choices
Sun, Sep 12th 2010 7:26a Paul Cable I am in the process of deciding which standard
for Xpages charting my client should use across EMEA. I would like
to use a simple option for now, one that is cheap, or free, and one that
all of the developers will be able to use.
I have looked into AMCharts, Google
Charts, Fusion Charts, JCharts and the standard charting option for Xpages,
I think the Google Charts were very
nice and had many options and themes, however, I am quite scared to use
Google, as they see [read] Keywords: domino
Fri, Sep 3rd 2010 2:26p Paul Cable Funny how things happen. I was teaching
a guy at work today the basics of Lotusscript and I wanted to refer to
the classic map that used to be visible when you open the designer client.
This map is a clickable map, which allows
you to understand the relationships between the different classes within
the Lotusscript object model.
Thankfully I came home today, read a
PlanetLotus and found this map,
thanks to Mat
Newman [read] Keywords: ldd