Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


gczychi last won the day on October 14 2016

gczychi had the most liked content!

Community Reputation

1 Neutral

About gczychi

  • Rank

Profile Information

  • Title
  • Gender

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Yosemite, Mojave, Win 7, Win 10

Recent Profile Visitors

2,815 profile views
  1. OMG, I never thought that these were not server compatible! But I will heed your advice turning the compatibility option on. Thanks a lot!!
  2. Hi, I have the following script step that works just fine, locally: Insert File [ Target: g::tmpc ; "$URL" ] g::tmpc is a global container field (that is deleted after the file (a pdf) is inserted. $URL contains something like "file://Macintosh HD/var/folders/m4/91h3r7mn2h71j7vmyzv4z7nm0000gp/T/S6847/File.pdf" (using the tempFolder functionality). When this is running on my FM Server 17 (script is called with PSoS) it just doesn’t fill the container field! It is very tedious to debug script steps on the server, but anyway I manage to check the Length ( g::tmpc ) after the
  3. Comment, you’re a genius. I completely forgot about the TextDecode function. I really like it! So simple to use, works on any platform and even in my favorite FileMaker version (16). AppleScript wasn’t really an option because I always get confused with the trazillion quote characters, the fact that it is not cross platform and especially the fact that there is no easy way to get the shell result back into FileMaker. Shell support would be way cool. Maybe someone would write (has written?) a script that intelligently works cross platform (AppleScript/Shell & PowerShell) and that
  4. Hi, hope it’s not to late to answer. It really seems to make no sense to have new field names each year for the same kind of data. If you can somehow create fields that you can reuse each year, then the following would be my suggestion: Since you seem to know SQL, I would suggest FileMaker’s Execute SQL function. With a free plugin (SQL Runner from Dracoventions; super great product, btw.) you can do INSERT INTO as you wish. The steps would be: 1) Paste SQL DUMP into a text field. 2) In a script, read line after line of the text field and put the data of each line into
  5. Hi, all I need is to read the content of a text file into a text field and I can’t figure out how. Situation: I have ≈150’000 folders, each with one image file and one xml/text file with meta information about the image file. The image file and the meta data need to go into the same record. I’ve looked for hours now, but couldn’t find a solution: • I can’t use the import folder command, because it creates new records for each file in a directory. • I can’t use Do AppleScript > do shell script > cat x.txt, because I can’t get the result into FileMaker. • I ca
  6. Hi, I'd like to INSERT new records, but only, when they not already exist. Otherwise I‘d need to update existing records. There is a handy command in MySQL and I wonder if there’s a workaround for our SQL92 engine? INSERT INTO table (column_list) VALUES (value_list) ON DUPLICATE KEY UPDATE c1 = v1, c2 = v2, ...; Thanks a lot for your comments! Gary
  7. GREAT, works like a charm! I tried everything, and the only thing that I missed was the second field name ", Konto.Name_short" in the GROUP BY line. I kept getting the error message — and now I know that THIS error message was actually saying where the problem was… 😀 All non-aggregated column references in the SELECT list and HAVING clause must be in the GROUP BY clause. Thanks a lot!
  8. Hi, I have a table Beleg:: that I can query like this SELECT Beleg.id_Konto, COUNT ( Beleg.id_Konto ) FROM Beleg WHERE Beleg.Year = 2020 GROUP BY id_Konto To get the COUNT of each id_Konto in Beleg: 2e974529-5bf6-47e1-b1a7-05b3b2582aea 397 cb54987b-1eec-4868-bcb5-14e2efccc1be 83 ea461038-43f1-43b8-8d68-a2f357f7f41f 27 And I have a table Konto:: that has the names for the id_Konto = Konto.id values: SELECT Konto.Kontonr , Konto.Name_short FROM Konto WHERE Konto.id IN ( SELECT ( Beleg.id_Konto ) FROM Beleg WHERE Beleg.Year = 2020 ) ORDER BY Konto.Kontonr
  9. Thanks, Kaizentu, it’s not really elegant, but nor is FileMaker scripting. For Loops, I'm ususally using the self resetting loop script from fmstandards, which is pretty cool (see picture). But FileMaker shouldn’t consider these instances as errors. So, what could prevent the no records found «error» to appear in the event list? Thanks, Gary
  10. Browsing through my event logs, I am finding weird scripting errors, like: ... Information 645 ...local Schedule "Import Main (every minute 8-20)" scripting error (401) at "Import : Import Main : 36 : Perform Find". How can a simple «Perform Find» script step (which works just fine in the server scheduled script, btw.) generate a scripting error? Occasions where the FoundSet = 0 should be considered «normal». I also have found other errors, that shouldn't be errors, like «Go to Record/Request/Page [ Next ; Exit after last ]», when there is no next Record. What is the best way
  11. That did the trick! After I changed the field to text, everything works now as it should. And the problem inserting «1¶2¶3» was also related to the wrong field type. Thanks a lot!
  12. I have a Number field «Kontakttyp_enum». It contains multiple (!) number values, depending on what the user has deemed to select (see picture). It works great — numbers appearing and disappearing in this field, depending on which checkboxes are clicked upon. Now, I’d like to set this field with the «Set Field» script step — but I can’t figure out how. I can read specific values (for example with the function «Position ( Kontakttyp_enum ; 6 ; 1 ; 1 )», but I don’t know how to add or remove a specific number. Has anybody any insight on this? It’s quite interesting. Even though it
  13. Hi, good idea. However, since the PersistentID is not unique (see: https://community.filemaker.com/thread/85477), it would create a lot of hassle to work with this one. Thanks, Gary
  14. It’s not as easy as: PatternCount ( Get ( ApplicationVersion ) ; "Server" ) Anyone know how I can determine if the FM application (FMP or FMPA, not Server) that a script is running on is the client or the server application? When using a remote database that is hosted on a FM application (not FMS), speed is very often an issue. So I need to determine if a script is executed locally on a FM application that is acting as the server (fast) or if the script is running on a client FM application accessing a remote database (slow). I would need to Exit the Script in the latter case.
  15. OK, I have found the problem: The account that I use in FMS to execute the script was not defined in both files, but only in one. Makes sense. So, in order to be able to access data in an external data source, the same account which FMS uses to execute the script needs to be present in both files.
  • Create New...

Important Information

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