Populate form fields from database.

Mike_Buglioli_(mikebuglioli_-_(deleted))

Is there a way to populate PDF form fields from a database, other than the database the form is already associated with?

Find more posts tagged with

Comments

Application_Services_FUJITSU_(fuji_ware05_-_(delet

Unfortunately, as far as we know this is not possible. In fact it's Acrobat that should be able to access the APIs of Livelink. This is (currently) not the case. Let's hope it will become possible. Would be very niceMore Information:mailto:jraedemaeker@switch.beswITch AsBuilt

Mareka_Ducharme_(MDucharme_(Delete)_1433588)

Not exactly sure what you are want, but as a work around and something that I've done is just create a view (link to the other database) in the Livelink tablespace and you should be able to access your information like you would if the data was in Livelink tablespace.

Mike_Buglioli_(mikebuglioli_-_(deleted))

We are wanting to populate fields on a form with information from a database based on an option chosen in a combo box on the same form.

Jose_Garcia

When you say that you would be able to access data like it was in Livelink tablespace does this mean that it can be accessed by the Livelink Search module as well?

Mareka_Ducharme_(MDucharme_(Delete)_1433588)

Not sure about that one.

Development_Base4_(Base4User10_(Delete)_2261135)

We have been able to access another Oracle database using the DBLink facility. Now you can access the other tables using OSCript functions and you can populate your form.The other databases are NOT indexed but if you save your form as a document (or new object type) then that will be indexed as usual.

Lavinia_Edmed_(DatumUser2_(Delete)_2053706)

Hi Micheal,The population of dropdown lists from a database, using Adobe Forms and the update of other fields in the form based upon the selection made by the user are perfectly possible. I should know because I have implemented it. You will need the Livelink Builder, to create a custom module and then use PATCHFDF and RELOAD orphans per form template. You will need to customise the objects to connect to the database(Oracle/SQLServer/Sybase), query the data (select A,B,C from X where A=Y), prepare the information for transfer to the form and pass the information to your form. There are a few other pitfalls to watch out for but I can fill you in if you still interested ...Lavinia (lavinia.edmed@datumc.com)

Liz_Connors_(sunvalleyfoodadmin_-_(deleted))

We've done a similar thing using ASP, where a button on the form submits the form to a script (ASP) on the server and then the returned page is the content data, quick and easy, but not within the Livelink scheme, so will require seperate support.