File: FILE - Identifier (DC) [File Original Name and File Original Path are added automatically]

Repeating DC metadata fields

DC fields in the CSV file can be repeated as many times as needed. 
For example, a CSV file can include several IE level Subject (DC) columns.
Each column will become separate dc:subject tags in Rosetta METS.
Please note the following limitation: multiple columns with the same DC field on certain level can be only added by manually editing the CSV file downloaded from the CSV template page.
Currently the UI in Deposit > CSV template does enable to add each field only once. 

How to add File Labels for viewer display

During csv ingest the file names in the "File Original Name" column are added as the file labels by default (e.g. "123.jpg" - complete file name).
If it is preferred to use instead the DC titles as the file labels, in addition to the "File Original Name" column, add two additional columns:
1. File - Title (DC) with the "123.jpg" (complete file name as would be located in the path provided in the "File Original Path")
2. File Label with the file title "Map of Indonesia" or whatever file label that should display in the viewer's table of contents on the left.

Important notes about the "Detailed CSV" submission format when used with a CSV file:

1. Make sure the file names listed in the 'File Name' column of the CSV match the names of the actual files.

2. Unless the zip contains internal folders:

• For Rosetta 7.0 and below - 'File original path' is: / (forward-slash)
• For Rosetta 7.1 and newer - 'File original path' is empty.

3. When the zip contains internal folders - 'File original path' is the path of files within the zip.
Make sure 'File original path' do not start with '/' (forward-slash).
Examples:

• a file directly under zip's root: image.jpg
• a file under few subfolders under zip's root: folder1/folder2/image.jpg

Important notes about the "NFS Acquiring" submission format when used with a CSV file:

In v4.2.1 the CSV automated deposit now supports absolute and HTTP paths.

To add a remote path, add the url, starting with “http://” to the 'File Original Path' column including the file name.

Make sure that the 'File Original Name' column is empty.

To add an absolute path add the url to the 'File Original Path' and the file name to 'File Original Name', make sure it starts with '/' ."

 

Scientific notations and Foreign language characters:

1. If automating CSV creation, the script should assure that non-byte order mark (BOM) UTF-8 encoded CSV is created.
2. For manual CSV creation, use LibreOffice or Notepad++ instead of Excel to save CSV files in non-byte order mark (BOM) UTF-8.

 

Collection Hierarchy Building Structure:

Object Type       Title (DC)            Is Part Of (DCTERMS)                        Publish Collection 
Collection           collection1                                                                      TRUE 
Collection           collection2        collection1                                             TRUE
Collection           collection3        collection1/collection2                           TRUE
Collection           collection4        collection1/collection2/collection3         TRUE

 

Will create the following collection hierarchy in Rosetta's Collection Management: collection1/collection2/collection3/collection4/<IEs>

NOTE: Rosetta Collection Management only displays dc:title in the Title column of the Content tab (not dcterms:title).

 

Refer to the "Depositing SIPs in CSV Structure" section of the Rosetta's Producer Guide:

http://knowledge.exlibrisgroup.com/@api/deki/files/39701/Rosetta_Producers_Guide.pdf

Refer to the "CSV Content Structure" and "CSV Templates" sections of the Rosetta Staff User's Guide:
https://knowledge.exlibrisgroup.com/@api/deki/files/39696/Rosetta_Staff_User's_Guide.pdf

For explanation with screen shots see attached file
Please see the relevant documentation for additional information and limitations

 

CSV Loading Pre-checks

Below is a list of preliminary checks that can be performed before ingesting a CSV.
Following these pre-checks will reduce the number of potential errors encountered during loading.

1. Confirm that all of the files listed in the "File Original Name" column in the csv correspond to the ones listed in /content/streams/ directory.

2. Confirm that all of the file names listed in the "File Original Name" column in the csv match the actual file names (e.g. case sensitivity)?

3. Confirm that the "File Original Path" column accurately reflects where the files reside (e.g. path matched was is defined in the submission format).

4. Confirm that there are no extra spaces after the column names and/or column content (the submission to fail and get routed to the TA workbench).

5. Confirm that there are no typos in the SIP folder name that would NOT match the path in the csv's "File Original Path" column (e.g. sampleJam instead of sampleJan).

6. Confirm that there is a "/" after the "streams" folder path in the "File Original Path" column in the csv (e.g. /operational_shared/sipTmpDir/test/content/streams/).

7. Confirm that producer agent to be used for csv ingest is linked to the producer.
If they are not linked, the producer/producer agent will not display in the Submission Job.

 

Update to Rosetta version 5.4

Rosetta version 5.4 supports  also the Source MD ingest with CSV deposit. 

It is available by adding a source MD object in the "{IE/REP/FILE} Source metadata content" column.