Welcome Guest   | Login   
  Search  
  Index |  Recent Threads |  Register | 


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
Previous Thread This topic has been viewed 17 times and has 3 replies Next Thread
calliduscloudnexus
Newbie



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

Edit this Post   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] Show Post Printable Version [Link] Report threatening post: please login first  Go to top 
support
localendar Expert
Member's Avatar


Joined: Sep 15, 2004
Posts: 5962
Status: Offline
Edit this Post   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] Show Post Printable Version [Link] Report threatening post: please login first  Go to top 
calliduscloudnexus
Newbie



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

Edit this Post   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] Show Post Printable Version [Link] Report threatening post: please login first  Go to top 
support
localendar Expert
Member's Avatar


Joined: Sep 15, 2004
Posts: 5962
Status: Offline
Edit this Post   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] Show Post Printable Version [Link] Report threatening post: please login first  Go to top 
[Show Thread Printable Version] [Post new Thread]

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