# Automated CSV file generation **URL:** \ **Category:** Kibana\ **Created:** [May 31, 2019, 3:05pm UTC](https://discuss.elastic.co/t/automated-csv-file-generation/183752 "2019-05-31T15:05:12Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![vipul12](https://avatars.discourse-cdn.com/v4/letter/v/f05b48/32.png) [@vipul12](https://discuss.elastic.co/u/vipul12)\ **Post date:** [May 31, 2019, 3:05pm UTC](https://discuss.elastic.co/t/automated-csv-file-generation/183752/1 "2019-05-31T15:05:13Z")
Does Kibana have a scheduler to automatically export CSV and transfer the file to another path or is there a way to automate this backend, I checked the old post, but it mentions about pdf report genaration. But I want a CSV file from saved search to be sent to a server. this is what i checked:[https://www.elastic.co/guide/en/kibana/current/automating-report-generation.html](https://www.elastic.co/guide/en/kibana/current/automating-report-generation.html) but i need csv file ---
**Author:** ![cjcenizal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cjcenizal/32/11216_2.png) [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)\ **Post date:** [May 31, 2019, 6:17pm UTC](https://discuss.elastic.co/t/automated-csv-file-generation/183752/2 "2019-05-31T18:17:15Z")
Hi there, you should be able to follow the instructions in the link you found to get the CSV report from the saved search. Just use the "Copy POST URL" button to get the URL you need to hit to generate the report. ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/a/0a55f2b49c3e0b34883f42a62ba692e9fc6942b6.png) ---
**Author:** ![vipul12](https://avatars.discourse-cdn.com/v4/letter/v/f05b48/32.png) [@vipul12](https://discuss.elastic.co/u/vipul12)\ **Post date:** [June 1, 2019, 7:52am UTC](https://discuss.elastic.co/t/automated-csv-file-generation/183752/3 "2019-06-01T07:52:24Z")
HI CJ, Thank you for reply. Which version of KIbana, you took screenshot from? I do not have this same option of "COPY POST URL". Also , in my version i know how to generate CSV , and I am doing it as well for my use case. But I need to automate generation of CSV and put it on a server from where it can be picked up for my separate tool. Regards. ---
**Author:** ![cjcenizal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cjcenizal/32/11216_2.png) [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)\ **Post date:** [June 3, 2019, 11:09pm UTC](https://discuss.elastic.co/t/automated-csv-file-generation/183752/4 "2019-06-03T23:09:50Z")
I took my screenshot in Kibana 7.1. I'm not sure when it was introduced, but here's what the equivalent functionality looks like in 6.0.0 UI: ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/9/c98e90609388ec6f55d842768f3a4af9e1184ea5.png) Does this help? ---
**Author:** ![vipul12](https://avatars.discourse-cdn.com/v4/letter/v/f05b48/32.png) [@vipul12](https://discuss.elastic.co/u/vipul12)\ **Post date:** [June 5, 2019, 10:34am UTC](https://discuss.elastic.co/t/automated-csv-file-generation/183752/5 "2019-06-05T10:34:57Z")
Hello CJ, yes it seem we are on 6.0 UI. and This is the same way I am generating my CSV file till now. Now my ask is ,1. we have this url generated, how to use this url to change the date automatically to fetch new data each day ? 2. how to place this CSV file to a ftp location on a server ? Regards, Vipul ---
**Author:** ![cjcenizal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cjcenizal/32/11216_2.png) [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)\ **Post date:** [June 5, 2019, 1:46pm UTC](https://discuss.elastic.co/t/automated-csv-file-generation/183752/6 "2019-06-05T13:46:31Z")
Hi there, you can't use that URL to programmatically change the date of the Saved Search you're trying to visualize. However, you can set the date range of the Saved Search to be "Relative" instead of "Absolute", so that it visualizes data from the past 24 hours. This way, when you generate the report each day, you will get just that day's data. In terms of uploading the CSV file to a server, that's something you'll have to implement on your own within the language and tools you're using to build your system. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 3, 2019, 1:46pm UTC](https://discuss.elastic.co/t/automated-csv-file-generation/183752/7 "2019-07-03T13:46:33Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.