We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Datamine SharePoint Library

Medium Priority
683 Views
Last Modified: 2012-05-11
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.
Comment
Watch Question

Uttam (Kukdai) DhakalSharePoint SME
CERTIFIED EXPERT

Commented:
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.

Author

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.
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
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.

Author

Commented:
I object, since there was no answer to the question!

Commented:
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
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
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#.
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.

Author

Commented:
Thank-you! I will see what I can do about getting this to work!

Author

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!
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Jason C. LevineDon't talk to me.
CERTIFIED EXPERT

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.