MARCcat: MARC Bibliographic records
(UXPROD-786)
|
|
| Status: | Closed |
| Project: | UX Product |
| Components: | None |
| Affects versions: | None |
| Fix versions: | None | Parent: | MARCcat: MARC Bibliographic records |
| Type: | New Feature | Priority: | P3 |
| Reporter: | Annalisa Di Sabato | Assignee: | Tiziana Possemato |
| Resolution: | Done | Votes: | 0 |
| Labels: | Heading, MARCcat-Bib, Name-Title, cap-mvp, team-mvp | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original estimate: | Not Specified | ||
| Attachments: |
|
||||||||||||||||||||||||||||
| Issue links: |
|
||||||||||||||||||||||||||||
| Epic Link: | MARCcat: MARC Bibliographic records | ||||||||||||||||||||||||||||
| Analysis Estimate: | Large < 10 days | ||||||||||||||||||||||||||||
| Front End Estimate: | Large < 10 days | ||||||||||||||||||||||||||||
| Front End Estimator: | Matteo Pascucci | ||||||||||||||||||||||||||||
| Back End Estimate: | Large < 10 days | ||||||||||||||||||||||||||||
| Back End Estimator: | carmentrazza | ||||||||||||||||||||||||||||
| Development Team: | @cult | ||||||||||||||||||||||||||||
| Rank: Chalmers (Impl Aut 2019): | R5 | ||||||||||||||||||||||||||||
| Rank: Chicago (MVP Sum 2020): | R4 | ||||||||||||||||||||||||||||
| Rank: Cornell (Full Sum 2021): | R5 | ||||||||||||||||||||||||||||
| Rank: Duke (Full Sum 2021): | R1 | ||||||||||||||||||||||||||||
| Rank: 5Colleges (Full Jul 2021): | R4 | ||||||||||||||||||||||||||||
| Rank: FLO (MVP Sum 2020): | R4 | ||||||||||||||||||||||||||||
| Rank: GBV (MVP Sum 2020): | R5 | ||||||||||||||||||||||||||||
| Rank: hbz (TBD): | R5 | ||||||||||||||||||||||||||||
| Rank: Hungary (MVP End 2020): | R1 | ||||||||||||||||||||||||||||
| Rank: Lehigh (MVP Summer 2020): | R4 | ||||||||||||||||||||||||||||
| Rank: Leipzig (Full TBD): | R5 | ||||||||||||||||||||||||||||
| Rank: Leipzig (ERM Aut 2019): | R5 | ||||||||||||||||||||||||||||
| Rank: TAMU (MVP Jan 2021): | R4 | ||||||||||||||||||||||||||||
| Rank: U of AL (MVP Oct 2020): | R4 | ||||||||||||||||||||||||||||
| Description |
|
Management of name-title heading in MARCcat based on David's prototype. |
| Comments |
| Comment by carmentrazza [ 01/Apr/20 ] |
|
The required changes have been made both on the back-end and on the front-end.
Front-end:
The Name / Title feature involves creating name / title tags and the browse search records. |
| Comment by carmentrazza [ 01/Apr/20 ] |
|
The creation of the name / title tags fails for this reason: Batch entry 0 insert into amicus.NME_ACS_PNT (NME_WRK_RLTR_CDE, MTRL_SPCFY_TXT, INTTN_WHICH_FLD_APLY_CDE, NME_WRK_RLTR_STRNG_TXT, NME_OTHER_SBFLDS, NME_SEQ_NBR, NME_HDG_NBR, BIB_ITM_NBR, NME_TTL_HDG_NBR, USR_VW_IND, NME_FNCTN_CDE) values (NULL, NULL, NULL, NULL, NULL, NULL, 110, 213, 2, '1000000000000000', 0) was aborted: ERROR: insert or update on table "nme_acs_pnt" violates foreign key constraint "nme_acs_pnt_fk3" This NME_FNCTN_CDE column must have for tag Name/ Title must be equal to 0. You have to assign the bug to Mirko |
| Comment by Mirko Fonzo [ 01/Apr/20 ] |
|
The following list shows the allowed values for the column NME_ACS_PNT.nme_fnctn_cde, the value 0 is not present: 1 => "Added Entry - Not specified" What the value 0 is intended for? |
| Comment by carmentrazza [ 01/Apr/20 ] |
|
For the creation of the title name tags we need to insert the code 0. |
| Comment by Mirko Fonzo [ 01/Apr/20 ] |
|
A proper new entry point has been added to the tables T_TTL_FNCTN and T_NME_FNCTN. |
| Comment by carmentrazza [ 01/Apr/20 ] |
|
Now, I have another error: Batch entry 0 insert into amicus.TTL_ACS_PNT (TTL_SRS_ISSN_NBR, TTL_SCDRY_FNCTN_CDE, INTTN_WHICH_FLD_APLY_CDE, TTL_VOL_NBR_DSC, MTRL_SPCFY_TXT, VRNT_TTL_DSPLY_CDE_TXT, SEQ_NBR, TTL_HDG_NBR, BIB_ITM_NBR, NME_TTL_HDG_NBR, USR_VW_IND, TTL_FNCTN_CDE) values (NULL, 0, NULL, NULL, NULL, NULL, NULL, 129, 220, 3, '1000000000000000', 0) was aborted: ERROR: insert or update on table "ttl_acs_pnt" violates foreign key constraint "ttl_acs_pnt_fk4" For Title/Name tags TTL_ACS_PNT the columns have a value of 0:
|
| Comment by Mirko Fonzo [ 01/Apr/20 ] |
|
I've added the required records to the T_TTL_SCDRY_FNCTN table. |
| Comment by Mirko Fonzo [ 03/Apr/20 ] |
|
One more issue has been found. insert into amicus.TTL_ACS_PNT (TTL_SRS_ISSN_NBR, TTL_SCDRY_FNCTN_CDE, INTTN_WHICH_FLD_APLY_CDE, TTL_VOL_NBR_DSC, MTRL_SPCFY_TXT, VRNT_TTL_DSPLY_CDE_TXT, SEQ_NBR, TTL_HDG_NBR, BIB_ITM_NBR, NME_TTL_HDG_NBR, USR_VW_IND, TTL_FNCTN_CDE) The issue has been fixed with the MARCCat DB 1.4 patch. |
| Comment by Annalisa Di Sabato [ 03/Apr/20 ] |
|
The test was successfull |