Upgrading & Migration

I have completed a solution designed on a Mac. I have sucessfully transitioned it to a PC environment, but I have some problems. First, the FMP files were copied onto a CD and transfered to the PC hard drive where they appear as generic documents. I can open them by right clicking and using the "Open With" option. This shows the file, and my scripts, relationships, etc. all work as expected. But, when I close the files, they go back to being generic documents (so they cannot be opened by double clicking them.) How can I get these files to become true PC FMP files? Second, I had to adjust all of my layouts (I expected that). But, although I have them so that the…

Hi there. I'm trying to convert the company's current FM5 solution, to now, FM8. So far it's going pretty smoothly, except for the fact that I'm having to break some flatfile parts down into a proper relational system. Again, that's not so much of a problem, except for the number of fields I have to go through. Basically I'm making copies of the flat file, relating them, and then deleting the unused fields in each. So yeah, I'm just looking to know... is there an easier way to do this?

With Version 8 does Filemaker update relationships that in previous versions would be broken if you renamed a file. I know you used to be able to do this thru developer, do you have to do it now using FM 8 Advanced? Thanks Ron.

In an application which has been converted to FM7 from FM6 how do I ensure that the data files are properly opened so that the correct machine hosts them? Is Open File (hidden) sufficient? The reason I ask is that the user of FM6 was told that just opening the files was not sufficient and had a whole procedure for clicking on every layout to ensure that all files were hosted correctly. I have read elsewhere that in FM7 locking does not happen just by opening a file (it requires entering data into a field on a table), so I want to be sure that I have the correct procedure (especially since I have modified the application to use the separation model.)

Hi guys We use FM5.5/6 at the moment Quick question about the FM8 file format, is it the same format as FM7? Glad I didn't bother upgrading to 7 now this has been released : Thanks Ben

We are currently using FileMaker to track our production information and time/materials. We are using Version 6 and hosting it in a workgroup type fashion. I have been proposing moving to version 7 and we were planning to do so in the next week or two. Then on Monday I hear that version 8 has been released. It looks like a great upgrade so we will be going from version 6 to version 8. My proposal for moving to 7 included purchasing a copy of Developer, Advanced Server to move away from the workgroup type hosting and upgrades to 7 for all workstations. I am not sure how to proceed now since the Server edn. hasn't been released yet. Can I use FMP 8 and host it i…

I've just d/l the Trial version of FMP8 and converted a multi-file db from v5.5 which contains a lot of fields in Greek (I live and work in Athens, Greece). Now, I know that since v7, FMP has been Unicode, so I don't understand the following problem: Some of the greek fields appear fine, some others show gobbledeygook. All fields in greek share exactly the same settings, so why the difference? Any ideas/tips? Thanks, people.

This is an amazing Forum. My sincere appreciation and thanks in advance to anyone who can assist me. They say the only stupid questions are the ones you don't ask... well... A few years back, I was a semi-serious user (8 hrs a day for 10 months) of FM4. I haven't touched it since then and have forgotten pretty much everything I knew. But I still regularly use a Contacts db I created - in fact, I can't get rid of that old Mac until I figure out what to do with that db. The idea of hand-typing all of the info into something else is daunting and, besides, I like the way I designed it. It's nothing fancy at all, just a non-relational flat-file solution with a whole …

I am quite experienced in FMP5.5, but an FMP7 newbie. I realize that multi-file dbs in 5.5 become multi-table dbs in 7. My question is: is there a quick way to import/convert a relational database system of about 20 files from 5.5 to a v7 file, and somehow to import into each new table of the single file all the field definitions, relationships and scripts? Or do I just import one of the 5.5 files, and then basically sit down for days and re-write all the remaining 5.5 files as additional tables within the newly created v7 db? Many thanks, people.

I migrated from 6 to 7, the solution contains 6 files. I have a script, which has worked for about 6 years, exporting selected records into a tab delimited text file, for uploading to online databases. Now, in 7, some records which have one field wherein there are several paragraphs of text (when written a carriage return was used to create the paragraph separations), get extra tabs, and are rejected by the online databases, because they appear to contain more fields than they should, because of the paragraph separations appearing as tab markers. When I look at the textfile in BBEdit I can clearly see the "extra" tab markers. How can I deal with this? thanks, …

Hi I have done quite a bit of database developement in fmp5 & 6, but have just gotten around to looking properly at fmp7. One solution I am converting over is a technical call logging system comprising of a number of fmp5 files: Contract Call Log Customers etc I have managed to convert this solution over in a working state (apart from a couple of silly script glitches), but am curious as to which is the best way forward. My understanding was that among other features fmp7 can have multiple tables per db file (as aposed to my seperate fmp5 files above). During the conversion I was expecting an option to 'flatten' my solution into one data…

I am working on upgrading our database from FM6 to FM7. The old database needs a lot of work to make it efficient, reliable, and attractive. I am working on a copy of the data, making the necessary improvements and enhancements in FM7. Meanwhile, however, the old database is still being used. I will need to identify and import to the new version the records changed or added between the time I created my working copy (already a couple of weeks ago) and the time the new version is ready. What is the best means of doing this? At present there is no field in the old database which reliably identifies the day on which a record is added or modified. Should I add such a f…

