none
List of Views RRS feed

  • Question

  • Hi

    This may seem like a dumb questions but....

    I have 4 (similar) lists and there are several views associated with each list. I want to be able to 'download' the list names for each list (maybe into excel) so that I can do an comparison  across the 4 lists and standardizes them.

    Is it possible to download the list names into a document - I can't see any way to do this.

    thanks,

    Peter

    Monday, April 3, 2017 2:23 PM

Answers

  • I don't think you will be able to do it without any custom code.

    You can use a combination of CSOM and PowerShell or .Net (C#) whichever you feel more comfortable to get the list names and view names with potentially all the columns to a csv or excel file.

    • Marked as answer by py1 Friday, April 7, 2017 7:49 AM
    Monday, April 3, 2017 3:53 PM
  • Hi,

    You can utilize Client Site Object Model by writing server side or client side code to export list content into excel sheet.


    Thanks, Amit Kumar, LinkedIn Profile ** My Blog

    • Marked as answer by py1 Friday, April 7, 2017 7:49 AM
    Friday, April 7, 2017 7:29 AM
  • If you are to SP , I highly recommend you to familiarise yourself with PnP.

    If you are comfortable with PowerShell refer to 

    https://github.com/SharePoint/PnP-PowerShell

    They provide useful cmdlets

    ##connect to SP instance

    $Admin  = Get-Credential -Message "Enter Administrator Credentials"
    Connect-PnPOnline -Url https://<tenant>-admin.sharepoint.com -Credentials $Admin 

    ##Get all views from list

    Get-PnPView -List "Demo List"  

    Otherwise you can refer to https://github.com/SharePoint/PnP-Sites-Core/tree/master/Core for .Net (C#)

    • Marked as answer by py1 Friday, April 7, 2017 8:55 AM
    Friday, April 7, 2017 8:51 AM

All replies

  • I don't think you will be able to do it without any custom code.

    You can use a combination of CSOM and PowerShell or .Net (C#) whichever you feel more comfortable to get the list names and view names with potentially all the columns to a csv or excel file.

    • Marked as answer by py1 Friday, April 7, 2017 7:49 AM
    Monday, April 3, 2017 3:53 PM
  • Hi,

    You can utilize Client Site Object Model by writing server side or client side code to export list content into excel sheet.


    Thanks, Amit Kumar, LinkedIn Profile ** My Blog

    • Marked as answer by py1 Friday, April 7, 2017 7:49 AM
    Friday, April 7, 2017 7:29 AM
  • Hi

    Thanks for you response. Can you please give me a pointer to CSOM - I am relatively new to SP so don't much about this area.

    thanks

    Peter

    Friday, April 7, 2017 7:49 AM
  • If you are to SP , I highly recommend you to familiarise yourself with PnP.

    If you are comfortable with PowerShell refer to 

    https://github.com/SharePoint/PnP-PowerShell

    They provide useful cmdlets

    ##connect to SP instance

    $Admin  = Get-Credential -Message "Enter Administrator Credentials"
    Connect-PnPOnline -Url https://<tenant>-admin.sharepoint.com -Credentials $Admin 

    ##Get all views from list

    Get-PnPView -List "Demo List"  

    Otherwise you can refer to https://github.com/SharePoint/PnP-Sites-Core/tree/master/Core for .Net (C#)

    • Marked as answer by py1 Friday, April 7, 2017 8:55 AM
    Friday, April 7, 2017 8:51 AM
  • thanks for the pointers

    Friday, April 7, 2017 8:55 AM