6 var frameload = function()
8 var ifd = ifr.contentWindow.document;
9 var chk = ifd.getElementById('lines');
10 if (!ifd.getElementById('rptdataarea') || !ifr.contentWindow.reportTable
12 console.log('report not ready?');
13 window.setTimeout(frameload,1000);
19 console.log('report ready?');
21 if (chk.value !='T') {
23 ifd.getElementById('date1').value = '1/1/2008';
24 ifd.getElementById('date2').value = '1/1/2013';
26 ifd.getElementById('footerform').submit();
31 if ( ifr.contentWindow.reportTable.oContentProvider.bRequestPending
32 || !ifr.contentWindow.reportTable.isInLoadedState()) {
33 console.log('report not ready?');
34 window.setTimeout(frameload,1000);
41 console.log("TRY downloading!");
43 var ar = ifd.getElementById('footerform').elements;
45 for(var i =0; i < ar.length; i++) {
47 data[e.name] = e.value;
50 console.log(ifr.contentWindow.reportTable.getTotalRowCount());
52 'https://system.netsuite.com/app/reporting/reportrunner.nl',
55 reportaction: 'exportcsv',
57 visibleranges: '0,' + ifr.contentWindow.reportTable.getTotalRowCount()
65 // we really just want to send a series of download requests..
66 //https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403
68 var ifr = document.createElement('iframe');
70 ifr.setAttribute('src','https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=' + id);
71 ifr.setAttribute('width','900');
72 ifr.setAttribute('height','700');
73 ifr.addEventListener('load', frameload);
74 document.body.innerHTML = '';
76 document.body.appendChild(ifr);
79 var ifd = ifr.contentWindow.document;
80 ifd.getElementById('lines_chkbox').
82 var ar = ifd.getElementById('footerform').elements;
83 for(var i =0; i < ar.length; i++) {
85 data[e.name] = e.value;
89 data.lines_chkbox = 'T';
90 data.reportaction = 'exportcsv'
91 //data.visibleranges =
92 data.apptype = 'html';
94 'https://system.netsuite.com/app/reporting/reportrunner.nl?reporttype=REGISTER&acctid=403',
101 downloaddata : function (url,data) {
104 var xmlhttp = new XMLHttpRequest();
106 xmlhttp.open("POST", url,true);
107 xmlhttp.responseType = 'arraybuffer';
108 xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
111 kv.push(i +'=' + encodeURIComponent( data[i]));
115 xmlhttp.onload=function() {
119 var r = new Uint8Array(xmlhttp.response);
120 for (i=0;i<r.byteLength;i++) {
127 method: 'nsdownloadpage',
128 filename : NS.id + '.csv',
129 headers : xmlhttp.getAllResponseHeaders(),
130 contentType:xmlhttp.getResponseHeader("Content-Type"),
136 xmlhttp.send(kv.join('&'));