Upgrading & Migration

Hello! I would like to call on you fine guru's for some advice! I work at quite a large company in the UK, we're currently running FM Pro 12, but pay the license fee and obviously have access to all the latest versions. I am just wondering how much of a "big job" it would be to switch everything over to FM Pro 14 or 15 (we have access to both) and what implications, if any we may encounter? Sorry if its a silly question, I just cant seem to find a good answer anywhere about this. Thanks in advance.

Hi, I have been given the task of upgrading and improving our solution at work which consists of 9 files. I've started by identifying the problems such as data loss or unexpected things happening and have focussed on one file to start with. In an offline file I have made my changes and the file is much more robust and easier to use but the problem is I've made changes on the relationship graph so the data is broken. This is not a major problem as because the data was incorrect it would have taken too much effort to fix but what we would like to do is archive the data, kind of like take a snapshot at which the data can then no longer be changed but can be viewed for tracea…

At my small legal practice, both my paralegal and I access an FM database (v13, but .fm12) hosted by a hosting company (ODI). Currently each of us access the database with an FMP 13 client. I will be migrating to FM 14 (kicking myself for not buying the buy one get one free back in Dec). I typically do testing on my Mac, before upgrading hers. Therefore, is there any issue with me accessing the database with FMP (or FMA) 14, and her with FMP 13? I'm thinking not, since the database is still the same. I'm not upgrading the database to use any FM14-only (UI) functionality until we're both upgraded.

Hi, I thought you could drag my older 12, 13 solutions over the FM 14 icon and convert the solution to have the FM14 extension. However, it only opens the older FM solutions. I am concerned that as FM advances is versions, Older FM Solutions may not open as the older versions get further away so I was hoping I could just drag and drop the older solution onto the new FM version and update solution extension so I can keep my oder solutions updated and I won't have to redevelop the older solutions. Is this possible ?? Thank you. Tom

Hi Forum! I'm going to upgrade from FM Pro Adv.12 to FM Pro Adv14. I've done plenty of research (probably not enough) and was wondering what would be the best/most practically way to approach. 1. Should I do a complete rebuild? I've had a few crashes seemingly unrelated to my file. Briefly in 12, any file I create, if I try to change the toolbar icons, it crashes-even a brand new simple file (no scripts, anything) However if I use a starter solution or any file anyone posts, and change toolbar icons, it doesn't crash. Same crash scenario if I have the data viewer open, in layout mode with a script open-and put a formula in the data viewer and select 'Monitor'.…

Hello! Although I used FileMaker 3-4 years ago to build a nice database to organize my material, research, and notes for my creative writing projects (and I still use that same database today), I haven't actually built anything new in FileMaker since then, so bear with me! My current objective is to create something that approximates a merger between the 'Starter Solution – Contacts' and the 'Starter Solution – Content Management' templates. The 'Contacts' starter solution template is a pretty great foundation for what I need in order to organize personnel because I'm doing a pretty large project wherein I will be working on a variety of smaller creative …

I have a client that was just converted from a FM 5 solution to FM13. Their solution had some 60+ files in it. With the new (from 5 anyway) security accounts in place, they are finding they have to log in many multiple times at different places. Frustrating. Is there a list of best practices for combining those many separate files into one or two? Or better ways to clean up the login issues? Thanks, Justin

Hi guys i am fairly new to fm. I use fm 13 as a client to access fm server. We have 18000 customers / unique ids in the DB as a crm each entity has has a series of tiers associated for opt in programs. I need to find a specific 700 of them by surname and make one change in the field from "inactive" to "active" I have their names and details in a csv Obviously I could search individually ale the change in the form, save and repeat. But could I somehow drop all the names in and get the 700 and make the changes from the table field. Is there a better way to achieve this many thanks

