Upgrading & Migration

I orderd FM8 upgrade since we had FM6. So now I have software installed on 8 computers and I find out that you can only have 5 concurrent users. We have about 6 files that we need to share, at least 3 of them are used by all 8 users all day. I see that maybe server would have been a better choice for an upgrade, but I have already spent the money on FM8. Am I understanding that I have to buy the full version of FM 8 Server to upgrade my 8 users from FM6?

In a perfect world, without regard to cost, what software, or tools would make upgrading/migrating from FM Pro 5/6 to FM Pro 8 Advanced the most efficient and comprehensive? Advance thanks for your thoughts!

Well, I design using FM Advanced 8.02. Some of our stations are 7.0v3 and some are 8.0v2. And we are using FM Server 7.0v4. I know they all work together. My problem is when designing. As I'm learning these new features, I keep wanting to use them! Management has 8.0v2 stations. There are a few features (such as Send/Save As Excel) I'd like to use for them. But before I did, I want to make sure that will work. My thought is that the button can check Account (stored in a global at login) and if they have vs. 8, fire the script; else produce message saying nada. But I'm also unsure on which features Server 7 will accept! I wish I had a list of all new vs. 8 f…

If I install vs. 8 will it automatically update my existing database I have in vs. 6? If NOT, then if I have vs. 6 and another person in the office gets the new vs. 8, can I transfer a clone of my database to that new person and they can use it? In other words, will vs. 8 accept a vs. 6 database? Thanks!!!

I had this discussion tonight with a SQL guy and was told that I was a fool to use FM because it was a snigle threaded based app. vs. SQL which is a Multi-Threaded based app. What defense can I provide to this?

