Creating filesQ. Is it possible to write a TABcharacter (or any other special character) in a file inorder to generate a log file that can easily be opened in another application, like Excel?
Yes, you can write any ASCII character to a file with Troi File Plug-in. You need to concatenate your ‘regular’ text with the special characters. The easiest way is to use the TrFile_AsciiValueToText function available in Troi File Plug-in 4.0 and later.
First define a global to hold the TAB:
gTABchar global, text
Then fill this global with the help of a (startup) script, like this:
TrFile_AsciiValueToText( "-Unused" ; "9")]
or with variables:
Set Variable [$$TABchar,
TrFile_AsciiValueToText( "-Unused" ; "9") ]
See also the example file MakeASCIIs.fmp12 in the File Plug-in download.
For this you need to know the character’s ASCII code, TAB has ASCII code 9. See the example file ASCII.fp7 for a list of ASCII codes here:
First create a global text field, for example called gXplatformReturn, which you set in a script that is run at startup of the file. In this script have the following step:
Set Field[ gXplatformReturn, TrFile_AsciiValueToText( "-Unused" ;
If(Abs(Get(CurrentPlatform)) = 1 ;
"13 10") ;
On macOS this will result in a CR (Carriage Return) and on Windows this will result in a CRLF (Carriage Return followed by a LF (LineFeed) character).
Now you can simply append this global to your calculations, for example in this script step:
Set Field[ gErrorCode, TrFile_AppendContents( "-Unused" , "A bit of text" &
TIP You can also define this as a global variable in FileMaker 8 or later.
DialogsQ. I do not want a dialog for the user to determine which file to manipulate - I already know where the file is. How do I stop the dialog appearing?
In the example scripts these steps are performed: first a step that asks the user for a file and stores the resulting file path in a global. Then secondly this global is used in the next function to perform the actual action with that file. If you don’t want a user dialog you can omit the first step and give the known path to the file as a parameter to the second function. So omit this step that brings the dialog up from the script:
Set Field[ gTheFileSpec,
TrFile_SelectFileDialog( "-Unused" ; "Please select a file:")]
And only perform this step:
Set Field[ textField,
TrFile_GetContents( "-Unused" ; gTheFileSpec ;) ]
The global field ‘gTheFileSpec’ must contain a valid path to a file. You can also use a text field or calculation to specify the file.
Use the Troi File Plug-in for this: if you know the path to the export file you can do it. First do an automatic scripted export to a file, for example named ‘Export.TAB’. Then use:
Set Field[ gErrorCode, TrFile_Movefile("-Unused" ;
gFilepath ; gFilepath & GetAsText(Get(CurrentDate)) ]
Here gFilepath is a global field and contains for example:
After using the function the name of the file will be 'ExportFile.TAB09291998'. The path will be:
This is on Mac and is file filtering in action. To change the default filtering take a look at “Filtering Files” in the example databases.
For example to display all files add this script step:
TrFile_SetDefaultType( "-Unused" ; "")]
The fileTypes parameter must be formated in pairs of lines. You can specify multiple pairs of lines. The first line of the pair should contain a description of the files to be shown in the dialog. For example: “Text Files (*.txt)”.
The second line of the pair should contain the extension to be shown. For example: “*.txt”. Also in the second line you can use multiple extensions to filter on by separating them with a semi-colon “;”. For example: “*.txt;*.doc”.
"Text Files (*.txt)¶"*.txt") ]
File FormatsQ. Can the File Plug-in read, write or modify Microsoft Word documents?
The File Plug-in can read or create any type of document. However, the File Plug-in does not know about the proper format for a Word document. So you can read in the contents of a document, but this will look like gibberish. The format of Microsoft Word is as far as we know not public, so we can’t help you decode the proper format.
If you want to create documents that Word can understand, you might try to calculate a RTF (Rich Text Format) formatted file.
Below you find an example of a Word document with only the text “Hello World”. This file can contain lots of extra information. A *part* of this file might be similar to this:
&endash;œ$%%^^¢£§§§§••••••¢ ¢ ˆ ˆ ˆ ˆ ¢ ˆ¢ d Hello World! ∞
∆A!∞ “∞ #êÝ
$êÝ %∞ ∞≈ ∞≈ ê≈
Not an easy read!
In Mac text files the end of a line is signalled by the CR or Carriage Return character (ASCII code 13). In Windows files in general and specifically text files (extension .txt) the end of a line is signalled by CR/LF which is the Carriage Return character (ASCII 13) directly followed by the Line Feed character (ASCII 10).
The Troi File plug-in can create files exactly as you want them, provided you know how to create the format with a FileMaker calculation. The plug-in also has a substitute function, so you can even change (exported) files on disk to some other formats.
Images and ContainersQ. Can the file plugin read metadata from raw images, like CR2 or NEF?
Troi File Plug-in will read IPTC and Exif metadata from JPEG, Raw and PNG images. The TrFile_MetaData function, with the switch “-GetEXIF” works with all RAW formats that are internally based on the TIFF format. Many (but not all) RAW file formats are based on TIFF, a.o. 3FR (Hasselblad), DCR, K25, KDC (Kodak), CR2 (Canon), ERF (Epson), MEF (Mamiya), MOS (Leaf), NEF (Nikon), ORF (Olympus), PEF (Pentax), RW2 (Panasonic) and ARW, SRF, SR2 (Sony).
This is not possible with a Troi Plug-in, but you can do this with FileMaker Pro 8 and later.
When graphics are stored in container fields, referenced graphics will not be visible to guests unless they have mounted the volume where the graphics are stored before opening the database.
Information on FilesQ. I want to get the creation date en file size from all files in a folder. How can I do that with the File plug-in?
You’d have to do this in two steps. First use the TrFile_ListFolder function to get the list of all the files in the folder, separated by returns. Then in a loop walk through this list and get the date created and size of each of the files, using the TrFile_GetDateCreated and TrFile_GetFileSize functions.
Set Field[creationDate, TrFile_GetDateCreated( "-Unused" ; gFilePath )]
Set Field[gSize, TrFile_GetFileSize("-Unused" ; gFilePath)]
You can calculate the gFilePath parameter from the path of the folder you have listed + the filename from the list.
For an example of a loop script please see the ManageMedia.fmp12 example file that comes with the download of Troi File Plug-in. This shows how to import a whole folder of image files, by using the Listfolder function to get a list of all files in a folder and then importing them one by one. In the example file have a look at the script ‘LOOP: Import the files from the folder’ and the scripts it refers to. You can change this to your own needs, by not importing the files but getting the creation date and file size of them one by one.
Use the TrFile_Exists function introduced in version 3.0.4!
Manipulating FilesQ. How can I separate filename and folder from a full path?
Lets say the full path is present in a global text field gFullPath. Then in a script you can use these calculations to split it out:
Set Field [ FileName, Middle(gFullPath ; Position(gFullPath ; If(Abs(Get(CurrentPlatform)) =
1 ; ":" ; "\" ) ; Length(gFullPath) ; -1) + 1, Length(gFullPath) )]
Set Field [ Folder,Left(gFullPath ; Length(gFullPath) – Length(FileName))]
This is the file is busy error. The file is probably opened by an other application.
Yes, use the TrFile_Launch function for this. Store the name of the external file in the database, including the path information. To keep this flexible you should consider to store the path to the file in a separate (global) field:
gPathToWordDocumentsFolder could contain
fileName could for example contain
In the script add this:
Set Field[gFilePath, gPathToWordDocumentsFolder & fileName ]
Set Field[gErrorCode, TrFile_Launch( "-unused" ; gFilePath )]
This will launch the file specified by gFilePath with its application.
The instructions for ‘TrFile_MoveFile’ state: “This function only works for source and destination on the same disk”. This is true on macOS. On Windows if you want to move a file from say “C:\Documents” to a folder on a server you can do it by specifying the path as “\\server\DocumentFiles\”.
You can do this using the TrFile_MoveFile function. See the User Guide of Troi File Plug-in, which shows this example:
Renaming a file:
assume your C disk already contains a file “Testtext.txt”. We assume that a global number field gErrorCode is defined. Create the following script:
Set Field[gErrorCode, TrFile_MoveFile( "-Unused" ; "C:\Testtext.txt" ; "C:\NewName.txt" )]
This script will move (rename) the file “Testtext.txt” to the “NewName.txt” file in the same directory. Note that on macOS the paths will be like:
Yes, there is a way. But as this is a very powerful feature, we only tell you after a request by email.
In some cases Troi File Plug-in can use UNC paths (like: \\Server\\share), as underlying Windows calls support it (UNC paths won’t work on macOS). But in general Troi File Plug-in needs full paths.
The following are valid paths that Troi File Plug-in can work with on macOS:
“Diskname:folder:file.zip” (full path)
“filemac:/Diskname/folder/file.zip” (filemaker style path)
On Windows you can use:
“C:\directory\file.zip” (full path)
“filewin:/C:/directory/file.zip” (filemaker style path)
LaunchingQ. On Windows the TrFile_LaunchFile command does not launch a file with a specific extension. How can I fix this?
It may be that your system is not configured to launch this filetype.
You can check this as follows (these instructions are for Windows 10):
In Settings open “System”. Select “Default apps” and then “Choose default applications by file type”. Search the extension that does not work and make sure to choose the default application you want to open it with.
MiscellaneousQ. Can you make alias or shortcut files with the Troi File Plug-in?
Yes, use the TrFile_CreateAlias function for this (introduced in version 8.5).
We try make cross-platform error handling simpler by translating error codes on Windows to the corresponding error code on macOS. For example on Windows you might get the error “$$-43” which means “File not found”.
NOTE It is still possible to get Windows errors, as we can only translate the error codes that are expected.
The Troi File Plug-in automatically closes the files after each function that accesses a file. This affects TrFile_GetContents, TrFile_SetContents, TrFile_AppendContents, TrFile_InsertContents and TrFile_Substitute.
Yes, from version 3.0.5 you can get this data from “Get Info” with Troi File Plug-in. Use this function:
TrFile_GetFileAttribute( "-FinderCommentAttr " ; TheFile)
See the example file Attribute.fmp12. You can also use TrFile_MetaData to get the data that is embedded in the file itself. See in Photoshop the IPTC data under File→File Info, and also the example file IPTC_XMP_Metadata.fmp12.
Higher ASCII characters are not defined in IPTC data, so the encoding can be Mac or Windows. Troi File Plug-in assumes the encoding is the same as the platform the plug-in is running on. If you run into this problem please use one of the following switches with the TrFile_MetaData function:
-SourceMacCharSet (if the IPTC data has Mac encoded characters)
-SourceWinCharSet (if the IPTC data has Windows encoded characters).
If your question is not answered here, please look in the documentation that comes with the plug-in or in one of the specific plug-in FAQs. If you have suggestions please email a FAQ suggestion.