I have a "time sheet" form that I've created in Livecycle Designer. It's going to interface with software that holds a database in MySQL. My understanding was that LCD doesn't play well, if at all, with MySQL. I wrote a PHP script that converts the entire MySQL database to an XML database.
So on my server I have database.xml.
I have created a data connection to database.xml in the form, so the architecture of the connection is set up. If I open the form in Acrobat Pro, I can manually import data from database.xml, but only from Pro and only if I know where the file is.
Once this is done, I have a drop down menu that these fields are populated into.
So here's the thing, can this form just have a javascript initialize event somewhere that finds the database.xml file, since it's in the same folder, import the values, and populate them where they need to be? Conceptually, it sounds like something that I should, of course, be able to do since it's just duplicating my mouse strokes in Pro, but these security issues and the fact that I want the form to work from Reader, this gets hairy.