Questions tagged [powershell-extensions]
Anything related to the Sitecore PowerShell Extensions (SPE) module or general Windows PowerShell.
261
questions
0
votes
0answers
12 views
SPE remoting throws error 'You cannot call a method on a null-valued expression.' on calling Invoke-RemoteScript
I installed Sitecore Powershell extension 5.1 on my sitecore 9.0.2 which is in azure PaaS. The imported SPE remoting module 5.1 to my windows powershell(5.1) on my local machine.
I enabled remoting ...
0
votes
0answers
23 views
Sitecore PowerShell access allow/deny at same time
Hello Sitecore SPE Experts,
I have a very basic question, hope anyone help me:
I am using something like below
Add-ItemAcl -Path master:\content\home -AccessRight "item:read" -PropagationType Any -
...
1
vote
1answer
42 views
PowerShell script to get data from Solr and Edit in Sitecore
Is there a way that i can Query Solr to get data based on a template. Then foreach of that data do a Sitecore Getitem and Update a field's value.
0
votes
0answers
22 views
SXA Creative Exchange Import triggered via SPE not working
I was trying to set up a CI/CD according to the documentation, where I planned to trigger a Creative Exchange Import via Sitecore Powershell Extensions Web Api.
https://doc.sitecore.com/developers/...
1
vote
1answer
20 views
Sorting Decimals in Show-ListView
I'm wondering how one would sort a column of decimal or currency values numerically in show-listview?
A contrived example:
$decimalArray = 1.1, 2.2, 3.3, 10.0, 20.0, 30.0
$props = @{
Title =...
0
votes
0answers
23 views
Can we copy entire master DB from staging to Dev using sitecore Powershell?
I am curious to know any such commands or way to copy master DB from one sitecore environment to another ?
I have a clue of using Copy-Item however I don't have much idea on that.
0
votes
0answers
26 views
Powershell script runtime error when clicking navigate/export excel button in showlistview result
I am using Powershell to generate a report using show-listview but sometimes when the user clicks the excel report or navigation button in the result window it's showing a runtime error.
I have ...
3
votes
1answer
52 views
Getting an item using Powershell having only the URL
Is it possible to get a Sitecore item via Powershell script having only the public URL?
Something like an overload of the Get-Item function that receives the URL would be ideal
Thanks in advance
0
votes
1answer
24 views
SXA Missing Variants in a cloned rendering
i followed the documentation https://doc.sitecore.com/developers/sxa/93/sitecore-experience-accelerator/en/copy-and-customize-a-rendering.html and cloned a Page Content rendering. The script finished, ...
0
votes
0answers
43 views
Sitecore PowerShell 6.0 Console on Sitecore 9.3 does not work [duplicate]
I just installed Sitecore 9.3 Standalone XP locally. After rebuilding the link databases and indexes; I did install the Sitecore PowerShell 6.0 package. I could not make the PowerShell console work. ...
0
votes
0answers
22 views
How to delete specific saved Sitecore Forms entries using SPE
I'm using Sitecore 9.0.1 and using the default Save Data submit action on my form:
There are many garbage entries due to test and bot submissions, and there isn't a way to delete any of the entries.
...
0
votes
0answers
10 views
Sitecore Powersheel elevated session through Active Directory single sign-on [duplicate]
I want to run some script through sitecore powershell extension but it gives me popup to login. We have currently configured Azure AD single signon for the environment so I dont know password for the ...
1
vote
1answer
57 views
Sitecore Forms CSV export not preserving new line characters from textarea input field
I've got a <textarea> set up in a Sitecore Form in which users can enter multi line inputs:
When the value is saved to the database I notice that the breaks ARE preserved:
If I copy the value ...
0
votes
1answer
41 views
Pass Variables to SPE Script from PowerShell via Remoting
I'm having trouble passing variables from a PowerShell script into a SPE Script. I'm attempting to call the SPE script from a PowerShell file on the file system. I'm trying to pass in variables that ...
0
votes
0answers
28 views
Override SXA Site Scaffolding
I'm aware of how to add additional items to site scaffolding via inserting items into a /sitecore/templates/Foundation/Experience Accelerator/Scaffolding/Roots/SiteSetupRoot template.
I'm interested ...
1
vote
2answers
70 views
Sitecore Powershell Extension throws null-valued expression exception
On a fresh Windows VM I installed powershell extensions module:
Install-Module SPE
Then I am trying to invoke a remote script on my sitecore instance:
$url = "https://my-sitecore.azurewebsites.net"
...
0
votes
1answer
37 views
DBCleanup with Powershell
I would like to automate the DBCleanup tasks (/sitecore/admin/dbcleanup.aspx). The idea is to launch a TeamCity job that calls a powershell script to run the different cleanup jobs on the different ...
0
votes
1answer
60 views
Data Importer Module not working with PowerShell Extensions
I was trying to use the Data Importer to import a csv of data templates. I get the following error:
New-Item : The type is not a known type for the file system. Only "file","directory" or "...
0
votes
0answers
51 views
Scheduled Task running through Sitecore Powershell extensions shows as running even when it completes
We are running a Scheduled Task manually through Sitecore PowerShell Extensions. The task runs for around 2-3 hours and completes successfully. But the Script window still shows as running even though ...
0
votes
1answer
36 views
Unable to find type in Sitecore Powershell Extensions script [closed]
We're looking to use a static function from a C# class we've written in a Powershell Extensions script.
We have included our code as a dll in the bin directory of our Sitecore application, and have ...
1
vote
3answers
71 views
Updating Item media field with specific media Sitecore powershell script
I have 400 product items. Previously, we have a common thumbnail image for all products. Now, I added a new image field (thumbnail image), all products I need to assign a common specific thumbnail ...
1
vote
1answer
73 views
Get renderings data source location
How to get rendering data source location either any one of below,
Get items final layout renderings with their data source location
Get rendering data source location by specific Rendering folder ...
0
votes
0answers
58 views
Migrate some items from one database to another having same or slightly different templates
I need to migrate data from one database say migration DB to master database using powershell scripts.
I have the migration database(client's database copy) .bak file of sitecore 8.2 and have ...
1
vote
1answer
67 views
SPE Remoting: Cannot perform operation because the runspace is not in the 'Opened' state. Current state of runspace is 'Closed'
SPE: 4.5.0.0
Sitecore: 8.2u3
I designed a script to remotely publish a series of item paths. Each path is iterated across each publishing target database. The net result is 8 individual remote ...
3
votes
0answers
140 views
Get-ItemReferrer : Object reference not set to an instance of an object
I am working on Sitecore PowerShell Extensions 5.0.0.42513 with Sitecore 9.0.
I have started facing issue as Get-ItemReferrer : Object reference not set to an instance of an object
Also shown below ...
5
votes
1answer
154 views
Performance issue with Sitecore Powershell Script
I am working on SPE (Sitecore.PowerShell.Extensions-5.1) with Sitecore 9.0.1 where I have one script which creates a report of items in approved workflow state. But the execution of the script is ...
0
votes
1answer
40 views
Sitecore Powershell Extension 5.1.0.19766 - debug tooltip tiny box
Sitecore PowerShell Extensions 5.1.0.19766
Sitecore 9.1
Windows PowerShell 5.1
I want to view the Objects during a debug process by hovering over the variable, object, array, etc., but only see a ...
0
votes
0answers
88 views
Identity Server + Sitecore Powershell: Non-admin cannot see scripts
I am using Sitecore 9.1 with Identity Server configured to authenticate users against Azure Active Directory. This works great and users can login with their azure accounts without issue.
I have ...
3
votes
0answers
58 views
Get workflow history for an item by itemid in sitecore powershell extension - Sitecore 8.1
I need to create a report by Sitecore Powershell Extension where I need to include the details of "Workflow Approver" and "Date on which workflow approved".
I have got the list of referring items for ...
3
votes
1answer
63 views
Report for Approved workflow state that are created/updated in last 30 day
I have to create a report via Sitecore Powershell where I have to fetch all items in Approved workflow state that are created/updated in last 30 days. I am getting the data but seems there are ...
0
votes
1answer
31 views
Update Allowed Controls in Placeholder [closed]
I need to update "Allowed Controls" field of placeholder using Sitecore Powershell. I have used below code -
$contentPlaceholder = Get-Item -Path "master:/sitecore/layout/Placeholder Settings/main"
$...
0
votes
2answers
57 views
new-using block with remove-itemversion
While learning about Remove-ItemVersion, I came across below piece of code -
New-UsingBlock(New-Object Sitecore.Data.Events.EventDisabler) {
Remove-ItemVersion -Path master:\content\home -...
1
vote
1answer
107 views
Remove duplicate items from an array of items
I need to create an array of templates that refer to a particular rendering. In some templates, renderings are placed twice. So, array contains 2 copies of same templates.
What is the sitecore ...
3
votes
1answer
62 views
What is the SPE equivalent of “Revert Tree”?
What is the SPE equivalent of "Revert Tree"?
I've attempted the following:
$config = [Sitecore.Configuration.Factory]::GetConfiguration();
$dataFolderPath = ($config.sitecore."sc.variable" | ?{ $_....
1
vote
0answers
38 views
Pagination on Update-ListView
I have written a PowerShell script as an action to delete selected items in the list view.
The issue is - when I delete an item on any page other than the first one, after deletion, update-listview ...
2
votes
1answer
228 views
Sitecore Powershell Script to Delete All Items in Results
I need to delete all the items present in the list view on the click of the "delete all" action button.
I am running the script -
foreach($selectedItem in $allData) {
$item = Get-Item -Path ...
0
votes
1answer
92 views
Sitecore powershell script to delete selected items from results
Below is the Sitecore Powershell Script to delete selected items from Powershell script result -
foreach($Item in $selectedData)
{
if($Item -ne $null)
{
$Item | Remove-Item
}
}
...
0
votes
1answer
53 views
Fixing media items with wrong extension
There have been some suspect manipulations in our media library (for example, detaching and reattaching of images), such that we now have images in our library which are linked to the wrong template. ...
3
votes
1answer
344 views
Sitecore Powershell script to add items in array
I am a Sitecore PowerShell newbie.
I have to write a Sitecore PowerShell script to ignore certain items from consideration based on their template types.
For this we can add these items to an array ...
1
vote
3answers
221 views
Sitecore Powershell skip items in System Folder
I am a powershell newbie. I have to write a Sitecore Powershell script where I need to check all the templates for a particular value. But I need to ignore templates inside /sitecore/templates/System/ ...
6
votes
2answers
311 views
Compare items between two instances
We upgraded Sitecore 8.2 project to 9.1. Upgrade took around 1 month to finish and during this period, authors created/updated some items in old instance and they didn't make a note of those items.
...
3
votes
2answers
305 views
Find-Item -Index Get latest version
I am looking for a master index query that will return the latest version of any item. In the solr index there is a field call _latestversion. But when I add that to my query, I get the error
Find-...
1
vote
1answer
55 views
Get-RenderingParameter is not recognized as a name of a cmdlet
I'm writing a script to exchange a rendering component with a new rendering component, but it should keep all of the same rendering parameters. I followed the documentation to use Get-...
2
votes
1answer
58 views
Use Set-ItemTemplate to fix an item with a missing template
Is there way to use Set-ItemTemplate to fix an item with a broken (deleted) template?
I'm trying the following script but get a null reference error
$item = Get-Item -Path master: -Query "/sitecore/...
0
votes
1answer
73 views
Out-Download access denied to user anonymous
I have a custom SPE script that is executed from the Reporting Tools on the Sitecore start menu. The script writes a csv file to the app_data\temp directory, then calls Get-Item $filePath | Out-...
0
votes
0answers
25 views
Export/download options for custom roles is hidden in power-shell script results
I have created a custom role for some users which can access some reports. Although the users under the specified role can access and execute the reports and get result window what they lack is the ...
2
votes
0answers
71 views
Unable to get xDB reports using Sitecore Powershell
I am trying to get the Page URL visits which we get from Experience Analytics dashboard using Powershell. Below screenshot specifies the data i am trying to access using Powershell.
I found a link ...
0
votes
1answer
45 views
How to use Receive-ItemCloneNotification in SPE?
I have items that have clone notifications.
Now I want to accept the changes using SPE.
Can someone teach me how to use Receive-ItemCloneNotification? Can't see any articles that explain it. Thanks!...
4
votes
1answer
92 views
Delete all items which names start with “old_”
I want to delete all images under the folder Images and all sub-folders too.
This is what I did
$path ="master:\sitecore\media library\images"
$items = Get-ChildItem -Path $path -Recurse
ForEach ($...
4
votes
2answers
458 views
Using Powershell Extensions to remove empty <p> tags from all rich text fields
I need to remove empty <p> tags from all rich text fields in the content tree:
<p> </p>
I've done nothing myself with Sitecore Powershell Extensions so far, so I am not ...
