Bigun

So here's the tech involved: Microsoft SQL 2014 FileMaker Server 14 FileMaker Pro 15 IIS/PHP The project involves submitting information via web form into the SQL database and then viewing it in a FileMaker portal connected to the database via ODBC. I've done this before, no big deal... except one feature that was thrown at me. Ability to submit images through the web portal and view them through FileMaker I've done image submittal via PHP before, but viewing them in FileMaker is a new one. I've seen some stuff on converting the images to BASE64 then converting them back in a FileMaker container field, but the information was several years old and I'm checking to see if there was any more modern way to handle it; and if it still needs to be done that way, I need some clarification on how to accomplish this.

I got it to work, here is what I did. I uploaded a test database with nothing in it but a script to send a simple e-mail, and ran the script in the scheduler successfully. I then modified the current script to send a test e-mail, ran it in the scheduler successfully. I then modified the current script again and loaded some custom dialogs displaying the variables used to make sure they were sane. - they were. I then loaded all the settings back to what they were and reran the script through the scheduler.... successfully. I have no flipping idea what happened, but it is working now.

Upgraded to FM Server 13.0v9 x64, same error.

I've done further testing by opening telnet on the FM server and testing a raw socket connection to the exchange server successfully. I've also installed the client on the FM server itself and ran the script successfully. It appears to be an issue with running this script on the server schedule.

​It is an internal Exchange server.

​Yes, they are on the same internal network.

The environment is Windows Server 2012, with FileMaker Server 13 v1x64. I've got a script that sends out an e-mail to multiple recipients. When I run the script through FileMaker Pro 13, it sends the e-mails with no issues. However, when I schedule the script to run, it fails. I had the schedule send me an e-mail after the task was done and got this: Looks like 1506 is an SMTP error, but I have no idea why it's failing when it's ran from the server but not from my local desktop. Any help is appreciated.

Solved: The "server.pem" file in the client's FileMaker directory was missing. Called FileMaker to have them send me a copy.

Fairly sure the issue is localized to the one client, but I cannot find the issue. This one newly installed client cannot see the files remotely hosted on our server, the other 400 clients have no issues. I've confirmed it is this one PC my installing NMAP on the client and scanning the server and it can see port 5003 open on the server. I've went even further and installed Wireshark on the client and filtered the server IP and tried to connect, wireshark showed no communication with the server, not even an attempt. This leads me to believe the issue is 100% with the client, but I don't know where to look or what to try. - Bonjour is installed - I can ping all of our servers with no issues I found one snippet of information that might help me: http://help.filemaker.com/app/answers/detail/a_id/5493/~/cannot-see-hosted-database But I could not find the resource they were talking about. Right now any help is appreciated.

I'm not sure what is going on, but here is the situation. I have a FileMaker Database residing on a FileMaker 10 Server I'm using FileMaker 11 Pro Advanced client The FileMaker database is linked to two SQL servers via two different ODBC connections Both SQL databases have 1 table each in the relationship database with a relationship setup between the two The relationship works, evidenced by setting up a layout with related fields displayed and populated Now, here is the problem. Searching in these related fields (in number 5) doesn't seem to working. I've tried searching with wildcards and with exact values, all of which return nothing. I'm at a loss, and have no idea why this isn't working.

Changing when the serial number generates and committing the record on field exit may do the trick, thank you!

This is FM 11 Go, but I'm not sure if newer versions correct this or not. I've got a form that is filled out via FM 11 Go and the file is hosted on a server, therefore an internet connection and a VPN tunnel is required in order to use the form. Also, in this form I have an auto-entered serial number being used and tons of validation before the record is saved. Now on top of all of this, it has been brought to my attention that gaps are appearing in the serial number, and the appearance of gaps is frowned upon by auditing. The behavior is easily reproduced by doing the following: Setup a FM file on a server with an auto incrementing serial number and some form of validation (a required value for example) Connect to file via FM Go Create record Do not meet minimum validation to save record Disconnect device from network Connected to Database on another device and look at the auto-enter serial's next value and notice it is incremented The other portion of the complaint is that the user starts a record, and any data entered is lost if they haven't met the minimum requirements and the internet connection is lost. Now I can see several things to blame here and a few ways to attack it. Blame the internet connection and make sure the connection is stable before proceeding (this is a hard requirement to expect end-users to maintain) Blame the VPN and try to find a better solution than the VPN built into IOS (this will incur extra cost as well as more R&D) Blame the server based file and build some hybrid local file that will transfer it's data to the server upon a solid connection (Complete rebuild and adds more complication than what is necessary and a lot more R&D) So I'm not really sure how to logistically approach the problem as it seems to be a two part problem with variables that are way out of my control. How is everyone else dealing with mobile data entry on these devices?

I have two databases. One is production database that has live data in it (we'll call it Database A), and another database that is a test database that I'm developing new features on (we'll call it Database B ). I take a daily backup of Database A, and attempt to import the records (Using the File -> Import Records function in FileMaker Pro Advanced) from a table into Database B. Database A, in just one table, has 37,357 records, after import is finished, FileMaker says 59 records were skipped due to errors. No other details we're given. Not sure what is causing the errors with those 59 records, is there a way to get more detail? Or even an interactive way to import the data when errors are occuring?

I'm trying to validate some container fields via script, and I've noticed that using the IsEmpty function doesn't seem to recognize signatures, as does the equal or not-equal sign operator. How do I check for signatures? *edit* Disregard, it was programmer error. This post can be deleted.

Vanilla, as-in I don't have any plugins. We have a test environment we plan on using, I just need to know what to look for, I'll find the threads you mentioned above.