I have upgraded an FM6 file to FM7, and I find that everything--field labels and field content--appears dimmed and fuzzy. I thought at first it might have something to do with default accounts and permissions, but I've looked into all that without success. I have full access to do what I want with the data, the layouts, whatever. I have a very hard time reading the data on the screen--even if I set font style to bold everywhere!--and I know my colleagues will be unhappy with this "upgrade" if I unleash it on them. Any suggestions?

I uninstalled the trial version of 7.0 and now when I try and install the actual version I get a message upon install that says "Error Applying transforms. Verify that the specified transforms path are valid." Then the installer closes. I am unable to install this program. I also have removed the old version in the add/remove programs so I dont' know what else needs to be done. Any help would be great.

Hey All, My first post to this forum. I recently reloaded my computer with FileMaker 5.5 but am having problems opening all of my files and the error that comes up is: "This is FileMaker Pro Release 5.5. "[FILENAME]" was created by version 4.01 of FileMaker and cannot be opened by this version. Please call FileMaker Inc. Technical Support." I've called Technical Support but have been on hold for 20 minutes. Anyone have any solutions to this? Many thanks, Weblancer

After converting to v7 my sum field doesn't work unless: I enter an number into the "quantity" field (part of the calculation leading to "sum"; or, all the repeating fields are filled. All the appropiate "do not evaluate if referenced fields are empty" boxes are checked. It seems that the calculation fields are trying to work because I see question marks in those fields ahead of where I am currently working. It worked in 6 just fine. I'm stumped. Any suggestions?

Please help - I am going nuts!! Filemaker Developer 7.0.3.320 Intermediate User Moving from 5.5 to 7.0 and can longer import a found set. I have two tables in my Special Ed File. One table is student/teacher schedule. Second table is the entry table where grades, behavior etc is stored (along with the student/teacher information). Each week, a teacher needs to create a new set of empty records in the entry file to update student progress. In FM 5.5 I had a button that would find that teachers schedule in the related file, and then in the entry file, it would import that found set of teacher/student records, Therefore creating an empty set of records for dat…

6 to 7 went pretty good. except 55 searches change the wrong records sometimes. They used to work. These scripts each checks if no records found. simple. But instead they continue sometimes using records from same layout but last find instead. I can posts scripts if necessary. But they all do it and worked in 6. checked windows, layouts, commit records. Last piece to figure out before going live. Thank you for considering helping.

Our current filmaker solution is on server 5.5 (Windows 2000 Server) with fm 6 pro clients. My question is, can I have filemaker .fp7 files sitting on my computer and not have to worry about people connecting to those files (same file name aside from the file exetention, case_note.fp5 vs case_note.fp7)? I'm assuming I won't have any issues since they are .fp7 files. I know if I have .fp5 files on my computer that are the same name as the ones on the server everything goes ape$hit. Right now I'm working on converting our solution to a single-file FM7 solution. It's a very long process, but I'm making some headway. I'd much rather be able to do this on my main…

Hi all Seems like this is a simple problem but I'm not sure how to solve it. I have a file which was at one time a FM5 file its dates were formatted 2004 01 01. Now the file has been updated to FM7 where dates are formatted 2004/01/01. The problem is when I search for records in a particular range e.g. <2004/01/01 only the records that match this format will come up in searches. Is there a way to update all of these old records to a format that will be recognizable by FM7?

The following script works in FMP 6 but not 7...its something simple but I just cant make it work. what am I missing? There are two files. SR_Lead and SR_Contract the join is on Lead Number in both files. The script checks to see if I have aan existing contract record related to the lead record. If not it lets me build a new contract record if so it takes me to the existing contract record. In Version 7 it is not doing the check for the existing SR_Contract record. The problem is likely in the If [Get (Last error)=101 ] statement but I can't figure out what is haywire

I have created a FMPRO DB to run my business. I am self taught and have no formal training. Many of the scripts and approaches used to resolve my problems are not designed in a particularly savy manner. Additionally, I have nobody to consult with locally about issues that arise or may arise. I had one programming class in college - probably got a "C". My database (FMPRO 6.0) currently has about 210,000 records and and 4,000 fields. The Database is almost entirely flat as I only recently figured out how to do relational DBs. There are many calcuation fields and quite a few scripts. The database works really well for me, but it is clearly not well designed. REP…

I've got an old datbase that has one field that has the customer number and name in one field. The new database I want them to have thier each field. One for their Number and one for their name. How should I go about doing this. I thought I should import the data twice. Have every thing in both and then create a script just to delete what I don't need. The field looks like this now. 123 company_xyz 15 company_dfy 2345 ccompany_xyt

Since upgrading, when trying to delete records from a table, the following message comes up: "This operation cannot be performed because one or more of the relationships between these tables are invalid." How do I figure out what the problem is?

