Starting a new project

  • Resolved girl_number_5

    (@trutherone)


    6 years, 5 months ago

    Hello Peter,
    Just perusing this plugin and cant believe its a close to what i need as this …brilliant.
    I need an initial pointer on how to get started with a new database of about 16 tables with relationships between some tables. The database was migrated from Access and ive used it before in previous PHP/Mysql app; now i want to use it as the main Db for WP-Data-Access.
    1. Can i import the entire DB? or do i need to do it one table at a time
    2. should i merge the new DB with the WordPress Database or can i define a new DB, however later i want to allow access to the new DB based on user-level so ill need access to wp_users.

    I’m just a little stuck where to start … any help appreciated

    Thanks in Advance …

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

    (@peterschulznl)

    6 years, 5 months ago

    Hi,

    1. Can i import the entire DB? or do i need to do it one table at a time

    Yes, you can import the entire DB at once. Just pack all your script files into one ZIP file and upload the ZIP file from the Data Explorer (button “Import data/Execute script(s)”). To upload ZIP files your installation requires PHP ZipArchive to be installed. The plugin checks the availability of Zip Archive and lets you know if it is available.

    Please make sure your SQL statements end with a semi colon + a next line. You can write multiple SQL statements in one script. You should be able to export from phpMyAdmin and import with the Data Explorer. You can also export from the Data Explorer and import with phpMyAdmin. It that case however, you need to disable checkbox “Export with variable WP prefix” in Manage Plugin > Back-end Settings.

    2. should i merge the new DB with the WordPress Database or can i define a new DB, however later i want to allow access to the new DB based on user-level so ill need access to wp_users.

    Interesting question! 😉 At this time part of the plugin is available for other databases, but not all. With this version you cannot create a Data Project or a publication in another database. For now I think it’s best to store your tables in the WordPress schema and use some naming convention.

    There are some videos that explain how to get started with a Data Project, but I have to improve the documentation. Other users have asked for this as well…

    For that reason I moved the whole documentation to a public website. You can find the video tutotials here: https://wpdataaccess.com/docs/documentation/data-projects/video-tutorials/. I hope this help you, but it will not answer all your questions. This is my next challenge! 🙂

    I hope you’ll get it to work. Let me know if you need more help!

    Best regards,
    Peter

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years, 5 months ago

    Hi trutherone,

    I hope you have been able to find your way using the plugin. For now I’m closing this topic. If you have any questions, please ask! I’ll be glad to help.

    Best regards,
    Peter

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Starting a new project’ is closed to new replies.