Mappings required

[codec]

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]

[erazlogo]

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

[erazlogo]

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

[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.

[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.

[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.

[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?

[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

[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.

[erazlogo]

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

[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

[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

[ajlyon]

What's the status of the last piece of this, regarding director, screenwriter, etc? Also, what about the closely related tickets #862 and #844?

Are there concrete changes that can be made for Zotero 2.1?

See the whiteboard for short-term changes to fields and types: ​https://github.com/ajlyon/zotero-bits/wiki/Zotero-types-whiteboard