2

I have built a catalog in in-design and the prices, description and item numbers are in Excel. We have imported the data by linking the excel sheet to tables.

Here is the issue. My reps want to change the pricing for each of these items themselves and be able to save it out as a PDF. My reps don't have Indesign nor the skillset to use the program.

Is there an easy way for them to import all their adjusted prices into a PDF somehow? Like a data merge only using a pdf and excel? Maybe there is another approach or another program that can do this because each rep would have different prices and they will not want to type in each price for over a 100 page catalog with approx. 5000 items.

1 Answer 1

3

Note: I never tried data merge within a PDF with an Excel file but found some info about it.


Acrobat Pro

Apparently it might be possible to do this with Adobe Acrobat Pro. You can create forms with fields using Acrobat Pro and there's an "import data" functionality.

You'll create some fields in Acrobat Pro and link them to the same cell names of an Excel sheet; that should auto-fill them and logically when the Excel file will be updated, the fields will be updated too.

Fields can be transparent and you can apply them anywhere on your original PDF exported from Indesign. One thing though, your client will need Adobe Acrobat Pro (not the Acrobat Reader) to save their data in the fields, and you'll also need to provide them the fonts or use the safe fonts.

I guess 5000 items should work, that's certainly going to be a lot of work to set up for you. In worse case, if your reps computers or the software can't manage that many data, the catalog might need to be split in sections and reassembled within Acrobat once all the data are filled in each section.

One thing that might be annoying is when you'll make updates on your Indesign file and re-export the PDF, I'm not sure you can quickly re-apply all the fields. You might need to copy/paste them from one PDF to the other or re-do them all again. That's something maybe the new Acrobat Pro fixed and made more convenient.

merge data in a PDF from Excel

I found this link about it:

https://answers.acrobatusers.com/Can-I-import-data-Excel-spreadsheet-fillable-PDF-Form-q113686.aspx

http://help.adobe.com/en_US/acrobat/X/pro/using/WSDD95883E-EB9B-409b-8C7C-33E0DAE68FFE.html

More links here:

Illustrator invoice to client useable PDF


Indesign

You can create forms from Indesign and export your PDF as interactive. And then use the import data to link your Excel, and fix the fields if necessary.

Apparently it can be a bit buggy if you use libraries but it's probably faster to create at least the fields in Indesign.

Basic design layout considerations

The auto field detection process looks for certain basic form design elements. To help improve the process, here are some general tips to consider when authoring a form.

  • Keep it simple and uncluttered—use ample white space or separator lines between areas.

  • Keep your layout well-organized so the field tab order is set properly.

  • Keep text within a 10–24-point size range.

  • Avoid drop shadows or ornate graphics on text labels.

  • Avoid overlapping fields, especially within areas that use underlines.

  • Avoid heavy decorative graphics or transparency on the page.

  • Use white as the primary background color; avoid putting text on top of colored rectangles.

  • Use the same style for each type of form object.

  • Do not use the same text label across multiple fields.

  • Make sure custom fonts use the proper encodings. In Acrobat 9 Pro or Acrobat 9 Pro Extended, you can use the Preflight tool to determine this.

Source: https://acrobatusers.com/tutorials/designing-forms-auto-field-detection-adobe-acrobat

https://helpx.adobe.com/indesign/using/dynamic-pdf-documents.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.