Wim Decorte

Moderators
  • Content count

    5,037
  • Joined

  • Last visited

  • Days Won

    116

Wim Decorte last won the day on January 4

Wim Decorte had the most liked content!

Community Reputation

396 Excellent

4 Followers

About Wim Decorte

  • Rank
    member
  • Birthday 12/17/1968

Profile Information

  • Gender
    Male
  • Location
    Toronto

Contact Methods

  • Website URL
    www.soliantconsulting.com

FIleMaker Profile

  • FM Application
    15 Advanced
  • Platform
    Cross Platform
  • Skill Level
    Expert
  • Certification
    7
    8
    9
    10
    11
    12
    13
    14
    15
  • Membership
    TechNet
    FileMaker Business Alliance
    FIleMaker Platinum Member
  • Title
    Sr. Technical Architect
  1. Do you need both servers to be available from outside the network?
  2. The free BaseElements plugin has all the HTTP POST and GET functionality that you will need.
  3. You can define a SQL query in the FM import script step to isolate the record(s) you want: http://www.filemaker.com/help/13/fmp/en/html/odbc_ess.20.13.html If that is not easy to do from the FM side then you may need to push the data from Access to FM through FM's ODBC interface.
  4. That is the right way to do it if you want to pull from FM. Does the import work at all? If not what is the error message? This I do not understand. "Everytime" -> are you saying that you do the import manually and want to automate it? If so you need to build a script that does the import for you. "I try to use relationship table" --> that doesn't make sense based on what you have already described. Are you trying to use the FM ESS feature (instead of the Import feature)? If you are trying to use ESS then it will not work. Access is not a supported ESS data source.
  5. You can do it from inside FM and pull, or from inside Access and push. Both platforms support ODBC so it depends on where you are most comfortable doing it from.
  6. Their documentation looks fairly clear, to send an SMS, you have to use the URL described here: https://api.chikka.com/docs/handling-messages#send-sms and after sending an SMS they will also send you an HTTP POST notification for which you need to have a 'listener' URL, the notification URL, basically your own web service that can receive those HTTP POSTs from them.
  7. As per Mike: do you have the OSX Server app installed? If not, anything else running on port 80?
  8. What was changed on the server? FMS patch? OS patch? What is the account used, an AD account? Local OS account? Is FMS set up to run as local system or with a customized account?
  9. Can you get to the web server, not any FMS part of it, just the name or IP address of the web server? What does the FMS admin console report? What does the FMS event log report after an FMS restart?
  10. Start with the FTS Advanced book & exercises to get you up to speed on the new features. Get certified. http://www.filemaker.com/learning/training/fts.html
  11. Do you mean MirrorSync (http://360works.com/filemaker-sync/) or did you mean just "mirror / sync" the data? If the latter you wouldn't need a plugin. Wordpress uses mysql normally and you can use ESS to work with the mysql data directly. If you don't want to use ESS and really want to duplicate the data into FM tables then you'll have to it by means of a ODBC DSN or JDBC connection from the client, not from the FM Cloud machine.
  12. Since you control the 'web service' that you are talking to, I would suggest that you construct a json format of the data that you need to send, with arrays for the multiple elements. And then just POST the json. You can then have your web service work with that json. Make your web service either a RESTful web service that can consume json or a SOAP one that expects XML. No need to export anything from FM, just construct the json (or XML if you want) in the script based on the data.
  13. A couple of ways: - an easy - but unintuitive - FM way is to export an empty field to the same file name; FM will delete the target file - or use Send Event and use the OS CLI to delete the file - (if you are already using a plugin with file manipulation functions, then it can be done that way too)
  14. You could use one of the free plugins that support SQL if you really want to use SQL... Why rebuild in 11 though? Can't help but feel that is such a waste of effort not going to the most recent version...
  15. Sure, that's what it is there for. But a couple of things to keep in mind: - @rwoods is spot on: the solution has to be designed with WebDirect in mind, which is different than designing for use with the normal FMP client. There are things that don't work and things that work differently - at heart it is a big trade-off between ease-of-development and scalability/performance/functionality. See the WebDirect hardware requirements, they are not trivial. - mind the licensing: the model does not lend itself very well to web applications that have a lot of anonymous users If you are planning to have no FMP or FM Go clients, you probably should seriously consider another platform.