leahpo

We use Troi File Plug-in with our FileMaker 6.0 Pro database to import text files into the FileMaker database field. Our text files could be larger than 64K, and the plugin imports text file in 64K chunks. We find it very useful, and it worked OK until recently. We have a new collection of files that contain accented characters, in ANSI format - French characters, as well as Registered Trademark sign, degree, etc.. All text files are located on our Sun computer, and the FileMaker Server 5.5 is on the Mac OS X. Troi File Plug-in imports the data as MAC characters, i.e. it thinks that the original file is Mac, and converts it to ANSI. When the text is viewed in FileMaker, it's completely wrong. I can, probably, use Substitute to convert characters back to ANSI, but this is a production database, and we process up to 50,000 records a month. Substitution will significantly slow the process. I can convert all text files to Mac format before importing, but it is undesirable, because data entry staff have to review text files before importing. Is there any way that I can set Troi File Plug-in to import data as ANSI? What if the server is Win 2000? Would it make a difference? This is really crucial - this is production application, and we do not have any other tool that can import data from text files into FileMaker. Thank you Leah

Sorry, I did not get any replies in the first post, and thought that may be I posted it in the wrong group.

Hi, Would anyone know how to capture find criteria for a Number or Date type field when >, <, <>, etc. operators are used. My users want to see search criteria before they perform a search, and want to be able to print them for future references. I created a gSearchCriteria global field, which is populated by a script which is looping through all filelds on a layout (they are in a FIND mode). If Status(CurrentFieldContent) is not empty, it appends Status(CurrentFieldName) and Status(CurrentFieldContents) to a gSearchCriteria global field. It works fine except when the Field Type is Date or Number, and they enter ">", "<", or other other logical operators. In this case CurrentFieldName is captured, but it appears that CurrentFieldContents is empty. I tried Set Field, Insert Calculated Results, Copy / Paste from the current field to the Search Criteria global. Is there a way to capture the data? Thanks

Hi, Would anyone know how to capture find criteria for a Number or Date type field when >, <, <>, etc. operators are used. My users want to see search criteria before they perform a search, and want to be able to print them for future references. I created a gSearchCriteria global field, which is populated by a script which is looping through all filelds on a layout (they are in a FIND mode). If Status(CurrentFieldContent) is not empty, it appends Status(CurrentFieldName) and Status(CurrentFieldContents) to a gSearchCriteria global field. It works fine except when the Field Type is Date or Number, and they enter ">", "<", or other other logical operators. In this case CurrentFieldName is captured, but it appears that CurrentFieldContents is empty. I tried Set Field, Insert Calculated Results, Copy / Paste from the current field to the Search Criteria global. Is there a way to capture the data? Thanks

Hi, Would anyone know how to capture find criteria for a Number or Date type field when >, <, <>, etc. operators are used. My users want to see search criteria before they perform a search, and want to be able to print them for future references. I created a gSearchCriteria global field, which is populated by a script which is looping through all filelds on a layout (they are in a FIND mode). If Status(CurrentFieldContent) is not empty, it appends Status(CurrentFieldName) and Status(CurrentFieldContents) to a gSearchCriteria global field. It works fine except when the Field Type is Date or Number, and they enter ">", "<", or other other logical operators. In this case CurrentFieldName is captured, but it appears that CurrentFieldContents is empty. I tried Set Field, Insert Calculated Results, Copy / Paste from the current field to the Search Criteria global. Is there a way to capture the data? Thanks

Thanks, Old Advance Man I turned File Sharing off on this server a while ago, when I started it initially, but someone must have turned it on again, though no one remembers doing it. Is it possible that it will turn itself on when Mac server is rebooted? Now, we cannot turn Mac OS X off without re-installing operating system. We have Mac OS 10.01 running in native mode, and OS 9.1 is also installed, runs in emulation mode. I have FileMaker 5.0 server installed, as well as FileMaker 5.5 server. The reason I am running FileMaker 5.0 server, because FM 5.5 server running on Mac OS X was extremly slow, even internally, and I could not find the root of this problem. It runs reasonable fast on FM 5.0 server, running classic 9.1 in emulation mode. I run field-by-field data comparison between two versions of the database - current and the version just after data was migrated from the legacy system(Oct 2001). There are a few records that have corrupt data - staff that is using this system (chemical database) are scientists who keep track of what they change and when, so they know what was corrupted. This Mac OS is used ONLY for serving FM databases, and no one has access to this computer for any other purpose. Is it possible that File Sharing caused data corruption in FileMaker files? I am puzzled by this. Thanks Leah

