Case: Together with Vulcan, we tackled a challenge involving the conversion of an Excel template into a format compatible with the BigCommerce platform. The task became complicated due to changes in the batch import function of the third-party vendor, leading to bugs and the absence of an error log made it hard to decypher the correct conversion.

Solution: Our Python-based solution transformed simple inputs into formatted column data, consolidating multiple data points. This streamlined the import process, significantly saving time and effort. Designed for adaptability, this module can accommodate diverse requirements. Hosted on an Amazon dedicated web server, it offers clients a reliable, user-friendly interface to ensure a good user experience and prevent unintended code alterations.

Case: Hubflow emerged as a platform connecting and facilitating learning among BJJ artists, schools, and seminars globally. Hubflow had several must haves for their online platform, such as; live chat function among members, google API location and distancematrix usage, cloud storage for database and rendering of digital art/photo's. The platform can be used by 3 different parties; Gym owners, Seminar hosts, BJJ Fanatics and the general public for information.

Solution: My role involved around the backend integration and the incorporation of various technologies:

• Python Flask Back-end for ultimate flexibility
• CSRF protection and admin dashboards
• Amazon S3 cloud (automated) storage
• Websocket usage for live chats between users
• Google authentication for accounts
• Mollie integration for premium membership payments
• Dynamic forms and pages
• Very Extensive Error Catching Module

Intro: CryptoBenelux stands as a prominent crypto-related news platform in the Netherlands and Belgium. It aims to provide comprehensive, no-nonsense information to the crypto community on a daily basis.

Case: CryptoBenelux writes her own blog articles. Cryptobenelux needed a so-called web-spider that duplicates the Dutch articles on the English version with a Chat GPT powered translation module. This to ensure proper translation of context. The solution should work day and night - and has to work autonymous.

Solution: We developed an autonomous web scraping and translation solution using OpenAI for translation and Python with various libraries for scraping. This solution saves approximately 200 hours annually for Cryptobenelux.

Case: We worked with a print shop in the US to set up an automation system. The main goal was to make things easier by moving images from S3 Amazon right to the webshop. We automated everything, paying attention to like colors, sizes, where to print on the product, the supplier, and descriptions created with GPT tech.

Solution: Our solution made the workflow smooth. We made sure images from S3 Amazon fit right into our webshop. This meant we had to think about things like different colors, sizes, print areas, various suppliers, and product descriptions written by AI (GPT tech). In the end, we got a system that works great and needs less manual work, making everything more efficient.

You may clone it via: LFG community bot

Please also refer to the following website:

• Pythoncheatsheet.org