Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Replies

Avatar

18-12-2007

can i have one too i am having loads of problems getting it to work

rdaniels@mass.co.uk

Avatar

08-03-2008

I have a vital form that clients fill out, which is passed to many people in the company along the workflow. The form is a Planner and we have in the following PDF, Word Doc..



Well before, the Planner.pdf was originally created in Word, since most people have access to Word.. but evolved to a PDF form created from the Word Doc via Adobe LiveCycle Designer 8.0 w/ User Rights enabled so that the form could be filled out and saved using Adobe Reader.. which was a step better than Word.. being that it is free. But this needed to be easier and more to the point b/c some clients don't particularly like installing the latest version of Reader, even if you provide them the link. Nor do they like saving the form, filling the form, and attaching the form to send back.



My goal is to have the client fill an HTML version of the form, submit and be done with it, but everyone in the workflow be able to easily receive the filled Planner as a PDF form.



So some months ago I ran into this post Chris Trip, "Populate Livecycle PDF from mySQL database using PHP" #8, 22 Sep 2007 4:37 pm



which uses the command line Win32 pdftk.exe to merge an FDF file into an existing PDF on the remote server, and serve this to whoever.



My problem was with shared hosting and having the ability to use the Win32 pdftk.exe along with PHP which is predominantly used on Linux boxes. And we used a Linux box.



so i created the following unorthodox method, which a client fills the HTML version of the Planner, all field values are INSERTED into a table in MySQL DB, I and all filled planners that have been filled by clients to date can be viewed from a repository page where an XML file is served up of the corresponding client, but someone would have to have Acrobat Professional, to import the form data from the XML file into a blank form.. altoughh this is simple for me.. I have the PHP file already created so that when a Planner is filled and client submits. >> the an email is sent to me with a table row from the repository of the client name, #, email, and a link to d-load the XML file,



But I also have the PHP files created so that the Planner can be sent to by email to various people in the workflow with certain fileds ommitted they they do not need to see, but instead of the XML file beiong served up i need the filled PDF Planner to be served.



I can do this locally with ease on a testing server, but I am currently trying to use another host that uses cross-platform compatibility so i can use PHP and the pdftk.exe to achieve this, as that is why I am having to serve up an XML file b/c we use a Linux server for our website, and cant execute the exe.



Now that I am testing the other server (cross-platform host), just to use them to do the PDF handling (and it's only $5 per month) I am having problems with getting READ, WRITE, EXECUTE permissions..



Si guess a good question to ask is can PHP do the same procedure as the pdftk.exe, and i can eleminate it.



or how in the heck can i get this data from the DB into a blank PDF form, like i have described??



here are some link to reference



Populating a LiveCycle PDF with PHP and MySQL

http://www.andrewheiss.com/Tutorials?page=LiveCycle_PDFs_and_MySQL



HTML form that passed data into a PDF

http://www.mactech.com/articles/mactech/Vol.20/20.11/FillOnlinePDFFormsUsingHTML/index.html

and an example

http://accesspdf.com/html_pdf_form/

________________________________________

Avatar

Avatar
Level 2
_Jenn_Dickens_
Level 2

Likes

0 likes

Total Posts

18 posts

Correct Reply

0 solutions
View profile

Avatar
Level 2
_Jenn_Dickens_
Level 2

Likes

0 likes

Total Posts

18 posts

Correct Reply

0 solutions
View profile
_Jenn_Dickens_
Level 2

28-01-2009

I know this is an old thread, but if anyone has an example they could send I would be eternally grateful. I have my Access DB connected to my form and it fills in beautifully with the information from the database. So I know that it is connected. I have followed all the tutorials I can find on inserting data into a database. When I click the button, I do not get an error but neither do I have the data inserted into my database. I am using Access 2007 and Livecycle ES 8.2. The form information only needs to be appended to a table in my database. The form and the database will always be on the same machine when this happens.



I thought this would be easy...



Oh, yeah... my Email is jdickens@dse.net



Thanx.



Jenn D.

Avatar

Avatar
Level 1
DavisGail
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
DavisGail
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
DavisGail
Level 1

06-05-2009

Lynne,

Could you please send me the sample using an ODBC Data connection to a Microsoft Access database?  I have been searching everywhere for this.

My email address is gmoran@ct.metrocast.net

Thanks,

Gail

Avatar

Avatar
Level 1
sheeda_pahlawan
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
sheeda_pahlawan
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
sheeda_pahlawan
Level 1

11-08-2009

Hi,
I am trying to incorporate a form I built with Access DB, I was wondering if LHigbee would be kind enough to send the DB sample? I will be a great help.
email to ldniit@yahoo.com

Thanks.

Avatar

Avatar
Validate 25
Level 2
mmgiath
Level 2

Likes

6 likes

Total Posts

321 posts

Correct Reply

0 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 2
mmgiath
Level 2

Likes

6 likes

Total Posts

321 posts

Correct Reply

0 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
mmgiath
Level 2

14-10-2009

Hi

Could anyone send me the sample of how to get form data to an MS Access database also?

My email is printshop@baycrest.org

Thanks

Avatar

Avatar
Validate 25
Level 2
mmgiath
Level 2

Likes

6 likes

Total Posts

321 posts

Correct Reply

0 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 2
mmgiath
Level 2

Likes

6 likes

Total Posts

321 posts

Correct Reply

0 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
mmgiath
Level 2

22-10-2009

Hi Stefan,

With a ODBC Microsoft Access setup I try follow your sample(selecting specific Database record) to

make it work for my needs...

I think I am almost there but I think something wrong with the SQL statement for the Main2 connection..

When I pick a department from the drop down list does not populate the required data!

What I am doing wrong?

Please HELP!!!!

Thanks

Avatar

Avatar
Level 1
ArizonaNorseKvi
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
ArizonaNorseKvi
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
ArizonaNorseKvi
Level 1

23-11-2009

If you don't mind, would you send this to jkolsen@u.arizona.edu?  Thanks!

Avatar

Avatar
Validate 1
Level 1
soynv
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
soynv
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
soynv
Level 1

04-03-2010

Could Lynne or someone who has a copy please send me the sample using an ODBC Data Connection to a Microsoft Access database

I have been able to connect to the access file but manipulating the data seems to be a larger problem.  thank you.

soynv@yahoo.com

Avatar

Avatar
Validate 1
Level 2
DubDubDubDesign
Level 2

Likes

3 likes

Total Posts

45 posts

Correct Reply

4 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile

Avatar
Validate 1
Level 2
DubDubDubDesign
Level 2

Likes

3 likes

Total Posts

45 posts

Correct Reply

4 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile
DubDubDubDesign
Level 2

25-03-2010

Hi Lynne

Please could you forward your example for writing to a database to me at gspaull@moog.com

This could help me put an end to a long running project.

Thank you in advance.

Kind Regards

Graham