Importing table as CSV with hyperlinks

  • Resolved mmeans

    (@mmeans)


    8 years, 3 months ago

    I am attempting to import a fairly large spreadsheet into a table. Importing it as CSV has worked fairly well without issue, but one of the fields is supposed to be a clickable hyperlink. I see there is a URL converting extension available for tablepress, but does this converter just spit out the hyperlink, or can I create a shorter line of text (a “click here!” sort of thing)?

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 3 months ago

    Hi,

    thanks for your question, and sorry for the trouble.

    That specific Extension can only convert the link so that the URL is used as the link text. For shorter texts (like “Click here!”) you would have to manually adjust the HTML code, or maybe construct the HTML externally, e.g. using Excel functions and macros.

    Regards,
    Tobias

    Thread Starter mmeans

    (@mmeans)

    8 years, 3 months ago

    my first attempt, I’d actually typed the HTML into the field, and hoped that it would import. the results with that were 1) the appearance of a link was imported, 2) link wasnt actually clickable, and 3) it just showed the link and the “click here!” was not displayed

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 3 months ago

    Hi,

    to investigate that, I’d need to see the resulting HTML code. Can you please post a link to the page with the table where this problem happens, so that I can take a direct look? Thanks!

    Regards,
    Tobias

    Thread Starter mmeans

    (@mmeans)

    8 years, 3 months ago

    I’m sure I’m doing something wrong thats an obvious rookie mistake
    https://thesupplementshopper.com/cheapest-proteins/

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 3 months ago

    Hi,

    thanks for the link!
    Indeed, the HTML structure for the links is a bit off.
    Instead of

    <a href "Get This Deal Now!">www.mysupplementstore.com</a>

    you would need to write

    <a href="http://www.mysupplementstore.com/">Get This Deal Now!</a>

    Note how the target URL has to go inside the href parameter (including the http:// or https:// prefix!) and how the link text goes between the > and </a>.

    Regards,
    Tobias

    Thread Starter mmeans

    (@mmeans)

    8 years, 3 months ago

    Thanks!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 3 months ago

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

    Thread Starter mmeans

    (@mmeans)

    8 years, 3 months ago

    Thanks again for the response, and now my follow-on n00b errors…… I got around to editing the spreadsheet, html now halfway proper in that it displays the “get this deal now!” text, but the actual link within the html isnt functioning. It just loops back to the main list page, it doesnt link outside of the website to the desired destination.

    Is there something else that needs to be typed into a cell, for it to import via CSV as an actual link?

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 3 months ago

    Hi,

    your link HTML code is still not correct. Please change

    <a href "www.a1supplements.com">Get This Deal Now!</a>

    to

    <a href="http://www.a1supplements.com">Get This Deal Now!</a>

    The URL needs to be assigned to the href parameter, and you need to add the http://.

    Regards,
    Tobias

    Thread Starter mmeans

    (@mmeans)

    8 years, 3 months ago

    thanks for the patience of dealing with a sloppy noob. got it all figured out

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 3 months ago

    Hi,

    great! Good to hear that it’s working now 🙂

    Best wishes,
    Tobias

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘Importing table as CSV with hyperlinks’ is closed to new replies.