3 Replies Latest reply on Dec 28, 2015 2:00 PM by Brian Stoppee

    Adobe Acrobat and InDesign Power for Non-Adobe Apps

    Brian Stoppee Adobe Community Professional

      Adobe Acrobat and InDesign are more than the huge document manipulating powerhouses that we know them to be. They're also project-saving gateways for non-Adobe apps, especially when dealing with tables. How do you extract horizontal rows of data from a PDF, and drop them into another app, if the PDF was created in a series of vertical columns? 1.) Open the PDF in Acrobat DC. 2.) File > Export to > Spreadsheet > Microsoft Excel Workbook. 3.) Open that newly created .xlsx file in Excel or Numbers. Now that page's tables are a series of cells for you to extract as needed. Then there's the need to extract data from tables on websites. It's easy enough to copy the data and paste it, but when you do that, you may see a hodge-podge of text and graphics, some of which didn't even appear on the web page. Try pasting it into InDesign. The graphics disappear. The website's possible typeface wars cease fire. However, there's probably still a bunch of repetitive text on the page, which you want to get rid of before pasting it into another app. By way of example, there may be 120 instances of "Click Here." How do you delete all of them, fast? 1.) Edit > File Change. 2.) In the "Find What" field, type Click Here. 3. ) Leave the "Change to" field blank. 4.) Click on the "Change All" button. "Poof!" 120 instances are gone. There's even far more power in these features. We'll explore more, later.

        • 1. Re: Adobe Acrobat and InDesign Power for Non-Adobe Apps
          gkaiseril MVP & Adobe Community Professional

          A many users have found out the hard way, InDesign form fields do not transfer well using InDesign's export to PDF. It is best to provide space for form fields in the InDesign document and export this simple file to a PDF. Then use Acrobat's Form Tools to add the form fields in Acrobat.

           

          Access fields in a PDF for use in other fields is done with JavaScript. If you are going to create a table of form fields, pre-planning field names is needed so one can use control loops to walk through the field names. You might want to research the use of hierarchical field names because this naming structure allows many different ways to access the grouped field names.

          • 2. Re: Adobe Acrobat and InDesign Power for Non-Adobe Apps
            try67 MVP & Adobe Community Professional

            It's a disgrace, really, that Adobe couldn't get this right.

             

            On Mon, Dec 28, 2015 at 10:00 PM, GKaiseril <forums_noreply@adobe.com>

            • 3. Re: Adobe Acrobat and InDesign Power for Non-Adobe Apps
              Brian Stoppee Adobe Community Professional

              GKaiseril wrote:

               

              A many users have found out the hard way, InDesign form fields do not transfer well using InDesign's export to PDF.

              I cannot say that we have had a problem and we generate hundreds of PDFs from InDesign, each year.

               

              I will admit that I have encountered some seriously messed up PDFs but I do not have the time to backwire them and attempt to discern the origins of the issues, so they may not have been generated by InDesign.

               

              But we go back to the Pre-InDesign 1,0 beta and started beta testing PageMaker 1.0, so we began falling into the best practices and methodologies Adobe has shown us.