Forums - View Thread - Exporting CSV with a URL

Welcome Guest | Login

Index | Recent Threads | Register |

Forums » List all forums » Forum: Discussion Forums » Thread: Exporting CSV with a URL

Quick Go »

Thread Status: Normal
Total posts in this thread: 4

[Change thread status] [Delete this Thread] [Move this Thread]
[Add To My Favorites] [Watch this Thread] [Post new Thread]

Author

This topic has been viewed 533 times and has 3 replies

calliduscloudnexus
Newbie

Joined: Dec 20, 2016
Posts: 35
Status: Offline

Exporting CSV with a URL	Reply to this Post Reply with Quote
	[Delete this Thread]

I exported my Releases calendar, which contains events with URLs in the body. When I look at the CSV export, the URLs are not there. Is that supposed to happen?

[Sep 20, 2017, 10:09:19 PM] [97.65.120.2]

[Link]

support
localendar Expert

Joined: Aug 9, 2022
Posts: 6395
Status: Offline

Re: Exporting CSV with a URL	Reply to this Post Reply with Quote
	[Delete this Post]

I think you mean to say your events contain embedded HTML (some of which is used for links)

The commission is intentional. CSV files use quotes as delimiters, and although there is a documented standard for embedding quotes (which are used in HTML markup) in CSV files (see https://tools.ietf.org/html/rfc4180) we have found that many tools that read CSV files do not interpret this standard correctly.

Can I ask what program you are using to read the exported CSV?
----------------------------------------
Marc Higgins
Support Associate, localendar.com
Follow us on Twitter! http://www.twitter.com/localendar_news

[Sep 20, 2017, 10:52:09 PM] [69.126.188.75]

[Link]

calliduscloudnexus
Newbie

Joined: Dec 20, 2016
Posts: 35
Status: Offline

Re: Exporting CSV with a URL	Reply to this Post Reply with Quote
	[Delete this Post]

The information is translated into an HTML page posted in a Lithium Community (https://community.lithium.com/t5/Lithium-Community/ct-p/External). Our thought was to take the output from our Localendar (title, dates, and (if present) URLs) and use that to create the HTML page for the Community. We are trying to automate as much as we can to avoid manual input errors. I don't see another export possibility in Localendar to get that information other than CSV.

[Sep 25, 2017, 10:01:05 PM] [97.65.120.2]

[Link]

support
localendar Expert

Joined: Aug 9, 2022
Posts: 6395
Status: Offline

Re: Exporting CSV with a URL	Reply to this Post Reply with Quote
	[Delete this Post]

I tried the link you provided but got a "node was not found" error.; I was hoping to see where you were importing the events to see if that might be a possible solution.

The iCal export will contain html links:
https://localendar.com/public/calliduscloudnexus.ics

The RSS export will also contain html links:
https://localendar.com/public/calliduscloudnexus?style=M3

Both iCal and RSS have better-adhered-to standards for embedded HTML, which as I mentioned is part of the trouble we have run into with the CSV "standard"
----------------------------------------
Marc Higgins
Support Associate, localendar.com
Follow us on Twitter! http://www.twitter.com/localendar_news

[Sep 26, 2017, 10:01:19 PM] [69.126.188.75]

[Link]

[Show Thread Printable Version] [Post new Thread]