I use Amelia on a WordPress multisite installation, because your plugin does not support any network syncing I have built some scripts to do it manually (for example to sync settings, services or employees). They all sync correctly except for an employees work hours (from the wp_amelia_providers_to_weekdays) table. Change made to the table in PHPAdmin are not reflected in the WordPress Dashboard. Can you let me know what I can do to be able to sync changes made directly in the database to the back end?
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we can log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Along with this, please provide me with the database access and I will assist you with this.
Since you're using a multisite installation, each sub-site likely has a different database prefix, such as "wp_amelia_...", "wp1_amelia_...", "wp2_amelia_...", and so on. Please check your database tables for these prefixes and make the necessary changes in each one. After each modification, check the WP backend to see when the changes take effect. This will help you identify the correct database prefix for the site you're working on.
We couldn’t replicate the issue locally and we don't have any custom scripts in place, so it's hard to determine if that's causing the issue.
Regarding admin access, our goal is to ensure the plugin operates correctly, as it does on our end and for most installations. If you can't provide access to the problematic site, please create a staging site with all sensitive data removed so we can investigate the issue.
I am looking at the correct table as when I make a change in the wordpress dashboard I can see the change in the table, however when I make a change in that same table it is not reflected in the wordpress dashboard. I have tested on a staging site with only your plugin installed and the issue remains.
You should be editing the "wp_amelia_providers_to_periods" table. When you edit that one, it reflects in the employee's working hours (see the attached screen recording). The "wp_amelia_providers_to_weekdays" table is being used only if the data from the "wp_amelia_providers_to_periods" table is deleted (for corresponding weekdays). Once we added multiple periods in Amelia (a long time ago), we kept the "weekdays" table so it continues to work for people who don't create multiple periods since those columns represented the first period only.
In short, if you edit the "wp_amelia_providers_to_periods" table, it will reflect the employee's working hours in Amelia.
hello,
I use Amelia on a WordPress multisite installation, because your plugin does not support any network syncing I have built some scripts to do it manually (for example to sync settings, services or employees). They all sync correctly except for an employees work hours (from the wp_amelia_providers_to_weekdays) table. Change made to the table in PHPAdmin are not reflected in the WordPress Dashboard. Can you let me know what I can do to be able to sync changes made directly in the database to the back end?
Thank you,
Sean
here are screen caps from phpmyadmin and wp dashboard. The settings in phpmyadmin are not reflected in the dashboard.
Attached files: dashboard.png
sql.png
Hello Sean,
Thank you for reaching out to us.
Can you please clear the cache and let me know if it updated times on the back-end?
Looking forward to your reply.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Hello, I tried that, and the time in the back-end and db still do not match.
Hello Sean,
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we can log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Along with this, please provide me with the database access and I will assist you with this.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
hello, because of data privacy laws I cannot share administrator access to my site as you would have access to my clients data.
can you try on one of your installs to see if you can reproduce this?
Hello Sean,
Since you're using a multisite installation, each sub-site likely has a different database prefix, such as "wp_amelia_...", "wp1_amelia_...", "wp2_amelia_...", and so on. Please check your database tables for these prefixes and make the necessary changes in each one. After each modification, check the WP backend to see when the changes take effect. This will help you identify the correct database prefix for the site you're working on.
We couldn’t replicate the issue locally and we don't have any custom scripts in place, so it's hard to determine if that's causing the issue.
Regarding admin access, our goal is to ensure the plugin operates correctly, as it does on our end and for most installations. If you can't provide access to the problematic site, please create a staging site with all sensitive data removed so we can investigate the issue.
Thank you!
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
I am looking at the correct table as when I make a change in the wordpress dashboard I can see the change in the table, however when I make a change in that same table it is not reflected in the wordpress dashboard. I have tested on a staging site with only your plugin installed and the issue remains.
Hi again Sean.
I understand the confusion now.
You should be editing the "wp_amelia_providers_to_periods" table. When you edit that one, it reflects in the employee's working hours (see the attached screen recording). The "wp_amelia_providers_to_weekdays" table is being used only if the data from the "wp_amelia_providers_to_periods" table is deleted (for corresponding weekdays). Once we added multiple periods in Amelia (a long time ago), we kept the "weekdays" table so it continues to work for people who don't create multiple periods since those columns represented the first period only.
In short, if you edit the "wp_amelia_providers_to_periods" table, it will reflect the employee's working hours in Amelia.
Attached files: dbChange.mp4
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Thank you! Syncing that table made it all work now!
You're welcome, Sean, glad I could be of assistance!
Let me know if there's anything else I can do to help.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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