Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

JavaScript to export multiple pdfs

Guest
Aug 12, 2016 Aug 12, 2016

Hi,

I'm trying to export multiple pdfs of about 500 pages each (2000KB), into excels, since the pdf are basically tables. I had originally 1 pdf with approx 4,6K pages, but it was to big to export, so I split it in about 10 docs.

Exporting each pdf takes a lot of time, so I would like some code so I can leave it running all night. I'm new in Javascript, so I don't know how to write that simple script and I haven't found the answer after googling a lot. Could someone help me writing it? I'm sure it's just a simple loop that opens files and export them.

Thanks

TOPICS
Acrobat SDK and JavaScript , Windows
832
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 12, 2016 Aug 12, 2016

This needs to be done in an Action, which has its own limitations and probably won't be able to process all of your files in a single go.

Acrobat is simply not suited for this kind of heavy batch processing, unfortunately.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Aug 12, 2016 Aug 12, 2016

Is the problem the size of the document or the number of documents? What if I split it in more, smaller, documents (100pg, 400kb each?). Would that help?

What is the alternative for getting this data into excels then?

Not sure if it is relevant, but I'm using Adobe Acrobat Pro DC.

Thanks

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 12, 2016 Aug 12, 2016

Both could be an issue. You didn't mention how many files you want to process, though...

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Aug 12, 2016 Aug 12, 2016

I have a single document of 4893 pages (22000 kb), I can easily split it in whatever number of documents I need (i.e. 10 docs of 500p each, 20 docs of 250p each, etc... ). Another important thing to mention is that I don't need it to be exported to a single excel... I can easily merge and clean later as many excels as I want using another program.

What do you recommend for converting this data into excel?.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 12, 2016 Aug 12, 2016

Ah, in that case it might work. I would try either of these combinations.

And you don't need a script. Just add a Save command and then specify its settings to export the file to an Excel spreadsheet.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Aug 12, 2016 Aug 12, 2016

Great!!!

How do I do the Save command? and how can I run it automatically to several documents sequentially?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 12, 2016 Aug 12, 2016

You can set an Action to process multiple files by selecting them when you

run it. You can also select the folder where they are located.

To set the files to export to Excel documents add a Save command to your

Action and then click on Specify Settings beneath it. Select "Export

files(s) to alternate format" and then "Excel Workbook". That's it, pretty

much.

On Fri, Aug 12, 2016 at 4:50 PM, gonzalop29 <forums_noreply@adobe.com>

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Aug 12, 2016 Aug 12, 2016
LATEST

I think that will work!! At least it did in my small pilot... I'll let you know once I have time to export the entire file to confirm it works.

Thanks very much!

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines