Sharepoint Online: Get List Items from Documents List with over 5000 Items using Powershell

My goal is to create a powershell script that will change the created by value in my Sharepoint online documents list. Fyi this list contains 10005 items.

I’m at the very beggining and already stuck because of this error:

Exception calling “ExecuteQuery” with “0” argument(s): “The attempted operation is
prohibited because it exceeds the list view threshold enforced by the administrator.”

Here is my script:

##Variables for Processing
$SiteUrl = "https://xyz.sharepoint.com/sites/xyz"
$UserName ="user@xyz.com"
$Password ="xyz"
$ListName ="Documents"

#Setup Credentials to connect
$Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName,(ConvertTo-SecureString $Password -AsPlainText -Force))

#Setup the context
$Context = New-Object Microsoft.SharePoint.Client.ClientContext($SiteUrl)
$Context.Credentials = $Credentials

#Get the list (documents)
$Web = $context.Web
$documentsList = $Web.Lists.GetByTitle($ListName)

#Get All List items
$ListItems = $documentsList.GetItems((Microsoft.SharePoint.Client.CamlQuery)::CreateAllItemsQuery()) 
$context.Load($ListItems)
$context.ExecuteQuery()

Write-host "Total Number of List Items found:"$ListItems.count

I want to loop through the list items and change the created by value.

How do you get around the 5000 item limit in this case?

Thank you.

website design – Icon alternative for items per page

I understand that you are trying to reduce the number of text in the page, which is a good thought, however as a best practice try to use the standard UX pattern which is well known and proved to work well. Also, users may interpresent an icon differently according to their content and culture, so it is difficult to design a good icon. I assume the ‘items per page’ is used in your context for data tables. So here I am submitting my idea for icon.

Disclaimer – icon is not tested for your context, you need to test it with the users.

Note – Always provide Alt text description for an icon, so that it will adhere accessibility norms.

If used in a table

If it is used for a table

If it is for document page

enter image description here

electronic items – What type of power outlets should I expect in hotels in Sao Paulo and Rio de Janeiro?

On 2009 the brazilian governament created a new standard that’s different from all other countries in the world:

why did they do it?

This image shows the brazillian standard at the bottom and the number of countries (países, in red) that use each other standard.

That said, it is still very common to find the american standard (second one) and mainly the “universal” plug (last one). Actually the most common is to find a plug using the universal without the ground port, so you’d need an adapter anyway.

Post 2009 buildings are required to use the new standard, while older buildings were not required to change existing plugs, so it doesn’t depend on where you go (São Paulo/Rio or the rest), but when the hotel was created/renovated.

That is such a hassle that every hotel must be prepared to have adapters for their guests, I wouldn’t worry if I my things use the american standard, but I guess I would buy one adapter to the american or universal or brazilian standard if using the other standards.

How to automatize web search for a large number of items?

I have a database of records and I need to know what of them are not represented in a web database. Utilizing the simplest web search engine I would have to enter the records separating them [] OR [] and specify location site:[adress of the web database] to find out what items are represented in the database. To find out what items are not represented in the database I would have to perform a search for each of them individually. Is it possible to automatize these actions? The number of records is about 10 000.

magento2 – How to prevent dropdown menu from closing when moving between top level items?

We’re using a dropdown menu modified from snowdog and magento, and our top level items have 6 options. It’s a pretty standard menu; when hovering over the top level items it drops down and shows the subnav items. However, when moving in between the main items, the menu briefly closes before reopening with the options for the next item. My initial thought was to write some javascript to detect when the menu is already open, and if so, prevent the event from bubbling up the DOM, but I have a feeling the answer is probably more simple than this solution. Maybe using a transition delay to make the hovering more forgiving?

If I were to try adding a transition delay, would this be done in our navigation.less file? I inherited this code base and things are a little messy, so I’m not positive how to start going about this.

select – Magento2: Place order only selected Items from cart

Proceed to place order with single / selected item.

