News:

Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - Joe

#1
Adobe Acrobat / Re: Update to Acrobat caused problems
February 15, 2024, 02:03:39 PM
Quote from: Foozball on February 15, 2024, 12:54:54 PMC'mon MAN!!
That was my first check (after i managed to find/kill a weird layer of shadows), then I re-exported the PDF (and the URL worked) and re-saved the JPG from the PDF which still failed, as "nttp" ...


However, I just heard from the sender "yeah, she made in CANVA, but it's still a PDF" ... I still haven't tried to take a Canva file to print (unlike you "lucky" guys), but all bets are off now.
Hey I had to ask...

I wonder if Acrobat is converting the link via a reverse OCR (changing text to image instead of image to text) and it is thinking the h is an n. That is just a wild guess and I have no proof. :P
#2
Adobe Acrobat / Re: Update to Acrobat caused problems
February 15, 2024, 11:19:05 AM
Quote from: Foozball on February 15, 2024, 09:02:03 AMRandom question about Acrobat: I'm working on a page for a friend in acrobat which will be a PDF (obviously) and saved a copy as a JPG ... it KEPT the website link, and I was SUPER impressed with that, for an image file.

But in the JPG the url links to "nttp.." despite the text being CORRECT and using "http.." ... wtf?



Any ideas/thoughts from you guys?
Are you sure the link in the PDF file correct? In the PDF the text can be correct while the actual link may not be. If you click the link in the PDF does it go to the correct place.

How to Create a Clickable Web Link on a JPG
#3
Adobe Acrobat / Re: Update to Acrobat caused problems
February 13, 2024, 03:36:21 PM
Oh come on! Do the upgrade. Live a little. Think of all the cool new features you are missing out on.
#5
The Rest... / Re: Excel stuff
February 07, 2024, 05:44:35 PM
#6
The Rest... / Re: Excel stuff
February 07, 2024, 05:00:09 PM
Quote from: pspdfppdfxhd on February 07, 2024, 03:36:13 PMAnd besides, Guardian Angels aren't supposed to ask for payment. It's in their code of conduct book. I saw it once.
Was kidding.
Spoiler
Not needed with the billions of dollars I earned in prepress over the years.
[close]
#7
The Rest... / Re: Excel stuff
February 07, 2024, 02:44:36 PM
Quote from: pspdfppdfxhd on February 07, 2024, 01:05:04 PMCongratulations Joe! The data house approved the text file with the double quotes!!

Another fine job by our prepress Guardian Angel!
How long before the check arrives? >:D
#8
The Rest... / Re: Excel stuff
February 06, 2024, 06:44:41 PM
Isn't that the way it usually goes? Pull a miracle out to be screwed over by something else. Been there...done that!
#9
Adobe Acrobat / Re: Update to Acrobat caused problems
February 06, 2024, 10:44:59 AM
So does Affinity Publisher. ;D
#10
The Rest... / Re: Excel stuff
February 05, 2024, 01:01:32 PM
Quote from: pspdfppdfxhd on February 05, 2024, 11:40:10 AM
Quote from: Joe on February 05, 2024, 11:27:58 AMJust google searches and finally ran across the ="" formula. Didn't save the website and now can't find it again. ;D

I did some VDP in my prepress life. Not a lot but some.
Well you must be a better "googler" than I.

"I did some VDP in my prepress life. Not a lot but some." (some is enough).
Do you have Excel? I did find something that says Excel outputs blank cells as ,"", instead of the way LibreOffice does it as ,, with the double comma signifying an empty cell.
#11
The Rest... / Re: Excel stuff
February 05, 2024, 11:27:58 AM
Just google searches and finally ran across the ="" formula. Didn't save the website and now can't find it again. ;D

I did some VDP in my prepress life. Not a lot but some.
#12
The Rest... / Re: Excel stuff
February 05, 2024, 10:33:02 AM
Quote from: pspdfppdfxhd on February 05, 2024, 10:28:52 AMI am filtering out each column for blanks and putting the +"" formula in the blanks. Seems ok so far.
What formula is +""  .

Or do you mean =""  ?
#13
The Rest... / Re: Excel stuff
February 05, 2024, 10:24:25 AM
Quote from: pspdfppdfxhd on February 05, 2024, 09:03:07 AMInitial testing seems to show that worked like magic!

My only issue is going through and finding all the blanks, there are 15,000 addresses in there.
Yeah that is going to be a problem since you can't do a search for an empty field and replace it with something else in LibreOffice. Probably the best option would be go ahead and make the .csv file and then open the .csv file in a text editor and search for ,, and replace with ,"", assuming of course there aren't any fields that have a double comma in it.
Quote from: DCurry on February 05, 2024, 10:16:51 AMAt my old shop if all the fields were wrapped with quotes an empty value showed as ,"",
You mean if you entered "" in the field? If so he would still have to manually enter it in all blank fields. Or do you mean empty fields would export as ,"",? If so were you using Excel or something like LibreOffice?
#14
The Rest... / Re: Excel stuff
February 05, 2024, 08:20:59 AM
Yes in Libre Office with the empty cell selected in the formula field as shown here:

Screenshot 2024-02-05 at 8.20.09 AM.png
#15
The Rest... / Re: Excel stuff
February 05, 2024, 07:31:09 AM
OK to get it to look like this:

Screenshot 2024-02-05 at 7.29.49 AM.png

In the blank cells enter this formula: =""