Hello,
i´m trying to create an automated csv report from our database but with „;“ as delimiter.
I´ve been able to set the right option in the JSON format aready { "delimiter":";"} but even if i select .csv as the default report format the output from art is exported as a .txt file – so the file itself is fine but the extension is not.
Is there anything else is need to add in the options or is there another way to get the output as a .csv file?
Thanks for your assistance
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've just seen that the File report format is something else and won't give delimited output so for now you there's no way to do what you've described.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
i´m trying to create an automated csv report from our database but with „;“ as delimiter.
I´ve been able to set the right option in the JSON format aready { "delimiter":";"} but even if i select .csv as the default report format the output from art is exported as a .txt file – so the file itself is fine but the extension is not.
Is there anything else is need to add in the options or is there another way to get the output as a .csv file?
Thanks for your assistance
Use the File report format and then in the options, add "extension": "csv"
I've just seen that the File report format is something else and won't give delimited output so for now you there's no way to do what you've described.
The just released 4.18 version should default to .csv file name in your case.