ApplyRecipeColumnPLCopen motion icon

FunctionClosedA function calculates a result according to the current value of its inputs. A function has no internal data and is not linked to declared instances. - Apply the values of a column from a recipe file

Inputs

FILE : STRING    Path name of the recipe file (.RCP or .CSV) - must be a constant value!
COL : DINT       Index of the column in the recipe (0 based)

 

@COLNAME=Col3 Col4

@SIZECOL1=100

@SIZECOL2=100

@SIZECOL3=100

@SIZECOL4=100

bCommand

tPerio

bFast

Blink1

test_var

bOut

@EXPANDED=Blink1

 

Example of CSV file with five variables and five set of values

comment lines here

TravelSpeed;100;200;300;400;500

MasterAbsPos;0;45;90;135;180

MasterDeltaPos;0;90;180;270;360

MachineSpeed;50;100;150;200;250

MachineState;0;0;1;1;2


  • For your CSV file to be valid, ensure the data are separated with semicolons (and not commas).

Usage in a FFLD program where column 3 is selected

Column 3 corresponds to column E in the Excel sheet because this parameter is 0 based

Result displayed in the Dictionary when the application is running

 

Outputs

OK : BOOL        TRUE if OK - FALSE if parameters are invalid

Remarks

  • The 'FILE' input is a constant string expression specifying the path name of a valid .RCP or .CSV file. If no path is specified, the file is assumed to be located in the project folder. RCP files are created using an external recipe editor. CSV files can be created using EXCEL or NOTEPAD.
  • In CSV files, the first line must contain column headers, and is ignored during compiling. There is one variable per line. The first column contains the symbol of the variable. Other columns are values.
  • If a cell is empty, it is assumed to be the same value as the previous (left side) cell. If it is the first cell of a row, it is assumed to be null (0 or FALSE or empty string).
  • In FFLD language, the operation is executed only if the input rung (EN) is TRUE. The output rung is the result of the function.

  • Recipe files are read at compiling time and are embedded into the downloaded application code. This implies that a modification performed in the recipe file after downloading is not taken into account by the application.

ST Language 

OK := ApplyRecipeColumn ('MyFile.rcp', COL);

FBD Language

FFLD Language

(* The function is executed only if ApplyRecipe is TRUE *)

IL Language 

Op1: LDClosed"Ladder diagram"
Ladder logic is a method of drawing electrical logic schematics. It is now a very popular graphical language for programming Programmable Logic Controllers (PLCs). It was originally invented to describe logic made from relays. The name is based on the observation that programs in this language resemble ladders, with two vertical "rails" and a series of horizontal "rungs" between them               
'MyFile.rcp'
ApplyRecipeColumn COL
STClosed"Structured text"
A high-level language that is block structured and syntactically resembles Pascal               
OK