I have read some of the posts stating that copy/paste is not the way to go, however, can anyone explain why the following script has worked every week for the last 5 years in v5 and now won't work in v7? The following script copies info from one portal and pastes it into another: Go to Portal Row[select;First] Loop Copy [select;Field to copy from] Paste [select;Field to paste to] (THE ABOVE COPY PASTE IS PERFORMED TWO MORE TIMES (FOR TWO OTHER FIELDS) Go to Portal Row[select;Next;Exit after last] End Loop Go to Portal Row [select;Field to go to] As noted, this script used to work without problems everytime. What happens now is that only th…

i have a database with several fp3 files. i converted all of them with fm pro 7 except one file. it keeps giving me an error that i have to use fm pro 3. if i look at the log file, all it says is the conversion was aborted. why would the conversions work fine for the other files but not this one? unfortunately, i can't find my fm pro 3 software. help! p.s. i also tried to do the same with fm pro 6, but got the same results. thanks egizzi

Howdy y'all... I'm currently 1/2way through our upgrade process here- moving from FM6Pro on OSX (shared DB file) to FM7Server Adv on PC. All of the client machines (6 of them) operate via an alias to a cloned version of the shared file with a relationship set to the 'mother' machine. Now. I've gone and installed FM7 on my own terminal and tested- and the base data comes over just fine--- *we have a very simple flat db file.* But here's my question- and the one that has the secretaries freakin' out: If I convert their current DB files- and fix the relationships- I still have to go back and reassign all the indiviual fields in their layouts. I haven't had any…

I am converting a FMPro 5.5/6.0 database that contains Baltic characters (CE fonts) to FMPro 7, however the resulting letters are gibberish, ie. don't convert correctly to Unicode. What am I doing wrong?

Hello, all. I'm trying to convert two databases from the ancient Nashoba Systems Filemaker 4 to Filemaker Pro 7. If I've read previous posts correctly, I need to convert first to Filemaker Pro 2.1, then to any version between 3.0 and 6.0, and finally to 7. Is that correct? The person before me in this job downloaded the trial version of 2.1 from the Apple ftp site, but that trial version would only convert the first 50 records of the database. We have over 6000 records in each of the databases. Any help you can offer this clueless newbie would be greatly appreciated. Peace, friends, Pat Fina

I converted from FM 6 to FM 7 and some layouts print fine and others I get a mesage that the print is out of memory can any one help

I am not sure which forum to post this question in. Before posting I read through the conversion from FileMaker Pro 6 to FileMaker Pro 7 forum as well was the one on portals. I did not see anything particularly dealt with the problem I have. I have a customer who uses FileMaker Pro to keep track of dumpsters. We have one file called

Hello everyone After 18 very enjoyable(well usually!) months I have a working solution installed in my business. It comprises of 18 files, umpteen relationships and runs in kiosk mode from FM server to approx 6 users throughout our business. It handles everything from initial enquiry & calculating an estimate, conversion to order, job tracking throughout the works through to final invoice, management reports and filing. All this along with a professional looking GUI means that I take great pleasure in seeing people using it every day and I would like to take this opportunity to thank everyone who has helped me along the way. Because I started as a complete …

Hi, please pardon this long post, but I have nowhere else to ask for help. I am a N-O-V-I-C-E user of FM Pro. Have used FM pro4.0 sparingly before given the unenviable task of "upgrading to FM Pro 7.0 with Web Publishing capabilities". So I read whatever info I can get on conversion and set about doing it. Now, the conversion's completed. Only these few problems got me stuck; 1) I am getting page format problems after conversion. The FM Pro 4.0 documents were configured to print to fit A4 size very nicely. After conversion, however, the fonts became shrunken and the page format became distorted. Some lines on the page were missing. 2) Some of our …

Hello FM fans! I'm an absolut beginner regarding the field of databases. In the lab were I have started to work we want to migrate our scientific db from Access/Win98 to FMP7/Panther. I came across this nice piece of software called FM Pro Migrator. To test whether this program fits our needs I installed the demo-software (http://www.fmpromigrator.com/downloads/demo_software/FmProMigrator3.46DemoWindows.zip) and followed the instructions for migration on Windows platforms on http://www.fmpromigrator.com/support/fmp...s_to_fmp7.html. Everthing went well until I came to the creation of the new database table in the FileMaker database and I got stuck with the follo…

In migrating, I've converted 5 related files from 5.5 to 7 and am now rebuilding by creating a new interface file with each original file as a table, entering the fields exactly as original (can't copy fields!) and then copy/pasting the layouts one by one (zero records, no relationships). This has worked fine in 3 tables, all fields in layouts are recognized in new table (to my delight!) except for now the 4th has <table missing> on each of the fields. I have done nothing different than the others, the fields are identical to the original, and I can't figure out why these fields have not been recognized in the copied layouts. Any ideas? thanks

