Preserve LDR 05, 06, 07 values on the export with custom mapping profiles
Description
Environment
Potential Workaround
Attachments
- 01 Apr 2022, 01:41 PM
- 01 Apr 2022, 01:41 PM
- 01 Apr 2022, 01:33 PM
- 01 Apr 2022, 01:18 PM
- 01 Apr 2022, 12:10 AM
- 31 Mar 2022, 08:48 AM
relates to
Checklist
hideTestRail: Results
Activity
Oleksii Petrenko April 6, 2022 at 9:06 PM
Deployed to Lotus BF. Please proceed with verification
Siarhei Charniak April 1, 2022 at 1:37 PMEdited
@Magda Zacharska
Verified on folio-snapshot environment
1. Created custom mapping profile:
curl --location --request POST 'https://folio-snapshot-okapi.dev.folio.org:443/data-export/mapping-profiles' \
--header 'x-okapi-tenant: diku' \
--header "x-okapi-token: $TOKEN" \
--header 'Content-Type: application/json' \
--data-raw '{
"name" : "T984504",
"recordTypes" : [ "SRS", "HOLDINGS", "ITEM" ],
"transformations" : [ {
"fieldId" : "holdings.holdingsstatements.statement",
"path" : "$.holdings[*].holdingsStatements[*].statement",
"enabled" : true,
"transformation" : "866 0$a",
"recordType" : "HOLDINGS"
}, {
"fieldId" : "holdings.permanentlocation.name",
"path" : "$.holdings[*].permanentLocationId",
"enabled" : true,
"transformation" : "866 $z",
"recordType" : "HOLDINGS"
}, {
"fieldId" : "item.effectivelocation.code",
"path" : "$.holdings[*].items[*].effectiveLocationId",
"enabled" : true,
"transformation" : "567 $s",
"recordType" : "ITEM"
} ],
"userInfo" : {
"firstName" : "Yauheniya",
"lastName" : "Kryshtafovich",
"userName" : "yauheniya_kryshtafovich"
},
"outputFormat" : "MARC",
"metadata" : {
"createdDate" : "2022-03-23T10:24:27.408+00:00",
"createdByUserId" : "ba840a17-c848-4b4f-a356-96900b088e9a",
"updatedDate" : "2022-03-23T10:24:27.408+00:00",
"updatedByUserId" : "ba840a17-c848-4b4f-a356-96900b088e9a"
}
}'Response:
{
"id": "1c422f42-cb91-4c8b-8aab-67297fed7721",
"name": "T984504",
"default": false,
"recordTypes": [
"SRS",
"HOLDINGS",
"ITEM"
],
"transformations": [
{
"fieldId": "holdings.holdingsstatements.statement",
"path": "$.holdings[*].holdingsStatements[*].statement",
"enabled": true,
"transformation": "866 0$a",
"recordType": "HOLDINGS"
},
{
"fieldId": "holdings.permanentlocation.name",
"path": "$.holdings[*].permanentLocationId",
"enabled": true,
"transformation": "866 $z",
"recordType": "HOLDINGS"
},
{
"fieldId": "item.effectivelocation.code",
"path": "$.holdings[*].items[*].effectiveLocationId",
"enabled": true,
"transformation": "567 $s",
"recordType": "ITEM"
}
],
"userInfo": {
"firstName": "DIKU",
"lastName": "ADMINISTRATOR",
"userName": "diku_admin"
},
"outputFormat": "MARC",
"metadata": {
"createdDate": "2022-04-01T12:49:41.492+00:00",
"createdByUserId": "e3e921b5-c95a-512a-8d22-4f6fbd2dd549",
"updatedDate": "2022-04-01T12:49:41.492+00:00",
"updatedByUserId": "e3e921b5-c95a-512a-8d22-4f6fbd2dd549"
}
}2. Created job profile - "mdexp-516"
3. Imported attached
file, initial leader value:
4. Performed data export (see attached
file), required leader fields were preserved:
Magda Zacharska April 1, 2022 at 12:07 AMEdited
Hi @Siarhei Charniak - I cannot validate this story until https://folio-org.atlassian.net/browse/STDTC-56#icft=STDTC-56 is fixed because I cannot create custom mapping profile. If this can be verified by API calls - please attach screen shots or we can use the demo time to walk through API testing so that we can deploy it to the bugfest environment without any delay
I'm attaching .mrc file that can be imported for testing purposes.
Magda Zacharska March 31, 2022 at 12:50 PM
@Nauman Khan - there are no plans for Kiwi HF3 at this point. The issue will be addressed in the Lotus release.
Nauman Khan March 31, 2022 at 8:48 AM
Issue being reported by Trinity and is getting replicated on bugfest kiwi as well for LDR6.
Data Export Module (mod-data-export-4.2.4)
Steps to reproduce:
1- Login to https://bugfest-kiwi.folio.ebsco.com/
2- Go to data export.
3- Upload the attached file(nim.csv). This record is having value as 'i' in LDR6 position.
4- Use the Vufind profile(which includes holdings and items data as well) for data export.
5-The exported mrc file has value changed to 'a' in LDR6 position.
LDR6 Value is preserved when export is done using default profile but changes when exported using custom profile.
cc @Ben Taylor
Purpose/Overview:
Some of the fields need to be preserved while exporting SRS records with that are enriched with holdings and item data.
Requirements/Scope:
LDR for the exports where SRS record was enriched with holdings/items records should be:
LDR 05, 06, 07 - preserved
Approach:
Acceptance criteria:
LDR fields are adjusted according to the requirements for the custom mapping profile
LDR does not change for the records exported with the default mapping profile
MARC file is valid
API tests are written/updated and tests passed successfully (screenshot added)