zincb

Here is a relatively accurate one that I hecho-ed a mano. Avery 5366 File Folder Labels.fp7.zip

I work for a DoD agency and my Filemaker solutions are being challenged by an impending need to grant access based on a user's Common Access Card (CAC), which is a physical card with a chip. The user is asked for a pin, which the card validates (three tries & then the card is locked)and there is some sort of PKI certificate that gets passed? Has anyone dealt with this before?

I maintain a set of Filemaker solutions on a Department of Defense network, using FMP 7 server & client. I would like to move to the unlimited thin client web-based version of FMServer. The problem is that DoD users may only access using their CAC cards, which store their PKI certificates. Does anyone have a way to validate PKI certs for CAC Cards?

It would be nice, but the solution runs everything from inventory to press schedules to time sheets, for three large printing facilities, with full historical archiving. The current number of fields is unlikely to be reduced, however the number of files will be, as some of the related FP5 tables will (someday) be combined into single FP9 files.

THANK YOU! I could not get the iKey program to work, as it "blew up" when I told it to run a script, but your suggestion gave me the idea to try QuicKeys (After I googled twenty times to remember the name). I downloaded the 30 day free trial and in less than 10 minutes have a script running that does one complete loop from Excel to FMP, using the F3 key -- such a simple blessing!. Now I just have to work up the courage to let it loop automatically!

Am porting a set of FMP5 files to FMP9. 6,782 field names need to be converted to standard format (e.g., remove $ chars, leading numerics, etc.) I have all the fields in an Excel SS and am planning on cutting & pasting NewName over OldName, but it will be horribly tedious. Is there a third party application that will run on Filemaker 6, 7, 8 or 9 that can make this task bearable?

Here is a file that illustrates what is happening to me -- if you click the export button, and look at the resulting text file in a processor with "invisibles" showing you will see that the paragraph returns (backwards P with a double-staff) in the calculations get converted to soft line feeds (down arrows, bent to the left). My guess is that you are using a combination of calculated fields and "stacking" them on top of each other. You only get a true paragraph return character between layer, but not inside of each layer. My problem is that I am stacking everything inside of a calculation, which is why I am getting only soft returns. So, to answer your question, if you reduce everything to a single calculated field, your hard returns should go away. It looks like my only answer is to use a looping script that builds each record in a single humongous global text box and then export it... hopefully before the memory limit is exceeded. Ugh-Lee, at best! Paragraph_Endings.fp7.zip

