Extract filename during import

[Rich S]

Greets, all:

I have a script to import the data from an exported Excel file, then it does its thing and exports the data into a .csv file--and it works just fine--but the filename of the source file always differs so I can't hard code that filename into the Specify Data Source option in the Import Records script step. C'est la vie. However, I would like to extract that filename so when the latter part of the import script exports the data as a .csv file, the exported file has the same filename as the source file (but with a different file extension, of course). Is there a way to capture the source filename during the import process--as a variable, I reckon--so I can automate the naming of the output file?

Cheers,

Rich

[comment]

21 minutes ago, WF7A said:

Is there a way to capture the source filename during the import process

No, but you could start the process by inserting the file into a container field. This will allow you to extract the selected file's name. Then have the script export the field's contents to a known location and import from there.

 

[Rich S]

Brilliant! Thanks!