Need help with a simple batch script

[hhaji]

Hi,

This is my first post, I am new to this forum.

I would appreciate your help. 

I have a full time job unrelated to programing but could benefit from having a script like below that would help me autmate data extraction.

We have windows 10 operating system.

We have an old system in place that the following automation would cut down on my wasting time extracting data manually from a bunch of pdf files that have txt and pictures combined

I learned that the below script (manually) would do the job but it needs to turn into a batch job.

Please feel free to post your reply on the forum or email me directly.

Rgds,

----------
# need a script.bat or .cdm to do the following

for i = 1 to 100

copy D: "example"+"i".pdf to C: "example"+"i".pdf

# when in C: drive
# do the following 4 subroutines

open example"i".pdf
save as example"i".jpg

open example"i".jpg
print test"i".pdf      # this will allow me to extract numbers from a picture

open test"i".pdf
save as test"i".xls

open test"i".xls
Vlookup x,y,z,w

Rtn (for i=)

-----------
 

[Squashman]

What programming language is that.  It certainly is not a Windows .bat file.

[Geek-9pm]

We have an old system in place that the following automation would cut down on my wasting time extracting data manually from a bunch of pdf files that have txt and pictures combined

Explain how you  do it manually.
Your manual method can be used as a model for a script.
First tell us what you need to d.

What do you wish to get out of the PDF documents?

[hhaji]

Sorry folks for not being clear,

This is not in any particular language.  I just typed in my actions as I would do the process manually, step by step.  I left out bunch of sub-steps for brevity. 

My hope is to get feed back on what these steps would be, legally stated in a typical .bat script, that I can go and run it as is - with some minor edits for the proper folder location etc.  I am assuming that the script can open a pdf file and save it as jpg for example - or am I incorrect on that?

rgds,

[Squashman]

I am assuming that the script can open a pdf file and save it as jpg for example - or am I incorrect on that?

What program are you using that does that?  Does it have command line capability?

[hhaji]

That is exactly why I am here at this forum asking for the clear syntax instructions.  What specific text do I need to type into the Notepad with what proper punctuation to save as foo.bat in order to execute the batch job at the C> prompt or the windows command line?

For example if you had to write a script to do the following what would your .bat script look like?

1.   Open foo.pdf
2.   Save as foo.jpg
3.   Open foo.jpg
4.   Print to pdf as FOOO.pdf
5.   Open FOOO.pdf
6.   Export to foo.xls

Mind you my full time job has nothing to do with programing but if I get a partially working example from one you experts I can play with it till I get it to work - with some possible additional help

[patio]

You didn't answer Squashmans question...

[hhaji]

Adobe Acrobat DC Standard - I can edit pdf file but not sure if it does what you are asking.  Sorry Squashmans.

[Geek-9pm]

This is a reference:
https://helpx.adobe.com/acrobat/tutorials.html
Fill, edit, sign, and share PDFs on any device.

PDF does a good job of putting words and pictures together. But it is weak on arithmetic and things using numerical calculations.. Like designing bridge.

In general, a PDF is fora visual presentation and is done by hand because it has a flare for things people do by hand. It is a presentation, not a sale report.

Well, you could use it for sales report. But the data would come from some kind of source that does numbers, not pictures. Now it you are doing studies in handwriting, you would use pictures.

So again, What do you want to do? What is it you want to show other people? some numbers? Some pictures? Why is it information in a PDF to start with? Is it your research?  Did it start out as a PDF and not a spreadsheet?

The key here is no programming languages, but rather what kind of work are you doing?  Is this something in medical treatment? Is this for sales tram?  Are you investigating handwritten documents?  Are you building a rocket ship?

Just want to help. 

[BC_Programmer]

1.   Open foo.pdf
2.   Save as foo.jpg
3.   Open foo.jpg
4.   Print to pdf as FOOO.pdf
5.   Open FOOO.pdf
6.   Export to foo.xls

I'm skeptical that this can be done with a Batch script, at least not without third-party software that provides most of the features. Particularly since based on your description previously you want to have the PDF import from jpeg actually attempt to recognize text.

[Geek-9pm]

I'm skeptical that this can be done with a Batch script, at least not without third-party software that provides most of the features. Particularly since based on your description previously you want to have the PDF import from jpeg actually attempt to recognize text.

That is about what I was thinking too.

[nil]

It sounds like you have two separate problems: you need to figure out a process to extract data from a PDF, and also you'd like to automate that process -- whatever it is.

It sounds like you need to extract text and images separately from a PDF, is that correct?

It would help if you describe in detail what process you currently use --

[DaveLembke]

Im  thinking same along the lines of what BC stated, 3rd party software would be needed. I use a keyboard/mouse macro for automated redundant stuff. It basically allows you to go through the process manually the first time while recording your actions. Then you can compile that into EXE form and call that from Batch or any other scripting or programming language as a system call etc. Software I use costs money though so if looking for a free solution I dont have a free solution.

I use Jitbit Macro Recorder for automated stuff. https://www.jitbit.com/macro-recorder/

The cool thing is that you can also go in and alter it before compiling it as a stand alone EXE to speed it up removing time delays while it was recorded when you were slow to be careful not to mess it up etc, as well as it has a linear execution list of what its going to do and you can add a goto loop etc and make it run over and over as well as add or remove stuff to sharpen it up for whatever application you have.

Here is a video of how it operates: https://www.jitbit.com/macro-recorder/macro-recorder-video-tutorial/

[Squashman]

PDF to JPG to PDF to Excel? That is a big *censored* in my book. Makes no logical sense.

[patio]

PDF to JPG to PDF to Excel? That is a big *censored* in my book. Makes no logical sense.

It souunds to me that the work staff are giving him impossible tasks...this is for work as per the 1st post.
Why they would do this i have no clue...