Search the Community
Showing results for tags 'fmp18'.
Found 30 results
-
Hi everyone, Can you help me to setup a webwiever to display videos on OSX ? I've search but didn't find the solution. Kind regards. Antoine
-
Filemaker, limit found set to first 3 records.
wattmhite posted a topic in FileMaker Pro Advanced 18
I have a script that performs a find and returns about 500 records. I am looking to limit this set to the first 5 found records and then perform another script (loop) for these 5 records. Is this possible with filemaker? -
Hi All Apparently FMI knows about this, and their advice is as follows The problem for me is I don't have an SSL certificate and am using the in-built FM certificate. I would have thought the in-built certificate would at least let me import from the hosted file, especially as I did this from the desktop of the server. The script doing the import has not changed for many years and still runs fine on pre-18 servers. Other than purchasing an SSL has anyone get a solution, without resorting to downloading the hosted files and running locally (I'm trying to avoid that step). Thanks -
Hi, I have some FMP development experience but more so on the intermediate level. We have a FMP database, hosted on a FMP server, that we use to track a bunch of our digital signs. All the data in the db is manually entered with fields such as 'name' and 'ip_address'. Sometimes these signs go offline, hangup, change ip addresses, etc. I had the idea to have the remote signs call a url every hour that is our signage db hosted on our FMP server. Something like: https://fmp.server.com/fmi/webd/db_name?name=signName&ip_address=ip The db could track these calls for all signs in the db and I could create a layout or report that would list the ones that haven't called in within a certain timeframe. I know exactly how the signs themselves would technically call the url, and can handle the layout & report, but don't know how to get the db to listen for the call and handle it. How can I do this? Are there any examples anywhere that explain this? I'm thinking the db would need to have webdirect enabled with a layout that is shared to Guest so a login isn't required but other than that I'm not sure where to start... or if there is a better way to handle this. Once the url call is made, the db wouldn't need to do anything back to the client/sign itself except for perhaps a simple 'success' message. Thanks! -
Hello, I have a FileMaker server 18 installation that’s crashing about once a week. When I look at the event log for the time of the crash. I see client 1 not responding, client 2 not responding etc. until all clients are disconnected. All databases show as open in the server console. From a client PC no open files are listed for the host. If I telnet to the server from a workstation on port 5003 a connection can’t be established. Stopping and starting the database server does not help. Restarting the FileMaker service does not restore operation. The server is still communicating with the network. I can open a web page or browse other computers on the network. Restarting the Windows server restores normal FileMaker operation. My environment is as follows: Windows Server 16 Standard Edition dedicated FileMaker server. 8 GB memory 80 GB RAID disk drive (40 GB free) Indexing turned off No third party backup software running No AV software running Windows File Sharing turned off for all folders. Windows Defender Turned off IPV6 protocol turned off What we have tried so far: We replaced the network switch (after the first crash a few weeks ago). Tested all databases for corruption. Compacted all databases Reinstalled FileMaker Server 18 Any insights would be greatly appreciated TIA John
-
I just updated my office to filemaker 18 and I have a script that imported records but skipped the first row which are all titles. I don't see a skip first row checkbox in the import interface anymore?
-
https://firesidefilemaker.podbean.com/e/a-conversation-with-claris-part-2/ This is Part 2 of a 2 part (90 minute) amazing conversation with Rick Kalman, Director of Product Management for FileMaker, and Robert Holsey, Senior Product Manager for FileMaker. Rick and Robert talk about, among other things, Claris Connect, the benefits of acquisition instead of strategic partnerships, save as XML, responsive layouts, Apple's influence, live database development, moving to a web first strategy and changes to the relationship graph. We are very honored that they took so much of their time to talk with us candidly and openly. Part 1 was released last Wednesday and has had over 700 downloads. Thanks to all for listening. Steven Blackwell tweeted that it was an 'Exceptionally significant PodCast' and that 'All #FileMaker developers should listen.' https://firesidefilemaker.podbean.com/e/a-conversation-with-claris-part-1/ Follow us on iTunes https://podcasts.apple.com/us/podcast/fireside-filemaker/id1473715087?mt=2&app=itunes Follow us on Podbean https://firesidefilemaker.podbean.com or find us on YouTube by searching for Fireside FileMaker ~
-
I have a FileMaker solution that powers an internal "TV network". It runs over Intel Compute Sticks which have FileMaker installed on them and are connected to TVs mounted to the wall throughout the facility. A FileMaker script runs through various layouts and steps thru records on each layout. This lets us show a calendar, weather report (in a web viewer), company news, birthdays, customer feedback, employee recognition, and pictures. I would like to add a news ticker to the solution, like you'd see on CNN scrolling across the bottom. I have a table with the news stories in it. Since you can't run more than once script at the same time, I have a script set on the server to step through the news stories. For each story it uses "set field" to put the story in the field one letter at a time, then cuts off the left side when it gets too long. I then set the solution to open a floating document window at the bottom to display the layout that has the new field on it. In theory, it should then appear that the story scrolls across the screen. It doesn't really work. It is jumpy and sometimes just doesn't show at all. This is the gist of the script for the ticker: Loop Set Variable [$message; Value: (news story)] Set Variable [$letter; Value: 1] Loop Set Field [Data::News;Right(Data::News;68) & Middle ($message; $letter; 1)] Commit Records/Requests Refresh Window [] Pause/Resume Script [Duration (seconds): .05] Set variable [$letter; Value: $letter+1] Exit Loop If [length($message) < $letter] End Loop Set Field [Data::News;Right(Data::News;68) & " | "] Commit Records/Requests Go to Records/Requests [(If ( Get(RecordNumber ) = Get(FoundCount);1;Get(RecordNumber ) + 1)] End Loop I've tried it with various pause durations, with/without the refresh, and with/sithout the first Commit. Nothing works the way I want. Has anyone successfully implemented such a thing?
-
I have a date field that is set by record created date, whenever I create a new record in this table it enters the current date. This is a phone log field so there are literally hundreds of thousands of records. I'm trying to create a calculation that displays the today, if the record created date is current date, and yesterday if it was yesterday and all other should be the date itself but when I create this calculation, it doesn't seem to update on a daily basis and just shows today even if the date was yesterday, unless I create a new record. Any ideas on what I'm doing wrong here?
-
https://firesidefilemaker.podbean.com/e/a-conversation-with-claris-part-1/ This is Part 1 of a 2 part (90 minute) fascinating conversation with Rick Kalman, Director of Product Management for FileMaker, and Robert Holsey, Senior Product Manager for FileMaker. If you aren’t familiar with these two experienced Claris International employees, we consider them to be part of the backbone of the company. Rick and Robert share some incredible insights about what goes into releasing a new version, their vision for the future and their quest to make FileMaker the best tool on the planet. We are very honored that they took so much of their time to talk with us candidly and openly. Part 2 will be released next Wednesday. Follow us on iTunes https://podcasts.apple.com/us/podcast/fireside-filemaker/id1473715087?mt=2&app=itunes Follow us on Podbean https://firesidefilemaker.podbean.com or find us on YouTube by searching for Fireside FileMaker
-
What does the superscript letter in the upper left corner of a field mean? I'm trying to relate fields in one table to fields in another table . . . Thanks!
-
I have a parent table with 3 child tables. In the child table, there can be many related fields. I need to export only one row of data for each record in the parent table. This would require that a new column be created for each of the many values related in the parent to the child. For Instance: Noah Justin has 3 Email Address NJ@Test.com, NJ2@Test.com, and NJ3@Test.com When I do an Excel Export from FM I get Column 1 . Column 2 Noah Justin NJ@Test.com NJ2@Test.com NJ3@Test.com I need: Column 1 . Column 2 . Column 3 . Column 4 Noah Justin NJ@Test.com NJ2@Test.com NJ3@Test.com I'm sure it's pretty common and there is an easy solution to this. TIA -
Welcome Back Claris - Episode #7 At the FileMaker Developer Conference last week, FileMaker, Inc. announced they had changed their name to Claris International and purchased Stamplay. This is a bit of déjà vu for anyone who remembers MacWrite, MacPaint and Claris Corporation. It’s a blast from the past that’s been modernized. We’ll share our thoughts on the announcement and even speculate as to what the future holds. Come join us for this exciting new era for FileMaker. https://firesidefilemaker.podbean.com/e/welcome-back-claris/ P.S. This is our 7th episode. The podcast has already had well over 1600 downloads in just under 3 weeks, so a huge thank you to all of our listeners. It's getting some great reviews and we would love to hear your thoughts and comments. New episodes will be released every Wednesday. Coming up: KISS (Keep it simple stupid) FileMaker Certification Favorites & Features P.P.S. If all goes to plan, a very special episode will be released on August 19. Stay tuned Follow us on iTunes https://podcasts.apple.com/us/podcast/fireside-filemaker/id1473715087?mt=2&app=itunes
-
Chino Hills, Calif., July 22nd, 2019 — John Mark Osborne and I would like to invite you to join us at the Fireside FileMaker podcast (http://www.firesidefilemaker.com or https://podcasts.apple.com/us/podcast/fireside-filemaker/id1473715087) for a series of interesting and, we hope, thought-provoking conversations about everything FileMaker™ from two passionate developers with a total of almost 60 years developing FileMaker solutions. “Michael and I have created FileMaker example files, written blogs, recorded videos, released example files, presented in public and even published books but we have never had the opportunity to record informal chats about FileMaker, much like you would with a FileMaker colleague. We are excited that this medium will allow us to explore FileMaker in a way we’ve never ventured previously”, says John Mark Osborne. The first 4 episodes are available on iTunes https://podcasts.apple.com/us/podcast/fireside-filemaker/id1473715087 or at the firesidefilemaker.com web site: Episode 1 - Native FileMaker Technologies Episode 2 - The Data Separation Model Episode 3 - FileMaker & Excel Episode 4 - How to Become a Professional FileMaker Developer Our philosophy behind these chats is to make you feel like you’re sitting right next to us around a campfire listening to our conversation. It’s casual, sometimes funny but always informative and thought provoking in a way we couldn’t be in a book, blog article, video or example file. Come join us at Fireside FileMaker, listen to an episode and give us your feedback.
-
Hi: I am planning the upgrade to 18, I have 3 questions 1- I will host my own server, as I do now with 11. We are 9 users, normally not more than 5 are connected. I don’t want to install a Windows server so I will go with a Mac. I am thinking of the basic Mac Mini upgrading memory to 16 GB, is it OK? 2- Of the above 9 users, 4 are occasional. I have 4 FMPA 17 individual licenses. If I buy 5 user licenses, can these 4 occasional users connect to the server with the individual FMPA 17 licenses, or do I have to buy the 9 user licenses? 3 - I will keep using Super Container, no point in using time to move to remote containers (tons of files) I will leave the computer that hosts SC as is, I guess that will be no problem (it is the same that currently hosts FMS 11, since load is light, it has not been an issue. it is a Windows 7 Pro machine. thanks Carlos -
Hi All, Do we need SSL Certificate for FM Server Child server that we use to for Web Hosting (WebDirect)? Regards, Khurshid Khan
-
Is anybody else seeing an issue with exporting to .xlsx in FMP 18? I have a scripted find/export that has never been a problem before. But, ever since I updated to FMP 18 I sometimes get errors with the Excel spreadsheet that is created. As you can see in the attached, if I make my changes and hit save it says I have to Save a Copy (if I use the same name it saves over the top of the open file just fine) because the original spreadsheet was an "older version of Excel". If I open it and try to save immediately, I get an error saying a "new version [is] available". I am using FileMaker Pro 18 on a Windows 10 machine and have Office 365 Premium.
-
Hello Experts, In my attached sample file, I have two Tables Inventory and Transactions. In my Inventory Table I have fields Current Month Inventory Last Month Inventory I want these two fields to capture the count of my Last month Inventory and the count of my current Inventory. In my Last Month Inventory Fields I like to have 1589 Bottles / 7 Boxes ; If someone withdraw 235 Bottles This Month My Current Inventory Fields will Show 1354 Bottles / 6 Boxes. Please find attached file that Im working. Thank you Cross posted to https://community.filemaker.com/en/s/question/0D50H00006qwZEcSAM/last-month-current-month-calculation Monthly Inventory.fmp12
-
Hi folks. I'm thinking of upgrading an FMS server, a physical machine that I own and administer, so I wanted some input on whether FM Server is going to benefit from more cores, as for example found in AMD's Ryzen CPUs or whether I should instead opt for less cores but with more performance per core (Intel). Does it utilize threads extensively when many clients are issuing requests, and if yes, has it been like that since, say, version 12 or is it just a recent development? And also, is this behavior similar in both macOS and Windows or are they different?
-
Hello FM Experts! Does FileMaker can create a Queuing System? Here's an example of a Queuing System: Do you think I can create a Queuing System using FileMaker?
-
I currently spend about $60 per month to a company that hosts my FMP 14 databases on a shared server. How complicated would this be to manage on my own? I am not interested in hosting sites for anybody else, just those for my own company. What kind of dedicated computer gear would I need to make this happen? Would I need to have a dedicated IP address? Can this be done by a rube like myself or would it be better to continue paying someone else for this work?
-
I am reworking my process of using FMP server side script. Run Server Scheduled Script every 45 minutes Log in to FTP get directory listing (plugin / curl) Create Record for each file in listing Fetch file via (plugin / curl) to text field Write file to server's Document folder Move file on FTP to sub directory (compete) Import files from document folder in to table It works but think kludgy and FMS probably requires more overhead to deal with the FTP plugin. Is there a way to do the following Run a server sequence script every 45 minutes Run a bash script on server login and fetch new files from ftp (need help with this) Save files to FMS Documents/incoming Run script that gets incoming files Run script that imports files Run script that moves files to complete directory Run bash script with file listing as parameter (need help with this) Bash script logs in to FTP moves files to complete folder on FTP OR DELETES them (need help with this) I am hoping this would be much more efficient for FMP to only have to do file imports vs having to also FTP. Thanks SD -
How complicated is it to migrate solutions written under FM Pro 14 to FMP 18? Will I need to rebuild them from 14 to 15 then 15 to 16 etc?
-
Filemaker 18 now has a popup requesting delimiter information when importing records. I have created a database which has been used for 5 years by my clients, It has an import record script which the user could just run and everything populated properly, after choosing the required file. Now there are shown a new popup and asked to choose delimiters. They now have to know which to choose and it is an extra step which is frustrating for the user. Is there any way to use a default delimiter as it is always the same type of file (tab delimited .txt) imported.
-
When a field validation fails, alert is displayed then when clicking OK program freezes
