Help with Email Address Exporter

[Woody619]

Hi,
I would like export all customer information,
name, email, address with postcode and phone number.

I have had a good search around the forums and had play with admin/email_export.php but can't get anything to show up in the file when downloaded using csv apart from just the column headings.

Can anyone point me in the right direction please?

[Chuckl]

Woody, Does it do this whatever audience you select from the dropdown?

[Woody619]

Woody, Does it do this whatever audience you select from the dropdown?

yeah I did try different audience but was still the same.

[Chuckl]

Very strange, it's not the most complex of mods...
Only things I can suggest are to check the query builder table in the database. I have had problems in the past with soft carriage returns in the table fields, or try a fresh copy of the files.

[Woody619]

Looking in all the other files for Email Address Exporter, admin/email_export.php is the only file I think I need to add anything to.

I have added

            $exporter_output .=  $FIELDSEPARATOR;
            $exporter_output .=  $FIELDSTART . "customers_telephone".$FIELDEND; 

So it looks like

        // add column headers if CSV or HTML format
          if ($format == "CSV" || $format == "HTML") {
            $exporter_output .=  $LINESTART;
            $exporter_output .=  $FIELDSTART . "customers_email_address".$FIELDEND;
            $exporter_output .=  $FIELDSEPARATOR;
            $exporter_output .=  $FIELDSTART . "customers_firstname".$FIELDEND;
            $exporter_output .=  $FIELDSEPARATOR;
            $exporter_output .=  $FIELDSTART . "customers_lastname".$FIELDEND;
            $exporter_output .=  $FIELDSEPARATOR;
            $exporter_output .=  $FIELDSTART . "customers_telephone".$FIELDEND;        
            $exporter_output .=  $LINEBREAK;
          } 

Now I think that should work to export the telephone number BUT it don't. It creates a column but no data.

Is there something else I need to add? where? and I can't find customers address field in the database, only customers_default_address_id? where is the postcode?

Thanks for your reply

[Chuckl]

Woody,
You are correct, what you have added IS the column header. if you look a bit further down the file, you will find the section where the actual data is added, and you need to add

$exporter_output .= $FIELDSEPARATOR;

$exporter_output .= $FIELDSTART.$audience->fields['customers_telephone'].$FIELDEND;

in the non XML section

[Woody619]

Woody,
You are correct, what you have added IS the column header. if you look a bit further down the file, you will find the section where the actual data is added, and you need to add

$exporter_output .= $FIELDSEPARATOR;

$exporter_output .= $FIELDSTART.$audience->fields['customers_telephone'].$FIELDEND;

in the non XML section

Yeah I did try that and the xml above it that never worked.

[Chuckl]

My apologies Woody, I finally understand the question you were actually asking...

When you select the audience for you export from the dropdown, you are actually selecting a predefined SQL query from the query builder table to select a set of data from the database tables.
In your case you want some data that is not contained in any existing entry, which means you need to insert an entry into the query_builder table that will return that data.
i.e. upload a SQL patch from admin that will create a new query, something like this:

insert into query_builder (query_category, query_name, query_description, query_string, query_keys_list) VALUES ('newsletters','My Address Export Query','Special Query for Customer Data Export','select c.customers_telephone, c.customers_email_address, \nc.customers_lastname, c.customers_firstname, o.entry_street_address as customers_street_address, o.entry_suburb as customers_suburb,o.entry_city as customers_city, o.entry_state as customers_state, o.entry_postcode as customers_postcode from TABLE_ADDRESS_BOOK o, TABLE_CUSTOMERS c where c.customers_newsletter = 1 AND c.customers_id = \no.customers_id GROUP \nBY c.customers_email_address order by c.customers_lastname, \nc.customers_firstname ASC','');

This will then give you a new entry in the dropdown list, which will return the telephone, address and postcode fields you were looking for, and you can then modify the export as necessary.

Rgds,

Chuck

[Woody619]

Thanks Chuck I will give that a try, thanks for the help.

[Woody619]

I didn't have any luck with that SQL patch, I got the extra dropdown box but it never exported any extra data. I tested all the formats.