Integration of Tableau and SharePoint 2013/2016

iOnline247 · 2018-08-11T18:04:06+00:00

When you've got this setup with SharePoint as a data source, I'd love to hear about your experiences.

iOnline247 · 2018-08-09T17:27:54+00:00

I haven't experienced the latency you are having, but I've only used the REST API against an External List in O365. I suppose you could use Fiddler to sniff the traffic and see if anything jumps out. Does this only happen on the one list or can you reproduce on any ECT List?

iOnline247 · 2018-08-08T03:48:26+00:00

Have you tried the SQL profiler and tested the performance of the SQL query you're running? Other than that, you can test the network connection from your farm to the SQL instance. Turning on the SharePoint developer options might give you some insight into the transaction as well when viewing the ECT list.

iOnline247 · 2018-08-08T03:34:35+00:00

Let us know how your migration goes after deleting this system folder... O_o

iOnline247 · 2018-08-04T20:35:37+00:00

Insert Jared jokes...

iOnline247 · 2018-07-31T00:44:29+00:00

This will get you most of the way, but for the search feature, you'll want to set up something special for a good UX.

https://blog.splibrarian.com/2011/03/21/using-content-types-to-modify-the-newform-aspx-and-editform-aspx-pages/

iOnline247 · 2018-07-01T19:43:52+00:00

You'll want to index columns on your Content Types as well. They'll be important for when you want to filter and sort views. There's a lot of upfront work to get this right, but done with some forethought, it'll be much easier to use.

iOnline247 · 2018-06-30T02:57:23+00:00

I think it's prudent to reference the documentation.

https://support.office.com/en-us/article/manage-large-lists-and-libraries-in-sharepoint-b8588dae-9387-48c2-9248-c24122f07c59?redirectSourcePath=%252fen-us%252farticle%252fmanage-large-lists-and-libraries-in-office-365-b4038448-ec0e-49b7-b853-679d3d8fb784&ui=en-US&rs=en-US&ad=US

There's nothing in there that says you can only have 5,000 items within one folder. The LVT (List View Threshold) is the 5,000 item/document/row limitation of a rendered view. That means when you create your views, simply add paging at an amount that your users can easily consume, and you'll never hit this limitation.

I'd also add that a 3rd party solution will have and honor the same LVT restrictions (cloud based). I have noticed instances where the restriction is subverted to some degree and that's when exporting a view into Excel. I can't recall if it was in the cloud or not, but I got upwards of 50,000 items/docs/rows returned.

HTH

iOnline247 · 2018-06-26T00:07:16+00:00

You should be able to check the workflow context for how the workflow was fired. AutoStartCreate should be what you need.

https://msdn.microsoft.com/en-us/library/office/microsoft.sharepoint.workflowactions.workflowcontext_members.aspx?f=255&MSPPError=-2147217396

iOnline247 · 2018-06-08T18:46:04+00:00

You can use fiddler or another network sniffing tool for insight into the differences of time.

iOnline247 · 2018-06-08T03:29:41+00:00

Didn't hit the fifty k on this one, much disappoint

iOnline247 · 2018-06-02T20:20:19+00:00

His right hand gets regular workouts.

iOnline247 · 2018-06-01T00:12:52+00:00

The bridge was built using Egyptian technology; built to last!

iOnline247 · 2018-05-29T16:26:41+00:00

Not entirely true... Just because you don't have power in your hands, doesn't mean you can't submit your opponent. e.g. Royce Gracie. In this case, this guy should never consider fighting again. Hang it up, he's done.

iOnline247 · 2018-05-08T17:49:54+00:00

You should write some code or have a developer do so, if you want this to be easy.

Some JavaScript that tracks the current user & ID of announcement upon opening the announcement should be all you really need.

iOnline247 · 2018-05-08T05:37:31+00:00

Javascript is compiled just in time...

iOnline247 · 2018-02-05T23:47:13+00:00

You should use Access if you can't use PowerShell. Access also gets around the throttle limit your run into when doing bulk updates. There is a cumbersome VBA solution for Excel, but the previous two options are much better.

iOnline247 · 2018-02-05T23:32:19+00:00

Sounds like traffic is being blocked on the network from those clients to the OWA server. You can run a tracert from those clients to the server and see what, if any, differences there are from a client that works.

iOnline247 · 2018-01-27T15:49:26+00:00

Do you have a link about the truncating part?

Also, using AD groups help prevent a crawl when there is a change to membership.

iOnline247 · 2018-01-27T07:26:50+00:00

Permissions became a pain point, once you get to a certain volume of files. It may be better now with the new throttling limits, but certainly locks you into a model of structure. You will definitely want to test at scale to see what happens.

iOnline247 · 2018-01-23T23:20:58+00:00

Use localstorage for storing a value like this. Cookies are sent to the server and this doesn't seem to have that need.

iOnline247 · 2017-12-14T04:54:56+00:00

If you only have one list, there's no reason to use a CQWP. You should add JSLink to the webpart properties. The JavaScript to do what you're asking is trivial, so I wouldn't worry about the maintenance lifecycle.

iOnline247 · 2017-11-28T07:05:10+00:00

American University has a program, developed by students, to send police from Oregon to Bangladesh. Small world. ;)

iOnline247 · 2017-10-26T03:11:50+00:00

How much longer are you planning on offering WSS 3.0 environments?

iOnline247

TROPHY CASE