Wim Decorte

  • Content count

  • Joined

  • Last visited

  • Days Won


Wim Decorte last won the day on January 4

Wim Decorte had the most liked content!

Community Reputation

396 Excellent


About Wim Decorte

  • Rank
  • Birthday 12/17/1968

Profile Information

  • Gender
  • Location

Contact Methods

  • Website URL

FIleMaker Profile

  • FM Application
    15 Advanced
  • Platform
    Cross Platform
  • Skill Level
  • Certification
  • Membership
    FileMaker Business Alliance
    FIleMaker Platinum Member
  • Title
    Sr. Technical Architect
  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. As per Mike: do you have the OSX Server app installed? If not, anything else running on port 80?
  6. 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?
  7. 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?
  8. 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
  9. 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.
  10. 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.
  11. 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)
  12. 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...
  13. 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.
  14. http://www.filemaker.com/products/filemaker-server/webdirect.html PHP and Ruby are both server-side scripting languages so you typically wouldn't pick both. FM has a native PHP API and also has an XML API that can be used in other web scripting languages. In fact, many 'connectors' have been developed over the years like fmDotNet for .NET, Rfm for Ruby, pyMaker for Python,...
  15. Amen. As a developer you pick the platform that you want to use to build solutions. Unless the client has already invested heavily in a particular technology and has a rigid policy of only allowing their approved technology stack. When we chose FM we knew that we chose a: - premium platform (it's never been cheap so it is not realistic to expect that it will ever be). It promises quick-to-market features and they charge for that. - a proprietary platform: the skill set is fairly unique and not easily portable to other environments, nor is the code. I have no problem with either of those because it is a decision I re-make almost every day. And I've always played / dabbled / used other technologies just because of this: *I* am responsible for my business and for my livelihood, not FM. All the eggs in one basket and all that. Over the holiday break I was brushing up on my C# skills and playing with the new .NET Core and Visual Studio for Mac, writing a small cross-platform application (iOS and Android) that uses a FM backend. A couple of thoughts: - most of what you need is free, up to and including using visualstudio.com for version control and agile project management - none of this is proprietary - but holy crap you have to spend a lot of time on the learning curve. Writing something for one platform is bad enough but for two or three? This is exactly why FM is a premium platform. You have to invest in something: either in the time and aggravation to get through the long learning curve and not pay for much licensing, or pay for the licensing and enjoy the short learning curve. And in the end it is all about value: is the time + money you need to spend on a problem worth the solution to the problem? Our biggest asset is not our chosen technology but our own skills; the ability to relate to a customer, understand what they are after and being able to dissect it and come up with a solution. It's not the car that gets you from A to B, it's the fact that you can drive the car.