In my search on this forum I found one relevant one that shed a bit of lite on what I need, it’s: New to SQL.
Around Christmas I downloaded MySQL. Lately I’ve been trying to create a first database.
I know that this is Inductive Automation forum and the product I work with is Ignition. Probably I should seek more help on their forum…
From “New to SQL” I found out that I also needed to download “Workbench”. I found some tips in the help. I got to say that it’s rather well done.
Also in Travis’ Webinars he often work with existing databases, the best example is the one that lists clients. He often uses it, makes modifications etc.
Now I created a database for the “STATION #1”. Production status will be stored there. The employees ID who worked there, the product being assembled, time to complete an assembly and time stamps.
I added two examples made ruffly in Excel. The first one is for a list of employees which is rather simple. The second one is quite similar to what we have already. From these two databases I can easily make tags for most of the projects. It would be easy to take a drop down text box to select an employee and a product to associate it to a work station for an example. These informations would be stored in some N7 files in the PLC. Where it’s interesting for our factory is to be able to associate the ability of an employee to complete a task and also evaluate the whole group for a particular product. Make some statistics!!
Here are some questions:
Can new databases be created directly from an Ignition Client?
Can all the columns be created directly from an Ignition Client?
3)Is there a way to fill an entire row with lets say three or four columns (index which is automatically done, name and ID)(Index, item,client’s ID, description, box per palettes)?
I want to start only with these few questions to avoid overwhelming those who offer their help. I probably will have to answer questions and will definitely generate some.
P.S.: desp, lann, picp, turm is for the three first letter of the last name and the first of the first name. So my last name starts by DES and my first name is Patrick. Just a hint.