Search the Community
Showing results for tags 'FM9'.
Found 222 results
-
FM9 incompatible step in calculation?
Justin Close posted a topic in Calculation Engine (Define Fields)
I was doing a bit of work for a client who is running FM9 clients, connecting to a file hosted on an FM11 server. I don't have FM9, so was doing development on FM11. I thought I had checked out that everything was compatible, but I somehow generated a calculation that doesn't evaluate on 9, but does on 11. The components of the calculations and custom functions used all appear to be innocuous... I am hoping someone here knows what I tripped up on. Here's the field calculation, and the 2 custom function definitions that it uses. The entire point of this calculation is to take a mish-mash text field that they have and make it sort nicely. For this bit I added, I'm just concerning myself with sorting some suffix numbers that occur between parentheses, e.g. 12345(A-1). Field calculation definition: Let ( [ _fileNum = Files::File Number ; //Position of 1st open/close parens, and then extract the text between them: _sParen = Position ( _fileNum ; "(" ; 1 ; 1 ) + 1; _eParen = Position ( _fileNum ; ")" ; 1 ; 1 ) ; _suffix = Middle ( _fileNum ; _sParen ; _eParen - _sParen) ; //Count the leading digits before any non-digit character, e.g. an alpha, or dash or space, etc. _count = CountPrefixDigits ( _suffix ; 0 ) ; //Remove extraneous characters (dash, space): _suffix = Substitute ( _suffix; ["-";""]; [" " ; ""] ) ; //Pad out the string to min 5 characters (helps 75-A sort next to 75): _suffix = _suffix & Left ( "!!!!!" ; 5 - Length (_suffix) ); //Reverse the character sequence (so the Code() call works out better): _suffix = ReverseString ( _suffix ) ]; _count & Code ( _suffix ) //prepend the digit count, but don't encode that count, just the rest of it ) -------------------- 'CountPrefixDigits ( aString ; aCounter )' custom function: If ( IsEmpty ( GetAsNumber ( Left ( aString ; 1 ) ) ) ; aCounter ; CountPrefixDigits ( Right ( aString ; Length ( aString) - 1 ) ; aCounter + 1 ) ) -------------------- 'ReverseString (aString)' custom function: If ( Length ( aString ) > 0 ; ReverseString ( Right ( aString ; Length ( aString ) - 1 ) ) & Left ( aString ; 1 ) ; Left ( aString ; 1 ) ) Thanks, Justin -
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 is corrupt! I've tried multiple times, with different extraction apps and in different directories. My question is; Does anyone know a place where I could obtain version 6 (or better yet, 4.0) for an OSX computer? I've looked everywhere! Thank you for your time, Tumma K.
-
Hello everyone. How can I set the calculated value of field C to the number of records having field A equal to the value inserted to field A and field B equal to the value inserted to field B? For instance with the following situation record 1 => A = "house", B = "pay" record 2 => A = "house", B = "win" record 3 => A = "car", B = "pay" record 4 => A = "house", B = "pay" when I create a new record having A = "house", B = "pay" C should automatically be 2 (since record 1 and 4 have the same A, B. Thanks
-
Hi everyone. I have a field called documents rendered as checkboxes (values are taken from a value list). Now I need to perform some calculation (basically to set the value of an other field) according to the checked values (number and values themselves). Which function should I use to get the list of checked values? For instance in the situation below: [ ] Book [ ] Magazine [ X ] Journal [ X ] Diary [ ] Paper I wish to get 2 and to get Journal and Diary. Thanks.
-
FM3 upgrade to FM Pro 5.5 - Windows 8 installation possible?
MrEddByrnes posted a topic in FileMaker Legacy fp3 and fp5
I'm hoping my question can have a happy ending. In the mid-90's, I purchased Filemaker 3. When Filemaker 5.5 Pro was released, I bought the update CD, which requires the user to either have FM 3 installed or to have the installation CD for FM 3. I've used it all these years, most recently with Windows XP Pro, and it has worked just fine. The databases I began with were long ago converted to FM Pro 5.5 databases. I'm still using FM Pro 5.5 on a laptop with WinXP Pro, but in 2013, I purchased a PC with Windows 8. I haven't been able to install FM 3 on it, therefore can't install FM Pro 5.5. I am retired and rarely use Filemaker, but I have a few Filemaker databases I'd like to add to my Win 8 machine. I don't feel it's worth upgrading FM for the sake of using a couple of databases. Has anyone else run into this situation and/or have a (possible) solution? Is there perhaps any other software that can read FM 5.5 databases? Thanks in advance for your help. -
I am using a custom filemaker solution for medical office billing written with fp5 running on a mac with snow leopard. In addition, I have a patient management db (which I wrote) that is linked through pt. ID number to the billing program allowing transfer of some demographic information (name, DOB, etc). Other than being limited by hardware restrictions, the billing program serves our needs for now and upgrading to fp12 will take some time (and money). In the meantime, I am upgrading my pt. management program to fp13 and would like to move new patient demographic information from the billing program ( fp5 running on snow leopard through Parallels) and the new pt management program ( fp13 running on OS X 10.9) on the same mac. Ideally, demographic information would be entered once into fp5 and then a scipt would make the data available for fp13. Any ideas on how to make this work?
-
Filemaker 5.5 database will not delete records on-line
randyinla posted a topic in FileMaker Legacy fp3 and fp5
Hi, can anyone tell me why my on-line database might have stopped allowing me to delete records? All of my access privileges and passwords are correct. thanks! -
Are there still hosting providers for filemaker 5.5?
randyinla posted a topic in FileMaker Legacy fp3 and fp5
Hi, I still use filemaker 5.5 and am very happy with it and don't want to upgrade. Does anyone still host filemaker 5.5? Thanks! -
Seeking the FMP Developer updater to 6.0v4 on Windows
Erwin R. posted a topic in FileMaker Legacy fp3 and fp5
Hello, I'm seeking the updater to FMP Developer 6.0v4 on windows platform. Download from FM is no longer available Does anyone still have it? Thanks in advance! Erwin EDIT: "OK, we found it back on an old backup system." -
Suddenly, after several years of use, FMP 6 won't open. (this happened on two not-connected computers). I get an error message "The feature you are trying to use is on a CD ROM or other disk not available. Insert FMP 6 disk" When I insert the original disk, it still doesn't work. When I uninstalled and reinstalled the program, it still doesn't work. I also notice that there is no filemaker pro.exe file in the Filemaker Pro 6 directory. There are FM subdirectories and many .dll files, but no .exe Any ideas? And, if this is a dead end, what steps can I take to get my data? 1) would the data import with a newer version of FM? I would rather not purchase 13. maybe a discounted 7 or 9 found on ebay? 2) Is there any other program I could use just to import my data? My database is a very simple address book? Thanks for any advice.
-
Hi, We are using FMP version 9 and want to do the following Post a simple web form from FMP 9 for our users to enter data. Allow the user to log in through our current employee portal, click a link and access the FMP form. Restrict the user's access to records in the FMP database to only their location. FMP must use the portal login credentials to authenticate them against Active Directory (the SSO part). Sounds simple enough but I haven't used FMP for several years (got into the management end of things). Publishing the form for web consumption is no problem. It's the SSO part that I certainly need help with. It would also be OK for the user to come in as a guest (without having to log in again) as long as the data they see is only for their location. There are about 300 locations that would have access to the form so it's vitally important that the data be segmented for each location. I would prefer to create 1 database for all 300 locations rather than creating 300 versions of the same database. If you can point out any posts that speak to these issues I would appreciate it. Jammer
-
Hello All! I have a hugh problem. Today it works fine on my XP SP3 but the day I have to change computer I have to change platform from XP to 7 or 8. I have a huge number of registers working together so its no option to migrate those to FP7 format or re-write for FP7 as it would take to long time. Today I work with Shubeck Pdf plug-in which combine several pdfs within my script and put out an email with the pdf as attachment. It works great with ghostscript version 8.5. I have borrough a computer with Windows 7/64 Bit for testing purposes. I found ghostscript 9.01 for windows 7/32 and installed it. Seems to be OK. I then installed Schubeck plug-in but under installation I got an Error-messeage with a lot of 0 and 705 at the end and it tells me that it couldnt found the printer drivers (which must be the ghostscript?). With a lot of work I can re-write my pdf-printing scripts if some other multi page pdf-printer for FM5 is avaible and works on W7/64. I hope some of you have some ideas which can help me and maybe have a plugin to sell. -Per
-
Hello, I lost my Filemaker Pro 3 CD, but it is still running under Windows XP. Now I want to change to Windows 7. I have an Filemaker Pro 5 Upgrade licence but I still need a CD for Filemaker Pro of a previous version, which I can also install under Windows 7. Does somebody know if it is possible to install FM 2-4.1 under Win 7 and where to buy it? Thanks!
-
I know, why would anyone be using FM 5.5! I have a client that uses FM Server 5.5 and FMP 5.5. They somehow have the access privileges configured to the layout and field level with no groups. This setup also has standard users (by their shared password) set to not be able to edit records in the Access Privileges Dialog, yet they can create new records and edit the new record. I had to add some new fields for them to use. The standard users cannot edit these new fields. They can edit the already existing fields. WTH? I need to have it so a standard user can only edit a new record that they just created but also be able to edit the new fields I just added to the database. They can edit the new fields if I put a checkmark in Edit Records in the Access Privileges Dialog, but then they can also edit records made in the past and the client does not want this but wants them to only be able to edit a new record they just created. This makes no sense to me. Can anyone help? Dave
-
Hi guys -- I've FM 5.5v1 running on Mac OS 10.6.8. On one of the databases, everytime I created a new field FM would automatically enter it on the Table view but some weeks ago it stopped doing it. The database is around 90 fields so it's not too large. Does anybody know why and how to fix it? Best!
-
Hello, Am I struggling with something or what! I fear that I'm trying to do too much with FMP9 and certainly more than my brain can handle! Simply put, I want to use a search string to filter a portal. Is this simple? On the Master table I have records of unique reference numbers (think contracts) consisting of an alphanumeric string, at least 9 characters long. On the portal table, I want to enter a string of 2 or 3 (random) numbers, then, (contract-side) perform a Position calculation which determines whether or not the string is contained within each record's reference number. The match and the filter would be based on Position equalling 1 (not 0). Problem 1: the Position calc is non-indexable so the relationship can't be made. One potential solution I've researched is to introduce a ValueList comprised of the record number and the Position calc result, in a self-join, then have the original Master table do a look-up on this TO. The new problem however is that having succeeded in indexing the field and making the relationship work, the indexing needs to be refreshed each time a new search string is entered... I'm into three tables and two more TOs currently. Constant fiddling and tweaking in an effort to fix the problems has probably broken more than it's fixed! I'm snow-blind, clueless and currently can't even make a script do this! Has anybody got any suggestions how to go about this more successfully?
-
Hi all! Does anyone of you run FM 5 on Windows 7 or 8? Do you have plugins from Schubeck pdf? Does it work? -Per
-
Convert a decimal number to time format
stixstudios posted a topic in Calculation Engine (Define Fields)
Hi there, I'm currently developing an ongoing solution where I have used decimal times. ie. 1.5 = 1hr 30mins, 3.75 = 3:45 etc. The reason I used decimal was clear to me at the time but now I would like to dispay the resulting calculation in "proper" time format. I could probably nut it out using some convoluted method but was hoping that someone has a more elegant solution. Cheers, Steve. -
I have a couple of errors on the server and I am new to Filemaker. Below are three errors that have reported in the event viewer, application logs. 1. File "Promissory Note.FP5" could not be opened: either allow FileMaker Server to host Single-User files or set the file to Multi-User in FileMaker Pro. 2. File "Receipts.fp5" could not be opened: maximum number of files already opened. 3. File "Credit Card Charges.FP5" could not be opened: a database with that name (or the same initial 31 characters) is already open; please rename one of the files. The only one that I could find information about was #3, and it was more than 1 file that I had to rename it was like 20. I just added a 1 to the end of the file name in the databaseBackup folder and those problems seemed to correct themselves (after I did a stop and start of the Filemaker Server service). Not sure on #1 and #2. Any advice on how to resolve these issues are greatly appreciated twells@uca.edu
-
Hi everyone and excuse me please if I seem ignorant of the inner workings of Filemaker. I stuck together my database a couple of years ago when my brain was younger, fresher and it took me the best part of 2 months !! We use it for writing invoices and creating quotations for my wife's business. It has worked absolutely brilliantly and I think FM is a wonderful bit of software. However I have just upgraded my wife's computer to Mac operating system OS10.7 (Lion) and suddenly a strange thing seems to be happening. This only happens on her computer and not on mine running OS10.6.8. When she uses one of the little drop down calendars to insert a date it begins fine but when the date appears on the page the year appears is in Japanese/Chinese Kanji characters. (I have attached an image of the characters) I have, of course, checked the language prefs etc in her computer and that all seems ok. Anyone else had this problem or know of a solution ?
-
I have heard from several sources that the FileMaker Pro cache should be set to 256 MB. I would like to heard recommendations on cache size for FM Pro 9 and the following memory sizes: 1 GB 2 GB 4 GB Any help would be appreciated.
-
Help needed, "FileMaker cannot share files because another user is already sharing files"
chiyunpai posted a topic in FileMaker Pro v7 – v9
Hi, I am having a problem with FileMaker Pro 9 in MacBook Pro (Lion). I got an error message "FileMaker cannot share files because another user is already sharing files" when I started my databases. I have tried all the solutions I could find on the internet, but the problem still not resolved. Any help from you will be very much appreciated. Below are what I have tried. 1. Uninstall and reinstall. (no luck) 2. Set IPv6 in Network advance setting to "Linked-local onlly". (no luck, it is not possible to turn it off). 3. No other copy of FM Pro is running 4. No FM Pro server is running in the network 5. unplug network cable from the computer (still getting the error message) Whatelse can I do to get rid of this problem? Thanks a lot in advance. Chi -
Has anybody experienced a failure within a new calculation of the "Evaluate this calculation from the context of.... " list to update with all appropriate relationships in the relationship graph. My file which started life in FM5 lost its reference to the main table recently, necessitating all new calculations to be copied from a previous calculation, which still had the full list, and then amended. I have partially overcome this problem by deleting the two relationships that remained in the list. Somehow this forced the main table to reappear in any new calculations and a couple of others popped up as well. However, I am still missing about 20 that have been created over time. I would rather not delete these 20 as well and reinstate them because this appears to corrupt relationships / lookups in other files which use this file, not necessarily these relationships. There must be an underlying table that is being referenced and has become corrupted. Any ideas how I might force it to behave, please?
-
Is there any problem running a FM9 application in Windows 7?
-
When I open a series of files I find that the majority are neither listed in the Window - Open Files listing nor the Window / Show Window (hidden files) listing. The only practical way to navigate between files is to minimise the one in view, select the other file I need and maximise it. Surely there must be an easier way than that? I wonder whether this is an error on my system or a shortcoming of Filemaker 9 Advanced?
