Datamine SharePoint Library

I have an InfoPath Library in SharePoint that houses expense forms. I would like to create web parts that will read data from these forms and put them into sharepoint lists (specifically the elements from repeating tables in the forms) that can then be used for reporting, graphs etc. Is there a special method to be able to access the information, or should I just be able to use c# and the SharePoint and xmlreader library to traverse the list and "extract" the data in real time.
nsi07Asked:
Who is Participating?
 
chapmanjwCommented:
Yea, you can use basic XML parsing to read your XML files: http://www.codeproject.com/KB/cs/xml_parsing.aspx
0
 
kukdaiCommented:
i guess if you have published the infopath form to a library then you can get all those data in the library after create a wrokflow and copy the data from the library to a list.
0
 
nsi07Author Commented:
Thanks for the reply.

But then what happens if the item is changed, then the data is invalid. That's why it would need to be in "real-time" not just a copy when the item is created.
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I've requested that this question be deleted for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
nsi07Author Commented:
I object, since there was no answer to the question!
0
 
_alias99Commented:
I've requested that this question be deleted for the following reason:

Deleting per Cleanup recommendation.<br /><br />nsi07, if needed, please repost this as a fresh question.<br /><br />_alias99<br />Community Support Moderator
0
 
chapmanjwCommented:
The best way to accomplish this is with Event Receivers.  Event Receivers are custom .NET events that fire when things happen in SharePoint sites and lists.  For example, you can trigger actions when on ItemAdded and ItemUpdated.  On the ItemAdded event, you could make it write to your tracking list with the details and then write the ID of that new item back to the original list.  Then in the ItemUpdated event, you could make it update the details on the other list based on the ID you received on the ItemAdded event.

Here is a quick guide on creating an Event Receiver in Visual Studio: http://msdn.microsoft.com/en-us/library/ff728093.aspx
Here is some guidance on adding items to a SharePoint list via .NET code: http://msdn.microsoft.com/en-us/library/ms467435.aspx
0
 
chapmanjwCommented:
Also, on another note, when gathering data you need from the form to use when adding to or updating the tracking list, it is simplest if you have the InfoPath data written to SharePoint columns on the library you submit to.  If that is not an option, you can always parse through the XML in C#.
0
 
chapmanjwCommented:
Don't need to delete this question.  My comments should point the user in the right direction and Ill answer any follow up questions as necessary.  Thanks.
0
 
nsi07Author Commented:
Thank-you! I will see what I can do about getting this to work!
0
 
nsi07Author Commented:
I think parsing the XML in real-time might work best here. I assume I can use the C# libraries to do it?

Thanks again for your help!
0
 
Jason C. LevineNo oneCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.