Uploaded image for project: 'mod-data-import'
  1. mod-data-import

EDIFACT files with txt file extensions do not import - Lotus BF



    • 2
    • Folijet Support
    • Lotus (R1 2022) Bug Fix
    • Incomplete/missing requirements


      Overview: When an EDIFACT invoice file has a txt file extension (which is not in the list of default file extensions), then it cannot be imported

      Current workaround: Change the invoice file extension to .edi or .inv before uploading the file

      Steps to Reproduce:

      1. Log into FOLIO-snapshot-load as diku_admin
      2. Go to Organizations
      3. Create a new Organization by clicking New
        • Name: WS Hein
        • Code: Hein
        • Accounting code: [any numbers you want]
        • Organization status: Active
        • Check the Vendor box
        • Save the newly-created vendor
      4. Go to Settings/Data Import/Field mapping profile
      5. Find the Default - Hein serials invoice field mapping profile
      6. Go to Actions/Duplicate
      7. Update the new field mapping profile as follows (leave the existing mapping info unless change or addition is described below)
        • Name: Import Hein Serials Invoice
        • Description: Delete all the existing text
        • Batch group: "FOLIO"
        • Vendor name: use the vendor lookup to find and select Hein
        • Accounting code: keep whatever accounting code was defaulted when you selected Hein
        • Payment method: "EFT"
        • Currency: Delete existing info and select "USD" from the dropdown menu
        • Save the updated profile
      8. Go to Action profiles and create a new profile
        • Name: Import Hein subscription invoice
        • Action: Create
        • FOLIO record type: Invoice
        • Link the field mapping profile to it and save
      9. Go to Job profiles and create a new profile
        • Name: Import Hein Subscription Invoice
        • Accepted data type: EDIFACT
        • Click + and select Action
        • Find the action profile you just created and attach to the job profile
      10. Now you have an EDIFACT invoice job profile
      11. Go to Data import and upload the attached file that has a file extension of ".txt" (lower-case
      12. In the Select job profile screen, select the Hein invoice job profile and run it

      Expected Results:

      1. Since .txt is not a file extension setting in the Data Import settings, all job profiles (MARC and EDIFACT) should display, The user should be able to select the Hein job profile and import the invoice.
      2. Since the file is not a MARC file, if the user selects a MARC job profile to import the Hein invoice, it should fail (since the MARC job profile can't parse EDIFACT) and display an error in the log, with some sort of message about job profile and file data are not compatible

      Actual Results:

      1. When the Hein EIFACT profile is selected, the file with ".txt" does not import, and shows in the log as failed, but no error message
      2. When try to import the same EDIFACT file with a MARC job profile, it does not import, does not fail, does not display an error message - just disappears

      NOTE: When fixed, also test an EDIFACT file with a different file extension that is not in the file extension settings (e.g. .money) to confirm that *any file extension not listed in the settings can be imported as EDIFACT

      Additional Information: See attached 274812_WSHEIN_STO.txt file

      TestRail: Results


          Issue Links



                olamshin Olamide Kolawole
                abreaux Ann-Marie Breaux
                0 Vote for this issue
                5 Start watching this issue



                  TestRail: Runs

                    TestRail: Cases