Difference between revisions of "Access formats"

From Archivematica
Jump to navigation Jump to search
 
Line 1: Line 1:
 
[[Main Page]] > [[Documentation]] > [[Format policies]] > Access formats
 
[[Main Page]] > [[Documentation]] > [[Format policies]] > Access formats
 +
 +
=FPR Access formats=
  
 
The table below shows formats considered to be access formats in the FPR (updated as of August 2015).
 
The table below shows formats considered to be access formats in the FPR (updated as of August 2015).
Line 128: Line 130:
 
| Word Processing || Microsoft Word  || 2007+ || fido-fmt/189.word || Microsoft Office Open XML - Word (FIDO extension)
 
| Word Processing || Microsoft Word  || 2007+ || fido-fmt/189.word || Microsoft Office Open XML - Word (FIDO extension)
 
|}
 
|}
 +
 +
=Local customizations=
 +
 +
If you have made local customizations to your FPR, your list may be different. To generate a CSV file of your FPR's access formats, run the following sql:
 +
 +
<pre>
 +
 +
select fg.description, f.description, fv.version, fv.pronom_id, fv.description
 +
into outfile '/tmp/access.csv'  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
 +
from fpr_format f join fpr_formatversion fv on f.uuid = fv.format_id
 +
join fpr_formatgroup fg on f.group_id = fg.uuid
 +
where fv.access_format = 1;
 +
 +
</pre>

Latest revision as of 16:15, 21 August 2015

Main Page > Documentation > Format policies > Access formats

FPR Access formats[edit]

The table below shows formats considered to be access formats in the FPR (updated as of August 2015).

FPR group File Format Version PRONOM ID Description
Email MBOX MBOX Generic
Image (Raster) JPEG \N Generic JPEG
Image (Raster) JPEG 1.01 fmt/43 JPEG 1.01
Image (Raster) Portable Network Graphics Generic PNG
Package PKWARE Zip x-fmt/263 ZIP file
Portable Document Format PDF Generic PDF
Portable Document Format PDF 1.0 fmt/14 Acrobat PDF 1.0
Portable Document Format PDF 1.1 fmt/15 Acrobat PDF 1.1
Portable Document Format PDF 1.2 fmt/16 Acrobat PDF 1.2
Portable Document Format PDF 1.3 fmt/17 Acrobat PDF 1.3
Portable Document Format PDF 1.4 fmt/18 Acrobat PDF 1.4
Portable Document Format PDF 1.6 fmt/20 Acrobat PDF 1.6
Portable Document Format PDF 1.7 fmt/276 Acrobat PDF 1.7
Portable Document Format PDF 1a fmt/95 Acrobat PDF/A 1a
Portable Document Format PDF 1b fmt/354 Acrobat PDF/A 1b
Portable Document Format PDF 2a fmt/476 Acrobat PDF/A 2a
Portable Document Format PDF 2b fmt/477 Acrobat PDF/A 2b
Portable Document Format PDF 2u fmt/478 Acrobat PDF/A 2u
Portable Document Format PDF 3a fmt/479 Acrobat PDF/A 3a
Portable Document Format PDF 3b fmt/480 Acrobat PDF/A 3b
Portable Document Format PDF 3u fmt/481 Acrobat PDF/A 3u
Portable Document Format PDF E-1 fmt/493 Acrobat PDF for Engineering PDF/E-1
Portable Document Format PDF fmt/157 Acrobat PDF/X Exchange 1a:2001
Portable Document Format PDF fmt/144 Acrobat PDF/X Exchange 1:1999
Portable Document Format PDF fmt/145 Acrobat PDF/X Exchange 1:2001
Portable Document Format PDF fmt/146 Acrobat PDF/X Exchange 1a:2003
Portable Document Format PDF fmt/147 Acrobat PDF/X Exchange 2:2003
Portable Document Format PDF fmt/158 Acrobat PDF/X Exchange 3:2002
Portable Document Format PDF fmt/488 Acrobat PDF/X Exchange PDF/X-4
Portable Document Format PDF fmt/489 Acrobat PDF/X Exchange PDF/X-4p
Portable Document Format PDF fmt/490 Acrobat PDF/X Exchange PDF/X-5g
Portable Document Format PDF fmt/492 Acrobat PDF/X Exchange PDF/X-5n
Portable Document Format PDF fmt/491 Acrobat PDF/X Exchange PDF/X-5pg
Portable Document Format PDF fmt/148 Acrobat PDF/X Exchange 3:2003
Spreadsheet Microsoft Excel Generic Excel Worksheet
Spreadsheet Microsoft Excel X fmt/178 Excel for Macintosh X
Spreadsheet Microsoft Excel 8 fmt/61 Excel 97 Workbook
Spreadsheet Microsoft Excel 2007 fmt/445 Excel Macro-Enabled 2007
Spreadsheet Microsoft Excel 2007+ fmt/214 Excel for Windows 2007+
Spreadsheet Microsoft Excel 2007+ fido-fmt/189.xl Microsoft Office Open XML - Excel (FIDO extension)
Spreadsheet OpenDocument Spreadsheet Generic ODS
Spreadsheet OpenDocument Spreadsheet 1.2 fmt/295 ODS 1.2
Spreadsheet OpenDocument Spreadsheet 1.0 fmt/137 ODS 1.0
Spreadsheet OpenDocument Spreadsheet 1.1 fmt/294 ODS 1.1
Text (Markup) Cascading Style Sheet x-fmt/224 Generic CSS
Text (Markup) HTML Generic HTML
Text (Markup) HTML 2.0 fmt/97 Hypertext Markup Language 2.0
Text (Markup) HTML 3.2 fmt/98 Hypertext Markup Language 3.2
Text (Markup) HTML 4.0 fmt/99 Hypertext Markup Language 4.0
Text (Markup) HTML 4.01 fmt/100 Hypertext Markup Language 4.01
Text (Markup) HTML 5 fmt/471 Hypertext Markup Language 5
Text (Markup) HTML Generic XHTML
Text (Markup) vCard fmt/395 Generic vCard
Text (Plain) CSV x-fmt/18 Comma Separated Values
Text (Plain) Plain Text x-fmt/111 Generic TXT
Text (Plain) Plain Text x-fmt/62 Generic LOG
Unknown Default Format Unknown file format
Word Processing Microsoft Word 2007+ fido-fmt/189.word Microsoft Office Open XML - Word (FIDO extension)

Local customizations[edit]

If you have made local customizations to your FPR, your list may be different. To generate a CSV file of your FPR's access formats, run the following sql:


select fg.description, f.description, fv.version, fv.pronom_id, fv.description
into outfile '/tmp/access.csv'  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
from fpr_format f join fpr_formatversion fv on f.uuid = fv.format_id
join fpr_formatgroup fg on f.group_id = fg.uuid
where fv.access_format = 1;