# Csv automatic insertion into SQL

**URL:** <https://forum.inductiveautomation.com/t/csv-automatic-insertion-into-sql/5919>\
**Category:** Ignition\
**Created:** [February 24, 2013, 12:15pm UTC](https://forum.inductiveautomation.com/t/csv-automatic-insertion-into-sql/5919 "2013-02-24T12:15:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jose.granero](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jose.granero/32/11190_2.png) [@jose.granero](https://forum.inductiveautomation.com/u/jose.granero)\
**Post date:** [February 24, 2013, 12:15pm UTC](https://forum.inductiveautomation.com/t/csv-automatic-insertion-into-sql/5919/1 "2013-02-24T12:15:33Z")

</div>

I’m currently working on a project with several dataloggers, each datalogger sends a csv file to an ftp sever everyday, the name of each file is function of the date and time it was sent, for instance TEST\_DATALOGGER1\_20130220183000, the question is, how can I automate from Ignition, the insertion of the data received everyday taking into account tha these must be saved only once in the database?

---

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [February 24, 2013, 3:10pm UTC](https://forum.inductiveautomation.com/t/csv-automatic-insertion-into-sql/5919/2 "2013-02-24T15:10:35Z")

</div>

take a look at this csv parser.

[viewtopic.php?f=25&t=7122&p=21163&hilit=csv+parser#p21163](http://www.inductiveautomation.com/forum/viewtopic.php?f=25&t=7122&p=21163&hilit=csv+parser#p21163)

Im not sure how you would know the filename unless you know the exact time the file will be generated ahead of time though. might be easier to do if you could make the datalogger only generate the date and not the time in the filename.