Opened 9 years ago

Last modified 6 years ago

#842 new enhancement

Mappings required — at Version 13

Reported by: codec Owned by: simon
Priority: major Milestone:
Component: styles Version: 1.5
Keywords: schema-update Cc: erazlogo, dstillman, ajlyon

Description (last modified by erazlogo)

Summarising the list discussion (I think)

I think the following mappings need to be added:
For Audio recording
performer is mapped as author. Composer, and words by need to be mapped, not sure there are good csl destinations.

Repository should be mapped to archive. [done]

Bills and similar
Bill number/case number should be mapped to number. Patent No. also needs mapping. [done]

Legal case, the court field needs mapping to something. [done]

series-editor to the new series-editor for books and chapters at least. [done]

Conference Paper

  • Conference name is not mapped, maybe to event? [done]

Film - producer and scriptwriter need mapping. Director may need changing.

Interviewer/recipient mapped to new attribute [done]

section in newspaper needs mapping. [done]

Change History (14)

Changed 9 years ago by erazlogo

comment:1 Changed 9 years ago by erazlogo

  • Cc erazlogo dstillman added

hi--
i just uploaded cslarchivalpatchfile that adds support for citing archival sources to zotero. i revised the two chicago note styles but they won't work without these changes so i will. the javascript revisions are very minor--they imitate simon's code and work in csledit.xul which i assume means that the code is bug-free.

dan--
can i have commit access for csl files?
thanks!
elena

comment:2 Changed 9 years ago by erazlogo

(In [1936]) Addresses #842, Mappings required

comment:3 Changed 9 years ago by codec

Added the mappings for series-editor to seriesEditor
documentNumber, patentNumber, billNumber, codeNumber, episodeNumber all map to number as part of [1956].
Need to consider original-date - I think that may need some SQL additions.

comment:4 follow-up: Changed 9 years ago by dstillman

Were the various *Number fields not working before? Because those are base-field-mapped to 'number' in SQL already, though it's possible the base field mappings aren't used in all places in the CSL code. We do want to avoid adding redundant JS mappings as much as possible.

comment:5 in reply to: ↑ 4 Changed 9 years ago by codec

Replying to dstillman:
They weren't available before the patch, and are after, so I guess they weren't mapped in the SQL, or else it wasn't getting through the JS somehow.

comment:6 Changed 9 years ago by dstillman

Here are the SQL mappings:

INSERT INTO baseFieldMappings VALUES (15, 60, 92); -- report/number/reportNumber
INSERT INTO baseFieldMappings VALUES (16, 60, 93); -- bill/number/billNumber
INSERT INTO baseFieldMappings VALUES (18, 60, 99); -- hearing/number/documentNumber
INSERT INTO baseFieldMappings VALUES (19, 60, 50); -- patent/number/patentNumber
INSERT INTO baseFieldMappings VALUES (20, 60, 101); -- statute/number/publicLawNumber
INSERT INTO baseFieldMappings VALUES (29, 60, 105); -- tvBroadcast/number/episodeNumber
INSERT INTO baseFieldMappings VALUES (30, 60, 105); -- radioBroadcast/number/episodeNumber
INSERT INTO baseFieldMappings VALUES (31, 60, 105); -- podcast/number/episodeNumber

So if those weren't working before, the mappings aren't being used in this part of the cite code. Simon, is that correct?

comment:7 Changed 9 years ago by codec

They look like they should work, but here is the output if I comment out the added code on some dummy entries with everything possible filled in with something for hearing, patent and statute.

Type is bill
Type is book
AUTHOR LONG=ContribLast ContribFirst SHORT=ContribFirst
ISSUED: YEAR=1990 (90) MONTH=January(Jan/1/01) DAY=1st/1/1
ACCESSED: YEAR=1992 (92) MONTH=February(Feb/2/02) DAY=2nd/2/2
TITLE SHORT=Short Title LONG=Hearing Title
PUBLISHER SHORT=Publisher LONG=Publisher
PUBLISHER-PLACE SHORT=Place LONG=Place
EVENT-PLACE SHORT=Place LONG=Place
PAGE SHORT=First Page LONG=First Page
NUMBER-OF-VOLUMES SHORT=No Volumes LONG=No Volumes
NOTE SHORT=Extra Info LONG=Extra Info
ABSTRACT SHORT=The Abstract LONG=The Abstract
URL SHORT=http://The.url LONG=http://The.url
CITATION-NUMBER SHORT=2 LONG=2

