Adobe LiveCycle (Archived)

Nanywaka · 8/27/10

Dear All,

I am designing a leave application form for my company to be posted on our Electronic Document Management System(EDMS) for staff to fill and process using workflow for approval. I need to have some of the fields of the form to be autmatically populated from data held in an Access 2007 or SQL 2005 database.

I have not found good guidance on how to accomplishe this.

The situation

The staff information kept in the database is:

Field	Remarks
Staff ID	Unique identifier
First Name	Normal text
LastName	Normal text
Department	Normal text
Section	Normal text

When the staff member downloads the form they should click on a button to enter the Staff ID and the form gets populated with the rest of the fields.

I need assistence on how this can be done with minimum scripting.

Darlington Nanywaka Sakwa

Report · 8/30/10

Can it be done ....yes. Are your users using Acrobat or Reader as their PDF viewer? If it is Reader then you will have to Reader Extend the form to allow this to happen (this data connectivity is not part of standard Reader). Also you will have to create a DSN on the users machine to make the connection between the OS and the database. Then you will have to write code to extract the specific record that you want. There are samples that show how to do this ....but without dealing with the 1st two things you are not going to get anywhere.

Paul

Nanywaka · 8/30/10

Dear Paul,

Thank you for your help.

The users will use Acrobat because they will also be able to append signature to their forms. I did find a sample which was based on LiveCycle 7.00 but it did not work and I could not find anything wrong when I tried debugging.

Can you provide me with links to some other samples if you have any? I will highly appreciate.

Regards

D N Sakwa