Automating export of CSV data

[Nish]

I would like a way to automate the export of data from the Systemhound database into Excel (or some other format) on, for example, a nightly basis.

Set up a job in Windows Task Scheduler to do this. The CSV Export tool has command line options, so create a batch file and call this. For example:

"C:\Program Files\systemhound\utils\shexport" -s -hwfile -swfile

Save the above line as export.bat (i.e., create a txt file in Notepad with the above line and save the file as export.bat), and then create a new task in Windows Sheduler and call this file.

[epolerecky]

Using the command: "C:\Program Files\systemhound\utils\shexport" -s -hwfile -swfile

What flags do I pass to shexport to specify a delimiter to use?

My CVS files are being exported without a delimiter which makes importing into SQL very complicated.

[Justin]

Hi Epolerecky

What you need to do is use the standard line of

shexport -s -delimiter , -hwfile -swfile

if you use the , after -delimiter it will sort the csv file correctly and you should be able to use the sql import tool to bring the data in.

Thanks

Justin