Just make sure your Read List and Read Item operation in your ECT have the same fields

Had some fun during the weekend. Customer asked me to add 3 new fields to an existing External Contents Type hosted on a SharePoint 2010 farm. Simple right? SQL Server Modify the pre-production database and alter the table to create 3 new varchar fields Add some dummy content to some records in pre-production farm SharePoint Designer Open the pre-production site collection and locate the External Content Type Open the external content type look at the operations and update the fields including the new ones After saving the changes I proceeded to test, and got an error, the view was not … Continue reading Just make sure your Read List and Read Item operation in your ECT have the same fields

Formulas to get the first and last row on a repeating table in InfoPath

You know, you wake up knowing that is going to be a wonderful day working for a customer with the software products you love. During today on-site support session, you found out that is needed to write some good old XPath formulas on an InfoPath form. There is a repeating table with the columns necessarily to describe travel information like Departure Date, Return Date, City, you named and the requirement was to expose the initial Departure Date and the last Return Date of the entire trip, so, what do we mean with entire trip? I maybe start a trip from … Continue reading Formulas to get the first and last row on a repeating table in InfoPath

SharePoint pushed to its limits

Have you been interested in knowing how intranets get together? Or what practices teams follows in order to design/build/deploy and support an enterprise intranet? I did had the question too, and one of the resources I have been following for a couple of years now is the Nielsen Normal Group Intranet Design Award. This is a competition conducted by the Nielsen Norman Group called annual intranet design to identify the world’s 10 best intranets. In this report you can see very interesting topics that will definitely give a broader idea on what it takes to build and deploy a top … Continue reading SharePoint pushed to its limits