Categories
InDesign macOS MySQL

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.

  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

Categories
InDesign

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
Categories
InDesign

Place Multiple Pages from another InDesign (or PDF) File

This is a very handy script for automating the time-consuming task of placing multiple pages from one file into an InDesign document.

  1. Download the latest version from GitHub
  2. Install the script
  3. Run the script (screenshot below)

There’s a full description and more explanation at InDesignSecrets.com

Categories
InDesign

Bulk Import InDesign Variables

Here’s a simple script that allows you to import variables from a simple text file, directly into InDesign as Custom Text Variables.

Here’s the script: ImportVariables.jsx

And a sample text file for importing.

Categories
macOS

Show Hidden Files in macOS

Apple greatly simplified the ability to show hidden files with the release of macOS Sierra.

CMD + SHIFT + .
Categories
InDesign

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

Categories
macOS

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
Categories
macOS

Shortcuts for Common Special Characters

Shortcuts for Common Special Characters