Hi, I have a strange problem. I started building a semi-complex database system in FM6, but half way through the project my client decided they would rather use FM7. So I converted the FM6 files to FM7 and spent a while tweaking the complex scripts and whatnot because the FM7 converter broke a number of things that were previously working. Then I developed these converted files further. For any new files (tables) I needed, I just started them clean in FM7. So now I have a mix of former FM6 files that have been converted and further developed - plus - several pure FM7 tables that I built within one FM7 file. So here's the problem: When these files are ser…

Can anyone recommend a migration consultant? I have several filemaker solutions that were developed using FM5.5 and used for the past 5 years in a client/server config (FM5.5 connecting to FMServer 5.5 Host). Now have dual system running (FM5.5/FMserver5.5 as mentioned) and a new Xserver with FMServer Advanced 7.0. New Xserver IWP works great with IE & Safari clients for new database applications developed in FM7.0 but old applications arn't behaving well in new environment.

Guys, I've finally managed to convert about 70% of my solution into the FP7 format. I've cleaned up all the relationships and duplicate file references the old FileMaker had remembered. Filemaker 7 seems to take and age when opening a file locally, and i'm guessing (rather hoping) it might be something to do with the file references. At present I have my references setup as : fmnet:/*/CONTACTS file:CONTACTS Is this the most logical way ot set them up (fmnet: first and file: second). I sell my solution to both multi-user as well as single user customers and the speed for single user is frustrating me. On the other side though, the network perform…

I wonder if there is a program that can convert automatically from version 6 to version 7 of FileMaker. Please let me know if you know anything in this regard. Thanks

Hi, I am new to FM but I was pulled on that and have no choice...Our user has FM 4.1 application ( 8 files ) developed 8 years ago on MAC. The person who did that left the company and soon something broke - fields became un-editable. I am trying to fix it and open a local copy on my windows machine.The problem is- all files have fp4 extention and I can't open them - so I did some research and re-named them to fp3. I can open them now, but the problem is that there is a lot of scripting referring to other files with fp4 extension, so application will not work...Does anybody know what can be done ?

I have taken a FM5 database and converted it into a FM7 database. I have rebuilt the solution (many many months in the works) and now want to take the old information and import it into the new solution. I can not import into calculation fields and am having trouble with the old database in regards to making the data workable, meaning that some of the old fields are calculations themselves. I would prefer to have all info go straight over but with the calculation fields in the new dbase that doesn't seem possible. I'm dealing with over 15,000 records, so hand-fixing the erroneous records is a major task in itself. Sorry if this is confusing...any startin…

I have a multi-file system running on FMP Server 5.5 with FMP 6 clients. I want to upgrade these files to 7, and have some basic questions. I've seen various options for some of them, but no pros versus cons answers. Here are my questions: 1.) To develop a system in 7, do I need developer? If so, what are the benefits? I do not need to bind the solution, which I know was something the earlier versions of FMP did. Also, if a system will be served off of 7 Server, does that make a difference to development in client versus developer? 2.) To use FMRobot, do I have to own developer or server? 3.) If $$ is an issue, and the files need to be converted manually in…

Post deleted by merkaba22

We

one of my more complex clients has a web application that is currently living on a standalone FM6/Lasso/OSX foundation and he is in the process of doing a complete upgrade. their FM6 system runs every facet of the company and they need to take it in steps. first up is the web app, and i want to see if anyone has done a reliable solution to import/export to and from 6 and 7. the direction i see as best case is an ODBC solution but i/ve never been able to figure out INSERT statements so i don't know if that will work. the next idea is an XML import/export. what's a good direction to start taking this?

Hi everybody! Besides working on a new solution I never had a closer look on the filesize of the FM7 files...but as a matter of fact: I converted a multi-file solution (21 FM5.5 files) into FMP7. The filesize originally was 71,3 MB and turned into 83.8 MB. Not too bad...but as I finally imported most of the data (not even from all files) into my FMP7 solution this one (consisting of only 8 files) has some 136 MB. The only main difference is that the new solution is much more sophisticated, but the data itself is the same. There are no pics or other memory consuming stuff included. Now this makes me a little worried...comments appreciated!

I've had many problems since I upgraded from 6 to 7. Fields don't sort as requested, various parts of layouts don't print, portals show records in Browse mode, but not in Preview mode or when printing. Has anyone else had any similar problems? I've checked my relationships and all are correct and same as they were in earlier versions of FileMaker. I also have tried re-designing layouts, but same errors occur. This is incredibly frustrating after ten years of loving FileMaker Pro and building up a database and now I can't print out many important reports! Any advice anyone???

I have a friend who wants to go from filemaker 3 to filemaker 7 (mac os 9 to os X).... what foreseeable problems can i expect? I have only used fmp7, and i thought that the major update was from 6 to 7 when relational db became relational... What kind of problems can I expect and should I get a consultant to do it or can a novice do it?

This has got to be a stupid question, but I need to ask it anyway: I have a database I've given someone that is now in production. I, of course, continue to make changes to it while they keep entering data. What I need to know is the proper sequence of steps to correctly move my user from one version to another. The version of FM will be the same. There are a number of tables with data entered by the users (this is a concert ticket reservations system so it has: table of buyers (name, address, phone), price list, table of seats). But there are also tables with data that the user did not enter. These I created under the covers and contain much of the relatio…

