CSV export
- Thread starter FilMar
- Start date
Maybe you can use the listcsv plugin.
In "Export Headings PHP Code" you can change the heading texts.
I didn't try.
Popup says "Code to run before the header row is exported. The $listModel->csvExportHeadings array contains the headings (not keyed by element name), which can be modified. Returning false will abort the entire export. Will be run in addition to any selected file, so can call functions defined in the file(s)".
I don't think you can omit the header totally.
In "Export Headings PHP Code" you can change the heading texts.
I didn't try.
Popup says "Code to run before the header row is exported. The $listModel->csvExportHeadings array contains the headings (not keyed by element name), which can be modified. Returning false will abort the entire export. Will be run in addition to any selected file, so can call functions defined in the file(s)".
I don't think you can omit the header totally.
Wiki and download page.
Ok, I give it a try.
But as you say, it runs before the header row is exported. I think at best I have a row with only the sepeators but I will always have a header row.
Now it is not that great job to open the file and delete it manualy but that it easy forgotten. So an automatic way would still be great.
But maybe it is a solution for another problem I have as now I have a field that is formatted as 999-999-999 but it needs to be outputted in the CSV as 999999999.
So that is a possible solution here.
Many thanks and greetings,
Filip
Ok, I give it a try.
But as you say, it runs before the header row is exported. I think at best I have a row with only the sepeators but I will always have a header row.
Now it is not that great job to open the file and delete it manualy but that it easy forgotten. So an automatic way would still be great.
But maybe it is a solution for another problem I have as now I have a field that is formatted as 999-999-999 but it needs to be outputted in the CSV as 999999999.
So that is a possible solution here.
Many thanks and greetings,
Filip
cheesegrits
Support Gopher
It probably wouldn't be too hard to add an option somewhere in the CSV settings to skip the header row on export, although it would be something I'd have to charge a little to do.
And yes, the listcsv plugin is perfect for doing things like tweaking the format of specific column data. I use it frequently do things like that - normalizing phone number formats, date formats, etc.
-- hugh
And yes, the listcsv plugin is perfect for doing things like tweaking the format of specific column data. I use it frequently do things like that - normalizing phone number formats, date formats, etc.
-- hugh