Store File into BLOB Field

erugalatha

Hi,

What is the code to take file from disk (i.e. using Common Dialog Codeunit functionality) and store it in a field of Type BLOB?

Thanks for any help.

Luc_VanDyck

myBlobField.IMPORT('*.BMP',TRUE);

erugalatha

Thank you.
Can it be files of any type? i.e. not just .BMP

Savatage

From Help..
Sub Type

Use this property to provide additional information about what will be contained in this field.
This property only applies to BLOB fields.


Settings: The SubType settings are:
Bitmap, Memo, User defined information User-Defined (default)

Comments
When you use C/AL functions IMPORT and EXPORT, the system will provide a dialog window from which the user can pick the BLOB to import or export.

Based on your selection here, the system will show only the appropriate file types. For instance, if you select Bitmap, the system shows only files with the extension .bmp. If you select Memo, the system shows only files with the extension .txt. If you select User-Defined, the system shows all files.

erugalatha

Thank you.

erugalatha

Is it possible to get the filename and file path from the dialog box of the BLOB.IMPORT('*.*', TRUE) function?

i.e. I want to store the filename and file path in the Filename and FilePath text fields on the record.

It seems you have to pass in the filename to the IMPORT function but I want to use the filename and filepath that the user selects to store in other fields.

In the help it suggests to use ImportedName := with a DataType of Filename ... as far as I can tell this DataType is not available in Navision.

Thank you.

rdwyer

Has anyone had any luck using the BLOB SubType field? According to MS support, it doesn't serve any purpose..

IE: if the Subtype was set to Txt, I would expect the Common Dialog to default to "Files of type" txt..

ara3n

Hello Rdwyer

Take a look at this thread on how to select a file. You can then use this import the file into blob.


http://www.mibuso.com/forum/viewtopic.php?t=14834&highlight=filename


You can store the file name as string as well as file type in a separate field.

Maria-S

Hello,

Has anyone had any luck using the BLOB SubType field? According to MS support, it doesn't serve any purpose..

IE: if the Subtype was set to Txt, I would expect the Common Dialog to default to "Files of type" txt..

For me the Memo option works fine, but User-Defined (both with and without angle braces <>) still gives *.bmp extension ](*,)

xdimidrolx

hi All, Is there any possibility to define the format of file stored in BLOB field (*.jpeg; *.bmp; *.tiff)?