Jump to content

Export in CSV file


Chris

Recommended Posts

Hi Chris,

you can try to use the OData Export and some scripting in Powershell to export to CSV.

image.thumb.png.f7dd967eb0817b0592fbae1d7f2c9f1c.png

Copy the "OData Sample Table Endpoint" and insert into the script below to export signal values:
 

image.png.e7f5a4cfedc29dd6f738c6635d03be2b.png

$credentials = Get-Credential

$result =Invoke-RestMethod http://seeqserver:34216/odata.svc/Analysis_36_Export_1_7C86D848_7A39_4B5B_BB67_FA66A18CF6E4_DataSet -Credential $credentials

$result |  ForEach-Object { 
$properties = $_.content.properties
[PSCustomObject]@{
Timestamp = $properties.timestamp
Temperature = $properties.Cooling_Tower_1ǀExampleǀArea_AǀTemperature
RH = $properties.Cooling_Tower_1ǀExampleǀArea_AǀRelative_Humidity
}
} | Export-Csv C:\Temp\data.csv -NoTypeInformation

Another way would be using the API / SDK (https://support.seeq.com/space/KB/117027248/Seeq%20APIs%20and%20SDKs) or Seeq Data Lab, if you have a license for this.

Regards,

Thorsten

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...