Exporting Affiliates to a file?

[IlluminatorLady]

Hi there,

Is there a way I can export my affiliate list to a file?

Thank you!

Lisa

[amin007]

By “list of my affiliate” do you mean their email addresses or affiliate IDs?

You can get an email list (comma separated) of all your affiliates from the “Affiliate Emails” tab in the “Manage Affiliates” menu. Copy and paste it to a document

[IlluminatorLady]

Thanks, I should have been more specific.

I need a listing of Affiliate Names and IDs, at a minimum. Is there I can do this fairly simply?

[amin007]

If you can code in PHP then yes you can do this fairly simply

No, there is no feature that just gives you the affiliate names and IDs.

If you are willing to do some coding then let me know and I will give you some guidance.

[IlluminatorLady]

I’ve done a lot of coding in my time but haven’t taken the time to learn PHP yet. But it looks as though now is the time to bite the bullet.

So yes, I’ll take some guidance as to what the steps I need to follow are.

Also, can you recommend a good PHP/MySQL book to get me started?

Thank you!

Lisa

[amin007]

LOL… since you been nice and I had some free time I put together this simple script that will display all the affiliate ID and their names

Copy and paste it into a file (name it “display_aff_details.php”) and upload that file into the “wp-affiliate-platform” directory then access it from the browser.

<?php

include_once('../../../wp-load.php');

global $wpdb;

$affiliates_table_name = $wpdb->prefix . "affiliates_tbl";

$resultset = $wpdb->get_results("SELECT * FROM $affiliates_table_name ORDER BY refid DESC", OBJECT);

if ($resultset)

{

foreach ($resultset as $record)

{

echo "<br />";

echo $record->refid;

echo ', ';

echo $record->firstname." ".$record->lastname;

}

}

else

{

echo 'No Affiliates found.';

}

?>

I am sure you can tweak it to display more information and format the output however you want it. Any problem let me know.

Still interested in a good PHP & MySQL book?

[IlluminatorLady]

Thank you so much!! I will give it a run as soon as I can.

I am paging through the W3 Schools PHP tutorial for now (http://www.w3schools.com/PHP/), hoping that gives me enough of the basics to find my way around.

With appreciation,

Lisa

[Author]

Posts