Hi guys,
i was working on a scheduled script to generate a XML file using an example that i found on the following site:
http://codeboxllc.com/ksc/script-library/scheduled-scripts/scheduled-script-template/
However, i keep getting the following error, not sure what it is. its bugging me:
Code: SSS_INVALID_SRCH_OPERATOR Details: An nlobjSearchFilter contains an invalid operator, or is not in proper syntax: internalid.
Any help will be greatly appreciated.
//each scheduled script MUST have script parameter called Last Processed Internal ID. //ID of last proessed internal id is defined in CMWL_Constants.js var SCRIPT_PARAM_PROC_INTERNALID='custscript1'; var lastProcessedId = ''; var intID = ''; var MAIN_SEARCH_ID ='customsearch_sh_feed_items'; var ctx = nlapiGetContext(); //get execution context from server //main function function processSHFeed() { try { initScriptParam(); var items = getMainSearch(); //var items = nlapiSearchRecord('item', 'customsearch_sh_feed_items',null,null); var xml = ''; if(items && items.length > 0) { var SKU; var Name; var RRP; var inStock; var Category; var caption; var imageA; var imageB; var imageC; var Manufacturer; var shortdescrition; var ShippingRate; var onHand; var stockDescription; var parentURL; var urlSKU; var done = 0; //Following are not currently used // var Cost; // var ShippingCost; // var Brand; // var CreationDate; // var Description; // var ImageURL; // var url; xml = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'; xml += '<Products>'; //begin executing scheduled script for (var i=0; i < items.length; i++) { var columns = items[i].getAllColumns(); //Get URL SKU urlSKU = items[i].getValue(columns[18]); //Get Parent Internal Id if(urlSKU!='') { var x = nlapiSearchRecord('item', null, new nlobjSearchFilter('itemid', null, 'is', urlSKU), null); var item = nlapiLoadRecord('inventoryitem', x[0].getId()); parentURL = 'http://www.latestbuy.com.au/' + item.getFieldValue('urlcomponent') + '.html'; } //THE columns[0] REFERS TO THE RESULTS COLUMN NUMBER //ASSIGNED IN YOUR SEARCH - [0] IS THE FIRST COLUMN SKU = items[i].getValue(columns[0]); if(SKU == '') { SKU = items[i].getValue(columns[18]); } Name = items[i].getValue(columns[1]); RRP = items[i].getValue(columns[2]); Cost = items[i].getValue(columns[3]); //ShippingCost = items[i].getValue(columns[4]); onHand = items[i].getValue(columns[5]); Description = items[i].getValue(columns[6]); ImageURL = items[i].getValue(columns[7]); Category = items[i].getValue(columns[8]); Brand = items[i].getValue(columns[9]); CreationDate = items[i].getValue(columns[10]); caption = items[i].getValue(columns[11]); url = items[i].getValue(columns[12]); imageA = 'http://www.latestbuy.com.au/' + items[i].getValue(columns[13]); imageB = 'http://www.latestbuy.com.au/' + items[i].getValue(columns[14]); imageC = 'http://www.latestbuy.com.au/' + items[i].getValue(columns[15]); Manufacturer = items[i].getValue(columns[16]); shortdescrition = items[i].getValue(columns[17]); ShippingRate = '9.95'; stockDescription = 'Credit Card / PayPal orders before 12 noon dispatched same business day'; //Set Category if not set if(Category == "") { Category = 'Gifts and Gift Baskets'; } //Check Stock if(onHand>0) {inStock = 'Yes';} else {inStock = 'No';} xml += '<Product>'; xml += '<Name>'+ '<![CDATA[' + Name + ']]>' + '</Name>'; xml += '<MerchantSKU>'+ '<![CDATA[' + SKU + ']]>' + '</MerchantSKU>'; xml += '<ProductBulletPoint1>'+ '<![CDATA[' + caption + ']]>' + '</ProductBulletPoint1>'; xml += '<URL>'+ parentURL +'</URL>'; xml += '<ImageURL>'+ '<![CDATA[' + imageA + ']]>' + '</ImageURL>'; xml += '<AlternativeImageURL1>'+ '<![CDATA[' + imageB + ']]>' + '</AlternativeImageURL1>'; xml += '<AlternativeImageURL2>'+ '<![CDATA[' + imageC + ']]>' + '</AlternativeImageURL2>'; xml += '<MPN/>'; xml += '<UPC/>'; xml += '<Manufacturer>'+ '<![CDATA[' + Manufacturer + ']]>' + '</Manufacturer>'; xml += '<CategoryName>'+ Category + '</CategoryName>'; xml += '<ProductDescription>'+ '<![CDATA[' + shortdescrition + ']]>' + '</ProductDescription>'; xml += '<ShippingRate>'+ ShippingRate +'</ShippingRate>'; xml += '<StockAvailability>'+ inStock +'</StockAvailability>'; xml += '<StockDescription>'+ '<![CDATA[' + stockDescription + ']]>' + '</StockDescription>'; xml += '<Condition>'+ 'New' +'</Condition>'; xml += '<Bundle>'+ 'No' +'</Bundle>'; xml += '<MerchandisingType/>'; xml += '<CurrentPrice>'+ RRP +'</CurrentPrice>'; xml += '<OriginalPrice/>'; xml += '</Product>'; intID = items[i].getValue(columns[19]); if (meterCheckRescheduler(i,items)) { done = 0; break; } else { done = 1; } } if(done==1) { xml += '</Products>'; var file = nlapiCreateFile('product-feed-sh-netsuite.xml', 'XMLDOC', xml); file.setFolder(39); //39 is the internal id of the folder //write result on the same page // response.setContentType(file.getType()); // response.write(file.getValue()); //Write XML to File var id = nlapiSubmitFile(file); } } } catch (e) { nlapiLogExecution('ERROR','Runtime Error',e); //Additionally, you may want to send error email to your admins here } } /** * Checks to see if script needs to be rescheduled based on remaining script meter. * Scheduled script comes with 10000 points. * Make sure you set EXIT_COUNT variable above. * @param _curArrayIndex * @param _rslt * @returns {Boolean} */ function meterCheckRescheduler(_curArrayIndex, _rslt) { if (ctx.getRemainingUsage() <= 20 && (_curArrayIndex+1) < _rslt.length) { var schStatus = nlapiScheduleScript(ctx.getScriptId(), ctx.getDeploymentId(), getParam(_rslt[_curArrayIndex])); if (schStatus=='QUEUED') { return true; } else { return false; } } else { return false; } } function getParam(_rsltrow) { var param = new Array(); param[SCRIPT_PARAM_PROC_INTERNALID] = _rsltrow.getValue('internalid'); //params['custscript1'] = _intID; //ADD additional paramter. last processed internal ID is automatically added return param; } /** * Search items */ function getMainSearch() { var flt=null, col=null; if (lastProcessedId && !isNaN(parseInt(lastProcessedId))) { flt = new Array(); //add in additional filter option to reduce the result set: where internalID < last processed //flt[0] = new nlobjSearchFilter('internalid',null,'lessthan',parseInt(lastProcessedId)); //ADD IN ADDITIONAL DYNAMIC FILTER OPTION HERE } //return nlapiSearchRecord('item',MAIN_SEARCH_ID,flt,null); return nlapiSearchRecord('item', MAIN_SEARCH_ID, new nlobjSearchFilter('internalid', null, 'lessthan', lastProcessedId, null)); ; } /** * sets up script parameter if any. */ function initScriptParam() { lastProcessedId = ctx.getSetting('SCRIPT',SCRIPT_PARAM_PROC_INTERNALID); }