Sunday 20 April 2014

Filing a bug report in KwaMoja

It appears from above that the administrator of webERP is shutting the project to new contributors, so it seems like a good time to run a series of articles on how to contribute to KwaMoja. Here is the first in that series:

image02Many people are nervous about reporting problems with open source projects. They fear that the developers will see it as a criticism. However all developers know that there is no such thing as "bug free" software. Any help they can get in tracking down and fixing these bugs is always appreciated.
KwaMoja uses a system called the bug genie to track any bugs in the software. We thought it waould be useful to write this short guide to filing bugs in KwaMoja using the bug genie.
Ok, so let's imagine that we have found a problem that we think may be a bug in the General Ledger Journal functionality (this will be an imaginary bug, I am not aware of any at the moment). The first thing we will need to do is to create an account for ourselves on the bug tracker. This is necessary firstly as it prevents spammers, secondly it enables you to track your bug, and for the developers to discuss the issue with you, enabling a dialog between you. Click here to enter the bug reporting section. You should see something like this:
If you already have a login, or you want to use one of the openid methods then
you can login from here. If you wish to create a new account then click on the tab marked "Register new account". You should now see a screen looking something like the one on the left.
image02Filling out this information and submitting it should give you a new randomised password. You should now login with the user and password combination that you have. You should consider changing the password at this point to one that you will remember.
You should now be taken to your dashboard page, giving you a summary of all your activity on bug genie. Obviously at the moment there won't be much on it!! If you are not taken to your dashboard, then click on your name in the top right hand corner and you should be taken there.
You should now see a menu bar at the top of the window looking like the picture
on the right. To enter a bug report select the "Bug Report" option and you will be taken to the main bug reporting screen. This has been kept deliberately simple. There are just three sections that you need to fill in.
  • Short Description
  • Description
  • Reproduction Steps
The short description should be brief but sufficient so that a developer browsing a list can quickly identify what it is about. Compare "KwaMoja doesn't work properly" with "General Ledger Journal gives the wrong total amount". Clearly the second is going to be easier for a developer to immediately understand the issue being reported.
The main description should contain as much information as you can about the issue being reported. You should include what version of KwaMoja you are using, what operating system and version you are using, a description of your server, and what browser you are using to view KwaMoja. Include any further information that you feel may be of use to the developers.
Finally there is the steps to reproduce the issue. Make sure you put everything no matter how obvious it may seem to you. Also include the results of what happens for each step.
Once you have submitted the report you should keep an eye out for feedback from the developer. It is likely you will get asked for more info, or be given a fix to test. Please reply to this feedback to help improve KwaMoja.

Tuesday 15 April 2014

Med-e-Tel in Luxembourg

Thanks to the sponsorship of Advanz of Luxembourg we had a great time at Med-e-Tel 2014.
The major aim of our presence was to promote the use of our open source solutions in developing countries. It was great to see other open source health systems present as well to help promote the concept of open source in hospitals.

There was  stand devoted to open source solutions, which was very well attended all week.

We had a lot of interest all week from all corners of the globe. We presented a paper on an implementation of Care2x in a large tertiary hospital. You can read the full paper here.


The presentation was part of the open source in health care session of the conference, and was very well attended with much interest in the various open source solutions for health care being presented.

I came away from the conference with the belief that we are on the right track with our solutions, and that open source really is the future for ICT in health care.

I have come away with renewed vigour to push forward with Project Mtuha and KwaMoja/Care2x solutions, despite the attempts by some to wreck the projects.

Again, much thanks to Advanz for their sponsorship and support without which our presence at the conference would not have been possible.

Friday 21 March 2014

Some properties of Automorphic numbers

This post is a complete change from my usual subjects.

Many years ago a man named Mike Mudge wrote a monthly column for Personal Computer World called "Numbers Count". There seems to be very little about him on the web, except for other fans like me. One such column inspired the following paper written jointly by my father[1] and I.

This work has just come to light during a recent house move that caused me to search through old papers, and despite it being 20 years ago, a quick search of the web shows that it still contains some original stuff, so I thought it would be interesting to publish it here. I am publishing it here unaltered, though obviously computing power has improved a lot over the years. I have tried to reproduce it exactly, but I may have made some transcribing errors, and if you see any please let me know.

Nb 20 years ago this work was unique to the best of our knowledge, but I can't promise that is still so.

Some properties of Automorphic numbers

Abstract: 

