add metadata to pdf from external source

Question

Hi, I have to update around 2000 pdf files' Title and Subject.

Each file has different Title and Subject and they are stored in an excel file.

How can I automate the process?

I have Acrobat Pro installed, and just beginning to learn coding.

I googled a bit, and seems I need to use JavaScript, or maybe VBA?

Any help would be appreciated.

try67 · Answer

Yes, this can be achieved with JS, but it's not a simple task. You would need to first convert the Excel file to a plain-text file (CSV or tab-delimited, for example), read that file using a script (you can use the readFileIntoStream method of the util object, for example), parse it into a data model, and then run an Action where you compare the name of each file that is being processed to the data model, and populate its metadata property accordingly.

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