DDDan

Hi Wim and Ocean West thanks a lot for the feedback. (and sorry for cross posting, but I like both forums) I'll take all these points into consideration. I see the pros and cons of both options, and tend to lean towards two separate files. I just wanted to know if FMP itself would kind of force me to this decision due to technical limitations, but that is not the case. And that is good to know. They are not in a hurry, so I have the time to give it some thought. Thanks again, Daniel EDIT: sorry, I forgot to mention that in the other forum someone pointed me to this page: https://support.claris.com/s/article/Technical-Specifications-for-FileMaker-Pro-18-Advanced

Hi, maybe not totally the right sub forum, but I couldn't find a better place... I have a client with an already complex system (60 tables, around 6000 fields total, 477 relationships, 1315 scripts, 400 layouts, file is 900Mb) and he is now asking to add a quotes module, which, due to the technical nature of their business, will also contain a lot of tables, calculations and relationships and so on. Before I start building this quotes module I would like to know if there is a limit to what you should or can put into one file. I'd prefer to keep everything in one file because some tables in the main system will be used in the quotes system as well, but only if this is advisable. So if anyone knows anything about maximum relationship or table count, I'd like to hear from them... Thanks in advance, Daniel

Hi, I am familiar with the send mail script step. What I'd like to do is include the first an last name when sending an email. In that way the receiver can choose 'add to contacts' and the first and last name plus the email will be added to contacts. If you make a calc field with firstlastnamefield & " <" & emailaddressfield & ">" and copy and paste the contents of this field into the 'to' field in Mail, it will include the first and last name together with the email address. However, if you use the same field in the script step Send Mail in the 'To' field, it recognises the email address, but skips the first and last name. Any idea how to make this work? Thanks, Daniel

Hi Comment, Dont worry, I'm not a native English speaker and in my language 'but' is an overused word that can connect almost anything in a sentence. Unfortunately (?) language is not like code, where you get a syntax error when you do not express yourself correctly... :-)

Yes comment, for some things I agree. But in some solutions there are typical values that need to be user adjustable like start of high and low season of the current year, nominal accounts for for invoices, allowed book years/months, default payment book, etc. Some of these might even differ from user to user. I often end up with a settings table with one record for general settings, and a user table for user preferences with a record per user. (Like default go to list or form view, open some tools in separate or main window, etc.) Dan

Its not so much work to avoid that people create extra records by using a custom menu. And as an extra in the startup script you could verify if there is only one rec. if not, it omits the first, and deletes the others. It can also check if the other unlikely scenario happens: the one record that should be there gets deleted. (With a custom menu this is easily avoided, but still.... You might have done it yourself in admin mode) In that case the solution can ask if it is starting from a clone, and then it can create a record and prompt the user to fill in the needed info... Custom menu's are way to go in general. For me its standard to script new, find, delete, etc. Gives you great control over the user experience.

Idea is good, just dont use globals but have only one record in Settings and use 'normal' fields....

Hi again, discovered some things you might find good to know... I've got it all working in Yosemite, even after I installed the server tools. (leaving web services off) That all works. There is however a new screen in server tools called 'access'. It is like a port based firewall where you can define through which ports access is allowed to the server and by which users. As soon as you set something in that screen it apparently enables this firewall and from that moment on web direct stops working. Hence the 'connection refused' message. So for now I went back to a backup of the system without the server tools. Another thing I discovered is that in Yosemite you can get the message 'Another copy of FileMaker Server is already running with this license' after you've manually stopped the server in the admin tools. The message is a bit misleading, it is not running twice, the server just lost it's license details. Re-entering the license details immediately enables all services. weird thing that didn't happen in Mavericks, but started as soon as I had updated to Yosemite. (this was after formatting the drive, installing a new system and FMS 13.05, nothing else, and upgrading..) The joy of computers! Daniel

Hi Claus, Really appreciate your efforts, but I formatted my drive, installed Mavericks (for now) and am installing FMS updates one by one. First deployed, tested if everything works, and it does, and now make a full disk image backup before every next step. (this is how I work for clients, but for my own server I tend to 'live dangerous', but lesson learned ;-) Haven't installed server tools yet, first make sure that FMS is working with web direct. Once everything works and I have backup I'll update to Yosemite, and last step is the server tools, but now I can always go back to my backups. And yes, I know Java 7 is the supported version, but if everything fails, you tend to try what the British so nicely call a 'drowning man's solution'. In the past, with <FM11 often updating Java would fix weird connection problems. But I think my OS was really confused, at a certain moment when I started FMS admin it would say that the same serial number is already running on my server... Really weird, because I know you need to stop the server before any update, and otherwise the updater won't let you. Wouldn't know how to start FMS multiple times on one server! But I've learned a thing or two from your input, and I keep all these tips and good to know unix commands on file for the future use. All the best, Daniel

Hi Claus, OK I tried the launch service and graceful commands, stop ams, restart, etc. did not help. Then I de-installed FMS completely, removed everything that the uninstaller does not remove manually, restarted, installed the whole thing from scratch, re-installed, same thing happens. (connection refused on port 80) Guess there is something wrong somewhere else in the OS. Updated Java, etc. but no way to get it to work. (this is all with OSX web Server tools switched off) Guess best thing is to do a fresh install of Mac OSX... Thanks for your help.

Hi Claus, Today I went through your documentation and tools. But the more I read it, the more I had the feeling that this was far beyond what I need. Thing is, I do not use OSX Server for hosting websites, and I keep the website services switched off. I mainly use it for VPN, proper file sharing, and testing. Having said that I tried to go through your instructions, but stopped somewhere halfway when it was mentioned that I needed to have the documents for the virtual hosts in the right locations. That is unknown territory for me. I would just like to know why FM web direct does not want to start, and if there is a 'relative' simple way to make it work, keeping in mind that the only web service I want to host, is FM web direct. (don't mind modifying http documents or terminal commands) As explained I am doing this on my test server at home, because before I promote this technique with clients I want to be sure that it is manageable. But I have my doubts... I hope you have a simpler suggestion... ;-) But anyway thanks for your help...

Hi Claus Thanks a lot for your quick reply and help. I just downloaded the mentioned document. I just wanted to say a quick thank you and will let you know how it goes. Might take a couple of days, this issue is on my home server which is there for testing, and coming days I am out working for clients. But I got something to read ;-) Just for clarity: I first installed and deployed FMS13 before I did anything with Apple's Server Tools (AST). I hadn't even installed them because I know about the issues between FMS and AST. Only after trying everything with FMS13 (de-install, re-install,etc) I could think if I wanted to see if AST would enable website hosting. Thanks again, will revert back with hopefully good news in a couple of days! Daniel

I had to update my FM Server Mac to Yosemite and I cannot seem to enable web services. During deployment I get the message: Test web server (http://127.0.0.1:80/fmi-test/test.xml): Connection refused (Please note that this is different from 'ports are in use' which is the other common error;-) I can install and deploy FM Server 13.05 without a problem, I just can't enable web services. I did a lot of testing, de-installed, manually deleted the Library-FM server folder, etc. Re-installed, etc. (when I re-install I did get the message port 80 and 443 are in use, and did choose disable web sites) Also tried port 591 as suggested by FM, same error. (also tried 8000, to be honest I don't care on which port it is web serving, I can remap that in the router) The problem seems to lie in Yosemite switching off access to port 80 (and others). I also have Apple Server Tools so I tried the following: I switched on Web services and then I can access the ports on my local network and you get the default website. (before somebody warns me that I shouldn't use Apple Server, I first tried to get it to work without Server tools installed. And when I was still using 10.8 they co-existed very peacefully, as long as you did not switch on Apple's web services, I need them for some other stuff) When I try to deploy FM Web direct while having on Apple's web services, I get the correct 404 error because the ports are in use (by Apple's web services) When I switch off web services again then I get error 403 (instead of connection refused) but that means almost the same. (forbidden) When I then try to access port 80 from my local network it says 'websites are turned off'. kind of suggesting that the ports are closed on the server now. Please note it is not a firewall issue, I am deploying FM Server from the same mac as it is running. (localhost) I have no (software)FW enabled on that Mac. I guess I am looking for a unix command to tell Yosemite that it should allow access of ports 80 and 443... Any suggestions, work around, unix commands are appreciated... I have wasted almost a day now... Daniel