Okay
  Public Ticket #2605153
how can i migrate employees to a new amelia site
Closed

Comments

  •  2
    jenny domingo started the conversation

    Hi, we are rebuidling our site and i need to migrate our existing employees to a new site that will have amelia built in. I'd like to bring over all the services, settings, and employees the way it is setup now. is there a way to do this?

  • aqiyl replied

    Hello Jenny D,

    Download Wptables  by tms or by using your Cpanel to export data from old website to new website

    1. Log in to cPanel.
    2. In the DATABASES section of the cPanel home screen, click phpMyAdmin: ...
    3. In the left panel of the phpMyAdmin page, click the database that you want to export.
    4. Click the Export tab.
    5. Under Export method, confirm that Quick is selected. ... Dump all rows. 
    6. Under Format, confirm that CSV is selected. 

    Use internet as reference. Keywords: How to export  Phpadmin mysql into excel

    Hope that helps. 

  •  2,572
    Aleksandar replied

    Hello Jenny.

    Aqiyl, thank you for your assistance, but there's a little more to that.

    Since you need to copy everything (settings included), you need to copy all wp_amelia_ tables (41 tables from your database. Also, wp_ is the default WordPress prefix, but in your installation it could be anything, so you're looking for "your_prefix_amelia_" tables) into your new website.

    Then access wp_options table:

    6172199762.png

    When you access it, you can search through the column "option_name". Search for the term "amelia_settings":

    9596326323.png

    The search will return only one row, and you need to edit it:

    3462547772.png

    Copy the entire "option_value" cell:

    8351363226.png

    When you paste it in the same location of your new website, you will need to update some stuff:

    Redirect URIs for Outlook and Google Calendar:

    Google Calendar - change "youroldwbsite.com":

    "redirectURI":"http:\/\/youroldwebsie.com\/wp-admin\/admin.php?page=wpamelia-employees"
    

    To "yournewwebsite.com":

    "redirectURI":"http:\/\/yournewwebsite.com\/wp-admin\/admin.php?page=wpamelia-employees"
    

    Just make sure to enter real data, not "youroldwebsite" or "yournewwebsite".

    Outlook Calendar - same change - from:

    "redirectURI":"http:\/\/youroldwebsite.com\/wp-admin\/"

    To:

    "redirectURI":"http:\/\/yournewwebsite.com\/wp-admin\/"

    And finally, "pageUrl" from:

    "pageUrl":"http:\/\/youroldwebsite.com\/index.php\/employee-panel\/"
    

    To:

    "pageUrl":"http:\/\/yournewwebsite.com\/index.php\/employee-panel\/"
    

    That should do it. If you have any issues with this, please leave us a private response with the log-in credentials, and we'll help you out.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables