• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 659
  • Last Modified:

Acrobat X Pro export collected files to spreadsheet

We have an interactive pdf that was designed in an older version of acrobat (8?).  It was set up to distribute and collect data.  The form contains fields that the users complete and a button that emails the form with the data back to our office.  We then have a separate pdf that is set up to collect all the user data.  It was very simple to import new form data, as well as to export all the data back out to an excel spreadsheet.

We recenly upgraded to Acrobat X Pro and seem to have completely lost all ability to import and export form data.  Need to find out how to at least export my exisitng data.

Thanks.
0
Jinghui Li
Asked:
Jinghui Li
  • 8
  • 4
1 Solution
 
Brian GeeCommented:
On the right-side of the toolbar, you will see Tools button. Clicking on it will expose a right-side navigation pane. Underneath the Comment button in the toolbar will be a very small box, that when clicked will show Tools that are available -- make sure Forms is checked on this list. The Forms tool should now be available for you to click to expand its contents. Clicking the option More Form Options > Manage Form Data, you should see Import Data and Export Data options.
0
 
Jinghui LiAuthor Commented:
I don't see a Tools button.
0
 
Brian GeeCommented:
How about going to View > Tools > Forms instead?
0
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

 
Brian GeeCommented:
So you can see what I was referring to, I made a screenshot:

 Screenshot of Acrobat X Pro
0
 
Jinghui LiAuthor Commented:
If I open just a regular pdf, I see the Tools button (Tools | Comment | Share).  But this is a dataset/datasource pdf that was designed to collect the returned form data.  The top panel of pdf looks like an inset of a table, with columns for the data fields, and each row contains the data that was submitted by a user.  The bottom of the form is the pdf the user submitted.  So as you click on diffferent rows, the bottom pdf updates.  

On this type of pdf, I only have one option, which is Share.

Does that make sense?
0
 
Jinghui LiAuthor Commented:
I don't have Tools as an option from the View menu.  I've looked everywhere and can't find any export functions.
0
 
Brian GeeCommented:
I haven't a dataset/datasource PDF readily available to test so I'll see if I can get my hands on one to test and hopefully assist with a solution...
0
 
Jinghui LiAuthor Commented:

I've spent countles hours searching on the web with little luck.

Attached is an article that explains how I initially set it up in Acrobat 8.  I'm just surprised that the upgrade to Acrobat X Pro doesn't support these features.  I am starting to think that I need to reinstall the older version of the program.

http://www.adobe.com/designcenter/acrobat/articles/acr8at_distribform.html


I appreciate your help.
0
 
Jinghui LiAuthor Commented:
I am starting to think that Acrobat Pro X does not support analyzing data from distributed forms that were created in Acrobat 8.  Quite a shame because it worked very nicely in Acrobat 8, and ultimately we'll have to find another product to handle form data.

In the meantime, I have found a co-worker that still has version 8 on their machine and is willing to export it for me - since it's VERY easy to do in that version.  

But I do appreciate your willingness to help.
0
 
Jinghui LiAuthor Commented:
Not sure how to grade and award points. Basically no solution was found.
0
 
Jinghui LiAuthor Commented:
Not sure how to grade and award points.  Basically no solution was found.
0
 
Jinghui LiAuthor Commented:
Not sure how to grade and award points.  Basically no solution was found.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 8
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now