[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

WordPressFilemaker sync support

Posted on 2014-04-05
9
Medium Priority
?
931 Views
Last Modified: 2014-04-11
I need help configuring a plugin WordPressFilemaker Sync built for syncing FM to WP. I own a license and can get the demo to work but not the full version. I also have the WP site and domain working (am using it to host a temporary IWP workaround that is not suitable. http://wordpressfilemaker.com/tour is the plugin built with (but not by hence no support) 360Works scripting tools. The developer is unavailable, and tutorials assume more experience than I have. I am ultimately trying to port a Filemaker summary report to a WordPress site for a client who does not use FM. IWP does not support the report, but I bought this plugin as a solution since I don't know php and cannot build from scratch. The tutorials available demonstrate the capability of the plugin but not configuration. I will attach the license info if useful.

Mark
0
Comment
Question by:MarkJulie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 6

Expert Comment

by:slinkygn
ID: 39980827
When you say the demo worked but the full version failed, how so?  Error message, anything like that?
0
 

Author Comment

by:MarkJulie
ID: 39980834
Demo connects because demo data and config fields are setup for testing. When I try to use the plugin from my nondemo fmdb, it is not configured due to lack of tutorial/instructions and its nonintuitive interface. I know it can work but am stymied at this stage.

Mark
0
 
LVL 6

Expert Comment

by:slinkygn
ID: 39981382
As far as I know there are no config fields to set up with that plugin.  You can put your parameters in fields if you want, but you don't need to; the wp_simplePost() function can take straight strings and work from that.  All that you should need to do is enable API use in WP, and then run the function in a script, giving it the location of your WP site's xmlrpc.php file, your login name and password, post contents and a few other parameters.

So we'll need more detail -- what exactly have you tried so far (contents of scripts you're trying to execute in FM, whether API access is enabled in WP as per the instructions, etc.)?
0
Plesk WordPress Toolkit

Plesk's WordPress Toolkit allows server administrators, resellers and customers to manage their WordPress instances, enabling a variety of development workflows for WordPress admins of all skill levels, from beginners to pros.

See why 2/3 of Plesk servers use it.

 

Author Comment

by:MarkJulie
ID: 39981814
WP api is enabled. Passing this script:

Set Variable [$retID; Value: wp_newPage( "http://www.markjulie.com/avenues_bible/xmlrpc.php" ; "markjulie@mac.com" ; "*****" ; "Another page for PCB" ; "Here is the current tally of PBC campers" ; "For the most accurate details, contact Kathy or Rhonda." ; "publish" ; "" ; "no" ; "" ; "current-camp-tally" ; "" ; "" ; "" ; "" )
Show Custom Dialog ["debug"; $retID]

I am trying to get a summary report of tallied data to display as a page.

What string from FM should be passed to display FM data?

Mark
0
 
LVL 6

Expert Comment

by:slinkygn
ID: 39983956
Looks like your function name is in error, and the parameters are out of order, according to the documentation.

wp_newPage() should be wp_newPost()

Additionally, your parameter list of:

( "http://www.markjulie.com/avenues_bible/xmlrpc.php" ; "markjulie@mac.com" ; "*****" ; "Another page for PCB" ; "Here is the current tally of PBC campers" ; "For the most accurate details, contact Kathy or Rhonda." ; "publish" ; "" ; "no" ; "" ; "current-camp-tally" ; "" ; "" ; "" ; "" )

should probably be:

( "http://www.markjulie.com/avenues_bible/xmlrpc.php" ; "markjulie@mac.com" ; "*****" ; "Another page for PCB" ; "Here is the current tally of PBC campers" ; "For the most accurate details, contact Kathy or Rhonda."; "" ; "publish" ; ""; "" ; "no" ; "" ; "current-camp-tally" ; "" ; "" ; "" )

Finally, you then display your $retID as the debug info, but it may be more useful to do as the documentation recommends and display wpx_LastError instead -- this code is based directly off the documentation's recommended code:
If [ LeftWords ( $retID; 1 ) = "ERROR" ] 
Show Custom Dialog [ Message: $result & “ “ & wpx_LastError; Buttons: “OK” ] 
Exit Script [ ]
End If

Open in new window

The full documentation for the plugin is in the "Documentation" link at the bottom of the plugin's home page:
http://wordpressfilemaker.com/wp-content/uploads/2010/11/Documentation.pdf

It has the details on how your function should be structured.
0
 

Author Comment

by:MarkJulie
ID: 39984325
Thanks. Your syntax fixed the posting issue. Is there a way to post the contents of a summary report to the WP post? I.e., will FM data have to be exported as a pdf, or is there a method to pass the results of a script to xmlrpc.php? The data is by name, gender, and class grouped by class then gender with a count per gender per class.
0
 
LVL 6

Expert Comment

by:slinkygn
ID: 39984370
Out of that sample syntax, items 4, 5 and 6 are the post title, teaser content and "read more" content, respectively.  You can change any of those strings to be whatever works out to a valid string in the FM calculation engine.

So, for example, where you have in the function:
"For the most accurate details, contact Kathy or Rhonda."

You could instead have:
"The totals for the week of " & myTable::thisWeek & " are: " & $data

Where myTable::thisWeek is a field in that table's current record and $data is a local variable containing more text data, where you've aggregated totals.  Or anything like that.  You can have FileMaker functions in there, or whatever data source you need, or anything else you may want to construct -- as long as the end result is a string.
0
 

Author Comment

by:MarkJulie
ID: 39984406
Is it possible to have $data update dynamically on the WordPress side as aggregate totals change, or is this solution only as current as my last run of the script on my desktop?

Is there any server side cron configuration possible if this is hosted on FMSA?
0
 
LVL 6

Accepted Solution

by:
slinkygn earned 2000 total points
ID: 39984424
"update dynamically on the Wordpress side" -- there's no way for Wordpress to do that; as far as I know WP treats its content as static.  If you wanted to do what you're describing, you'd have to save the post ID when you originally create a post and then use that to fire a scheduled script that uses wp_editPost() to push changes from the FileMaker side.

Yes, FMSA can handle cron-like scheduled running of FM scripts.  Those would be configured through the FM Server Admin Console.
0

Featured Post

Plesk WordPress Toolkit

Plesk's WordPress Toolkit allows server administrators, resellers and customers to manage their WordPress instances, enabling a variety of development workflows for WordPress admins of all skill levels, from beginners to pros.

See why 2/3 of Plesk servers use it.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Suggested Courses

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question