How do I pull data at 1 minute interval using piconfig?

I have a request to pull all data for a number of tags at 1 minute interval. This is 13 years of data. I gather that I will have to break this up into chunks of 4-5months at a time. I think I can live with this.

I have played with piconfig and a powershell script I found in another post. I have everything figured out except the 1 minute part. I can do this with Datalink, but Excel doesn't have nearly enough capacity for this much data.

 

Is there a way to do this 1m interval using piconfig or powershell?

 

Also, I'm open to ideas on how to get as much data as possible at a go so I can do with less effort.

Parents
  • Hello ​ ,

    there is usually multiple ways of doing things plus options to tweak a solution to specific requirements like writing the output to a file instead of showing it at the prompt. We support custom application development but expect customers to assume ownership and to create, maintain and support their custom applications. Custom applications can easily become very complex and for this reason we cannot support them. You may understand that we avoid offering ready-to-use code samples.

    Please consider finding a developer in your organization who understands the samples, maybe when consulting with the AF SDK Reference, and who is able to adjust the samples to meet with your businesses requirements.

    If you for your purposes you could remove lines 32 and 33 and add the following:

    foreach ($AFValue in $AFValues)
    {
        if ($AFValue.IsGood) 
        {
            Write-host $AFValue.Value "; " $AFValue.Timestamp
        }
    }

     

Reply
  • Hello ​ ,

    there is usually multiple ways of doing things plus options to tweak a solution to specific requirements like writing the output to a file instead of showing it at the prompt. We support custom application development but expect customers to assume ownership and to create, maintain and support their custom applications. Custom applications can easily become very complex and for this reason we cannot support them. You may understand that we avoid offering ready-to-use code samples.

    Please consider finding a developer in your organization who understands the samples, maybe when consulting with the AF SDK Reference, and who is able to adjust the samples to meet with your businesses requirements.

    If you for your purposes you could remove lines 32 and 33 and add the following:

    foreach ($AFValue in $AFValues)
    {
        if ($AFValue.IsGood) 
        {
            Write-host $AFValue.Value "; " $AFValue.Timestamp
        }
    }

     

Children
No Data