piPointList.InterpolatedValues Powershell export to csv, per column the values of the PIPoint

I've changed the loop to this and used a Hash tables or Dictionaries. But now I only have the timestamps as a result, because I use $output.Timestamp, but I've no clue to add the values of the PIPoints here without getting these kind of values in the CSV; "System.Object[]" and "OSIsoft.AF.Asset.AFValues"

$resultsMap = @{}

try
{
 [Collections.Generic.IEnumerable[OSIsoft.AF.Asset.AFValues]] $listResults = $piPointList.InterpolatedValues($timeRange, $timeSpan, "",$true, $config) 
 
 $i=0
 foreach ($pointResult in $listResults) {
 if ($i -eq 0) {
 $resultsMap.add("Timestamp", $pointresult.Timestamp)
 $i++
 }
 else {
 $resultsMap.add($i, $pointresult)
 $i++
 }
 }

 
}

catch 
{
 Write-Host $_
}
 

$output = @()
$output += New-Object PSObject -Property $resultsMap
$output.Timestamp | Select-object localtime | Export-Csv -Delimiter ";" -Path $myDestinationForData -NoTypeInformation

I've changed the loop to this and used a Hash tables or Dictionaries. But now I only have the timestamps as a result, because I use $output.Timestamp, but I've no clue to add the values of the PIPoints here without getting these kind of values in the CSV; "System.Object[]" and "OSIsoft.AF.Asset.AFValues"

$resultsMap = @{}

try
{
 [Collections.Generic.IEnumerable[OSIsoft.AF.Asset.AFValues]] $listResults = $piPointList.InterpolatedValues($timeRange, $timeSpan, "",$true, $config) 
 
 $i=0
 foreach ($pointResult in $listResults) {
 if ($i -eq 0) {
 $resultsMap.add("Timestamp", $pointresult.Timestamp)
 $i++
 }
 else {
 $resultsMap.add($i, $pointresult)
 $i++
 }
 }

 
}

catch 
{
 Write-Host $_
}
 

$output = @()
$output += New-Object PSObject -Property $resultsMap
$output.Timestamp | Select-object localtime | Export-Csv -Delimiter ";" -Path $myDestinationForData -NoTypeInformation

You are getting closer.  While your performance issue is entirely with PowerShell and not AF SDK, let's take a step back to examine things in AF SDK that can help.

The order of tags in a PIPointList can be fairly well determined. If you wanted to have a tight control over the specific ordering, I would recommend a case-insensitive Dictionary keyed by String with a value of PIPoint.  The String key would be the case-insensitive tag name.  I know how to do this in C# but not too well with PowerShell.

An InterpolatedValues call may return collections of AFValues in a certain order, but there are 2 things we know.  One, for enumeration of the result, the entire AFValues list for that enumeration will only apply to one specific PIPoint.  And two, since it's interpolated values over a range, then each AFValues list will have matching timestamps at their respective index within the AFValues list.

So rather than a dictionary keyed by string, you may need 2 dictionaries.  The first would be of your output order of tag, or specifically the case-insensitive dictionary keyed by the Tag Name, with the value being the PIPoint.  The next dictionary would be a transformation of the results from InterpolatedValues, and it would be keyed by PIPoint with the value being the AFValues list.  

You might be able to not have the 2nd dictionary, and instead have a specific array or list of AFValues, where a given index of the list refers to a specific PIPoint.  What you would need to tie together in your code is how to populate the list of AFValues so that the given index refers to the correct tag.  Another nice property to understand is that you could check the first value in the AFValues collection to grab the .PIPoint property, and therefore its name.

And all of this jumping through hoops is because you may want a specific order, and all of this is also the reason for the degraded performance.  If you would be happier just to know you've dumped all the data, but maybe "Tag 2" comes before "Tag 1", you wouldn't need dictionaries but would need the array or list of AFValues as mentioned in the immediately preceding paragraph.

Hi Ralph, from the code you have shared it seems as though you are not accessing the value for this PI Point. To do so you would need to call $pointresult.Value which contains the actual value for this point. You may find this link of use for this issue. Moreover, you might want to consider using a dictionary with a key being the PI Point such as:

Dictionary<PIPoint, AFValues> resultsMap = new Dictionary<PIPoint, AFValues>();
IEnumerable<AFValues> listResults = piPoints.RecordedValues(timeRange, AFBoundaryType.Inside, null, false, config);
EventsRead = 0;
foreach (AFValues pointResults in listResults)
{ 
resultsMap[pointResults.PIPoint] = pointResults; 
EventsRead += pointResults.Count();
}

This being said, you may also want to have a look at the following link for further insight on how to use listdatamethods.