Hi Jang, I have not done this with ExtendScript. I am sure you already know this, but for the record, you can use FrameScript to connect to ODBC databases.
With ExtendScript, you could use XML as an intermediary format between the database and ExtendScript.
Thanks Rick, but FrameScript is not an option here. And using XML does not solve the problem, as I would need to fire some script from elsewhere to do the pushing and pulling of data. I currently write a series of SQL queries into a text file and have the customer execute the textfile from a PHP script running on their web server. For a localization project I would want to pull little bits of info out of the SQL database on the fly, i.e. using an ExtendScript that might then become event-triggered. The format to exchange info is not changing the need for an active link.
Hi Jang, I know Russ Ward has some sample code using the socket object. I am sure he will give you some advice. Rick
Only if he still likes me .
Hey Russ, what's up? You've been quiet on the forum lately.
In the meantime I have found some info about the best way to go forward. As the MySQL database will run on the same server that publishes the web help and security issues normally prohibit direct access to that database, I will create some PHP to execute the queries I send to the socket. Should not be too complex, I hope.
I am curious about whether you have made any additional progress on FrameMaker database connectivity via Extendscript. I'm attempting to replace/augment an existing FrameScript with an Extendscript implementation, so I'm seeking a similar solution.
no reply from everJang so far?
Read online there's ways to make HTTP calls from ExtendScript via Bridgetalk. So while not specific to FrameMaker, this might be a way to go that I think is generic across Adobe apps:
and the asynchronous version:
one would then just need to tailor the code to fit the specific web service or PHP web page/script to call that does the DB stuff.
Sorry, I did not see there were replies to this forum. I was getting too much mail from all kinds of forums so I shut down some of the notification mailers.
I don't think your solution is lo-tech Jang, just one of several different architectural solutions.
check out the library porky.io, it lets you handle all those mysql and json/xml requirements