News:

Main Menu

Acrobat forms

Started by DigiCorn, July 02, 2024, 04:10:43 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

MacTwidget

Quote from: DCurry on July 09, 2024, 09:20:48 AMNo typing required. Get all the PDFs in a folder, select all, copy. Open Excel and paste. It will paste the file names.
Well DAMN! I did not know you could copy and paste directory items like that.
THank you for the tip!

Joe

Quote from: DCurry on July 09, 2024, 09:41:10 AMWeird. I've literally done it hundreds of times. Maybe I glossed over a step - have to have an open Excel doc and your cursor in a cell. 

You can also paste into a text editor like BBEdit. Don't try with TextEdit, though, because it will paste the actual files instead of the names.
Works in TextEdit too if you have the document format set to "Make Plain Text" instead of "Make Rich Text".
Mac OS Sonoma 14.2.1 (c) | (retired)

The seven ages of man: spills, drills, thrills, bills, ills, pills and wills.

Joe

#17
Quote from: DigiCorn on July 09, 2024, 09:35:58 AMI'm in SDP training all week, but I did spend a second and tried this. No dice.
Are you on a PC using Windows or on a Mac? Doesn't work on Windows.
Mac OS Sonoma 14.2.1 (c) | (retired)

The seven ages of man: spills, drills, thrills, bills, ills, pills and wills.

DigiCorn

"There's been a lot of research recently on how hard it is to dislodge an impression once it's been implanted in someone's mind. (This is why political attack ads don't have to be true to be effective. The other side can point out their inaccuracies, but the voter's mind privileges the memory of the original accusation, which was juicier than any counterargument ever could be.)"
― Johnny Carson

"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

"Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut."
― Ernest Hemingway

Joe

Quote from: DigiCorn on July 09, 2024, 10:11:46 AMWindblows
Windblows does work if you put it in List view and "copy path"...then search and replace out the path and just keep the filename.
Mac OS Sonoma 14.2.1 (c) | (retired)

The seven ages of man: spills, drills, thrills, bills, ills, pills and wills.

DCurry

One of my favorite uses for this trick is on a VDP job I used to do that had hundreds of headshot photos. Not every sales rep had a photo and the design was different for those without so I needed an easy way to compare my photo list to the data to see who didn't have a photo. 

Copied the file listing of the photos from the Finer into an Excel column, and in a second column was the list of reps from the data. There's a way you can tell Excel to highlight entries that don't exist in both columns and it doesn't care what order they are in. Makes it easy to see what reps are missing photos. 
Prinect • Signa Station • XMPie

Build a man a fire, and he'll be warm for a night. But set a man on fire, and he'll be warm for the rest of his life!

DigiCorn

I don't have a copy path option
"There's been a lot of research recently on how hard it is to dislodge an impression once it's been implanted in someone's mind. (This is why political attack ads don't have to be true to be effective. The other side can point out their inaccuracies, but the voter's mind privileges the memory of the original accusation, which was juicier than any counterargument ever could be.)"
― Johnny Carson

"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

"Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut."
― Ernest Hemingway

Joe

Quote from: DigiCorn on July 09, 2024, 11:23:40 AMI don't have a copy path option
What version of Windows are you using? I was on Window 11 when I tried it.

Does it do anything if you select "Copy" and then paste into notepad? On Win 11 "copy" didn't give me the option to paste into Notepad.
Mac OS Sonoma 14.2.1 (c) | (retired)

The seven ages of man: spills, drills, thrills, bills, ills, pills and wills.

DigiCorn

Windows 10 Enterprise

Attempting to past to Notepad (ctrl-V) yields zero results (nothing... right-click paste it's greyed out)

Dragging and dropping to notepad is garbage.
"There's been a lot of research recently on how hard it is to dislodge an impression once it's been implanted in someone's mind. (This is why political attack ads don't have to be true to be effective. The other side can point out their inaccuracies, but the voter's mind privileges the memory of the original accusation, which was juicier than any counterargument ever could be.)"
― Johnny Carson

"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

"Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut."
― Ernest Hemingway

David

found this:


QuoteHold down control, shift, and right click the selected documents. Choose copy as path and then paste the data.


there was a mention about win 7 or above for this to work
Prepress guy - Retired - Working from home
Livin' la Vida Loca

DigiCorn

Quote from: David on July 09, 2024, 01:39:30 PMfound this:
there was a mention about win 7 or above for this to work
OK. That worked... but it copied the file name and not the field contents of the pdf, which is what I really need.
This would be great if the customer had named the file with the name of the recipient, and not some random initials (which don't even match the name).
"There's been a lot of research recently on how hard it is to dislodge an impression once it's been implanted in someone's mind. (This is why political attack ads don't have to be true to be effective. The other side can point out their inaccuracies, but the voter's mind privileges the memory of the original accusation, which was juicier than any counterargument ever could be.)"
― Johnny Carson

"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

"Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut."
― Ernest Hemingway

David

Quote from: DigiCorn on July 09, 2024, 01:57:51 PM... if the customer had named the file with the name of the recipient, and not some random initials (which don't even match the name).
I think that is standard procedure for all file names, use something that has nothing to do with what it is.



filesonmyharddrivetoprint.pdf
Prepress guy - Retired - Working from home
Livin' la Vida Loca

DCurry

Quote from: DigiCorn on 7/9/2024, 3:57:51 PMOK. That worked... but it copied the file name and not the field contents of the pdf, which is what I really need.This would be great if the customer had named the file with the name of the recipient, and not some random initials (which don't even match the name).

Correct - this is just a way to use Data Merge to place all the PDFs into an InDesign document so you wouldn't have to manually place them like you did.
Prinect • Signa Station • XMPie

Build a man a fire, and he'll be warm for a night. But set a man on fire, and he'll be warm for the rest of his life!

DigiCorn

Yeah - I get what the end result was. I was a little distracted because I'm on this webex all day, every day this week and still trying to work. 

I don't know what kind of voodoo magic I thought was gonna extract the names out of the field in the individual files. I should just chant and swing a dead cat over my head while facing east.
"There's been a lot of research recently on how hard it is to dislodge an impression once it's been implanted in someone's mind. (This is why political attack ads don't have to be true to be effective. The other side can point out their inaccuracies, but the voter's mind privileges the memory of the original accusation, which was juicier than any counterargument ever could be.)"
― Johnny Carson

"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

"Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut."
― Ernest Hemingway

Tracy

I'm sure this isn't allowed, but If I worked at a place that didn't have pitstop 
I would buy it myself. I have a small company mindset now tho.
I actually like working in bigger companies tho!!