• Latest versions
    Wordpress v5.4,
    Contact Form 7 v 5.1.7
    Flamingo v2.1.1

    Currently when in Admin under flamingo -> inbound messages “wp-admin/admin.php?page=flamingo_inbound”, when we click Export, the csv exported includes many (not all) blank rows with only the Date field populated. When I manually query the database (with query below), I see all the information that should be exported that is not.

    SELECT
    (SELECT
    pm1.meta_value
    FROM
    wp_postmeta pm1
    WHERE
    pm1.meta_key = ‘_field_contact-first-name’
    AND pm1.post_id = p.ID) AS firstname,
    (SELECT
    pm1.meta_value
    FROM
    wp_postmeta pm1
    WHERE
    pm1.meta_key = ‘_field_contact-last-name’
    AND pm1.post_id = p.ID) AS lastname,
    (SELECT
    pm1.meta_value
    FROM
    wp_postmeta pm1
    WHERE
    pm1.meta_key = ‘_field_contact-telephone’
    AND pm1.post_id = p.ID) AS phone,
    (SELECT
    pm1.meta_value
    FROM
    wp_postmeta pm1
    WHERE
    pm1.meta_key = ‘_field_contact-email’
    AND pm1.post_id = p.ID) AS email,
    (SELECT
    pm1.meta_value
    FROM
    wp_postmeta pm1
    WHERE
    pm1.meta_key = ‘_field_contact-message’
    AND pm1.post_id = p.ID) AS message,
    post_date
    FROM
    ct_it3r_b4u9s.wp_posts p
    WHERE
    p.post_type = ‘flamingo_inbound’
    and p.post_date between ‘2020-02-01’ and ‘2020-03-26’
    order by p.post_date DESC

    Can this be resolved?

The topic ‘Exporting Inbound Messages missing data’ is closed to new replies.