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.…
CSV Import Summary Field: Why It's Required and How It Breaks Your Data Key takeaways END STATE: a CSV import that updates an existing Jira issue's custom field, including an Assets/Insight object field, without accidentally overwriting the Summary, verified against Atlassian's own documented…
