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 > OmniPlan > OmniPlan General
FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
Importing CSV Thread Tools Search this Thread Display Modes
I've got a client who's keeping his part of a project in a spreadsheet and I want to import his stuff into my plan. I'm told that MS project does this (though I'm not a user). Can this be done in OmniPlan?

In the release notes for Beta 6 I found the following "Minor Fix"

Quote:
The column mapping panel on import from OmniOutliner and CSV
formats is now resizable and allows the ability to add
custom data columns.
The way I read that it sounds like I can import CSV formatted data into OmniPlan, but I've looked high and low and can't find an import function nor a way to paste data from a spreadsheet into task viewer.
 
Just drag and drop the CSV file onto OmniPlan's dock icon, or if you use the File > Open menu, you should be able to select the CSV file from there as well.
 
Greg's instructions will give you a new project file from the csv file, not integrate it into your existing project. So you'll then have to select the tasks in that new project, copy them, and paste them into your original project.
 
Thanks for the tip, I would have never thought you could just "open" a csv. Perhaps an Import menu pick would be more obvious, for now it could do csv and MS Proj formats? Typically users (or me anyway) think of "open" for native formats and "import" for other formats.

So now that I have this working, I'm having trouble importing duration. My comma separated csv looks like this:

Quote:
"Task","Duration","Start" "Resources","Comments/Notes"
"CLT Alpha Buildout",,06/23/2006,,
"CAMS Order Placed","1d",06/23/2006,"Chung Daniel",
"HW Build Review/Meeting","2d",07/26/2006,"Wan Feiwen",invite Bill
"Build specs received","4d",07/27/2006,"Yu Tehhen, Chung Daniel,"
"Deploy Doc updated","1d",08/02/2006,"Wan Feiwen",
When I import it all my durations are showing up as 1 day (1d), except "build specs" which shows up as "4h" not 4d or 1d. Very odd. What's the expected format for the duration field when it imports? Does this have something to do with the fact that my spreadsheet exported such that the duration field is enclosed in quotes?

Thanks for the tips!
 
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing svg tobiwankenobe OmniGraffle General 3 2009-05-08 06:43 AM
Importing mpp titel OmniPlan Extras 1 2008-11-26 03:15 PM
Importing CSV elitedev OmniFocus Extras 2 2008-02-04 11:02 AM
Importing OO Pro 3 AlainG OmniGraffle General 0 2007-02-14 05:20 AM
Importing on a PC Zoolok OmniOutliner 3 for Mac 1 2006-06-05 08:41 AM


All times are GMT -8. The time now is 04:27 PM.


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