Wim Decorte

  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by Wim Decorte

  1. The free BaseElements plugin has all the HTTP POST and GET functionality that you will need.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. As per Mike: do you have the OSX Server app installed? If not, anything else running on port 80?
  7. 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?
  8. 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?
  9. 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
  10. 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.
  11. 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.
  12. 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)
  13. 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...
  14. 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.
  15. 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,...
  16. 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.
  17. What is reported when you run a recovery on a copy of a backup? Any errors? Does the record count show up normally? with "new rule" you mean a new schedule in FMS? What else is running on that FMS server? Usually these kinds of issues come interference with other processes like 3rd party backups, dropbox, OS level file sharing,... Not to sound pedantic: this is precisely why you should not assume that the backups are fine; you have to proactively check them once in a while so that you can solve these kinds of issues without a gun to your head.
  18. Not sure what you mean; just tried this in both FM15 and 14 and neither works. What's the header? Part of the FM app or part of the layout? You can always get the file path in the data viewer by using the Get(FilePath) function.
  19. Is there a minimum assignment to the machine? I don't think I would be happy with a pooled setup for a database server (of any kind).
  20. Authorization is always set at the db level; not sure what specifically you have in mind? One way to solve the database visibility: set all files to be not visible in their sharing properties. Then give users a launcher file that opens the main file they work in.
  21. Sounds like you did not configure DB2 for external authentication like you have DB1. If DB1 uses any kind of data from DB2 then it must allow authentication for the same user. Note that authentication is not the same as authorization. With authentication you're just establishing WHO someone is. With authorization you establish WHAT they can do in your database. You absolutely must authorize the user to DB2 but you can control what they can see and do. When you say "I don't want them to see DB2", do you mean in the "open remote" dialog? That's easily fixed and has nothing to do with authorization or authentication. Just set the file up to be not visible.
  22. Works like a charm in 15... I think something off in your data? I just copied and pasted your calc after creating the data.
  23. Here's a very simple approach that uses AWS S3. Very cheap and very easy to implement and comes with an enormous feature-set on the backend to do things like retention policies through lifecycle settings. The example uses Windows but once you install the AWS CLI (http://docs.aws.amazon.com/cli/latest/userguide/installing.html) then the command is pretty much the same: http://www.soliantconsulting.com/blog/2016/06/backups-to-the-cloud-with-aws I use a variation of this to not upload everything but to sync to a folder in my S3 bucket and then instruct S3 to copy the sync'd folder to a date/time stamped new folder on S3. That way I still have my full sets (as many as I want) but with uploading just the files that were changed. Almost like progressive backups to the cloud...
  24. ESS is not possible with 11 and PostgreSQL. ESS support for PostgreSQL and DB2 was introduced with 15. For 11 you have to stick with the backends that were supported at the time (MySQL, SQL Server and Oracle - but mind the versions of those and the drivers that are needed, if you have more recent versions of any of these it may not work).
  25. Most likely the permissions on the files were changed so that the FMS account (fmserver of group fmsadmin) no longer owns them. Use the chown and chmod command lines to set it correctly. You can use the free BatchMod application if you don't like using Terminal.