Setup ODBC on macOS

In order for Easy Catalog’s ODBC extension to connect to a MySQL server, you need to have an ODBC DSN already configured. X X

  1. Download and install the driver from dev.mysql.com
  2. Download and install the ODBC Administrator from iodbc.org
  3. Open the ODBC app and click on “System DSN”
  4. Click “Add” and choose the appropriate driver
  5. Name your source and add Keyword/Value pairs like this
    • HOST: server IP or domain
    • USER: username
    • PASSWORD: password
    • DATABASE: dbname

Thread Pre-Existing Text Frames

If you have a document that has unthreaded text frames (fig. 1) and you want to thread them together, but don’t want the text to end-up smashed together (like fig. 2) when you’re done, follow these steps.

figure 1
figure 2
  1. Do a GREP Find/Replace with these values (screenshot fig. 3)
    • Find: .\z (last character in a text frame)
    • Replace with: $0~R (previously found text and frame break character)
  2. Thread the frames together

Your finished product will look something like fig. 4!

figure 3

figure 4

InDesign Find & Style Paragraphs

If you have text that’s been imported with basic text tags to define what style should be applied to that specific paragraph, you can use a simple script to delete those “Text Tags” and apply the corresponding paragraph style.

For example, say you have the following text:

[HEADER] This is a Simple Header
[SUBHEAD] Subtitle Goes Here
Nullam quis risus eget urna mollis ornare vel eu leo. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Integer posuere erat a ante venenatis dapibus posuere velit aliquet.

And you want it to be formatted like so:

This is a Simple Header
Subtitle Goes Here
Nullam quis risus eget urna mollis ornare vel eu leo. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Integer posuere erat a ante venenatis dapibus posuere velit aliquet.

Here’s how to achieve this with a simple script that can save you a heap of time when you have a lot of such tags.

  1. In the Scripts panel, open the folder: Application > Samples > JavaScript > FindChangeSupport
  2. Right click on the .txt file and choose “Reveal in Finder”
  3. Open the .txt file in a text editor, add these two lines to the end of the file and save it (you can substitute the underlined strings with any combination you’d like, the first one is the “Text Tag” that’s currently in your document and the second is the name of the paragraph style that you want to apply to the matching paragraphs)
    text {findWhat:"[HEADER]"} {changeTo:" ", appliedParagraphStyle: "Heading"} {includeFootnotes:true, includeMasterPages:true, includeHiddenLayers:true, wholeWord:false}
    text {findWhat:"[SUBHEAD]"} {changeTo:" ", appliedParagraphStyle: "Subhead"} {includeFootnotes:true, includeMasterPages:true, includeHiddenLayers:true, wholeWord:false}
  4. Make sure that you have corresponding paragraph styles in your InDesign document
  5. Double click the script: Application > Samples > JavaScript > FindChangeList.jsx

Show Hidden Files in Yosemite

If you’re looking for a way to show your hidden files in Yosemite (Apples latest OS as of March 2015 — OSX 10.10). All you have to do, is change a setting for Finder and then relaunch Finder. This can be done with aa couple of very simple terminal commands.

  1. Open terminal
  2. Type the code below and hit return
    defaults write com.apple.finder AppleShowAllFiles TRUE
  3. Then type this and hit return again
    killall Finder

When you’ve had enough of seeing all your hidden files just reverse it!

  1. Open Terminal back up
  2. Type this and hit return
    defaults write com.apple.finder AppleShowAllFiles FLASE
  3. Type this hit return and you’re back to normal!
    killall Finder