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

 
Forecast view listings for Mac desktop Thread Tools Search this Thread Display Modes
Quote:
Originally Posted by BrainInside View Post
@kingsinger
I think I get the idea, but I was thinking it is for OmniFocus forecast option on MacOS like it is on iPhone.

If you will be able to get a screen shot I would appreciate. Maybe I'm getting it wrong, however I think it will have no use for me.

Thanks
It isn't really like Forecast view on the iPhone. It's just a way of getting a layout on your desktop that contains similar information to the information contained in the forecast view on the iPhone.

It's not an interactive list. It's simply a text list of items starting in the next x days (or due in the next x days). When you make a change in Omnifocus, the next time the script is refreshed, these changes will be reflected on your desktop.

So if you don't keep OF open on your mac all the time, but you'd like to be able to see your task list at a glance by looking at your desktop, these scripts might be worth you while. But if what you really want is something pretty close to the iPhone functionality, this probably isn't what you want.
 
The "Calendared in the next seven days (by day of week, from iCal)" script appears to assume 10.8 Mountain Lion uses the same sqlite3 table schema as Lion. Apparently it doesn't.
Code:
sqlite3 ~/Library/Calendars/Calendar\ Cache
.tables
.scheme ZICSELEMENT
reveals 10.8 has moved rolled back to using 'zlocation'... or at least that's how my Calendar database is after moving from 10.6 > MobileMe > iCloud > 10.8

I've modified the script a bit to add in a check for sw_vers 10.8. It assumes 10.8 and later will retain 'zlocation' as opposed to 'zlocation1'

From line 11:
Code:
if [ $OSXVER -eq 7 ]; then
    CALTABLE=zicselement
    REMCODE=24
    LOCN=zlocation1
elif [ $OSXVER -ge 8 ]; then
    CALTABLE=zicselement
    REMCODE=24
    LOCN=zlocation
else
    CALTABLE=zcalendaritem
    REMCODE=9
    LOCN=zlocation
fi
 
Thanks – that's very helpful – I haven't seen a 10.8 system yet.

Amended above.
 
To exclude projects from the startdate script, change lines 18-20:

Code:
MATCHES="($STARTS < ($NOW + (7 * $DAY))) and ($STARTS >= $TODAY)"
#TOTAL=$($OFQUERY "SELECT count(*) FROM task t WHERE $MATCHES")
to:

Code:
MATCHES="($STARTS < ($NOW + (7 * $DAY))) and ($STARTS >= $TODAY)"
#TOTAL=$($OFQUERY "SELECT count(*) FROM task t WHERE $MATCHES")
EXCLUSIONS="AND p.name NOT IN ('Daily Review', 'Weekly Review')"
and line 34:

Code:
left join folder f on t.folder=f.persistentIdentifier
WHERE status='active' and $MATCHES
ORDER BY t.effectiveDateToStart, f.name, p.name, c.name
to

Code:
left join folder f on t.folder=f.persistentIdentifier
WHERE status='active' and $MATCHES $EXCLUSIONS
ORDER BY t.effectiveDateToStart, f.name, p.name, c.name
Quote:
Originally Posted by dbyler View Post
Rob,

This is awesome! For those interested in excluding certain projects from the output... just change

Code:
read overTOTAL weekTOTAL foreTOTAL  <<< $($OFQUERY "
	SELECT count(*) FROM $JOIN WHERE $OVERMATCHES;
	SELECT count(*) FROM $JOIN WHERE $MATCHES;
	SELECT count(*) FROM $JOIN WHERE $NEXTMATCHES;
")
to

Code:
EXCLUSIONS="AND p.name NOT IN ('Work Recurring', 'Daily')"
read overTOTAL weekTOTAL foreTOTAL  <<< $($OFQUERY "
	SELECT count(*) FROM $JOIN WHERE $OVERMATCHES $EXCLUSIONS;
	SELECT count(*) FROM $JOIN WHERE $MATCHES $EXCLUSIONS;
	SELECT count(*) FROM $JOIN WHERE $NEXTMATCHES $EXCLUSIONS;
")
In this example I've excluded tasks from the "Work Recurring" and "Daily" projects.

Note: this only works for the DUE script. I'm tinkering with the START script but it's not just a copy-paste operation.

/d
 
In v 0.15 of the calendar there is a bug where it shows past calendar items. At 19:34, 30/10/12 New Zealand time, it shows calendar items back as far as 11:00 on 29/10/12. It will not show items starting at 10:59 or before.

This is related to the timezone, when I set my computer time to GMT then the calendar shows events starting at midnight last night (as expected).

I am running OS X 10.7, is my time zone not being picked up and adjusted for in the script?
 
Quote:
Originally Posted by danielcompton View Post
I am running OS X 10.7, is my time zone not being picked up and adjusted for in the script?
Thanks for picking this up I wonder if there is a daylight savings subtlety at work.

If you enter this in Terminal.app on your system, do you get a correct local time adjustment ?

Code:
date +%z | awk '{if (substr($1,1,1)!="+") {printf "+"} else {printf "-"} print substr($1,2,4)}'
or perhaps more to the point, what does this return, and does it look right ?
Code:
date +%z
 
Quote:
Originally Posted by RobTrew View Post
Code:
date +%z | awk '{if (substr($1,1,1)!="+") {printf "+"} else {printf "-"} print substr($1,2,4)}'
Code:
-1300
Quote:
or perhaps more to the point, what does this return, and does it look right ?
Code:
date +%z
Code:
+1300
NZ daylight savings time is 13 hours ahead of GMT. I'm not sure which of the two is correct but they aren't matching up. What do you think?
 
can anybody make a screenshot of that? I totally don't understand what you guys write here... not everybody is so smart to be a programmer ;-)
 
Quote:
Originally Posted by danielcompton View Post
Code:
-1300
Code:
+1300
NZ daylight savings time is 13 hours ahead of GMT. I'm not sure which of the two is correct but they aren't matching up. What do you think?
They are technically both working - the former derives a zone reset by a simple sign-inversion (so that 13 hours are deducted from the GMT value).

In your 10.59 11.00 example, are we looking at late morning, or at 22.59 and 23:00 by 24h reckoning ?
 
It was late morning, e.g. 13 hours before midnight.

The full terminal output is below.

Code:
$date +%z | awk '{if (substr($1,1,1)!="+") {printf "+"} else {printf "-"} print substr($1,2,4)}'
-1300
$date +%z
+1300
 
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tasks in Forecast view RGC OmniFocus for iPhone 2 2013-04-20 10:03 AM
Calendars-Forecast View sprocketjockey OmniFocus 2 for Mac (Private Test) 1 2013-04-09 12:55 PM
Flagged View Desktop vs iPad russmcduff Applying OmniFocus 3 2012-05-28 04:47 AM
Forecast view? abisot OmniFocus for iPhone 1 2011-04-23 11:30 AM
Anyone know if Forecast view will be coming soon? trulyshy OmniFocus for iPhone 4 2010-08-19 08:08 PM


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


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