Migrating a custom list with attachments from SharePoint 2007 to SharePoint 2013

There is a workaround I found and used to migrate a custom list with attachments from SharePoint 2007 to SharePoint 2013.

Below are steps:
1. Use Access 2010 to import the SharePoint 2007 list into a database
2. From Access 2010 export to the SharePoint 2013 site

When I first exported it, it was read-only (That was issue). So, I had to do it again (import then export) but make sure the database in access was not read only. It worked very well after that. I got all attachments. 

Completed Salem™ Certified Practitioner Online Course

Hi All

Yay, I’m very happy as I've successfully completed Genius SharePoint Business Strategist course http://thesharepointstrategist.com/about-us/ which qualified me as certified Salem™ Practitioner.

Salem™ is framework which can be used in any business for SharePoint as a solution.

Salem™ (Sequenced and Logical Enterprise Methodology) – course contains 15 different modules which are connected and are very useful to applied to any business : http://geniuscourses.litmos.com/online-courses/register/25684

Here are some of features of this online course:

·         Available online – which is very flexible for anyone.

·         Course materials are so much in detail and concise for each sections which are understandable

·         Videos and slides are nice explained with real life example

·         Length of this course is suitable

After completing this course you must know how business should use SharePoint and what parameters needs to be considered when it comes to apply SharePoint in real life!

I enjoyed this course and recommend taking the same course to improve SharePoint knowledge!

Disha Shah

Get and set BDC Column Value via Javascript

Hi All

We already know very well reagarding "getTagFromIdentifierAndTitle" function in SharePoint which is very useful to set and get the value of TextBox, DataField, Dropdown and many more to set and get the values from control. But what about if your list contains BDC Column value. How to set  and get the value from BDC Column?

Here is the jascript to achieve set and get the BDC column Value.

<script type='text/javascript'>
//set default value
_spBodyOnLoadFunctionNames.push("loadandhideBDC");
function loadandhideBDC()
{
setDefault();
}

//To check it contains value before saving
 function PreSaveAction() {
var elem = getBDCTagFromIdentifierAndTitle("TEXTAREA","Object Picker", 1);
if(elem.value =="")
{
 alert( "Invalid Value");
 return false;
}
}

function getBDCTagFromIdentifierAndTitle(tagName, title, count) {
var tags = document.getElementsByTagName(tagName);
var myCount = 0;
for (var i=0; i < tags.length; i++) {
var tempString = tags[i].id;
if (tags[i].title == title){
myCount++;
if(count == myCount){
return tags[i];
}
}
}
return null;
}


function setDefault() {
var variety = "";
var elem = getBDCTagFromIdentifierAndTitle("TEXTAREA","Object Picker", 1);
if(elem) elem.value = variety;
var elem = getBDCTagFromIdentifierAndTitle("DIV","Object Picker", 1);
if(elem) elem.innerText = variety;
}
</script>

Disha Shah