My new on-line backup service

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 hardware, or remembering to run a backup, it's so easy to set up and you can upload files by click and dragging them.  The backup will continuously check the PC against the files in the backup.  As a bonus, it will keep the previous 30 versions of any files that you update or delete.

 

Its safe, secure and only for September we are offering this service with unlimited storage for just £25.00 (instead of £44.99).  All you need to do is follow the link and sign up for the service.  You can find more information here on the website, or read the FAQ section.

Teaching a new dog old tricks

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 is not available in 8.5.2 if you do not have the Designer client installed.

I created a new text file in notepad and saved it with the name of "Designer.exe" and started Lotus Notes.  Hey presto! ... we have the menu option.

This little trick was used in the days of version 7, when you wanted to install Notes Designer....so, you can teach a new dog old tricks...

An update on what I have been doing

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 a desktop migration project and not a coding project.

…. hence the lack of technical blog posts recently.

I am making the most of this opportunity to improve my Team Leading and PM skills,  I have even picked up my MS Access skills since being here.  I do not have access to the developer client for Lotus Notes (first time since 1998) and therefore I had to improvise.  The previous team leader had set up a large spreadsheet which was being maintained by many people and was struggling from size and usage, so I suggested we simply import this into a multi-user access database.

It is strange to lead a team and a project in an area where my skill set only touches part of the project.  I do not have in-depth details of how to install software on machines using SMS/SCCM and how firewalls setting must be configured, login scripts written in vb and many other intricate details… but I do know Notes and how it works and is configured. 

I can contribute to the technical discussions when discussing details around roaming and Single Sign-on, location documents and ID Vault.  Thankfully, I have a Technical Lead in the team and another guy that seems to have a wealth of knowledge of notes, machines, vb and a is a general all-rounder.  It is strange, but enjoyable, to be hands off and trust these guys to make the technical decisions, as I am the one that used to be in that position for development projects.

I have decided that I am liking the Team Leader / PM type of role and have committed myself to self-learning of Prince2.  I am planning to have passed my foundation by the end of this month and plan to take the Practioner (if I can) before my holiday in August.  More of that in a future post, I am sure.

Button to open db on a particular server

We have many servers in our environment and we try to make sure users use their local server for their applications.  Below is a simple button to force a user to open an application on a particular server, which will place this replica on top of their replica stack.

Excel formula

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 screen.  When I paste this into Excel, it thinks it is text.  The problems start when I try to convert the text into a number, so that it can be imported.  Everything I had tried failed, such as various paste special techniques, convert cell and copy paste from notepad etc...

XML - Part three - Import

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 <id> value, which is used as a key to find the document.  With the <id>, I can find the document and then run through all of the fields in the XML and replace the values within the document.  The field name is the same in the document as it is in the XML file, so no mapping is required in this example.

XML - Part Two - The Export

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:\Temp\Document.xml", so you will have to change this to fit your requirements.

I use a view to handle the field names to export, as I do not want to export every field.  My field configuration will be the subject of a further post.  For now, think of it as a list of field names where there is one document per field.