Hello,

We are trying to export taxonomy terms to a csv-file and would like them to be per term in a column.

Now it looks like this (comma seperated):
Ex-Students, Members, Qualified Financial Analyst
Qualified Financial Analyst
Group Board ABAF, Members, Qualified Financial Analyst, Teachers
Qualified Financial Analyst

But we would like to have a column for each term. So a column can only be populated with one term.

Is there someone that already tried this or knows how to accomplish this? Because we have been trying for days with no result.

Thank you !

Comments

svnindia’s picture

svnindia commented

The expected result is one row with terms as label ?

just one row or is there any other requirement in this?

marcmarc_’s picture

marcmarc_ commented

No, the result is 7 columns if you have 7 taxonomy terms. For each term a column.

So the first column is populated with 'Ex-Students', the second with 'Members', third with 'Qualified Financial Analyst', ...

svnindia’s picture

svnindia commented

You can create a view with terms to export in csv, by default it gives the result as row..
By customizing the template "views-data-export-csv-body.tpl.php" to override row as column....
The template can be found in "sites\all\modules\views_data_export\theme"

Thanks,
SVNindia

steven jones’s picture

steven jones commented
Status: Active » Fixed

Yeah, so override the template, or do something clever in views, like adding 7 different columns that either show a single taxonomy term or nothing, that'll get you what you want.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.