FT View SE VBA

Neal Wallace

Member
Join Date
Apr 2021
Location
Gadsden, AL
Posts
1
I have a project to integrate some recipes between 8 production lines.

Each system is currently an island to each production line and each having its own FT View SE Distributed Server and Clients on each line. Each line currently using the built-in recipe tool to handle about 140 different recipes.

The systems are currently using some VBA to move daily data logs to a location on a network drive / Storage.

Up to now the products only run on a specific line but operations wants to have the ability to run all products on all lines which is no problem except for the recipes.

The request is to somehow use the FT View SE VBA and a SQL database to be able to have the recipes in SQL and use them for every FT View SE system but not sure if this is possible.

The built-in recipe+ systems appear to only import and export.csv files?

Any ideas on how to integrate recipe+ with SQL or if there is anything built-in or an easier way to do this?
 
Never used FTV for SQL recipe handling but I'm sure it is possible, however, it depends on the VBA & the plugins, I have used it in other Scada systems & it is really robust, the system I did would fetch 2,500 words of information into 2500 registers, so was quite a large recipe, at that time there were in the region of 160 recipes stored on the DB, the slowest thing was the population of the registers over the network probably about 3 seconds but that is still pretty fast. Assuming the Database is on a server where all HMI's can access it & the VBA has the ability to connect using SQL queries then it should be pretty simple.
I used a data source name on the Scada so that it could be quickly changed as our IT Dept. would change servers probably every 12 months (probably for upgrades, so they would migrate the DB's to another server on occasions.
 

Similar Topics

I'm creating an HMI that has a recipe with 288 data point. It has 3 pieces of data for 96 segments. I need help with VBA code to copy all 288...
Replies
0
Views
140
Hi all. Currently I'm working on a VBa script for FTView. I would like to understand a bit better about some commands. 1) What are the...
Replies
3
Views
595
Hi all. I'm running a VBA code on my FTView which is actually working, but everytime I open the display that calls the VBA code, it throws the...
Replies
28
Views
1,803
Greetings, I have this question: How can I add a tag, in my case LS:0 {#5} (literal string of tag #5), to a variable using VBA? I couldn't find...
Replies
4
Views
894
Hi I hope all are doing good I have some doubt on FTV VBA coding for Drop down list. I wanted to know how to build a VBA code for Drop down list...
Replies
3
Views
998
Back
Top Bottom