Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


dysong3 last won the day on September 23 2014

dysong3 had the most liked content!

Community Reputation

1 Neutral

About dysong3

  • Rank
  • Birthday 02/28/1955

Profile Information

  • Industry
  • Gender
  • Location
    Lausanne, Switzerland

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

4,223 profile views
  1. Yes of course, global fields. Thanks once again.
  2. Thanks once again. With your demo I was able to create a stylesheet that pretty much suits my purposes. Just two more questions. Ideally I'd like to have 4 global records serve as a header is the stylesheet. So that their info only appears once at the beginning of the output file. Is there any way of doing that? And how do you add paragraphs characters, say between the each records block of text?
  3. Thank you for all this precious feedback. Any hints on how to configure an XSLT stylesheet
  4. Hi, I am trying to establish some simple code using a text calculation. The calc I have written goes like this : "[" & #_security_name & "]¶" & "security_name = " & #_security_name & "¶" & "security_type = " & #_security_type & "¶" & "account = " & #_account & "¶" & "sar_timeframe = " & #_sar_timeframe & "¶" & "sar_timeframe_switch = " & "#_sar_timeframe_switch" & ¶ & "sar_periods = {""1m"": ""1D"", ""2m"": ""1D"", ""3m"": ""1D"", ""5m"": ""1D"", ""10m"": ""1D"", ""15m"": ""1D"", ""20m"": ""1D"", ""30m"": ""3D"", ""60m"": ""1D"", ""120m"": ""1D"", ""240m"": ""2D"", ""1D"": ""5D""}" & ¶ & "sar_incremental_step = " & #_sar_incremental_step & ¶ & "sar_max_step = " & #_sar_max_step & ¶ & "ma_timeframe = " & #_ma_timeframe & ¶ & "ma_slow = " = #_ma_slow & ¶ & "ma_fast = " = #_ma_fast & ¶ & "order_size = " & #_order_size & ¶ & "activate = " & #_activate_security_name The result I am getting at present is just "0". However if I just use the first ten lines i get : which is exactly what I want. Would anyone have any idea why the line "ma_slow = " = #_ma_slow & ¶ impedes the calc from functioning properly? Sorry. Just figured it out. Line 10 should read "ma_slow = " & #_ma_slow & ¶ and not "ma_slow = " = #_ma_slow & ¶ My bad
  5. Well I have at least discovered what the problem is. My FM Pro clients and FM Go can connect to the Server from outside my local network, but not from within it. Would anyone know how I can get my router to accept internal communications? And not just external ones.
  6. Filemaker clients can access remote files but FileMaker go cannot. These setups previously worked. What can be blocking fm go?
  7. Thanks for you reply. nslookup gives my correct ip address. So there are no problems there. I did a port scan of localhost a got the results posted below. When you say that is precisely what I want to do. I need to be able to test WebDirect on my own computer so that I know it's working for different users. I have posted below the results I get when I do a port scan for localhost. It seems to me that the necessary ports are open both externally and internally. So why isn't it working?
  8. Furthermore, I did a port scan locally and from outside the local network. What's weird and what I can't figure out is that the ports that are open are not the same. The shorter list of open ports is what's open locally.
  9. I have just been obliged to change my setup to a different internet provider. FMS 16 running on OS 10.13.3. I am not an expert on configuring internet service setups, but having been trying to reproduce what existed on my previous provider. I am now in the strange position where Filemaker client and Webdirect work correctly from computers outside my local network via a DNS address. On the local network Filemaker client only works via the local address on FMS. The DNS address fails to connect. As for Webdirect it also fails to connect on the local network. I can't get my head around what could be impeding the connection locally but not from outside the network. Here's a little summary of what i have tried to implement to get this up and running. I realise that some of the things I have done are superfluous. But as i said I am no expert. I have reserved my DNS address as a "IP address reservation" using the MAC address of the computer on which FMS resides. designated my DNS address as the "Dynamic DNS" turned NAT on used Port Mapping to open TCP and UDP ports including ports 16000, 16001, 5003, 80, 81, 443, 389 designated the local IP of the compute on which FMS resides as "DMZ" turned the firewall off. designated TCP and UDP ports including ports 16000, 16001, 16020, 16020, 5003, 389 as "special application" So would anyone have an idea what I need to do to make Webdirect and Filemaker client work on the local network using my DNS address? And possibly let me know what of the above is superfluous.
  10. Hi, Here is a custom function that I found on Briandunning.com. The problem is when I try to create a new function with this code, Filemaker refuses it saying The "here" above is situated before the parentheses after "WordWrap" and before "UnprocessedText". Would someone be kind enough to tell what I'm missing here to get this up and running? Let ([ TruncatedText = Left ( Text ; Size + 1 ) ; CountOfSpaces = PatternCount ( TruncatedText ; " " ) ; CountOfReturns = PatternCount ( TruncatedText ; "¶" ) ; PositionOfLastSpace = If ( CountOfReturns > 0 ; Position ( TruncatedText ; "¶" ; 1 ; 1 ) ; Position ( TruncatedText ; " " ; 1 ; CountOfSpaces ) ); AddReturn = If ( CountOfReturns > 0 ; "" ; " ¶" ); ThisLine = Trim ( Left ( TruncatedText ; PositionOfLastSpace ) ) ; UnprocessedText = Right ( Text ; Length ( Text ) - PositionOfLastSpace ) ; Result = If ( Length ( Text ) ≤ Size ; Text; ThisLine & AddReturn & WordWrap ( UnprocessedText ; Size ) ) ]; Result ) Sorry everyone. Please dismiss my post. I just realised that I was trying to include "WordWrap" as a function parameter and as the function name. All's well.
  11. Well the web viewer appears to be the culprit. But that doesn't resolve my problem as I would like the script to work and keep the web viewer. Any ideas on how to do that
  12. There you go. There are plenty of others should this not be helpful. filemaker crash log.rtf
  13. Hmm Error capture doesn't seem to offer any help. The scripts still work perfectly well in previous versions of FM. I have backups and the oldest backup I could find, more than a year old, behaves in the same manner. The same scripts make FM15 crash.
  14. Sorry for being a dummy, but how do you access the FM crash log? I've just googled it and found nothing. Of course you're right about copy and paste. It just goes to show how old some of these scripts are, they were made before variables were part of FM and I've never got around to correcting them. That is not the reason for the crashing as I've just corrected it and it still happens.
  • Create New...

Important Information

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