jorix

Just as Baloo says, you have to install the MySQL ODBC driver and use an import function in Filemaker to load data from MySQL. If you want to put something into MySQL, you can consider using the "Execute SQL" script step and execute whatever SQL statements you desire. (for instance: "INSERT INTO table (fields) VALUES (values)", or: "UPDATE table SET field = value, field = value WHERE id = someidvalue", and so on). Generally, all SQL statements supported by MySQL are possible to execute from within Filemaker. Good luck with your databases. Greetz, Jorix

Get cool and use a Resource Editor

quote: Originally posted by danjacoby: All I know is that everybody I know who has used both hates Access -- I mean as in "despises", "loathes", "abhors". They may not exactly love Filemaker ('cause there are always issues), but at least they don't hate it. I've worked with Access and I dind't really hate it. As a matter of fact I admire some functionality. While working with Filemaker I quickly realized that it came from the Macintosh platform, easy to use and stuf.. Filemaker doesn't understand Windows the way it should, as Windows is an event-driven OS and Filemaker isn't. The only events you can trigger in Filemaker is when a person clicks a button, or when a field-condition fails.. Therefore I think that Filemaker doesn't suit my needs, and Access gets way closer to the ideal database suite. (I hope I didn't insult someone by now...)

How come Filemaker Pro 5.5 Developer doesn't remember if the Remote Data Access Plug in was activated for a database? Each time I reopen the database I manually have to enable the RDAC for each database I open (about 20 databases)..

quote: Originally posted by Anatoli: If you will make some autolog procedure, let people log once and save their bookmark inclusive of their Name and password, then nobody is forced to remember something. That would work but then it isn't as dynamic as it was ment to be. You see, the beauty of a web-based application lies in the fact that you can access it from everywhere (at the office, at the customers or at home via VPN)

quote: Originally posted by Keith M. Davie: "...full NT Authentication so you can serve databases with fm unlimited from a fm server via the web and require your web-users to enter their NT username/password/domain combination in order to get access..." OK, I'll show my ignorance. I have no idea of what "NT Authentication" consists or how it works with the www. I fail to understand your complaint since I do know that FileMaker will allow you to set up your own username/password/domain (or any other combination you could want)if you want entry restrictions. All you need to do is create it. You can even set this up while employing an "all users" Web Security permission. SIMPLIFY ... Keith The point is that I'm not too lazy to set up the Web Security database, but that our users don't want to remember more than one username/password combination. You see, our users are people that don't use the computer as a primary working-tool, so it shouldn't be too complex for them. They just make some letters in Word, some presentations with Powerpoint, read and send mail with Outlook, surf the internet for a bit and register what ours they spent working on a project. The last part will be going via the Intranet soon, and it shouldn't be necesary for them to have an other username/password combination for the Intranet, otherwise they might not use it and that costs the finance department much time.. Maybe there's someone out there who created a plug in for this problem?