An automorphic number is is a number whose square ends in the same digits as number itself. Automorphic numbers form two series ending respectively in the digits 5 and 6. Successive members of each series have the same sequence of trailing digits and are formed simply by appending a new leading digit to their predecessor. Corresponding numbers in the two series bear a simple numerical relation to one another and are co-prime. Consequently, the sequence of one series uniquely determines the sequence of the other series. Some properties of automorphic numbers are discussed and these properties used to develop rapid and efficient methods for the generation of automorphic numbers. One such method generates numbers of up to 32,000 digits in length in a run time of 75 minutes[2]. n-Automorphic numbers to bases other than 10 are briefly discussed.

Introduction:

The computer generation of automorphic numbers using a simple trial and error process soon indicates that there are only three n-digit automorphic numbers for any value of n. One of these consists of the digit 1 with a string of leading zeros and may be regarded as trivial. In the case of the other two, it is found that with the exception of the leading digit, each n-digit automorphic number is identical with the corresponding n-1-digit number, and it is therefore only necessary to determine the leading digit for any n-digit  automorphic number. The following describes some properties of automorphic numbers and which lead to more efficient methods for their generation.

Methods

The generation of automorphic numbers was carried out with a Packard-Bell 445 elite 486Ssx running at 33mHz using programmes implemented in turbo pascal.

Results

Theorem 1 : 
For any value of n, there exists only two n-digit automorphic numbers and these end in the digits 5 or 6.
Proof: Let n= 10a+b represent a two digit number. If n is automorphic then 
 n^2=100a^2+20ab+b^2=1000z+100y+10a+b   .............................  (1)
and b^2=b+10x
where x is an integer. Only b=5 or b=6 satisfy this condition and therefore all 2 digit automorphic numbers must end in 5 or 6.

Substituting b=5 in equation (1) above gives
100a^2+90a=1000z+100y-20
90a must end in the digits 80 and therefore a=2 and n=25.
Substituting b=6 in equation (1) above gives
100a^2+110a=1000z+100y-30
110a must end in the digits 70 and therefore a=7 and n=76.

Let n=100a+10b+c represent a 3 digit number. If n is automorphic then 
n^2=10^4*a^2+2ab*10^3+b^2*10^2+2ac*10^2+20bc+c^2=10^5z+10^4y+10^3x+100a+10b+c ........ (2)
and c^2=c+10j where j is an integer, therefore the digit c must be either 5 or 6.
Substituting c=5 in equation (2) gives us 
10^4*a^2+2ab*10^3+b^2*10^2+10^3a+10^2b+25=10^5*z+10^4*y+10^3*x+100a+10b+5 ...... (3)
and 90b must end in the digits 80, therefore b must have the value 2.
By the same procedure substituting b=2 into equation (3) gives the value a=6. Substitution of c=6 in equation (2) and repetition of the same procedure gives values of 7 and 3 for b and a respectively.
Therefore to digit automorphic numbers can only be 25 and 76, and 3 digit automorphic numbers can only be 625 and 376.

Conjecture A

If p and q are any pair of n-digit automorphic numbers then p+q=10^n+1

Conjecture B

If p and q are any pair of n-digit automorphic numbers then p and q are co-prime.

Theorem 2

If p is an n-digit automorphic number and q=p-1 then pq=100s where s is an integer.
Proof: Let pq=1000a+100b+10c +d and p^2=1000f+100g+p
Then p^2-pq=1000f+100g+p-1000a-100b-10c-e=p
1000f+100g=1000a+100b+10c+e
Therefore c and d must be zero, and a=f, b=g, and pq=100s where s is an integer.

Theorem 3

If p is an n-digit automorphic number and 10^nA+p is the corresponding n+1-digit automorphic number, then A(2p-1)+x=k*10^n-1 where k is an integer and 100x=p^2-p
Proof: Let p=10a+b. If p is automorphic then 
p^2=1000l+100m+10a+b=100(10l+m)+p
Let x=10l+m then p^2=100x+p and 100x=p^2-p
Let the 3 digit number be 100A+p, then if this number is automorphic
10^4A^2+200pA+p^2=10^5*z+10^4*y+10^3*x+100A+p and 200pA-100A=p-p^2+1000k
Therefore A(2p-1)+x=10k
By the same procedure it can be shown that for the 4-digit number 1000B+100A+10a+b the leading digit B is given by the expression
B(2p-1)+j=k*10^2 where p=100A+10a+b, j*10^3=p^2-p, and k is an integer.

Theorem 4

