locked
Generate List of URLs RRS feed

  • Question

  • Hi guys,

    I am interesting to know how to create a list of all files in particular directory and export list into CSV or Excel file. Anyone knows to do it.It’s SharePoint Server 2007.

    Thanks,

    Nuttakorn

    • Edited by Nuttakorn Wednesday, June 8, 2011 3:00 PM Add Version of Sharepoint
    Tuesday, June 7, 2011 3:46 AM

Answers

  • Shouldn't be too hard.

    1. Map the document library to a drive
    2. Navigate to this drive with a command prompt
    3. Use this command ls -l to generate the properties and this command to output this into a line by line text file dir /b > print.txt
    4. Copy that info into Excel and manipulate as needed I

    Or just use DataSheet view and copy and paste that info into new excel sheet.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Thursday, June 23, 2011 11:25 AM
    Answerer

All replies

  • Hi Nuttakorn,

    Can you provide more details about your requirement? Do you want to create a document library to store the files and export the list in to CSV?


    --Cheers
    Thursday, June 23, 2011 6:25 AM
  • Shouldn't be too hard.

    1. Map the document library to a drive
    2. Navigate to this drive with a command prompt
    3. Use this command ls -l to generate the properties and this command to output this into a line by line text file dir /b > print.txt
    4. Copy that info into Excel and manipulate as needed I

    Or just use DataSheet view and copy and paste that info into new excel sheet.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Thursday, June 23, 2011 11:25 AM
    Answerer
  • Thanks a lot for this.
    Tuesday, June 28, 2011 7:44 AM