I know we can export a list into excel, but does anyone know a way to automate this? Or maybe something similar? My end goal is to archive the items from a list into a document of some kind, every month to a library.
Solved! Go to Solution.
I will post up the link again. Try googling Vadim Tabakman list to excel and it will take you to his blog post on this. He provides a video and you can download the UDA he has provided. Let me know if you need anything else.
I used Vadim's workflow to export my sp list to csv. This is really very helpful. Now I have a requirement to filter the rows based on the value of a specific field. Can someone help me with the XSLT for such filter.
I just want those rows that has the contains the word "approved" as the value for a specific column called status. I hope this has to be implemented in the UDA's Query XML Action to transform XML to CSV.
@rencygonzalez .....I'm also trying to use it in 2013 but first to build the chunk for CSV file it's taking too much time. For me it took 25 min or so for just 5 items with 5 columns. And then in web request, I'm geeting an error message i.e. "Error performing web request. The remote server returned an error: (414) REQUEST URI TOO LONG". For creating a CSV in a doc. lib. I'm using "webURL/XYZ/currentdate_currenttime.csv"
Could you please confirm if it's taking this long to build your CSV chunk and also what am I doing wrong in web request action?