How to include HTML entities in CSV file for upload

Ce fil est résolu. Voici une description du problème et la solution proposée.

Problem:
The user would like to include HTML entities such as ampersand (&), quotes ("), an apostrophe (') in a CSV file when importing custom posts using the CSV Importer plugin.

Solution:
According to the plugin's page, you need to change the character with its HTML entity. Check the entities here https://www.w3schools.com/html/html_entities.asp

& : &
" : "
' : '

https://wordpress.org/plugins/csv-importer/

This support ticket is created Il y a 3 années et 11 mois. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-	-	9:00 – 13:00
14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-	-	14:00 – 18:00

Supporter timezone: Africa/Casablanca (GMT+01:00)

Marqué : Import and export

Ce sujet contient 4 réponses, a 2 voix.

Dernière mise à jour par davidm-13 Il y a 3 années et 11 mois.

Assisté par: Jamal.

Auteur

Publications

février 11, 2021 at 10:56 pm #1943003

davidm-13

Hi,
Please can you tell me how to include HTML entities such as ampersand (&), quotes (") and apostrophe (') in a CSV file when uploading custom posts.?
Thanks

février 12, 2021 at 4:48 pm #1944035

Jamal

Hello and thank you for contacting the Toolset support.

Could you please elaborate a little more on your question so I can better understand it? What do you mean by uploading custom posts? Are you referring to an import plugin? What plugin?

Would you like to reproduce this issue on the following test site? lien caché
Please share a minimal CSV file to demonstrate this issue using Google Drive, Dropbox, or Pastebin.

février 12, 2021 at 5:03 pm #1944043

davidm-13

Hi Jamal,
I'm loading custom posts from a csv file using CSV Importer - https://wordpress.org/plugins/csv-importer/.
These posts contain ampersands, quotes and apostrophes (in both title and content). These are special characters in HTML so I want to know if I need to do find/replace for them in the csv file and if so what are the replace characters?
Thanks

février 12, 2021 at 5:21 pm #1944075

Jamal

According to the plugin's page, you need to change the character with its HTML entity. Check the entities here lien caché
- & : &
- " : "
- ' : '

février 12, 2021 at 5:53 pm #1944121

davidm-13

My issue is resolved now. Thank you!