Background of the issue:
I have a form on this page: hidden link. When the form is filled and submitted, it is supposed to send a thank you letter to the customer in Arabic. I have translated it using string translation in WPML.
Symptoms:
The thank you letter is being sent in English instead of Arabic, even though it has been translated.
Questions:
What should I do to ensure the thank you letter is sent in Arabic?
Hi,
Just to update you,
I deleted the notification message that the end user get and what ever I put in it it goes to end user, If I put Arabic it goes in Arabic for English or Arabic Version site and so on
Please help urgently
Site is live
Hi,
Thank you for amazing support
Another update,
I had to delete the notification that goes to customer in live site
Becuase customers getting wrong langugae in notification
Please fix
As mentioned in our previous conversation, I have created a staging site and made some modifications. During this process, some customers submitted new entries through WPForms on the live site, but these entries do not appear on the staging site. Unfortunately, WPForms does not provide an option to export entries from the live site and import them into the staging site, which complicates the synchronization process.
I reached out to Hostinger, and they suggested importing the WPForms tables from the live site database to the staging site. I have attached an image of the relevant tables for your reference. However, I suspect this may be contributing to the problem, as I deleted the notification message, saved, and recreated it, but the issue persists. Currently, when someone fills out any form, they receive an English notification email, regardless of the language version of the site they are using.
Additionally, prior to the staging setup, the default language was English, and the site appeared as follows:
-English: hidden link
-Arabic: hidden link
After changing the default language and publishing the site, the URLs changed to:
-Arabic: hidden link
- English: hidden link
PS. I changed deafault language after publishing the site.
I hope this information helps resolve the issues quickly, as the site is live and I am receiving complaints from customers.
Thank you for the details. I have shared it with our team for an expert opinion. And also made a copy of the site using the Duplicator Pro plugin. Becuase Duplicator free version is showing host build interrupt errors.
This requires detailed testing. We will get back to you as soon as possible. Please wait.
Hi,
Any update?
My method for importing entries is valid according to wpforms.
Here is their reply:
Hello Hasan,
Thank you for contacting us!
Currently, we do not have a feature to import entries to a form or site. I do agree it would be super helpful, though. I will add your feature request to our list of requests for that feature.
As a workaround, you can try importing the entries directly into the database. Before you attempt this, I would recommend creating a site backup just in case anything goes in the wrong direction.
We have an article with details about our database structure here: hidden link.
Basically, we store all form data in two tables within the native WordPress database (shown in this screenshot: hidden link). The field values for entries are stored in the entries table and are encoded in a single JSON object for better storage.
If you open your wp_wpforms_entries table through phpMyAdmin, you’ll be able to see what I’m describing (here’s an example screenshot: hidden link). Through phpMyAdmin, you can also check out how other data is structured in our two tables.
One of the possible workarounds is that you can import entries using MySQL/phpMyAdmin. There are 3 entry database tables:
_wpforms_entries
_wpforms_entry_fields
_wpforms_entry_meta
The only issue is that the data that is contained inside has a lot of relationships based on the field and form IDs. When you import a form, the form ID is likely to change so it’s important to make sure that the form ID matches the ID from where it came. Similarly, the field IDs on the form will also need to match so that everything lines up correctly.
As long as the form IDs do match, it should be possible to import the tables into the database without any issues but I have not actually tested this and it is only an educated guess. Just remind to create a full backup of your site including the Database at first if you proceed with the workaround.
Here is a short video recording as a demonstration on how to find these in your database: hidden link
I apologize that we can't provide what you're looking for right now, but I appreciate the suggestion and any other details you may be able to provide! It's always helpful to get insights from our users.
Could you please let me know if you have any other questions?
We are still working on this issue. But not able to replicate the issue exactly in our local copies. So a couple of requests.
1) It seems the user's locale settings are being determined by the email address, pfx[dot]kazem[at]gmail[dot]com, based on the logic in:
\WPML\Forms\Hooks\WpForms\Notifications::getLanguageForEmail
(found in wp-content/plugins/wpml-wpforms/classes/Hooks/WpForms/Notifications.php).
Therefore can you please test it with another email address that is not known to the system?
2) If the issue exists with another email address, can you please check if the bug is reproducible in our Sandbox site (a fresh installation). It is a simple replica of your site with only must required plugins.
Please click this URL to access the sandbox site backend - hidden link
Reproducing the bug in a fresh installation will help us a lot speedup the debugging. Thank you for your kind understanding and cooperation.
Thank you for the updates. We have configured WPForms Pro on the sandbox site now. Please check you can reproduce the issue or not.
Also, please try the following workaround and make sure the bug exists or not.
It seems the user's locale settings are being determined by the email address, pfx[dot]kazem[at]gmail[dot]com, based on the logic in:
\WPML\Forms\Hooks\WpForms\Notifications::getLanguageForEmail
(found in wp-content/plugins/wpml-wpforms/classes/Hooks/WpForms/Notifications.php).
Therefore can you please test it with another email address that is not known to the system?
--
Thanks!
Bigul
The topic ‘[Closed] WPForms notification is translated to Arabic, but customer gets English version’ is closed to new replies.
