Help with Export to Excel

[barnettc2]

We are using Valence 3, and I've used the extjs4 scripts.

<script type="text/javascript" src="/extjs4/ext-all.js"></script>
<script type="text/javascript" src="/vvresources/valence-extjs4.js"></script>

I'm trying to use the standard fnExportToCSV function as seen here...

function fnExportToCSV(){
		var tb = Ext.getCmp('mainIVLCCYGrid').getDockedItems();
		if (!dsMainIVLCCYGrid.sortInfo) {
			//var sortFld = '';
			//var sortDir = '';
		}
		else {
			sortFld = dsmainIVLCCYGrid.sortInfo.field;
			sortDir = dsmainIVLCCYGrid.sortInfo.direction;
		}
		Ext.DomHelper.append(document.body, {
			tag: 'iframe',
			frameBorder: 0,
			width: 0,
			height: 0,
			css: 'display:none;visibility:hidden;height:1px;',
			src: 'vvcall.pgm?sid=' + sid + '&app=' + app + '&pgm=IVLCCY&action=getCSV&limit=' + tb.pageSize + '&start=' + tb.cursor +
			'&sort=' +
			sortFld +
			'&dir=' +
			sortDir
		});
		
	}

In my console on chrome, I'm getting the error: Uncaught ReferenceError: sid is not defined.

Any advice to get this working properly? If I remove the sid part of the URL, the next error I get says that app is undefined.

Thanks,
Chris

[sean.lanktree]

This should work:

src: 'vvcall.pgm?sid=' + sessionStorage.sid + '&app=' + Ext.getUrlParam('app') + '&pgm=IVLCCY&action=getCSV&limit=' + tb.pageSize + '&start=' + tb.cursor +
			'&sort=' +
			sortFld +
			'&dir=' +
			sortDir

Note: the next maintenance update of 3.0 includes a much easier method:

Valence.util.download({
    pgm : 'IVLCCY',
    action : 'getCSV',
    etc.....
});

[barnettc2]

Thanks for the Response

Now I'm getting the error:

Uncaught TypeError: Cannot call method 'append' of undefined

I definitely look forward to the upcoming release.

[sean.lanktree]

Ext.DomHelper.append

has been changed to....

Ext.core.DomHelper.append

for Ext4.

[barnettc2]

Thanks!

That did the trick!