So i've got an active fmp7 database running on a 9.03 server... The hardware is already years passed its expiration point, and (due to that annoying java issue) I don't think I can install it on a newer OS model.. Am currently running on Mac OSX 10.5, and can't seem to get the Admin software to work on 10.6 in any usable way.. So my plan: utilize a new(er) server with FMS 14, install it, and use it to serve the older FMP file.. I've been told that a newer server will handle older files (as long as I don't change them import them into a newer FMP app and re-save them). Is this path good, bad, or just plain impossible?

I can't seem to find a link to upgrade from FMPA 13 to 14. Is there no longer a way to upgrade or am I missing something?

Hi I hope you can help me out of a big CRISIS I have been running my business accounting and invoicing system on on FM Pro 6 for the last 6 years I recenty had abig system crash and we upgraded to system OXS 10.10 from 10.6.8 installed FM pro 9 and now i cannot access any of my old files which i now need for a Government audit Evert time I try open a 2009 invoice I and asked to convert it ..which I do but when i open it it is requesting my OLD password and ACCOUNT name ..Unfornatley I no longer have it Any suggestion how to access my old files You soonest attention would be appreciated

Hello, All! I am an aspiring developer for Filemaker. The company I work with is stuck in the past working off of Filemaker Pro 4.1 I was given the task of bringing us up to Filemaker Pro/Server 13. So far my conversion prototypes are successful but we recently had a layout issue that can only be fixed in versions 3-6 (as the file is an .fp3) I work off of a macbook while our network is all Windows 7. In order for me to repair the layouts without tampering our active database, I decided the best option is to repair a copy of our solutions off the network. Unfortunately, when I go to download the trial version of Filemaker Pro 6 off of the respected website, the file i…

I am new this FileMaker. My company has been using it for years and had FM6 for PC. We have recently switched everything to Mac and purchased FMPro 13. I need to know how to get all of our information (data and forms (layouts)) into FMPro13. I have figured out how to get the data over after converting the files and moving them to our server and then converting them again to import into our Mac system. I can't get any of the previously created forms/layouts into FMPro. We have business contracts pre-printed and use the data from FM to add the customer details when we print. I am not tech savvy and need some serious assistance. I have been trying for 3 days and w…

Hi, I tried to find the web page were I read the following, however I have been unsuccessful. A statement was made basically staying ... If you want a painfully slow experience hosting a solution; migrate your FM 12 solution to FM 13. I have customers using FM 12 moving to FM 13 including myself, we are not redeveloping their solutions and I was wondering if there is any insight here. Not really sure how best to ask this question, I guess more feedback if nothing else of other developers who may have had experiences with issues related to their customer were I maybe better prepare myself. Thank you. Tom :-)

Does anyone know if there is a problem using FM10 Advanced to develop solutions while runnning WIN 7? I've been retired for a few years and supported one (ex)-customer using WIN 7 with no problems making minor mods. Recently, I got a request from my son to write a fairly trivial DB for his business. I've had funny glitches like a double-click on a button not letting me edit the button's text; closed the DB and re-opened it - no worries! Today I nearly went insane trying to get 'Constrain Found Set' to behave! On top of that, my memory isn't what it used to be, so when things do not behave as I think they should, I wonder is it me or the FMP/WIN7 combination or a…

Hey all I've moved my database onto a different computer, and the database contains secure, externally maintained containers. The transfer of the containers completely failed, and now my containers contain a "missing file" reference. The secure data is on the new computer, but FileMaker is failing to see it when I've updated the connection folders. Is there a way to fix this, or must I re-import the container data for each individual record? UPDATE: Ok, sigh of relief, I managed to restore the database on my original computer, and all data integrity is intact. So this brings me to this question: What is the best way to transfer a database with secure, extern…

Hi - I have a runtime solution that I will be upgrading. The new version will have several many to many relationships where previously there were many to one. So I'll need to populate the new Join tables with data to correspond to the previously existing instances in the earlier version. I'm thinking this must be a fairly common thing to do as one realizes the need for more complex relationships and additional entities. Is there a well-known or standard way to import the old data into the new configuration? Thanks, Michael

Hi folks, I'm going to roll out my database to another user in the next week or so. I've solved a few problems to do with this, but it would be good to see what I've overlooked! Auto serial numbers - I'll need to add 1000 or something to theirs so we don't clash when we merge data. To update the solution I'm planning to create a clone, copy it to their computer and copy their records to it. - this seems to be the most beginner level way to do it! (will this actually merge out data, or would I be better of creating a blank clone?) At the end of the year we'll hopefully have wifi so will be able to use common data through a server solution or separation. What'…

In order to (cheaply) have my FM solution hosted, I need to combine 12 files into one. I am using v12. Some of the files are quite large (over 100Mb) and most have lots of relationships, value lists, scripts but no custom functions. Very complex. It seems that there is no automatic way to do it but is there a step-by-step for v12 since links will be broken if I do it incorrectly. Help please! Happy to upgrade if that will help in any way.

Hi, We have a FMP Server 11 and a FMP 13 version. We cannot upgrade the FM Server 11 to 13. We need to get FM13 data into the FMServer 11. Are there ways to accomplish this ? - Export records script from FM13 - ODBC connection between FM11 and FM13 ? Thanks for looking into my question.

Just got off hour long call with FM support, recommended I post in forum. Forced (Mavericks upgrade) to FMPro13 broke an old Filemaker-supplied inventory/invoicing program I have used for years. Structure, basically, 7 connected db files: People.fp7, Products.fp7, Invoices.fp7 etc. called with Menu.fp7. Had upgraded numerous times before, didn't break.... This time did normal conversion (to fmp12). Basically, broke scripts. (Did one pass of remapping external data sources. Worked in some cases, not in others.) Just too much for me to track down so I think I'm looking for someone to take it on.... but any thoughts welcome. Seems to me I have tried to ex…

I have an old FM3 application for an agriculture program that has been migrated to FMP11 via FMP5. In the app there is a record layout in one file (Exhibitor) that includes a portal allowing modification of related child records from another table in another file (Animals). There is a button in the portal layout to take a user from the portal in the Exhibitor layout to an Animal layout in the Animals file, showing the record from the Exhibitor's portal. The script fired on the button click scrolls the records in the Animal file to the current record in the portal, then runs Select Window to switch focus to the other layout, with the fields populated with that record. …

