Jump to content

dysong3

Members
  • Content Count

    181
  • Joined

  • Last visited

  • Days Won

    1

dysong3 last won the day on September 23 2014

dysong3 had the most liked content!

Community Reputation

1 Neutral

About dysong3

  • Rank
    member
  • Birthday 02/28/1955

Profile Information

  • Industry
    theatre
  • Gender
    Male
  • Location
    Lausanne, Switzerland

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    10.12.4

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

4,347 profile views
  1. Yes, I do want to remove all leading and trailing punctuation from the input. Thanks for the idea of using script triggers. However after a little toying, the only script I can get to work with that method is the Let function. TextFormatRemove() apparently is not available under script calculations. And I can't seem to get the Substitute one to work, but I can't fathom why. If I can just get the Substitute to work as a script calculation or concatenate it with the TextFormatRemove. I'will have got to where I want to be.
  2. TextFormatRemove is to remove any formatting in the field. The "Let" function is to make sure that the last word of an address does not appear as an orphan at the beginning of a new line, whatever the context. And the Substitute function is to correct any of the following suite of characters to make them conform to my specific needs for address formatting. Ideally I would like to subject any entry into this address field to the whole three of these calculations. I hope that's clear
  3. Hi, I have 3 calculations that I would ideally like to concatenate into one, but can't work out how to do it. How can it be done? TextFormatRemove ( MiddleWords ( Self ; 1 ; Length ( Self ) ) ) Substitute(Home_Address_1 ; ["ch. "; "chemin "] ; [" "; " "] ; ["-Au-"; "-au-"] ; ["Ch. "; "chemin "] ; ["ch. "; "chemin "] ; ["Chateau"; "Château"] ; ["chateau"; "Château"] ; ["Ch "; "chemin "] ; ["av "; "avenue "] ; ["av. "; "avenue "] ; ["Av. "; "avenue "] ; ["Av "; "avenue "] ; ["ave. "; "avenue "] ; ["ave. "; "avenue "] ; ["Ave. "; "avenue "] ; ["Ave "; "avenue "] ; ["pl. ";"place "] ; ["Pl. ";"place "] ; ["BIS ";"Bis"] ; ["bd ";"boulevard "] ; ["bd. ";"boulevard "] ; ["Bd ";"boulevard "] ; ["Bd. ";"boulevard "] ; ["Bvd. ";"boulevard "] ; ["Bvd ";"boulevard "] ; ["Bp ";"Boîte Postale "] ; ["BP ";"Boîte Postale "] ; [" cp ";" — Case Postale "] ; [" CP ";" — Case Postale "] ; [" Cp ";" — Case Postale "] ; ["CP ";"Case Postale "] ; ["Cp ";"Case Postale "] ; ["cp ";"Case Postale "] ; ["c.p. ";"Case Postale "] ; ["C.p. ";"Case Postale "] ; ["De ";"de "] ; ["-De-";"-de-"] ; ["-Du-";"-du-"] ; ["Du ";"du "] ; [" d'a";" d’A"] ; [" l'a";" l’A"] ; [" d’a";" d’A"] ; [" l’a";" l’A"] ; [" d'e";" d’E"] ; [" l'e";" l’E"] ; [" d’e";" d’E"] ; [" l’e";" l’E"] ; [" l'h";" l’H"] ; [" l’h";" l’H"] ; [" d'h";" d’H"] ; [" d’h";" d’H"] ; [" d'i";" d’I"] ; [" l’i";" l’I"] ; [" d’i";" d’I"] ; [" l’i";" l’I"] ; [" d'o";" d’O"] ; [" l’o";" l’O"] ; [" d’o";" d’O"] ; [" l'o";" l’O"] ; ["-d’o";"-d’O"] ; ["-l'o";"-l’O"] ; ["-d’o";"-d’O"] ; ["-l’o";"-l’O"] ; [" d'u";" d’U"] ; [" l'u";" l’U"] ; [" d’u";" d’U"] ; [" l’u";" l’U"] ; ["Des ";"des "] ; ["rte ";"route "] ; ["Rte ";"route "] ; ["Rue ";"rue "] ; ["Ruelle ";"ruelle "] ; ["sent. ";"sentier "] ; ["str. ";"strasse "] ; ["st-";"St-"] ; ["¶";" "] ; [" ";" "] ; [" L’";" l’"] ; [" L'";" l’"] ; [" D’";" d’"] ; [" D'";" d’"] ) Let ( pos = Position ( Home_Address_1 ; " " ; Length ( Home_Address_1 ) ; - 1 ) ; Case ( pos ; Replace ( Home_Address_1 ; pos ; 1 ; Char ( 160 ) ) ; Home_Address_1 ))
  4. Yes of course, global fields. Thanks once again.
  5. 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?
  6. Thank you for all this precious feedback. Any hints on how to configure an XSLT stylesheet
  7. 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
  8. 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.
  9. Filemaker clients can access remote files but FileMaker go cannot. These setups previously worked. What can be blocking fm go?
  10. 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?
  11. 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.
  12. 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.
  13. 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.
  14. 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
×
×
  • Create New...

Important Information

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