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?

Save hyperlinks in CSV file
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Save hyperlinks in CSV file
#11228
Save hyperlinks in CSV file 13 Years, 4 Months ago Karma: 0
Hello Everyone

My goal is to have in the first column all entries as hyperlinks .
The problem is I can't save the CSV file that will keep the links.
Do I need something different than Microsoft Excel ? Or I have to put the text with the code like this
<a href="My Text">www.mylink.com</a>

Cheers
Last Edit: 2011/02/20 02:06 By Sergo.
The administrator has disabled public write access.
 
#11243
Re:Save hyperlinks in CSV file 13 Years, 4 Months ago Karma: 748
Hello,

Read this post please. Could you specify do you need it for "ARI Data Tables" or "ARI Smart Content" extension or for both of them?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#11371
Re: Save hyperlinks in CSV file 13 Years, 4 Months ago Karma: 0
Hi! I had the same problem saving links from Excel to .csv file. The only solution I found out was to write the HTML code in Excel cells or directly in the .csv file e.g
Code:

<a href="http://www.website.com">Description</a>
Last Edit: 2011/02/23 08:59 By babben.
The administrator has disabled public write access.
 
#11373
Re: Save hyperlinks in CSV file 13 Years, 4 Months ago Karma: 748
Hello,

CSV format supports only plain text, it doesn't support hyperlinks. There are two possible ways to resolve this problem:

1. Save HTML code. Like in babben's post.

2. Create two column in CSV file, one column will contain link, second column will contain link title and use "Column settings -> Format" option that combine two columns in one column and create hyperlink.

Regards,
ARI Soft
Last Edit: 2011/02/23 09:02 By admin.
The administrator has disabled public write access.
 
#11418
Re:Save hyperlinks in CSV file 13 Years, 4 Months ago Karma: 0
This is how I achieve that , thanks to ARI Soft team

Set the following columns settings:

_________________________________________________________________________

ID | Hidden | Format

Brand and Product | No | <a href="{$columns:Link}">{$value}</a>

Link | Yes |
_________________________________________________________________________
The administrator has disabled public write access.
 
Go to topPage: 1