Doug Leib

We are a national company based in Tulsa, OK seeking an intermediate to advanced FileMaker Developer. As a member of our development team you'll be responsible for maintenance and ongoing development of existing solutions as well as new solutions. Responsibilities include: developing powerful, user-friendly solutions using FileMaker Pro; analyze code to find causes of errors and revise programs; write and maintain documentation of changes to solutions; provide technical assistance to inquiries regarding errors, problems or questions with programs; train end-users and technical support staff to use and support programs. Experience with FileMaker Pro, FileMaker Plug-ins, AppleScript or other programming and scripting languages are a plus. FileMaker certification would also be an advantage. The candidate must be competent with complex calculations, sophisticated scripting and relational database design. To succeed in the position you must be willing to learn new skills as needed due to the innovative nature of our company. This is a full-time position and while we are located in Tulsa it may be possible for you to work remotely. If you are unfamiliar with Tulsa it is a city with relatively low unemployment, low cost of living and a growing economy. As part of our team, youll enjoy paid insurance, vacation benefits, casual dress and a great work environment. We're looking to hire immediately! Email your resume and to dleib@digicutsystems.com or fax to (918) 622-5171. Or if you just can't wait call (918) 622-4725 and dial extension 1109.

Thanks for your interest but this position has been filled.

We are a national company based in Tulsa, OK serving the automotive after-market industry. We are seeking a highly skilled Relational Database Developer who excels at solving technical challenges. You

The see the suggestion I made above for using cron to create an event as a regular time interval... say every minute that would move the file from one folder to another.

The files you've listed above would not be viewable in FileMaker. I have created a solution where in addition to importing a file format that could not be viewed in FileMaker I also imported an accompanying GIF, TIF or JPG file to act as a preview of the non-viewable file I was importing. This may or may not be suitable in your situation.

I doubt that any of the ideas I was thinking of would be feasible in the situation you describe. Sorry.

Changing fonts won't solve the problem. Search for fuzzy or blurry or fonts and you should be able to learn more. Larger font selections may help.

Two ways to handle this... First - Save to a specified filename (probably what you are doing now) then using a plug-in like Troi File or a few others you can rename and or move the file as you wish with a unique name and not overwrite. I do this frequently using the Troi plug-in and use the date and time in the name as an example. You might like to incorporate the user's name. Second - New Millenium has a plug-in called DialogMagic that dynamically creates uniquely named export files from within a script, and lets you specify where you want them located - even create a folder on-the-fly. You said you currently save a copy... this function works with exporting which you may or may not prefer. As I already said these are not the only two plug-ins that can help you with this. Just two for example. FileMaker alone will not handle this for you.

Developer won't do anything extra for you on this one. Some file formats are viewable (not editable) in FM. Formats like EPS, TIF, GIF, JPEG... for example. What format are you working with?

I just spied the quote below on the FileMaker website. Seems kinda fast... what do you all think? I'm already rewriting but I can easily imagine that some users will not be able to convert by September 17. FileMaker Version: Dev 7 Platform: Mac OS X Panther

Likely you won't need so many long concatenated key with 7 since your relationships can be created with calculated keys.

hmcmahon... there's been alot said about this already. Do a search for fonts and you'll get an ear full. Let me guess... you're using Windows. One of 7's new features is anti-aliased fonts but there is an interaction problem with Windows font smoothing. This is not a problem on the Mac... just one more reason to switch. As far as layout mode in a runtime version... no! Then it wouldn't really be runtime. Depending what you need to do with runtime there are some dynamic layout tricks that work for certain situations but no where near as flexible as layout mode.

Is your server a OS X or Unix system? If so you could use cron and its move (see man mv) command to perform this function.

I tried the script before I posted it. It works. Just specify the field as indicated above.

