6 var frameload = function()
8 var ifd = ifr.contentWindow.document;
9 var chk = ifd.getElementById('lines');
12 console.log('report ready?');
14 if (chk.value !='T') {
16 ifd.getElementById('date1').value = '1/1/2008';
17 ifd.getElementById('date2').value = '1/1/2013';
19 ifd.getElementById('footerform').submit();
24 if (!ifd.getElementById('rptdataarea') || !ifr.contentWindow.reportTable
25 || ifr.contentWindow.reportTable.oContentProvider.bRequestPending
26 || !ifr.contentWindow.reportTable.isInLoadedState()) {
27 console.log('report not ready?');
28 window.setTimeout(frameload,1000);
35 console.log("TRY downloading!");
37 var ar = ifd.getElementById('footerform').elements;
39 for(var i =0; i < ar.length; i++) {
41 data[e.name] = e.value;
44 console.log(ifr.contentWindow.reportTable.getTotalRowCount());
46 'https://system.netsuite.com/app/reporting/reportrunner.nl',
49 reportaction: 'exportcsv',
51 visibleranges: '0,' + ifr.contentWindow.reportTable.getTotalRowCount()
59 // we really just want to send a series of download requests..
60 //https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403
62 var ifr = document.createElement('iframe');
64 ifr.setAttribute('src','https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=' + id);
65 ifr.setAttribute('width','900');
66 ifr.setAttribute('height','700');
67 ifr.addEventListener('load', frameload);
68 document.body.innerHTML = '';
70 document.body.appendChild(ifr);
73 var ifd = ifr.contentWindow.document;
74 ifd.getElementById('lines_chkbox').
76 var ar = ifd.getElementById('footerform').elements;
77 for(var i =0; i < ar.length; i++) {
79 data[e.name] = e.value;
83 data.lines_chkbox = 'T';
84 data.reportaction = 'exportcsv'
85 //data.visibleranges =
86 data.apptype = 'html';
88 'https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403',
95 downloaddata : function (url,data) {
98 var xmlhttp = new XMLHttpRequest();
100 xmlhttp.open("POST", url,true);
101 xmlhttp.responseType = 'arraybuffer';
102 xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
105 kv.push(i +'=' + encodeURIComponent( data[i]));
109 xmlhttp.onload=function() {
113 var r = new Uint8Array(xmlhttp.response);
114 for (i=0;i<r.byteLength;i++) {
121 method: 'nsdownloadpage',
122 filename : NS.id + '.csv',
123 headers : xmlhttp.getAllResponseHeaders(),
124 contentType:xmlhttp.getResponseHeader("Content-Type"),
130 xmlhttp.send(kv.join('&'));