3 replies to this topic

[davidcornett]

Hi,

I have a dynamic fill-in XFA form created in Adobe LiveCycle. A lot of the fields we already have the answers to so we'd like to be able to automatically pre-fill the PDF before sending it to a client. All of our data is stored in a SQL database.

What programming steps and languages would be necessary to query a name, and have matching data returned from the SQL database and able to fill in the PDF? I've successfully pre-filled the form using an XML file with the fields named correctly, so I assume one solution is to automatically generate the XML doc from the database, and then using Acrobat we can import the data in 1 step. Any idea how to go about doing the XML generation/transfer?
Would a certain programming language like C# help with this whole process?

I'm very new to programming, so I'd appreciate a kick in the right direction. Thanks!

[Orjan]

It's absolutely an solution with a XML file. It can be done using just about any language, but if you are in a windows environment, C# might be a good choice, as you can create a small windows application which allows you to search the customer in the database and get the file in a nice and tidy way.

This shows the making of a XML file in C# from microsoft's help: http://msdn.microsof...y/bb387089.aspx

[davidcornett]

It's absolutely an solution with a XML file. It can be done using just about any language, but if you are in a windows environment, C# might be a good choice, as you can create a small windows application which allows you to search the customer in the database and get the file in a nice and tidy way.

This shows the making of a XML file in C# from microsoft's help: http://msdn.microsof...y/bb387089.aspx

Thanks for the reply Orjan. Are there any clear advantages using C# rather than SQL SSIS to create jobs?

[Orjan]

Probably that you can make a neater application for generating your XML than SSIS might be. If you already use SSIS and it can make it for you, stick to it, I'd say.