View Complete Post
We have a manual process that we do on a SharePoint list to export data from SharePoint to a spreadsheet that can then be used by non SharePoint programs. I'd like to be able to automate this process so that it can be scheduled as a Task to run on
a daily basis. Not sure if a workflow can do what I'd like it to. I have SharePoint Designer 2007 as well.
Here are the steps:
1. Load a particular View of a SharePoint List
2. From the view's Action menu, "Open with Access"
3. Save the resulting Access database as a file to a specific Folder on the computer hosting SharePoint
This would be run as a Task on the computer hosting SharePoint.
We are having an issue with occasional Tasks being created by a WF that have a blank Assigned to field. Solution consists of:
Unfortunately, although this worked fine during dev and test, now the solution is live and we are having 150-200 requests per day, we are finding that the WF occasionally fails to fill in the Assigned To details when it creates the Task. (approx 8 failures
per 200 requests, ie 4%).
As SharePoint already has the User data field, I am confused why this might fail, and there is no obvious pattern (same auth, 4 work OK then 1 failure).
Does SP contact the AD again when it creates the Task?
Anything else I should investigate? any suggested fix / work-arounds?
I've created a aspx task form, and it's working as planned. However, the window that is popping up when the task form fires is too small, and I would like to set the initial height/width to my own values. How do I override the standard sharepoint
css/style values so that I can control the size of the task window?
I am having a simple OOTB approval worflow associated to the simple document library. Task is created when an document is uploaded to the library. When I click the task item in task list, I see a blank field "Requested By" right below the
"Status" column and I am unable to understand from where this field is coming and how to populate this field. Any help would be great...