W3C home > Mailing lists > Public > public-csv-wg@w3.org > June 2014

What to do when "primary key" cell values are blank

From: Tandy, Jeremy <jeremy.tandy@metoffice.gov.uk>
Date: Fri, 6 Jun 2014 08:53:40 +0000
To: "public-csv-wg@w3.org" <public-csv-wg@w3.org>
Message-ID: <2624871D9A05174691BD59F8EFD68AE2088453B9@EXXCMPD1DAG3.cmpd1.metoffice.gov.uk>
Hi - when putting together Use Case #24 - Expressing a hierarchy within occupational listings [1] I was considering how primary key behaviour might work. In this use case, there are four different types of entity described in a single CSV file. I inferred that we might apply four different templates to pull out the relevant contents and transform into RDF. A given row describes _one of_ the types of entity, meaning that the primary key column asserted, say, for extracting "SOC Major Group" concepts will often be blank. 

I have stated in the use case that:
> Where the value in the designated primary key column is blank, the row is ignored.

I have also added this constraint to the primary key requirement [2].

Please advise is this is inappropriate!

Regards, Jeremy

[1] http://w3c.github.io/csvw/use-cases-and-requirements/#UC-ExpressingHierarchyWithinOccupationalListings
[2] http://w3c.github.io/csvw/use-cases-and-requirements/#R-PrimaryKey 
Received on Friday, 6 June 2014 08:54:08 UTC

This archive was generated by hypermail 2.3.1 : Tuesday, 6 January 2015 20:21:40 UTC