CEATH Company
-
Content Count
19 -
Joined
-
Last visited
-
Thanks very much, Ryan. I'll give that a try. I think you are correct: these emails must contain HTML exclusively. A few questions, however: it is very possible that inline attachments will be included in emails that are processed this way and it is likely we will also receive plain text emails. If I switch from "body" to "html" ... Will plain text emails still have their contents inserted into a FileMaker text field as before? Will attachments at the end of emails still be able to be downloaded and placed in container fields in FileMaker the same way? Will attach
-
We have a client that is sending email to us from their ServiceDesk help desk system. The issue is that the email is laced with HTML tags, so much so that the 360Works Email plugin script step to read the email doesn't find any body to insert in a FileMaker field. The script step is of the form: Set Field[ImportedMessage::body ; EmailReadMessageValue( "body" )] The field ImportedMessage::body is empty, even though we know there is content because a cc copy of the same email can be read, for example, by Apple Mail. Any ideas how to parse the content out of an email that a bunch of
-
Connecting to Amazon Redshift Data Warehouse
CEATH Company replied to CEATH Company's topic in External Data Sources
Thanks, Wim! That's a great overview of the differences and similarities of the two forums. I'll try to be a good citizen of both. -
Connecting to Amazon Redshift Data Warehouse
CEATH Company replied to CEATH Company's topic in External Data Sources
So sorry, Wim. I'm not sure about proper etiquette in the two different forums. I certainly want to do it right and fit in with the community. I'll use XPOST to flag any cross posting, but how about some advice? When is it more appropriate to use FileMaker's TechNet and when should I use FMforums? Are the two audiences different (one more technical, for example, or one more Filemaker Corporate focused)? I'd appreciate some guidance that would differentiate the two different venues. -
We have a client that maintains a fairly large data warehouse on Amazon's Redshift service. We're now being asked to build a FileMaker solution that will access that data. We have the FileMaker solution built (hosted on our own FileMaker Server 14 server) and we now need to access the data on Redshift. Does anyone have experience connecting via ODBC to Redshift? Is there any documentation on that yet? We feel like we're close, but the Amazon documentation doesn't know about FileMaker, and the FileMaker ODBC documentation doesn't specifically mention Redshift so we think we're just missing
-
Just wondering if there are compatibility issues with any of the 360Works plugins in the newly released version of FileMaker Server 13.0v5? I'm not getting the extensions to load (I'm using Email, RemoteScripter, Scribe and the ever-faithful SuperContainer). I have some other issues I'm fighting, including a documented issues related to a license key that says it is in use on another machine (even though it is the same machine it is in use on -- see this post). Just trying to eliminate variables by making sure that my 360Works plugins on FMS 13.0v5 are not causing an issue. Thanks!
-
This thread began on October 17. Now we're well into November. Do we have any idea when FileMaker Server 13 will be Yosemite compatible? I purchased a new MacMini for a new client system we're developing, and realize now I can't run the system on the new box until FMS 13 is Yosemite compatible. Just curious if we have a time frame yet.
-
Duh. I'll answer my own question. The issue wasn't with the attachments -- it was with the body text. I had been using type "rtf" -- which doesn't support both text and attachments. Once I switched to type=html, I can now get both attachments and body text in the same message. Thanks -- and sorry to bother the community. Perhaps my stupidity will help someone else searching for a similar question.
-
New SCSetErrorCapture Plugin Function
CEATH Company replied to ianintheworld's topic in 360 Works General Support
I'm currently using 1.963. I have the automated updater scripts that run and update my suite of 360Works plugins at every launch. Thanks for asking. -
I'm stumped by what would seem to be a simple problem. I have a script that has been sending composed e-mail successfully for months now. The e-mail send script gathers up the To Addresses, Header, and Body text, then sends the e-mail. Works fine. Now I've added the ability to include an attachment. The same script, with the attachment command (EmailAttachFile) added, works fine, except that the body text no longer is included in the e-mail -- just the attachment. If there is no attachment, the e-mail sends with the body text included. It seems I can't have both. I test for er
-
New SCSetErrorCapture Plugin Function
CEATH Company replied to ianintheworld's topic in 360 Works General Support
Hi Joe,  Now that I have the Error Capture commands set to true, I'm getting error messages as shown in the screen shot.  The error code is java.lang.illegalArgumentException: Null stream was passed to inputStreamAsBytes.  The plugins appear to be loading properly, but the error message is disconcerting my users.  Any thoughts?  Martin Ramsay CEATH Company   -
New SCSetErrorCapture Plugin Function
CEATH Company replied to ianintheworld's topic in 360 Works General Support
Thanks for this advice, Joe. I too had tried "on" and "1" but didn't think of trying "true" as the parameter to set the error capture on. My plan is to execute this new function as part of my initialization routine for all appropriate 360Works products that I use. That way I'll capture all errors and only have to do that once. Martin Ramsay CEATH Company -
I'll go ahead and answer my own question. After exploring further, it appears that one actually CAN'T overwrite a file that already exists using the ScribeDocSaveFile function. So I've solved the problem a different way. Each export gets a unique name (a concatenation of the user's ID and a serial number). The server hard drive will fill up with downloaded files after a while, but I'll just delete the old downloads and keep the more recent ones. This approach also lets me (using SuperContainer) list all the recent downloads a user has created, just in case they want to re-download s
-
Hi All, This should be a simple one ... I'm using 360Works Scribe to populate data into an Excel spreadsheet template. The solution is hosted in FM Pro Server using Instant Web Publishing. After the user has examined some dynamic data on the screen, they may download an Excel spreadsheet containing the data. To do this, I open an Excel file that serves as my template using ScriebeDocLoad. I then populate various fields into the spreadsheet using lots of ScribeDocWriteValue commands based on what the user is viewing, then save the file using the ScribeDocSaveFile function. I use
-
Copying records from one table to another table.
CEATH Company replied to laguna92651's topic in Relationships
FileMaker only imports data from the source file based on the current found set. So make sure only those records you want to import are currently "found" before doing the import. Also note the import based on match function. By matching on product number and selecting the correct settings for the import, you won't create duplicate records in the inventory table.
