As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
trying to import Excel spreadsheet but column contains text and hyperlinks - hyperlinks are lost when I import the data
Hello bsowebteam.
Thank you for your purchase.
Can you please send us that Excel file, so that we can try re-creating it locally?
Also, you said you tried importing the file - that means you used the third option when creating the table (Create a table by importing data from data source), correct?
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Hi Aleksandar
I used the First Option - Create a table linked to an existing data source.
in one of the columns there are hyperlinks behind the text, along with other text
eg "This cell contains a link to Amazon" (with the word Amazon being a hyperlink to http://www.amazon.com)
when I import the data I get "This cell contains a link to Amazon" and the word Amazon has no hyperlink
if I create a spreadsheet with a Links column - links only import if they are explicitly in the format http://linkname.com, not if they are a text label with a hyperlink behind it
Ian
Hello Ian.
Yeah, I see; the issue here is that this column is being recognized as a "String", which it should be, given that it contains text and only one word contains the hyperlink.
So, in order to use that link in wpDataTables, you need to create the table using the third option (Create a table by importing data from data source), and then edit the entries, but in this manner:
It's not possible to keep the hyperlink other than what you already mentioned:
if I create a spreadsheet with a Links column - links only import if they are explicitly in the format http://linkname.com, not if they are a text label with a hyperlink behind it
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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