I'm on Mac OSX and currently run a fairly simple estimating/invoicing solution that involves 3 files: invoices, estimates and clients. I upgraded to FM7 hoping to migrate these files into a single solution with three tables but my research on this forum tells me that may not be possible. Plan B: the invoicing and estimating files are almost identical in look and functionality. Can I migrate the invoicing file then create another table which is a duplicate of that file? So far my research has turned up no way to do this. Thanks in advance for any insight- Michael

I have just upgraded to 7 from 5.5. My FM5.5. web sharing was working fine but the FM7 is giving me the following error message: 404: Not Found error message and "/FMPro". "FMPro" is used in the form on the HTML page i.e. "<form action="FMPro" method="POST">" Does anyone know if this "action" could be wrong and if so what might be a solution to my problem? Would appreciate help.

In version 5.5 I made a multifile relational Database according to the FMP example files "Inventory", Items", and "Sales". Now in the "Inventory" file I do a find request in the unstored calculation field "Quantity on Hand" (Initial Inventory Level - Quantity Sold). I notice that the more records the "Inventory" database contains, the longer it takes to find the records that show the quantity on hand of my find request. In fact, it took too long, so in FMP 5.5 I abandoned the idea of using it. Now I just started studying the trial version of FMP 7, my question before I upgrade: As to the SPEED of find requests on unstored calculation fields, will this greatly improve…

Hi everyone, I'm wondering if there are any utilities out there that can help me upgrade my 5.5 database files (about 50, with about 50-100 text fileds in each) into version 7. All my files are very simple - just text fields, no relationships, hardly any scripts. However, I'd like an upgrade tool that can take each of my current files, and turn it into a single file in filemaker 7, with 50 different tables, with all my fields and data intact. Anyone know of such a tool?

Is it possible to have FM6 and 7 running on the same mac ? Is there any installation issues ? I have existing solutions in 6, but need to start on new in 7.

I've recently converted a file from FMPro6 to FMPro7. I noticed a lot of unexpected variations in calculation results and also script procedures. On most of those, I was able to change a few things to correct the results. But there is one that I am having trouble with. I am using the following script to validate a correct date format entry in performing a FIND in a date field: If (Get(LastError) = 500) Clear(Field) Enter Browse Mode Show Custom Dialog ["Not a valid date format"] End If In FMPro6 this worked fine, but FMPro7 does not seem to recognize the Get(LastError) request. So I am stuck in the middle of a script with an inval…

Hi there, I don't know if this is a dumb question, I suspect I'm not as savvy about these things as most people here. But here's my problem: I just got a new computer which runs Mac OS 10.3.5. I was previously using 9.2. I have Filemaker Pro 6. When I try to install it in my new computer, it brings up Classic, and will not run in OSX. How do I change this? If I don't resolve this I may resort to Appleworks DB, which I am not as thrilled about, but it works. Thanks!!

I am working on converting an application from filemaker pro 3.0 to filemaker pro 7.0. In FileMaker pro 3.0, the primary file uses file extension .fm, the rest of auxiliary files use file extension .fm_. do I need to change their file extension to .fp7? Jackson

I'm testing out FM7 (as a naive user). I wanted to see how export/import would work ... naively thinking that if I exported in tabbed format, then I would be able to import that same file straight into the same file without effort, but when I did so, the order of the fields is different. I cannot seem to specify that the import order matches the existing table field order. Is it possible to do this or do I have to do this manually?

I've been using FM4 for years and went to 6 and was pleased. I just went to 7 and things are mighty slow. My biggest problem is printing. I print wireless to a Lexmark T420. I print 100 or so bills a month and it used to be a breeze. Now when sending it to the printer it keeps pausing and I have to hit the continue button on the printer maybe half a dozen times. With 4 and 6 it was a pleasure to print. Scrolling is also slow. Simple database, 2 entries per customer and 10 simple calculations. I like the new features in 7 but am ready to go back to 6. Am I right in assuming 7 is overkill for small databases? Thanks Hutch

I have been asked to modify an FM5 application that was developed on Windows. I have a Mac using FM7 (trial). When I attempt to convert the FP5 files I get an error message that the files are corrupted or else they are not FileMaker files. Is this due to the fact that I am attempting to go cross platform or is something else wrong?

I was wondering on average how long it took to tranfer a good size mult-file database (containg about 10 tables) fm6 to fm7, or what people's general experience has been with transferring a fm6 db to fm7 db

Hi All I had (what I thought was) a perfectly simple AppleScript to place pictures into container fields based on a field that containing a filename. Unfortunately it no longer works in FM7. Also, I had another series of simple scripts to open the placed pictures into Preview that no longer work. I would appreciate it greatly if anyone has the time/interest to check out my scripts and offer any advice they may have. Hopefully its a syntactic problem. Below are copies of the scripts. Thanks Brad To import pictures into the current record:[color:"blue"] set folderPath to (choose folder with prompt "Import Photos from...") tell application "…

