localendar Forums Homepage

Print at Apr 19, 2024, 8:32:41 AM View all posts in this thread on one page
Posted by calliduscloudnexus at Sep 20, 2017, 10:09:19 PM
Exporting CSV with a URL
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?

Posted by support at Sep 20, 2017, 10:52:09 PM
Re: Exporting CSV with a URL
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

Posted by calliduscloudnexus at Sep 25, 2017, 10:01:05 PM
Re: Exporting CSV with a URL
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.

Posted by support at Sep 26, 2017, 10:01:19 PM
Re: Exporting CSV with a URL
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


Help! | Cobranding | Legal | Privacy Policy | About localendar.com | Contact Us