Data retrieval from a SQL database to post process with different analytical tools. The conditions for the data retrieval were the same everyday. So a cronjob was adapted to retrieve the data and send it to the collegues automatically by email. Everything using python, pandas, latex, SQL connectors, exchange server, .
Setup a Django project for end users to retrieve data from a SQL database giving specific arguments through a Form. The data is process in the backend with python and pandas and return HTTP a .csv file.
An invoicing department needed to send invoices using a specific .CSV file format through EDI. the existing invoice system already had a SQL database So a script with an SQL connector was made to connect to the database and retrieve the data. The .CSV file was customized according to the format of the buissnes partner. The program was designed be triggered automatically everytime a new invoice data was input into the database. But also an option to manually send a request through a django form for excpetions on the invoices.
Installed the Open source Home Theater Software KODI on a second hand Lenovo thinkcentre for home use. The thinkcentre size makes it suitable to have it right next to the TV. the OS was configured to boot directly to KODI on start up. Music, Videos and photos were stored on a NAS in the same network and accesed through FTP by KODI. The result is a very practical device next to the TV which allows to access all media resources on the NAS with a nice GUI. Any wireless keybard-like gadgets supplements it.
Task manager app
The setup was made on company's network premises.
Setup a Django project for a clan leader to manage in-game activities. Setup of users roles and profiles. Models for activities, registrations, participation, results and user achievements. Succesfully deployed on Heroku.
Setup a Django project for webscraping an online videogame website information. Online videogames websites publish real-time data that needs to be checked manually by the player. The webscraping script retrieves the data, evaluates preset conditions and if met sends an alert by email.
