What does my csv need to look like to successfully import link data into a list?
Reading a few posts, I've tried creating a spreadsheet with a single field and the |-| separator between the label and URL and it doesn't work with or without text quotes set.
Also, I'm unable to load the element manually by editing a row; I added "test" (without quotes) for the label and "http://forum.woodenboat.com/index.php" (again w/o quotes) and get the error:
"you have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE `boat_list_2` SET `Current_Name`='{\"label\":\"test\",\"link\":\"http:\\/\\/forum.woodenboat.com\\/index.php\"}' WHERE"
Thanks.
Bill
Reading a few posts, I've tried creating a spreadsheet with a single field and the |-| separator between the label and URL and it doesn't work with or without text quotes set.
Also, I'm unable to load the element manually by editing a row; I added "test" (without quotes) for the label and "http://forum.woodenboat.com/index.php" (again w/o quotes) and get the error:
"you have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE `boat_list_2` SET `Current_Name`='{\"label\":\"test\",\"link\":\"http:\\/\\/forum.woodenboat.com\\/index.php\"}' WHERE"
Thanks.
Bill