Hello, does anybody know hoe to Import data from excel to DB in Ignition 7.9.16. Basically I am trying to bulk upload the recipes. Regards, Narayan

Which DB? Some like MySQL, in WorkBench, you can just click a button and import. Think it’s CSV though not XLSX. In 7.9 you will have to do some heavy scripting or use the module from Kymera systems… office module.

Yes, I want to upload the data in MySQL or MSSQL .

Well, choose one and let us know. The method will be different. MySQL: Save XLSX as CSV. Go into WorkBench and import to table. Don’t even need Ignition. Is this for initial setup only or for regular adding new recipes? If the latter, script it. Parse the CSV with Jython.

Well mostly it will be MySQL, Uploading would be mostly one time and obviously doing it from work bench is simpler but in future operator may need to upload the second set of bulk recipes and just click on button on ignition, then we must fetch the file from location ( location can be hard coded) a…

OK. So script it. Same script can insert to MySql or MS SQL with slight syntax change.

This is where i need help, do you know any example of such scripting ?

[image] Python script optomisation Ignition So seems to be that this line; multiRowPrepUpdate is the cause. Running it in the script console, or on a gateway event, won’t write anything to the db. It will on an action performed button in a client for some reason. I could…

[image] Importing a CSV file into a dataset, filter it by date, then into a postgresql database Ignition Actually this was intriguing so I poked around and will share my results. I created a csv file with the following data: date,pressure,temp 2018-01-01 12:00:00,10,70 20…

Thank you, I will give it a try :slight_smile:

[image] Matrix_Engineering: Go into WorkBench and import to table You can do this in any DB I've used fwiw. Open csv in Excel, copy rows, paste into DB table

Data upload from excel to Database

Ignition

Matrix_Engineering January 5, 2021, 10:41am 8