earth_america
user_standard Log on
action_search_stroke
earth_america
Log on to rate and give feedback 1 2 3 4 5 Log on to rate
0
How to

How to


Products: WebStation
Functionalities: Basic Functionality
12/3/2024

Exporting a Search to Excel

You can export a search result as an Excel file.

Show More
action_close

Use Search to find and view objects in the EcoStruxure BMS database.

Different Searches

There are two different ways to search in WebStation:

  • The Search function searches for all object names and property names in the system.

  • A saved search is a predefined search that searches specific criteria in a specific part of the system. Saved searches are created in WorkStation and the search criteria cannot be changed in WebStation.

Search is case insensitive, which means that Search does not distinguish between uppercase and lowercase letters. A search for "Fan" results with hits for both "fan" and "Fan".

Wildcards

Use wildcards to substitute characters or combinations of characters in a search.

Search supports two main wildcards:

  • Asterisk (*) represents any combination of characters including white space.

  • Question mark (?) represents any single character.

For example, you want to find all objects and properties containing the word “Temperature”. You start the search with an asterisk so that the search includes all hits on objects like “Outside Air Temperature” where the asterisk represents the words before "Temperature", in this case “Outside Air”. You also have to end the search text with an asterisk to include objects like “Temperature Alarm” where the asterisk represents the word after "Temperature", in this case “Alarm”.

Local or Global Searches

You can search in your whole EcoStruxure BMS or only in a folder, device, or server:

  • To search your whole system, select the top server and then perform the search. You can also click the Search whole server button in the list.

  • To search a specific folder, select the folder and then perform the search.

Tip:

When you perform a search, you cannot leave the Search box empty. To perform a search, you have to enter something in the Search box.

Export a search

You can export a search result as an Excel file.

Multi-edit in the search list view

You can multi-edit several objects in the search result list at the same time. This saves a lot of time compared to editing the objects one by one.

For more information, see Multi-editing in Search .

To export a search to Excel

  1. In WebStation, in the System tree , select the folder, server, or device you want to search in.

  2. Click the magnifier.

  3. In the Search box, type the text you want to search for.

  4. Press Enter .

  5. Í the toolbar, click the Export to Excel button

     
    action_zoom_plus_stroke
    .

  6. Save the Excel file.

See Also

  • Search in WebStation
  • Searching in WebStation
  • Search Toolbar
  • Searching Using a Saved Search