nfregistrar

Using FP 8.5 on a PC. I have mistakenly changed the File Options to Logging in Using Guest Account and Switch to Layout, Data Entry. So when I access that file, it comes up in guest mode with out asking for a log in user. The file is password protected so I only have access to part of it. I can't change the File Options as Guest doesn't have that priviledge. How do I get out of this? I have not been able to find a way to switch users. Dave

I checked it again. It works in FP7. To the best of my knowledge this is what I do. It has been done over a 1000 times in the last year with out a hitch on both a PC and a Mac: One takes a raw data stream from a secure page on our web site, with 39 fields of data per record and copies it to the clip board. A Filemaker script in the main file is then run which does a little housekeeping and then calls another script in another FileMaker file which pastes the clip board to one of its fields. It strips out one record by looking for an end of record marker and puts that record into another of its fields. It then operates on that record in the field and finds all the field data separators and replaces them with tabs. (The "replace" symbol look like a square on my PC). It then exports the resulting field into an external file called data.tab. (When I use fp7, data.tab definitely has tabs in it but not in fp8.5.) Control returns to the main script which imports the data from data.tab as tab separated data into 39 fields in a new record in the main file. This repeats until all the records have been done. When I do it in fp8.5, all 39 fields pile up in the first field as there are no tabs to separate them out. Anyway, if I can't make it work in fp8.5, I will need to either stay with FP7 or find another way to make it work. Dave

I sorry, I don't understand what you are telling me to do. Is there a difference in FP8.5 that prevents it from writing a text string like: data1data2 etc. to an external file using the Export Records command with out losing the tabs? There are 39 pieces of data with a tab between each. It still works from the same database when I run it in FP7 instead of FP8.5. Dave

I recently upgraded from 7 to 8.5. A script that I have been using for a long time in 7 no longer works now that I am running under 8.5. The step that fails is: Export Records["data.tab";Windows ANSI] File Type is Tab-Separated Text Files (*.tab) Field Export Order is string1. String1 is Type text with a string of data separated by tabs in the field. It has only one record. When it writes to data.tab the tabs are lost. If I stop the script just before the export step and cut and paste string1 to data.tab, and then skip the export step then the data works in subsequent parts of the script that depend on the tabs being there. Dave

what is the general format for a script to send an email using verizon/yahoo. Something roughly like this worked for Juno: Open URL["mailto:email address"&?subject="subject"&"&body="text"]

I tried to print a script. I selected Print to File and Generic/Text Only. There were 2 problems. First: The screen became partially filled with large black characters written on top of each other. Second: When I opened the file that I selected, There was nothing there. I used Wordpad to open the file. Is this supposed to work? Printing the script directly to a printer works fine. Dave

Thanks for you help. I think that I am almost there. I have a filemaker file that has just one field and one record. A script pastes the raw data in that field and using find and replace, it removes extraneous stuff and puts tabs between the fields in the data. There is a unique string at the beginning of each record in the raw data. The script removes the first one and puts returns at the beginning of the rest. Result, a return at the end of each record except the last one. All this takes place in that one field in that one record in Filemaker. It is then exported to a tab file. In the main Filemaker file this script is called and then the tab file is imported. The problem is that is apparently doesn't see the returns and tries to put it all in one record. Oddly, if I manually enter returns in the tab file and import it, it acts as if it sees 2 returns. Alternately deleting the return manually in the tab file and putting it back back, it now sees the return. :???

I though that I had replied to this, but I don't see it anywhere. My apologies if this is a repeat. Thanks for all the good ideas. My basic questions now boils down to this: Can the find/replace in Filemaker 7 script be used to find "returns"? If so, how does one specify a return.

Is there a way to use scripting in filemaker that will do the job of converting return-delimited text to tab-delimited text proir to importing it into a filemaker database. FileMaker Pro 7 Bible (page 523) suggests using MS Word to do the job. However it would be much more useful to skip that step. I need to do it for each new piece of data or groups of data that I receive on a daily basis.

Thanks, that works just fine, although I did not find the need to use %20 for spaces in the body.

I am using Juno for my email. If I use Send Mail with To: , Subject: and Message: designated, I get the subject and message OK but no address in Juno. If I use Open URL with the following:(for example) mailto:nfreg@juno.com?subject=Registration I get the email address and subject OK in Juno. I don't remember where I got the syntax from. If there is further syntax that works, I don't know what it is. I have been using the Open URL version for some time, with a script that copies the text so I can paste it in the message area when I get to Juno. Does anyone know how to get all three in Juno (email address, subject and message) automatically?

hi bd You were right "what i knew wasn't so". Wrong reference in my script to older version of Excel file. Thanks for your help. Could you please remove my attached files? Dave

You guys were right. It was supposed text data. My script was referencing the wrong folder which had an older version of the Excel data in which it was a number. Thanks to all for your time on my boondoggle.

As a follow up, the script used to import is called data. Camp.fp5 is password protected. Email me if you need the password.

Here are my Excel test file and the FP5 file. testfiles.ZIP