Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleDescription of Issue

Select Import in the GA School Lunch/School Nutrition program and getting a message that message that Errors have occurred. Import was unsuccessful

GA School Lunch Import Error, Munis (glgalnch) err- mesg System Log ID

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleContext
  • Financials
  • Georgia
  • GA School Lunch ExportNutrition DE106 Reporting


Export file columns don't match the import file columns
Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause



Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution
Import file columns need to be all caps, in the following order, and match exact wording:
  • REPORTING YEAR
  • REPORTING PERIOD
  • DESCRIPTION
  • SCHOOL NUMBER
  • POSITION RANGE
  • AMOUNT

    The error may be a result of installing (master) work ticket MUN-429777, which made the Export to Excel column header order match the Import to Excel column header order, allowing you to Export to Excel, make changes and then use the same file to Import to Excel.  However, the column header formatting was inadvertently changed for the Import to Excel file.  Where column headers in the Import file previously had to be all caps, they now need to be case sensitive.  We apologize for the ensuing frustration.

    To move forward, please confirm the following:

    • Column headers need match the header columns produced from the Export to Excel file., as follows
      • Reporting Year
      • Reporting Period
      • Description
      • School Number
      • Position Range
      • Amount
    • Import file should only have one tab/worksheet. 
    • Check file for bad data or hidden fields.

    ...

    Export file has the columns School Number, Position Range, Description and Amount. 

    Import it needs to be Reporting Year, Reporting Period, Description, School Number, Position Range and Amount.
    Panel
    borderColor#03396c
    titleColorWhite
    titleBGColor#03396c
    titleAdditional Information

    Under (master) enhancement work ticket MUN-429777 473721 we will standardize the export/import process.