A clothing catalog is mostly photos, and the photos rarely come with good labels. A seller writes "nice outfit". A supplier sends a folder called new_final_2 . Somebody then has to look at each picture and type "scarf". This walkthrough turns that folder into a CSV: one row for every garment and…
I had a recurring need: a reproducible, offline snapshot of the remote-job market I could open in a spreadsheet, load into a database, or feed into a script — without scraping five job boards myself, juggling five different site formats, or maintaining five scraping pipelines that break every time…
I build dashboards that compute every number from the source data. The part people never trust is exactly that: you hand over a file, you get a page, and you have no way to know the page actually came from the file. So I made that checkable. There's a section on my landing page where a raw CSV sits…
Disclosure: I’m Hardik, Gixo’s solo founder. AI agents drafted this article and code example. The code example was checked by executing it in Node.js. This is a standalone educational calculation using synthetic data. A waterfall chart describes how a balance changes. The height of a floating bar…
My partner trades micro futures on a prop-firm account that bans fully automated trading. I wanted a tool that checks every fill against her own rules the moment it happens. Those two facts decide the design: the NinjaTrader side may read, and it may write files. It may not touch an order. This…
Looking through my script library, the same model keeps coming up. An SFTP upload Suitelet. A saved search exporter that writes CSV to the file cabinet. A module for multipart file uploads. A validator for journal entry lines during CSV imports. Payment file templates for ACH. I'd love to call that…
Every developer runs into the same small file questions, over and over: Is this download really the file the vendor published? What MIME type is this upload actually? Why is the server rejecting a file that "looks fine"? How many MB is 52,428,800 bytes again? Can I just look at this CSV without…
Part 8 wrote customers to a CSV file. The obvious next request is the reverse: "we have a list from the trade fair, can you load it?". And once an import can write a hundred customers in one click, the next question follows immediately: "and how do I get back to yesterday if it went wrong?". So…
Sooner or later every business application gets the request "can I have that in Excel?". With the main menu from part 7 there is finally a place for functions that belong to no single form, and a CSV export is the natural first one. The requirements were short: one line per customer, with the…
Someone asked me a question about a small feature I shipped. Seven words: "Is the exported file OK in Excel?" I said yes. The CSV was valid. RFC 4180 compliant. Every field quoted, every embedded quote escaped. Then I actually checked, and found three bugs. The file opened. It was also unreadable.…
