Opened 8 years ago

Closed 7 years ago

#1375 closed defect (fixed)

schema changes for patent item type

Reported by: erazlogo Owned by: dstillman
Priority: major Milestone: 2.0 Final
Component: data layer Version: 2.0
Keywords: schema-update Cc: bdarcus, simon

Description (last modified by erazlogo)

http://forums.zotero.org/discussion/5780/better-patent-support-needed-in-bibliography-country-in-database/#Item_1

Add issuingAuthority field.

Place in patent item type is currently mapped to country. Since some styles cite both place and country, we should unmap place and add a country field.

Citations for patents in Chicago need to include both date of filing and issue date (CMS 17.219). As far as I can tell from system.sql, in the patent item type the "Issue Date" and "Date" fields (the latter presumably the place to enter the date of filing) are both mapped to the same field, date. As a result, CSL cannot display the date of filing at all. One possible solution is to replace date with filingDate field and still map issueDate to date.

To complicate matters further, patents need to be dated by year of filing in the Author-Date Chicago style, but in most other author-date styles they are dated by the year of issue. The current mapping of issueDate to date works for most styles but not Chicago. One possible solution is to still map issueDate to date in Zotero, but map filingDate to a new CSL value and then code this exception in CSL.

Change History (7)

comment:1 Changed 8 years ago by erazlogo

  • Description modified (diff)

comment:2 Changed 7 years ago by erazlogo

At the same time, you may want to block Chicago styles download in the Additional Styles section for 1.0 clients. I will add these new fields to the styles right away which may cause errors in old versions.

comment:3 Changed 7 years ago by erazlogo

Ok, so it is possible that migration of does data need to happen - from "Date" to the new field "Filing Date." I thought the field will just need to be renamed, but it seems I was wrong about that because Date is a base field.

comment:4 Changed 7 years ago by dstillman

  • Cc bdarcus simon added
  • Milestone changed from 2.0 Beta 3 to 2.0 Final
  • Version changed from 1.5 to 2.0

Adding 'country' field, removing (nonfunctional) base-map from 'place' to 'country', adding 'issuingAuthority', replacing 'date' with 'filingDate', and moving 'date' data to 'filingDate'. Keeping 'issueDate' base-mapped to 'date'.

Is there an existing CSL variable that filingDate should be mapped to?

comment:5 follow-up: Changed 7 years ago by erazlogo

Here are the options in CSL:

"issued" | "event" | "accessed" | "container" | "original-date"

"original-date" maybe? there doesn't seem to be a "filing-date" option currently.

Elena

comment:6 in reply to: ↑ 5 Changed 7 years ago by bdarcus

Replying to erazlogo:

Here are the options in CSL:

"issued" | "event" | "accessed" | "container" | "original-date"

"original-date" maybe? there doesn't seem to be a "filing-date" option currently.

Elena

There is no CSL variable appropriate to a notion of a filing date. I've added a ticket to the CSL tracker.

A bigger point: we really need a process for dealing with date changes, so that we can better coordinate connections between CSL, Zotero, and BIBO.

comment:7 Changed 7 years ago by dstillman

  • Resolution set to fixed
  • Status changed from new to closed

(In [5638]) Schema updates:

  • For "Book Section", added "Book Author" (needs to be mapped to CSL container-author) (closes #872)
  • For A/V item types, "Recording Type" mapped to "Type" is now "Format" mapped to "Medium" (closes #1060)
  • For "Radio Broadcast" and "TV Broadcast", replaced "Series Title" with "Program Title" mapped to "Publication Title" (CSL field container-title rather than collection-title) (closes #860)
  • For "Patent", added "Country" field, removed (nonfunctional) base-map from "Place" to "Country", added "Issuing Authority", replaced "Date" with "Filing Date" (not currently mapped to CSL), and moved "Date" data to "Filing Date". Kept "Issue Date" base-mapped to "Date". (closes #1375)
  • For "Film", mapped "Distributor" to "Publisher" (closes #861) and added "Genre" mapped to "Type"
  • For "Podcast", mapped "Audio File Type" to "Medium" rather than "Type"
  • For "Bill", added "Cosponsor" creator type (closes #655)
  • For "Case", added "Author" as primary creator type instead of "Counsel" (#655)

This can't yet sync, so upping sync API version and delaying dev XPI build.

Note: See TracTickets for help on using tickets.