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 data into an existing doc Thread Tools Search this Thread Display Modes
I have a project, which is mostly me as the human resource, that I started out keeping track of my time, materials, and labor, in Excel. The fields relevant to OmniPlan that exist in it are:

date, item, my hours, labor cost, materials cost

Mid-project, I began tracking actions (but not materials costs nor labor costs) in OmniPlan.

I want to add some needed extra columns in the spreadsheet, export the relevant columns to a delimited text file, then import it into my existing OmniPlan doc.

My goal is:

- Have all of my hours in OmniPlan, so I can get a total when the project is complete.

I'm going to continue tracking labor and materials costs in Excel (the project is getting close to done).

Following are some things I'm considering doing, and some questions.

1) I think I need to create a start date+time column, and an end date+time column, and somehow get dates into a date/time format in Excel that OP can ingest. The start time is really irrelevant; i.e., it could be 12am of the day.

2) I will add a column for resource, and fill in my name for every row that I did work (again, I don't need to track other's work, since I'm accounting for that as labor cost), then probably sort on that column, and only export rows that have my effort in them.

3) Since OP will move forward any times that are not part of a resources regular or extra-hours schedule, at least when creating tasks in the interface, do I need to, say, create extra hours for every day of every week of the entire project (multiple years), to allow the imported tasks of mine into the project? That seems daunting.

Thanks,

Bob
 
I just finished this. It was easier than expected. I followed help, and exported a sample project, then created a template spreadsheet, got my old data into it, massaged the data (e.g., convert to OP time format), set a start date, and things rolled in quite well.
 
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
importing data ociciornie OmniFocus 1 for Mac 2 2010-11-02 09:51 AM
Importing existing tasks from a PC Cantankerous OmniFocus for iPad 2 2010-08-02 05:45 AM
Importing Data Into OmniFocus endoftheQ OmniFocus 1 for Mac 3 2010-05-30 08:58 AM
Help: Getting existing iPhone data onto new desktop dawesten OmniFocus for iPhone 2 2008-09-03 02:20 PM
Question re: importing existing notes Competra OmniFocus Extras 1 2008-07-25 05:33 PM


All times are GMT -8. The time now is 02:18 AM.


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