Yesterday we received the complete Filemaker 5.5 package (Server 5.5, Unlimited 5.5, Developer 5.5, Pro 5.5, WSC + Tools). After installing the Server 5.5 package, I quickly found out that the NT Authentication doesn't do what you expect it to do. It only ask the user to enter it's username/password/domain if the user isn't logged on to a trusted domain. After that you can't do a thing with the username (no status functionality...), conclusion: NT Authority doesn't work! As for Filemaker Developer 5.5: THIS PRODUCT RULES! We're now able to create a full Database Design Report in XML or as an Filemaker Database and finally the Scripts can be debugged an executed step-by-step. I'm really dissapointed of the NT Authentication part. Let's hope that Filemaker 6.0 contains full NT Authentication so you can serve databases with fm unlimited from a fm server via the web and require your web-users to enter their NT username/password/domain combination in order to get access... (I'll post that last part in the Future Requists, maybe they listen.. ) Well, on with the Web Security database again then. Greetz, Jorick Schram All-Round & Multi-Platform Developer VODW Marketing The Netherlands

When you have a FM Server 5.5 and FM Pro Unlimited 5.5 which hosts some databases from the FMServer via the Web Companion, and you're using NT Security for your databases on the FM Server, does the Web Companion prompts the user for an NT username/password for the databases it requests? I really need to do this, because our users don't really feel like remembering more than one username/password combination and they want to change their passwords sitewide. Please let me know Greetz, Jorix

That's an option, but then I have to create the whole tool for the Intranet, while I only wanted the users to get the status of their call, and the status of the helpdesk (availability, company global issues, etc).. I think I'll just add another file with nothing but two fields: username and logged_on_status. Then I'll create some HTML to find all logged_on_status="logged_on" and display that list. Thanks for your advices

OK, since many people mailed me about how to send a HTML mail from Filemaker, here it goes: The Database - Create three global fields (Recipient,Subject,HTMLBody) - Put the Recipients name in the Recipient field - Put the Subject in the Subject field - Put the HTML you want to appear in the mail in the HTMLBody field - Export the three fields to C:tmp.txt - Use the Send Message script step: Open Application/Document and specify my nifty application Nifty application?? - Use Visual Basic to create an application and use the following sourcecode: code: Private Sub Main() Dim strAddress As String Dim strSubject As String Dim strHTMLBody As String Dim objOutlook As New Outlook.Application Dim objMailMessage As Outlook.MailItem On Error Resume Next 'Open the exported file, read the records and kill it afterwards Open "C:tmp.txt" For Input As #1 If Err.Number <> 0 Then MsgBox "An error has occurred!" & vbNewLine & "This programs cannot be started without the existance of ""C:tmp.txt""...", vbOKOnly + vbCritical, "Error" Exit Sub End If Input #1, strAddress Input #1, strSubject Input #1, strHTMLBody Close #1 Kill "C:tmp.txt" 'Send the HTML mail using the imported fields Set objMailMessage = objOutlook.CreateItem(olMailItem) With objMailMessage .display False .SentOnBehalfOfName = "helpdesk@vodw.com" If (InStr(1, strSubject, "Status call") > 0) Or _ (InStr(1, strSubject, "Uw call is opgelost") > 0) Then .CC = "helpdesk@vodw.com" End If .To = strAddress .Subject = strSubject .HTMLBody = strHTMLBody .Send End With Set objMailMessage = Nothing End Sub This program reads the C:tmp.txt and uses its contents to create a HTML mail using Outlook. Perfect huh? Greetz, Jorick [ November 28, 2001: Message edited by: Jorick Schram ]

Is it possible to get a list of the users who are currently using a database? We're using a Helpdesk callregistration database and I'm going to put it online with web-companion. On the helpdesk-site I want to enable the users to see which employee is in the house/online. Thanks in advance! Greetz, Jorick

Yup, I knew that Filemaker Server 5.5 support NT Domain Authentication, and that Filemaker Pro 5.5 clients can logon with these credentials, but I'm searching for a way/possibility to let users logon to the web interface with these credentials.. So if anyone knows a way to do this, please let me know

...great... spaces won't work ....

Hi Lange, What you can try is to create a function with a parameter that's passed to the alert() function: <HEAD> <SCRIPT LANGUAGE="javascript"> <!-- function showalert(message) { alert(message); } // --> </SCRIPT> </HEAD> <BODY> <P><A HREF="javascript:showalert('[FMP-CurrentRecID]')">Click here to send the RecordID!</A></P> </BODY> This should do the trick. Greetz, Jorick Schram VODW Marketing

Cool, I'll rename all the index.html's with default.html's and create new index.html's with a refresh script.

Apparently that counts for all index.html's in the Web folder, since the one i'm trying to upload is in a subdirectory within the Web folder..

When I try to upload a modified html page to the Web folder of my Filemaker Pro 5 Unlimited server (Windows 2000), the files seem locked. The only way to upload the files is to stop filemaker, upload te files and start filemaker again... Is this normal? Or is there another way to upload the files without problems?

You don't need a font to do that. All you do is make the font the same color as the background and you're set.

Maybee you've all read my complaints about the fact Filemaker just can't send HTML mail via MS Outlook (Corporate/Workgroup Edition), just plain text. I now created a really cool workaround for this. What I did was create a Visual Basic Project and a script in Filemaker. The Filemaker script exports some fields I need in the mail message to a CSV file, the VB Project reads this export and uses the data to generate some HTML code for the Body of the mail. Next I used the MS Outlook object library to create a 1) Outlook Application Object and 2) Outlook.Application.MailItem Object The MailItem object contains an .HTMLBody property. If set, it creates an HTML mail with the HTML code from .HTMLBody . It's that simple! If someone wants me te clearify this solution, feel free to mail me at jschram@vodw.com . (hmm... I guess smiley's don't work in the Subject.. ) [ August 13, 2001: Message edited by: Jorick Schram ]

Sure, no problem. All you have to do is setup a printer, create a script that does a print setup step with restore setup options on. Repeat these steps for each printer you have (7 printers is not that much, believe me, we have about 30 to 40 printers in the building) and your done.

Is it possible to get some templates of the new style buttons of MacOSX? I would like to use them in my filemaker databases.

I have ten years experience in programming in almost any kind off language on the PC (started in GW-BASIC, TURBO BASIC, TURBO PASCAL, ASSEMBLY, TURBO C++, DELPHI, VISUAL BASIC, C++ BUILDER, VISUAL C++, VBA, MS ACCESS VBA+SQL+RDBMS, DBASE IV,... have I forgotten something? ), so it won't be any problem to create a database in Access and clients in Visual Basic. I also have got a MS SQL 7 Server in my business LAN which hosts our intranet. I can use that server to host another database as well. The licenses shouldn't be any problem also, because we really own all the software packages (Filemaker Srv/Pro/Unl/Dev/Mobile and all of the MS stuff) I'm wondering if it is possible to create a more professional looking and working tool in Filemaker than in Access... (maybe someone sees a challenge here?) BTW: Let me straight out that this doesn't meen I won't be using Filemaker anymore, just not for my current project (A ITIL implemented Helpdesk utility)

Ok, if Filemaker is only able to let Runtime solutions be single-user databases, I'll just sell all of my Filemaker Software Packages, It's just worthless and useless for me! Imagine: If I create a database in MS Access, create clients in Visual Basic and use javascripting to get the data to my intranet, I'll create a much cheaper solution! And just because Filemaker Pro 5.0 doesn't understand two-way dataexchange with ODBC, it isn't possible to create a fully functional client in Visual Basic/Visual C++ ..... (and I thought Filemaker wanted to become a better product than MS Access, it's much worse than Access!)

Sure you can use a multiuser database with Runtime solutions... The only thing is that you need at least one version of Filemaker Pro, which hosts the database. The runtimes are able to connect to that Database.

nope, I don't mean that.. I meant the Object Size window (where you can enter your object sizes, like height, width, and the positions..) For example, I want to change the width of an object and want try some values. I click in the object size window, and change the width value, I press tab to let the object change size (the focus moves to the height field). If i don't like the size, like it became, I want to go back to the width field and change again. Normally you would go back to that field with Shift-Tab, but Filemaker Pro 5 just ignores the Shift and goes to the Left position field...