ZPData

Hi, I have a newly setup FMS 19 machine on Mac Catalina. I would like to install FMPA 19 on the server machine to "remote connect" on a very occasional basis. I have done this with earlier version of FileMaker many times on many servers and works fine. Obviously, not to make this a workstation but it is useful for testing things sometimes. So, when I do this, I get: Conflict is with the server. So I am "conflicting with myself". Any ideas? THANKS. - Chris

FYI, to anybody reading this, I did try the SendGrid instructions and they are fairly simple - Base64 Encoded "apikey" and then the API key but it just doesn't work so I gave up on SendGrid. Bottom line is that SendGrid is VERY focussed on API implementations and just far more hassle than worth it. I was successful with gmail and creating an app password.

Thanks. I guess I'll just have dig into that....

Hi, I am a developer with a number of clients and I look after about 3 servers. As part of this, I have used SendGrid as an easy, free SMTP sending server. Has worked fine. Here I am just talking about sending with Send Mail script step -nothing complex like the API. I am thinking about sending both from scripts (so Send Mail script step) and server itself (FMS error messages etc). SendGrid is now enforcing two factor authentication which is problematic as I have used a number of SendGrid accounts in different places. I have read one can use Google's with an app password but what I really want is something that has these characteristics: - I can set it up myself without having to hassle my client for anything (like their Gmail credentials). - Separate from my own Gmail. I am not sending Spam (mostly things like order confirmations) but I wouldn't want these things on my main account. - Something where I can have multiple accounts if necessary. SendGrid used to deliver this but now it is all getting more complex than I think it should! Anyway. Anybody have any ideas about how best to do this in 2020 now that everything is getting more and more locked down. THANKS. - Chris

Hi, I am going to be doing a mini project with FileMaker where an excel sheet is going to be distributed to bidders for some work. My plan is to then import the data from completed spreadsheets into FileMaker using Scribe. The Excel sheets aren't going to be the most complex Excel ever but there are some special things. So, we feel we need an experienced Excel person to take care of that. So, we are looking for recommendations for an Excel consultant who might be able to help us out. Ideal person is: -Based, like us, in the UK. US is OK though. -Able to stick around for bits and pieces as we go along over the coming months (and maybe years). The project is very much a developing thing. THANKS for any recommendations. - Chris

I solved the problem. Wasn't corruption. I had a script running for the "Today" FileMaker 6 problem. This script updating 300k records every night (server side script). I had introduced an audit log into the databases and the logs were increasing by 1GB / month. See https://www.excelisys.com/fm-tips/filemaker-pro-13-tip-n-trick-easy-bake-filemaker-pro-13-audit-trail/ Amazing how tiny log additions (100 bytes maybe) added up to 1GB per month.

I am 99% sure it is nothing to do with containers. There is nothing going on with containers that I am aware of. There is no storage going on of anything in containers... I have compacted which cuts down by 1.5GB. I have recovered. There is a long standing issue on recover (which we are ignoring and continuing to use the unrecovered file). The file when recovered is the same size and compresses the same as the unrecovered file (so recover is not fixing the issue). My next move it to delete tables in a copy of the database and see if a particular table has a big effect.

Done!

I have a similar problem with a .fmp12 file. Did this problem get solved? The problem is described at: https://community.filemaker.com/thread/152862 THANKS.

Chuck, THANKS for posting this. I may have the same problem. I am using anchor buoy with abbreviated TO names. In my case, I see 3 solutions: -Rename my anchor TOs to match table names but I don’t like this. I like my abbreviated TO names for anchor buoy methodology. (e.g. I don’t want to rename INV to invoices). So this solution is no good. -Introduce new TOs with the table names. I don’t like this because it will clutter up my TO lists when assigning fields etc etc. So this solution is no good... -Rename my tables to match anchor TOs. This I could do but I am reluctant. I like a more fulsome name so I can remember. Still I guess this is the best of the options available. Also an interesting point is if I do any of these things I now have to be careful about renaming things… So we have the “rigidity” of SQL ending up in FM because of the use of ExecuteSQL… ditto for avoiding SQL reserved words. No big deal I suppose but an interesting observation. -Chris

A few things I would add to this: -There are two format changes to make in the upgrade from FM11 to FM12 is pretty hassle free so really the only problem is the change from FM6 era to the .fp7 era. -The actual problems encountered in this depend greatly on what your solution is actually like. If it is a simple solution then it can just be converted and will mostly work correctly. I recent converted a very large solution (30+ files) and I followed the whole MetadataMagic route with pre and post conversion tasks. I found a number of issues this way but I could have also just take the approach of just deploying it and seeing what happened. I believe this was possible because the scripts and relations in this 30 file system were very simple. So, I just wanted to say that I think you may be able to upgrade without that much trouble. Just try it and see That said, I do have a license of MetaDataMagic and would consider working on your files on a consultancy basis if you wanted. MetaDataMagic gives you LOTS of information. Good luck with it. Best Regards, Chris Van Buren e: chris@zeropointdata.com FileMaker 11 Certified Developer - FileMaker Business Alliance Member ---------------------------------------------------------- Zero Point Data Ltd. www.zeropointdata.com t: 01291 689966 f: 01291 689977 Abbey Lodge, Tintern CHEPSTOW, NP16 6SF Company Registration: 06478212 VAT: 930 3069 50 ---------------------------------------------------------