7 var frameload = function()
9 var ifd = ifr.contentWindow.document;
10 var chk = ifd.getElementById('lines');
11 if (!ifd.getElementById('rptdataarea') || !ifr.contentWindow.reportTable
13 console.log('report not ready?');
14 window.setTimeout(frameload,1000);
20 console.log('report ready?');
22 if (chk.value !='T') {
24 ifd.getElementById('hddn_daterange1').value = 'CUSTOM';
26 ifd.getElementById('date1').value = '1/1/2008';
27 ifd.getElementById('date2').value = '1/1/2013';
29 ifd.getElementById('footerform').submit();
34 if ( ifr.contentWindow.reportTable.oContentProvider.bRequestPending
35 || !ifr.contentWindow.reportTable.isInLoadedState()) {
36 console.log('report not ready?');
37 window.setTimeout(frameload,1000);
44 console.log("TRY downloading!");
46 var ar = ifd.getElementById('footerform').elements;
48 for(var i =0; i < ar.length; i++) {
50 data[e.name] = e.value;
53 console.log(ifr.contentWindow.reportTable.getTotalRowCount());
55 'https://system.netsuite.com/app/reporting/reportrunner.nl',
58 reportaction: 'exportcsv',
60 visibleranges: '0,' + ifr.contentWindow.reportTable.getTotalRowCount()
68 // we really just want to send a series of download requests..
69 //https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403
71 var ifr = document.createElement('iframe');
73 ifr.setAttribute('src','https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=' + id);
74 ifr.setAttribute('width','900');
75 ifr.setAttribute('height','700');
76 ifr.addEventListener('load', frameload);
77 document.body.innerHTML = '';
79 document.body.appendChild(ifr);
82 var ifd = ifr.contentWindow.document;
83 ifd.getElementById('lines_chkbox').
85 var ar = ifd.getElementById('footerform').elements;
86 for(var i =0; i < ar.length; i++) {
88 data[e.name] = e.value;
92 data.lines_chkbox = 'T';
93 data.reportaction = 'exportcsv'
94 //data.visibleranges =
95 data.apptype = 'html';
97 'https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403',
104 downloaddata : function (url,data) {
107 var xmlhttp = new XMLHttpRequest();
109 xmlhttp.open("POST", url,true);
110 xmlhttp.responseType = 'arraybuffer';
111 xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
114 kv.push(i +'=' + encodeURIComponent( data[i]));
118 xmlhttp.onload=function() {
122 var r = new Uint8Array(xmlhttp.response);
123 for (i=0;i<r.byteLength;i++) {
130 method: 'nsdownloadpage',
131 filename : NS.id + '.csv',
132 headers : xmlhttp.getAllResponseHeaders(),
133 contentType:xmlhttp.getResponseHeader("Content-Type"),
139 xmlhttp.send(kv.join('&'));