Ok, we can make last try with the below, please kindly check,
1. Save the CSV File Correctly
1.1 Use UTF-8 Encoding
– Avoid Excel: Excel often mishandles UTF-8 encoding. Use Notepad++, Sublime Text, or LibreOffice Calc instead.
– For Notepad++:
1. Open the CSV file.
2. Go to Encoding > Encode in UTF-8-BOM.
3. Save the file.
– For LibreOffice Calc:
1. Open the CSV file.
2. Go to File > Save As.
3. Choose CSV (Text) and check ☑ Edit filter settings.
4. Set Character set to Unicode (UTF-8) and ☑ Add BOM character.
# 2. Configure WordPress for UTF-8
2.1 Update wp-config.php
Add these lines to your WordPress root’s wp-config.php :
define('DB_CHARSET', 'utf8mb4');
define('DB_COLLATE', 'utf8mb4_unicode_ci');
2.2 Check Database Collation
1. Open phpMyAdmin (via your hosting panel).
2. Select your WordPress database.
3. For all tables, change collation to utf8mb4_unicode_ci (use Operations > Collation).
–
# 3. Server-Side Fixes
3.1 PHP Configuration
Add these lines to your server’s php.ini or .user.ini
default_charset = "UTF-8"
mbstring.internal_encoding = UTF-8
mbstring.http_output = UTF-8
– If you don’t have access to php.ini, contact your hosting provider to apply these settings.
3.2 Web Server Headers
– For Apache (add to .htaccess in WordPress root):
`AddDefaultCharset UTF-8
<IfModule mod_headers.c>
Header set Content-Type “text/html; charset=UTF-8”
</IfModule>`
`
– For Nginx (add to nginx.conf):
`charset utf-8;
charset_types text/html text/plain text/css application/json application/javascript text/xml application/xml;
`
3.3 MySQL Connection Collation
Add this to wp-config.php to force UTF-8 for database connections:
php
// Force UTF-8 connection
$mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$mysqli->set_charset('utf8mb4');
# 5. Import CSV into WPDM
1. Go to WPDM > Import/Export.
2. Upload your CSV file (ensure it’s saved as UTF-8 with BOM).
3. Map the CSV columns to WPDM fields.
4. Ensure Character Encoding is set to UTF-8 in the import settings.
# 6. Last Resorts
6.1 Manual Import via phpMyAdmin
1. Export your CSV as UTF-8.
2. In phpMyAdmin:
– Select your WordPress database.
– Go to Import > Choose File (select CSV).
– Set Format to CSV and Character set to utf8.
6.2 Contact Hosting Support
If you’re on shared hosting and lack server access, ask them to:
– Confirm PHP/MySQL uses UTF-8.
– Update php.ini and MySQL collation to utf8mb4.
Please kindly check and let me know.
Thank you and kind regards
