Large EDIFACT invoices fail to import properly - Kiwi BF env (Harrassowitz Chicago)

Description

Current workaround Manual entry

Steps to Reproduce:

  1. Scenario

    • Go to Kiwi Bugfest

    • Go to Settings/Data Import and review the Job/Action/Field mapping profiles for Create Large Harrassowitz serial invoice IMD+L and the attached invoice file 20201114072017.EDI and Word version 20201114072017.edi.docx and confirm that the field mappings are correct

    • Go to Data Import and upload the file 20201114072017.EDI

    • Assign the Harrassowitz job profile cited above, and import the file

Expected Results: should create 9 invoices with a total of 1326 line items

Actual Results: did not complete

Additional Information: EDIFACT files (file extension .edi) and corresponding human-readable Word versions (file extension .docx)

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

2

Checklist

hide

TestRail: Results

Activity

Show:

Kateryna SenchenkoNovember 29, 2021 at 11:18 AM

, we did fix the file extension thing - it should be case insensitive, sorry for confusion. 

Ann-Marie BreauxNovember 29, 2021 at 11:14 AM

Excellent! I just saw your note about the file extension needing to be lower-case . I thought we fixed it so that the case of the file extension was ignored. Will test again later today (nap time now), and add a comment in the Kiwi release notes and a Lotus bug, if necessary.

Kateryna SenchenkoNovember 29, 2021 at 11:06 AM

,

Import was successful after the chunk size for EDIFACT files was reduced! I'll add it to the release notes. Thank you!

Ann-Marie BreauxNovember 29, 2021 at 10:36 AM

All sounds good - thank you . I'm going to close this issue, since I think it's only a config problem.

Tested on Kiwi BF with the following files and profiles:

  • 20201114072017.EDI Create Large Harrassowitz serial invoice IMD+L (9 invoices, 1326 lines)

  • 20211112095358.24-SER.subs.edi Create Large Harrassowitz serial invoice MOA+39 (17 invoices, 277 lines)

  • 20191130072046.TAMUSER.edi Create Large Harrassowitz serial invoice (18 invoices, 1104 lines)

  • ALE0092.R110817.T100818.INV Create large EBSCO subscription invoice (31 invoices, 1732 lines)

All except the last one successfully created all invoices and invoice lines. I reviewed the profile for the last one (Create large EBSCO subscription invoice) and tried the import several times, but it always failed on Kiwi, with no useful error message in the UI. The same file did import successfully in Juniper BF, so maybe it's an issue with configuration.

Also, the import and invoice creation was noticeably faster on Kiwi BF than Juniper.

Kateryna SenchenkoNovember 29, 2021 at 10:24 AM

Hi , we asked to adjust the params on Kiwi bugfest, it will be done shortly, and we'll be able to test import of the Duke file again

Done

Details

Assignee

Reporter

Priority

Story Points

Development Team

Folijet Support

Release

R3 2021 Bug Fix

Affected Institution

Cornell
TAMU
University of Chicago

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created November 22, 2021 at 2:47 PM
Updated December 29, 2021 at 2:48 PM
Resolved November 26, 2021 at 4:37 PM
Loading...