I am attempting to embed list content into SharePoint pages/wiki pages that is stored on a separate site. I think some of this information might not be relevant, but I am going to include it so that you can get a better picture of what I am trying to achieve. There have been many, many variations of this question asked before, but I can’t seem to find a solution that actually works for my scenario. Most of the solutions I’ve found seem to reference older versions of SharePoint Designer and the options I have been instructed to use either no longer exist or I can’t locate where they’ve been moved to.
I’ve spent the better part of the last year building out an internal resource center and intranet on SharePoint Online as part of our Office 365 subscription. The goal is to create a centralized location for any of our employees to lookup client and customer specific information quickly and easily. We handle financial collection for several different clients and each one has their own procedures and rules on how files are to be handled. The vast majority of this information is programmed into our on-site CRM and is not view-able or accessible to our call center employees. Our CRM exports everything stored in it into a SQL Database in near-real-time and we have this SQL database integrated so that the information we need is made available in several SharePoint lists. The purpose of this is so that our CRM Database administrator only has to update changes dictated by our clients one time in our CRM. Those changes made to the CRM are then pushed out to the SQL database so that the changes are populated in any other applications connected to the SQL database. For example Bank A, “Main Street Bank” instructs us to charge 4.00% interest on an acct. The data rules for “Main Street Bank” are updated in our CRM, and the change to 4.00% is automatically updated in the SharePoint List.
These SQL connected SharePoint lists are stored in a SubSite of our main Resource Center Site on SharePoint to prevent accidental tampering by anyone else in the company that shouldn’t have access to a full dump of our CRM’s SQL database. Under the Resource Center there are subsites for different teams, depts, etc illustrated here. I am building a template page for client specific information and attempting to have those pages pull the content from the lists stored in the SQL Database Site; that way on “Main Street Bank’s” page it will display 4.00% and if they decide to change the interest rate then once it is updated in the CRM, its dumped to SQL, Synchronized with the SharePoint list and updated on the Bank’s page without anyone needing to go and edit that page or any other page that references that information.
I have found article after article and blog post after blog post that make it sound really simple to do this, but I have yet to find a solution that works.
Most solutions instruct to use the Content Query Webpart like in these examples:
- Display List View from Subsite on Parent Site
- SharePoint 2013 – Add List View Web Part to Subsite
I’ve found several instructions that say I should use a Data View Webpart but the buttons are either grayed out or when I can insert the webpart, I can’t edit the code.
I’ve also tried creating the list view webpart that contains the data I want displayed on a page in the SQL Database subsite, then export the webpart and import it into the other subsite but I always get an error that the list doesn’t exist.
- Display List/Web Part on Another Site with SP2013
Lastly, I have investigated using the Cross Site Publishing Feature to turn the SQL Lists into Catalogs, but this appears to require new Site Collections to be created. I can go this route if it’s the best solution, but our Office 365 Administrator isn’t too keen on creating a new Site Collection.
What is the best method to do what I am trying to do and if a resource already exists that has my solution where am I going wrong?
✓ Extra quality
ExtraProxies brings the best proxy quality for you with our private and reliable proxies
✓ Extra anonymity
Top level of anonymity and 100% safe proxies – this is what you get with every proxy package
✓ Extra speed
1,ooo mb/s proxy servers speed – we are way better than others – just enjoy our proxies!
USA proxy location
We offer premium quality USA private proxies – the most essential proxies you can ever want from USA
Our proxies have TOP level of anonymity + Elite quality, so you are always safe and secure with your proxies
Use your proxies as much as you want – we have no limits for data transfer and bandwidth, unlimited usage!
Superb fast proxy servers with 1,000 mb/s speed – sit back and enjoy your lightning fast private proxies!
99,9% servers uptime
Alive and working proxies all the time – we are taking care of our servers so you can use them without any problems
No usage restrictions
You have freedom to use your proxies with every software, browser or website you want without restrictions
Perfect for SEO
We are 100% friendly with all SEO tasks as well as internet marketing – feel the power with our proxies
Buy more proxies and get better price – we offer various proxy packages with great deals and discounts
We are working 24/7 to bring the best proxy experience for you – we are glad to help and assist you!