Input CSV Format: Difference between revisions

fix required fields
(fix required fields)
Line 5: Line 5:
== Input CSV Format for iDigBio Media Appliance ==
== Input CSV Format for iDigBio Media Appliance ==


The appliance will build you an input CSV file if you don't already have one. In the dialog you can point it to your folder of media files and it will build the bare minimum of what it needs to ingest your media. On the other hand, if you have rich data from the media EXIF or IPTC, for example, you can use Audubon Core (AC) terms to build your own input file. Some recommended fields are given below.
The appliance will build an input CSV file by scanning a specified directory for media ("Generate CSV"). This is the most common workflow for the media appliance.
 


{| class="wikitable" border="1"
{| class="wikitable" border="1"
|-
|-
! scope="col" style="text-align:center; width:210px" | AC Column Name  
! scope="col" style="text-align:center; width:210px" | Column Name  
! scope="col" style="text-align:center; width:60px" | Required  
! scope="col" style="text-align:center; width:60px" | Required  
! scope="col" style="text-align:center" | Description  
! scope="col" style="text-align:center" | Description  
! scope="col" style="text-align:center" | Example  
! scope="col" style="text-align:center" | Example  
|-
|-
|style="text-align: center;" | dcterms:identifier
|style="text-align: center;" | idigbio:MediaGUID
|style="text-align: center;" |Y  
|style="text-align: center;" |Y  
| GUID for a digital multimedia object.  
| GUID for a digital multimedia object.
| "urn:uuid:3c1dc496-e5c6-4849-b616-cada2896190d", "ids.amnh.org/AMNH_PBI 00010147 lateral.jpg"
| "urn:uuid:3c1dc496-e5c6-4849-b616-cada2896190d", "ids.amnh.org/AMNH_PBI 00010147 lateral.jpg"
|-
|style="text-align: center;" | idigbio:OriginalFileName
|style="text-align: center;" | Y*
| Entire path+filename as stored on the appliance user's local disk in OS / filesystem syntax. This field '''or''' ac:accessURI must be used.
| "C:\images\AMNH_PBI\AMNH_PBI 00010147 lateral.jpg", "/home/Plants/VSC0043330.jpg"
|-
|style="text-align: center;" | ac:accessURI
|style="text-align: center;" | N*
| Entire path+filename as stored on the appliance user's local disk in URI syntax. This field '''or''' idigbio:OriginalFilename must be used.
| "file:///C:/images/AMNH_PBI/AMNH_PBI 00010147 lateral.jpg"
|-
|-
|style="text-align: center;" | dc:format  
|style="text-align: center;" | dc:format  
Line 24: Line 35:
| "image/jpeg", "audio/mpeg"
| "image/jpeg", "audio/mpeg"
|-
|-
|style="text-align: center;" | ac:accessURI
-}
|style="text-align: center;" | Y
 
| Entire path+filename as stored on the appliance user's local disk in URI syntax
If you additional media metadata that you would like to include in the media recordset, you can use supply additional Audubon Core (AC) terms in your own input file. Some recommended fields are given below. The media appliance required fields mentioned above must still be included in the input file.
| "file:///C:/images/AMNH_PBI/AMNH_PBI 00010147 lateral.jpg"
 
The following is under maintenance.
 
{| class="wikitable" border="1"
|-
! scope="col" style="text-align:center; width:210px" | AC Column Name
! scope="col" style="text-align:center; width:60px" | Required
! scope="col" style="text-align:center" | Description
! scope="col" style="text-align:center" | Example
|-
|style="text-align: center;" | dcterms:identifier
|style="text-align: center;" | N
| GUID for a digital multimedia object.
| "urn:uuid:3c1dc496-e5c6-4849-b616-cada2896190d", "ids.amnh.org/AMNH_PBI 00010147 lateral.jpg"
|-
|-
|style="text-align: center;" | idigbio:OriginalFileName  
|style="text-align: center;" | idigbio:OriginalFileName  
Line 45: Line 69:
|-
|-
|style="text-align: center;" |dc:rights or dcterms:rights
|style="text-align: center;" |dc:rights or dcterms:rights
|style="text-align: center;" | N  
|style="text-align: center;" | N |-
|valign="top"|dc:rights -  “CC BY-NC"<br>
|valign="top"|dc:rights -  “CC BY-NC"<br>
dcterms:rights - http://creativecommons.org/licenses/by-nc/4.0/
dcterms:rights - http://creativecommons.org/licenses/by-nc/4.0/
Line 77: Line 101:
|}
|}


'''With the exception of idigbio:OriginalFileName, the following information is deprecated. The information below is being maintained for historical reference only. Use [https://terms.tdwg.org/wiki/Audubon_Core_Term_List Audubon Core] terms instead.'''
 
 
'''The following information is deprecated and is being maintained for historical reference only. Use [https://terms.tdwg.org/wiki/Audubon_Core_Term_List Audubon Core] terms to provide additional media metadata.'''




Line 86: Line 112:
! scope="col" style="text-align:center" | Description  
! scope="col" style="text-align:center" | Description  
! scope="col" style="text-align:center" | Example  
! scope="col" style="text-align:center" | Example  
|-
|style="text-align: center;" | idigbio:MediaGUID
|style="text-align: center;" |Y
| GUID for a digital multimedia object.
| "urn:uuid:3c1dc496-e5c6-4849-b616-cada2896190d", "ids.amnh.org/AMNH_PBI 00010147 lateral.jpg"
|-
|style="text-align: center;" | idigbio:OriginalFileName
|style="text-align: center;" | Y
| Entire path+filename as stored on the appliance user's local disk.
| "C:/images/AMNH_PBI/AMNH_PBI 00010147 lateral.jpg", "\home\Plants\VSC0043330.jpg"
|-
|-
|style="text-align: center;" | idigbio:CollectionObjectGUID  
|style="text-align: center;" | idigbio:CollectionObjectGUID  
1,554

edits