http://www.fmpromigrator.com/ FmPro Migrator - FmPro Migrator documents and migrates FileMaker Pro databases and stand-alone solution files to MySQL, Oracle, Access, SQL Server, Sybase, DB2, PostgreSQL and FrontBase. Large text and image data is accurately transferred to the destination database with no manual re-keying. This graphical application generates migration scripts, repeating fields conversion scripts, Perl CGI scripts and documentation files within a few seconds. FmPro Migrator also includes a FileMaker 3,4,5,6,7 to FileMaker 7 table consolidation feature, enabling developers to utilize the new FileMaker 7 security model for their FileMaker solutions. FmPr…

Hi All A sad day to be working but hey... I have upgraded my database from v5 to v7 today and I'm currently having problems when trying to login with the client machines. The problem appears to be intermittent and on my XP clients. Can anyone help? Many thanks in advance eSBee

I have an education client with 12 copies of FMP 5.5, mixed Mac and PC. One copy resides on a server (but is FMP 5.5 Client), serving four very light-use database files. The other 11 users launch FMP once or twice a day, connect to the server through FMP's built-in database sharing, update a few things and quit out. Users never create new layouts, add fields, or anything else of significance. Add records, update records, and print - that's it. I don't think the database has been otherwise modified in 2-3 years. The server has been upgraded to OS X, and users are having problems reaching the server, something many others have experienced. The solution is to upgr…

I am trying to install FM 7 on Windows xp pro. I purchased the software form one of the forum sponsors, Hardcoremac. I get as far as "Copying new files" when a popup asks: "Please insert the disk:1" AS I only have one disk that's in the drive it will not proceed. Any ideas?

Hello all I'm a newbie to FMP and have taken on the task of performing the above mentioned upgrade. Could you please help me with some possibly silly questions? Currently, we are using FMP 5 on a mixture of XP and Win 2K PCs. One of the Win 2K PCs is hosting the database files over our client/server network. 1. On this PC the LDAC plug-in was installed, when I upgrade/convert to v7 how will I get this plug-in back? 2. Is it possible to run both the v5 and v7 databases simultaneously? Is so how is it done? I tried searcing for licensing restrictions on filemaker.com but couldn't find any relevant information. 3. We want to use the container …

I have done my first conversion from 6 to 7. I know nothing about file references, and can find no indication of them in my version 6, but after my conversion to 7, I noticed that there were several file references created (somehow). I do not want to reference any EXTERNAL file. Do I just delete all these file references?

I purchased a copy of FM Pro 7 and like it a great deal but the literature which describes the software indicates it must run on Win 2K or WinXP. Can anyone verify that? If that is indeed true I can't deploy it in our office because most users are running Win98 and need to keep doing that until we migrate an old DOS application to FM. Accordingly I'm wondering whether FM Pro 6 will run on Win98? If so I need to find somewhere to purchase FM Pro 6 assuming it's still available somewhere. Can someone help? It would be appreciated. Jess

Just wondering: we are running FM6 right now, and thinking about getting a FM7, but only on one machine of the network. Are there any compatibility issues that I should be aware of before taking the plunge? (All except one of the machines are MSWindows; the last one is a seriously hacked SuSE Linux 9.2).

I have a small database that id like to migrate from FM 3 MAC to FM 7 for windows. I didnt find anything about cross-platform migrations searching the forums. Any suggestions??

I recently converted my database which is fairly simple to version 7. It has been working fine in version 5 and now I am having trouble with a time field. I use the time fields for calculations of timecode. The fields having trouble function like this. I enter a start time in the format hh:mm:ss and a end time in the same format. The database then calculates the difference between the two and displays it in another field (ie;length) in the same format hh:mm:ss. Now that I have upgraded to version 7 that no longer works. I put in a start time and recieve a format error saying that the time is entered incorrectly. Same goes for the end time. Then when both num…

Ever since I upgraded to FM 7, it takes forever to print to .pdf. Anyone else experienced this poor performance when printing to adobe distiller after upgrading?

After upgrading to FM7 from FM6... It was decided that the db needed to be rebuilt, not only because it was running off of 4 different files, but also because it was originally created 6-7 years ago in a much older version, and many new features could be added to make it more effective. The basis of the Database has just been copied, except for the fact that instead of 4 files, I'm working with 4 tables; and updated layouts. For the most part I just copied scripts, and updated them with the newer tables rather then file paths. However, on several cases I have run into the same problem. When using a portal to make a selection... (I.e. copy the selected contact fr…

Hi All, I wanted to convert the existing FMP 6 solution to FMP 7. Can the files directly be converted from 6 to 7. What is the correct method of doing this. Please let me know. Thanks. Yogesh.

