Export Schedule

  • Resolved jfdesignco2

    (@jfdesignco2)


    2 years, 4 months ago

    Is there a way to export the schedule to a new install? We redesigned my client’s site and need to export their current schedule to the new site.

Viewing 1 replies (of 1 total)
  • Plugin Author plainware

    (@plainware)

    Hello,
    I’m sorry for not replying sooner. Our plugin keeps its data in WordPress database tables so you can either move the whole WordPress database to the new site, or just export then import only ShiftController related data.

    wp_options: records where “option_name” starts with “sh4_”
    wp_posts: records where “post_type” starts with “sh4_”
    wp_postmeta: records where post_id in the results of the previous step

    Speaking in SQL, you’ll need to export the full results of the following queries, then load them into the new database keeping the records ids:

    
SELECT * FROM "wp_options" WHERE "option_name" LIKE "sh4_%"
SELECT * FROM "wp_posts" WHERE "post_type" LIKE "sh4_%"
SELECT * FROM "wp_postmeta" WHERE "post_id" IN(SELECT ID FROM "wp_posts" WHERE "post_type" LIKE "sh4_%")
Viewing 1 replies (of 1 total)
  • The topic ‘Export Schedule’ is closed to new replies.