External database (pulling data from there)

Hi Jesus,

I don't think this can be done in the List Options: Get options from MySQL (advanced) text box as you are just entering the MySQL query for the CMS Builder database.

You may be able to enter PHP (with the mySQL connect details, etc) in the List Options: Use options listed below text box but this isn't what it was intended for so would at the very least require some trial and error to test it. Also you would need to make sure the output was when record per line.

Hi Damon, thanks for your answer.

Do you have something like this previously done?

Any reference you you have might help me a bit to see if this could be something I can work with.

Thanks!

Hi,

This isn't something I have done before but this post has some example code to connect to your server:
http://interactivetools.com/forum/forum-posts.php?postNum=2190548#post2190548

You would need to modify the mysql_query to get the values you need.

Set this up as just a php file outside of CMS Builder to first see if you can return the results you are after, one per line.

Then you can test adding that into the list options. Never done this before so not sure how it will work out but worth trying to see.

Thanks Damon,

Just wondering... Is there an API or are you planning to have an API so we can comunicate from other systems into CMSB?

Thanks!

Hi Jesus,

We can build APIs. It is a custom job each time for the specific requirements needed. 

Contact Ross at consulting@interactivetools.com to further discuss requirements and other project details.

Thanks!

Hi Jesus, 

You could think of MySQL as the API.  The first step could be to come up with some custom stand-alone PHP code to load the values from the remote database.  Once you had that you could: 

• Run your new script on a cron and have it update a CMSB database table once a minute/hour/day, and then load the values from there with CMSB
• Figure out how to run your custom PHP code from inside the "list fields options" text box in the field editor.  We added a new feature for this in 3.03: Editors: List field options specified as text can now contain PHP code

Hope that helps!