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.