• Hi

    I have made tables for member database. As far as I can see, there is only one option to export data ( all data) in the Data Explorer. Are there any options to export data from a search. That could be export by zip-code to various formats as SQL,excel,csv etc etc. Maybe as a push-button on the in the Data Publisher ?

    Best regards

    Lars Brandi Jensen

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Lars,

    The plugin offers two kind of exports:
    (1) Full table
    (2) Selected rows (from a search)

    (1) This options is available from the Data Explorer main page > Manage table > Actions tab. I believe you already found it.

    (2) To export selected rows, go to the Data Explorer, find your table, click on the Explore link of your table, select the rows you want to export, select your preferred export type from the bulk listbox and click Apply.

    If the second option is not available on your Data Explorer table pages, you might have disabled it in the plugin settings. You can find more information about these here:
    https://wpdataaccess.com/docs/documentation/plugin-settings/back-end/

    Hope this helps! ??

    Best regards,
    Peter

    Thread Starter larsbrandi

    (@larsbrandi)

    Ahh, got it. It was (2) and select the dropdown “bulk actions”

    Thread Starter larsbrandi

    (@larsbrandi)

    Is it possible to grant access to the Data Explorer via another user role as Admin ? I think here of a user role like subscriber + access to “WP Admin Access”

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Lars,

    It is possible to give non admin users access to specific tables, but you need to to write some PHP code. You can find an example here:
    https://wpdataaccess.com/2020/04/08/how-to-use-wp-data-access-classes-in-your-own-php-code/

    Another plugin user was asking the same question yesterday. I have an idea how to make this available for plugin users with no PHP experience as well. Let me know if you have no PHP experience. I can send you a message when the new feature is available. Hopefully this week…

    Best regards,
    Peter

    Thread Starter larsbrandi

    (@larsbrandi)

    Hi Peter

    I have plenty of PHP experience ?? I will try to mock around with the provided script. I will gladly appreciate if it is made an option in the plugin. That would be great.

    Best regards

    Lars

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Lars,

    What is the status of your topic? Did you make any progress?

    Thanks,
    Peter

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Export of data’ is closed to new replies.