We have built several desktop and web based systems that generate reports based on data received via SMS. For example we developed the Kusanya SMS data collection system for an International NGO that is based in Westlands, Kenya but has operations in 15 countries in Africa. Basically they are funded by donors such as the USAID and United States President Malaria Initiative to spray malaria insecticide in over 15 countries in Africa. Their main problem was that they would issue a laptop and modem to each spray operator on the ground for uploading spray operation data such as insecticide consumption, distribution, household reconnaissance, number of children under five and pregnant women given nets among other operational data. This was not only cumbersome but very expensive rending the entire operation economically unfeasible. We developed a system that uses a low end phone such as a nokia 1100 (mulika-mwizi) to send an SMS to a modem connected to a desktop application that did analysis, collation, storage and reporting on demand. The system was piloted successfully in Ghana and Ethiopia
Above is a sample data collection sms with the predefined message format properly filled and the response
from the server system.
Tabular report of the data received from the field which can be graphed, printed or exported to excel
We customized the application for a local bank that has over 2000 door to door salesmen of loans, cards and accounts. Basically the system issues them with a unique sales personnel code that they use to remit sales data in real time from the field. thus management are able to have a picture of what is happening on the ground to make informed decisions and also improve personnel productivity.
This is a sample report generated by the Kusanya SMS Sales Tracking solution.
1st floor,La Contessa Place,Ring Road, Kilimani
P.O. Box 333-00502 Karen, Nairobi, Kenya
Mobile: +254710602452 | +254726489473