Planer Run
Reads piece by piece planer data from a table, determines the runs and inserts the runs into a table. This will only insert run info, not data. The data will have to be inserted via stored procedure after this program has run.
| Parameter | Description |
|---|---|
| ReadTimestampColumn | The name of the column that contains timestamp in the read table. |
| ReadThicknessColumn | The name of the column that contains thickness in the read table. |
| ReadWidthColumn | The name of the column that contains width in the read table. |
| ReadLengthColumn | The name of the column that contains length in the read table. |
| ReadTable | The name of the table DGS will be reading piece by piece data from. |
| ReadFilter | SQL where statement used to filter data in the read table (Example: “Sorternumber = 1 AND Destination = 1”). |
| RunRows | Row threshold for runs, for example if RunRows is 25 and we get 25 2x6x16 in a row it will be considered a new run. |
| WriteTable | The name of the table to write the runs to. |
| WriteThicknessColumn | The name of the column that contains thickness in the write table. |
| WriteWidthColumn | The name of the column that contains width in the write table. |
| WriteLengthColumn | The name of the column that contains length in the write table. |
| WriteRunStartColumn | The name of the column that contains the run start time in the write table. |
| WriteRunEndColumn | The name of the column that contains the run end time in the write table. |