Create a CSV file from the Results of a Saved Search via Script

Below is a sample script that creates a CSV from the results of a saved search. Please note that the saved search already exists.

// Creating the searchvar search = nlapiSearchRecord('transaction', 'customsearch93');// Creating some array's that will be populated from the saved search resultsvar content = new Array();var cells = new Array();var temp = new Array();var x = 0;// Looping through the search Resultsfor (var i = 0; i < search.length; i++) { var resultSet = search[i]; // Returns an array of column internal Ids var columns = resultSet.getAllColumns(); // Looping through each column and assign it to the temp array for (var y = 0; y <= columns.length; y++) { temp[y] = resultSet.getValue(columns[y]); } // Taking the content of the temp array and assigning it to the Content Array. content[x] += temp; // Incrementing the index of the content array x++;}// Creating a string variable that will be used as the CSV Contentvar contents;// Looping through the content array and assigning it to the contents string variable.for (var z = 0; z < content.length; z++) { contents += content[z].toString() + '\n';}// Creating a csv file and passing the contents string variable. var file = nlapiCreateFile('test.csv', 'CSV', contents);

DISCLAIMER: The sample code described herein isprovided on an "as is" basis, without warranty of any kind, to thefullest extent permitted by law. Netsuite Inc. does not warrant or guaranteethe individual success developers may have in implementing the sample code ontheir development platforms or in using their own Web serverconfigurations.Netsuite Inc. does not warrant, guarantee or make anyrepresentations regarding the use, results of use, accuracy, timeliness orcompleteness of any data or information relating to the sample code. NetsuiteInc. disclaims all warranties, express or implied, and in particular, disclaimsall warranties of merchantability, fitness for a particular purpose, andwarranties related to the code, or any service or software related thereto.Netsuite Inc. shall not be liable for any direct, indirect or consequentialdamages or costs of any type arising out of any action taken by you or othersrelated to the sample code.