is there a plugin that will support my admin activities?

is there a plugin that will support my admin activities? I don’t want to know about user activity – which Reports would satisfy I think. I want to get a report, for example, of all pages and relevant info such as: id, name, parent, category(s), status, update date, author etc. I am wondering if there’s a generic report writing tool for use with WP so that I can define my own reports?

Thank you….. liz

  • Lizat
    • Design Lord, Child of Thor

    Ari et al,

    Any answer to this question. Basically I want a reporting tool for the back end (a development suggestion?). But something that would list my pages, parents and ket information would help a great deal.

    Thank you

    liz

  • aristath
    • Recruit

    I’m afraid I don’t quite understand what you need… Can you please elaborate?

    Do you only want to see your own posts, or everyone’s posts?

    Is this on a network installation or a single site?

    If this is on a network installation, do you want to see the posts throughout your network, or just on the current site?

    What info EXACTLY do you want to display?

    Please advise,

    Ari.

  • Lizat
    • Design Lord, Child of Thor

    Hi Ari,

    I want to report on, for example:

    • ALL pages, parent, status, author, date, categories
    • ALL Users, Name, email, type, date of creation, subscriptions
    • etc…..

    This is fairly standard reporting requirement for any db admin. I could SQL the back-end but I can’t believe I am the only person wanting this which is why I suggested it could be a plug-in requirement (assuming it doesn’t already exist).

    liz

  • aristath
    • Recruit

    Hello again!

    I’m afraid I was unable to find a plugin that will do this…

    However you can do it using some custom templates on your theme.

    Here’s what you can do:

    Create a page called ‘custom-query’ from your dashboard. If the ID of that page is for example 387, then you will have to create a new file in your theme and call it ‘page-387.php’.

    In that file, you can paste the following:

    <?php

    // The Query
    $the_query = new WP_Query( 'author=-999999' );

    // The Loop
    if ( $the_query->have_posts() ) {
    echo '<table>';
    while ( $the_query->have_posts() ) {
    $the_query->the_post();
    echo '<tr>';
    echo '<th>' . get_the_title() . '</th>';

    $meta_values = get_post_meta( get_the_ID() );

    foreach ( $meta_values as $meta_value => $value ) {
    echo '<td>' . $meta_value . ': ';

    if ( ! is_array( $value ) ) {
    echo $value;
    } else {
    foreach ( $value as $value1_key => $value1_val ) {
    if ( ! is_array( $value1_val ) ) {
    echo $value1_key . ': ' . $value1_val;
    }
    }
    }
    echo '</td>';

    }
    echo '</tr>';
    }
    echo '</table>';
    }
    /* Restore original Post Data */
    wp_reset_postdata();

    This will create a table containing ALL the posts and their metadata.

    Then you can do something similar for users.

    I hope that helps!

    Cheers,

    Ari.

  • Lizat
    • Design Lord, Child of Thor

    Hi Ar,

    Thank you so much for this it is a great help. I will add as a development suggestion because I think it would be useful for more than just me.

    Great service!

    liz

    (no resolved checkbox showing but it is now closed)

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.