As an end user I have multiple items in my cart, but I would like to proceed with a single item or selected items to checkout and place / create the order.

Once order is placed, coming back to cart rest all item should be available in cart.

Any Extension OR customization for this ?

How to use items from the same custom taxonomy in different roles in a custom post type?

How can I use items from the same custom taxonomy in different roles in a custom post type?

I am developing a genealogy site which includes among other things biographies of ancestors, presentations about ancestors / family history and old letters that the ancestors have sent to each other. To link all this up I have a custom taxonomy ‘Ancestor’ that I use to tag which ancestors are mentioned in which post/page.

To make the letters part more accessible, I have created a custom post type ‘Letter’. Now I would like to assign one ‘Ancestor’ as a ‘sender’ and one as a ‘recipient’ to each ‘letter’.

views – Drupal7 Commerce – Multiple Custom Line Items with single add to cart button

I am working on a system that pulls in available dates and booking references from a third party API – we then need to add these pieces of extra information to a line_item that is added to cart.

I have the custom line item setup by way of

'hook_commerce_line_item_type_info()'

What I would really like to see now is several products (Adult, Child, Concession) – all being available within one form – and a single add to bag button. With the caveat of needing to submit the custom line_item attributes at the same time (these values will be copied over using Javascript after being selected in the UI).

I have made use of commerce_add_to_cart_extras – which provides a view of the products – with a single add to bag – but no notion of being able to add the line_item attributes to the form. Indeed – I’m not even sure that the form processing of this module caters for custom line_item – even if my form_alter code managed to get the syntax of the extra fields correct:

$form_state('rebuild') = TRUE;
        $form('line_item_fields')('#tree') = TRUE;
        //line_item_fields(field_resource_id)(0)
        //line_item_fields(field_resource_id)(und)(0)(value)
        foreach(element_children($form('add_to_cart_quantity')) as $key) {
            //hook_form_FORM_ID_alter
          //  echo ("here: ".print_r($form('add_to_cart_quantity')($key)));                                    
            $form('line_item_fields')($key)('field_resource_id')('und')('0')('value')=array(
                '#type'=>'textfield',                
                '#product_id' => $form('add_to_cart_quantity')($key)('#product_id'),
                '#title'=>t('ResourceID'), 
                '#tree' => TRUE
            );
        }

Has anybody got a solution to how this can be done? We only have one product type – and one custom line item type to consider – and they have a 1:1 mapping.

Hope someone can help here!

electronic items – How to get a 220V European plug into a 220 V wall outlet in Taiwan?

I have to help someone plug a European built electronic device into a 220 Volt wall outlet in Taiwan. Right now they have a cord with a 2 round pin type-C plug.

We’re in northern Taiwan, Hsinchu and Taipei are both easily accessible. Is there any chance that there is a “weird plug store” in northern Taiwan, or some other way we can do this without cutting cables or using an ugly series of adapters? Something that is safe and safety people won’t frown upon? I’ve combed local 3C stores and can’t find anything reasonable.

fyi Taiwan plugs and codes generally look similar if not identical to those in the US.

3C an abbreviation often used in Taiwan for “computer, communication, and consumer electronics”

enter image description here enter image description here

enter image description here enter image description here

dnd 5e – Does the Thief rogue’s Use Magic Device feature let them ignore class, race, and level requirements on attuning to magic items?

The Artificer’s Magic Item Savant feature states (E:RftLW p. 58, WGtE p. 180; emphasis mine):

(…) You ignore all class, race, spell, and level requirements on attuning to or using magic items.

In contrast, the Thief rogue’s Use Magic Device feature merely states:

(…) You ignore all class, race, and level requirements on the use of magic items.

The Use Magic Device feature doesn’t mention ignoring requirements on attuning to magic items, only on using them. It seems like that would mean a Thief rogue can not attune to a magic item if it has a specific requirement on who can attune to it (e.g. the holy avenger).

Does the Use Magic Device feature let a Thief rogue ignore class, race, and level requirements on attuning to magic items?