Hello SharePointCommunity,
we have started our SharePoint Project some weeks ago and unfortunately now we’ve got stuck.
We are using SharePoint Online 2013 (directly hosted by Microsoft) and we have synchronized all of our Active Directory Users. At the moment we are using SharePoint only to upload some Excel File which can be accessed by all of our users (no Special permission).
But now we want to start some more complex Tasks and although I have watched a lot of Videos and read Best Practice Examples from Microsoft and within Blogs I got completely stuck – which is of course a bit frustrating (when you want to conquer the SharePoint World). 😉
I think the Task itself is quite common one and basically simple:
I want to show a customer-list to our field workers.
I get the List from within SQL and it has > 50.000 Entries
I have found quite useful Information that there will be a Problem when you want to synchronize more that 5.000 Elements to a List without generating some Views in Advance…
http://support.microsoft.com/kb/2759051/en-us
http://office.microsoft.com/en-us/sharepoint-help/manage-lists-and-libraries-with-many-items-HA102771361.aspx
We are using a 3rd Party-Tool to snychronize our Data from within SQL to SharePoint 2013 – we have tested this with some entries and it works quite fine.
http://www.layer2.de/en/products/Pages/Cloud-Connector-for-SharePoint-2010-Office365.aspx
But now here are my questions:
The fieldworkers use their email-adress to Login to SharePoint.
At the moment there is not an email-adress from the different field-workers within the customer-list (SQL).
There is a field containing a “field-worker-no” for example 001 or 057 and so on…
I want the field-workers just to see “their own” customers when they Login.
Can I do this without programming? Do I have to add the Email-Adress within SQL? Can i solve this using a variable for each fieldworker within SharePoint? If so where can I do this?
Do i have to generate Lists manually für each field-worker (this would be a lot of work for different lists, because there are quite a lot of them…)
I hope you can help me with some useful hints concerning my question.
Kind regards from Austria
Oliver