If k is the square of an n-digit automorphic number j ending with the digit 6, then the le4ading digit in the corresponding (n+1)-digit automorphic number is 10-m where m is the coefficient of 10^n in k. For the corresponding n-digit number ending with the digit 5, the leading digit in the corresponding (n+1)-digit number is m where m is the coefficient of 10^n.
Proof: Let p=10a+b where p is a 2-digit automorphic number, then p^2=1000l+100m+10a+b
Let the corresponding 3-digit automorphic number 100A+p
From Theorem 3 above we know
A(2p-1)+10l+m=10k where k is an integer
Substituting p=76 we get 151A+10l+m=10k and A*l+m=10
Therefore A=10-m
Substituting p=25 we get 49A+10l+m=10k and A*9+m=10k
Therefore A=m

Theorem 5

For any value of n there exists only three-n-digit tri-automorphic numbers and these end in the digits 2, 5 or 7.
Proof: Let n=10a+b then 3n^2=300a^2+60ab+3b^2
If n is tri-automorphic then:
300a^2+60ab+3b^2=1000z+100y+10a+b  ..................  (4)
and 3b^2-b=10x   ............................  (5)
where x is an integer. This condition is only satisfied by b=2, b=5, or b=7
Substituting b=2 in equation (4), it follows that a=9
Substituting b=5 in equation (4), it follows that a=7
Substituting b=7 in equation (4), it follows that a=6
Corollary: 
For di-automorphic numbers, equation (5) becomes
2b^2-b=10x and b=8
For tetra-automorphic numbers, equation (5) becomes
4b^2-b=10x and b=4
For penta-automorphic numbers, equation (5) becomes
5b^2-b=10x and b=5

Discussion

Initial computer studies were carried out by testing numbers in sequence for automorphic character. The programme listing is shown in Appendix 1 [3]. As might be expected run times were very long and only 16 automorphic numbers were generated in a run time of 3 hours [4]. These studies did however demonstrate two important properties of automorphic numbers.
1. Only two n-digit automorphic numbers exist for each value of n
2. Such numbers form two series in which successive members differ from their predecessors only in the leading digit.

The first 8 members are shown for example below
Series 1525625062590625890625289062512890625
Series 2676376937609376109376710937687109376
Total11101100110001100001100000110000001100000001
In order to convert an n-digit automorphic number into the corresponding (n+1)-digit automorphic number it is necessary only to test the digits 0 to 9 for suitability as the leading digit of the next number. This obviously facilitates the computer generation of automorphic numbers. Furthermore it appears from the above table that the sum of a pair of n-digit automorphic numbers is equal to 10^n+1 (see Conjecture A above), and therefore a sequence of automorphic numbers is uniquely determined by the corresponding pairing sequence.
Theorem 3 allows the calculation of the leading digit of the next automorphic number in the series. If for example p=625 then A*1249+390=10k implies A=0 giving 0625 as the next automorphic number in the sequence. If p=0625 then A*1249+39=10k gives A=9 making the next automorphic number in the sequence 90625.
Theorem 4 provides a simple alternative method for the calculation of the next leading digit in automorphic numbers terminating in the digit 6. If p=376 then p^2=141376 and m, the coefficient of 10^3 is equal to 1. Therefore A=10-1=9 giving 9376 as the 4 digit number.If p=9376 then p^2=87909376 and m the coefficient of 10^4 is equal to zero. Therefore A=10-0=10 giving 09376 as the 5-digit number. If p=625 then p^2=390625 and m, the coefficient of 10^3 is equal to zero giving 0625 as the 4-digit number.The same procedure gives 90625 as the 5-digit number in the sequence.

The programme listing for this procedure is shown in Appendix 2 [5]. Using this procedure, the series of automorphic numbers up to 20,000 digits in length was generated in a run time of 54 minutes. Repetition of the procedure using an AST 486DX running at 50Mhz generated automorphic numbers of up to 32,000 digits in length in a run time of 75 minutes. As a point of interest it may be noted that the leading ten digits and the trailing ten digits of the two 32,000-digit automorphic numbers are as follows:
6351634399..............................................................................8212890625
3648365600..............................................................................1787109376


Appendix 3 lists all the n-automorphic numbers to base b where b=2 to 10 and n=1 to b-1 [6]. The following points may be noted:
1. No base 2 automorphic numbers are apparent.
2. It is conjectured that an (n+1)-automorphic number to the base (n+2) is of the form:
.......nnn(n+1). For the cases n=5, b=6 and n=9, b=10 there are two accompanying numbers while single numbers only occur for all the other cases.

