Monday, November 28, 2011

Acrobat -- Connect PDF to a Database

Important update: Unfortunately, Adobe have been gradually removing the support for DB connectivity in Acrobat (except for forms created using LiveCycle Designer). As of Acrobat XI this functionality is completely gone.

 I've recently developed a set that allows you to connect your PDF to a local or networked database.
It's possible to copy highlighted text, bookmarks, form field values, etc. from your PDF directly into a database table, such as Access databases. It's even possible to access the database from your file and populate fields or create bookmarks based on data read from it. The possibilities are endless.

NEW: You can now download a working example that shows how this tool actually works.
It contains a sample database and a PDF that reads the data off of this database and uses it to populate the form fields in it. The full set of tools is, of course, able to both read and write data off the database.
You can download the sample files from here.

This is a really powerful set of tools. If you're interested in purchasing it, contact me directly.

Friday, November 25, 2011

Reader -- Display Form Data


Direct purchase using PayPal ($25 only)!

This script can be used to display all of the form data in the file in Adobe Reader.
The output is in plain text, which can be easily copied to another application.

Update: Free demo version now available. It will show the values of up to 3 fields.

If you have any questions regarding this tool, you can contact me directly.

Wednesday, November 23, 2011

Batch Edit URL Links in PDF Files


Version I: Direct purchase using PayPal (Older version: $75 only per license)!



Version II: Direct purchase using PayPal (New version, $125 per license)!


This powerful little tool allows you to edit all the links in a PDF based on a simple search and replace command, and it can be used to process an entire folder (and all of its sub-folders) in a single go.
The tool can edit not just URL links, but also links to files, and convert them to URL links.

NEW FEATURE V (16-07-2015):  Yet another new feature for this tool, an option to export all the URL links in all of the selected files to a text file, included in v. 2 of the tool.
In addition, there's now a free demo version of the v. 2 tool, available as well.

NEW FEATURE IV (25-12-2014): The tool can now process links with JavaScript-actions that use the launchURL method.


NEW FEATURE IV (14-11-2014): The tool now also processes bookmarks, as well as fields and links.

NEW FEATURE III (19-06-2014): Now this tool will also process links associated with button form fields, not just Link objects.

NEW FEATURE II: A new version of this tool is now available, which allows you to edit the URLs of your links in multiple files, using multiple commands, specified in a list.
So instead of having to make one change at a time, you can now run as many Search & Replace or Append commands as you wish!
The new tool is available for only $125, and can be purchased through here.

 
New interface of the tool:
(click to enlarge)


There's still a free demo version of the tool available (old version). The demo version will process up to 3 links on the first 3 pages of the first 3 files. The full version has no such limitations, of course.

How the older version looks like:

(click to enlarge)

Imagine the following situation:
You have a set of PDF files which point to your website:
"Welcome" links to http://www.mysite.com/welcome.html
"Intro page" links to http://www.mysite.com/intro.html
"Next" links to http://www.mysite.com/page1.html
etc.
But then you decide to change your domain name to http://www.mynewsite.org and now you need to update all of your PDF files!

Well, this tool will do that for you. You just specify the folder to run it on, the Search & Replace action, the text to match ("mysite.com") and the text to replace it with ("mynewsite.org"), and voila! All of your files are updated in a second, and you get a detailed log of all the changes made to them.

This tool can also append text to the beginning or end of your URL links, so if you want to add a new URL parameter to the end of all of your links, you can easily do so.

This tool does not require you to actually have Acrobat. All you need is to have Java installed on your computer.

If you have any questions regarding this tool, you can contact me directly.

Sunday, November 20, 2011

Acrobat -- Set Initial Layers To Current State


Direct purchase using PayPal ($30 only)!

This script allows you to set the current view state of the layers in the file as the default state when the file is opened.

If you have any questions regarding this tool, contact me directly.

Tuesday, November 15, 2011

Acrobat -- Filter Comments By Color


Direct purchase using PayPal ($30 only)!

For some reason, Adobe has dropped the option to filter the comments list according to the color of the comment in version X of Acrobat. So I decided to jump to the rescue of those who depended on this feature, or just found it useful, and created a script which allows you to do it once again.
You can select the color you want to filter from a list of pre-defined colors, or just click on a comment with the color you want to use and then select the last option in the list: "Selected Comment Color". The script will then identify this color and will only present comments with the same color.

Here's how it works:
1. Select the comment color you want to see from the list

2. Now only the comments with this color are visible (even in the built-in Comments List!)

3. We remove one of the comments, and now we want to restore the comments we've hidden...

4. We're back to the original situation, with our edits in tact.

It's as simple as that...

If you have any questions regarding this tool, contact me directly.

Wednesday, November 9, 2011

New Scripts Location for Acrobat 10.1.1

To all of my customers (and everyone else who encounters this issue):
If you've installed scripts into the user-context folder of Acrobat X, which are:
On Windows XP:
C:\Documents and Settings\(username)\Application Data\Adobe\Acrobat\10.0\JavaScripts
On Vista or Windows 7:
C:\Users\(username)\AppData\Roaming\Adobe\Acrobat\10.0\JavaScripts
And then updated to Acrobat 10.1.1, these scripts will no longer work, due to a change in Acrobat's folder structure.

To resolve this issue, move the scripts to the following folder:
On Windows XP:
C:\Documents and Settings\(username)\Application Data\Adobe\Acrobat\Privileged\10.0\JavaScripts
On Vista or Windows 7:
C:\Users\(username)\AppData\Roaming\Adobe\Acrobat\Privileged\10.0\JavaScripts

If this folder doesn't exist, you can either create it yourself, or place the script in this folder instead:
C:\Program Files\Adobe\Acrobat 10.0\Acrobat\JavaScripts
or
C:\Program Files(x86)\Adobe\Acrobat 10.0\Acrobat\JavaScripts

(My thanks to the Acrobat Ninja for the info related to this problem)

Friday, November 4, 2011

Acrobat -- Create Popup Images


Direct purchase using PayPal ($85 only per license)!


This script will make your standard PDF file much more dynamic and interactive.
It allows you to insert "popup" images that appear whenever the user clicks a certain phrase, or even just hovers with the mouse above it! The image disappears when the mouse is clicked again, or moved away, respectively.

For example, let's say you have some figures in your file. Instead of linking to them on a different page, why not have the appropriate figure pop up whenever the user moves the mouse above the words "figure 1", "figure 2", etc.
The same can be done with products, people's names, tables, screenshots of websites, or whatever... Even pages from another PDF!

How it works:
1. You create a plain-text file (semi-colon delimited) that specifies the phrases and the image to associate with them. For example, it can be:
Figure 1;C:\My Images\Figure1.jpg
Figure 2;C:\My Images\Figure2.gif
Figure 3;C:\My Images\Figure3.png
Figure 4;C:\My Images\Figure4.jpg

2. You then select the properties of the links that display the images (border width, style and color, among other things), in this dialog:

3. The images and links are then automatically added to the file.
If you choose to do so, a check-box will be added to the top left corner of the first page which will prevent the images from popping up, unless checked.
Also, if you choose that option, a report will be presented at the end, specifying how many images were added, and to which pages.

You can download a sample file from here, which shows how the script works.

If you have any questions regarding this tool, you can contact me directly.