Hello everyone.
I am working on importing a PDf file into IDEA for a client. When I open up the file in Adobe Reader, the columns align under the column titles and the report looks nice and formatted.
However, when it goes through the Report Reader in IDEA, the data in the columns appears to shift and it does not looks as aligned as it was in Adobe Reader. I tried to use the floating trap approach with this file, but did not have much success.
When I open the file in Monarch, the columns stay properly aligned.
My question is does this occur often in IDEA with PDF files? The same thing happens all of the time in ACL with PDF files, almost to the point that I tell my ACL clients to try to avoid getting PDF files as their source data files.
I would be curious for thoughts and to know if this happens in IDEA frequently.
Thanks so much for your help!
Warm regards,
Mike
mkeiffer33
Offline
Last seen: 1 month 1 week ago
Joined: 12/23/2015 - 17:54
Hi Mike,
It does happen on occasion but not that often, generally pdf files import fine. Here is one possible work around for you that will hopefully allow you to import it into IDEA.
http://ideascripting.com/forum/alignment-pdf-file-changes-report-reader
Good luck in the import.
Brian
Hi Brian,
Thanks so much for the quick response. I will give that shot and see what happens.
Plan B would be to import the entire row of data (each record) and then do computed fields to try to parse the data.
Thanks again!Mike
Brian,
You are Da Man! I followed your instructions to the letter and to quote you: "It worked like a charm!"
Thanks so much!
Mike
Glad to help. What pdf printer driver did you use?
Hi Brian,
I downloaded the driver from this website - http://www.win7pdf.com/pdf-printer.html
This seemed to work pretty well, but I am thinking about perhaps investing in Adobe Standard, as I think that program also comes with the Adobe printer driver.
Thanks again!
Mike