File extension for output file in Jasper Server scheduler

JasperServer 5.6.1

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?

andyf's picture
36
Joined: Feb 7 2018 - 1:53pm
Last seen: 5 years 3 months ago

4 Answers:

joseng62's picture
6251
Joined: Dec 5 2014 - 2:43am
Last seen: 4 months 1 day ago

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"

andyf's picture
36
Joined: Feb 7 2018 - 1:53pm
Last seen: 5 years 3 months ago

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.  
https://community.jaspersoft.com/documentation/jasperreports-server-ulti...
or you might need to dump the csv file somewhere and then add the txt ext with some cusotm code. 

 

joseng62's picture
6251
Joined: Dec 5 2014 - 2:43am
Last seen: 4 months 1 day ago

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.

andyf's picture
36
Joined: Feb 7 2018 - 1:53pm
Last seen: 5 years 3 months ago
Feedback
randomness