Popular Content

Showing most liked content since 04/26/2017 in all areas

  1. 3 likes
    Couldn't this be much simpler? AppleScriptSpeak.fmp12
  2. 2 likes
    Not sure I follow entirely, but in your script, just before the "Show Custom Dialog" just do a Set Field [Examples::MASTER CODE ; "" ]
  3. 2 likes

    Version 1.0.0


    This technique was inspired by @Claus Lavendt in a tweet. Now with offset new card style mode you can now create a tool pallet to interact with a document in preview mode


  4. 2 likes
  5. 2 likes
    See: http://www.filemaker.com/help/16/fmp/en/#page/FMP_Help%2Fextended-privileges.html%23wwconnect_header (the last item in the table).
  6. 2 likes
    That doesn't actually help the user find the answer to his question, it answers a different one, and there are reasons for wanting this one answered.
  7. 1 like
    Looking for instructions for Windows? Click here! Let’s Encrypt is a non-profit certificate authority with the mission of spreading the SSL love across the internet. Though they’re not officially supported, we can use Let’s Encrypt to get free SSL certificates to use with FileMaker Server. We will use a Bash script and a LaunchDaemon to retrieve and automatically renew SSL certificates through Let’s Encrypt to make sure our connections to FileMaker Server are secure. With this, there’s no reason anyone should have an invalid SSL certificate on their FileMaker Server deployment! Requirements: FileMaker Server deployed on a Mac server – Tested with OSX 10.11 but may work with other versions. The “FileMaker Database Server Website” page must be reachable through the public internet using a web browser at the address you wish to get an SSL certificate for, such as http://myserver.mycompany.com. This means opening or forwarding port 80 in your router, firewall, or security groups. We use the Let’s Encrypt HTTP verification challenge, so we must make sure that Let’s Encrypt is able to reach our FileMaker server through HTTP. Warning: FileMaker does not list Let’s Encrypt as a supported SSL vendor and usually alerts the community that non-supported SSL vendors’ certificates won’t be able to be validated by FileMaker Pro and Go. I believe we’ve solved this issue with this solution. We’ve had no problems with validating these SSL certificates with FileMaker Pro 13-16 but of course can’t make any guarantees. FileMaker Go 15/16 also seem to validate everything correctly, though FileMaker Go 14 can’t connect. Please post in the comments section below if you have any issues using these SSL certificates. This is an experimental script and procedure. Please proceed with the use of this Bash script and Let’s Encrypt SSL certificates at your own risk. Here’s a summary of what we’re going to need to do: Install Homebrew Install Certbot Edit the GetSSL.sh file Run the Bash script Change the FileMaker Server SSL Connections settings Set up a schedule to renew the SSL certificate 1. Download the GetSSL.sh Bash script First, you’ll need a copy of the GetSSL Bash script. Download the file using the link below and save it on your server where you’ll want to get the SSL certificate. Warning: This is an experimental script and procedure, and SSL certificates from Let’s Encrypt are not officially supported by FileMaker, Inc. Please download and use this script with the understanding that it comes with no guarantees or warranties, and that you are doing so at your own risk. Blue Feather, Let’s Encrypt, nor anyone else are responsible for what happens to your server or systems when using this script. Download the GetSSL Bash script 2. Install Homebrew Homebrew is a package manager for Mac. It’s used to install tools and applications for your system. You can read more about Homebrew at the Homebrew website. We’re going to follow the instrucitions on there to install Homebrew on our Mac server. Run the following command in Terminal: /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" 3. Edit the GetSSL.sh file The script file needs to be edited so that it know the address you wish to get an SSL certificate for. Open the script in a text editor like TextEdit, TextWrangler, Sublime Text, or through Terminal using an editor like Vim. Change the address, email address, and (if necessary) the FileMaker Server install path variables to reflect your server’s information and your contact information. Let’s Encrypt will use this contact information to reach out to you if there is a problem with the SSL certificate that they have issued to you. 4. Run the Bash Script WARNING: Running this Bash script will safely restart your FileMaker Server service, abruptly disconnecting any active users. Make sure that nobody is connected to your server before you run this script. With Certbot installed, we’re now ready to run the Bash script. Make sure nobody is connected or using your FileMaker server and then run the GetSSL.sh Bash script by navigating to the directory you have it copied to in your Terminal window and entering: sudo ./GetSSL.sh A bunch of text will scroll by in the Terminal window as the script requests, fetches, and installs your SSL certificate. Your FileMaker Server service will then be stopped and started again automatically. Your SSL certificate should now be installed! Go to your FileMaker Server admin console to make sure you’re seeing the new SSL certificate. You may need to close and re-open your browser if you had the page open already. 5. Change the FileMaker Server SSL Connections settings The SSL certificate is installed, but we want to force FileMaker Pro and Go clients to connect securely to our server. Log in to your newly secured FileMaker Server admin console. Select the Database Server options from the list on the left and then the Security tab at the top of the page. Check the “Use SSL for database connections” option (as well as “Use SSL for progressive downloading” if you would like) to force FileMaker Pro and Go clients to use a secure connection when connecting to this server. Save your changes and then restart your whole FileMaker Server machine or just the FileMaker Server background service. Your FileMaker Pro clients should now show the green lock icon when logging in to this server, indicating that the connection is secure. 8. Set up a schedule to renew the SSL certificate SSL Certificates from Let’s Encrypt are only valid for 90 days and must be renewed before that time. Let’s Encrypt does this purposefully to encourage automation and increase security. In that spirit, we should set up an automatic renewal for our SSL certificates so that we don’t need to manually re-run this every couple of months. This process is similar to setting up a scheduled script in FileMaker Server. Move the GetSSL.sh file to a relatively permanent location on your server. An example place for this might be /usr/local/bin/. You’ll need to create a LaunchDaemon schedule to run the script at the dates and times you want to do it. A LaunchDaemon will run your scheduled program or task at the dates and times, or at the interval, that you specify. These certificates are good for 90 days at a time, and the Certbot tool we’re using will only renew them once they’re at least 30 days out from renewal. You will want to create a .plist file to schedule this in a way which makes the most sense for you. You can have it run once per week, for example, and it will renew your certificate when it becomes eligible for renewal (It will still restart your FM Server at your scheduled time, even if there isn’t a new certificate – I’d like to update this in the future to only restart if there’s a new certificate.). You can use the example .plist file available at the download link below. You can download and edit this example file to run your GetSSL.sh script at the location you stored it at and on the days you want. This example one is scheduled to run once per week, on Saturdays at 6:21 pm. You can read more about writing your own LaunchDaemons from the Apple Developer site. Download example .plist As an alternative, there’s a great app called Lingon X which give you a really nice GUI for creating, editing, and installing LaunchDaemons. A demo is available, and a single-user license is $9.99, which may be worthwhile as it makes creating and scheduling LaunchDaemons very easy. Once you’ve finished setting your schedule, place your .plist file in /Library/LaunchDaemons/. With your LaunchDaemon installed you can tell your server to start the schedule by ( substituting your .plist file name and then ) running : sudo launchctl load /Library/LaunchDaeomns/my-script.plist Done! That’s all that you need to do! Your script should run automatically at your scheduled time to renew your SSL certificate with Let’s Encrypt. Do a test to make sure that it’s all working properly, that it gets a new certificate for you, and that your FileMaker Server service restarts after it has retrieved the certificate. If there is an issue, you may want to run the script manually in PowerShell or debug with the PowerShell ISE to locate any issues. Keep in mind that your FileMaker Server service will be restarted after getting the new SSL certificate, so be sure to schedule it for a time when people will not be active in your system. This is an early version of this script and there is quite surely room for improvement. Please let me know if you have any suggestions or run into any issues using this scripting. Let’s make the FileMaker community a secure one! View the full article
  8. 1 like
    to expand on that; you have this isEmpty ( Sub9First_Semester or Sub9Second_Semester) this part: Sub9First_Semester or Sub9Second_Semester will result in a boolean result; 0 or 1, so it will never be empty
  9. 1 like
    You have a 'parcels' key/node that is not correct. It should immediately start with an array as per their API, you start it as another piece of JSON with another 'parcels' key name
  10. 1 like
    I get exactly where you are at. My first dive into development was taking a system from FMP 4...and reworking the workflow, and adding a ton of features. With the capabilities of the modern versions of FM, there may be some opportunities to consolidate that down into a single UI file that reaches out to the other files and uses there data. Classic separation model use-case. Good luck with whatever you decide to do, and if you need tips or have questions. You know where to find us!! lol
  11. 1 like
    If you take that piece of your code and put in the data viewer it will tell you what is wrong. Look at the output and compare it to what is required. Some quick ones: - you don't need the ampersand after the first -H - you don't add spaces between the different sections
  12. 1 like
    To address the loss of the bottom toolbar during development, I have created a small toolbar which I am putting on every layout with a hide condition if [ not "Full Access" ]  As a result of reading this thread, I think I will be adding additional buttons/segments to include "Show/Hide menu bar[toggle]" and to access layout Mode
  13. 1 like
    FileMaker's 'Open' command will work with Excel and text files -- converting them to FileMaker files in the process -- but not PDF. I believe you can fill in PDF forms using Scribe: 360works.com/filemaker-pdf-plugin/
  14. 1 like
    I move it to Managing Scripts I deleted your duplicate post. Please do not double post your questions.
  15. 1 like
    No. Try the Open URL[] script step to open a non-Filemaker file in its native application. I don't know of a way to do that natively from Filemaker. Perhaps with a plugin.
  16. 1 like
    You can email FileMaker... But as there is only little changes between the versions, you could simply go with 12 and be fine.
  17. 1 like
    Come to think of it, you could probably just use Find/Replace to highlight the found text and to move to the next (or previous) occurrence. This could be scripted, as shown in the attached file. Note that we are using a calculation field to prevent accidental modification of the original. FindNexttInPortal.fmp12
  18. 1 like
    I conducted a small test of my own and I can confirm that including an external stylesheet causes a failure. That's hardly surprising given what I said earlier about the XSLT being applied from memory, even with the BE_ApplyXSLT() function. Strange choice on part of the plugin's author. Yeah, well, that seems to be a separate issue that muddies the waters. The function does not return any error codes - not even a 0 in case of success.
  19. 1 like
    They are being sent out in batches. Takes a few days. Globally, we are probably talking about millions of emails. I've heard several people say they haven't gotten theirs yet.
  20. 1 like
    I can confirm there is no error message (using BE 3.3.4). However, the process itself works fine for me. Verify your paths as suggested here: https://baseelementsplugin.zendesk.com/hc/en-us/articles/205350417-Notes-about-File-Paths
  21. 1 like
    I'm assuming you are using a system script schedule on FMS? Then the script itself can only be in one location: the FMS scripts folder. If it is not there you wouldn't be able to select it when you set up the schedule. This could be a permissions issue: both on the script file itself (owner and group has to be fmserver / fmsadmin ) and the script will be executed in the context of that fmserver user. That user needs the proper rights to do what you want; which it may not have.
  22. 1 like
    For the new version, going to test it like mad in the next few days.....
  23. 1 like
    It would. Clicking a button to populate a joining date field would work even better, IMHO.
  24. 1 like
    There is no good reason to add the joining month to the actual membership number. You can easily display the joining date (formatted as MMDDDD) alongside the membership number, if it helps. Although I believe a computer would be much better at keeping track of when it's time to renew a membership than a human eyeball.
  25. 1 like
    There are 3 new extended privileges in 16 that are off by default. So you need to check them to make sure they are enabled, if needed. fmrest - Access via FileMaker Data API - FMS only fmextscriptaccess - Allow Apple events and ActiveX to perform FileMaker operations fmurlscript - Allow URLs to perform FileMaker scripts
  26. 1 like
    We have millions of records in multiple tables, being hammered on by 100 users... And processing 3-5k records at a time. Rarely takes longer than a few seconds. So I'm not sure what you mean. I'll agree, FM will let you build it so it's slow, but that doesn't mean it can't be faster. And as Jeremy said, performance increases are only beneficial to a point. There are so many variables that can make a process or script perform poorly, it's short-sighted to always blame FM for that. Sometimes, and probably more often than we would like to admit, it is the developer's fault.
  27. 1 like
    Here's another: https://www.geistinteractive.com/2017/05/09/filemaker-16-biggest-change-since-filemaker-7/
  28. 1 like
    I am guessing you are having a problem with the "ILR-99999999-1617-20160229-144401-01.xml" file. The reason for this is that all the elements in the file are in a namespace. They are put there by the default namespace declaration: xmlns="SFA/ILR/2016-17" carried by the root Message element and inherited by all it descendant elements. This means all your select expressions select nothing. In order to select an element in a namespace, you must declare the same namespace in your stylesheet, assign it a prefix (an arbitrary string), and use that prefix to address the elements in the source XML: <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ilr="SFA/ILR/2016-17"> <xsl:template match="/"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <METADATA> <FIELD NAME="LearnAimRef" TYPE="TEXT"/> <FIELD NAME="AimType" TYPE="TEXT"/> <FIELD NAME="AimSeqNumber" TYPE="TEXT"/> <FIELD NAME="LearnStartDate" TYPE="TEXT"/> <FIELD NAME="LearnPlanEndDate" TYPE="TEXT"/> <FIELD NAME="FundModel" TYPE="TEXT"/> <FIELD NAME="ProgType" TYPE="TEXT"/> </METADATA> <RESULTSET> <xsl:for-each select="/ilr:Message/ilr:Learner/ilr:LearningDelivery"> <ROW> <COL><DATA><xsl:value-of select="ilr:LearnAimRef"/></DATA></COL> <COL><DATA><xsl:value-of select="ilr:AimType"/></DATA></COL> <COL><DATA><xsl:value-of select="ilr:AimSeqNumber"/></DATA></COL> <COL><DATA><xsl:value-of select="ilr:LearnStartDate"/></DATA></COL> <COL><DATA><xsl:value-of select="ilr:LearnPlanEndDate"/></DATA></COL> <COL><DATA><xsl:value-of select="ilr:FundModel"/></DATA></COL> <COL><DATA><xsl:value-of select="ilr:ProgType"/></DATA></COL> </ROW> </xsl:for-each> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet> Note that I have also deleted the: <COL><DATA><xsl:value-of select="ilr:elevation_m"/></DATA></COL> part from your attempt, because I don't see an elevation_m element in your input nor a corresponding field in the field names you have defined.
  29. 1 like
    No, at least not going by your description. There is something else you're not telling us, e.g. a script trigger..
  30. 1 like
    This is cute. And completely not the case in reality. I have seen so many "professionals" try to replicate work we have done in FileMaker, and they have been ridiculously unsuccessful. I don't disagree with some of what you mentioned. There are things I would love to see done differently. But that is also the case with every other programming environment I've dabbled in. To be fully honest, they all suck in their own way. Scale? What kind of scale are you referring to? I ask because I see 2 types of people that say this ( note I'm not implying anything about you specifically, just a general observation ). (1) People who built themselves into a corner, and just set up the data model the "wrong way". For them handling a few thousand records is painful. (2) People who want to process 20 million records in a second or two. Constantly. All day. Yeah, FileMaker isn't that tool. Relatively speaking, the number of companies needing to process millions of records a day is kind of small...compared to the companies that only need to handle a few thousand to a few million records a year. So for developers, this is one tool they have in their toolbelt. And they get paid well for the work they do. That's the definition of professional. Many developers I know have more work than they can handle right now. So it's hard to agree with you on that point.
  31. 1 like
    That could be because your script is paused at that time. Let your script finish (or don't run it at all), switch to Layout mode, go to the "RPT Outstanding CAPA Report" layout and examine what - if anything - is under the Capa No. label. The other possibility is that you don't have the required access privileges.
  32. 1 like
    I think it would be best to start by identifying the problem. But if the field is not on the layout, then obviously you need to put it there: http://www.filemaker.com/help/10/fmp/html/create_layout.9.21.html#1028407
  33. 1 like
    Can you show the report layout in layout mode? Can you show the script the button calls? Are you sorting the report by the sub-summary part?
  34. 1 like
    Well, we can only guess. I can think of three reasons why you don't see the number: 1. The field is not on the layout (or perhaps not entirely within the Body part of the layout); 2. The field is empty; 3. The field and the layout do not belong to the same TO.
  35. 1 like
    You can use as many wildcards as you wish. They're evaluated in order, so you simply add the criteria in order. Using the wildcard rather than putting the criteria inline tends to save a lot of headaches. E.g.: ExecuteSQL ( "SELECT DISTINCT id_song FROM T26_SET_SETLISTS WHERE id_staff = ? OR id_staff = ?" ; ""; "" ; $Guitarist ; $Drummer ) I don't think this query will give you the results you're looking for, but if you're interested in going further, start here: https://filemakerhacks.com/2012/10/19/the-missing-fm-12-executesql-reference/
  36. 1 like
    No, not as a portal filter but I guess you could use like that. I would personally use the ExecuteSQL() to collect the IDs, set the IDs in a global text field as a multiline and use it to build the relationship.
  37. 1 like
    by far the easiest for you would be to use a multiline key on the left side of the relationship with the IDs of the selected staff: So return delimited list in a global text field: STA01 STA02 Relate to the STA field in the join table will give you a relationship (to use in a portal) to show the songs that they know. Now that may still show duplicate songs in there. You can solve that by using a SQL query for instance to ask for the 'DISTINCT' songs that match both staff but that's a little more advanced, let us know if you're up to working on that.
  38. 1 like
    I am not sure I understand your request. If user A has modified (and committed) a record 10 times, then a list of 10 last users to modify the record would have 10 entries of A. Or didi you mean the last 10 distinct users to modify the record? Also, why do you need to create a new record in another table? Wouldn't a field in the same table (showing a return-separated list of up to 10 user names) be sufficient?
  39. 1 like
    Are the quotation marks the problem? Sent from my iPhone using Tapatalk Pro
  40. 1 like
    Why can't you capture the error and have the script do the reverting? -- P.S. If you had searched for 'capture unique revert', you could have found this: http://fmforums.com/topic/100315-preventing-duplicates-when-creating-new-records-using-set-variable/?do=findComment&comment=456712
  41. 1 like
    You should look in Filemaker's File > Manage Database… > Fields, under Type. And since you have the Advanced version, you can use the Script Debugger and the Data Viewer to see what the actual value of the variable is at script runtime, and what does the test return. Yes. And a relationship based on matching the numerical code. Note also that you need a lookup only if you want to store a copy of the looked up address. Otherwise you can just display the related address directly on your layout.
  42. 1 like
    Got Rentals? Finally, the Ultimate Rental-Tracking Software Solution for the Equipment Rental Industry! Pre-made? Custom? Or SaaS? It’s a never-ending battle of pros and cons when trying to find apps that will make your rental business run smoother while giving you the best bang for the buck. Pre-made? Tempting. It costs less up front but choosing this one-size-fits-all solution may leave you addled with useless features and not enough functionality. Custom? Seems costly but will definitely meet your needs. With SaaS (software-as-a-service), you remain at the mercy of your vendor for feature upgrades, and as fees add up over the years you may find you could have paid for a custom-fit solution instead! Luckily, when it comes to rental business software applications, there’s another way … eXcelisys has released a new eX-File, the eX-RentalTracker — a FileMaker Pro jump-start solution for the equipment rental industry. The app tracks inventory, bookings, returns, customer contacts, invoices and payments and includes an availability calendar. Because the basics are already there, customization is quick and easy. The eX-RentalTracker is the best of both worlds, offering clients a software solution that’s part ready-made and part custom. “After working with multiple customers constructing tailor-made rental tracking solutions for their businesses, we decided to build a jump-start solution for the masses,” said Doug West, eXcelisys VP for product development. “The eX-RentalTracker comes pre-built with many of the standard features our rental business clients have been requesting.” The eX-RentalTracker is for rental businesses who’ve found out-of-the-box software solutions too clunky and custom-built systems too expensive. The eX-RentalTracker can be used on a desktop PC (Mac/Windows) with certain task-based functions available on iPads. See the eX-RentalTracker in Action Today Businesses interested in the eX-RentalTracker can request a FREE demo copyvia the eXcelisys website. After receiving the eX-RentalTracker demo, you can tool around in the app to see how easy and intuitive it is to use. You won’t need a tutorial to figure out how the eX-RentalTracker works because the tabbed interface makes navigation a cinch. Check out the “home” screen, which includes “Quick Tasks” tabs that provide rapid access to the tasks most frequently used in rental app solutions. The eX-RentalTracker simplifies daily processes. Features include: Kitting (allows multiple items to be packaged in a single rental kit) Barcodes/handheld scanners (for quick check-out/check-in) Instant invoicing (no more entering long strings of product numbers) Equipment tracking (prompts users to select the condition of returned items at check-in so broken inventory doesn’t get placed back on the shelf) Availability calendar prevents overbooking. The “Quick Tasks” tabs on the home page offer quick access to many everyday tasks, such as adding a customer, a product, a PO, a vendor or an order. Track the history of each item — know where it’s been and the condition in which it was returned. eX-File FileMaker Pro Templates Save Tons of Time & Money eXcelisys has been designing jump-start FileMaker Pro template solutions since 2004 when the first edition of the FileMaker Pro BizTracker was released. Since then, the BizTracker (for sales-driven businesses) has evolved into a full lineup of eX-File solutions, including the eX-TruckingTracker (which tracks trips, mileage, and expenses) and the eX-EvalTracker (used to archive employee performance). The eX-BizTracker has been a popular and steady jumping-off point for countless eXcelisys customers requesting software development. Ever proactive, eXcelisys developers modified the tried-and-true eX-BizTracker to create the eX-RentalTracker by adding features and functionality common to and frequently requested in the rental industry. Recently, Birnn Chocolates of Vermont contracted with eXcelisys for a biz-tracking solution. After four generations and 101 years in business, Birnn Chocolates was ready to join the 21st century with a software upgrade to smooth daily operations. Owner Mel Fields had been using a hodgepodge of paper record-keeping, Excel spreadsheets and Google documents to keep the truffles flowing. Fields needed an up-to-date system to manage the production process, ensure order fulfillment and track the ingredients and finished goods for FDA compliance. Instead of starting from scratch — like he does with his truffles — Fields started the process using the eX-BizTracker as a foundation for his business solution. During his hands-on experience with the eX-BizTracker demo, Fields discovered that many of the features he needed were already built into the software. “Being able to demo was essential for being able to pull the trigger and make the decision,” said Fields. Utilizing the pre-built mock-up allowed Fields to zero in quickly on modifications needed to make the software fit his unique business needs. Fields is still awaiting his software solution as eXcelisys developers finish tweaking the eX-BizTracker build. Fields is certain he’s getting a great deal. “We spent some hours taking away features, but in the grand scheme of things, I’m quite sure we got a lot more for the money by starting with BizTracker.” Like Birnn Chocolates, Cinema Camera Rentals recently came to eXcelisys seeking a custom inventory management app and used the eXcelisys BizTracker5 as the foundational template. “This approach helped me the most from a time standpoint,” said Cinema Camera rental manager Matt Stemmley. “Instead of dedicating the energy to figure out how I wanted the system to be laid out, I instead hit the ground running on envisioning functionality.” Stemmley advises business owners to take advantage of the eX-RentalTracker. “Future customers of eXcelisys in any sort of rental capacity will ideally be able to start with the eX-RentalTracker base and add features as they see fit.” Stemmley says he “highly recommends” the eX-RentalTracker to anyone considering a rental app based on the FileMaker Pro platform. “In my opinion, it will save them countless hours that could be dedicated to other areas of design and functionality.” Demo the eX-RentalTracker today. Like Birnn Chocolates, discover how pre-built FileMaker Pro templates can sweeten the deal in the search for the right and perfect software solution for your equipment rental business. To request the eX-RentalTracker demo, click here. To read about the Cinema Camera rental-tracking solution, click here. To read about another eXcelisys-built rental-tracking solution, click here.
  43. 1 like
    "doesn't work" is not a good description a problem. What - if anything - actually happens? Most likely, the value of the variable is not what you think it is (esp. since you say it's "numerical" - numerical values do not have a leading zero). Anyway, it seems your task would be much better accomplished by performing a lookup from a table of 12 records, with fields for Code (a number between 1 and 12) and Address (the actual text you're trying to insert).
  44. 1 like
    Define a calculation field (result is Text) = List ( ProductName ; "All" ) and base your value list on that. You may want to prepend a space to " All", in order to force it to the top of the list.
  45. 1 like
    I'm guessing you will feel constrained by FileMaker. Maybe something like Xojo? Or R? Or just stick with Swift.
  46. 1 like
    If this description is what you mean by 'open', then: no. FM's scripting is proprietary. It does allow for running external things through plugins etc but you'd have to find one that you like to do this. I think they exist for python but not for swift. The size of it (20GB) is sorta meaningless, a better measure would the the # of records and the # of fields per table and a better understanding for us on the nature of the manipulations you'd expect to do on those records. If you have 20 million records for instance and expect sub-second summary calcs on those then FM is not the tool for you. FM does have a pretty good ODBC/JDBC and XML API. The python API you have found is a wrapper around that XML API, that one only works through FMS. xDBC works locally on a copy of FMP but the calls to it also have originate from that same machine. There is a hybrid solution for you: FM does have native support for MySQL databases. So you could keep your heavy-duty record manipulation outside of FM but still use FM as a GUI to your records. Check out the ESS feature as it is called (External SQL Sources).
  47. 1 like
    Hi Andi You can download a Free Trial of FileMaker Pro 15 here http://info2.filemaker.com/FileMaker_trial_request.html It has a time limit, but you should be able to get a feel for how it works. Check out the example files that is included HTH Lee
  48. 1 like
    That's not a Filemaker-related question. I suggest you start a new thread and post what you have so far: the source XML, your current stylesheet, and - no less importantly - the target field mapping.
  49. 1 like
    Try ExecuteSQL ( " SELECT COUNT ( NoteImportant__lxt ) FROM JOB WHERE CompanyName__lxt = ? " ; "" ; "" ; CompanyName__lxt ) To get this result from the context of Jobs without finding/sorting, create a summary field Count of NoteImportant__lxt and a Jobs self-join by company and display the related summary field from the self-join. As an aside: shouldn't you have (and use) a company ID foreign key in Jobs, rather than the name?
  50. 1 like
    Here is a working version of the EAN-13 barcode example. There was an error in the divider bar calculation. To see how to implement this code in existing solutions, see the upcoming UPC-A example in this Forum. Since the solutions are working now, I will delete all intermediate uploads. CodeEAN13new.zip
This leaderboard is set to Los Angeles/GMT-07:00