Solved

WordPressFilemaker sync support

Posted on 2014-04-05
9
906 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

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 500 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

734 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