Data Logging and Display • Creating Batch History • Configuring a Default Database for All Task History Creating Batch History IWS provides powerful tools that enable the user to create and manage batch historical information. The user is able to create batches by using the following formats: • Proprietary : When using the proprietary format, each batch will be stored on a different historical file. The user can save historical data in both the normal historical file and batch files at the same time (see Trend Folder for more information about these files). • Database :
The historical data used for the batch is saved in the same table as the normal historical data; an additional table called BatchHistory keeps registers with the information about the batches. The list below describes the fields on the BatchHistory table: Tip: You can customize the name of the table and the name of the columns created in the database by editing the project_name .APP file, as follows: [Trend] DefaultName = NewName [Trend GroupPRI|SEC ] BatchHistory= TableName For example:
[TREND001PRI] BatchHistory=MyTableForPrimaryDB [TREND001SEC] BatchHistory=MyTableForSecondaryDB [Trend] Group_Number=Trend_Worksheet Batch_Name=Load_Number InduSoft Web Studio Page 239 Field Name Data Type Description Group Number _ Integer Trend group number. This is the number of the worksheet that you are creating to specify the tags that will be stored on your batch history. Batch Name _ String Name of the batch Start Time _ TimeStamp Date and Time that the batch was started. End Time _ TimeStamp Date and Time that the batch was finished Pri Table _ String Reserved Sec Table _ String Reserved Description String Batch description Deleted Boolean 0: Batch has not been deleted 1:
Batch has been deleted