How Do I Fill In An Adobe (Fillable) PDF File With Data From A Database
Posted on 2005-03-21
I'm new to Adobe (Professional 7.0) I'm actually self-teaching myself Adobe PRO. Please go easy (and VERY simple) on me?
I have 1 field of information stored in an Oracle database - called 'Name.' (There are actually more fields, but once I get this simple example out of the way, I can figure the rest out.)
How do I pass the information contained from the Oracle "Name" field to the Adobe (fillable) form so the end-user can print it out? (I explain it in much greater detail - see below.)
My thinking - Is it this simple?
I'm utilizing and getting more and more familiar with Adobe Designer, but too self teaching myself. So if could go easy on me, help shed some light there too, it'd be a great big help. Such as, is it as simple as save the "fillable" Adobe form, and naming each field using the "Binding" name field to pass my information to?
I know how to program getting the data using a Web form via CGI into an Oracle DB, and then getting the information back out of the database.
If there is anyone so kind as to just leave one example of how to automatically fill-in one field say "name" and fill in the (fillable) Adobe form's "name" text box, when called from a Web form, I'd appreciate it. I consider this extremely difficult - at least from my point of view - points!
My (full and detailed explaination) example:
I have created a very simple HTML form for the user to fill in their name - then click submit.
Afrter the user clicks "Submit" - their name gets stored into my Oracle database, in the field name "Name".
(I'm fluent enough with Perl to get that accomplised - and then I'm able to retrieve the data in the "name" field using Perl.)
10 minutes later I wish to have an HTML form that states something like, "Who's Record Do You Wish To Retrieve? ... then have a "Submit" button. I'll supply them with a drop down box with the list of names from the Oracle DB "Names" field as a good example.
This time the user can select their record (or their name) and it retrieves the PDF with their name already filled in so they can print it.
Via CGI - I'm able to pass the data contained in the "name" field - but how do you call up the PDF file and pass the data to the Adobe "Name" text field?
Again, is it this simple?
Have I confused the heck out you all?