We created this small web app for a client. They needed a solution to allow their vendors and contractors to submit and manage invoices. The application provided a web interface for third party vendors to access, as well as a FileMaker interface for back office access, all backed by a MySQL database.
Locals Know is a social travel application for the iOS and Android platforms. We worked on a web-based RESTful API used by the mobile applications to pull data from the server. Much of the structure for the API was already built by a previous developer. However, the existing code base had several outstanding issues. First of all, the database schema did not match the intended design of the app, and there were some other issues. We restructured the database, wrote migrations, modified the API responses, and fixed several other bugs. Beyond bug fixes, we also added additional API end points for new features and helped troubleshoot some issues with the API requests from the iOS application.
As well as dealing with the RESTful API, we built a client-facing web interface to allow users to view this content outside of the native mobile apps. Using the responsive design features in Twitter Bootstrap, we built this web interface to render on desktop web browsers, tablets, and mobile browsers.
In addition, to support this web interface, and the social nature of the app, we built a custom URL shortener system to aid in sharing content via Twitter and Facebook. The URL shortener created compact URLs, uniform in length, with no discernible pattern, guaranteed to be unique.
At Liquis, our team built a script, which would run on a Linux live CD, or USB bootable thumb drive, to automate the processing of PCs, laptops, and servers for resale after liquidation. The script used various linux utilities to extract hardware specifications, format them into XML and insert that data into the company’s FileMaker database. After this proess was completed successfully, the script would also securely erase the machine’s hard drive using a process based on DoD standards, in order to ensure to sensitive client data was left of the machines upon sale. For this project we made use of Linux Bash scripting; utilities like dd, dmidecode, and others; and FileMaker’s XML-based custom web publishing.
Partnering with our client, we worked on ongoing basis, managing the database and IT systems for Liquis, an asset management and corporate liquidation company. We built a custom FileMaker application which managed nearly every aspect of the company’s day-to-day operations. This included tracking of incoming trucks, pallets, and assets; automatically importing product photos for online sales, ODBC import/export with MSSQL-based eBay listing tool, Blackthorne; complex financial report generation; and automated pick and shipping systems. We also built a web interface, allowing clients to log in and view complete status of items entrusted to the company in real time. During this project, we used FileMaker Pro, PHP, MySQL, MS SQL, eBay Blackthorne, ODBC, rsync, Groovy, UPS Shipping XML API, Java printing APIs, among others technologies.