I am trying to create my first data loading application in APEX 20.1.
The application loads CSV files. All records in a file are for the same academic year (e.g. 20202021 OR 20212022). The academic year is not a column in the file, however.
Right now, the data load is working, but I am not populating the academic year field. I could ask the users to add academic year as a column in the file prior to the load, but think there is a more user-friendly approach.
How would you handle this? I thought of adding a page to the application that prompted for the academic year after the data load has finished and then updates the records with that value when a button is clicked... Is there a better way?
Any general suggestions are greatly appreciated.