serverside – Ursus Code

Boost Efficiency: Convert Large Netsuite CSVs to Excel XLSX

May 19, 2023 Adolfo Garza Comments 0 Comment

I faced a challenging project that involved converting large CSV files stored in Netsuite’s file cabinet into XLSX format, specifically in Excel files. These files varied in size, with some exceeding 30 MB and even 100 MB. Initially, I attempted to use SheetJS, a plugin designed for this purpose (https://docs.sheetjs.com/docs/demos/cloud/netsuite/). However, I encountered difficulties as the plugin loaded the entire CSV file into memory, causing errors and performance issues. To overcome this limitation, I devised an alternative solution for converting…

Snippet to create a delay in a server side script

May 15, 2017 Adolfo Garza Comments 868 comments

The motivation behind the creation of this function stems from the absence of a built-in setTimeout functionality in the server-side environment of Netsuite. Although I personally had not encountered the necessity for such a function, I recognized the potential value it could hold for others facing similar circumstances. It is essential to note that the provided code relies on a busy-wait mechanism, which is widely acknowledged as an antipattern and discouraged for use. This approach involves a loop that continuously…