Summary:
Enable users to configure an import to point to a folder instead of a fixed file path, so the system automatically selects the newest file available each time the import runs. This supports recurring Excel import workflows where source files are regularly replaced with newly dated versions.
Problem Statement:
Currently, imports require a fixed file path, which means users must manually update the import configuration whenever a new file is added with a different name or date stamp. This creates unnecessary maintenance, increases the risk of selecting the wrong file, and makes recurring import processes less reliable and more time-consuming.
Proposed Solution:
Allow users to configure Excel imports to target a specific folder rather than a single file. When the import runs, the system should automatically identify and use the most recently updated or newest matching file in that folder. The configuration should clearly define how the newest file is determined and should work reliably for recurring scheduled or manual imports. The feature should reduce the need for repeated path changes while maintaining predictability and control over which file is imported.
Benefits:
Reduces manual effort for recurring imports that rely on regularly updated files.
Decreases the likelihood of user error caused by outdated or incorrect file path selection.
Improves efficiency and reliability for teams that manage cyclical Excel-based import workflows.
Makes import configurations easier to maintain over time.