Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Opotoc last won the day on January 30 2013

Opotoc had the most liked content!

Community Reputation

1 Neutral

About Opotoc

  • Rank
    Software Engineer & Consultant

Profile Information

  • Gender
  • Location
    Mannheim, Heidelberg, Ludwigshafen, Germany
  1. Hi Don, I understand forums are for helping not doing the work To get to your desired result all you need to do is to include another CF based on DupReturnOrSpaceReList where everything "Right" is "Left". List ( DupReturnOrSpaceReListRIGHT ( ReturnOrSpaceReList ( YOUR_INTEVAL_LIST ; REGULAR_MINUTES ) ) ; DupReturnOrSpaceReListLEFT ( ReturnOrSpaceReList ( YOUR_INTEVAL_LIST ; REGULAR_MINUTES ) ) ) Cheers, Alexander
  2. Hi CCB, mine was just an example that's why I chose an html table as output to demonstrate. If you only need to import one record the above works fine, glad you found a solution. Cheers, Alexander
  3. Hi Don, In FileMaker this requires two CFs since we cannot nest two functions into one CF: one to group everything that is in the expected sequence (i.e. every five minutes). the second to extend each group into that up-side-down pyramid. // ReturnOrSpaceReList ( tlist ; _minutes ) // If ( IsEmpty ( tlist ) ; "" ; Let ( [ s = Substitute ( tlist ; Char (13) ; "¶" ) ; t = GetAsTime ( GetValue ( s ; 1 ) ) ; u = GetAsTime ( GetValue ( s ; 2 ) ) ; // next value in list v = GetAsTime ( t + _minutes * 60 ) // following the pattern this should be the next value
  4. Two machines - sames path, is one volume probably mounted on the other machine? check /Volumes/ Terminal open /Volumes/ This shows all volumes on your machine, in case of conflicting names the volume still shows up in Finder with its name, but the path is different: i.e. Finder: HD HD /Volumes/: HD HD-1
  5. Hi CCB, you need to loop through with <xsl:for-each> . Best, Alexander <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xd="http://www.oxygenxml.com/ns/doc/xsl" xmlns:Demographics="http://www.zillow.com/static/xsd/Demographics.xsd" exclude-result-prefixes="xd Demographics" version="1.0"> <xsl:template match="/*"> <table> <xsl:for-each select="response/charts/chart"> <tr> <td> <xsl:value-o
  6. Don, all that needs to be done is to put your script loop into a CF: // ReturnOrSpaceReList ( ListA ; ListB ) If ( IsEmpty ( ListA ) ; $theNewList ; Let ( [ $t = GetValue ( ListA ; 1 ) ; $theNewList = If ( PatternCount ( ListB ; $t ) ; $theNewList & " " & $t ; List ( $theNewList ; $t ) ) ] ; ReturnOrSpaceReList ( RightValues ( ListA ; ValueCount ( ListA ) - 1 ) ; ListB ) ) ) ListA is the list with all potential items, ListB are the actual taken items. So this was my coffee break . Cheers, Alexander
  7. Hi, if I get you right, you should be able to do it like this. I assume that you use some trigger to show the customer dialog (button or script trigger on load). All you need to do is in your script If [ PatternCount ( List ( RelationToPortalRecords::CERT ) ; "YES" ) > 0 ] Show your dialog.. End if List creates a ¶-separated list of all entries in a related table's field. So all you need to check if there's at least one "YES" in the list. Best, Alexander
  8. Hi, I think a recursive CF should you the job easily. Compare two Lists List1 = List of the actual occurences (/may contain breaks) List2 = List of all potential occurences -> you can generate this this with the CustomList CF of Agnes Barouh. With your CF just simply loop through List2 with GetValue , check wether the item exists in List1, if not add it with " " to your CF_List, other wise "¶". I think this should do the trick. Best, Alexander
  9. Hi, absolutely, you should look into conditional formatting. Count ( Tableof::events) > 1 --> apply red, bold, whatever you wish Best, Alexander
  10. Hi, you need to select the author element for the for-each statement. For the import you select the author contents via "." XPATH works as the same implies via the path to the information, it's not a script language. This way it will work: <xsl:for-each select="contributors/authors/author"> <xsl:value-of select="."> Cheers, Alexander
  11. Hi Tom, Best practice is to use a script: Set Variable [$theIDs] = ExecuteSQL ( ... ) Set Filed [ Your_global_Field_for_the Relation ] = $theIDs. Cheers, Alexander
  12. I had most of the files deleted and now everything is working as expected. This points to that there is some limitation either timing or file count. As very rough figure I can tell from my "experiments" 1.000 files in the tmp folder seem to be ok. But that's just some figure, no other factors as workload etc were taken into any consideration.
  13. Are you sure the path to the external file is working on the server? Before FileMaker had native Execute SQL I used the same technique and never had any problems.
  14. Have you created a plugin for ExecuteSQL()? To my knowledge you can only use ExecuteSQL() with ScriptMaster Advanced and you cannot invoke it via a Script Step. You need to create a custom plugin.
  15. Time to take a break!

  • Create New...

Important Information

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