The Omni Group
These forums are now read-only. Please visit our new forums to participate in discussion. A new account will be required to post in the new forums. For more info on the switch, see this post. Thank you!

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

 
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
 
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..
 
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
 
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)
 
 


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
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 08:11 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.