Use Case

On many occasions for site reporting to data comparison as well as others, it is important to be able to export a set of tags from all turbines in a site. Bazefield's filter allows for easy bulk additions of tags to the data export list to achieve this goal.


Background

The data export application in the analysis tab has a user manual in the User section of the portal documentation called Data Extraction. This walks through a quick example based on a common use case. There is also an excel plugin that may be useful. Additionally if you are doing repeated analysis in a 3rd part tool, it is probably appropriate to use the API via script or program.


Steps

Step 1: Locate the Data Export application, ensure filter is open


Step 2: Filter for Site & Asset Type that you wish to load tags from




Step 3: Add Tags


Step 3 a: Select Asset Tags check box, Search for the desired tag


TIP: There are a couple of ways to retrieve the data you want. For example, if you wanted 10 minute average values, you could utilize the 10 minute tag itself that stored that 10 minute record, or you could use the real time tag, and perform a 10 minute average "on the fly" when you export the data.




Step 3 b: Add the next tag


For this example, we will have wind speed and active power together group by asset on the export. However we are adding the tags one after the other for illustration.





Step 4: Setup Data Export Parameters

NB! Review data export time zone article for understanding whether to use the UTC switch to leave.


These properties are going to export a "on the fly" 10 minute average in a specified date format that is friendly with excel. We're picking the "last 7 days" time frame for 75 turbines. It took 2 minutes to download the file. For data exports that may span long time frames, such as a year, it is best practice to break this up into ~ 2 month segments. Obviously it depends on how many tags you're attempting to export.


NB! "CSV" file in this case use's semi-colons ';' to separate data, this is a good catch all for mixed data cultured product where commas and decimals are different between countries. 


Step 5: Open in Excel (Tips)