Details
-
Bug
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Done
-
None
-
-
0.5
-
Folijet Support
-
R2 2021 Bugfix
Description
Overview: When an invoice file has a CAPS file extension of INV or EDI, you can upload it, but cannot import it. It fails silently, with no error or indication of what happened. If the EDIFACT invoice file has an extension of lower-case inv or edi, you can upload it and import it. MARC files with upper-case, lower-case, or mixed-case file extensions import just fine.
Current workaround: Change the invoice file extension to lower case before uploading the file (added this note to the Iris release notes)
Steps to Reproduce:
- Log into FOLIO-snapshot-load as diku_admin
- Go to Settings/Data Import/Field mapping profile
- Find the Default EBSCO Serials Invoice field mapping profile
- Go to Actions/Duplicate
- Update the new field mapping profile as follows (leave the existing mapping info unless change or addition described below)
- Name: Import EBSCO Serials Invoice
- Description: Delete all the existing text
- Batch group: "FOLIO"
- Vendor name: use the vendor lookup to find and select EBSCO
- Payment method: "EFT"
- Currency: Delete existing info and select "USD" from the dropdown menu
- Vendor reference number: leave the existing one for RFF+SNA, and add another one
- Vendor reference number: RFF+LI[2]
- Vendor reference type: "Vendor subscription reference number"
- Save the updated profile
- Go to Action profiles and create a new profile
- Name: Create EBSCO subscription invoice
- Action: Create
- FOLIO record type: Invoice
- Link the field mapping profile to it and save
- Go to Job profiles and create a new profile
- Name: Create EBSCO Subscription Invoice
- Accepted data type: EDIFACT
- Click + and select Action
- Find the action profile you just created and attach to the job profile
- Now you have an EDIFACT invoice job profile
- Go to Data import and upload the attached file that has a file extension of ".inv" (lower-case
- In the Select job profile screen, select the EBSCO invoice job profile and run it
- Once the import completes (and displays at the top of the landing page list), upload the attached file that has a file extension of ".INV" (upper-case)
- In the Select job profile screen, select the EBSCO invoice job profile and run it
Expected Results: Both files should import successfully. The case of a file extension (all-upper-case, all-lower-case, or mixed case) should not matter.
Actual Results: The file with ".inv" imports successfully. The file with ".INV" does not import and seems to just disappear. For comparison, import the attached ".mrc", ".mrC" and ".MRC" files with the Default create instance and SRS MARC Bib job profile. All 3 MARC files import successfully.
Additional Information: See attached video and files
TestRail: Results
Attachments
Issue Links
- blocks
-
MODDATAIMP-510 Release v2.1.2 (R2 Juniper Bugfix)
-
- Closed
-
- defines
-
UXPROD-2851 NFR: Data Import (Batch Importer for Bib Acq) & PubSub R2 2021 Juniper Technical, NFR, & Misc bug work
-
- Closed
-