Could not compute value for ComputedIndexField: sizerange for indexable

If during indexing you can find the following exception in Crawling.log:

It means that probably some of your media items have a wrong values

Now, you have a difficult choice to make

If you chose to manually solve the problem, you can finish reading here.

Below you can find a ugly Powershell script that will do job automatically and generate at the end report about changes.

      
        #
      
        # Fix value '123 x 123' in Size field to the proper image size (bytes).
      
        # Author: Robert Senktas
      
        #
      
        $sitecorePath = "master:/sitecore/media library"
      
        $processedItems = Get-ChildItem -Path $sitecorePath -Recurse | ForEach-Object {
      
            if ( $_.Size -match "x" ) {
      
                $mediaItem = New-Object "Sitecore.Data.Items.MediaItem" $_
      
                [Sitecore.Resources.Media.Media] $media = [Sitecore.Resources.Media.MediaManager]::GetMedia($mediaItem);
      
                $stream = $media.GetStream()
      
                $reportItem = [PSCustomObject]@{
      
                    ID     = $_.ID
      
                    Path   = $_.Paths.Path
      
                    Size   = $_.Size
      
                    Length = $stream.Length
      
                }
      
                $_.Editing.BeginEdit()
      
                $_["Size"] = $stream.Length
      
                $_.Editing.EndEdit()
      
                $_ | Publish-Item -PublishMode SingleItem -Verbose
      
                return $reportItem
      
            }
      
        } 
      
        # Generate a report
      
        Import-Function -Name ConvertTo-Xlsx
      
        [byte[]]$outobject = $processedItems | 
      
        Select-Object -Property ID, Path, Size, Length | 
      
        ConvertTo-Xlsx 
      
        Out-Download -Name "report-change-image-size-.xlsx" -InputObject $outobject

view raw fix-size-field-in-media-items.ps hosted with ❤ by GitHub

Below the report.

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Google account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Podziel się:

Like this:

Related

Leave a Reply Cancel reply