Type is book
Type is patent
AUTHOR LONG=ContribLast ContribFirst SHORT=ContribFirst
ISSUED: YEAR=1990 (90) MONTH=January(Jan/1/01) DAY=1st/1/1
ACCESSED: YEAR=1992 (92) MONTH=February(Feb/2/02) DAY=2nd/2/2
TITLE SHORT=Short Title LONG=Patent Title
PAGE SHORT=First Page LONG=First Page
NOTE SHORT=Extra Info LONG=Extra Info
ABSTRACT SHORT=The Abstract LONG=The Abstract
URL SHORT=http://The.url LONG=http://The.url
CITATION-NUMBER SHORT=3 LONG=3

Type is bill
Type is book
AUTHOR LONG=AuthorFirst AuthorLast SHORT=AuthorLast
ISSUED: YEAR=1990 (90) MONTH=January(Jan/1/01) DAY=1st/1/1
ACCESSED: YEAR=1992 (92) MONTH=February(Feb/2/02) DAY=2nd/2/2
TITLE SHORT=Short Title LONG=Statute Title
PAGE SHORT=First Page LONG=First Page
NOTE SHORT=Extra Info LONG=Extra Info
ABSTRACT SHORT=The Abstract LONG=The Abstract
URL SHORT=http://The.url LONG=http://The.url
CITATION-NUMBER SHORT=4 LONG=4

And here it is with the change.

Type is bill
Type is book
AUTHOR LONG=ContribLast ContribFirst SHORT=ContribFirst
ISSUED: YEAR=1990 (90) MONTH=January(Jan/1/01) DAY=1st/1/1
ACCESSED: YEAR=1992 (92) MONTH=February(Feb/2/02) DAY=2nd/2/2
TITLE SHORT=Short Title LONG=Hearing Title
PUBLISHER SHORT=Publisher LONG=Publisher
PUBLISHER-PLACE SHORT=Place LONG=Place
EVENT-PLACE SHORT=Place LONG=Place
PAGE SHORT=First Page LONG=First Page
NUMBER-OF-VOLUMES SHORT=No Volumes LONG=No Volumes
NOTE SHORT=Extra Info LONG=Extra Info
ABSTRACT SHORT=The Abstract LONG=The Abstract
NUMBER SHORT=Doc Number LONG=Doc Number      <----------
URL SHORT=http://The.url LONG=http://The.url
CITATION-NUMBER SHORT=2 LONG=2

Type is book
Type is patent
AUTHOR LONG=ContribLast ContribFirst SHORT=ContribFirst
ISSUED: YEAR=1990 (90) MONTH=January(Jan/1/01) DAY=1st/1/1
ACCESSED: YEAR=1992 (92) MONTH=February(Feb/2/02) DAY=2nd/2/2
TITLE SHORT=Short Title LONG=Patent Title
PAGE SHORT=First Page LONG=First Page
NOTE SHORT=Extra Info LONG=Extra Info
ABSTRACT SHORT=The Abstract LONG=The Abstract
NUMBER SHORT=Patent Number LONG=Patent Number      <----------
URL SHORT=http://The.url LONG=http://The.url
CITATION-NUMBER SHORT=3 LONG=3

Type is bill
Type is book
AUTHOR LONG=AuthorFirst AuthorLast SHORT=AuthorLast
ISSUED: YEAR=1990 (90) MONTH=January(Jan/1/01) DAY=1st/1/1
ACCESSED: YEAR=1992 (92) MONTH=February(Feb/2/02) DAY=2nd/2/2
TITLE SHORT=Short Title LONG=Statute Title
PAGE SHORT=First Page LONG=First Page
NOTE SHORT=Extra Info LONG=Extra Info
ABSTRACT SHORT=The Abstract LONG=The Abstract
NUMBER SHORT=Public Law Number LONG=Public Law Number      <----------
URL SHORT=http://The.url LONG=http://The.url
CITATION-NUMBER SHORT=4 LONG=4

comment:8 Changed 9 years ago by codec

After looking at this further it turns out it only needs the number mapping as like Dan said, the rest are provided for by the SQL mapping table.
ISBN needs to be added too.

comment:9 Changed 9 years ago by erazlogo

  • Description modified (diff)

See also tickets #872, #867, #863, #862, #861, #860. These could all be done together once schema changes are possible.

comment:10 Changed 8 years ago by erazlogo

  • Keywords schema-update added

comment:11 Changed 8 years ago by erazlogo

(In [4265]) Addresses #842, Mappings required
Addresses #1408, Incorect format for legal case citations in CMS note without biblography style
On the branch, maps court in case item type to authority, a new CSL variable

comment:12 Changed 8 years ago by erazlogo

(In [4266]) Addresses #842, Mappings required
Addresses #1408, Incorect format for legal case citations in CMS note without biblography style
On the trunk, maps court in case item type to authority, a new CSL variable

comment:13 Changed 8 years ago by erazlogo

  • Description modified (diff)
Note: See TracTickets for help on using tickets.