Categories on the Export

I’ve the same “problem”. It would be great when the category is also an option in the excel. Keep up the good work!

@paulram85: As per the Forum Welcome, please post your own topic.

fritoebola and paulram85, Categories is next in line on my To-Do list.

I did the presets first since they were a bit of priority for most users.

??

Weeeeeeeeee!!!!!!

That answer just made my week… as I said that is what the plugin needs to be Peeeerrrrfect!!! ??

Any ballpark on when a new version of this will be complete with the category filter built in? The plugin works great but won’t do what I need unless filtering and exporting categories is an option.

Hello, you nearly save my life, just one step to make it ?? the problem is, that i have connected gravity forms and woocommerce. The files from woocommerce works perfect but i can’t finde from gravity form. Do you know how to do it?

Hello!

When you are trying to export a custom field with multiple-selection, on the report appears the word “Array” because surely on DB is an Array with the different values.

I’s possible to view this values on the file generated? Actually aren’t exported.

It’s a great plugin, thank you Yuri!

Hi Yuri,

It is indeed a great plugin, but I too really need to be able to export the Categories as well!

A few months ago you posted that this was the next item on your to-do list. Could you let us know when this feature will be ready?

Thanks!

I’ve just build the feature to export the categories (not the filter).
There are only two additions to be made in /controllers/class.phimind_excel_export_plus.php

First on line 50 add
$this->array_wp_custom_columns["categories"] = "Categories";

The second addition on line 318

case "categories":
$query = 'SELECT GROUP_CONCAT(t.name) as categories
FROM wp_term_relationships tr
INNER JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
INNER JOIN wp_terms t ON t.term_id = tt.term_id
WHERE object_id = '.$post->ID;
global $wpdb;
$field_value = $wpdb->get_var( $query );
break;

@yuri, could you insert this into the plugin?

Right!!!!
I must try it up later on too

Pionect: I added above code and the column header was displayed but nothing was populated.

what I did exactly. I copied your code and pasted on your said line then hit return to move the code that was previously there, to the next line. I then saved and refreshed the page. as I mentioned, the column and header were created, but not populated.

thanks!

@sterdog: I’ve changed my query to fit different database prefixes. I hope this will fix your issue.

case "categories":
global $wpdb;
$query = "SELECT GROUP_CONCAT(t.name) as categories
FROM ".$wpdb->prefix."term_relationships tr
INNER JOIN ".$wpdb->prefix."term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
INNER JOIN ".$wpdb->prefix."terms t ON t.term_id = tt.term_id
WHERE object_id = $post->ID ";
$field_value = $wpdb->get_var( $query );
break;