cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
B1234
Level III

Importing multiple pdf files in jmp

I have approx. 300 pdf files each containing data tables I want to import to jmp.  I'm trying to loop trough them to open and attach to a new data table but cant even get files to open!

This is what I have tried but doesn't seem to be working.

I'm using JMP 15

 

Names Default To Here(1);
path = "C:\example folder\";

theFilesList = Files In Directory(path);
For(i = 1, i <= N Items(theFilesList), i++,
	Open(
		theFilesList[i],
		PDF Tables(
			Table(
				add rows(page(1), Rect(0.3267, 1.2373, 3.5835, 2.5003), column borders(0.3267, 2.7608, 3.5835)),
				add rows(page(1), Rect(0.2685, 3.8856, 8.2878, 5.2504)),
				add rows(page(1), Rect(0.2685, 5.3449, 8.2878, 6.5035))
			)
		)
	)
);

 

B1234_0-1651669800533.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Importing multiple pdf files in jmp

Try modifying this part of Open

theFilesList[i]

to

path || theFilesList[i]

Error message is telling you that path "\pdf1.pdf" isn't valid path, so add the directory before the file. You might have to remove extra \ from the end of path or start of file name.

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: Importing multiple pdf files in jmp

Try modifying this part of Open

theFilesList[i]

to

path || theFilesList[i]

Error message is telling you that path "\pdf1.pdf" isn't valid path, so add the directory before the file. You might have to remove extra \ from the end of path or start of file name.

-Jarmo
B1234
Level III

Re: Importing multiple pdf files in jmp

This worked like a charm! thank you !!