...
Execute next script to find which file attachment has unknown file extension
Code Block language sql SELECT a.oid, a.filepath, a.display_name, a.concept_oid, a.term_oid, d.name AS dictionary FROM tw_attachment a, tw_dictionaries d WHERE a.type = 0 AND a.dictionary_oid = d.oid;
If you want to fix that files manually, you can open each concept or term where file attached by using next URLs:
1) For TermWeb 3 installation:
https://example.termweb.eu/termweb/view/${concept_oid} or https://example.termweb.eu/termweb/view/${concept_oid}/${term_oid}
2) For TermWeb 4 installation:
https://example.termweb.eu/view/${concept_oid} or https://example.termweb.eu/view/${concept_oid}/${term_oid}If you see in column “filepath” that file is in supported file types you can update it’s type by specifying right DB value.
See below of this article list of supported file types.Most of changes should be applied automatically, in case of cached value, try to restart TermWeb.
...
List of supported file types TermWeb 4.0.5 and earlier releases.
File type | DB value | Supported file extensions |
---|---|---|
UNKNOWN | 0 | <any other value> |
WORD | 1 | doc |
OPENDOC | 2 | odt |
3 | ||
EXCEL | 4 | xls |
HTML | 5 | htm, html |
JPG | 6 | jpg, jpe, jpeg |
GIF | 7 | gif |
PNG | 8 | png |
ZIP | 9 | zip |
GZ | 10 | gz |
AVI | 11 | avi |
QUICKTIME | 12 | mov, qt |
MPEG | 13 | mpeg, mpe, mpg |
TEXT | 14 | txt |
REALAUDIO | 15 | rm, ra, ram |
WAV | 16 | wav |
AU | 17 | au |
MP3 | 18 | mp3 |
M4A | 19 | m4a |
RTF | 20 | rtf |
POWERPOINT | 21 | ppt, ppz |
WORDX | 22 | docx |
EXCELX | 23 | xlsx |
POWERPOINTX | 24 | pptx |
Page Properties | ||
---|---|---|
| ||
|