According to Filemaker's Help pages, Filemaker 11 is not supported and not tested on Windows 8 http://help.filemake...11308/related/1 This may prove to be an issue for us as we are currently on FMP11 and are not ready to migrate to FMP12. Does anyone know why FMP11 is not supported - does it not run at all, or does it run with some known issues? Thanks Brian

Upgraded on Dec 3. Simple flag fields (yes/no) no longer visually show flag status, even though they function properly - these check boxes remain empty at all times. The color scheme for highlights, check boxes etc has changed. The field and text formatting has also changed. Text, auto entered through scripting, now has shortened field bottoms and narrowing of text fields. Some scripts default to the wrong tab on a layout. These are just a few of the issues presented with the upgrade. I don't know what other issues may be found as I use the file more fully. So my question is: re-write the whole database or spend the time fixing the current one.?

Hi I have a FMP 12 database. I have an older MacPro G4 running OSX 10.5 and it looks like FMP 10 run fine there. So instead of just collecting dust i think it could be useful for this database. But the problem is, can i downgrade from FMP12 to FMP 10. Is it even possible? The FMP 12 file has many scripts and calculations and also relations so i really dont want to start over from the beginning. Any suggestions? Thronborg

We have many legacy tables that were setup before FM took all tables into a single file, and wondering if it makes sense to combine them. Business is finally beginning to look better (after many years), so we want to sharpen our office procedures. Examining our FM solutions is part of the procedure. I don't recall which version that the all-in-one capability was added, and I remember seeing at the time discussions of the pros and cons. Aside from the aesthetic issue, and convenience of having a combined datafile, is there an advantage to combining tables? We would have Proposals, Addresses, Invoices, etc, all existing now as separate data files. And secondly how w…

Hey Guys, After I upgraded a few of my databases from 11 to 12 (and accessing remotely), I seem to get sorting records dialog boxes when navigating through layouts in layout mode. Show sample data is not enabled, so just wondered why this is happening, and if I can avoid it at all? Since upgrading from 11 to 12 editing/saving layouts/viewing layout lists seems lag. I also get an occasional connection lost, without the server or internet going down. Any help on the above would be greatly appreciated. Thanks, Dan

I have a solution that allows the end user to upgrade their own database. Basically I send them the new file, they run it, and it pulls in the old data. With FM12, I suspect that this workflow may no longer work. Is it still possible, with FM12, to import data stored in an FP7 file (i.e. via script)?

Hi.. i used Base element plugins I m trying to enabling it on client m/c On server side i enable this plugins..nd restart the server. but still its not visible on client m/c please help me Thanks..

I'm somewhat new to FM but decades old to programming (Fortran, anyone?). First question: I have a Windows FMP database in FM 8.5 (file type "fp7") that needs to move to Bento on a Mac. Is there a path directly from fp7 to Mac Bento or do I need to first upgrade to FM 11 or FM 12? Second (related) question): My customer is already involved somewhat in Bento on the Mac. Is there a path to get his files *back* to FM 8.5? If not, is there a path to get his files back to FM 11 or 12? Thanks much for helping this novice. Tom Fuller

Hello, I recently migrated a FM11 database to FM12. I haven't noticed any hiccups the past few months until I tried to create a container field that has interactive content. I'm wanting to view PDFs in the container field. When I mark the container field to "optimize for interactive content" in layout mode, the Insert Menu does not display PDF or Audio/Video after selecting the container field in browse mode. However, if I create a new database in FM12, the interactive nature of a container field works as expected. Could this be a problem with the conversion? I have tried creating new container fields in a few different tables with the same results. The file is host…

HI ..i want to import partucular record only from file means when dabase's field(job no) match with csv file(Job no) then add csv file's record in db ....not all records from file .....how this thngs can be perform...??

I'm not sure if this is the right place to make this post but I couldn't find anything that sounded any closer than here. Some time ago I remember reading a post, I think by Ender, showing the 1, 2, 3's of how to take part of one solution (tables, fields, relations, layouts, Value lists etc) and move it into a different solution. I seem to remember part of it but remember there was in fact a 1, 2, 3 way of doing it and hope you can help me with it. I have FMP 12 Advanced and use a Mac. Thank you. HJ

Hi Everyone, Very soon I'll be transferring files from FM6 to FM11. I'm using some external plugins and expect some work to be done to transfer all files. I was wondering if it's possible to run both versions of FM alongside each other so I can take a couple of weeks to get all my files in order again? Thanks, Peter

Hi All, My client has given a set of filemaker files which are "FP7" extension.I'm trying to open these files using "FileMaker Pro 12",after the file is converted to FMP12 also i get errors saying "either the host is not available or the file is not available on the host." Â Can anyone please help me. Â Thanks, Rajee