Jump to content
  • Welcome To FMForums

    Welcome to our community, full of great ideas on developing your FileMaker solutions effectively,
     for peer-to-peer support of the FileMaker Platform and related products and services. Register and join the conversation!

     

    fmf AD.jpg

     

     

All Activity

This stream auto-updates     

  1. Yesterday
  2. While it's been around for a few years now, there aren't too many developers in the world of FileMaker who have explored Node-RED. Created by IBM and made open source in 2016, this visual programming tool may start to make waves in the FileMaker world. A wonderfully generous developer named Lui de la Parra has made it possible to use Node-RED with FileMaker's own Data API. This means that anything in the world of Node-RED is now accessible to FileMaker. This is an amazingly powerful technology for connecting all kinds of things, both physical and virtual, into the FileMaker ecosystem. In this video, I walk through my own personal use of Node-RED and showcase how I use it in order to capture XML data from an online store and process that data directly into FileMaker. Whether you need to collect moisture data from physical hardware in a vineyard to interacting with any online web service or API, Node-RED, in conjunction with the Data API, will allow you to realize all kinds of powerful solutions! Click the title or link to this article to view the video. View the full article
  3. While it's been around for a few years now, there aren't too many developers in the world of FileMaker who have explored Node-RED. Created by IBM and made open source in 2016, this visual programming tool may start to make waves in the FileMaker world. A wonderfully generous developer named Lui de la Parra has made it possible to use Node-RED with FileMaker's own Data API. This means that anything in the world of Node-RED is now accessible to FileMaker. This is an amazingly powerful technology for connecting all kinds of things, both physical and virtual, into the FileMaker ecosystem. In this video, I walk through my own personal use of Node-RED and showcase how I use it in order to capture XML data from an online store and process that data directly into FileMaker. Whether you need to collect moisture data from physical hardware in a vineyard to interacting with any online web service or API, Node-RED, in conjunction with the Data API, will allow you to realize all kinds of powerful solutions! Click the title or link to this article to view the video. View the full article
  4. I had a similar experience, not quite so drastic, where a file was growing something like 100 MB/day. But it was an interface file where no data was being added. To troubleshoot, I took a copy of the file and since, as you discovered, cloning doesn't fix it, and deleting fields didn't fix it, I started deleting tables, then closing the file to see the effect on file size. If you have a lot of tables you can hone in on the culprit by deleting half of them, check size, if no change, delete half of remaining, etc. It turned out deleting one particular table made a difference. Even though it supposedly had no data. Then I had a thought -- what about the truncate script step? It worked! Whatever was lurking in that table -- presumably something in a container -- was flushed out by truncate. Good luck and welcome to FM Forums.
  5. 3+ GB for a file with no data (clone) is huge and not typically normal. Do you use a lot of layout elements like pictures or graphics? Try to produce an XML DDR report, if it does not finish then the place where it stops could be a good indicator of something that is off in the and it will point you to where that is (you'll need to backtrack the XML structure from the point where it stops, so it is a bit of chore). Don't run recover on your original file, run it only on copies or backups! Also look in the FMS event log to see if FMS crashed at some point. If you are running FMS on Windows, also use the Windows application event log and system event log to look for errors.
  6. You're right, I was and thank you. I had the Client ID field from Clients whereas your example has the Parent ID from Children (of course, they cry). A numpty error. Thanks very much for taking the time to help.
  7. You are obviously doing something wrong - but I cannot tell from your description what it is. See if the attached demo helps. SelectParent.fmp12
  8. Thanks for the reply Something about my understanding is skewed here. I have done what you suggest, thank you, and yes, it does the look up fine. But it won't show Customers in the list until a Customer is assigned (the dropdown or menu is blank). Then, if I try to change the customer by name it is trying change the Customer ID for that Customer Name (ie I get the "unique values" message) I get this even if the control is an Edit Box. To clarify; this is within a layout based on Jobs I have worked out that what I need to do is the other way around, ie create the Job within the Customer layout (through a Portal) rather than assign a Customer within the Jobs layout after creating a job. But I don't understand this logic. I don't see why I can't make a Job then assign a Client My relationship is set one-to-many Clients::Client ID -> Jobs::Client ID Creation of Jobs is allowed through this relationship but Creation of Clients is not (Otherwise many clients with the same name are created.
  9. If you are choosing by selecting from a value list using a drop-down list or a pop-up menu, you can define the value list to Also display values from second field. Make CustomerName the second field and check the option to Show values only from second field. Note that the behavior of field formatted as a drop-down list will be different from a field formatted as a pop-up menu: after exiting the field, the drop-down will display the selected CustomerID, while the pop-up will continue to show the name. But the field contents will be always the ID. And of course you must have unique customer names for this to work.
  10. Apologies for this newbie question, it seems like it should be obvious, but.... Database, two fields Customers and Jobs, relationship by Customer ID. When a new Job is created you need to choose a customer, I want to choose the Customer by Customer Name but have the relationship by Customer ID - ie choosing the Customer only depends on knowing the Customer Name, not the Customer ID Or do I need to make the relationship on Customer Name to be able to choose Customer Name in the Jobs layout?
  11. Last week
  12. Hello, We are running an FM15 solution on a Windows Server platform in a small sized company setting. The FM solution is comprised of about 70 Tables, multiple layouts and Scripts. Its been in use for over 6 years in this environment and working well On June 25th, the File size grew from 1.7 GB to 5.8 GB Performance the next day was fine, and we actually didn't notice the change until 2 weeks later I have run: File/SaveAs/Compacted: 4.29 GB Save as Clone No records: 3.24 GB I have run the DDR report on an older,smaller backup file and this one and cannot detect any glaring differences When running the Recover command it hangs on recovering the last Library, (has no name?) at around 4514. I saw this in the Recover Log file I have tried systematically deleting tables, layouts but the file size does not diminish by much I'm afraid since the recover does not finish, I am looking at some corruption. Does anyone have any other trouble shooting ideas or why the file size may have grown? Any comments are appreciated Jon
  13. Did you try running it with the debugger to see if it fails at a certain script step? Did you try running the script from the menu, instead of a button to see if the button is corrupt?
  14. Looking to take your FileMaker to the next level by bringing it to web or creating a customer web portal? Learn why Vue.js is our recommended Javascript framework to build highly dynamic FileMaker webapps. Be sure to check out FileMaker Web Apps with Vue.js Includes a free video and sample file. Joseph Yeager dbservices.com
  15. nick360Works

    Josh

    Hi Josh, Please navigate to http://localhost/360Deploy/ or your serveraddress/360Deploy and click the link to submit a bug report. That will send in a log file to 360Works support, so we can look at the errors more closely. Thanks.
  16. I have a billing system, from customer data. I have a script to create new invoice, it always worked fine. suddenly crashed and the filemaker closes whenever I intend to create a new invoice. Thanks for any suggestions to solve.
  17. Start here. https://filemaker.jiveon.com/docs/DOC-9285
  18. No, that is not correct. You can set a global in a table in another file, as long as you have TO to that table in the file that runs the script.
  19. bcooney - thank you for the advice. When I imported the zipcode file the fields that were globals in the old table did not import as globals but rather as text fields. <facepalm> . Wish I'd seen your response sooner but in the end I wound up re-writing the script so that passing parameters became mute. As mentioned this was old code from FM6 and I was trying to make a quick change. We all know what a quick change can turn into. Wim Decorte - setting a global field in another table from anywhere can be done as long as the tables are in the same file but unless I'm mistaken this doesn't apply if the global field is in a table referenced in an external data source. Is that correct? comment - I was using debugger and data viewer. When I was in the parent script and set the value the field and value was showing in data viewer as expected. When the sub-script was called then the same fields in data viewer showed 'unrelated table'. The parent script was run from a file called 'logging'. From that perspective the table I moved (zipcode) was moved from one external data source (zipcode::zipcode) into another external data source (claims::zipcode). The TO chart in logging was changed to reference the newly moved table. In theory the script that worked with the old configuration (zipcode::zipcode) should have never seen the difference. Of course, in theory, I should have also looked closer at the imported table to be sure those fields were actually globals. ;) Thank you all for your responses.
  20. Amazon Simple Storage Service (Amazon S3) is essentially an online file storage service. This file storage service offers industry-leading scalability, data availability, security, and performance. This FileMaker Demo App shows you how to upload documents out of a FileMaker container up to S3, and how to generate a public url link to that document. Download the sample file here: https://fmtraining.tv/marketplace/aws.html support@rcconsulting.com www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com
  21. The result of Get (DesktopPath) includes a trailing /, so try: Get ( DesktopPath ) & "StuAdd/Full_Download.xlsx" The .xslx format is supported since at least version 10, if not earlier.
  22. Greets, all: I'm sure this has been asked but after searching through 168 pages of this forum, I couldn't find an answer so it's on me that if this is a repeat question. Sorry. This involves FileMaker Pro v12 client and server on another company's machine in another location; I'm using a VPN to help out. I want to code a script to import a file from the user's desktop (in a folder named StuAdd; the filename is Full_Download.xlsx) but I don't know how to code the syntax for importing from either a Mac or PC to the file on the server. So far, I have: Case ( Abs ( Get ( SystemPlatform ) ) = 1 ; "filemac:" ; "filewin:" ) & Get ( DesktopPath ) & ...and that's as far as I got. I tried ...(Get (DesktopPath) & /StuAdd/Full_Download.xlsx, but that didn't work, so I need help with the syntax. One question off the top of my head is, with FMP v12.x being so dated, does it even recognize .xlsx as an extension? Cheers, Rich
  23. Hello! Many thanks to the formula works very well. The numbers will be used for military identification.
  24. Thanks for posting back and closing the loop. It'll help the next one down the line.
  25. If I may ask, what's the purpose of using such ID's? How do you plan to use this?
  26. Hello French user of FM14 I'm looking for a sample of getting infos for a book through Google books API in a FM database (tile, author...cover picture...) Thanks for your help Noël
  1. Load more activity
×
×
  • Create New...

Important Information

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