html : the content of the HTML version of the email. replyTo : a reply to email address only. text : required, but can also be empty. subject : required, but can be an empty string. from : the from name and email address. This function can also use the options in the BE_CurlSetOptionfunction, where applicable. ReplyTomust be an email address only and cannot include a name. If you're including an actual name, you MUST include angle brackets around the email address. The To, CC, BCC and attachments can be passed value lists in order to send to multiple people or to include multiple attachments.Įmail addresses are in the format Name " With it, I've gotten this working and understand a bit more about passing these routines back and forth between Filemaker and the OS.BE_SMTPSend BE_SMTPSend(from to subject text ) It will return a result for whether or not it worked. Have a look at this post :Īnd there is a file attached that has Custom Functions in it you can use to convert from a FileMaker path to a plugin path and back. You need to start with the path to the FileMaker file, and then convert it to a plugin path. I REALLY appreciate your help in this problem for me.Ī relative path won't work. I am sure this is positively elementary but I am evidently brain dead at the moment. I have everything in place as far as variables populated (hoping I CAN use a variable like I did with BE_ListFilesInFolder!) and would like to know how to call the function in a script? Send Event? That way, there is no chance for the client to import the same file more than once as well as gathering all of the original data into one folder for archiving. So what I am going to do next is right after import, I want to use BE_MoveFile to move the file that was just imported into another folder. Setup a loop to loop through the global field and import all of the records that we grabbed via BE_ListFilesinFolder - works great! Thanks for your help! I have worked this out (in a round about way) by assigning the path to a variable and that seems to work: The value you get back from BE_SelectFolder ( "" ) is exactly how the BE_ListFilesInFolder function is expecting the path to look. Try using BE_SelectFolder ( "" ) in the Data Viewer and select this folder on the machine, and compare the output to what you have below. I have tried to use a relative path ( Set Variable ) which does not workĪnd the results of BE_SelectFolder ( Set Variable ) which does work. The data folder I am importing is one level deeper than the folder that the database is in. However, I can assume that the folder structure will be different on the clients machine (this will be a runtime). Thanks for the reply! Doing that indeed did add the list of the files. Reply to this email directly or view it on GitHub: Subject: Re: BE_ListFilesInFolder ( path ) ( #3) I have pasted the script below to see if you see what I am doing wrong.īE_ListFilesInFolder ( "file::C::Users:hardee:Desktop:PIEDMONT GRAPHICS:BASE:DATABASE:CSV_Files:" ) I just cannot get the field to populate with the function. I have pasted the filenames into the field and the import script loop works fine. I have the path TO the files in a global field and need to get the LIST of the files into another field to loop through importing them. I must have a thick skull because I've tried several ways to get this to work. That way you can tell what the path should be, and convert to or from the standard FileMaker paths as appropriate. They put up a dialog, and you can select a file or folder and then it will return the path to that file/folder. The best way to understand the paths are to run the functions BE_SelectFile ( "" ) and BE_SelectFolder ( "" ). The "from" and "to" parameters are paths again. You need to convert the internal ( OS ) path into a FileMaker path, set it into a variable and then use the variable in place of a full path in the import step. Can anyone point to documentation or guide me in how to call these routines within a script?Īll of these can be done in this plugin if you want to use it. This obviously is not an option in the Windows version and am trying to use this plugin to accomplish this. Upon completion, move the files imported into a done folder. Loop in a script to import the multiple files into a table Read in a list of files in a specific folder (relative to DB folder) into a global field. In the mac solution I used Applescript within a script to: I've developed a Filemaker 10 database on the Mac platform that I now need to port to Windows. I've just installed this plugin and am trying it out and have a couple of questions (if permitted).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |