Jump to content

Sky Willmott

  • Content Count

  • Joined

  • Last visited

  • Days Won


Sky Willmott last won the day on January 25 2016

Sky Willmott had the most liked content!

Community Reputation

15 Good

About Sky Willmott

  • Rank
    Sky Willmott
  • Birthday 01/28/1975

Profile Information

  • Gender
  • Location
    Elgin, Scotland

Recent Profile Visitors

4,236 profile views
  1. The issue is that that when the exported CSV opens in Excel, it messes up the special characters such as those used in "São Tomé and Principe".... Aha - found a solution 🙂 Just insert the BOM as the first character of the global field content that you are exporting. It can be represented using Char ( 65279 ), so your calculation used to set the first line can be: Char ( 65279 ) & "\"Country\",\"Precipitation\",\"Year\"¶" I just tested in FMP and WebDirect and works great.. The exported CSV opens in Excel with all characters displaying correctly. Revised sampl
  2. It's looking like what we might actually do is abandon the Server side plugin and just use client-side as we know it works ok, and in reality it is only really one person in the Accounts dept that ever needs to trigger the sync to QBO.... Will mean reworking a lot of scripts so that they just do a 'Perform Script...' rather than 'Perform Script on Server...', but that will probably not be too difficult to do.
  3. Yep - it is the 'server edition' version of the plugin along with a demo file they provide that is designed to be hosted on server and use the plugin with PSOS scripts that they have set up for the demo file. I am using it to connect to the QuickBooks Online 'sandbox' company which has a set of data provided in it that is for testing purposes... Using the 'client side' version of the plugin with FMPA works without any issue with the same QBO account and data. The two macOS FileMaker Servers I have tested with are two different machines.... One using Mojave and the other High Sierra... Plu
  4. Hello, Has anybody successfully managed to get v3 of the FM Books Online server side plugin working with FileMaker Server on macOS? I have tried with FileMaker Server 16 and 17, testing with the server side demo file provided and with my sandbox and live QBO accounts. What mostly happens is that I get the FileMaker error of 'The hosts capacity was exceeded', and the FMS logs show FMSE unexpectedly shutting down every time I attempt to use the plugin 'on server' with PSOS... Any tips or suggestions much appreciated.
  5. Have tested using FileMaker Server 16.0.2 on Windows Server 2012 R1 using WebDirect on Safari 10.1.2 (Mac) and it also shows same problem... However, on Chrome 60 on Mac there is no horizontal scroll bar - works as expected.
  6. If you view the image in the container full screen, and then tap it, you will see the 'Share' button at the top right... Hit that and you should see the option to Save Image - which saves it to iOS photos.... And now in Go 15, you can also use the 'Destinations' function when exporting field contents to do the same...
  7. In the Dropbox app, tap on the file and then on the 'share' button... You will see the option to 'Open in...' Tap that, and you will see 'Copy to FileMaker Go'... Tap that and the file will be copied into FileMaker Go and opened... See attached...
  8. It looks like you are using '/' after your database name when it should be a '?' Also param should just =$msg So your URL would be: <a href="FMP://$/MyFMPdatabase?script=isolatesearch&param=$msg"> https://www.filemaker.com/help/14/fmp/en/html/sharing_data.17.6.html
  9. You could use the script step 'Insert from URL...' To download the csv file into a container field and then set a file path variable such as $path to something like: Get(TemporaryPath) & "myfile.csv" Then use script step 'Export field contents' to save the csv in the container field to the $path and from there do the Import Records script step to import the csv data from $path Hope this helps...
  10. Get(NetworkType) only returns the connection type to the file you currently have opened, in which case, when you use it on a local FileMaker Go file, it returns '0', with no indication of whether or not you will be able to connect successfully to a hosted file. If you are already connected to a hosted database and use it then it will return '2' for cellular and '3' for WiFi connection... However, in order to test that the device even has an internet connection before attempting to connect to a hosted file (in order to avoid the lengthy delay whilst Filemaker Go attempts to connect to the hos
  11. Yep, I agree with Kris... Using Insert from URL into a text field works very well... I typically use a very lightweight page to insert, e.g. an html page with nothing but the text "OK" on it... Then use Insert from URL and check that the text field contains the "OK" text, and also check for error code 1631...
  12. One way to have zero dialog printing from FMGo that I have used in the past is to use Insert from URL script step to trigger a php script that ultimately uses Google Cloud Print to print... You can create PDF using FMGo, insert it into a container, base64 encode it, POST using Insert from URL, to your php script which then decodes back to PDF and sends to Google Cloud Print.... There's a brief outline of the method anyway.... Might be worth exploring further for your requirements... Only problem sometimes was a delay at Google Cloud Print queue, but mostly was very fast....
  13. Do you have any unstored calculation fields on the layout you are viewing and trying to sort? This can slow things down a lot... Try creating a new layout based on the table occurrence you want, and then place only the ClientID and Date fields from that table occurrence on the layout and try sorting that... Providing both ClientID and Date fields are not unstored calculations, which I'm guessing they are not, then you should see a big difference....
  14. Hi there, Just thought I'd share something I posted about over at community.filemaker.com in response to a question there... The issue was that FMGo 14 was displaying a very 'jumpy' UI when switching between List view layout and a Form view layout. The list view in particular shows a lot more visual glitches than was ever the case in FMGo 13... What I've found though is that using the new Top and Bottom Navigation layout parts (rather than Head and Footer parts) for both the list view view and the form view layouts that are navigated between, results in a much smoother transition between th
  15. Hi Tim, Yep - that was it.... I just needed to add the container to the form view layout... Thank you for your help. Shmuel... Yes, the php code files should be uploaded to your web server... In a lot of standard hosting packages, this is the public_html folder or equivalent.....
  • Create New...

Important Information

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