topic Re: Can JMP read PDF file/s? in Discussions

Can JMP read PDF file/s?

anirdesh_gmail_ — Mon, 27 Jun 2016 13:25:06 GMT

Can JMP read PDF file/s?

We have many PDF and EXCEL files to read to generate report.

Re: Can JMP read PDF file/s?

jenkins_macedo — Wed, 19 Oct 2016 03:12:42 GMT

Yes, If you just want to view a pdf in JMP. Yes, JMP has the capability to upload the file and view it. If you have a pdf file with data that you need to extract, than you might want to use the Internet Option by clicking on File > Internet option and select it either as a web page or text.

That brings you to this pop-up window which ask you for the URL. Copy and paste it there and select the Open As: Webage, Data and Text.

As for Excel, JMP reads all Excel files saved as EXCEL, Text, CSV, etc. Do you know that you can also upload directly JMP by using the JMP-Excel Add-in?

Re: Can JMP read PDF file/s?

anirdesh_gmail_ — Mon, 27 Jun 2016 15:44:47 GMT

My PDF files are on the local network drive. Any clue.

Re: Can JMP read PDF file/s?

msharp — Wed, 19 Oct 2016 03:12:52 GMT

Let's be a little adventurous shall we? What do you think will happen when you put a file path location into a web browser? It opens it!

Let's try the same here.

Example:

It works!

Re: Can JMP read PDF file/s?

anirdesh_gmail_ — Wed, 19 Oct 2016 03:13:02 GMT

I already tried to put path name as : c:\temp\my_test_file.pdf

I got the message below.

Re: Can JMP read PDF file/s?

jenkins_macedo — Mon, 27 Jun 2016 17:30:33 GMT

What specifically are on those pdf files? Data? If data, convert the pdf as a text file and upload such that you can retrieve the data. You can also upload the pdf directly, but that will only allow you to view the contents of the pdf and nothing else, or maybe I could be mistaken. There are lots software out there that you can use to convert pdf back to just a simple text file. Once that conversion is done, you can upload it as a text file directly to JMP. As for Excel files, just upload that as Excel by selecting the appropriate file format during upload by clicking File > Open > and than change the file format to Excel or whichever format your file was originally saved in.

Re: Can JMP read PDF file/s?

jenkins_macedo — Mon, 27 Jun 2016 17:57:11 GMT

Did you attempt uploading the file from your local computer using the internet connectivity data upload file above? If you are uploading directly from your computer instead of the internet, you don't need the link, but rather use the File > Open option

Re: Can JMP read PDF file/s?

msharp — Mon, 27 Jun 2016 20:09:03 GMT

I'm going to recommend what Jenkins recommends below since it appears that you are trying to import data saved in a .pdf format. I'm betting the easiest way is to convert the PDF files into an extension better suited for data manipulation like a .txt or .csv.

Re: Can JMP read PDF file/s?

anirdesh_gmail_ — Tue, 28 Jun 2016 15:08:09 GMT

Thanks for all the responses from smart JMP contributors. Learned that PDF file needs to be converted to EXCEL | DOC file format

in order to use it wisely.

Re: Can JMP read PDF file/s?

jenkins_macedo — Tue, 28 Jun 2016 15:39:49 GMT

I just posted a recommendation out there for developers to come up with an Add-in that can convert pdf data files into text format to else the troubles with having to use other software to convert these pdf files into text file/excel anirdesh@gmail.com

Re: Can JMP read PDF file/s?

Jeff_Perkinson — Mon, 18 Nov 2019 21:22:21 GMT

JMP 15 can now import data from PDF files.