SQLECmd icon indicating copy to clipboard operation
SQLECmd copied to clipboard

Adding OG File Name Variable for Output CSV

Open stark4n6 opened this issue 2 years ago • 5 comments

** SQLECmd version ** 1.0.0.0

Is your feature request related to a problem? Please describe. Processing multiple similar formatted files that use the same Map cause indistinguishable resulting CSVs.

Describe the solution you'd like When running with seek across Maps, would be great to have a potential variable to the "BaseFileName" field that would add the original file name that is processed to the final CSV filename.

Describe alternatives you've considered N/A

Additional context See screenshot below, the original DB files on the right and the resulting files on the left. I have to manually open each CSV to figure out which correlates to which original DB.

Screenshot 2022-05-13 155328

stark4n6 avatar May 13 '22 19:05 stark4n6

So maybe %f which would put the filename of the DB being parsed into the BaseFilename, kinda like how KAPE works with %m and %d with Hostname and DateTime?

AndrewRathbun avatar May 13 '22 20:05 AndrewRathbun

doesnt what is on the screen during the run help?

EricZimmerman avatar May 13 '22 20:05 EricZimmerman

does the csv itself contain a source file field?

EricZimmerman avatar May 14 '22 15:05 EricZimmerman

does the csv itself contain a source file field?

Yes it does.

AndrewRathbun avatar May 14 '22 18:05 AndrewRathbun

does the csv itself contain a source file field?

yeah it does, maybe I need to refactor the queries to see if I can tie the databases together somehow more easily.

stark4n6 avatar May 14 '22 18:05 stark4n6