Export CSV without column headers?

missinglina · Post by **missinglina** » Thu Apr 25, 2019 5:15 am

Greetings, All:

I am sure one of you savvy fellows knows the answer to this: What file do I edit and how to export to CSV without column headers?

Thanks!

arbei · Post by **arbei** » Thu Apr 25, 2019 9:32 am

You can customize the class ExportCsv or you can write a new class inherited from ExportCsv and then set:

$EXPORT["csv"] = "MyExportCsv"; // MyExportCsv is your new class for export

in server side Global Code.

You may also use server event "Row_Export" to export in your own way.

See the topic Server Events and Client Scripts in the help file for details about Global Code and the server event.

missinglina · Post by **missinglina** » Thu Apr 25, 2019 12:29 pm

Thank you! The problem is I don't know how to edit the class. And I did try to edit the Row_Export server event as follows (also Page_Exporting) but it did not work. The headers are still being exported in CSV. The column headers names can be seen below: They are: RecordCode,VoidedIndicator,AccountNo,CheckNo,CheckAmount,IssueDate,PayeeName

// Row Export event
// $this->ExportDoc = export document object
function Row_Export($rs) {

$this->ExportDoc->Text .= $this->RecordCode->ViewValue . "," . $this->VoidedIndicator->ViewValue . "," . $this->AccountNo->ViewValue . "," . $this->CheckNo->ViewValue . "," . $this->CheckAmount->ViewValue . "," . $this->IssueDate->ViewValue . "," . $this->PayeeName->ViewValue . "\r\n";

}

following a tip for the above, I also modified Page_Exporting like this based on the tip:

function Page_Exporting() {

return FALSE; // Return TRUE to use default export and skip Row_Export event
}

missinglina · Post by **missinglina** » Sat May 25, 2019 4:41 am

Also would be great to have the option to not export the row or rows with the aggregate totals. Useful to see it on the page, but would be nice to choose not to export it. I'm still looking for the solution to turn off exporting headers. Thanks.