Skip Navigation

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

No supporters are available to work today on this forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

Sun Mon Tue Wed Thu Fri Sat
- 12:00 – 14:00 12:00 – 14:00 12:00 – 14:00 12:00 – 14:00 12:00 – 14:00 -
- 17:00 – 21:00 17:00 – 21:00 17:00 – 21:00 17:00 – 21:00 17:00 – 21:00 -

Supporter timezone: Europe/Vienna (GMT+01:00)

Tagged: 

This topic contains 8 replies, has 0 voices.

Last updated by Bigul 1 day, 2 hours ago.

Assisted by: Bigul.

Author Posts
October 31, 2024 at 2:49 pm

hasanK-7

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?

October 31, 2024 at 5:08 pm
November 1, 2024 at 2:53 pm #16355300

hasanK-7

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

November 1, 2024 at 2:59 pm #16355318

hasanK-7

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

November 1, 2024 at 3:28 pm #16355360

hasanK-7

Hi dear WPML Team,

I hope this message finds you well.

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 your attention to this matter.

Warm regards,

wpforms.PNG
November 1, 2024 at 5:27 pm #16355737

Bigul
Supporter

Languages: English (English )

Timezone: Europe/Vienna (GMT+01:00)

Hello,

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.

--
Thanks!

Bigul

November 3, 2024 at 3:17 pm #16358134

hasanK-7

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?

Thanks!

November 5, 2024 at 5:19 pm #16368519

Bigul
Supporter

Languages: English (English )

Timezone: Europe/Vienna (GMT+01:00)

Hello,

Thank you for the feedback. I have shared it with our team. We will get back to you as early as possible. Please wait.

--
Thanks!

Bigul

November 10, 2024 at 2:42 pm #16385793

hasanK-7

Any update?
Its been a week and I didn't hear from you!!!!!!!!!!!

November 11, 2024 at 5:21 am #16386569

Bigul
Supporter

Languages: English (English )

Timezone: Europe/Vienna (GMT+01:00)

Hello,

Sorry for the delay. We are still working on this issue and get back to you as soon as possible. Please wait.

--
Thanks!

Bigul

November 15, 2024 at 1:54 pm #16408685

Bigul
Supporter

Languages: English (English )

Timezone: Europe/Vienna (GMT+01:00)

Hello,

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.

--
Thanks!

Bigul