How to download all database from contact form 7?

—

by

Hazli

Hi,

I’m using Affiliate Pro with Contact Form 7.

1. How do I download all database refered from my affiliate via the contact form 7? I should be able to download them right for my reference.

2. Why is it I’m not getting all the information from the contact form 7 refered by my affiliate? It’s hard for me to track which lead is whose.

3. Plus I’m also getting this: http://screencast.com/t/MFvs5UfeJNah

I’ve enabled the notification setting.

Which I have the latest plugin installed and still getting the message.

By the way where can I donwload enable automatic updates for your plugins by itthinx?

Thank you.

Posted in
Tags ,

Comments

9 responses to “How to download all database from contact form 7?”

  1. Hazli Avatar
    Hazli

    Ok found it!

    Thank you Kento.

    But is there a way for me to download it to excel sheet?

    1. kento Avatar
      kento

      Currently not, but we’ll be adding new export features which will allow to do so.

  2. Hazli Avatar
    Hazli

    Hi Kento,

    Yes I need the database, all the information refered by my affiliate via the contact form.

    Because right now I’m not getting all the notification, and some conflict with which lead is whose by my affiliate.

    If I can have all the information, who refered who along with Name, Phone Numbers and so on, then it’ll be easy for me to track.

    Because I’m running it for local MLM company.

    And I can’t handle it without the master list.

    Thank you.

    1. kento Avatar
      kento

      Ok thanks, but you already have that information available under Affiliates > Referrals. Simply enable these filters on top of the page: Expand details, Expand descriptions, Expand data. And you can use the search field (also check the Descriptions option for the field) to track down individual referrals based on form data and lead details as that is recorded along with the referrals.

  3. Hazli Avatar
    Hazli

    Hi Kento,

    Sorry, I’m no technical guy. Seriously I have no clue what is MySQL or SSH.

    Do you have and documented walkthrough such as video that I can follow along?

    Thank you.

    1. kento Avatar
      kento

      Hi Hazli,

      Do you have phpMyAdmin available on your hosting account? Also, can you please explain what you want to do with the data you obtain from the database? Based on that, we can suggest a more appropriate solution taking into account the level of expertise you have with the facilities available.

  4. Hazli Avatar
    Hazli

    Hi Kento,

    I don’t understand. How do I do this:

    SELECT * FROM wp_aff_referrals INTO OUTFILE ‘/tmp/referrals.txt’;

    What I mean by contact form 7 database is all the information key in by the lead refered by my affiliate such as name, phone numbers, address etc?

    1. kento Avatar
      kento

      That’s a query you can run on the MySQL database directly, for example using phpMyAdmin. You would access that through your server’s admin panel provided by your hosting service. Or you can log in to your server via SSH and run that query through the MySQL console directly.

  5. kento Avatar
    kento

    Hi Hazli,

    #1 You can export referral data directly from the database using

    SELECT * FROM wp_aff_referrals INTO OUTFILE '/tmp/referrals.txt';

    We are also working on an export feature for referral data on the administrative back end.

    #2 Under Affiliates > Referrals you should enable Expand details and Expand data to see all data recorded along with the referrals.

    #3 The error message shown isn’t related to the plugins.

    #4 You should install the itthinx updater plugin using your service key. See Service Key for details and as shown in the screenshot from #3, you can click the link in the first message to install the plugin.

Share