Chris Posted July 10, 2020 Share Posted July 10, 2020 Hello, Is it possible to export directly in CSV? (script?) I need to export a large amount of value and with Excel I reach the row limit. Thanks Christophe Link to comment Share on other sites More sharing options...
Thorsten Vogt Posted July 10, 2020 Share Posted July 10, 2020 Hi Chris, you can try to use the OData Export and some scripting in Powershell to export to CSV. Copy the "OData Sample Table Endpoint" and insert into the script below to export signal values: $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 1 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now