How to include HTML entities in CSV file for upload

This thread is resolved. Here is a description of the problem and solution.

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 3 years, 8 months ago. 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)

Tagged: Import and export

This topic contains 4 replies, has 2 voices.

Last updated by davidm-13 3 years, 8 months ago.

Assisted by: Jamal.

Author

Posts

February 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

February 12, 2021 at 4:48 pm #1944035

Jamal

Supporter

Languages: English (English ) French (Français )

Timezone: Africa/Casablanca (GMT+01:00)

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? hidden link
Please share a minimal CSV file to demonstrate this issue using Google Drive, Dropbox, or Pastebin.

February 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

February 12, 2021 at 5:21 pm #1944075

Jamal

Supporter

Languages: English (English ) French (Français )

Timezone: Africa/Casablanca (GMT+01:00)

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

February 12, 2021 at 5:53 pm #1944121

davidm-13

My issue is resolved now. Thank you!

This ticket is now closed. If you're a Toolset client and need related help, please open a new support ticket.