2. ASPRunnerPro General questions
  3. Export Field Names
This topic is locked

Export Field Names

 		5/19/2008 12:52:36
ASPRunnerPro General questions
R
 Rhoffman author

I just switched to ASPRunnerPro 5.2 from 4.1. Now when I export a table, I get the field names in the header and not the Label names as before. Is there a way to fix this? Users have custom Excel macros based on the old label names.
Thanks
Sergey Kornilov admin 5/19/2008

Starting with version 5.2 ASPRunnerPro uses field names instead of labels so export file can be imported back to the database.
If you like to use labels instead of field names open C:\Program Files\ASPRunnerPro5.2\source\export.asp in any text editor and make changes in bold:

sub WriteTableData

if rs.EOF then exit sub

'// write header

response.Write "<tr>"

if REQUEST("type")="excel" then

foreach Fields as @f filter @f.bExportPage order @f.nExportPageOrder##

response.Write "<td style=""width: 100"" x:str>" & PrepareForExcel("##@f.strLabel s##") & "</td>"

endfor
R
 		Rhoffman author 5/20/2008

That worked. Thanks.
A
 		apensler 11/7/2008

I am trying to find the way to export label names rather than field names on 6.0 and I cannot find it. The 5.2 instructions do not appear to be the same.
J
 		Jane 11/11/2008

Al,
above instructions work for ASPRunner 6.0 as well.

Where do you make your changes?
M
 		mmhsymon 6/23/2009

Al,

above instructions work for ASPRunner 6.0 as well.

Where do you make your changes?



thankx a lot