Export data without Reporting module (out of date)

Ignition
1

System is running 7.8.5 , Can't buy license for reporting module because its out of date.

Have the transaction module pulling 3 points of data + timestamp every 15 minutes.

I need to pull this out to a excel, csv or something. ideally would like to script it to run once a day and save to a folder.

But more urgently I just need it to run once showing data from the 1st to 15th of this month for an audit from the water district.

I was thinking about creating a table, running a query to populate it, and a button to save to excel or csv.

But the date range seems a little tricky on the user side.

2

For a one-off, yes.

Use a date range selector component. Use expression bindings to adjust its output start and end dates to precisely the desired break points, then feed those into your query. Use a script instead of a binding for the data to the table.

1 Like
3

This was my initial thought. But it seems to clunky to use to adjust dates.

I ended up using a text field and passing it into the query. Seems "easier" and for a one enough shouldn't be a big deal.