• Resolved juliagr

    (@juliagr)


    Hi,

    You were so helpful with my last request that I thought I’d write again!

    One of the columns is websites and I want them to automatically register as such when I import the table. Whether I import as csv or xlsx it does not automatically register that the text is a link. I do not want to have to go through each individual box and insert the link tags — especially if the display text is simpler than the destination link. What a pain — I have 200 entries!

    Table site: https://site.claimscon.org/table-2/

    You’ll see some links are live because I entered them manually. But it’s too slow (the Edit Table page is actually very slow).

    Thank you!
    best
    julia

    https://www.ads-software.com/plugins/tablepress/

Viewing 15 replies - 1 through 15 (of 18 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi Julia,

    thanks for your question!

    Good news: The “Automatic URL conversion” Extension for TablePress from https://tablepress.org/extensions/automatic-url-conversion/ is what you are looking for ??

    Regards,
    Tobias

    Thread Starter juliagr

    (@juliagr)

    Wow, thank you. Thank you so much!

    I already rated you five stars — would do it again if I could.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! Good to hear that this helped!
    And also thanks for that rating, I really appreciate it!

    Best wishes,
    Tobias

    Hi Tobias, I would like to convert email addresses. Please tell me the shortcode should I enter? I tried to do this [table id = 123 automatic_url_conversion = true /] but does not work. Another thing: How do I remove blank lines on the right side of the table? I would like to show only the fields with content. Thank you very much

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your question and sorry for the trouble!

    If you follow the exact instructions from https://tablepress.org/extensions/automatic-url-conversion/ , it will also work for email addresses and make those clickable.
    One thing that could be wrong in your Shortcodes are the spaces. Please try again with the exact Shortcode

    [table id=123 automatic_url_conversion=true /]

    (You must have the Extension installed and activated, of course!)

    To remove the blank lines on the right: Just delete the empty columns on the “Edit” screen of your table. First check the checkboxes below them and then click “Selected columns: Delete”.

    Regards,
    Tobias

    I’m sorry, Tobias, but I had not activated the plugin. Now it works fine. I removed the empty columns as you have shown me.

    Just one question: I can’t import the files (pdf, doc, etc..) that I attached to the original CSV file. For example, in text “download” the link to the document is on the server (e.s. https://www.mydomain.com/document.pdf). Please could you tell me how to do.

    You are very kind. Congratulations for the plugin

    Best regards
    Eddy

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi Eddy,

    good to hear that both the links and the removing of the columns worked! ??

    Now, I’m not really sure what you mean with importing those other files. Are you expecting that this are imported to your server? Because that will not happen. TablePress can only import the table itself.

    Regards,
    Tobias

    Thanks Tobias,
    For each entry of the tables I would like to enter more than e-mail files to download. In the CSV file I select attach files and insert Url of the remote server where file is located. The PDF (or Doc) is not included in the CSV file, but the link is the same that a website. The difference is between “www.mydomain.com” and “www.mydomain.com/document.pdf”. On the first link can see the website, the second (what I would do) can download the document

    Thanks again!
    Eddy

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi Eddy,

    I still don’t really understand ??
    From your description, it sounds as if certain URLs (those to PDF files) are not linkified/made clickable automatically?
    Can you maybe post a link to the page with the table, so that I can see what’s going on?

    Regards,
    Tobias

    Hi Tobias,

    As you can see on https://www.lavori.calabriaregolare.it/example/ only the email is clickable. The three columns “Download” no(although it has been linked)
    I used this shortcode: [table id=8 automatic_url_conversion=true automatic_url_conversion_new_window=true /]
    Email is ok.
    In the “Download” (example the same all rows) hyperlink is https://www.lavori.calabriaregolare.it/documenti/Punti_di_forza_Progetto_Lavori_Regolari.pdf, but I don’t know why it does’t work.
    I’m sure I do something wrong.
    Thanks so much!

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    ah, now I understand ?? Thanks for the link and for the explanation!

    The problem here is that your CSV file does not contain the links, but only the text “Download”. If you open the CSV file in a text editor (like Notepad), you will see what I mean. It does not contain the URLs to the PDF files. And due to that, there’s nothing that can be made clickable automatically by the Extension (regardless, the Extension would not be able to make this clickable with a “Download” link text).
    So, you will now either have to re-add every link manually (via the “Insert Link” button below the table edit fields), or you’ll have to find a way that your CSV file (you might also want to try the HTML format) contains the full links as HTML code.

    Regards,
    Tobias

    Hi,

    I solved, thanks. In the CSV file I just put the string for each field: Download</ a>. Table show “Download” clickable, not hyperlink.

    Regards,
    Eddy

    I solved, thanks. In the CSV file I just put the string for each field: < a href = ” http : / / www . mydomain . com / document . pdf ” > Download < / a >. Table show “Download” clickable, not hyperlink.

    Regards,
    Eddy

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi Eddy,

    yes, that’s what I meant ?? Good to hear that this will work.

    Best wishes,
    Tobias

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

    Thread Starter juliagr

    (@juliagr)

    Tobias, is there a way to customize the link so that the target is different than what is written in the column? Eg: <a href="https://jewishfamilysvc.org/senior-services.php#holocaust">www.jewishfamilysvc.org</a>

    Thank you

Viewing 15 replies - 1 through 15 (of 18 total)
  • The topic ‘Automatically activate a link’ is closed to new replies.