I have a problem with importing data from CSV files. I want to import some tables that have multiple data within one cell, for example the format is like this
Feature1 Feature 2 Feature 3
When I import the CSV I select the column als "Multi line edit" but the format is not correct, only when I edit the data and press save again, the data shows correctly.
Is there any way to avoid this step shown in the video? Because we want to import a lot of these tables and it will be additional work for our content team.
The example CSV is attached here, too.
What do you suggest? Maybe there's another way to work with such a CSV?
Yes, this is the current default behaviour for a use-case like that,
when we import data from CSV or Excel files or Spreadsheets,
as far as i know, the only workaround you can do is to format the source data from the cells of the CSV to have HTML <br> tags in places where you need new lines, because our string columns render HTML,
so that can make the source output with the new lines automatically,
without the need to go in each cell and align them in a multi-line editor, as shown on your video.
Hello!
I have a problem with importing data from CSV files. I want to import some tables that have multiple data within one cell, for example the format is like this
Feature1
Feature 2
Feature 3
When I import the CSV I select the column als "Multi line edit" but the format is not correct, only when I edit the data and press save again, the data shows correctly.
I have recorded a video for you
Is there any way to avoid this step shown in the video? Because we want to import a lot of these tables and it will be additional work for our content team.
The example CSV is attached here, too.
What do you suggest? Maybe there's another way to work with such a CSV?
Thanks in advance!
Best regards
Jannik Lindner
Hi, Jannik
Thanks for reaching out to us
- I see what you mean.
Yes, this is the current default behaviour for a use-case like that,
when we import data from CSV or Excel files or Spreadsheets,
as far as i know, the only workaround you can do is to format the source data from the cells of the CSV to have HTML <br> tags in places where you need new lines, because our string columns render HTML,
so that can make the source output with the new lines automatically,
without the need to go in each cell and align them in a multi-line editor, as shown on your video.
Here is my Video where i demonstrate one cell with adding the HTML <br> tags, and how it renders during the import https://watch.screencastify.com/v/MA7jaIBcIkBMuC6O99Nm
Let me know if that helps, and in the meantime, i will also check with our 2nd level Team if we have any better workarounds.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables