The job completed with errors after importing .edi file when mapping profile contains fields with hyphen

Description

Preconditions:

Authorized user with following permissions is logged in:

  • Data Import File Upload - all permissions

  • Data import: Can upload files, import, and view logs

  • Settings (Data import): Can view, create, edit, and remove

  • Invoice: Can view, edit and delete Invoices and Invoice lines

Steps to reproduce:

  1. Go to Settings/Data Import/Field mapping profiles

  2. Find the Default - Harrassowitz serials invoice and go to Actions/Duplicate. Adjust the new field mapping profile:

    • Profile name: Test Harrassowitz invoice with space

    • Description: Delete

    • Batch group: Select one from the dropdown list

    • In the Invoice note field, add RFF+API[2] " " NAD+SU+++[1]

    • Vendor name: Click Organization lookup, find the Harrassowitz vendor and select it

    • Payment method: Select one from the dropdown list

    • Currency: delete the mapping and select USD

    • Description: Change the existing mapping from {POL_title}; else IMD+F+050+[4-5] to {POL_title}; else IMD+L+050+[4-5]

    • PO line number: Change the mapping from RFF+SNL[2] to RFF+LI[2]

    • Subscription info: Add IMD+L+085+[4-5] " " IMD+L+086+[4-5]

    • Subscription start date: Add DTM+194[2]

    • Subscription end date: Add DTM+206[2]

    • Comment: Add IMD+L+085+[4-5] " " IMD+L+086+[4-5]

    Save the field mapping profile

  3. Duplicate the field mapping profile you created in Step 2 and adjust as follows:

    • Profile name: Change to Test Harrassowitz invoice with hyphen

    • Invoice note field: Change to RFF+API[2] "-" NAD+SU+++[1]

    • Subscription info: Change to IMD+L+085+[4-5] "-" IMD+L+086+[4-5]

    • Comment: Change to IMD+L+085+[4-5] "-" IMD+L+086+[4-5]

    Save the updated field mapping profile.

  4. Go to Settings/Data import/Action profiles. Create a new Action profile by clicking Actions/New action profile

    • Name: Change to Test Harrassowitz invoice with space

    • Action: Create

    • FOLIO record type: Invoice

    • Click on Link profile, and select the Test Harrassowitz invoice with space field mapping profile

    Save the profile

  5. Go to Settings/Data import/Action profiles. Create a new Action profile by clicking Actions/New action profile

    • Name: Change to Test Harrassowitz invoice with hyphen

    • Action: Create

    • FOLIO record type: Invoice

    • Click on Link profile, and select the Test Harrassowitz invoice with hyphen field mapping profile

    Save the profile

  6. Go to Settings/Data import/Job profiles. Create a new Job profile by clicking Actions/New job profile

    • Name: Change to Test Harrassowitz invoice with space

    • Action: Accepted data type: EDIFACT

    • In the Overview, click +Action, and select the Test Harrassowitz invoice with space action profile

    Save the profile

  7. Go to Settings/Data import/Job profiles. Create a new Job profile by clicking Actions/New job profile

    • Name: Change to Test Harrassowitz invoice with hyphen

    • Action: Accepted data type: EDIFACT

    • In the Overview, click +Action, and select the Test Harrassowitz invoice with hyphen action profile

    Save the profile

  8. Now you should have 2 complete job profiles, one to test the multi-field syntax with a space between the elements, and one to test with a hyphen between the elements.
    Go to the Data Import app

  9. Import the attached MichHarrasowitzSerial.edi invoice file.

  10. Select the Test Harrassowitz invoice with space job profile, run the job, and confirm

  11. Go back to Data Import and impost the same invoice, this time using the Test Harrassowitz invoice with hyphen job profile

  12. Pay attention to the job status.

Actual result: The job completed with errors after importing .edi file when mapping profile contains fields with hyphen.

Expected result: The job completed after importing .edi file when mapping profile contains fields with hyphen. The invoice and invoice lines are created.

Environment: https://bugfest-ramsons-aqa.int.aws.folio.org, https://bugfest-ramsons.int.aws.folio.org

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

3

Checklist

hide

Activity

Show:

Ryan Taylor January 31, 2025 at 3:26 PM

- Odd behavior, but unsure how prevalent this is. Considering there is a workaround by changing the name of the mapping profile, I think we should briing to sunflower as a p3, but consider upping for Ramsons CSP inclusion if this triggers issues in production environments.

Khalilah Gambrell January 29, 2025 at 7:30 PM

Hey . What is the priority of this issue?

Details

Assignee

Reporter

Priority

Development Team

Folijet

Release

Trillium (R2 2025)

RCA Group

TBD

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created January 27, 2025 at 2:53 PM
Updated March 12, 2025 at 1:54 PM
TestRail: Cases
TestRail: Runs