Solved

WordPressFilemaker sync support

Posted on 2014-04-05
9
903 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
  • 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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

 

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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
This article discusses how to create an extensible mechanism for linked drop downs.
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

830 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