topic Re: Importing multiple pdf files in jmp in Discussions

Importing multiple pdf files in jmp

B1234 — Fri, 09 Jun 2023 16:58:21 GMT

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))
			)
		)
	)
);

Re: Importing multiple pdf files in jmp

jthi — Wed, 04 May 2022 13:49:03 GMT

Try modifying this part of Open

theFilesList[i]

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.

Re: Importing multiple pdf files in jmp

B1234 — Thu, 05 May 2022 06:53:47 GMT

This worked like a charm! thank you !!