# Export Sqlite data to CSV file
**URL:** https://discourse.nodered.org/t/export-sqlite-data-to-csv-file/12688
**Category:** General
**Created:** [28 June 2019 13:29 UTC](https://discourse.nodered.org/t/export-sqlite-data-to-csv-file/12688 "2019-06-28T13:29:49Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Rapidsafeguard](https://discourse.nodered.org/u/Rapidsafeguard)
#### Post date: [28 June 2019 13:29 UTC](https://discourse.nodered.org/t/export-sqlite-data-to-csv-file/12688/1 "2019-06-28T13:29:49Z")
I am working on export report in csv file from sqlite database. I have used CSV node and It is working fine but when I debug file node it gives empty result. I am little bit stuck.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [28 June 2019 13:43 UTC](https://discourse.nodered.org/t/export-sqlite-data-to-csv-file/12688/2 "2019-06-28T13:43:40Z")
What do you mean, when you debug file node?
---
### Author:  [@Rapidsafeguard](https://discourse.nodered.org/u/Rapidsafeguard)
#### Post date: [28 June 2019 13:44 UTC](https://discourse.nodered.org/t/export-sqlite-data-to-csv-file/12688/3 "2019-06-28T13:44:40Z")
It is CSV node output. I can share flow.
`[{"id":"8c6db192.7e7d","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"d0e8783f.d2d828","type":"ui_button","z":"8c6db192.7e7d","name":"","group":"89ea92be.2a899","order":2,"width":0,"height":0,"passthru":false,"label":"Report Download","tooltip":"","color":"","bgcolor":"","icon":"","payload":"","payloadType":"str","topic":"select * from sensor_aggr","x":150,"y":380,"wires":[["c889c718.cf1b98"]]},{"id":"942a4fd1.b978f","type":"file in","z":"8c6db192.7e7d","name":"Report generate","filename":"C:\\Users\\Enerzon Automations\\.node-red\\Report.csv","format":"lines","chunk":false,"sendError":true,"encoding":"none","x":760,"y":340,"wires":[[]]},{"id":"c889c718.cf1b98","type":"sqlite","z":"8c6db192.7e7d","mydb":"9dd4ecf7.ee476","sqlquery":"msg.topic","sql":"","name":"DB","x":330,"y":380,"wires":[["374aff.6853e502"]]},{"id":"b78af7d6.9b17f8","type":"debug","z":"8c6db192.7e7d","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","x":750,"y":400,"wires":[]},{"id":"374aff.6853e502","type":"csv","z":"8c6db192.7e7d","name":"","sep":",","hdrin":"","hdrout":false,"multi":"one","ret":"\\n","temp":"epoch,device,sensor,value","skip":"0","x":510,"y":380,"wires":[["942a4fd1.b978f","b78af7d6.9b17f8"]]},{"id":"89ea92be.2a899","type":"ui_group","z":"","name":"SensorData","tab":"d78a1ced.899ba","order":2,"disp":true,"width":"6","collapse":false},{"id":"9dd4ecf7.ee476","type":"sqlitedb","z":"","db":"C:\\Users\\Enerzon Automations\\EnerzonDB.db","mode":"RWC"},{"id":"d78a1ced.899ba","type":"ui_tab","z":"","name":"Dashboard","icon":"dashboard","order":1}]`
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [28 June 2019 14:24 UTC](https://discourse.nodered.org/t/export-sqlite-data-to-csv-file/12688/4 "2019-06-28T14:24:02Z")
So what is not working?
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [28 June 2019 14:29 UTC](https://discourse.nodered.org/t/export-sqlite-data-to-csv-file/12688/5 "2019-06-28T14:29:24Z")
Do you realise that you have used a File In node, which reads a file. What exactly are you trying to do?
---
### Author:  [@Rapidsafeguard](https://discourse.nodered.org/u/Rapidsafeguard)
#### Post date: [28 June 2019 15:03 UTC](https://discourse.nodered.org/t/export-sqlite-data-to-csv-file/12688/6 "2019-06-28T15:03:27Z")
Damn! It was my blunder. I forgot to see in hurry. I haven't seen read and write node. Thanks man you are rock.