Jump to content

Search the Community

Showing results for tags 'pc'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 17
    • FileMaker Server 16
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker DataAPI
    • FileMaker WebDirect
    • Custom Web Publishing
  • FileMaker Platform
    • FileMaker Pro Advanced 17
    • FileMaker Pro 16
    • Command Line Data Migration Tool
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • Legacy FileMaker Platform Discussions
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Member Lounge
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Site Donations
  • Site Advertising

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 270 results

  1. Hi, I am working (better trying or playing around) with FM for some 5 years now. I am not a pro or anywhere near there but in course have come up with some db's serving my purpose well. However, comes the time comes the limits.... I am currently working on a simple invoicing module. (have set up a separate very small db for trial and testing as I do not want to spoil the Starting Point 4 solution template which I have amended to my requirements to an extensive stage already) 4 Fields, namely Current Date: Date Field (system time - have to refresh the window as no real time clock counting solution available for FM) Due Date: Date Field - Date when the invoice is due Status: Text Field - Active, Paid, Overdue and Aging Invoice paid: Date Field Date when the invoice was paid Purpose is to autoenter and update by calculation the Status. Case ( Date > Date Due; "OVERDUE" ;Invoice paid ≤ Date Due; "PAID" ; Date > Date Due +14 ;"AGING";Date Due ≤ Date;"ACTIVE";"") 2 Problems. a.) There seems to be something wrong within the AGING calculation, which is supposed to kick in after 14 days overdue and b.) I would like to override and change the Status field content from for example "Overdue" to "Paid", the moment the field "Invoice Paid" is not empty. Otherwise it would have to be changed manually or would stay on "Overdue" even when an invoice was paid after due date. How am I going to do that?? This may seem easy for many (and I do envy you for that) but it certainly ain't for me. Any help highly appreciated.
  2. I've got a .xls file(s) that are being imported through the server from a PSOS process. Most of the time, it works great! On occasion, the import process will stay stuck at the Import script step. It doesn't execute it, and it throws no errors. I know it's stuck there because I'm placed some sendmail command pre and post, and I never receive the post message. The virtual user server creates just hangs there and never logs out. It doesn't show as using any system resources through the statisics screen, but other real user notice a slowdown when this happens. I also tried the same thing through a server-side schedule, with the same results. The same file will import perfectly fine when I import it through a normal FMP client connection. Once this happens, any other PSOS processes won't work. Server just keeps piling on the virtual users but never logs them out. The only way to stop this is to restart the FMSE service through the command line. I realize that there is some funky data inside the file, as I can copy just the lines that I need, paste it into a new .xls file, and then it'll work fine. But I can't expect the end users to do this with every single file. Server should be able to at least detect this issue and give an error. Something with the server import doesn't work the same way as the client version, but I just can't figure out what or why it would just hang at the import step and not throw an error. I don't know if this is a specific PC issue, as I don't have a MAC server to test this out with. Anyone seen this kind of behaviour and/or offer any suggestions? Thanks!
  3. Apologies in advance for the newbie question, but I really have searched extensively on the web, this site and various tutorials. My only conclusion is that I do not know which question to ask, as I am fairly accomplished in VBA. I am self-learning Filemaker Pro 12 as I need solutions for an Ipad and I like the ease of creation and modification on the fly. Essentially, I have a database where the master might be many hundreds of fields, or I could create myriad tables and keys - this is irrelevant to the problem. What I would like is to create a solution where at the first field of entry, a dropdown allows for a selection of, say, 10 choices. When that field is filled, depending on the choice I would like a specific layout to appear for data entry. These layouts may have some fields in common with others but never all. Put another way, if I have Item_Field, and user clicks A, I would like the layout for A to appear natively or show up in a portal below. When they click new record, it reverts to the main layout again. I might also need this process to be iterative i.e. several levels down. If this involves CASE scripting, that does not scare me, I just need to know what to look for in the reference materials as to what this process is called. Any help would be appreciated. Thanks in advance.
  4. StanleyPatz

    pc Will FM13 read old .fp7 files?

    I have to dump a WinXP computer for a new Win8.1 machine. If I buy FM13, will I be able to read my old .fp7 files? Will I still see my old report formats? Or is there a conversion routine to be run first?
  5. How can i make a field be required to be filled if another field in the same table has data in it. In other words. I have a date field that if i have a date listed in there i want to have a compliance field be required to be filled. If the date field is not filled it can be empty. Thanks again filemakers! -Erik
  6. jfaunce2

    pc Calculated Value List

    I need to create a value list for a drop down to be able to choose the Graduation Year for students. I'd like the list to include: this year, this year +1, this year + 2, and so forth. I don't want to do fixed values since list will advance each year. Thank you
  7. I'm trying to create a report for a solution, and have hit a bit of a roadblock when creating a report.  I have 3 tables:  1. Statistic Categories     -Each record in the table is a particular statistic code  2. Incidents     -Contains individual incidents. Each incident is coded with a statistic (using a value list, containing values from Statistic Categories table)     -Only 1 statistic code is assigned per incident  3. Reports     -Reports are related to a particular incident, and contain an incident report for the incident.     -Each incident may contain multiple reports   I am using a report format already in use by the company, and need to continue using the same format. The report itself is "hard coded" as it needs to be in the same format as the existing form.   From time to time, searches may be performed to display incident reports for a certain incident date range, or for a certain incident type(s). Based on the reports found, I need to update the header for the report to output a Yes/No value as to whether the found set contains a certain report type. I suspect this can be done somehow by obtaining a count of each statistic category in the found set?  I would appreciate some advice on how to achieve this.  I have attached an example file.  Thanks Matt Report.zip
  8. I wasn't sure exactly which forum to drop this question, but here goes: I would like for my users to be able to connect to a remote database directly from an icon on the Windows desktop. Is there a way to pass in the (remote) file to open to make that happen? Thanks! Ryan
  9. Hello, Â I've been trying to create a server side script that will run daily on a windows 2003 server using Filemaker server 10. The script is suppose to export it to an excel file. (I then what it to be emailed to me, but one thing at a time). It never saves to the file location on the server, i've tried every "filewin" combination I could think of. Doing some research and tried a $variable and still cannot get it to save on the server. Is there a windows settings that may be preventing filemaker server from saving to a location? Script picture attached.
  10. Scenario; I developed a database for  a client that has appr. 7 employees that work in a call center. Each employee is assigned 500 accounts / customers to work. As a default all accounts are imported in the "STATUS CODE NEW"....(SEE SOFTWARE SCREENSHOT- below)....As they work the accounts they change the status code to whatever happened on the account (ie) - if they called and left a message for a customer they then change the status code to (1st attempt) - NOTE: there are 15 different status codes...  Now with 7 employees as they are all working there assigned que of accounts, the status codes are constantly changing within the que...  What I need is a layout that will show how many accounts each employee has in each status code in real time as they are changing the codes ( SEE STATUS CODE DASHBOARD )...   I would appreciate any help with this and if necessary I can arrange a screen-share to show exactly what is needed  Thank You In Advance.....  Lyntech Systems STATUS CODE DASHBOARD_xlsx.pdf
  11. I have a solution that has been working great in testing. Went to move it to the FMS Server (WinServer2012R2) and none of the external data sources are available. Confirmed that the ODBC 32-bit System DSNs are the same on development machine vs. Server but still no love. Anyone have some hints where I went wrong?
  12. We had an error come up on our Filemaker 11 server running on Windows with two machine deployment. Our php apps are generating the following error when we try to connect to the database server: Fatal error: Maximum execution time of 30 seconds exceeded in C:Program FilesFileMakerFileMaker ServerWeb Publishingpublishing-enginephpFileMakerImplementationFileMakerImpl.php Nothing has been modified by IT support or our developers as far as we know. Any suggestions what we might do to reestablish a connection between our web server and database server? Has anybody had a similar situation.
  13. Hello, was wondering if someone could share some insight onto how server scripts handle global variables. I have an email script set on a schedule that, as part of it, moves between layouts. One of the layouts it goes through has a script trigger for OnLayoutEnter that changes the custom menu set based upon username. The 'Install Menu Set' aspect of that script trigger breaks the email schedule and forces an abort. I've tried to work around that by using: If $$Script = 1 Exit Script End Ifin my script trigger. Then declaring Set Variable [$$Script; Value: 1] <email stuff with layout changes> Set Variable [$$Script; Value: ""] in my email script. But, the schedule seems to ignore the global variable and proceed to run through the script trigger, breaking itself. Am I doing something wrong or can I just not use global variables in scripts run by schedules? Any help appreciated.
  14. Has anyone installed .net 3.5 on their FileMaker Server 11 installation? Was it OK or was there any conflicts problems after the installation? We need to create some sort of bridge between FileMaker and a thirdparty program and the developers of the third party program have asked us to install .net 3.5 on our servers so they can create a connector between the two. Many thanks Abdul
  15. We're using FMP11 Server Advanced on Windows Server with FMP11 on Windows 7 or XP computers or on a Windows terminal server. We're analysing the Server Event Log files to look more closely about how the databases are being used. The serve reports events such as 94 - Client "%1" opening database "%2" as "%3" where the % items are replaced with variable information, so %2 might become Parts List and %3 might be engineering. %1 looks usually looks something like Production (TS1) [] Now we recognise (TS1) as the name of one of the computers in our network and [] as an IP address. However the name at the beginning of %1 isn't a name we recgnise - we had expected to see the users Windows Profile Name but some of them are unknown to us - what data does FMP11 Server use to get that name? (There is no external access to the databases, access is only via our internal network and the computer names and IP addresses are entirely valid for these 'unknown' clients.) Thanks Brian
  16. I noticed that the installation of the web technology in FMServer 13 has created a new site "FMWebSite" in IIS, and that I had to stop the current/default site in favor of this new one. How is this going to work if this needs to be installed on an existing website? I couldn't find any documentation from FileMaker on this subject. It looks like I will have to move all of the web files to the 'new' default folder (FMServerHTTPServerconf), or change the default path for the FMWebSite site? Would there be any problem to changing the default path in the IIS Manager? If you've noticed anything else that would be helpful in this particuar situation, I would be appreciative of any advice.
  17. Hi Am running FMS12 - I found the post regarding server import export and have followed these instructions. http://fmforums.com/forum/topic/64713-server-side-imports-and-exports/ However the script that I set up to import a file is failing, I believe this is because it is not finding the file to import, although I get no error only a time out, and given the test is for but 100 records am certain that it is not because of inadequate time to run it. I have tried: Setting up a variable to Get (DocumentsPath) & "[filename].xls" Have added "file:" and "filewin:" types to precede that so "file:" & Get ( DocumentsPath ) & "Kinds.xls" and "filewin:" & Get ( DocumentsPath ) & "Kinds.xls" Have used the "Get (DocumentsPathListing) to gather the files in the documents folder and used the explicit path to try to import from that. Alas to no avail. Noted that the directory uses back slashes not forward slashes (as the documents path listing shows) when I view this in properties, so I've even tried the path from there. Am exporting fine into the directory using the same variable, was then hoping to switch to another layout and import the same records back in, works fine on standard FMP, but just can't get it working on FMS. Any ideas would be gratefully received. Thanks
  18. Hello Everyone, I'm having a hard time working out how to do a search and replace. How I have my FM project set up is; I have three tables. The first is Staff, it has these fields: id, staffID, firstName, lastName, fullName (caculated). The second is Assets, it has: id, staffIDFK, dn, make, model, etc... The last is Resources, it has: id, staffIDFK, assetsIDFK, addItem. What I have is on the Staff page I have two tabs, the first tab shows all of the staff members information, the second tab has a portal showing all assets assigned to them. Above the portal I have a field(addItem) from the Resources table and a button. What I'm trying to do is have the ability to type in the DN into the "addItem" field and press the "Add" button to add the device to the current Staff member. DN stands for Device Number specific for each item, its like the id for the item but I was told i should always have an id field in each table. How I was hoping the logic would go something like this: If (content from Resources::addItem is found in any Assets::DN fields ) Check Asset to see if Assets::staffIDFK is empty If NOT, Message box: "Currently Checked out to "Staff::fullName" do you wish to add anyways?" Yes/No If YES, Set Assets::staffIDFK to Current Staff::id Else if (Resources::addItem is not found) Message Box: "No Item Found." I really hope this makes sense. Thank you for your help in advance!
  19. Hi people, (I'm new to filemaker in particular) I'd want to build a database and have it hosted externaly and let as many users as possible access it online. My question is reading a specification detail about a 100/250[ theorical ] limit of simultaneous users connected at an exact same time: - Is there a limit for the qty of "registered user" i.e 250 ? (that is user 251 could not register even when noone is connected) or will I be able to let some10.000+ users register a new account and my database will be accessible as long as there is only 250 connected at a particular moment ? *Note I am not too concerned about this 250 numbers in itself since I believe it's high enuff for my present need. I am more concerned about any possible FM built-in restriction policy. Has anyone here experimented this over 100/250 qty of users logged in (or accessing a particular file) at the same time ? Thanks for your sharing your own experience here, Eric
  20. Fairly sure the issue is localized to the one client, but I cannot find the issue. This one newly installed client cannot see the files remotely hosted on our server, the other 400 clients have no issues. I've confirmed it is this one PC my installing NMAP on the client and scanning the server and it can see port 5003 open on the server. I've went even further and installed Wireshark on the client and filtered the server IP and tried to connect, wireshark showed no communication with the server, not even an attempt. This leads me to believe the issue is 100% with the client, but I don't know where to look or what to try. - Bonjour is installed - I can ping all of our servers with no issues I found one snippet of information that might help me: http://help.filemaker.com/app/answers/detail/a_id/5493/~/cannot-see-hosted-database But I could not find the resource they were talking about. Right now any help is appreciated.
  21. Hi all, I'm new here so I hope I get everything right. I've done a search already, but I can not find my issue listed. Sorry if it's been covered before. OK, here goes..... VMWare Server running on HP Prolient G7 tin 2 Virtual Cores 4Gb RAM Windows Server 2012 R2 DataCenter x64 IIS v8.5 (Default for 2012 R2) FileMaker Server 12 FileMaker Pro 12 Advanced with Bonjour JRE v7 This is a brand new build specificity for this use. I've installed FileMaker Server 12 on to the above setup with Custom Web Publishing using PHP I followed the deployment wizard and deployed for a single machine setup. I allowed FMS to install the provided version of PHP with it's own configuration. There is NO SSL configuration on the server at present. The admin console shows three green ticks to indicate that everything is happy. However, when I run the PHP Custom Web Publishing Test, I get the page displayed correctly, (PHP is working) and it identifies the name of the server, but below the main information box, I get the following error message: The PHP connection to the FMServer_Sample database failed. The PHP test was not able to communicate with the Web Publishing Engine. Make sure you have PHP publishing enabled and the database has the fmphp extended privilege enabled. (Error 22; Unknown error) The sample database is installed and it is listed in the admin console, status, normal and dots across the line. I can't imagine that it wasn't installed with the correct Extended Privileges for CWP and I would not be 100% confident to know what I should check for. I am viewing the CWP Test webpage on both the server and a client and getting the same error message. Can anyone suggest any further areas that I should be looking at? Cheers in advance, Barry.
  22. Last week I did the FMS upgrade from 13.0.4 to 13.0.5, and my database has stopped providing an XML feed that worked for a a few years (and that powers one portion of my organization's Web site). I'm going to append all the information that might be pertinent. First, what I've already done: - I've Edited Deployment, asking it to enable XML. (First asked it to turn off Web Publishing, then a second pass to turn it on again.) I've then gone into Web Publishing and asked it to enable WebDirect and PHP (just wondering is that would kick-start a process). - I've run iisreset /noforce from the Windows command line. - I've rebooted. Also, I have a static IP on this machine, but in its interface, it provides what looks like an internal IP address. The next thing I guess I'll do is call support and/or reinstall, but I'm posting this to ask for related wisdom. I will mention that since we moved into a new building a few weeks ago, I've been haunted by connectivity problems - some folks get kicked off a couple of times an hour. I think that's an internal problem related to hardware/cable (since I was able to connect remotely from home and remain connected for 24 hours), but I mention it here in case it seems germane.
  23. Hi, not sure this is the correct forum we have a calc field for our Invoice total ... Sum(inv_invitm_InvoiceID::Total Sell Price) + (Amount Imported/1.1) ... which is the sum of all the invoice items records + the value of the invoice total for all the old invoices imported prior to starting with FM Our file is hosted in Brisbane with nightly backups to my office in Sydney So all works fine then one day doing a find on the cacl field only finds those records where the search value = Amount Imported .. it won't find any invoices where the Sum of the invoice items = the search value However, the Find still works correctly on the overnight backup files !! the hosting mob reboot their server and it's fine again .. for a while then it stops working again anyone ever come across this ? the hosting mobs can't work it out .. they host other company's files and haven't had any reported probs ? .. so far it only seems to be a prob with that field, although most of the time our finds are not on calc fields thanks Cate
  24. Hi, As we know that we have option to configure FileMaker Server with PHP (which is installed on IIS).. Like the way.. I have another question.. Do we able to configure FileMaker server with PHP Which is installed on Apache (with Linux machine).. Please clarify.. If you already experienced please help us to configure Filemaker 12 server with Apache.. Many Thanks ~Guru
  25. We are a summer camp and will be deploying Parent Accounts through IWP and would like to use port 591. The problem is I can't figure out how to configure Filemaker Server to listen on port 591. Port 80 is being used so it makes sense to use the alternate - but how?? The firewall is configured properly to port forward 591. We have no problem accessing the IWP database on the LAN using port 80 (haven't been able to test outside yet - as I stated above port 80 is in use) but when I change the port in the IP address to 591 - http://LAN.ip:591/fmi/iwp/res/iwp_home.html - nothing. I have searched but I can't find where to configure ports in Filemaker Server. Here is what we are using: Windows Server 2003 - latest SP & build Filemaker Server Advanced 12 - latest build Thank you! Jim

Important Information

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