I have an excel sheet that has links in some of the cells. When I import it, however, the links are gone. There's too much info to do it all manually so I'm wondering if there is a way to import the sheet so that the links get copied over.
When you are making wpdatatables from existing data source for proper rendering of URL link column you have to provide proper format in file for wpdatatables which is:
I don't know what that means. The link in my excel sheet does have the proper link "http" and yes it need to be linked text. But when I upload it, it's just text. If I switch the entire column to URL it makes everything a URL and I don't want that. It also just creates random URLs that don't link to anything.
I also am not able to edit them individually by row, which wouldn't be helpful anyway because I don't have the time to go through and add links to hundreds of rows.
I'm wondering if there is a way to upload my excel file so that linked text in my excel file will be added to my WordPress site as linked text.
You have to insert URL links like I explain you in previous post. You can't use any formatting in excel file because wpdatatables grab only data from file. (if you use Excel function or format for links in wpdatatable will be inserted only that text without link.)
To understand on what you mean please check file in attachment how you need to insert links in Excel file.
I see what you mean now, sorry. Unfortunately, however, I still can't get it to work. Here's a link to the page. I tried to make my own and it didn't work so I copy and pasted your exact example and this is what I get...
Yes and now please change option Column type to URL link on DATA tab in column settings for that column "Player" and you will see proper link with text(I mean for that first cell where you have proper format(Google) not for others)
That works great but is there a way to change just cells with links or does the whole column have to be links. As you can see when I updated it, it works great in 1 cell but now I have several hundred that are all just broken links.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
You can edit every cell one by one with standard edit modal in wpdatatables or you can use bulk multiply rows edit with Excel like editor or change it manually in Excel file that you use for this table.
I have an excel sheet that has links in some of the cells. When I import it, however, the links are gone. There's too much info to do it all manually so I'm wondering if there is a way to import the sheet so that the links get copied over.
Thanks
Hi Ryan,
Thank you for your purchase.
When you are making wpdatatables from existing data source for proper rendering of URL link column you have to provide proper format in file for wpdatatables which is:
http://www.google.com or https://www.google.com
or if you need text instead of link you can use:
http://www.google.com || Google or https://www.google.com || Google
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
I don't know what that means. The link in my excel sheet does have the proper link "http" and yes it need to be linked text. But when I upload it, it's just text. If I switch the entire column to URL it makes everything a URL and I don't want that. It also just creates random URLs that don't link to anything.
I also am not able to edit them individually by row, which wouldn't be helpful anyway because I don't have the time to go through and add links to hundreds of rows.
I'm wondering if there is a way to upload my excel file so that linked text in my excel file will be added to my WordPress site as linked text.
Thanks,
Ryan
Hi Ryan,
You have to insert URL links like I explain you in previous post. You can't use any formatting in excel file because wpdatatables grab only data from file. (if you use Excel function or format for links in wpdatatable will be inserted only that text without link.)
To understand on what you mean please check file in attachment how you need to insert links in Excel file.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
I see what you mean now, sorry. Unfortunately, however, I still can't get it to work. Here's a link to the page. I tried to make my own and it didn't work so I copy and pasted your exact example and this is what I get...
http://www.nflbigboard.com/archives/2581
Hi Ryan,
Yes and now please change option Column type to URL link on DATA tab in column settings for that column "Player" and you will see proper link with text(I mean for that first cell where you have proper format(Google) not for others)
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
That works great but is there a way to change just cells with links or does the whole column have to be links. As you can see when I updated it, it works great in 1 cell but now I have several hundred that are all just broken links.
http://www.nflbigboard.com/archives/2581
Hi Ryan,
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
You can edit every cell one by one with standard edit modal in wpdatatables or you can use bulk multiply rows edit with Excel like editor or change it manually in Excel file that you use for this table.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables