I'm trying to get attaching files go mails generated using FM17 to work. The idea is to attach a variable file to a mail-message generated for a specific record. The filename for the attachment is specific to the record and I've got a field that generates that filename (fileNamejpg01).
I'm using the send mail option in a script (which is working) and the option to attach a file by giving a file path. That file path looks like this:
The variable part is "$fileNamejpg01" and I'm sure I'm doing something really dumb ... but don't find anything that solves the problem (or that I at least understand).
Hope someone can help!
By Helder Moreira
I have in my small store, a sales system running on a POS with an extra display, for the customer to see what is being added to the invoice. How do I make the filemaker present on this small monitor the summary of what is being sold?
how can I maker filemaker to display on the second monitor only the invoice.
By John Link
I'd like to be able to export a text file that would contain several fields from a single record, with each field on a separate line. Here's an example: John Q Public
111 West First Street
New York, NY 10001
How might I do that? I know how to export csv or Excel files, but they don't satisfy my need.
To try to explain the setup as succinctly as possible:
Database is running on a FM17 Server (on a Windows virtual(?) machine... Our IT department handles that part).
The FM database does a number of imports every morning from our primary (4D) database, using an ODBC driver, but I have not found a way to have those imports run successfully from the server, so I have them running on an instance on a secondary user account on my desktop computer.
The scripts are triggered by adding a record to a table, which is checked every five minutes using an OnTimer script. I run a separate instance of FM17 on my user account so that I can use the database even if there is an import running.
This solution has been working (fairly) well for a number of years, but last week, my desktop computer was updated to Mojave (10.14.6), and since that upgrade, it seems that the imports on the secondary account will only run while that user account is active.
1) Is anyone else doing anything similar, where they have an instance of FM running on a separate user account?
2) If so, have you had any trouble with Mojave, or have suggestions on what may be going on?
3) Any suggestions on how to fix this? My initial thought is to just open the database using FMP on the Server system and try having the imports run from there, but am concerned that might also have problems.
Any suggestions would be greatly appreciated.