I am having the exact opposite problem. In several calculated fields, I use the paragraph end character (¶) and when I export the combined calulations for all the records in the found set, the paragraph returns I entered are all "soft" end-of-line returns (in Pages and in MS Word they look like a down arrow, bent to the left MS Word finds them in Windows with CNTL-l, but can't find them on a Mac). The only true paragrah break occurs between each record. Does anyone know how to get "true" paragraph returns?

The Windows ODBC manager works fine, too.

Description: To reduce the number of hours spent doing sudoku puzzles, here is a basic helper file. It will keep track of the possbile numbers a cell can be. It is crude, but works -- would love to see one that uses stored procedures or those cool calculation modules. You need to color the numbers yourself, to back out your guesses; I use black for ones that I know for sure & red for guesses and the ensuing stream of dependencies. I wanted a script to clear only red numbers, but could not find a text format "tester" script step. Any help? Working Under: Dev 7 Solution Status: Beta Pre-requisites: Author(s): zincb Date: 12/01/05 Credits: Instructions / Other Info: Disclaimer: FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify. sudoku.zip

I have been trying to get to the help section of www.filemaker.com for two days and my browser does not find them. I can get to filemaker australia and in the UK, but they send me back to the US branch to download patches or to get help. Is anyone else having this problem?

Here is my problem: Table 1 is SYSTEM. Table 2 is COMPONENT. Table 3 is BANDWIDTH. A SYSTEM can have zero or many COMPONENTS. A COMPONENT may have zero or many BANDWIDTHs. I want to export all data from all tables, to a single flat file. If I export with my "focus" on BANDWIDTH, I only get COMPONENTS that have a BANDWIDTH, and only SYSTEMS that have those COMPONENTS. So, to export the whole enchilada as a single flat file, I need to be on the SYSTEM table, to export all local and linked data. The problem is that, in the export file, SYSTEM data is only in the first row of the export set. Each succeeding row contains data from COMPONENT, or both COMPONENT and BANDWIDTH, but does not contain the SYSTEM information. This data, no-data, pattern is repeated for each SYSTEM record in the export file. Because the SYSTEM data is not entered into the rows containing COMPONENT and BANDWIDTH information, I must run a looping script on the entire exported file, to copy the parent data into subsequent rows. With zillions of records this extra step is extremely time-consuming. Is there something I can do to avoid this last step?

Oh, nooo! This ain't loooking good. How do I send an improvement suggestion to Filemaker? ... You mean that round thing by the door?

No, I am exporting from the topmost file. If I export from the bottom-most file, I only get data where the thread goes up to the top. Example: Table 1 is SYSTEM. Table 2 is COMPONENT. Table 3 is BANDWIDTH. A SYSTEM can have zero or many COMPONENTS. A COMPONENT may have zero or many BANDWIDTHs. If I export from the BANDWIDTH, I only get COMPONENTS that have a BANDWIDTH, and only SYSTEMS that have COMPONENTS. So, to export the whole enchilada as a single flat file, I need to be on the SYSTEM table, to export all local and linked data.

I am struggling to understand FM7 exporting from related tables, into a single file. I have three "daisy-chained" tables in a single file. I want to export ALL data from all three tables into a single flat file. When exporting, my focus is on the parent table. When I look at my exported file, the parent data is only in the first row of the export set. Each succeeding row that should contain the same parent data is blank where the parent data should be. The data from one or both of the child files is in these "parentless" rows, and looks fine. This is repeated for each parent record. I am faced with performing the export and then running a looping script on the entire exported file, to copy the parent data into subsequent rows, but this seems ludicrous. I must be missing some switch that needs to be set... Please help, me kind sir/madam... I am lost...

Looks like this is a documented bug: http://www.fmforums.com/threads/showflat...SID=#Post135451

Just found this thread after I posted the same question. One workaround is to use an extra slash and asterix in the calculated URL. In my example: "http://www.google.com" & "[color:"red"]/*/search?hl=en&lr=&q=" & GoogleMe & "&btnG=Google+Search", and the resulting "good" page has an URL of: http://www.google.com//*/search?hl=en&lr=&q=prd-13&btnG=Google+Search. It works but it looks strange.

If I use Firefox and go to the Google search page (www.google.com) and type in [color:"purple"]"prd-13", and press Enter, the resulting page has an URL of: [color:"blue"]http://www.google.com/search?hl=en&q=[color:"purple"]prd-13&btnG=Google+Search Using this as a guide, within my database, I created a local text field, called [color:"green"]"GoogleMe" and a button that calculates the URL: [color:"orange"]"http://www.google.com/search?hl=en&q=" & [color:"green"]GoogleMe & "&btnG=Google+Search", but when I press the button, the URL of the "bad" page that results is: [color:"blue"]http://www.google.com/[color:"red"]/search?hl=en&lr=&q=[color:"purple"]prd-13&btnG=Google+Search (note the extra slash after google.com) I found a workaround by using an extra slash and asterix in the calculated URL: [color:"orange"]"http://www.google.com" & "[color:"red"]/*/search?hl=en&lr=&q=" & [color:"green"]GoogleMe & "&btnG=Google+Search", but the resulting "good" page has an URL of: [color:"blue"]http://www.google.com//*/search?hl=en&lr=&q=prd-13&btnG=Google+Search I would prefer to stick to "standard" URL construction. Is there any way to make the extra slash go away? (FMD7 Win2k)

I have two problems. The first problem is that I have a set of Numeric Filemaker fields that, when I export records to a DBF format, zeros are entered into any field that is empty. I need them to stay blank. Is there some setting that prevents zeros from being entered when using a DBF? My second problem is that I am trying to export a DBF file from which Visual FoxPro can read a logical field from. I tried filling with ".F." and ".T." but the FoxPro app sees it as a Char(3) field, not as a logical. Is there any way to flag a Filemaker field to be exported as a "true" logical ?

WRONG WRONG WRONG Wim Decorte has it right; you either need to install everything on each client PC or you need to run something called Terminal Services, which is a Microsoft product. It worked so nicely in FMP5, why'd they have to go and break it?

By installing the VLA on the server and sharing the directory, there is no need to go to each PC and install Filemaker, and then install all the patches. We work in in several secure (every door is locked) buildings in different parts of the city. Everyone uses the same shared Filemaker executable, up to the VLA limit. Although we could get away with a shortcut to the Filemaker Application, without a shared folder, our users have a habit of deleting their shortcut when they clean their desktop. They can then go to the shared drive and copy a new shortcut, all by themselves. Both are on the same server due to funding constraints. We hope to dump the FMP5 apps & files in the next 3 months. The believe-it-or-not solution to this installation problem appears to be installing Filemaker 7 on the server, in the shared directory, from one of our remote clients! We are now installing the v3 update and hope it still works, when through. Bayern, eh? I grew up in Obergiesing! It's a small world. Hab'd'Ehre!

Am trying to install a 10 seat Filemaker 7 volume license on a Windows 2003 server, for use by Windows 2000 clients. The server is running FMP server 5.5 for normal use & the FMP7 is for testing, as we migrate our solutions to FMP7. The program runs fine, sitting at the server, but when I share the folder, even with FULL admin rights, I get "This application has been installed incorrectly or modified by another program. Please run the Installer to get a fresh copy of the application after determing the cause." I uninstalled, tried installing to the default C:Program Files directory, tried the v3 update, rebooted the server, stopped FMP server 5.5 services, but nothing seems to work. Has anyone seen anything like this before?

I downloaded the patch and it DID fix it! Yee-hah!

I am re-building in FMD7 from scratch, an existing FMP6 solution that imports a large (53Mb) text file and parses it, via 12 calculated fields, with some of the calculations relying on other calculations. It used to take 5 hours to import with FMP6, with indexes on. However with FMD7, with all indexing off, 24 hours later it still had 6 Mb left to go, and had dropped from ~8000 bytes/second to ~200 bytes/second. Disgusted, I killed the job, and am now pre-processing the text file using MS Access, which imports & parses it in about 5 minutes. So how do I justify to the budget-controlling techno-weenies why I need to use a "non-standard" product like FMP7, when I need Access, anyway & is so much faster? Remember, their eyes glaze over after 20 seconds... I am upgraded to latest FMD7 patch... is there a patch or a workaround?

In case FMP developers (the ones who develop FMP, not develop with FMP) are listening, please make my scrolling mouse scroll. Calculated field, stored: NoScroll = [1,000 tiny irritations = 1 pita]