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

Getting Data in and Out (Mostly FileMaker <-> OmniPlan, but could apply to others) Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
I first asked about AppleScript, but what I really wanted was to be able to export files from FileMaker, and load them into OmniPlan.

Here are the things that I have found so far:

0.) Apparently, OmniPlan *can* import ".csv" format files, which wasn't clear from the mini-manual or the OmniPlan web page.

1.) When you export from OmniPlan to what Omni calls ".csv" what you really get is a tab delimited file. To get FileMaker to happily import this file, you must change it to be a ".tab" file.

2.) The converse is true in exporting from FileMaker. To make OmniPlan understand the file, you have to ask FileMaker to make a ".tab" and then re-name it to be a ".csv". I would recommend that you change this to match FileMaker's terminology, as it is one of the most likely programs apart from Excel which people are likely to want to use. Or, just fix your .csv files to really be comma separated values.

3.) The names of the columns created on export are different than the names that the "Column Mapper" is looking for on import. Further, could it be possible to make a .csv file that would not need to be mapped? OmniPlan could look at the file, and if it looked "right" (Properly ordered column names in the first row?)

4.) I think an import function which would allow you to load data into an already existing file could be really cool. Of course, this would raise the issue of resolving conflicts between old and new, so it might be a mistake. Of course, through the use of Task ID's and unique resource names, etc, this problem could be avoided.

In the end, I am interested in being able to do the following:

Store information about tasks and dates in our FileMaker database.

Use OmniPlan to visualize that data. Manipulate the data in OmniPlan: Resolve conflicts, adjust the order of tasks, etc. That is, stuff that should be really slick in OmniPlan, and which would be tedious and kludgey in FileMaker (and require a lot of custom layouts, scripting, etc.)

Export the data from OmniPlan and use it to update our FileMaker records.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Go to a particular FileMaker record omnibob OmniFocus Extras 0 2013-05-06 07:05 PM
OmniPlan V2 - Losing columns of data when copying to Excel dedestan OmniPlan General 1 2011-08-19 04:03 PM
does not appear to contain valid OmniPlan data cfportaluser OmniPlan General 8 2009-11-30 10:59 PM
Omniplan does not appear to contain valid Omniplan data fposada OmniPlan General 2 2009-11-30 10:58 PM
OF and Filemaker Pro : any chance to link ? fabrice67 OmniFocus Extras 3 2008-01-17 02:00 PM

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

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