In FM7 all "Status" functions have been replaced by "Get". Unfortunately, the change of the name also brought in a diminished capacity of some of these functions. Previously, the function "Status(CurrentFoundCount)" produced results that could be seen in related files. Now it is impossible: related files do not display the values in the field "Get(FoundCount)" of other files. Am I missing something, is there another way to display the number of currently found records in a related file (NOT another table within the same file)?

Hi All, I wanted to know if FileMaker Pro 7 can be run on Linux OS. I have the existing solution on Windows 2003 Server. Can I take it directly to Linux. Please let me know. Thanks. Yogesh.

The "Exit Record/Request" script step is gone in FM7. It probably has to do with the new way files can be selectively saved. This is fine, but how do I now exit a field? I need a step that will leave a field without going to another one. What should I use? Interstingly, the FM7 Help files still refers to this non-existent step (excerpt: [...]Make sure that the record you want to delete is active (use navigation script steps), and then use Delete Record/Request. If the current layout contains a portal, use Exit Record/Request to make sure that no related record is selected, then use Delete Record/Request.[...])

I have a 5.5 solution that is to be updated to v7... The 5.5 version is opened via a script (set to run 'On Open') in a 'launch' DB that resides on the user desktop. There exists two versions of the 'launch' db - one that was included in the bind and one that wasn't. Normal users open using the non-bound launch db and everything opens in standard mode. Public computers open using the kiosk launch db and everything opens in kiosk. Up until now that has worked perfectly - there never seemed a need to maintain kiosked and non-kiosked versions of the databases Problem: When I migrate the solution to v7, the whole mess opens in kiosk mode unless I open the databases …

Hi all. First post here. Have been an avid FM (and Mac) user since around 1990. We currently have our company running on a very simple 3 file system (invoices, customers, parts catalog) using FM3 or FM4. We have about 10 computers networked using these files. Most computers are G3's or G4's running OS9. Accounting is handled with MYOB and Inventory is (sometimes) handled in Excel with no direct link to FM. As we upgrade computers (and OS's), the question of upgrading FM comes to the forefront. I'm fighting the "upgraditis" which usually plagues me since I see no need to upgrade. I understand, just barely, the relational aspect of the new versions. I'…

I'm currently migrating/rebuilding a fm6 solution to fm7. The fm6 version is in kiosk mode, and when I open it in fm6, I hold the 'option' key and enter with master password, I can go to any -related- databse and view them in a normal window. Now this problem occurs: when I open the same solution in fm7, (I build a new interface file), but also use upgraded database files from the fm6 version. Problem with these files is that they only show themselves in kiosk mode, even when I open them by the master password Any suggestions how to undo the kioskmode from those updated files? These files where not the primairy files in fm6....

I have installed FM7 DEV on my, much used, "shop" PC, running XP Pro , without any problems at all. But, after installing it on a newer P4 box, which has givien me no trouble at all, whenever I open any fp7 file and go to the graphic table view ( FILE>DEFINE DB) the tables are there, but the words and connection lines will not appear unless I click on the table header. If I let go, the words disappear! Also, if I try to draw lines or borders in Layout mode, I cannot see them either. Nor can I seem to set their colors in the color picker box to anything!. I've uninstalled and reinstalled several time, to no avail. But, if I reinstall it on the …

In FMP 6 a script in reports.fp5 runs an external script in another file (customer.fp5). Customer.fp5 performs a find on all the active customers. Reports.fp5 then sets fields based on the summary fields of customer.fp5. The relationship is based on a simple field called "key" that has the same value in both reports.fp5 and all the records in customer.fp5 My problem is that when the database was converted to FMP 7 the script does the find okay, but reports.fp5 sees the summary of all records in customer.fp5, and not just the found set. Any ideas on why this is happening?

I compiled a small fm db of architectural details using fm 2.1. The claris XTND image import plug-in has given up the ghost and I got fm7 now. I can't find a way to upgrade the file to fm 7 I don't have any intermediate versions of fm. Can s.o suggest a solution ? ie an accessible place to get a demo version of an intermediate fm version to use to open the old file etc marmot

I am sharing FM pro 7 on a small network of 5 machine and it randomly allows several users to log into one database but then if one particular user is logged in, another cannot. It appears to be random. What might be the reason. Do I absolutely need to run FM Server in order for a couple of people to access it?

I have some questions or please help my with reagarding FM6 (PC) and FM7 (PC). Exist any of applications succesfully convert the databases done in FM6 to FM7? The problem affects the databases containing Czech characters (CE fonts). This problem affecting data can be solved through export from FM6 and import to FM7 but all the texts used in layouts stays badly coded - we would have to rewrite about a hundred of layouts which is virtualy impossible - it would take weeks to rewrite all the labels. This problem repels us from migrating to FM7. [email protected]

Hi all, I'm a very small developer for a little company that's been running FM5/6 for quite a few years now. I've rebuilt and maintained most of their database in the two years I've been here, and now we've decided to upgrade to FMP7. The transition has been very smooth so far, much less trouble than the documentation on the FM upgrade process had lead me to believe - for the most part, I just imported the FM6 database folder and it all works. But we are having some problems, and I need some help. The biggest problem we have at the moment is with a print view in our Invoice system. Here's the setup: the Invoices file stores a few data points like order date, shi…

FM7 has a SERIOUS bug that renders all my solutions created in previous versions unusable. I rely heavily on calculations that use statements such as: Case (Field1>0;"something";"something else") or Case (Field1=0;"something";"something else") These Boolean statements no longer work in FM7. Previous versions of FM understood the statement

I have taken the "plunge" so to speak and am about to convert from FMPRO 6.0 to 7.0. I have loaded Filemaker Server 7 on a new server. I have converted a basic single file FMPRO 6.0 DB to 7.0 and loaded it on the new server. It appearrs to be working OK over our LAN. My question is based on something I just read on page 97 of the Filemaker Migration Foundations and Methodologies document. It states that to run Filemaker Server 7 on a Mac you must be running OSX "Server". I am not running the Server version of Mac OSX on this new hardware and do not seem to be experiencing a problem. any thoughts will be much appreciated........ Ray

We have recently updated from FM6>FM7 and when using Excel 2004 cannot link to fm7 file and pull down data as we could with FM6. Excel does not see Fm7 at all. This apears to be a problem with new fm7 filetype and odbc. Does anyone know an easy workaround !! - Help!

I am couple questions. 1. I am developing a DB that I would like to deploy on the network, other than istalling FileM pro on a shared server and web sharing the application on the server what would I need ? 2. After deploying the DB, what is the easiest way to re-deploy changes to DB without intrupting the users ? what about about the existing data in the DB ? for example in Ms. Access you can split the DB into client and server portion and have the data in the server portion and you can change the client as you wish without affecting the data as long as you do not change the data structure, even then it will allow but it will warn you about the data integrity. …

Hallo, I have 3 tables, Products, Orders, and OrderProducts. Products is a list of all possible products, identified by ProductId A record in Orders is created when someone phones with an order, and is given an OrderId The Products for an Order are stored in OrderProducts, which contains OrderId, ProductId and Quantity. On my order form I want to display data from the Order table in the header, then with a list of data from the OrderProducts, but for each OrderProduct I want to display data from the Products table, such as Product Name, Manufacturer etc. How can I do this? I created a form based on Orders, then a portal for OrderProducts, but I can't wor…

I was wondering if anyone knew of a way to slipstream the 7v3 updater into the FMP7 installer? I will be rolling out FMP7 to about 25 users in the next month or two and it would be nice if there was a way that I could slipstream the updater into the installer so I won't have to install the product and then install the update. Thanks for any help you may have. Jeremy

Hi - This is my first post here. I am very new to this and purchased FM Pro 7 on a recommendation from a friend / business associate. So, I am wondering if this is what I need to do what I want. I know that FM is very powerful, but please read what I HOPE to do... I am mainly a studio engineer / musician by trade. I supplement my income by doing CD artwork / layouts. These are my only sources of income. I am getting fairly busy as of this year and am seeking better ways to organize my info. What I would like to do is create a database in FM 7 that allows me to have three main sections and several nested sections. The three main sections would be audio (for re…

I upgraded my database to v7 from 5.5. It works OK except for an average calculation(which doesn't work) in a report with grouped data and totals. The report is set up to show the number of events per month and gives the total events over the last 7-8 years in the leading grand summary with the average events per month. The subsummary is by Year (leading) and Month (trailing). It worked OK in v5.5 but now the average calculation does not work. Any help would be appreciated Arnold

We're in the process of migrating to FMP server 7 advanced from FMP 6 Unlimited. Is it possible to run both versions on a one dedicated server running MS IIS on an entry server?

I have been slowly rebuilding my solution. Just for the fun of it I thought I would try converting my old files. I have not tried this since 7.03 upgrade. 2 problems came up. 1. The new files will not open, I think I have a file reference problem since it tells me it can not find an file, but the file is there. 2. The files are not combined into one solution. When I read the manual I understand that you have to buy a third party software to combine tables into one solution, I am having troubling beliving fm would do that. Can you confirm there is no way to simply put the tables together.

After migrating a FM 6 file to FM 7, I noticed I can't find some records which I know are there. I just get a pop up message with "No records match this set of find requests" When I view the file in table mode I can find the record manually. What am I doing wrong?

Hi, I'm brand new here - first post. First question: There are some ads on this forum that offer FileMaker 6 for as low as $70 (such as from Hard Core Mac and eDirect). They claim to be perfectly legal, fully functioning copies. Are these legitimate? Any downside to purchasing from these places? Sounds a LOT better than $200+ for retail. Also, I was fairly proficient in FM Pro 4 in its heydey, but really don't use it much in my current job. However, I've been charged with helping some other users upgrade from 4.1. Is it a bad idea to just upgrade to version 6? Or would they be better off going to 7? If it matters, these aren't particularly sophisticated us…

I am a new FM user and I would like to know how to make a copy of the database and make sure that I am not changing information on the old database. I believe I have to update links. Can anyone help me? Also, how do you add fields to the database? Thanks!