Link to home
Start Free TrialLog in
Avatar of baytowel
baytowelFlag for United States of America

asked on

using acrobat X Pro, how do I parse data from a fillable pdf programmatically using .net

I'm using acrobat X Pro, how do I parse data from a fillable pdf programmatically using .net
I have attached my pdf. with the fillable data ......
This file only has 3 or 4  fillable fields filled in but should be enough to show what I mean....
I would like to receive this file via email, save it to a server, parse the information, rename the file based on whether there is a PO number, this becomes the filename or not - then use the inputted date or Now(), then email the complete form (images included) to another email while using the parsed data to fill my SQL Server tables.
So my script would look like this phonetically:
If PO > "" then filename = PO data & .pdf
elseif date > "" then filename= date & .pdf
else filename = now() & .pdf
end if
then
send email of filename to joe shmoe
then
parse name, dept, manf, style, size etc to sql server table

Am I crazy, or should this be fairly easy as all data is stored in datafields???

Please help... Thank you.
Max point to everyone....
PreveaOrderForm.pdf
Avatar of Kalpesh Chhatrala
Kalpesh Chhatrala
Flag of India image

Avatar of baytowel

ASKER

Haven't had a chance to try yet, hopefully today.... thank you
Avatar of NKOWA
NKOWA

Check out:
http://www.fdftoolkit.net

Online examples:
http://www.fdftoolkit.net/examples/

Open-source edition:
http://fdftoolkit.codeplex.com/

Also check out:
http://www.pdfemail.net/

Note: I haven't inspected your PDF, but if its an Acrobat Form, or a Static XFA LiveCycle PDF form, then the form can be parsed. If it's a XFA LiveCycle form saved as a "Dynamic" PDF, then you have very few options.
It is an XFA Life Cycle form saved as a "Reader Extended PDF w/ Additional Feaures"... Does that mean I'm stuck with very few options??
When in LiveCycle, click File=>Save As=>?

Does it say "Dynamic PDF", or "Static PDF" for the File Type?
You can still submit the whole PDF format with Dynamic XFA form, but you won't be able to parse it using any library.

If you submit XDP data with Dynamic XFA form, you can parse it, but you won't get the whole PDF in your email, just the XDP data.

If you submit whole PDF format or XDP data with the "Static" XFA, and you can parse XDP and parse "Static" XFA, and get the whole PDF in your inbox by merging.
Dynamic XFA are used for dynamic field and row generation in expanding tables.

If you don't need this feature, I suggest saving as (Save As) "Static PDF".
If you need a custom script, or a single PDFEmail.net script, contact me:

http://www.nk-inc.com/support/sales/
If I save as a static pdf will the customer filling out the form be able to save it?
I am saving as static in adobe livecycle designer, then as Reader Extended PDF w/ Additional Feaures in adobe acrobat x pro
You can enable usage rights the PDF type regardless if it's static XFA, dynamic XFA or an Acrobat form.

The latest version of Adobe Reader doesn't need Usage Rights enabled; because, it allows the client to save with data, and submit whole PDF format. But for older versions of Adobe Reader, you can enable usage rights, and the client will be able to save it or submit whole PDF format.
SOLUTION
Avatar of NKOWA
NKOWA

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This looks like my solution....but how do I make this work:
Dim cFDFApp as new FDFApp.FDFApp_Class
Dim cFDFDoc as new FDFApp.FDFDoc_Class

I downloaded the following library:
http://fdftoolkit.codeplex.com/

where do I need to put the code?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial