I want to export 100,000 rows of a dataset using suitescripts. What is the best way to do this without hitting usage limits?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To export 100,000 rows of a dataset using SuiteScripts without hitting usage limits, you can use a combination of Map/Reduce scripts and the

N/task

module. Map/Reduce scripts are typically used for processing large volumes of data on a record by record basis. However, if you're trying to output a large volume of data in one CSV, you might want to consider using a scheduled script. If you're encountering a timeout, it might be because you're exceeding the script time limit. In this case, you could consider re-scheduling the script with a mechanism to know where to carry on from, or using the built-in yield functionality. The

N/task

module can be used to create a saved search task. This allows you to bypass the 10,000 row limit that is imposed by NetSuite on CSV exports. Here's a general idea of how you might use the

N/task

module:

javascript
var myTask = task.create({
    taskType: task.TaskType.SAVED_SEARCH
});
myTask.savedSearchId = 'customsearch_my_saved_search';
myTask.filePath = '/CSV Exports/myExport.csv';
var taskId = myTask.submit();

Please note that the above code is a simplified example and you may need to adjust it to fit your specific needs. Remember that there is a 10mb limit with files in the file cabinet, so you might need to split your data into multiple files if it exceeds this limit. Also, keep in mind that the 100,000 row limit is a NetSuite limitation and there's no setting to bypass this. If you need to export more than 100,000 rows, you might need to split your data into multiple saved searches or reports.

I want to edit the PO work flow