The Omni Group

Go Back   The Omni Group Forums > OmniOutliner > OmniOutliner 3 for Mac
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
Exporting URLs to spreadsheet Thread Tools Search this Thread Display Modes
Hi. I am trying to import an OmniOutlinerPro document into two spreadsheets (both Numbers and Google docs). The first column contains URLs. I saved the document as a text file, then opened it in both Numbers and Google docs. In both of them, they displayed the data in the first column as:

www.amitymama.com <http://www.amitymama.com/>

Neither Numbers or Google docs recognize either part of that data as an active URL. I'm wondering if there is another way to allow the spreadsheet programs to parse the data differently so the first column is a clickable URL.

If not, then I'd love to see a future feature of OmniOutliner in which it can export to xml format.

Thanks,

Sky
  Reply With Quote
Quote:
Originally Posted by Skylamar View Post
I'd love to see a future feature of OmniOutliner in which it can export to xml format.
Have you tried exporting to OPML ?
(an XML format)

003 files are also XML files.

(If the Document > Advanced inspector has "Compress on Disk" they will be zipped XML)

003 "files" are, by default, package folders, so to see the XML you will need to Ctrl-click them, and choose "show package contents"

The DTD is at http://www.omnigroup.com/namespace/O...outline-v3.dtd

--

Last edited by RobTrew; 2010-08-21 at 03:12 AM..
  Reply With Quote
Hi again. I guess don't know much about xml. I wasn't able to open the contents.xml file in Numbers or Google docs. Google says it can open xls files.

Anyway, if there's anything else I can do to get it to work, please let me know.

Thanks,

Sky
  Reply With Quote
URLs in OO3 are easier to manage and export if you un-check the box under Preferences > General Preferences > Attachments so that URLs are left as text when they are entered.

If your URLs are in text format, you can export the file as CSV, which Numbers should be able to import.

(Haven't tested it - I am using Excel)
  Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Numbers spreadsheet zdlo OmniOutliner 3 for Mac 0 2012-05-30 12:49 PM
Exporting Text and URLs Together? willard202 OmniFocus 1 for Mac 2 2010-08-27 08:50 AM
next version - copy/paste from spreadsheet? PLEASE! [Feature added in 1.1] kasmicb OmniGraphSketcher for iPad 8 2010-04-16 10:02 AM
Adapted script to copy a spreadsheet into OmniOutliner scooby OmniOutliner 3 for Mac 0 2009-07-12 10:07 AM
Google Spreadsheet m0sca OmniWeb General 3 2006-09-09 12:32 PM


All times are GMT -8. The time now is 06:24 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.