Hi, I need to monitor all transactions in the database. I already have field that records Modifier Name, and Modified Date/Time. But these apply to whole record. I have a file with > 400 fields, and I wanted to create a log of: Field Name & Modified Date & Modifier Name. I created Transaction log field, text, and set field option = calculation = Status(FieldName) & Status(CurrentDate) & Status(UserName). I tested it, and this field is not updated. I can create a script that will do this and attach it to each field, but there are too many fields. Any better ideas? Thanks

Hi, I am booting from Classic - OS X is running in the background. File sharing is on - I checked. What does file sharing have to do with corrupt data? And how can ONE character in a large (few thousand characters) field be changed? Leah

The FM 5.0 runs on MAC OS in classic mode 9.1.

Hi, Would anyone have an idea what could be the problem: The application resides on the Mac OS X server, FM Server 5.0 One of the users is creating records using a copy of the application, locally on her Windows ME computer. She exported the data, sent it to me, and I imported it into the server-based application. The record in question has one letter in one word of one field(out of >400 fields)changed to a period. The user says that no one changed that particular field, and it happened as a result of the import. Since I still have the file that was sent to me, I re-imported it again - and the problem is not there. I was wondering if anyone knows of a possibility of data corruption during import. Also, the server is MAC OS X, and the client is Windows. When the records are created the user copies/paste from other Windows applications. I think that the user changed it by mistake, but just to be sure I wanted to hear other's experience. Thanks

Hi, I was wondering if anyone has a suggestion to the following problem: I created a Send Mail script in the server (FM 5.0 on MAC OS X) application which is triggered by a change in the field. It worked perfectly on mine and other user's client computers (PC's). I received a new computer, and, after installing FileMaker 5.5 on it, the Send Mail script will hang, and I have to abort the application (CTL+ALT+DELETE). I tried to select in Control Panel/Internet Options/Programs different programs as my default e-mail - Netscape, Outlook, etc - nothing worked. Then I installed Pegasus Mail MAPI extension, and it works now - it uses Pegasus as an e-mail program. However, if I try to change my default e-mail to anything else, it still uses Pegasus. Another user had to re-install FileMaker 5.5 on her computer, and, although the e-mail script was working on her computer before and she was using Outlook as the default e-mail, it does not work now and hangs her computer. I tried to install Pegasus MAPI extension on her computer as well, but it did not resolve the problem. She still cannot use Send Mail script. All other users are OK, they do not have Pegasus MAPI extension installed, and the script works fine for them, and they can select any e-mail program as default. I did not make any changes to the Send Mail script on the server. Any sugestions? I would really appreciate your help.

Thanks all of you for your replies. I was not able to do any testing because the application is running on Mac Classic 9.1, on FM 5.0. Users are doing data integrity check, and they do not want me to shut the server down even for a few hours. Right now it's working fine, they are relatively happy(last 2 days). I will perform all checks that were recommended and see if it will be faster. Leah

No, we are waiting for it. Could this be the problem?

Hi, We have FileMaker 5.0 server running on new Mac OS X server (G4 with dual processors, 512 RAM). It runs on Mac classic version 9.1 The application consists of 12 related files. Main table is large, about 85 MB, has over 800 fields, 170 layouts, a lot of buttons, etc. Most related files are quite small, up to 100 K each. For all files Local Data Access Companion and Remoute Data Access Companion are enabled. MAC server is on a network (TCP/IP connection). All users(6 right now) run FileMaker Pro 5.0 client and internally we access FM application via HOSTS button, by opening the main table on the server. Internally it is quite fast, it takes a few seconds to open all tables (start-up script), and navigation between records is fast. However, we have one user located far away, who is using the web (cable modem connection) via VPN to log into our system (network), and then she opens FM 5.0 client, and opens the main table via HOSTS button. After the user upgraded to cable modem in the beginning her connection speed significantly improved. It still was not as fast as local connection, but much faster than before. I thought that upgrade to FileMaker 5.5 Server (which runs in native mode on Mac OS X) will solve the problem. We finally received FileMaker 5.5 Server, I installed it quickly. I allocated maximum amount of Cache to it - Mac server is dedicated to FileMaker - and excitedly started it. And was it ever slow! It took me locally about 5 minutes to open files, any navigation, update, etc took a minute or more. I switched back to FileMaker 5.0 Server in classic mode, which starts slowing down very fast. FileMaker Server runs in the foreground. The users are testing the application, and are constantly complaining about the performance of the system. I have to restart FileMaker Server a few times a day, but I would like to run FileMaker 5.5 in native mode. Would anyone have any suggestions? Does anyone runs FileMaker Server 5.5 on Mac OS X? How is the speed? Thanks in advance for any help. LeahP