Im looking to create a company phone directory based from the import of a spreadsheet/delimited file. It would list the Department and each employee associated with the department as well as their extension.SpreadsheetDepartmentNameExtensionAdminJohn Doe1234AdminJane Doe2345BusinessHowie Doe7890BusinessMowie Doe5678PDF BuildAdminJohn Doe 1234Jane Doe 2345BusinessHowie Doe 7890Mowie Doe 5678Any chance this is possible?

Participant

Question

Company Phone Directory Import

Forum|Forum|7 years ago
March 13, 2018
3 replies
438 views

Im looking to create a company phone directory based from the import of a spreadsheet/delimited file. It would list the Department and each employee associated with the department as well as their extension.

Spreadsheet

Department	Name	Extension
Admin	John Doe	1234
Admin	Jane Doe	2345
Business	Howie Doe	7890
Business	Mowie Doe	5678

PDF Build

Admin

John Doe 1234

Jane Doe 2345

Business

Howie Doe 7890

Mowie Doe 5678

Any chance this is possible?

Acrobat SDK and JavaScript

This topic has been closed for replies.

JR Boulay

Community Expert

This is typically a job for InDesign

Acrobate du PDF, InDesigner et Photoshopographe

T

Test Screen Name

Legend

Or just Word. It’s what Word calls a mail merge. Then save the finished Word file as PDF. Everything else is much harder.

Joel Geraci

Community Expert

You just want to create a flat PDF of the list?

G

gregg5758851Author

Participant

A flat PDF would be fine. I dont want to list the Department for each employee though. I want to 'group' by department and then list the name and extension.

Joel Geraci

Community Expert

Acrobat has a report generator that would let you create a document via JavaScript but you really don't want to do that. It's not as flexible as you might hope. You could also do it by creating free text annotations via JavaScript and then flatten the document but again, you really don't want to do that. It's non-trivial if the list needs to break across pages.

My best advice is to learn how to group rows by column in your spreadsheet and then create the PDF from there.

try67

Community Expert

Sure. The first two fields can be drop-downs and the last one a text field, and they populate each other based on the selections made in them. I've created scripts that implement exactly this kind of thing, including one that lets you set it up based on a spreadsheet. You can find it here: Custom-made Adobe Scripts: Acrobat -- Create Cascading Dropdowns

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded