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


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 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.


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, 8 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, 8 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, 8 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, 6 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, 6 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