Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

On our portal (Enterprise 2010) there are about 100 subsites (all in a single site collection), and there are form-libraries there where a user can fill out an infopath form and submit the data to a library on that same subsite.

My problem is that now the boss wants a summary of data from all the submitted forms - from one field in particular. I don't need the data to stay in sharepoint - I just need a spreadsheet summary that I can work with.

How can I get that? Powershell? I have admin rights everywhere.

share|improve this question
add comment

2 Answers 2

You could expose certain InfoPath fields as columns in the SharePoint form library. (These fields can be configured in the form publishing wizard.) Then you could view the libraries as spreadsheets. However, this would only work for forms that have been submitted after the field were exposed.

To get data that has already been submitted, I think you will need to do some programming or at least XML parsing. You have to first extract the underlying XML files, which you could do programmatically, or by grabbing them from the Explorer view or by mapping the library to a drive letter. Then you will need to parse through the XML, either by writing a custom program or PowerShell script, or by using some tool--possibly a Windows grep tool with a regular expression feature--that can extract the field that you need.

share|improve this answer
    
Ah, the forms have already been deployed, and the data I want is NOT exposed as columns (doh!). What about fetching the xml files with powershell? Any clue? –  BGM May 8 '13 at 2:04
    
This would be possible in powershell, though not a fun activity. You need to connect to each file, stream the contents, and extract the entity data you want. –  Mike Oryszak May 8 '13 at 2:52
    
@BGM This might help with pulling the files down in PowerShell: blogs.msdn.com/b/varun_malhotra/archive/2012/02/13/…. This might help with extracting the data: blogs.msdn.com/b/powershell/archive/2008/03/23/…. –  J T May 8 '13 at 12:57
add comment

You might consider using something like InfoPath DB (http://infopathdb.codeplex.com/) which is a codeplex project that can be used to query the raw XML as a datasource as JT mentioned, though without you having to write the actual code. This would make it possible to get the data even if the fields/columns were not previously defined in the SharePoint libraries.

share|improve this answer
    
Interesting! Let my try that out. –  BGM May 8 '13 at 2:50
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.