EXPORTFILE Function (MediaSet)

Exports the media objects in the current media set of a record to individual files on your computer or network. In the record, the media set is referenced in a MediaSet data type field.


[count := ]Record.MediaSetField.EXPORTFILE(FileNamePrefix)  


Type: Record

Specifies the record that includes the media set.

Type: MediaSet

Specifies the MediaSet data type field of the record that includes the media objects.

Type: Text

Specifies the location and name of the exported media files.

Each exported media file is given a name that consists of a prefix that you specify, plus an index number that is automatically assigned. The file name has the format prefix-index.type, for example, Image-1.jpg, Image-2.jpg, and Image-3.jpg. To set the parameter value, use the format: path\prefix.type.

  • path is the folder path where you want to store the files.

  • prefix is the text that you want before the index number.

  • type is the media type extension.

Property Value/Return Value

Type: Integer

Specifies the number of media files that were generated and stored in the output file path.


The exported media files will be of the same media file type as when they were imported. For more information about the media types, see Supported Media Types.

The function has the following behavior:

  • If a file that has the same name as the exported file already is located in the target folder and the current session has write access on the file, the existing file will be automatically replaced by the new file.

  • If the export fails, the existing file will be erased.

  • If a media in the media set cannot be found in the database, no file will be generated for this object.


This example first imports two media files (JPEG image files) from a local folder to the media set of a record in the table 27 Item of the CRONUS demonstration database. Then, using the EXPORTFILE function, the media objects are exported to files again in another local folder.

For using media sets on records, the Item table includes a MediaSet data type field that is named Picture.

The example code requires that you create the following variables and text constant:

Variable name DataType Subtype
itemRec Record Item
count Boolean
Text constant name ConstValue
Text000 %1 media files were exported.

The code imports the JPEG image files (.jpg) from the folder C:\images to record 1000 in the Item table, and then exports the media files to the folder C:\images\export.

// Import image files the C:\images folder.  
itemRec.Picture.IMPORTFILE('C:\images\1000-v1.jpg', 'Demo image for item ' + FORMAT(itemRec."No."));
itemRec.Picture.IMPORTFILE('C:\images\1000-v2.jpg', 'Demo image for item ' + FORMAT(itemRec."No."));

// Export the MediaSet to two separate image files in the c:\images\export folder.  
count := itemRec.Picture.EXPORTFILE('C:\images\export\' + 'Item1000Image.jpg');   
Message('%1 files exported.', count);

See Also

Working With Media on Records
IMPORTSTREAM Function (Media)
IMPORTFILE Function (MediaSet)
IMPORTSTREAM Function (MediaSet)
MediaSet Data Type
EXPORTSTREAM Function (Media)
EXPORTFILE Function (Media)