[1] http://www.google.com/patents/US4877732

      http://www.google.com/patents/US3636037
      http://www.google.com/patents/US4249015
      http://www.google.com/patents/US3701779
      and others................... 
[2] Note the timings given in this paper were from the initial work carried out approximately 20 years ago, and obviously would be very different if repeated these days.
[3] Unfortunately this appendix has been lost, if I find it I will add it here later for the sake of completeness.
[4] I have just run a very simple python script and using a brute force method it generated the first 16 in 128.222 seconds!
[5] Again this programme listing was not found, sparing people from seeing my lack of coding skills from 20 years ago!!
[6] The loss of this appendix is a great shame as this gives some interesting information. I will try to recreate this data at some time.

Thursday 6 February 2014

KwaMoja version 14.02 is released

 KwaMoja version 14.02


This is a brand new version of KwaMoja with many additional features, and many enhancements from webERP.

There is a completely rewritten installer giving an option of 27 different charts of account donated by contributors from around the world. Users have the choice to upload some demo data, or to go through the entire hand holding procedure to set up a new blank company.

Internal stock requests can now be edited or cancelled on a per line or per request basis.

When making a payment to suppliers, the invoices can be chosen from within the payments screen, and all allocations are performed automatically.

Inventory can now be analysed on an ABC basis, to identify fast/slow moving items. This analysis can be done using different bases, and multiple analyses kept.

KwaMoja has a dashboard that enables multiple views of the status of orders/inventory/banks etc. to be shown on one screen. This is configurable on a per user basis.

There is a new and more intuitive user interface for those using it for whom English is not the first language.

Shipments can now be entered with a start date before today's date thus enabling a more sensible ETA date to be entered.

The code has been simplified and smartened up in line with the coding guidelines.

Numerous bug fixes have been applied.

Form as are now verified at client side, and better error dialogs are shown.

The full change log can be viewed here: https://github.com/timschofield/KwaMoja/blob/release_1402/doc/Change.log

The state of resource planning in African Industry

A proper history of ERP would be beyond the scope of this article so what below is a radical précis of the facts, simplifying occasionally for the sake of brevity.

In the nineteen seventies a new approach to manufacturing systems started to spread outwards from Japan. Generally credited as starting at Toyota where it had evolved over a period of years. This approach had several names JIT (Just In Time), stockless production, and Material requirements planning (MRP).

What was happening was that the capabilities of computers was being utilised to plan the resources being used in manufacturing to dramatically reduce the cost of holding and handling these resources. It became possible to plan exactly what resources were going to be needed and when. Then correct management of the supply chain meant that these resources could be in the right place at exactly the right time. Better planning and efficient use of resources produced better quality finished goods.

This revolutionary approach began to move through western businesses during the eighties with such companies as Hewlett Packard leading the way. Through the eighties and into the nineties most western companies adopted at least some of this new manufacturing philosophy, the most successful at implementing this became the most competitive, and survived the recessions of those years.

Computer software to help this approach was developed, at first in house, and then by ISV's. This was called MRP, then MRP II also CRP (Capacity Requirements Planning) eventually evolving into one integrated solution ERP (Enterprise Resource Planning).

Like most new market places there was an initial explosion in the eighties of many vendors supplying this software, followed up as the market matured in the nineties by a consolidation into a small number of vendors.

Then came the open source revolution of the new century, when there was again an explosion of new products onto the market place.

So, first Asian businesses, then American and European businesses adopted this new philosophy their products became highly competitive in the world market. Where did this leave Africa?

I first began to get involved with African businesses in the second half of the last decade and was horrified at just how few companies had adopted this approach to manufacturing. Too often the approach was "Labour is cheap, if we have a problem we throw more cheap labour at it". This approach comes with many problems. Most obviously quality falls when you employ cheap temporary labour, but there is also the social aspect of this. The small amount of planning that seemed to be done was done by hand or spreadsheet. The resource planning revolution had not reached Africa.

Poor control of resources also meant that businesses were losing a great amount of stock through theft. This had a double affect on the business, there was the loss of money that had to be used to replenish the stock, but also the failure to meet customer orders was costing them dearly.

This meant that African goods just couldn't compete with western companies that used sophisticated tools to keep quality high, and costs low.

It would be nice to say that African business owners took to ERP very quickly, but as it was in the early days in the west it was a struggle, but more and more businesses are now seeing the benefits of good planning.

The only software that has been available to African businesses has been produced in the west. This was one of our motivations in producing KwaMoja. We wanted to produce some thing that would benefit African businesses, and something that was produced in Africa, and something that African consultants can sell services around.

We are happy to announce that a new version of KwaMoja is ready and hitting the mirrors already. This is version 14.02 and you can download this version from here.

Sunday 19 January 2014

Comments on "ICT Aid projects in Africa - Why so many failures?"

I got a lot of comments on this article, but the article was printed in many places, and so the comments were dotted around. I thought it might be useful to bring them together in one place.

On the Human Resources Africa Group Steve Oloo said:
"May be its because the Projects lacked good visibility study. another thing that happens in Africa and in my case I can speak of Kenya. you find that the Government can change policies and tax in a day thus making the equipments outsourced to be expensive than initially planned hence going for cheaper options that are generally expensive... another thing that happens is that the level of poverty in Africa is too much that the creativity is diverted in the line of vandalism of ICT projects...one example is the fiber-optics which is the best invention and thought to be useful to ICT only but people in Africa vandalize the just to make illuminating flowers structures to sell to the public thus hindering its usefulness...
the right personnel is also a problem since Africa , Kenya in particular see papers rather than what you can do.... Lastly the level of corruption in Africa is so deep that even a good project for all humanity must be bribed so as to be implemented..making the initial cost be peanuts compared to the cost of implementation...."


On Africa - All Things Business Phil Johnny said:
"ICT projects failure in Africa is largely due to [ LACK of will power, dedication, commitment & passion] to ensure that people in Africa benefit from Information & Communication technology which they rightly deserve. Conflict & Corruption have been plaging the continent for years. There is no doubt tons of investment opportunities in Africa but without the right people (Authorities) in the corridors of power, things could easily get out of control and no one will be seen to account for the mess. Moreover, when the willingness and readiness to make needed sacrifices is not in the hearts of the leaders, all else fails. Therefore, a COMPLETE & GENUINE CHANGE OF ATTITUDE is absolutely necessary."

 On Accra Business Club - Africa | Ghana | Networking Andrew Brookes said:
"Tim great piece - very astute.
One obvious resource for ICT in Africa and other developing countries (India)is LInux and other free source software; but because the general ethos is that because people (e.g Ricard Stallman and GNU) don't charge there is next to no money to support projects. Microsoft on the other hand has a better business model ,so what it decides to get behind usually doesn't fail
Secondly it seems to me there is no thought or co-ordination by say the Ghana Government to take the data it has on official registered NGO's concerned with ICT and link activities together.
As you say some projects are maybe vague. What about this project i've been working on- You take the school wiki download a quality E-encyclodpedia of 6000 articles, 26 million words and 50,000 images which has been checked and based on the UK curriculum( http://schools-wikipedia.org) you enhance it with a search function and work out how say 10 or more children would be able to use it with a set up of server/client.
see http://www.youtube.com/watch?v=HkCjzlVQ6_g&feature=youtu.be
There would be potential to "personalize" the system if scholars and historians contributed since the E-Encyclopedia is basically a bunch of web pages that can easily be edited. Since the set up involves a web server there is the capacity to use it to teach children construction of web pages, CSS style sheets and computer languages such as PHP.
I have had a previous meeting with the ICT co-ordinator of the Ministry of Education in Accra, and I bet if I was sitting opposite him now and put the above to him I wouldn't be surprised if he could even comprehend the possible value of such a project.
Microsoft on the other hand has just appointed Otema Yirenkyi in Ghana; what I can imagine is if Microsoft comes and says "we have the money, the ideas etc so you don't have to do much " then its easy for those with lack of imagination, vision and leadership to just go along with it.
Personally I am not against Microsoft and admire their business model ; also there is potential for joint projects such as LInux servers and Windows clients
"
  

I replied:
"I agree fully with you Andrew. I wrote an article here http://weberpafrica.blogspot.co.uk/2013/10/africa-and-open-source-software.html on the subject of why African governments should look to open source as a way of building a local IT industry.
I do believe that if these governments invested the money they spent on foreign IT products and services in a local open sourced based IT industry everybody except the multinationals would gain,
I have set out in that article how I envisioned this working.
Very much like your wikipedia for schools. Have you tried the Ministry for Education? I am sure you are correct in what you would expect from them. I have previously come across the "if it's not American and expensive how can it be any good" philosophy in Govt departments. There are potentially donor organisations that could help.
"

