Showing Bulk data on suitelet

This topic contains 3 replies, has 0 voices, and was last updated by Vinayak 7 years, 7 months ago.

Author

Posts
April 2, 2017 at 1:19 am #21738

Vinayak

Hello everyone,

Is there any way to show huge bulk of data on suitelet using sublist (on or table )also along with data there will be other fields to filter those results and also one button to process that list results. I am facing performance issues. Please advice if I can achieve this using HTML or some other method like pagination or any other best method.

Thanks
This is a cached copy. Click here to see the original post.
April 3, 2017 at 5:42 am #21739

Olivier Gagnon NC

Yes I have done this in the past. You can manage your own mechanism using an HTML construct (instead of NS sublist) and then maybe something like a JSON cache to manage pagination. Worked well when I did it.
April 3, 2017 at 5:25 pm #21740

michoel

Here is an example of doing something like this with DataTables for pagination

mos_product_search.js

Code:
/**
* Suitelet to make searching for stock codes really easy
*
* Script Type: Suitelet
*
*/

function getItems() {

var columns = ['internalid', 'itemid', 'salesdescription', 'baseprice', 'lastpurchaseprice', 'custitem_uom', 'upccode', 'quantityonhand', 'vendorcode'];

var searchcolumns = [];
for(var col in columns) {
searchcolumns.push(new nlobjSearchColumn(columns[col]));
}

var search = nlapiCreateSearch('item', null, searchcolumns);
var results = search.runSearch();
var items = [], slice = [], i = 0;
do {
slice = results.getResults(i, i + 1000);
for (var itm in slice) {
var item = {};
for(col in columns) { item[columns[col]] = slice[itm].getValue(columns[col]); } // convert nlobjSearchResult into simple js object
items.push(item);
i++;
}
} while (slice.length >= 1000);

return items;
}

function suitelet (request, response) {

switch(request.getParameter('custom_request_type')) {

case 'items':

var items = JSON.stringify(getItems());
response.write(items);
break;

case 'html':

var content = nlapiLoadFile('SuiteScripts/MOS Customizations/productsearch/mos_product_search.html').getValue();
response.write(content);
break;

default:

var url = nlapiResolveURL('SUITELET', 'customscript_mos_stock_code_search', 'customdeploy_mos_stock_code_search');
var form = nlapiCreateForm('Product Search');
form.addField('content', 'inlinehtml', '')
.setDefaultValue('<iframe style="display: block; height: 80vh; width: 100%; border: none;" src="' + url + '&custom_request_type=html"></iframe>');
response.writePage(form);
}
}
mos_product_search.html

HTML Code:
<!DOCTYPE html>
<html lang="en">

<head>
<meta charset="utf-8">

<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/r/zf-5.5.2/jq-2.1.4,dt-1.10.9/datatables.min.css"/>
<script type="text/javascript" src="https://cdn.datatables.net/r/zf-5.5.2/jq-2.1.4,dt-1.10.9/datatables.min.js"></script>

<script>
"use strict";

$(document).ready(function(){

$.fn.dataTable.ext.errMode = 'none';

var table = $('#table_search')
.on('error.dt', function (e, settings, techNote, message) {
console.log( 'An error has been reported by DataTables: ', message );
})
.DataTable({
ajax: function (data, callback, settings) {
var data = localStorage.getItem('product_data');
callback({ 'data': JSON.parse(data) || [] });
},
columns: [
{ title: "Code", data: 'itemid', width: "20%", render: function(data, type, row, meta) {return '<a href="/app/common/item/item.nl?id=' + row.internalid + '" target="_blank">' + data + '</a>';} },
{ title: "Description", data: 'salesdescription', width: "45%" },
{ title: "Supplier Code", data: 'vendorcode', width: "10%" },
{ title: "Barcode", data: 'upccode', width: "5%" },
{ title: "UOM", data: 'custitem_uom', width: "5%" },
{ title: "QOH", data: 'quantityonhand', width: "5%" },
{ title: "Last Cost", data: 'lastpurchaseprice', width: "5%" },
{ title: "Sell Price", data: 'baseprice', width: "5%" }
]
});

var url = window.location.href;
url = url.replace('custom_request_type=html', 'custom_request_type=items');

var updateData = function() {
$.get(url, function(data) {
localStorage.setItem('product_data', data);
table.ajax.reload(null, false);
});
}();

window.setInterval(updateData, 900000);
});

</script>

</head>

<body>
<div class="container">
<table id="table_search" class="display compact" cellspacing="0" width="100%">
</table>
</div>
</body>

</html>

david.smith replied on 04/04/2017, 10:32 AM: love datatables! great product.
April 9, 2017 at 4:01 am #21741

Vinayak

michoel

Hi michoel..

the code which u have given for bulk data, I tried with the same code but I am not able to fetch data from netsuite and also m not able to show on table… I guess when I run the script then html part ill get triggered but after m not able to call Item get functionality from HTML page… when I run the code it showing me table n loading message inside the table.Please help me to to solve the issue
Author

Posts

You must be logged in to reply to this topic.