We updated the server the past two days, you should see some speed performance of our site.

Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


sal88 last won the day on December 21 2017

sal88 had the most liked content!

Community Reputation

2 Neutral

About sal88

  • Rank

Profile Information

  • Gender
  • Location
    United Kingdom

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
  1. Always Verify backup integrity?

    Thanks Fitch! Very happy to hear that!
  2. Hi all I have three backup schedules: hourly, daily and weekly. To reduce any lag experienced by end users during the day I am wondering if I should do away with the verification step for the hourly one, which would speed up the backup. I would keep it on the other two and would be emailed by FMS if there were an issue. But if there were a crash and I wanted to restore from the hourly one, how do I know the data integrity is OK? Obviously if there were an issue I would use the older daily one, but that is a risk I'd be willing to take if it sped things up. Thanks
  3. Execute SQL - Insert and Select

    Hi bcooney I don't suppose you could clarify what the difference is between ESS and what I am doing here? This looks promising in terms of doing INSERT from SELECT: https://www.soliantconsulting.com/blog/executesql-filemaker However I have a few hurdles before I get to that point. Here is what I have done so far: I have my ODBC source set on the server which hosts our filemaker solution. On my local machine I have to locally add the ODBC source in order to use the "Execute SQL" script step. It does not see the ODBC source that I have set up on the server. I also cannot add the local ODBC source to 'external data sources'. Now I can create a new record in the external SQL source using "Execute SQL" (and the locally added ODBC source) however it takes a very long time for the new record to appear. I am viewing the record from a layout that is based on the server's ODBC connection (not my local ODBC connection). The new record definitely gets created however as if I try to perform the same operation with the same ID it complains that the ID is already in use. Also if I connect to the ODBC source from MS Access then I see the record straight away. The idea is that a script will run on the server every hour that will delete the records in the external SQL table and then populate it with records from the FileMaker database. Will this be possible given that I can only select my locally added ODBC source in the "Execute SQL" script step. If someone could point me in the right direction that would be great! Many thanks
  4. Brilliant! that works. thank you very much Olger!
  5. Hi all My scheduled server scripts call up my onwindowopen startup script, which is great. I specify that the startup script exits if it is being run from the server. The actual scheduled script then runs fine. However I don't want any of my scheduled scripts to run if the plugins are not enabled on the server. I thought I could achieve this by utilising the 'halt' script step on the startup script in the event that the plugins were found not to be enabled. While it does halt the startup script, it does not also halt the script that called it up (the scheduled script). I'm guessing though that this is because the scheduled script has not actually 'called' the startup script. Should it work the way I expected? Or is there a way to disable the running of scheduled scripts without having to specify in each individual one that they should not run if there is no plugin. MT
  6. Execute SQL - Insert and Select

    I'm still stuck on this - I can't work out if ESS is even meant for my purposes. Any help whatsoever would be much appreciated. Many thanks
  7. Hi all I'm trying to export my filemaker records to my external sql database via the execute sql script step but am getting a number of errors. I can see my external ODBC source and can generally write to it (I can go to the respective layout and click 'new record'). My query basically as follows: "INSERT INTO dbo.Log ( dbo.Log.log_id, dbo.Log.log_case_idf, dbo.Log.Labour_TOTALS_Labour_Cost, dbo.Log.Labour_TOTALS_Item_Sale) SELECT Log_Log.log_id, Log_Log.log_case_idf, Log_Log.Labour_TOTALS_Labour_Cost, Log_Log.Labour_TOTALS_Item_Sale, FROM Log WHERE Log_Log.Log_Type = '2'" My first question is: is it even possible to export to an odbc source with a 'insert INTO SELECT' query? Many thanks
  8. Can't see DSN

    No i just ticked the Enable ODBC/JDBC checkbox on the server. I tried to add the DSN from my client machine. The DSN is on my local machine.....Aaaaand I've just set up the DSN on the server instead and I can now see it! I take it this is the correct and only way for it to work for a hosted database?
  9. Can't see DSN

    I can see the DSNs in a newly created local blank database. However when i upload this to our server the DSNs no longer appear. I've enabled ODBC in filemaker server but no joy.
  10. Can't see DSN

    I'm still nowhere further on this. Is there a (very simple) guide somewhere for setting up ODBC? Thanks
  11. Can't see DSN

    My FileMaker client is 64-bit. So i deleted the ODBC 32-bit DSN and added it to the 64-bit version instead. But it is still not showing in the external data source list.
  12. Can't see DSN

    Hi all I'm trying to connect to an Azure SQL database from FileMaker 16. I've added the DSN via ODBC 32bit (see pic). However, when I go to File>Manage>External Data Sources, it doesn't show the DSN. Where am I going wrong? Thanks in advance
  13. Thanks Fitch, I'll give it a go. Loving the importing option though so might just go for that!
  14. Would they be able to have full access to data in the host file but limited in the reports file? To clarify: Main database - users have full access to data (restricted only by layout features) but cannot edit scripts/layouts/database Reports database - full access to design privileges, and access to data in main database but on a read only basis I've tried to define the privileges in the host file but it doesn't appear to work, i'm guessing there's a conflict in defining privileges in the host file for files that reference it but NOT for users that are accessing the host file directly (in the usual manner). Using external authentication might be complicating things also, perhaps when I am linking to the host file from the reports file it doesn't ask for authentication? Is native filemaker authentication better for this type of thing? Thanks
  15. Hi all Users are more frequently than ever requesting that custom reports be made. Up till now this has involved me creating layouts and scripts that can produce the data/reports in the form they want. I'm wondering if now it might be possible to let them take control of reporting in a way that is separate from the current database (which is heavy on GUI and disabling of features for ordinary users). I'm thinking of creating a totally new database which users would be able to completely edit from a design perspective, which would point to the main database as an external data source. However I would like it so that they would NOT be able to edit/create/delete those external records. I've had a play with it and can't seem to get it to work (we're using external authentication via windows server active directory). Is such a thing possible? Many thanks

Important Information

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