Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Auto-Fill PDF form with values from VFP application

Posted on 2010-11-19
7
2,023 Views
Last Modified: 2012-05-10
I have a pre-defined PDF form that has fields. I would like to auto-populate the fields with the data that was entered into a form in an Visual FoxPro application and then print the PDF form. Does anyone have a recommendation on how to do this? If so, do you have any source code examples that you would be willing to share?
Thanks in advance for any help.
 
0
Comment
Question by:Thomas Swaney
  • 3
  • 3
7 Comments
 
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 34180216
I am not familiar with FoxPro. Can you write programs in it comparable to VBA in MS applications? Can you access your FoxPro data from Visual Basic? If so, this is not very complicated, but I need to get an idea about how Dara is accessed first.
0
 
LVL 2

Author Comment

by:Thomas Swaney
ID: 34181105
You can access the data from VB but i would rather use strictly FoxPro. If you can show me how to do it with VB I can figure it out in FoxPro. I am also familiar with VB.
0
 
LVL 44

Accepted Solution

by:
Karl Heinz Kremer earned 250 total points
ID: 34184445
A while ago I wrote a blog post about reading form field values via VBA. Writing is pretty much the same process. Take a look at my blog post at http://khkonsulting.com/2010/09/reading-pdf-form-fields-with-vba/ and the Acrobat IAC programming information at http://www.adobe.com/devnet/acrobat/interapplication_communication.html

If you do not have Acrobat, take a look at the iTextSharp library at http://sourceforge.net/projects/itextsharp/
You can find some information about how to do that with VB here: http://www.codeproject.com/KB/vb/CompleteFormFieldsOfPDFs.aspx
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 2

Author Comment

by:Thomas Swaney
ID: 34193443
Thanks khkremer. This does work as you suggested but the only other issue is that the PDF documents that I have to write to have password protected fields. I will award you the points but do you have any idea how to work around this? I really appreciate it.
0
 
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 34198963
The fields are not password protected, it's the document. If you do have the password, you should be able to use iTextSharp. If you don't have the password, you may be able to use an earlier version of the iText library (4.0.3 and before): http://www.opensubscriber.com/message/itext-questions@lists.sourceforge.net/7709373.html
0
 
LVL 2

Author Closing Comment

by:Thomas Swaney
ID: 34202119
Thanks for you help!!
0
 

Expert Comment

by:jason126
ID: 37337826
can I get the foxpro code cause I am not familiar with VB?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problems with opening files via VBA Shell command 5 323
Need graphics tool to create card game 2 148
Adobe Acrobat DC "Out of Memory" 7 458
acrobat scan error 4 63
Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
*Adobe Acrobat 9 was used for this article.  Particular steps may vary depending on software versions. Adobe Acrobat has many, many variables that my be utilized to customize your forms for clarity and ease of use. The Form Editing Tool will be y…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question