Versions Compared

Old Version 4

changes.mady.by.user Caterina Caracciolo

Saved on

compared with

New Version 5

changes.mady.by.user Caterina Caracciolo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Source: CSV files sent by Aureliano.

  1. GroupMarine_MarineResourceResource.csv
      Marine_Resource.csv
      1. contains a list of all stocks ("super" and "sub"-stocks)
    1. Group_MarineResource.csv. 
      1. contains the grouping; group-identifier | member-identifier


    Issue 1: Problems with file Marine_Resource.csv

    1. has broken lines (resulting in having parts of a stock's name in field "Identifier").
      1. Solution. Fixed manually.   

    2. there is a "\" before ";" in lines 1522 and 1529. This is interpreted as escape character for ";" , hence it is not interpreted as separator and the whole file is read badly. See: 

      1. 11,551;013:0636;Hybrid Sole - USA EEZ Bering Sea and Aleutian Islands\;;;;;;

      2. 11,558;013:0643;Slender Sole - USA EEZ Bering Sea and Aleutian Islands\;;;;;;

      3. Solution. Removed "\" manually, then the CSV is read correctly. 
    3. Has ; as separators instead of ,. Problem when using it with Sheet2RDF
      1. Solution. Opened in Excel then saved back as CSV.