Just trying to upload a post!
Link to post: (Importing multiple pdf files)
by Ressel
https://community.jmp.com/t5/Discussions/Importing-multiple-pdf-files/m-p/343202#M59241
Warning: I am new to coding! I have about 500 pdf files containing tabulated data I want to import. I managed to create a script that will extract, stack and transpose the data as well as append/concatenate it to a table (that I called "final.jmp"). Each pdf is represented by one row in final.jmp. Now here's the workflow and issues I identified: Since I couldn't figure out how to import multiple pdfs, I had to resort to importing each pdf individually by changing the *.pdf file name to be imported in the script (which is embedded in final.jmp). After each import I have to close all the intermediate tables created and opened in the process, and save the resulting table as new final.jmp. I then re-open final.jmp, edit the script to the new pdf file name, import a new pdf and so on and so forth. My question: Is it possible to run the script in a repetitive fashion, each time selecting a new pdf until all pdfs from a folder have been imported and collated into a final table? Open( "C:\example folder\example.pdf", PDF Tables( Table( table name( "1" ), add rows( page( 1 ), Rect( 2.0419, 0.9776, 3.1993, 1.1726 ) ), add rows( page( 1 ), Rect( 1.2137, 3.7819, 6.3603, 3.9069 ) ), add rows( page( 1 ), Rect( 0.8717, 3.9636, 3.0796, 4.0886 ) ), add rows( page( 1 ), Rect( 0.9853, 4.1436, 3.0029, 4.2686 ), column borders( 0.9853, 2.5172, 3.0029 ) ), add rows( page( 1 ), Rect( 4.581, 4.1436, 7.297, 4.2686 ) ), add rows( page( 1 ), Rect( 0.8883, 4.4136, 4.6374, 4.5386 ), column borders( 0.8883, 1.9603, 4.6374 ) ), add rows( page( 1 ), Rect( 0.7556, 4.7979, 7.5908, 8.2654 ) ) ) ) ); Data Table( "1" ) << Stack( columns( :Column 3, :Column 4, :Column 5, :Column 6 ), Source Label Column( "Label" ), Stacked Data Column( "Data" ), Output table("2") ); Data Table( "2" ) << Transpose( columns( :Data ), Output Table( "Final" ) )
This message has 0 replies
