Thread

Hi, I’m trying to build a module that exports all the members data including custom member fields as a csv file. I would like the field title row to reflect the actual field name, not ‘m_field_id_22’ but rather map the field name ‘m_field_name’ from the ‘exp_memer_fields’ table to the corresponding field in the ‘exp_member_data’ table.

As you can tell this is quite a complicated query and array to asemble given the abstracted nature of expression engine database fields.

I am wondering if there is an inbuilt expression engine model that I could tap into to construct this query to help build the correct array for output in CSV formatting?

Does anyone have any ideas about how best to construct this query?

Hi Badlands,

If you take a look at the Member module, it does this very thing. Here’s how it does it (I’ve copied the code chunk into its own function for my own use):

function get_cmf()
{
    $fields = array();

    $query = $this->EE->db->query("SELECT m_field_id, m_field_name FROM exp_member_fields");

    if ($query->num_rows() > 0)
    {
        foreach ($query->result_array() as $row)
        {
            $fields[$row['m_field_name']] = 'm_field_id_' . $row['m_field_id'];
        }
    }

    return $fields;
}

Hope that helps. We may need to move this over to How-to if it doesn’t.  😜