Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

A Spotlight Plugin for InDesign Apps
Every now and then I poke around the web to see if someone has found a way to search InDesign files with Spotlight. For many users of InDesign, this missing capability has been a point of frustration since Spotlight was introduced with Tiger back in April of 2005. Now there's a little something for anyone running InDesign CS5 or CS5.5.

Over in the Adobe forums, John Hawkinson put together a plugin. He recommends installing it, then using Terminal to re-index specific files or folders using:

mdimport /Users/UserName/Path/To/File/Or/Folder

I installed the latest version of his plugin (version 0.1c) into ~/Library/Spotlight then ran the mdimport command on my Documents folder. While he's explicit that this is alpha software, I've seen no issues and it seems to work very well. Thanks, John!

[crarko adds: A big help for a fairly significant omission. Good find.]
  Post a comment  •  Comments (3)  
  • Currently 4.00 / 5
  You rated: 5 / 5 (6 votes cast)
[4,654 views] Email Article To a Friend View Printable Version
Sticky Widget from Selected Text Apps
There's a recent Macworld article for quickly making Stickies. I thought that some folks might want to make Sticky Widgets instead.

This is derived from my hint posted a few years ago.

Depending on your system version (and possibly other factors), you may need to launch Dashboard at least once if you haven't since system startup before trying the Service.

Here are the simple steps:
  • Open Automator and create an empty Mac OS X Service document. In the document window set the first popup to text and the second pop-up to any application.
  • Drag a Run AppleScript action into the right side of the Automator document window. Then paste the following line into the Run AppleScript step just beneath the (* Your script goes here *) line:
        set inputText to (input as text)  
        do shell script "open /Library/Widgets/Stickies.wdgt"
        delay 0.2
        tell application "System Events"
          keystroke tab
          keystroke tab
          keystroke inputText
        end tell
  • Save the Service document as 'Sticky Widget from selected text,' then open the Keyboard prefpane.
  • In the Keyboard Shortcuts segment tab, click Services, and put Command+Ctrl+Shift+S into the shortcut area for the Sticky Widget from selected text entry in the list. Close the prefpane (the keyboard trigger is just a suggestion - you can use others, just be sure to test, because whether a shortcut works or not can be affected by lots of things).

[crarko adds: I tested this (without the shortcut), and it works as described.]
  Post a comment  •  Comments (3)  
  • Currently 1.75 / 5
  You rated: 1 / 5 (4 votes cast)
[3,278 views] Email Article To a Friend View Printable Version
10.7: Unlock screens using any admin password Apps
Under Lion, the screen saver authentication dialog box does not allow you to enter a username. So even if you've made the changes detailed in this Snow Leopard hint there is no way to put in alternate credentials to unlock a user's screen.

First, edit /etc/pam.d/screensaver as per the original Snow Leopard hint:
  • Open /Applications/Utilities/
  • Type cd /etc/pam.d
  • 3. sudo cp screensaver screensaver.bak
  • 4. sudo nano screensaver
  • 5. Find the line:
    account required no_warn group=admin,wheel fail_safe
    and change it to:
    account sufficient no_warn group=admin,wheel fail_safe
  • Press Control+X to save /etc/pam.d/screensaver and exit nano.
Then, still in Terminal, we make a wholly unintuitive change to /etc/authorization:
  • cd /etc
  • sudo cp authorization authorization.bak
  • sudo nano authorization
  • Press Control+W and search for unlock the screensaver
  • Change the line:
    <string>The owner or any administrator can unlock the screensaver.</string>
    <string> (Use SecurityAgent.) The owner or any administrator can unlock the screensaver.</string>
  • Press Control+X to save /etc/authorization and exit nano.
  • Reboot the Mac

[crarko adds: I haven't tested this one, but the original Snow Leopard hint was good. Be sure to make the file backups before doing any editing, and if it were me, I'd want to do this on a test machine (with a full system backup) before deploying it. If you try this and find any errors/omissions please post them in the comments, and I'll correct the hint.

Note: Changed references to /etc/authentication to the correct file /etc/authorization and other cleanup.]
  Post a comment  •  Comments (17)  
  • Currently 4.50 / 5
  • 1
  • 2
  • 3
  • 4
  • 5
  (4 votes cast)
