Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

How to insert HYPERLINK in csv-file
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: How to insert HYPERLINK in csv-file
#60224
How to insert HYPERLINK in csv-file 7 Years, 7 Months ago Karma: 0
Hello, I want to insert hyperlinks in one of columns,external hyperlink.
Is it possible to insert hyperlinks in csv format file? I tried to put command =HYPERLINK("somelink";"linkdisplay") in csv file, but noting changes, it's not working.
What is the solvation, probably I have syntax errors in command line for links, but it is important for my site.
Here is my site: agup.varna.bg/index.php/registers/2013-04-23-07-00-18/razresheniya-za-stroezh-2017-g
I want to put link in the latest column.
Please, answer as soon as possible.
Best Regards,
S.Nikolova
The administrator has disabled public write access.
 
#60225
Re:How to insert HYPERLINK in csv-file 7 Years, 7 Months ago Karma: 760
Hello,

CSV is a simple format and it doesn't support any formatting command, but "ARI Data Tables" can format retrieved data (from database or CSV files). For this use "Columns settings -> Format" parameter. For example if "Link" column contains links, set "Columns settings -> ID" parameter to Link value and populate "Columns settings -> Format" parameter with the following value:

Code:


<a href="{$value}">Link</a>



Regards,
ARI Soft
The administrator has disabled public write access.
 
#60226
Re:How to insert HYPERLINK in csv-file 7 Years, 7 Months ago Karma: 0
It works! Thank you very much!
The administrator has disabled public write access.
 
#60645
Re:How to insert HYPERLINK in csv-file 7 Years, 4 Months ago Karma: 0
admin wrote:
Hello,

CSV is a simple format and it doesn't support any formatting command, but "ARI Data Tables" can format retrieved data (from database or CSV files). For this use "Columns settings -> Format" parameter. For example if "Link" column contains links, set "Columns settings -> ID" parameter to Link value and populate "Columns settings -> Format" parameter with the following value:

Code:


<a href="{$value}">Link</a>



ARI Soft


I made this. but now I'm trying to make new file with some text and link as: =HYPERLINK("www.google.bg";"google"),in Columns settings I set Id= Link, and value ><a href="{$value}">Link</a>, but it's now not working. What was wrong?
The administrator has disabled public write access.
 
#60649
Re:How to insert HYPERLINK in csv-file 7 Years, 4 Months ago Karma: 760
Hello,

Could you send your CSV file and screenshot(s) of module settings page by email?

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1