First of all... you mention a password/account issue. I'm not clear on what your issue is. Be aware that passwords are case sensitive in 7. Second... as far as fields that are "automated" (do you mean calculating) but editable... in 6 or 7 this simple technique workd if I understand your need correctly. Create an additional editable field of the appropriate type ie. text or number... then whe you create your calculation check to see if it is empty. Example: ExtendedCost = Case(IsEmpty(EditableNumber), Quantity * UnitCost, EditableNumber) Let me know if I understood your situation. If so did this help? Doug

I've not used Event Manager but I do you Events regularly. I'm including a sample Events script step below and will explain. External ("OzEv-AddEvent", "script" & "|" & "My Daily Event" & "|" & "Data.fp5" & "|" & "Process Data" & "|" & "D" & "|" & 18 & "|" & 0 & "|" & 0 & "|" & "" & "|" & "" & "|" & 1 ) The last number "1" in the function makes the event "persistent" which will solve your problem. You can make an Event Manager created Event "persistent" by clicking the "persistent" checkbox when you create the Event. Following is an explanation of "persistent" events... "Persistent events, when added, will remain installed until they pass or are deleted. Events that are not persistent will be deleted when FileMaker quits or the plug-in is deactivated." -oAzium Events Manual Hope the helps, Doug

Based upon your original post I got the idea you'd like to actually mimic a manual find by range ie. 8400...8500. You can do this with the following script. Enter Find Mode [] Set Field ["8400 & "..." & 8500"] Perform Find [Replace Found Set] In my example I've hard coded the numbers for the range but these values could come from global fields populated by input from a Custom Dialog Box for example if preferable. Or maybe you'd use buttons to select the input range for the script. Doug

Without knowing more about the differences between the contact types, my first question would be do you really have to separate the tables? For example you say the contact types were vendors and customers. You could have a field that specifies the type of contact and direct them to a layout designed for that type. If that's not appropriate you could separate the contact tables but still combine and subordinate tables, ie. phones, addresses. I think in order to offer a fully qualified answer more needs to be known. What makes the contacts different? Are there any reporting requirements that would dictate a structural benefit to one method or another?

I think we understand your requirements now. There are multiple way to accomplish this, some of which have already been alluded to. Here's you situation in my opinion. While not particularly difficult... what you are trying to do will be tedious. Since each of your databases vary there is no one succicinct answer we can offer you here. Maybe someone else will see something I'm missing but there is no ONE script that we could relay here that will deal with all of the permutations in your scenario. Doug

This may be a permissions problem... I'll run it by my systems administrator tomorrow. Till then, Doug

FYI - Here's a Chronology of FileMaker Version. I think Yvonne is referring to FileMaker II. This is 3 versions older than FMP3 thus the unlikelyhood of an import into FMP3. It can be confusing. I suspect that tab or the like may be the only option. Yvonne, keep us posted. Doug

First of all, if the the RIP folder is not shared I don't know how you'll copy or move a file to it. Never the less... You'll either need a plug-in to do this or Applescript. This is beyond my basic Applescript knowledge but I could guide you using a plug-in. Waves in Motion and Troi both make a plug that will handle this task.

I looked at the user guides for FileMaker Pro 3-7 and found no indication that any of them could import the FileMaker 2 file directly. Are you able to open the database in 2 and export TAB or CSV maybe? I've go an old book at the office that might have the answer. I'll post it if so.

This would work fine. A variation would be to find the records you wish change followed by this script. Go to Record/Request/Page [First] Freeze Window Loop Set Field ["ST", "(insert calculation described in Ender's response)"] Go to Record/Request/Page [Exit after last, Next] End Loop As shown "ST" would be the field you wish to set with the abbreviation. This method is extra work to set up but will run faster than the replace technique with a large number of records provided that you FREEZE the window. Otherwise it will be slower and more work to set up. You decide which to try... either will have the same outcome. In general a looping script with the FREEZE WINDOW script step before the loop will be faster than a replace.

Yes this can be done a couple of different ways depending upon the exact particulars. To offer a detailed step-by-step answer one would need all the details. In general, the two methods that occur to me would be to either use a relationship formed by the match field and script the comparison and set field process or use a find instead of the relationship but the relationship method would be preferable. Doug