Migrating SP list from one site to another in SP2010

Lately I've been assigned to create a new team SharePoint. This is a totally new exercise for me and I need to do a lot of research in the net.

Today I would liek to share with you all on how to migrate a customed list from a site to another new site in SharePoint 2010.

Migrating SP list from one site to another

Method 1: Export in excel file

1. Export the list you want to migrate in excel file.
2. Save the file in your local drive
3. Open the save file, create a table for the list and save change.
4. Go the new site, click on site actions>more options>create list> import spreadsheet
5. Click create.
6. Key in your list name, description and browse the excel file you want to import.

Pro:

• You are able to delete unwanted columns
• As long as you have the designer access right

Con:

• File maybe big and time consuming
• More steps
• You will have to reconfigure the column settings

Method 2: Import as List Template .stp

1. Choose the list you want to migrate.
2. Go list setting> Save as template. Remember to check "include content"
3. Now this .stp file is available in List Template Gallery (parent site)
4. Save the template in your local drive.
5. Go to your new parent site.
6. Site actions> Site Settings> Galleries> List Templates
7. Import the . stp file you have just save in your local drive.
8. Now this template is available for all your sites(parent and sub-sites)
9. Go to the site you want to import the list.
10. Site actions> More options> Create list
11. Choose the template you havs just save in the list templates. Click create
12. Viola. Now you have your list ready for action.
13. You will loose all the lookup features and need to link that back as you import the rest of the related list.

Pro:

• Straight forward and quickest way
• Retain most of the lsit column's features

Con:

• You must be the site admin in order to perform the import

Happy trying!

Hotel Review: Ecotel Bangkok

After several attempts booking via PYOtravel, at last we get our room booked and paid for. Here we come Ecotel Bangkok!

Overall I think this is a good choice of hotel. It is situated opposite Ramada & Bangkok Palace. So once you take a taxi from Don Mueng, just tell the taxi you want to go to Bangkok Palace or you may end up like us. Our taxi despite of the map provided by the hotel was not able to find Petchaburi Rd 35. If I have told him earlier that thsi hotel is opposite Bangkok Palace, I'm sure all of us do not have to go round and round in Pratunam area and having Bryan started crying in the taxi as he was too tired after the long trip.

Summary of the hotel:

1. We pay RM600 for 2 rooms for 3 nights stay (without breakfast as you can get a lot food nearby)
2. We get spacious room, toiletries and towels are provided, comfortable pillows and beds.
3. Nearest 7-eleven is just 100m away :) Plenty of taxi and Tuk Tuk.
4. Taxi ride to airport using express way is around THB 250
5. Just beware of the tourists from India. They tend to make a lot of noise even as early as 3am :(
6. It took us 15 min walk to Platinum Mall
7. Strongly recommend to try the Pork Noodle and Beef Noodle along the road to Indra Square. The uncle has been selling for so many years and his beef noodles is so tasty :)

Last note, since there are 4 adults + 1 toddler, we travel around Bangkok via taxi most of the time. It's so convenient and trust me, Bangkok taxi is so affordable and spacious. I think the furthest taxi ride we took was to go to Asiatique RiverFront. This is another new place in Bangkok and a smaller version and more organized Chatuchak!