Andrew Brookes commented:
"cheers Tim
from the perspective of an Educational resource which could be extended , I can not at the moment imagine a better one than the school wiki with search facility.When you say there are potentially donor organisations that could help, could you elaborate a little on who they may be and how I can contact them?
One problem I have is that I went through quite a few hoops to get an NGO registered in Ghana but don't have anything registered in the UK. I did try to get support in the U.K but the feedback is " we don't help organizations or charities unless they are UK registered"!
I am not keen to bang my head against a brick dealing with UK possible EU bureaucracy to be honest"

And I replied: 
"Getting money for an African NGO or other charitable organisation directly from western countries is very hard. Too much money vanished down that hole in the past. Going through a UK/EU based organisation provides any donor with some legal recourse if funds go missing.
However there are UK based organisations that already have this link between UK and Africa in place. One such that immediately springs to mind for your project is http://www.africaeducationaltrust.org which is UK based but works in Africa. There are others than could possibly help.
I have some other contacts that could possibly help. Contact me on tim.schofield1960@gmail.com if you would like us to try and work together to get this moving


On Windhoek Business Club - Namibia Ashraf Bharmal said:
"Wrong projects for wrong reasons. There are cases of spectacular successes too but few and far apart."
and Salehe Khatibu replied: 
"poor management of them "
and I said:
"@Ashraf Agreed. I feel that many donor organisations get this balance wrong because of a lack of local knowledge. A person or group is sent to Africa to evaluate the project. They stay in a luxury tourist hotel, are entertained by local people eager to say whatever they think is needed to be said to get the money flowing. None of this is wrong, but means that they don't get a clear view of what is needed and the people locally will not always tell them for fear that the project will not go ahead. 
@Salehe Very true. Project management skills are some of the hardest to learn, rarest, but least appreciated skills going. Bad leadership will cause failure whatever else happens"

On Dar es Salaam Business Club - Tanzania Catherine Mkude said:
"Dear all, My name is Catherine G. Mkude and I am a PhD researcher at the University of Koblenz-Landau in Germany working on a framework for e-government systems design for developing countries. In my research, I am investigating e-government strategies, programmes and projects (applications, infrastructures, comprehensive solutions, etc.) in developed and in developing countries. In doing so, I want to determine how developing countries can leverage from the more successful e-government endeavours in developed countries.
I am currently in a stage of collecting information on experiences, practices and solutions in 5 domains of e-government implementation in developed and developing countries. These domains are (1) electronic public services, (2) electronic participation, (3) application of information and communication technologies (ICT) in policy making processes, (4) e-government infrastructure and, (5) evaluation and sustainability of e-government.
Therefore I would like to kindly ask you to participate in a survey, which investigates these domains through separate questionnaires. I would highly appreciate if you could fill in one (or even more) of the below questionnaires. The responses for the questionnaires are entirely confidential and anonymous.
The following links direct you to the respective questionnaire per domain. The approximated time to fill in a questionnaire is also indicated below. Please choose the link(s) of the domain(s) you feel most comfortable to answer.

  1. Domain electronic public services: http://cmkude.limequery.com/index.php/983413/lang-en. Approximate time is 40 minutes.
  2. Domain electronic participation: http://cmkude.limequery.com/index.php/388819/lang-en. Approximate time is 40 minutes.
  3.  Domain ICT in policy making: http://cmkude.limequery.com/index.php/776413/lang-en. Approximate time is 35 minutes.
  4. Domain e-government infrastructure: http://cmkude.limequery.com/index.php/375388/lang-en. Approximate time is 30 minutes.
  5. Domain e-government evaluation and sustainability: http://cmkude.limequery.com/index.php/582399/lang-en. Approximate time is 30 minutes.
In advance I appreciate and thank you for your time and contributions. If you are aware of someone who I can ask to fill in either of the questionnaires, please let me know by email and I will invite them. Thank you and kind regards,  Catherine G. Mkude. "
Ashraf Bharmal said:
"Hope you paper will produce some positive results. Best wishes and Good luck"
Leticia Slame said:
"Hello Tim, it quiet interesting that has been my question why ICT Project fail to successed and if they successed it wont last long and most of the people have negative response, I will be glad if I get the reasons. "
and Ashraf Bharmal said:
"My Take:
1. Politically expeditious projects
2 Poor planning
3 FEEDS and Feasibilities , Colorfully printed, beautifully bound and presented, full of sound and fury in which affected sectors, people have no say.
4. Foreign contractors, not involving local entities in the project from the beginning who would gain hand on experience of the project, instead of six week orientation seminars at the end of the completed projects
5. Lack of post project planning of operating, maintaining."