[9,155 views] Email Article To a Friend View Printable Version
True fullscreen in Microsoft Word 2011 Apps
Word 2011's built-in fullscreen mode leaves a lot to be desired. Microsoft says they're updating the program to use Lion's fullscreen mode, but until then, here's a way to hide all the interface elements so you can use the whole screen.

After you put Word into its own Space, the first thing to do is hide the menu bar using this tip here.

First I made a backup copy of Microsoft Then I showed package contents on the original and opened the Info.plist that's in the Contents folder. It opened up in Lion's Property List Editor. I hit the 'Add Child' button and typed in LSUIPresentationMode and hit return: it automatically changed to Application UI Presentation Mode. I typed 4 in the Value field, and it automatically changed to All Suppressed. I saved the plist in place. That copy of Word now auto-hides the menu bar (mouse to the top of the screen to show it).

The next step was hiding everything manually in Word. I turned off the ribbon and the toolbars. I put the ruler on AutoHide. In the Window section of the View section of Preferences I unchecked all the boxes and checked the 'Wrap to window' box.

At this point the only thing left onscreen is the window's titlebar. Some Visual Basic can hide that by pushing it up above the screen's top edge. I added this macro to the Normal template using the Visual Basic Editor, then assigned it to a command key sequence using Customize Toolbars and Menus and clicking on the Keyboard... button.
Sub TrueFullscreen()
With ActiveDocument.ActiveWindow
 .Top = -23
 .Left = 0
 .Height = (Application.UsableHeight + 23)
 .Width = (Application.UsableWidth)
End With
End Sub
Now running that macro on an open document makes it take up the full screen. Setting your view mode to Draft or Web Layout will let you use the whole width of the screen for text, with the 'Wrap to window' option I mentioned above. I currently have a document that I'm adding a lot of comments to, and I prefer the balloons interface to the sidebar interface, so I'm using Web Layout.

To show your title bar again, just pick 'Arrange All' from the Window menu.

