# ControlLogix --\> SQL & CSV

**URL:** <https://discourse.nodered.org/t/controllogix-sql-csv/86766>\
**Category:** Industrial\
**Created:** [26 March 2024 12:39 UTC](https://discourse.nodered.org/t/controllogix-sql-csv/86766 "2024-03-26T12:39:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lcbateman3](https://avatars.discourse-cdn.com/v4/letter/l/f1d935/32.png) [@lcbateman3](https://discourse.nodered.org/u/lcbateman3)\
**Post date:** [26 March 2024 12:39 UTC](https://discourse.nodered.org/t/controllogix-sql-csv/86766/1 "2024-03-26T12:39:57Z")

</div>

Hello everyone.

Have a system that I wrote many years ago in Excel & VBA using DDE Links. Want to move away from that as its clunky and getting outdated. Need to add some new tags so this is as good of a time as ever.

I have an ControlLogix (L71) processor. I need to read an array (100,30). Currently, this is done in an excel spreadsheet with each row and column mapped to the actual data point.

I'd like to go to a mySQL or some other type DB. I can make a front end that reads from that for the user interaction.

The second part is there is a trigger on the PLC to print a ticket. This is the updated item that comes from the PLC. I need to take this data (from the 99th part of the array and it's elements) and create an CSV file.

From what I have read on Node-RED I think I can do all of this. Just want to confirm before heading down this route.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [7 April 2024 09:54 UTC](https://discourse.nodered.org/t/controllogix-sql-csv/86766/2 "2024-04-07T09:54:18Z")

</div>

> [@lcbateman3](#):
>
> ControlLogix

there are nodes for reading AB PLCS

> [@lcbateman3](#):
>
> I'd like to go to a mySQL or some other type DB

There are lots of DB nodes avaiable. MySQL, MSSQL, SQLite, and many many more. I would suggest starting with SQLite as it requires very little to get up and running. The simply migrate to mySQL (or other) once you get the gist of things.

> [@lcbateman3](#):
>
> The second part is there is a trigger on the PLC to print a ticket. This is the updated item that comes from the PLC. I need to take this data (from the 99th part of the array and it's elements) and create an CSV file.

You will likely have to poll the address that signals "print a ticket" (I am not overly familiar with AB nodes)

Creating a CSV file is child's play.

> [@lcbateman3](#):
>
> From what I have read on Node-RED I think I can do all of this. Just want to confirm before heading down this route.

I do not see anything in your requirements that Node-RED cannot handle.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [6 June 2024 09:55 UTC](https://discourse.nodered.org/t/controllogix-sql-csv/86766/3 "2024-06-06T09:55:13Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.