TXT file type changes to "Unknown" after upload.

0 votes

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.

in How To by (7.0k points)

1 Answer

0 votes
Best answer

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

by (64.5k points)
edited by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer