Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


_ian last won the day on October 6 2016

_ian had the most liked content!

Community Reputation

4 Neutral

About _ian

  • Rank

Profile Information

  • Title
    Software Architect
  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. One of our IT guys has had a look at the snap-shot of the VM from last night and has found that there is an alias pointing to a directory in the 360Works folder, so he's re-enabled IIS and is putting it back the way it was. Interesting that the important bits, the synch process just kept on going with no problems.
  2. Hi We're doing a one-way sync from our FM Server to a SQL Server instance. MirrorSync is installed on the SQL Server instance which is configured as the spoke. This has been running for several years now with no problems. Do we need to run IIS on the SQL Server box? IT is on a mission to disable/remove all unnecessary services from our server VMs and have asked me whether IIS is required here. I somewhat rashly said "I don't think so" and they've disabled IIS. I'm not seeing any error messages in the MirrorSync logs and data is synchronising with no problems. However my MirrorSyncConfigClient.jnlp client doesn't seem to be responding. So is this dependent upon IIS? I suspect it is, but everything else is working as expected... thanks
  3. Hi I've come up with a solution for a problem I had last week and wanted to post it here in case it helps anyone else. We had a strange thing with our MirrorSync server last week - the internal database got out of sync with the FileMaker Server (Hub) and the SQL Server (Spoke), so it kept trying to add Suppliers that had already been added to SQL Server and returning error messages for each one. The suppliers had been added to the SQL Server spoke, but MirrorSync kept trying to add them again. I checked and we had no duplicate keys in the FileMaker database so that wasn't the problem. My solution was to switch off the SQL server error reporting for duplicate keys on the table in question executed this on the SQL SERVER: ALTER TABLE [Suppliers] REBUILD WITH (IGNORE_DUP_KEY = ON) run a sync - the redundant additions failed silently and MirrorSync updated it's internal database to record the addition. then back to the SQL Server to run ALTER TABLE [Suppliers] REBUILD WITH (IGNORE_DUP_KEY = OFF) Run a sync again and everything's happy now.
  4. Given what you want to do, you might consider looking at MirrorSync by 360Works. It's a synchronisation production that allows you to sync record creation, deletions, updates between two databases. In your scenario you could configure it to sync record changes from the MySQL tables into your FileMaker system. We use it to read from our FileMaker system into a data warehouse in SQL Server.
  5. I'm using Let(_path = Substitute(Get(DocumentsPath);"/";"\\") & "Manifest_Detail_Imports\\"; Right(_path;Length(_path)-1) ) then BE_ListFilesInFolder ( $_import_directory;"csv" ) to list the contents of the directory to read the contents of \Documents\Manifest_Detail_Imports on my server doing it server-side is massively faster and less troublesome than using a client to run imports.
  6. Thanks Jesse. That sounds like it will sort that issue very nicely. No need to post that version. I'm off to Berlin for dotFMP at silly o'clock tomorrow morning and have a load of other stuff queued up for when i'm back. I'll just download and install when you do the next release. I've deleted all the old log files, so not in a massive rush.
  7. I agree with Brent, we've been running WebDirect for about a year now and it's been absolutely rock solid. Slow, but rock solid. If it was my files sitting on a server that was being restarted every day, I'd be asking some questions of the hosting company.
  8. and... while I'm on the topic of features... I've just investigated last nights sync failure. I'm pretty sure it's down to running out of disk space. A way to restrict the maximum size of the log files would be nice. Or what might be simpler is - provide a sync warning (maybe hourly) when disk space is getting low. Do you prefer receiving feature requests directly via email or through this forum? thanks
  9. ​Hi Jesse It happened again this morning. Here's a screen-shot. While I'm at it. Another feature suggestion: perhaps the ability to set a user defined limit on the number of error emails? I had a sync problem at around 0457 this morning. By the time I got into the office I found close to 100 emails letting me know there was a problem. If i could limit it, it would still cover the situation of a temporary glitch which resolves itself (e.g. the error message if someone is deleting while the sync happens) but also let me know when it's a more major issue. (e.g. this mornings "Last sync failed: java.sql.SQLException: Connections could not be acquired from the underlying database!". thanks ian
  10. ​I'll send you an example the next time this happens.
  11. Hi guys Synch is running beautifully, really fast. We're able to sync every 120 seconds, so our Financial Data Warehouse is effectively real-time. Now it's been running a while I do have one suggestion that I would find helpful. When I have data type conversion errors - typically converting string to decimal - it would be really useful if the error message on the MirrorSync app window would tell me which table and primary key. As it stands when these errors happen I know that there's a data type issue, but need to dig through the log files to find which table and record. I'm tightening up data types throughout the system, but it's not a common problem. Once every few weeks is typical. I suppose the other alternative would be for me to write an import format so Logstash and Kibana can deal with it. Then i'd could just take advantage of all that ElasticSearch goodness. But i don't really have the time...
  12. Integration with Dropbox is definitely possible using their APIs. I've done it using ScriptMaster, but am not at liberty to share the code. GoogleDrive would also be possible, though i've not done it.
  13. I've not tried Selenium with a ScriptMaster function so I don't have enough experience to form an opinion. By coincidence I was doing a fair bit with PhantomJS last week, though with PHP not FileMaker.
  14. I'm curious why you're using Selenium here? If you use the PhantomJS sample script Rasterize.js then you can call PhantomJS from the shell and it will work nicely. I've just tested with the shell script example in ScriptMaster and it works correctly. At least on OS X - don't see why there'd be a problem on windows though.
  15. well, Steven and Wim have already explained, but here goes... The built in FileMaker security system is the most secure way to control who gets access to data within a FileMaker database. Home made security systems sit on top of that layer and are predicated on the user having access to certain data that will control what they can see. They usually rely on scripting and trying to prevent access by not displaying layouts -two approaches that are doomed to fail. They're almost always vulnerable to an attacker altering the data the controls what is visible. Over the years I've been asked to look at several of these systems and they were all vulnerable. In most cases a few minutes with data viewer and the design functions gives you everything you need to bypass the system.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.