On KwaMoja - Open Source ERP for Africa Nicholas Mmasi said:
"-Too many unfair side deals...people want to spend money and write a good report
- Demotivated staff ,less communication and unclear benefit of the system to the operating staff.
- No plan for sustainability right from the beginning,so once the donor pulls out the things end up there.
-Unrealistic requirements and system rationale... "

and I replied
"Hi Nicholas,
"-Too many unfair side deals...people want to spend money and write a good report "
I agree, I have seen too many "stage managed" visits by donors to sites where people at the sites have been given money to back up a false report.
"- Demotivated staff ,less communication and unclear benefit of the system to the operating staff. "
This is what I meant by lack of good project management. It is the job of the project management to motivate and communicate with staff.
"- No plan for sustainability right from the beginning,so once the donor pulls out the things end up there. "
Excellent point. Sustainability is some thing I should have gone into greater length about in the article. Who maintains once the donor leaves. Where does the financing of that support come from? "

Nicholas said:
"Hi Tim, Donors also have bad policies that are not applicable in Africa.I have been going around trying to see why so many projects fails eve before donors pulls out.
Almost all project are in pilot mode/Nursery and never get out of the lab.Similar scenarios are readily available and visible in areas of agriculture(farming technology and techniques), small scale industries, bio-gas,ICT, healthy ,and many more....
I normally find them in exhibitions only.... "

and I replied:
"Hi Nicholas, sadly you are right, despite most involved having the best intentions. I don't believe that it is necessary though, with some changes in policy and outlook a much higher percentage will succeed. There will always be failures but the failure rate shouldn't be this low. Tim "

On Information and Technology Lisa Schnellinger said:
"Excellent points. From my experience, I think they are often true of all types of development projects, in all regions. "

On Monrovia Business Club - Africa | Liberia | Networking Deodatus Shayo said:
 "Lack of ownership "

On Harare Business Club - Zimbabwe | Southern Africa Viola Marufu said:
"Tim, you have an interesting article. Interesting that you list your perspective as statements made from observations of certain African projects which does not necessarily implying that all projects are run like this. However, you should note that the major reason why some donors want local community members to staff and manage projects, rather than outsiders is because the locals know their community better and thats another way of empowering the community. Furthermore, it does not justify the expense of getting an outsider, so to speak, than getting an equally qualified local staff member.
You also say that ICT projects are a newer idea in Africa than in the west and there is limited number of qualified local project managers available. Thats not necessarily true. ICT projects are welcome and expanding in Africa. The current development is the spread of ICT effectively in rural communities and schools. In most areas the major setback is electrification. They are more and more qualified business people, educationists, economists and ordinary people who have well advanced ICT skills. So it is not necessarily an issue of skill but they are other factors influencing this. You are mixing points here.Furthermore if jobs are advertised, the right candidates apply for the job.
Then you say project employees are more interested in perpetuating the project than completing it, they prolong the project for personal interest etc. That is true where the project itself is not well managed. There is always need for an independent Monitoring and Evaluation exercise. They are also independent auditors.
A project that is really interested in benefiting the country in which its operating in will not wait to get a report on their desk. They will also put in measures to ensure all is well. This would be true no matter where the project runs. Whether its in Africa or the West, there is always need for accountability. "

I replied:
"Hi Viola, Thanks for your interesting comments. Firstly I should make clear that I am not nor have I ever been part of a donor organisation. I write from the perspective of someone who has either worked in, or observed many projects.
"Interesting that you list your perspective as statements made from observations of certain African projects which does not necessarily implying that all projects are run like this" - I agree, I tried to make the point I was writing from personal experience only, and was trying to answer why it appeared to me the failure rate was higher than normal in donor funded ICT projects. There is a high failure rate in all ICT projects.The UK NHS IT project is one of the most high profile failures.
"However, you should note that the major reason why some donors want local community members to staff and manage projects, rather than outsiders is because the locals know their community better and thats another way of empowering the community. Furthermore, it does not justify the expense of getting an outsider, so to speak, than getting an equally qualified local staff member. " - obviously it makes sense to employ local staff, my company always has, it keeps money within the local community. However my experience of projects where only local staff work has not been good, for reasons I said. It requires a balance that few projects actually have.
"You also say that ICT projects are a newer idea in Africa than in the west and there is limited number of qualified local project managers available. Thats not necessarily true. ICT projects are welcome and expanding in Africa. The current development is the spread of ICT effectively in rural communities and schools. In most areas the major setback is electrification. They are more and more qualified business people, educationists, economists and ordinary people who have well advanced ICT skills. So it is not necessarily an issue of skill but they are other factors influencing this. You are mixing points here.Furthermore if jobs are advertised, the right candidates apply for the job. " - Well again I can only comment from my own experience. Recruiting qualified local staff has always been a problem. I have regularly trawled the universities, and advertised extensively. I am not saying that there are not capable African staff, just that either they are either in private industry, or moved to the west. I have also seen many projects run by project managers with little or no training in project management. I tried in the article to understand why this is. Project management skills are very different from ICT skills.
"Then you say project employees are more interested in perpetuating the project than completing it, they prolong the project for personal interest etc. That is true where the project itself is not well managed. There is always need for an independent Monitoring and Evaluation exercise. They are also independent auditors. " - That is the point I was trying to make. It is human nature to make the projects last when you are earning money from it. The fault lies in the agencies not managing and monitoring the projects.
"A project that is really interested in benefiting the country in which its operating in will not wait to get a report on their desk. They will also put in measures to ensure all is well. This would be true no matter where the project runs. Whether its in Africa or the West, there is always need for accountability. " - Agreed, as I said at the start the only reason I wrote about Africa was that was where my experience was. "


As you can see, lots of very interesting comments came from this discussion on top of the comments on the article itself.


Tuesday 14 January 2014

Sustainability and Corruption in donor funded projects.

I wrote this article a couple of days ago and it attracted a lot of comments. Many of the comments focused on these two issues which I didn't go into in much detail, but they are very important to donor funded ICT projects.

These are somewhat controversial subjects so again I will keep from naming specifics.

Any donor funded project should be sustainable. That is it should continue to function when the donor leaves. Sounds obvious I know, but most people would be amazed at just how few do carry on working. Anybody who has like me, worked and traveled extensively in Africa will be able to recount stories of when this has failed. Here are just a few of mine:
  • Water pumps that cannot be maintained when they break down because there are no spare parts, no money or means to get them, nobody trained to fit them if they were available. 
  • Fields full of farm machinery (Tractors, Canadian sized combine harvesters etc) rotting away. Why? No spare parts, and nobody trained to maintain them.
  • I once visited a large hospital in East Africa which had a modern but non-functioning CT scanner. Again the reason given for its lack of functionality was that it had broken down and nobody could repair it. The hospital was losing considerable income from its not working. This income could easily have paid for a maintenance contract but nobody had arranged it. Lives were being lost in that area of East Africa because the only hospital with a CT scanner had no plan to maintain the scanner once it broke down. The hospital director told me that eventually somebody would donate a new one and the old one would be thrown away.
I am not finger pointing here, this is a story you will hear throughout Africa. In order for projects to be sustainable they have to generate some income, and that income has to be put back into the project in order to provide for the maintenance. For instance I saw a very good scheme in rural Tanzania where the donors had paid for a water pipeline bringing fresh water from a mountain spring many miles away. The local towns people were charged a few shillings (one shilling equals 0.00037 British pounds at current exchange rate) for the water. This money was used to pay local towns people to maintain the pipeline. The money stayed within the local community, and the water continues to flow to this day. Why can't a similar model be used for the above mentioned pumps?

I have seen projects providing hospitals with software. The hospitals were led to believe that the software was free, so no provision was made to support the system once it was installed. When bugs were found in the system there was nobody to fix them, and the software fell into misuse. However this software made the hospitals more efficient, improved their income, that income should have been used to fund local support for that software.

This is one of the reasons why billions of dollars in aid money floods into Africa but things never get better for its citizens.

The other reason is the corruption that follows these projects. I have over the years had conversations with people who have been found to have taken money from projects.  The common theme is always that they do not see it as stealing, or as something wrong. The best analogy I have is that aid money is seen like a river flowing down the mountain, and if you divert a little to irrigate your own field, then the water doesn't stop flowing, and you get a better harvest. The flaw with this argument is that the supply of money is finite and the river does stop flowing.

The best solution I have for this is closer and more rigorous scrutiny of the project by onsite managers who are appointed by the project donors to supervise the use of the money. Just the same as would be done with any commercial company when a budget is allocated to a project.

International aid is not working, but it can. It needs a change of attitude from both the donors and the receivers of the aid.