Capture a filename during an import
I am trying to automate (as much as possible) an import process and need some guidance/assistance.
I am importing an Excel spreadsheet where I need to capture the filename too. My goal is to strip part of the filename out and use it as an event name for the records I have just imported.
Currently I am importing the Excel file, verifying the import structure, and then manually adding the event name to the names I have just imported.
If you can offer guidance or point me to an example I would appreciate it.