The Baretta

Wow that's a long heading...  Let me explain how this is done, and why this path was chosen out of all the options. THE OPTIONS Still to come... SETTING UP There's quite a few large steps to get this done, so I'll split it into the following sections, ensuring we test along the way to make sure we haven't missed a step: Install & Configure Oracle Client on Web Server Create custom Web Service in Visual Studio Deploy Web Service to IIS Build InfoPath Form Configure InfoPath Services Deploy InfoPath Form to SharePoint Environment Install & Configure Oracle Client on Web Server Ask your Oracle DBA what version of Oracle the database is running on. Navigate here and download the corresponding Client (for this excercise get the 32-bit version if its an option):  http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Copy to the IIS Server (Web Front End) Extract and install, here's the settings I used for the i...

Error: "The root of the certificate chain is not a trusted root authority" this blog has a very good explanation of why you are receiving the issue: http://blogs.perficient.com/microsoft/2011/03/how-to-create-an-outlook-appointment-using-nintex-workflow-2010/ However, the solution for adding the correct Root Certificate was a bit sloppy in my opinion.  As the script below adds ALL the certificates (which in my case was about 100 of them, very messy!): foreach ($cert in (Get-ChildItem cert:LocalMachineRoot)) { if (!$cert.HasPrivateKey) {New-SPTrustedRootAuthority -Name $cert.Thumbprint -Certificate $cert } } When you only need to add one.  The one it's referencing.  It should be referencing your Outlook Web Access URL (Webmail).  You know, the URL you input in the Appointment Configuration Settings. If that's the case, here's how to download the right certificate and keep a nice clean Certificate List in SharePoint: navigate to your Webmail address cl...

I was going to build this bad boy, but I decided to buy a road bicycle instead :S You can't have everything!  But I thought I'd throw this list up as a reference of price changes and if anyone else is looking for a build that I've double (triple) checked will definitely fit in the box provided. This kit will fit 1 x 3.5" HDD and 1 x 2.5" HDD very comfortably.  You can fit 2 of each, the problem being that you have to start suffocating the box from air-intake, increasing heat considerably from all reports. $49 - Cooler Master Elite 110 $171 - EVGA 02G-P4-3753-KR G-SYNC Support GeForce GTX 750 Ti Superclocked 2GB 128-Bit GDDR5 PCI Express 3.0 Video Card $129 - Corsair RM 450 $104 - 8G Kit (4Gx2) DDR3 G.skill 2133 $164 - Gigabyte Z97N-WiFi $100-$130 - CPU Cooling $267 -  i5-4690K ------------------- TOTAL: $984-$1014 Prices based off msy.com.au and cpl.com.au on 15/08/2014

Had to look at a few different KB articles for this one so thought I'd throw all the steps together in one quick blog. First you need to create a login, to do this, connect to the master database and run the following query: CREATE LOGIN login1 WITH password='SuperSecretPassword'; Then connect to the Database you wish to give access to, you need to create the user, then supply the access.  Run the following scripts: CREATE USER login1User FROM LOGIN login1; EXEC sp_addrolemember 'db_owner', 'login1User';

PURPOSE Ever wondered what sort of SQL data connections are possible in SharePoint Online? Ever wondered of the limitations when trying this type of setup? If so, read on...  This tutorial will go over all the steps to setup everything from scratch.  Every step is important, you miss one, it won't work. WHAT YOU NEED SharePoint Online Plan 2 (you cannot achieve this with the basic version of SharePoint online as you require access to the Admin panel to setup Secure Store access permissions and BCS permissions. A windows azure account (which you can get a free 30 day trial as long as you're willing to provide your credit card. SharePoint Designer 2013 installed locally (required to create the final connection to the azure DB. Please note, you'll make this a hell of a lot easier if all these accounts are setup using the same office logon.  Otherwise you'll be logging in and out like a madman. IMPLEMENTATION Step 1 - Create SQL Database:   ...

Ever had this issue on SharePoint Online? "This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator."  "To view items, try selecting another view or creating a new view. If you do not have sufficient permissions to create views for this list, ask your administrator to modify the view so that it conforms to the list view threshold." Well I have, and it sucks. My particular issue was that someone had uploaded 120,000 files to a document library, which they then wanted to add metadata to, however, being a bulk upload, they weren't adding it as they were going, so in turn, any sorting/filtering of such a large bank of files let to the famous error above. Of course you can't bypass the LVT (list view threshold), but as we all (should!) know, is that once you have added metadata, you can do things to avoid it. My solution to this issue is not quick, but it worked.  I created a view showing only...

This is a follow up to my previous post on the perfect responsive ecommerce solution, which you can find here:  http://thebaretta.blogspot.com.au/2014/06/the-perfect-responsive-free-ecommerce.html You can add the Code below to fix up any slight issues that I've found in the Responsive Solution from the previous post. Fixes include: Shopping Cart goes off the screen on Mobile Add padding around Website Logo Products span full width of site instead of being limited by the standard code. ------------------------------------------------ /* CUSTOM CODE */ mark { background-color: transparent; font-weight: bold;} /* START Make the cart table responsive */ /* http://css-tricks.com/responsive-data-tables/ */ @media only screen and (max-width: 480px) { /* Force table to not be like tables anymore */ .woocommerce-page table.shop_table, .woocommerce-page table.shop_table thead, .woocommerce-page table.shop_table tbody, .woocommerce-page table.shop_table th, .woo...