TXT file type changes to "Unknown" after upload.

Question

When I initially upload a txt file it shows a [TXT] icon.

But as soon as I save the record it turns to [Unknown].

The file has now become filename.unknown so when you click on it to view it Windows does not recognise it.
It is still a text file and can be read with notepad, it is just the file extension that has changed.

Answer 1

The reason is that dbFront can't determine what the file extension should be.

When you configure an Object Field type you have the option of specifying a secondary "Filename Field" that will be used when dbFront needs the attachment filename.

dbFront uses the file extension as found in the "Filename Field" and the actual attachment contents to determine what the real file attachment type is. For security reasons, dbFront does not trust the attachment filename alone. If the file attachment type and the file extension don't agree then dbFront returns [Unknown] as the filetype.

In addition, if the file type can't be determined from the contents and there is no "Filename Field" specified then dbFront will also return [Unknown].

For more details see: Object Fields