Here are some examples of work that we have done for our clients. Reference contact information is available on request.
The network coordinating office of the Addiction Technology Transfer Network (ATTC), a government funded not-for-profit organization located on the University of Missouri - Kansas City campus, helps to coordinate the efforts of 10 ATTC regional centers around the country. Originally, every regional center maintained its own website with its own database. Kansas City Web Programmers helped the coordinating office design and build a consolidated website and database for not just all of the regional centers in their network, but also 20 partnering agencies in the Prevention Technology Transfer Center (PTTC) and the Mental Health Technology Transfer Center (MHTTC). Using WordPress, detailed forms were built to capture all of the data needed from each center’s website. The data can also be compiled for regular government reports, which greatly improved the speed and efficiency of the regular reporting process and saved each regional center the costs of maintaining their own website.
KC Web Programmers helped the Peer Recovery Center of Excellence migrate data from an existing ASP.Net website with a Microsoft SQL Server database to a new WordPress website with improved design, resource searchability, and other enhancements. The Peer Recovery Center of Excellence, funded by the Substance Abuse and Mental Health Services Administration (SAMHSA), uses custom post types and enhanced filtering of events, resources, state certifications, and more.
KC Web Programmers took over the maintenance of an existing WordPress website for the Clinical Training Center for Sexual and Reproductive Health (CTC-SRH). Later that site was migrated to a new WordPress server with a refreshed design. All existing WordPress content was maintained while new content and features were added to create a more modern and easily maintained WordPress website that functions great in desktop or mobile sizes.
KC Web Programmers works closely with PLC Enterprises of Overland Park, KS to provide database driven features to clients in the power generation industry. Most recently, we used the Google Maps API to automatically find the closest generator technicians to a company’s generator sites and calculate the distances between generator sites across the country.
KC Web Programmers has worked with multiple departments of Ingredion's North Kansas City plant to enhance several existing Access databases used in daily operations from manufacturing to quality assurance. Eventually an ASP.Net Intranet was built with a SQL Server database. Each of the various Access databases in the plant has been upsized to the SQL Server database and the forms and reports converted to ASP.Net pages. The Intranet allows Ingredion employees from different departments to log in with their own accounts and see only the forms and reports specific to their role.
WeDriveU, based in Burlingame CA, provides chauffeuring services and transportation management to individuals and corporations. Kansas City Web Programmers built two different online reservation portals for WeDriveU. The first system used back-end ASP.Net web services to connect with travel software and independent and corporate travel agencies. Data is passed to WeDriveU as XML and is translated to a different XML format before it is stored in WeDriveU's reservation database. The second system is a user interface on the WeDriveU site for consumers to book their own reservations.
The Highland Plains Division (headquartered in Kansas City) of the American Cancer Society had a large Microsoft Access database used to track the planning and finances of fundraising events. We helped them turn the Access forms into ASP.NET Web pages to make this database accessible on the web. We then converted the Access database to a Microsoft SQL Server database to improve performance and reliability. From there we added extensive data-entry and reporting functionality so that hundreds of staff from around the Midwest can now update and view event data that was previously only available at Headquarters. (This is a password-protected extranet site and is unavailable to the general public)
In partnership with San Diego State University's Interwork Institute and Autosphere, Inc. of San Francisco, Kansas City Web Programmers built a distributed data collection system for the four island states of FSM. Each island collects data in an offline desktop Microsoft Access database and periodically uploads their data to a central web-accessible database. The central data driven site currently allows only password-protected access, but was designed to later allow public access to reports on the special education metrics of FSM.