[crarko adds: I haven't tested this one. Do be sure to make the backup before tinkering with the property list file.]
  Post a comment  •  Comments (0)  
  • Currently 4.00 / 5
  • 1
  • 2
  • 3
  • 4
  • 5
  (1 vote cast)
[14,091 views] Email Article To a Friend View Printable Version
VirtualBox: Using snapshots to avoid excessive TimeMachine actitvity Apps
Are you running another OS with the great and free VirtualBox virtualization application by Oracle? Are you also using TimeMachine? Chances are that you are excessively using Time Machine and filling your Backup disk with slightly different but still huge disk images. Here's a possible solution to this problem:

VirtualBox provides the possibility to create snapshots. This allows you to go back to a virtual machine state when you are not happy with your virtual machine anymore. Possible examples are: you messed up your system or you caught a virus in your virtual machine.

This feature can also be used for circumventing the problem mentioned above, namely the excessive Time Machine usage.
  • Bring your virtual machine to a state you like
  • Create a snapshot in VirtualBox
  • Exclude the snapshot directory from TimeMachine Backup (it is located in /Users/YOURUSERNAME/Library/VirtualBox/Machines/VIRTUALBOXNAME/Snapshots, change YOURUSERNAME and VIRTUALBOXNAME accordingly)
Using that trick, the original disk image will be backed up, while the changes you make everyday will not.

Side effects: Your changes are never backed up, so in case of disk failure, you lose them. If you make changes that are important, you might want to merge the current state from time to time and create a new "safe" snapshot.

[crarko adds: I haven't used VirtualBox for quite a while, but this should be handy for those of you who do.]
  Post a comment  •  Comments (7)  
  • Currently 4.50 / 5
  • 1
  • 2
  • 3
  • 4
  • 5
  (2 votes cast)
[7,449 views] Email Article To a Friend View Printable Version
Search iTunes Radio list by making a new playlist Apps
You can search the iTunes list of radio stations if you add them to a playlist that you created.

If you click the built-in Radio list in your iTunes Library, you can see lots of internet audio streaming radio stations, apparently chosen by Apple, organized by genre; but you can't search the list. The iTunes search field in the top right corner is grayed-out.

If you make a new playlist, and drag radio stations into it, you can search in that playlist.

I wanted to search for any radio stations that might play, for example, 'dubstep' or 'Hindi' or 'reggaeton.'

I made a new playlist and dragged radio stations into it. I tried dragging all of them, but iTunes gave up after 999 stations. I also see that iTunes won't retrieve station names now, but that may be because I tried dragging them all (that would be at least 1500 stations). Maybe my network's sysop shut that off. Anyway, I'll try again tomorrow, but the point of the hint is that you can use the Search feature if the radio stations are in a playlist.

Also, note that you probably should select all stations and uncheck them, because if iTunes is set to Shuffle mode and it chooses a radio station, it'll stop shuffling because an audio stream never comes to a stop.

[crarko adds: I remember putting radio stations into playlists long ago when I use iTunes Radio; never tried to search them though.]
  Post a comment  •  Comments (1)  
  • Currently 3.67 / 5
  You rated: 2 / 5 (6 votes cast)
[5,933 views] Email Article To a Friend View Printable Version
Restoring hidden apps to the list in the Mac App Store Apps
While viewing my purchased apps in the Mac application of 'App Store' I clicked the (X) next to the iPhoto Installed button. iPhoto immediately disappeared from the list of purchased apps.

There is no Undo for this nor any other obvious or searched solution. Here is how to restore the listing of purchased apps. It is not obvious.

Delete an app if you haven't. Under the App Store menu item Store drag down to View My Account.

Enter your password and a new option is available in the account window listing Hidden Purchases with an option to unhide them.

You do not see this option unless you have deleted at least one list item. This provides a way of filtering out rejected apps you have purchased.

[crarko adds: I tested this (in 10.6.8), and it works as described. At least with the iTunes App Store, there is a warning dialog and some instruction when clicking on the X to hide an app as mentioned in this hint.]
  Post a comment  •  Comments (5)  
  • Currently 5.00 / 5
  • 1
  • 2
  • 3
  • 4
  • 5
  (5 votes cast)
[16,578 views] Email Article To a Friend View Printable Version
iTunes: Quickly convert videos to AAC audio Apps
I do have some video podcasts I'd love to be able to listen to in double speed on my iPhone. However, this only works for audio files.

For audio files in your iTunes library, it's possible to quickly convert them to your default audio encoding using the command 'Create AAC Version' in the 'Advanced' menu. With video files, that particular command is greyed out. However, when pressing the Option key, the command turns into 'Convert to AAC…' which lets you select any iTunes-compatible file in the browse dialog and turn into AAC audio. While this approach works, it is clunky and cumbersome.

Recently, I've discovered a much more straightforward solution which takes advantage of functionality that seems to be sort of a bug in iTunes.

Select the desired video in iTunes and then choose the aforementioned 'Convert to AAC…' command using the Option key but let go of the Option key as soon as you selected the menu item. Instead of letting you select a file to convert, iTunes will happily convert the selected video to AAC.

Note however that your video will end up in iTunes' 'Music' section. If you want it to appear in 'Podcasts' or 'iTunes U', you will have to select it, get info and change the media type manually.

[crarko adds: It's also seems possible to get 'Convert to MP3' depending on the format of the original video.]
  Post a comment  •  Comments (6)  
  • Currently 3.67 / 5
  You rated: 3 / 5 (6 votes cast)
[16,505 views] Email Article To a Friend View Printable Version
Numbers: Simulate XIRR annualized rate of return Apps
XIRR is a classic and widely used Excel function which is very useful for calculating rates of return on investments given an initial and final value and a series of cash inflows and outflow in irregular amounts at irregular intervals (e.g. Jan. 15, invested $200, Mar 12, withdrew $100, ...). Although iWork '09 Numbers doesn't have this function, it can be simulated, as described below.

XIRR takes as input a series of dates and cash flow amounts, and computes the annualized rate of return over the time period with the correct allowance for the time impact of the transactions (earlier transactions have had more time to make an impact). As a typical application, you might want to calculate your yearly rate of return given an irregular set of investments and withdrawals, and that's the example we'll consider here. The Numbers IRR function calculates a per-interval return rate given an irregular series of inflows/outflows at fixed intervals. Here's how to use it to simulate XIRR:
  • Create a Cash Flow Summary Table with columns Date, Amount (and optionally Notes). For every cash event flow in a year, enter the date it occurred on (Numbers is smart and will recognize and normalize any dates you enter), and the net amount for that day: positive for inflows (investments) and negative for outflows (withdrawals).
  • Create another Cash Flow Daily table with only two columns: Date and Amount. In the first row of this column, enter the date as 'Start:' and for the amount, the starting account value, as a positive number. In the second row, enter the date 1/1/year for the year of interest. Select it and pull down from the circle at lower right to create a date entry for each and every day, through 12/31/year.
  • Starting on the date 1/1 (e.g. in cell B2), enter in the Amount column the formula:
    =SUMIF(Cash Flow Summary::$A,A2,Cash Flow Summary::$B)
    Where Cash Flow Summary is the name of the table listing the cash flows. Select this cell and drag it down to copy this over the rest of the days in the year. This will select any cash flow amounts from the Cash Flow Summary table above on the given date.
  • On the last day, 12/31, edit the formula, subtracting the final balance of the account. So, if there were no investments or withdrawals to the account on that day, this cell will contain the negative final account balance. You might consider referencing the initial and final account values from another, more convenient location.
  • Anywhere else, you can now compute the annualized rate of return as:
    =(IRR(Cash Flow Daily::Amount,(1+Guess)^(1/Days in Year)-1)+1)^Days in Year-1
    Where Guess is an (annualized) initial guess for the return rate (like .05, or 5%), and Days in Year is the number of days in the year (365 or 366 for leap years).
  • (Optional, for appearance) Select all the rows of the Cash Flow Daily table except the first and last, click on the black triangle which appears at left for any of them, and Hide Selected Rows.
Now you can add any number of days with inflow/outflow to the summary table and the return value is updated at once. As a check, for most cash flow streams, the computed annualized return will lie between the two values:

Pretending the total yearly net inflow occurred at the beginning of the year, increasing the initial account value:
Final Value/(Initial Value+Net Inflow)-1
Pretending the total net inflow occured at the end of the year, reducing the final account value:
(Final Value-Net Inflow)/Initial Value-1

[crarko adds: I haven't tested this one. I am curious to know how many of you have successfully replaced Excel with Numbers. I'd guess that would be the most difficult piece of Office to do without.]
  Post a comment  •  Comments (1)  
  • Currently 3.75 / 5
  You rated: 5 / 5 (4 votes cast)
[5,605 views] Email Article To a Friend View Printable Version
Transfer iPhoto book to SnapFish Apps
I was nearly done laying out a photo book in iPhoto when I got a coupon for half off a photo book printed from Snapfish. I wanted to take advantage of the coupon but didn't want to have to redo all the work I had put in laying out the book. With a modest amount of work I was able to transfer my book over. Here's how:

First I exported the photo book from iPhoto to a PDF by right clicking in the background of the photo book layout and choosing 'Save book as PDF". Then I created an Automator workflow to create a JPG image from each page of the PDF that went like this (just search for each command, drag it over, and select the option as indicated below):
  • Get selected Finder items
  • Render PDF Pages as images
  • Move Finder Items (to Desktop)
  • Rename Finder Items (Make Sequential)
Save the workflow. After running the PDF through this workflow I had a series of sequentially numbered images files, one for each page of the book. I uploaded these to Snappish and used the full page layout option to make each image a full page. Presumably you could do something similar for other Photobook printing sites.

I did have to reproduce the layout of the front and back covers in Snappish, and everything else was just as I had it in iPhoto. Of course the layout in Snappish was static and could not be tweaked, so make sure you have everything just the way you want it in iPhoto before transferring it over.

[crarko adds: I haven't completely tested this one, but the Automator workflow was pretty simple to create.]
  Post a comment  •  Comments (3)  
  • Currently 5.00 / 5
  • 1
  • 2
  • 3
  • 4
  • 5
  (4 votes cast)
[7,737 views] Email Article To a Friend View Printable Version