I have created a report that needs to run daily in CSV format and email into our parent company's automated system. The report works perfectly, and I can schedule it as required, but the automated system I am sending it to requires the output file to have a ".txt" extension, not a ".csv" extension. I have tried including ".txt" in the file name in the scheduler's output options, but the resulting csv output file is then "<filename>.txt.csv". This will not work and I have to solve it. how can I do this?
Have you tried the following ?
Yes I have seen and tried that link, but it has no effect on the scheduler, and would not work anyway becasue it delivers the data in plain text not csv. - I need the content of the data file to be csv, but the extension of the created file must be ".txt"
Seems like you going to have add some custom code. Don't think there is a easier way that you going to achieve your desired results.
So maybe have a look if the below link might asssit.
or you might need to dump the csv file somewhere and then add the txt ext with some cusotm code.
Thanks. That looks like a good solution, but we have no Java programmer resource here. We will forget about using Jasper for this, and build the required function using a different application.