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

Copy column script Thread Tools Search this Thread Display Modes
I've been playing around with AppleScript and created this script that can copy a column to another OO document. I don't know if this would be of use to anyone as it has limits but here it is.

To use it, run it from the source document with a column highlighted. It will copy to the 2nd document you have open and you need to select a row in the destination document where you want to start the pasting. If a column with the same name as the one you've selected exists, it will paste into that one, otherwise a new one will be made.

The outline structure of the source data will be recreated if it doesn't exist in the destination. So you could actually copy a column to a blank document and make it the topic column.
Attached Files
File Type: zip Copy (16.3 KB, 615 views)
Thanks Derek, I find this script really useful: I put OO under some stress recently, creating gigantic OO files packed with dozens of columns (all of them indispensable!) only to find out too late that I also need to copy or export them singularly in order to share data with other applications. I wish this Copy Column function will be included in the next version of OO.
Hi Derek, I have just found your script to copy a column. But it does not work with my OO-documents. Can you help me to fix this problem? Please find enclosed a small test document. Such kind of columns I have to copy from one to an other OO-document.
Thank you for helping
Attached Files
File Type: zip Testdoc for (4.8 KB, 288 views)
It's failing due to the inherited styles you have applied to entries on those two columns. I'm not sure why off-hand but I didn't do anything to account for styles when I wrote the script so it's not too surprising. It's unlikely this is an easy fix so I'll have to get back to you later, sorry.

If you want to use the script now, you can either remove the styles from those entries, or remove the styles themselves then save and reopen the file.
Hello Derek, I have to wait still you have found a solution. Removing the styles is not possible because the styles itself are the informations. (We use the styles like a traffic light: red: work not yet started; green: work done and approved.) After using OO for more than one year as project overviews in our development department merging of documents is now a big issue.
Regards Johannes
So you need to actually merge files as in copying a column to another already existing file with data? If you just need to copy a non-topic column to the topic of a new file, it's possible to do that without a script by placing the column you want to copy to be the first one on the left in the document. I'll explain this better if this is a possible solution.
Sorry for taking so long to get back to you. The problem is due to named styles being applied directly to the text in those cells. OO's AppleScript isn't able to handle this when you're going between different files and I'm not sure why off-hand. I also haven't been able to find a way to make it work. If I find something I'll update the script but it's not looking likely.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a script to copy OF actions (and notes) to Journier? peterlemer OmniFocus Extras 1 2011-05-11 06:13 PM
Script to copy iCal todos into Omnifocus inbox? danielcompton OmniFocus Extras 7 2010-09-04 06:01 PM
Script to copy columns (and any selected rows) to new doc RobTrew OmniOutliner 3 for Mac 0 2010-06-07 02:47 AM
Adapted script to copy a spreadsheet into OmniOutliner scooby OmniOutliner 3 for Mac 0 2009-07-12 10:07 AM
copy down a column? rvdparis OmniOutliner 3 for Mac 2 2009-03-16 03:08 PM

All times are GMT -8. The time now is 07:09 AM.

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