[Plugin: Contact Form 7 to Database Extension] import data in other plugin

  • Im working with your plugin, and im trying to import only lastname, Firstname, and email adress in another plugin called wysija-newsletters. in the mentioned plugin they have a handle code wich checks for other plugins: f.e ` ‘eemail_newsletter_sub’=>array(
    “name”=>”Email newsletter”,
    “pk”=>”eemail_id_sub”,
    “matches”=>array(“eemail_email_sub”=>”email”,”eemail_name_sub”=>”firstname”),
    “where”=>array(“eemail_status_sub”=>”YES”)
    ),`

    i would ask how I could manage to get the requested data from your plugin table?

    something like this

    ‘cf7dbplugin_submit’=>array(
    “name”=>”contact-form-7-to-database-extension”, …

    Im pretty new in programming and Im not able to figure this out, I think its more complicated because you use the submit time to handle the relationship of the data. Wouldnt it better to do 1 row for each incoming mail, with the rows inthere!?
    sorry for my bad english!!!
    greets max

    https://www.ads-software.com/extend/plugins/contact-form-7-to-database-extension/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    To get data from the table via PHP code, you can use the code shown in Create Your Own Short Code. But instead of creating a short code, you can use that code to query data from the table and loop through $row arrays.

    Thread Starter ottolo123

    (@ottolo123)

    thanks for your reply. It is also possible to do a shortcode, i can after use in another plugin!?
    I dont figure it out, how to retrive the data from your database table! How I mentioned, i want to use something like this in the other plugin to check for new data, it will then be imported automatically by this plugin.

    'eemail_newsletter_sub'=>array(
"name"=>"Email newsletter",
"pk"=>"eemail_id_sub",
"matches"=>array("eemail_email_sub"=>"email","eemail_name_sub"=>"firstname"),
"where"=>array("eemail_status_sub"=>"YES")
),

    I`m not a coder! sorry

    Plugin Author Michael Simpson

    (@msimpson)

    Seems like you would have to add code to that other plugin to check for new entries in my plugin. The code you provide is just an array data structure. I guess that other plugin does something with that? Maybe you should see if you can approach the problem from some hook in that other plugin.

    Thread Starter ottolo123

    (@ottolo123)

    im looking at it, i wrote to the plugin author, but he says It would be critical to import data from your plugin sorry not my text(“I looked at the db structure of the contact 7 to DB.
    And Wow, that’s messy ??
    Using our synchronising script there is no way you will be able to make it work.”)
    wouldn`t ther be a method to export a certain fields of your plugin

    eg.

    id firstname lastname email
    1 Maximilian Riffer [email protected]
    2 Max Mustermann [email protected]

    something like that, so i coul look forward to get the other Plugin to do the rest.

    its a bit to tricky to make it work as it is now!!
    thanks
    max

    Thread Starter ottolo123

    (@ottolo123)

    My other idea is to import mail lastname and firstname from the db of the importer automatically as not activated wp user. so w plugin imports the data automatically!! could you help me figuring out this idea!? thanks max

    Plugin Author Michael Simpson

    (@msimpson)

    As I said before, the Create Your Own Short Code shows how to programatically get data in the format. So you would have to see if whatever synchronization script you are taking about can hook up to that data. All the export functions product data in that format.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘[Plugin: Contact Form 7 to Database Extension] import data in other plugin’ is closed to new replies.