I would imagine many have had older solutions that they wanted to consolidate under the new table system in one file. I have foole around with doing this a bit and have found that if I simply import the file as a table, I lose any links to that file (IE: Any lists that were based on fields in that file for instance). I have looked at FMRobot but cannot see from its description that it manages to preserve all previous relationships (In fact, it's description implies it does NOT preserve relationships) and links in the table that once were directed at the external file. Anyone have some real world experience doing this that can provide some insight? I a…

I converted my .fp5 files to .fp7 and I am hosting these files on FM Server 7. Does anybody know why my find requests return zero results when i am trying to find data in a calculated field based on a relationship? When I move all dbs to my harddisc and open the files locally (FM pro 8) all is good... Any help very much appreciated!

Hello All, I do all my development on Mac. Once the project is done, I then take it over to the windows side for a test drive to make sure everything looks and acts correctly. I have just moved over to the windows side with a fairly involved solution. I would rate it as the most complicated solution I have ever done dual platform. I am seeing a HUGE performance hit on the windows side. I have tried optimizing on the windows side, but this did not improve the situation much. Any tips/suggestions on getting the most out of this solution on the windows side? NOTE: This is still a filemaker file, not yet made into an stand alone. Thank…

Hi I installed the filemaker 8 server advanced. I added an entry in dns, am forwarding port 5003 but still cannot connect through fmnet. No databases show up and if I add the path manually they don't show up either. I am not sure if that is the correct way to connect to the server remotely. Do i have the port wrong or something? I can get to the server fine from the web browser. AND I can get to the database internally via "localhosts" fmnet, just not externally. boohoo.

After upgrading to v.8 we developed a problem with one of out fields in a layout. Previously we had a script that copy and pasted a value from another file and then pasted it into a field in the original layout. This is no longer working. However we are able to copy from the original layout and then paste into the other file using the same script. I have attempted creating a new script that mirrors the original but it still isn't working. Any help will be appreciated. Thanks, Dave

after upgrading from 6 to 8, on my invoice,only the first item will lookup from my inventory list. How do I fix?

Case(GetAsDate (QuoteDate) ≥ Date(10;3;2005); (Case(ExemptCertificate = "Taxable"; .08375; ExemptCertificate="Westchester"; .07375; ExemptCertificate="Suffolk";.08625; ExemptCertificate="Nassau"; .08625; 0)); Invoice::Date ≥ Date(10;3;2005); (Case(ExemptCertificate = "Taxable"; .08375; ExemptCertificate="Westchester"; .07375; ExemptCertificate="Suffolk";.08625; ExemptCertificate="Nassau"; .08625; 0)); Case(GetAsDate (QuoteDate) ≥ Date(6;4;2003); (Case(ExemptCertificate = "Taxable"; .08625; ExemptCertificate="Westchester"; .07; ExemptCertificate="Suffolk";.085; ExemptCertificate="Nassau"; .0875; 0)); Invoice::Date ≥ Date(6;4;2003); (Case(Exem…

Hi, I have an old dBase III database that uses HP-ROMAN8 encoding that I would like to port over to FileMaker Pro. Any ideas about converting ROMAN8 to UNICODE? Thank you! -PeacePhila

Hi, I jumped from FMP5 to FMP 7, and I actually spent a few years without using the program, so I guess that I have lost somethings along the way. I have a file done in FMP5 that opens with a user password directly, without asking for opening password. I rememeber that i use to open it with the administrator passwork Option-clicking it, so that the log-in menu appears. It doesn't seem to work anymore in FMP7. How do I make this file display the login menu so I can enter the administration password?

Hello, I am trying to covert my old FM6 database (web folder) over to FileMaker 8 Server Advance. I have converted the old database file over to 8 (running on sever advanced) and I have run the old FM6 wed folder via CDML converter. What do I change my old html search page to? Does anyone have a basic custom web publishing solution they could attached so I could get an idea of what all the files need to look like? I am very lost!! Thank you

Has anybody migrated from PrintSmith to FileMaker? I am wondering if FileMaker has all the estimating features and user-friendliness that PrintSmith does. Also interested in tracking & job ticket abilities. Thanks, Rachel

Guys, Ive got a Main file which I've hosted on the server. Everyone can access this file fine as sharing is on. I have one user that has a local file, and my main file points to this in the file reference has the ip address of the file. Each user has a different account logon, can I somehow in the file references area setup an If Account = "Jalz" then activate reference otherwise ignore it?

Quite a jump coming.... I have 23 fully related databases I need to upgrade in the next couple of months (I'm waiting for the FMP8 bible to come out). I just downloaded the FMP8 migration download from filemaker.com.. "Converting FileMaker Databases from Previous Versions". It seems to reference filemaker 7 a lot when I was expecting FMP 8... this is just recycled text that wasn't cleaned up later for FMP 8, right? it makes me nervous though that not all the issues will be accurate. ... and this is business critical info... so I want to be extra careful. Is it correct for FMP8? If there is a better source for conversion info as well.. please…

we have been on 5/5.5/6 forever, and are introducing 8 to the scene. coupla questions: - can we run FMS5.5 on the same LAN as FMS8 ? - can we run FMD6 on the same Mac OSX tiger box as FMA8 ? - can we run FMD6 & FMA8 from the same box at the same time ? - can we run them with open served files from 6 & 8, respectively? - how is any of this behavior different for WinXP or Win2k? thanks. i searched and searched and could not find this info on filemaker.com (imagine that!)

I have 8 desktop clients running FM 6 (peer-to-peer) and want to introduce the FM Server 8 that will install on the Server (SBS2003). Will this work or do I need to get new upgrades for the clients as well? Thanks

At work, we have FM Pro 7 running on Windows XP. I bought a copy online to use at home on my macmini running Tiger. Can I take the .fp7 file from work to home, work on it, and then bring it back to work the next day without issues? Are there any "gotchas" to look out for? Thanks.

I am upgrading from v4.0 to v8.0 and am trying to combine tables into one file. I follow the instructions in the help file: ------------------ To import table schema without data: 1. Open the database file into which you want to import a table. 2. Choose File menu > Define > Database > Tables tab. 3. Click Import. --------------- ... but there is no Import button to click!

Spent a considerable amount of time renaming all layouts and scripts on a relational FP6 multi-file solution (per white paper suggestion) in preparation for conversion and then converted the files using FMP8 Advanced. My goal is to combine several of the files into the main file as additional tables. When I import a file as a table all of the fields import fine and the conversion process creates a generic new layout titled the same as the file's name that was imported. I then have no problem importing the scripts from the same file. The problem is that the importing process does not import the layouts from the subject file and any scripts that reference these layouts a…

Have a old filemaker 5 file that converted fine to 8. The question I have is the old file was setup wrong and I am correcting it in the new file but using the import data from file does not update in the new repeating field correct. So I must be incorrect in the way I am trying to fix it. The old file had 6 sets of exact fields Qty. 1,2,3,4,5,6 and description 1,2,3,4,5,6. The new file has just 1 of each field, formatted as a repeating field. Importing the file the first time works fine but when I try to import again using the next field #2 and putting it in the new file field as a update it overwrites it and does not add it in the repeating field, the old file and the ne…

Hi, I would like to get peoples feedback on which migration tool to buy. FM Robot, FM Migrator, or which other is out there to buy. What I want do is to have one single file with all my scripts, layouts, fields and so on. I know I am going to have to do some cleaning up. I just don't want to do all of that copying and importing stuff. PS, I don't have developer. I want to convert from FM5 to FM7. Thanks for you feedback

I created a db in FM7 on OSX. Can't open it from WinXP FM6. Is there any way to save backwards to FM6? A plug in perhaps? Thanks, Kevin

:help: I have upgraded from FMP 7 to FMP 8 Advanced and can open my files by double clicking on them if I launch FMP 8 Advanced first. However, if I don't launch the program first I get the following message: The operation could not be completed An unexpected error occured (error code - 10660) Has anybody got any ideas please?

Hello there. Can I edit files over the network with Filemaker 6 if those files were created in FIlemaker 3? Also, do I need Filemaker 5 installed to upgrade to 6, or do I just need the code? Thanks

Upgraded a 20 file relational db to Fp8. After months of reprogramming and resetting of file references a constant problem emerges. Whenever I use the 'Window' pull down menu to select a file named 'Spline' it displays another file (the crime file). When I once again select the spline file (this time while in the crime file that it displayed) using the window pull down menu it displays the ptstop file. I have redone the file references with the same results. Note: script calls to this file (the Spline) work fine and all files are in the same local directory. What could be causing this?

Hi, First time to this forum so please forgive if I have posted in the wrong area. The problem I have is a runtime that i wrote 10 years ago in filemakerpro v4. I need to upgrade to the latest filemaker and after purchaseing filemaker 8 advanced i opened the filemaker 4 files and followed the prompts to update to filemaker 8. After doing the automatic conversion the following errors are occuring. 1. I keep getting "can not modify that record cause it is open somewhere else" from my browse around this forum it looks like i need to put commit record script step in my scripts but am not familiar as to where i put this step in my scripts. 2. bad relationship er…

I did a trial conversion of my solution to FileMaker 8.0 and I'm having an issue that maybe somebody can shed some light on. My solution consist of FileMaker Server hosting a bunch of files and each user has a local file for opening the database and logging in. This local file is referred back to many times in every hosted file. The hosted files reference the local file with an absolute path which happens to be my hard drive and my directories. In FileMaker 6 the hosted files always find each users local file although the reference is pointing to my specific machine. In FileMaker 7/8 the local file cannot be found unless I reference each users specific directory. I've tri…

I need to change the fields so that Only the first letter of every word is in Caps. Right now its all over the place. Some records are all lowercase, some are all uppercase, and some are mixed. Thanks Devin

I have a field that has both customer # the customer in one field! I need to split the two out. simple yes, or so I thought untill I noticed that sometimes they did not enter the customers #. So I need a calc that will split them. Only grab the first numbers for the customer # and only grap the text for the customer name. Any Ideas? Thanks Devin

Hi, I'm working from a mac and am migrating my v6 app to v7. All the "re-write" was prepped and going to plan, with exception to one... I have multiple files from which I need to create a report. Right now I go to the preview mode, make a copy, go to a different fm file, past the screendump in a container field and do this on serveral other pages. The common FM file now contains all the required "screens" to make up the report, after which page numbers are added etc. When I print this report in v6 the text is as it should be, but in v7 it appears the screendump was in a very low resolution resulting in unreadable texts and such. Does anyone know of a…

Prior to migration ... I thought it might be a good idea to relocate all my fmp6 files for one particular solution, into one directory ( I wanted to do this anyway - and now is a good time) ... but I'm having this problem... Using FMP6... I'm trying to modify an existing solution... - previously, the menu file resided outside of the folder with all the solution files in it... All of the file reference links were working fine with that basic set up... - now I am trying to take the menu file - and place it inside the main folder with all the other files... So I quit FileMaker ... Moved the menu file ... And booted up with the menu file in the new locati…