We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

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,576
    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