Page 1 of 1

exporting data from Empower 2 to excel

Posted: Mon Apr 12, 2010 7:51 pm
by moonchips
Hi,
I am trying to export data from Empower 2 to an ACSII file. I was able to generate an export method. and then I went to the results tab, right click any one of the results, choose export with my export method. but nothing was exported to the destination folder.

I am wondering if we need to purchase any extra package to do that.

If no, could any one please tell me how to generate an export method, and use it to export data to various format.

Thanks a lot

Posted: Tue Apr 13, 2010 1:08 pm
by DR
Probable issue: Your report file is there, but you are not seeing it because Excel defaults to opening up *.xl* named files. Your report file is *.ars - so set Excel to look for all file types (choose option in the bottom of "Open File" dialog box). It should be there. If not, see below.



An export method just calls up a regular method and ships the data to a user specified file.

Generally, I take an existing sumamry method (just tables) and I strip the headers, footers and page breaks out. Then I do a "save as", naming it whatever_export. I create an export method that (on the Report tab) names the previous method and specifies a path and ascii file name on a local drive (in client server installations, don't save your files on servers).

Posted: Tue Apr 13, 2010 1:35 pm
by aceto_81
Probable issue 2: Maybe you tried to export on a mapped network drive?

I tried this this morning and you need to use "\\server\map" instead of "R:\"


good luck

Ace