Links not Importing from CSV File
-
Hi, I am having an issue working with CSV files exported from Ninja Tables that contain HTML Links.
As a quick test, I made a simple table with an HTML field for hyperlinks. When I export the table as a csv, I get this result:Name,Link
"Link 1","<a href=""https://www.google.com/"">Google</a>"
"Link 2","<a href=""https://www.bing.com/"">Bing</a>"If I import that same .csv file with Ninja Tables, the table only has an empty anchor tag for the cell contents. For example: <a>Google</a>
For the new table, I set the Link Column to be an HTML field, then tried reimporting the .csv file and it has the same result.
If I manually change the .csv file to the following the links are imported properly:Name,Link
"Link 1",<a >Google</a>
"Link 2",<a >Bing</a>So obviously this is a problem with CSV files containing quotation marks for strings, but it seems like Ninja Tables should be able to parse HTML tags properly, especially when the file is exported from Ninja Tables?
I have to modify file paths for a table with 6000 entries, so I need to use excel to alter the exported csv file, and then reimport the edited csv as a new table. Let me know if there is some other way to import csv files , or if there is a secret setting that allows ninja tables to properly parse HTML tags from a csv.
Thanks!
- You must be logged in to reply to this topic.