Přihlásit
 
HlavníKnihovnaCertifikaceDownloadPodporaKomunitaFóra
Zdroje informací pro profesionály v oboru IT >
> 
> 
Column Missing in Exported List in Datasheet.

คำตอบ Column Missing in Exported List in Datasheet.

  • 13. února 2012 9:31
     
     
    Přihlásit se a hlasovat
    0

    Hi,

    I have a SharePoint Wiki Library in my Site.

    Its default View is All Item
     Visible Columns
       - Type
       - Name
       - Modified By
       - Modified
       - Created By
       - Created
       - Group (Custom Column)

    Then I exported it to Spreadsheet (Action>Export to SpreadSheet).
    But in the Exported File (.iqy) Column Modified is missing.
    Then I use a different view that also shows Modified Column then Export it to Spreadsheet. I got the same result, no Modified Column in the exported file.
    I also check the DataSheet view, Modified Column is not available even if the Column

    Can anyone please explain why Modified Column is not included in the Spreadsheet... Does it got something to do with the Modified Column being not editable by the user?

    And how can I add Modified Column in the Spreadsheet.

    Thank you very much... ^_^

    • Přesunutý Mike Walsh FIN 13. února 2012 9:36 Nothing to do with programming. Also as a Wiki q it goes to Social Computing (From:SharePoint - Development and Programming (pre-SharePoint 2010))
    •  
     

Všechny reakce

  • 15. února 2012 3:39
    Moderátor
     
     Odpovědět
    Přihlásit se a hlasovat
    0

    Hi Check'on'it,

    You can create a Calculated column to equal Modified column in your Wiki Library, then you can export this wiki library to Spreadsheet (.iqy) using "Export to SpreadSheet", then you can find both the Modified and Calculated columns there.

    Thanks

    Daniel Yang

    TechNet Community Support

     
  • 15. února 2012 6:58
     
     
    Přihlásit se a hlasovat
    0

    Yup! did it...
    works for a while...

    But when the crawl starts the value in the calculated column.. was not equal to Modified Column..

    I'm thinking of doing it via custom code...
    I'll create an event handler that will set the value of a single line of text column upon Edit(Updated) and adding (Added).

    But how can I hide the column on wiki library?
    I used to hide column in Document Library by Content type but wiki library doesn't have that... can you please give me an idea on how to hide a Column in Wiki Library.

     
  • 16. února 2012 3:36
    Moderátor
     
     Odpovědět
    Přihlásit se a hlasovat
    0

    Hi Check'on'it,

    If you only want to get the Modified column value, you can also use Workflow (e.g. Update List Item) to copy value to a new column and export to SpreadSheet.

    If you didn't want to display the custom columns in all wiki pages, you can modify the wkpstd.aspx under 12 Hive (also affect all wiki libraries), you MUST backup the original wkpstd.aspx file before modification, refer to details,

    http://philwicklund.com/Lists/Posts/Post.aspx?ID=59

    Or some other ways (e.g. program, powershell, etc.) mentioned in below article,

    http://solutionizing.net/2008/12/29/hiding-wiki-library-custom-columns/

    Thanks

    Daniel Yang

    TechNet Community Support